Re: [jffnms-users] rddtools

[Dan C. <ch...@en...>]

Javier Szyszlican wrote:

> You should su - to root first to be able to su to jffnms then.
>
> And also check the shell on /etc/passwd for jffnms, it should be set 
> to false, you should set it to something to be able to login.
>
> Also try without the "-".
>
> Javier
>
> Dan Caton wrote:
>
>> Javier Szyszlican wrote:
>>
>>> So, to try this do.
>>>
>>> # su - jffnms
>>> $ cd engine
>>> $ php4 -q poller.php <host_id>
>>>
>>>
>>> Replace <host_id> with one of your hosts ID.
>>>
>>> Javier
>>>
>>> Dan Caton wrote:
>>>
>>>> Javier Szyszlican wrote:
>>>>
>>>>> Hi Dan,
>>>>>
>>>>> This is probably a problem with your cronjobs, or a permission issue.
>>>>>
>>>>> Check if you have files in rrd/* and check your cron.log to see if 
>>>>> the poller job is running.
>>>>>
>>>>> Javier
>>>>>
>>>>> Dan Caton wrote:
>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> I have setup jffnms on a Debian sarge box and have gotten it all 
>>>>>> to work except for the graphing.  When I click on performance I 
>>>>>> ge the following message:
>>>>>>
>>>>>> The RRDTool files for Interface ID 52 (from Host ID 5), has not 
>>>>>> been created by the Poller Process yet
>>>>>>
>>>>>> Any idea what I am doing wrong?  I can't seem to find it in the 
>>>>>> documentation.
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Dan
>>>>>>
>>>>>>
>>>>>> -------------------------------------------------------
>>>>>> SF email is sponsored by - The IT Product Guide
>>>>>> Read honest & candid reviews on hundreds of IT Products from real 
>>>>>> users.
>>>>>> Discover which products truly live up to the hype. Start reading 
>>>>>> now.
>>>>>> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>>>>>> _______________________________________________
>>>>>> jffnms-users mailing list
>>>>>> jff...@li...
>>>>>> https://lists.sourceforge.net/lists/listinfo/jffnms-users
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>> I found the cron job messages in the syslog and it shows:
>>>> Feb  3 06:17:01 chiefdesk /USR/SBIN/CRON[13133]: (jffnms) CMD (cd 
>>>> $JFFNMS && php4 -q consolidate.php >/dev/null 2>&1)
>>>> Feb  3 06:18:01 chiefdesk /USR/SBIN/CRON[13138]: (jffnms) CMD (cd 
>>>> $JFFNMS && php4 -q consolidate.php >/dev/null 2>&1)
>>>> Feb  3 06:19:01 chiefdesk /USR/SBIN/CRON[13143]: (jffnms) CMD (cd 
>>>> $JFFNMS && php4 -q consolidate.php >/dev/null 2>&1)
>>>> Feb  3 06:20:01 chiefdesk /USR/SBIN/CRON[13149]: (jffnms) CMD (cd 
>>>> $JFFNMS && php4 -q poller.php >/dev/null 2>&1)
>>>> Feb  3 06:20:01 chiefdesk /USR/SBIN/CRON[13150]: (jffnms) CMD (cd 
>>>> $JFFNMS && php4 -q consolidate.php >/dev/null 2>&1)
>>>>
>>>> so it looks like it is running
>>>>
>>>> Dan
>>>
>>>
>>>
>>>
>> I am unable to su - jffnms it still lists me as user chief
>>
>> Dan
>>
>>
>> -------------------------------------------------------
>> SF email is sponsored by - The IT Product Guide
>> Read honest & candid reviews on hundreds of IT Products from real users.
>> Discover which products truly live up to the hype. Start reading now.
>> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>> _______________________________________________
>> jffnms-users mailing list
>> jff...@li...
>> https://lists.sourceforge.net/lists/listinfo/jffnms-users
>
>
This is what I got:

db_ping(mysql) Connection to DB Restored...
db_ping(mysql) Connection to DB Restored...
db_ping(mysql) Connection to DB Restored...
db_ping(mysql) Connection to DB Restored...
db_ping(mysql) Connection to DB Restored...
Query failed - poller_plan - You have an error in your SQL syntax; check 
the manual that corresponds to your MySQL server version for the right 
syntax t5

                ORDER BY
                    pollers_poller_groups.pos, interf
????

Dan