Re: [jffnms-users] Flat rrd

2005-02-02 Thread Javier Szyszlican
;5,4" Are you mean hosts.id in (5,4) ? Min -Original Message- From: Javier Szyszlican [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 1:01 PM Cc: jffnms-users@lists.sourceforge.net Subject: Re: [jffnms-users] Flat rrd No, You were right the first time, the SQL is failing.

Re: [jffnms-users] Flat rrd

2005-02-02 Thread Javier Szyszlican
6:00 PM To: jffnms-users@lists.sourceforge.net Subject: [jffnms-users] Flat rrd I got flat rrd graphs since -pre3. My backend db is pgsql (don't know if any rrd configuration info be querried correctly). The rrd data files did not updated since change to -pre3. ps -ef indicated two rrdtool

RE: [jffnms-users] Flat rrd

2005-02-01 Thread Min Qiu
ERROR: invalid input syntax for integer: "5,4" Are you mean hosts.id in (5,4) ? Min -Original Message- From: Javier Szyszlican [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 1:01 PM Cc: jffnms-users@lists.sourceforge.net Subject: Re: [jffnms-users] Flat rrd No,

Re: [jffnms-users] Flat rrd

2005-02-01 Thread Javier Szyszlican
ot;:""). "\n\t GROUP BY hosts.id"; Min -Original Message- From: Javier Szyszlican [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 7:07 AM Cc: jffnms-users@lists.sourceforge.net Subject: Re: [jffnms-users] Flat rrd You did it ok, But that SQL is not corr

RE: [jffnms-users] Flat rrd

2005-02-01 Thread Min Qiu
L PROTECTED] Sent: Tuesday, February 01, 2005 7:07 AM Cc: jffnms-users@lists.sourceforge.net Subject: Re: [jffnms-users] Flat rrd You did it ok, But that SQL is not correct in PgSQL. Let me fix it and send you a patch. Javier Min Qiu wrote: > Tried to similate the sql in poller2.php > &g

Re: [jffnms-users] Flat rrd

2005-02-01 Thread Javier Szyszlican
PM To: jffnms-users@lists.sourceforge.net Subject: [jffnms-users] Flat rrd I got flat rrd graphs since -pre3. My backend db is pgsql (don't know if any rrd configuration info be querried correctly). The rrd data files did not updated since change to -pre3. ps -ef indicated two rrdtool processes is runn

RE: [jffnms-users] Flat rrd

2005-01-31 Thread Min Qiu
ear in the GROUP BY clause or be used in an aggregate function What I did wrong in above SQL? Min -Original Message- From: Min Qiu Sent: Monday, January 31, 2005 6:00 PM To: jffnms-users@lists.sourceforge.net Subject: [jffnms-users] Flat rrd I got flat rrd graphs since -pre3. My

[jffnms-users] Flat rrd

2005-01-31 Thread Min Qiu
I got flat rrd graphs since -pre3. My backend db is pgsql (don't know if any rrd configuration info be querried correctly). The rrd data files did not updated since change to -pre3. ps -ef indicated two rrdtool processes is running. Where should I dig more cludes? Thanks, Min --