[hobbit] Unable to create Availablity Report spreadsheet - FIXED

[Brand, Thomas R.]

The bbrep error message was pointing to permissions, and at one point, I had opened perms fully (777) all the way down the path to the rep directory.

I resolved this last night after reviewing changes I had made last week.

The problem was due to a silly change I had made to the BBGENOPTS= definition in hobbitserver.cfg. 

I had added MKBB2COLREPEAT=20 to BBGENOPTS="..."; I don't remember where I saw this described, but it appeared to work -- my bb2.html and subpages showed a column header row every 20 lines.

Upon further review, I finally noticed that this should be set up simply as a variable definition on new line, not included in BBGENOPTS. Once I fixed this, I was able to create the spreadsheet reports again.

The 'check permissions' error message out of bbrep had me searching in the wrong direction for a while -- perhaps that's the error bbrep generates anytime it cannot create the output file.

Thank you for you suggestions
Tom


-----Original Message-----
From: wiskbroom at hotmail.com [mailto:wiskbroom at hotmail.com] 
Sent: Friday, February 05, 2010 11:18 AM
To: hobbit at hswn.dk
Subject: RE: [hobbit] Unable to create Availablity Report spreadsheet.


Have you resolved this yet?  Looks like your perms for rep are not set properly:

drwxrwx--x 8 xymon www 4096 Jan 28 18:10
/cvsrx/home/xymon/server/www/rep/


Try running chmod 777 /cvsrx/home/xymon/server/www/rep/ and retry gen'ing a report.

If this works, then you need to make sure that the group perms are setup to allow the apache owner permission to rw, then you can re-chmod back to 775, better than 771, what you have.

.vadim

>
> Hi all...
>
>
>
>
>
>
>
> I'm having a problem generating a 'spreadsheet'
> availability report (Reports | Availability Report ) with the Xymon 4.3.0-0.beta2
> server and could use some help/suggestions as to where to look next.
> These reports were working as late as two weeks ago; I can't think of
> anything that I've changed in the environment that should affect the
> report generation.
>
>
>
>
>
>
>
> bbgen for Hobbit version 4.3.0-0.beta2
>
> Statistics:
>
> Hosts : 3015
>
>
>
>
>
>
>
>
>
>
>
> All other reports appear to be working fine.
> If I select the 'Generate Report' button, my report gets created and
> displays and the files are created in the www/rep/ directory
>
>
>
>
>
>
>
> When selecting 'Generate Spreadsheet',
> the result is:
>
>
> Generating report for the period: Jan 27 2010 - Jan 27 2010
> (nongr)
>
>
>
> --bbrep-7740-126471984 Content-type: text/html
> Could not generate report.
>
> Check that the /home/xymon/server/www/rep/ directory has permissions
> '-rwxrwxr-x' (775)
>
> and that is is set to group 8
>
>
>
>
>
>
>
> I have checked the ownership and permissions of the
> directory tree and all seems ok...
>
>
>
> # ls -l /home
>
>
>
> lrwxrwxrwx 1 root root 11 Jul 22 2008 /home
> -> /cvsrx/home/
>
>
>
> # l -d /cvsrx
>
>
>
> lrwxrwxrwx 1 root root 15 Jan 19 10:23 /cvsrx ->
> /data/cvsrx_dev/
>
>
>
> # l -d /cvsrx/home/
>
>
>
> drwxr-xr-x 32 root root 4096 Dec 7 11:25
> /cvsrx/home//
>
>
>
> # l -d /cvsrx/home
>
>
>
> drwxr-xr-x 32 root root 4096 Dec 7 11:25
> /cvsrx/home/
>
>
>
> # l -d /cvsrx/home/xymon/
>
>
>
> drwxr-xr-x 11 xymon hobbit 4096 Jan 8 14:36
> /cvsrx/home/xymon//
>
>
>
> # l -d /cvsrx/home/xymon/server/
>
>
>
> drwxr-xr-x 9 xymon hobbit 4096 Dec 7 11:40
> /cvsrx/home/xymon/server//
>
>
>
> # l -d /cvsrx/home/xymon/server/www/
>
>
>
> drwxr-x--- 16 xymon www 4096 Jan 28 18:12
> /cvsrx/home/xymon/server/www//
>
>
>
> # l -d /cvsrx/home/xymon/server/www/rep/
>
>
>
> drwxrwx--x 8 xymon www 4096 Jan 28 18:10
> /cvsrx/home/xymon/server/www/rep//
>
>
>
>
>
>
>
>
>
>
>
> # l /cvsrx/home/xymon/server/www/rep/
>
>
>
> total 28
>
>
>
> drwxr-xr-x 7 wwwrun www 4096 Jan 28 18:01
> 6916-1264719548/
>
>
>
> drwxr-xr-x 7 wwwrun www 4096 Jan 28 18:03
> 7703-1264719824/
>
>
>
> -rw-r--r-- 1 wwwrun www 2109 Jan 28 18:04
> avail-s09trbrxs-memory-1264719841-7737.txt
>
>
>
>
>
>
>
>
>
>
>
> I added '--debug' to bb-rep.cgi:
>
>
>
> exec /home/xymon/server/bin/bb-rep.cgi $CGI_REP_OPTS
> $BBGENREPOPTS --debug>/tmp/bbrep.debug 2>&1
>
>
>
>
>
>
>
> and got a large output file. At the very end
> of the file, it appears that the program simply stopped as the the output in the
> debug log just stops:
>
>
>
>
>
>
>
>
>
>
>
>
> Host: s09996rxs, ip: 172.19.227.11, name: s09996rxs, color: 4, old: 0, anywaps:
> 0, wapcolor: -1, pretitle: '(NULL)', noprop-y: (NULL), noprop-r: (NULL),
> noprop-p: (NULL), noprop-ack: (NULL), waps
>
>
>
>
> Test: OfflineDB, alert 0, propagate 1, state 4, age: , oldage: 0
>
>
>
>
> Test: nfs, alert 0, propagate 1, state 0, age: , oldage: 0
>
>
>
>
> Test: mysql, alert 0, propagate 1, state 0, age: , oldage: 0
>
>
>
>
> Test: cpu, alert 0, propagate 1, state 0, age: , oldage: 0
>
>
>
>
> Test: disk, alert 0, propagate 1, state 0, age: , oldage: 0
>
>
>
>
> Test: procs, alert 0, propagate 1, state 4, age: , oldage: 0
>
>
>
>
> Test: ports, alert 0, propagate 1, state 4, age: , oldage: 0
>
>
>
>
> Test: msgs, alert 0, propagate 1, state 0, age: , oldage: 0
>
>
>
>
> Test: files, alert 0, propagate 1, state 0, age: , oldage: 0
>
>
>
>
> Test: memory, alert 0, propagate 1, state 0, age: , oldage: 0
>
>
>
>
> Test: conn, alert 0, propagate 1, state 0, age: , oldage: 0
>
>
>
>
>
>
>
>
>
>
>
>
> Host s09996rxs is the last host listed in my
> bb-hosts file.
>
>
>
>
>
>
>
> Any suggestions?
>
>
>
>
>
>
>
>

 		 	   		  
To unsubscribe from the hobbit list, send an e-mail to
hobbit-unsubscribe at hswn.dk