Hi Min,
What PostgreSQL version do you have?
I'm running dev-db/postgresql-7.4.6 and it works fine.
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
