Graph Error

view rules in triggers configuraton

Re: 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: jffnms-users@...
> 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
> jffnms-users@...
> 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
> jffnms-users@...
> https://lists.sourceforge.net/lists/listinfo/jffnms-users

--

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Javier Szyszlican, Project Leader, JFFNMS
javier@...

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

Re: Graph Error

The Graph appears but its empty?

Thats only caused by your poller task not running correctly, or a permission 
problem.

Javier

Jared Hamilton wrote:
> Hi all,
> 
>  
> 
> I have everything setup.  My scheduled tasks are running and I have 
> graphs showing up for all interfaces but there is not data being 
> recorded.  Now the color indicators do display the current settings but 
> it does not display the counters on the graph.  Any advice?
> 

--

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Javier Szyszlican, Project Leader, JFFNMS
javier@...

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

Re: view rules in triggers configuraton

I've not finished the GUI conversion on that page yet.

Sorry.
Javier

sander.paauwe@... wrote:
> 
> Hi,
> 
> I have a problem when I try to configure my triggers.
> 
> The following error occurs:
> 
> *Fatal error*: Call to undefined function: std_table_row() in 
> */opt/jffnms/htdocs/admin/adm/adm_triggers_rules.php* on line *44*
> 
> What does that mean, is there someting wrong with my versions or is it 
> the pre3 release ?
> 
> Thanks&
> *Regards*,
> Sander Paauwe
>  <at> Mail: _sander.paauwe@..._ <mailto:sander.paauwe@...>

--

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Javier Szyszlican, Project Leader, JFFNMS
javier@...

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

RE: Graphing trouble

Thanks Markus,

This does seem to be my issue as well. I reread the instructions and
they indicate the bat files should be in the "jffnms\engine\windows"
directory. The bat files themselves refer to a php file in the
"jffnms\engine" directory. I ran the poller.bat manually and it did
create many files in the rrd directory. However my graphs are still
blank, and I have completely ruled out any file permission issues (which
seems to be the most common problem with blank graphs).

Did you just copy the bat files into the engine directory and recreate
the scheduled tasks, or did you edit the path statements within the bat
files?

-----Original Message-----
From: Markus Hirsch [mailto:markus@...] 
Sent: Tuesday, February 01, 2005 12:44 AM
To: Ed Humes; jffnms-users@...
Subject: Re: [jffnms-users] Graphing trouble

Hi Ed,

I had a similar problem with the installation unter
windows.

My Problem was, that the poller did create rrd-files when I started it
manually.

The solution for my problem was quit simple: the directory under whicht
the poller.cmd and the other batches had to run had to be jffnms/engine
not jffnms/engine/windows which was the default.

kind regards
Markus

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

RE: Flat rrd

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:javier@...] 
Sent: Tuesday, February 01, 2005 7:07 AM
Cc: jffnms-users@...
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: jffnms-users@...
> 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
> jffnms-users@...
> 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
> jffnms-users@...
> https://lists.sourceforge.net/lists/listinfo/jffnms-users

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Javier Szyszlican, Project Leader, JFFNMS javier@...

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
jffnms-users@...
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

Re: 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:javier@...] 
> Sent: Tuesday, February 01, 2005 7:07 AM
> Cc: jffnms-users@...
> 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: jffnms-users@...
>>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
>>jffnms-users@...
>>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
>>jffnms-users@...
>>https://lists.sourceforge.net/lists/listinfo/jffnms-users
> 
> 
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Javier Szyszlican, Project Leader, JFFNMS javier@...
> 
> 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
> jffnms-users@...
> https://lists.sourceforge.net/lists/listinfo/jffnms-users
> 

--

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Javier Szyszlican, Project Leader, JFFNMS
javier@...

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

RE: Flat rrd

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:javier@...] 
Sent: Tuesday, February 01, 2005 1:01 PM
Cc: jffnms-users@...
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:javier@...]
> Sent: Tuesday, February 01, 2005 7:07 AM
> Cc: jffnms-users@...
> 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: jffnms-users@...
>>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
>>jffnms-users@...
>>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
>>jffnms-users@...
>>https://lists.sourceforge.net/lists/listinfo/jffnms-users
> 
> 
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Javier Szyszlican, Project Leader, JFFNMS javier@...
> 
> 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
> jffnms-users@...
> https://lists.sourceforge.net/lists/listinfo/jffnms-users
> 

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Javier Szyszlican, Project Leader, JFFNMS javier@...

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
jffnms-users@...
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

Log interpretation

Hi,

I use jffnms 0.7.9 to monitor a LAN of about 1500 interfaces. The jffnms
server (Xeon 2.8 GHz, 1 Go of RAM) seems to have some performance problem.

Could you please explain to me how to interprete the poller log ?

Thanks for your work,

Regards,

Patrice 

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