Unable to create Availablity Report spreadsheet.
list Thomas R. Brand
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:
<data ...>
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
<EOF>
Host s09996rxs is the last host listed in my bb-hosts file.
Any suggestions?
Thomas Brand | CVS Caremark |Rx Systems Admin|Office: XXX-XXX-XXXX |X
CVS Drive, Woonsocket, RI XXXXX Mail Stop 34040C | user-10a840458972@xymon.invalid
Disclaimer: 1) all opinions are my own, 2) I may be completely wrong, 3)
my advice is worth at least as much as what you are paying for it, or
your money cheerfully refunded.
CONFIDENTIALITY NOTICE: This communication and any attachments may
contain confidential and/or privileged information for the use of the
designated recipients named above. If you are not the intended
recipient, you are hereby notified that you have received this
communication in error and that any review, disclosure, dissemination,
distribution or copying of it or its contents is prohibited. If you
have received this communication in error, please notify the sender
immediately by telephone and destroy all copies of this communication
and any attachments.
list Wiskbroom
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?
list Thomas R. Brand
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: user-ddebaeecde97@xymon.invalid [mailto:user-ddebaeecde97@xymon.invalid]
Sent: Friday, February 05, 2010 11:18 AM
To: user-ae9b8668bcde@xymon.invalid
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?