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
