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
-------------------------------------------------------
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
