Unable to create Availablity Report spreadsheet - FIXED

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?