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