Regarding the last error, it was a bug, I've fixed it already.
Please download the current devel and replace the poller2.php file.
Also you should run the poller2 as php -q poller2.php master N where N is the number of threads.
Javier
Min Qiu wrote:
Javier,
It was not this SQL, it is the db_update() later try to update the
tables when the poll finished.
14:44:34 mqiu:
SELECT hosts.id, count(interfaces.id) as cant_interfaces
FROM hosts, interfaces
WHERE hosts.id > 1 and hosts.poll = 1 and interfaces.id > 1
and
interfaces.poll > 1 and interfaces.host = hosts.id and
((hosts.last_poll_date + hosts.poll_interval - (hosts.last_poll_time/2))
< 1107287074)
GROUP BY hosts.id
Executing: /usr/bin/php -q poller2.php 5,4 0 0 0 &
14:44:35 : H 5,4 : Poller Start : 93 Items.
14:44:35 : H 4 : I 13 : P 1 : reachability_start:ping():
41ffdc2332f8b ...
14:44:56 db_ping(pg) Connection to DB Restored... Query failed - db_update(hosts) - Update hosts set last_poll_date = '1107287091',last_poll_time = '17' where hosts.id = '5,4' - 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: [email protected]
Subject: Re: [jffnms-users] Flat rrd
No,
You were right the first time, the SQL is failing.
I'm going to try again with PgSQL on my side.
Thanks, Javier
Min Qiu wrote:
I failed to copy the entire SQL statement and give you the wrong impression. However, I recalled lasttime we had the similar problem with inserting time() directly to pgsql.
I comment it out in poller2.php and the rrdtool runs again:
function hosts_random_list($interval = false) { //FIXME Add Satellite
$query_hosts="
SELECT hosts.id, count(interfaces.id) as cant_interfaces
FROM hosts, interfaces
WHERE hosts.id > 1 and hosts.poll = 1 and interfaces.id > 1 and
interfaces.poll > 1 and interfaces.host = hosts.id".
====>// (($interval)?" and ((hosts.last_poll_date +
hosts.poll_interval
- (hosts.last_poll_time/2)) < ".time().")":"").
"\n\t GROUP BY hosts.id";
Min
-----Original Message----- From: Javier Szyszlican [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 7:07 AM Cc: [email protected] 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
select hosts.id, count(interfaces.id) as cant_interfaces
from hosts, interfaces
where hosts.id > 1 and hosts.poll=1 and
interfaces.id >1 and interfaces.poll >1 and interfaces.host= hosts.id
ERROR: column "hosts.id" must appear 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: [email protected] 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 running. Where should I dig more cludes?
Thanks,
Min
-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports.
Save time by over 75%! Publish reports on the web. Export to DOC, XLS,
RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ jffnms-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jffnms-users
-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports.
Save time by over 75%! Publish reports on the web. Export to DOC, XLS,
RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ jffnms-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jffnms-users
-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Javier Szyszlican, Project Leader, JFFNMS [EMAIL PROTECTED]
I hope JFFNMS or I were helpful to you, if you can, please donate at http://jffnms.org/donate
-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS,
RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ jffnms-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jffnms-users
-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Javier Szyszlican, Project Leader, JFFNMS [EMAIL PROTECTED]
I hope JFFNMS or I were helpful to you, if you can, please donate at http://jffnms.org/donate
------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ jffnms-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jffnms-users
-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Javier Szyszlican, Project Leader, JFFNMS [EMAIL PROTECTED]
I hope JFFNMS or I were helpful to you, if you can, please donate at http://jffnms.org/donate
------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ jffnms-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jffnms-users
