Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support  

 FAQFAQ   SearchSearch   MemberlistMemberlist    RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in    


spine not work

 
Post new topic   Reply to topic    Cacti Forum Index -> Help: Windows Specific
Author Message
feelgirl



Joined: 06 Apr 2008
Posts: 18
PostPosted: Wed May 07, 2008 11:16 pm    Post subject: spine not work Reply with quote
Date Thu, 08 May 2008 12:05:33 +0800
Cacti Version 0.8.7b
Cacti OS win32
SNMP Version net-snmp
RRDTool Version RRDTool 1.2.x
Interval 300
Type spine
Time:21.6397 Method:spine Processes:1 Threads:1 Hosts:58 HostsPerProcess:58 DataSources:1131 RRDsProcessed:567
PHP Version 5.2.2

in my cacti_log,I can saw:
05/08/2008 10:11:43 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
05/08/2008 10:11:43 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
05/08/2008 10:11:43 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
05/08/2008 10:11:43 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
05/08/2008 10:11:43 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
05/08/2008 10:11:27 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
05/08/2008 10:11:27 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
05/08/2008 10:11:27 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
05/08/2008 10:11:27 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
05/08/2008 10:11:27 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
05/08/2008 02:11:21 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
05/08/2008 02:11:21 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:21.6397 Method:spine Processes:1 Threads:1 Hosts:58 HostsPerProcess:58 DataSources:1131 RRDsProcessed:567')"
05/08/2008 02:11:21 AM - SYSTEM STATS: Time:21.6397 Method:spine Processes:1 Threads:1 Hosts:58 HostsPerProcess:58 DataSources:1131 RRDsProcessed:567
05/08/2008 02:11:21 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\AppServ\www\cacti\rra\xgs8512_traffic_in_610.rrd --template traffic_out:traffic_in 1210241479:385728153703102:226869149238765
05/08/2008 02:11:21 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\AppServ\www\cacti\rra\xgs8512_traffic_in_611.rrd --template traffic_out:traffic_in 1210241479:146475021320778:66832867163446
05/08/2008 02:11:21 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\AppServ\www\cacti\rra\xgs8512_traffic_in_612.rrd --template traffic_out:traffic_in 1210241479:36425707793467:16131856156668
05/08/2008 10:11:21 AM - SPINE: Poller[0] Time: 21.2340 s, Threads: 1, Hosts: 58
05/08/2008 10:11:21 AM - SPINE: Poller[0] DEBUG: MYSQL Free & Close Completed
05/08/2008 10:11:21 AM - SPINE: Poller[0] SPINE: Net-SNMP API Shutdown Completed
05/08/2008 10:11:21 AM - SPINE: Poller[0] DEBUG: Allocated Variable Memory Freed
05/08/2008 10:11:21 AM - SPINE: Poller[0] DEBUG: PHP Script Server Pipes Closed
05/08/2008 10:11:21 AM - SPINE: Poller[0] DEBUG: Thread Cleanup Complete
05/08/2008 10:11:21 AM - SPINE: Poller[0] DEBUG: SQL:'insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())'
05/08/2008 10:11:21 AM - SPINE: Poller[0] DEBUG: SQL:'replace into settings (name,value) values ('date',NOW())'
05/08/2008 10:11:21 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
05/08/2008 10:11:21 AM - SPINE: Poller[0] Host[63] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function

05/08/2008 10:11:21 AM - SPINE: Poller[0] DEBUG: SQL:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (610,'traffic_in','2008-05-08 10:11:19','226869149238765'),(610,'traffic_out','2008-05-08 10:11:19','385728153703102'),(611,'traffic_in','2008-05-08 10:11:19','66832867163446'),(611,'traffic_out','2008-05-08 10:11:19','146475021320778'),(612,'traffic_in','2008-05-08 10:11:19','16131856156668'),(612,'traffic_out','2008-05-08 10:11:19','36425707793467'),(613,'traffic_in','2008-05-08 10:11:19','1087434779490454'),(613,'traffic_out','2008-05-08 10:11:19','532234592497172'),(614,'traffic_in','2008-05-08 10:11:19','939302954143438'),(614,'traffic_out','2008-05-08 10:11:19','1077918655132947'),(615,'traffic_in','2008-05-08 10:11:19','13902399897198'),(615,'traffic_out','2008-05-08 10:11:19','21081264116430'),(616,'traffic_in','2008-05-08 10:11:19','5641232172616'),(616,'traffic_out','2008-05-08 10:11:19','2874073142589'),(617,'traffic_in','2008-05-08 10:11:19','0'),(617,'traffic_out','2008-05-08 10:11:19','0'),(618,'traffic_in','2008-05-08 10:'


in cmd line rrdtool fetch the rrd file .not updata.

where is my problem?
help me !
thanks
Back to top
bpraveen



Joined: 08 Feb 2008
Posts: 24
Location: BANGALORE
PostPosted: Wed May 07, 2008 11:26 pm    Post subject: Reply with quote
This is an autentication problem, Looks that the user dont have access to your database, Can you check your Spine.conf/cactid.conf and make sure you have provided the autentication details over there.
Back to top
feelgirl



Joined: 06 Apr 2008
Posts: 18
PostPosted: Thu May 08, 2008 12:19 am    Post subject: Reply with quote
my spine.conf show:
DB_Host 127.0.0.1
DB_Database cacti
DB_User cactiuser
DB_Pass cactiuser
DB_Port 3306

is Match my sql data

I think TimeZone mybe is the porblem
I'm in china,the system time is Differ for 8 hours from local time
05/08/2008 01:05:33 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
05/08/2008 05:01:28 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"

where I can Modify the file for the right Timezone
Back to top
BSOD2600
Cacti Moderator


Joined: 08 May 2004
Posts: 6767
Location: WA, USA
PostPosted: Thu May 08, 2008 12:14 pm    Post subject: Reply with quote
What makes you think there is an authentication or timezone problem?

Did you not see the rrdtool.exe update commands in the log file? If the files are not updated, then is quite possible you have a NTFS permission problem. Make sure IUSR and IIS_WPG accounts have modify rights on the rrd files.
Back to top
xandlsoft



Joined: 09 May 2008
Posts: 7
Location: VIENNA, Austria
PostPosted: Fri May 09, 2008 3:13 am    Post subject: I have allso troubles with spine Reply with quote
My poller not run with spine. Cacti.log says:

05/09/2008 09:52:01 AM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Scheduled Task, but 324 seconds have passed since the last poll!
05/09/2008 09:57:00 AM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
05/09/2008 09:57:00 AM - SYSTEM STATS: Time:298.7553 Method:spine Processes:1 Threads:1 Hosts:75 HostsPerProcess:75 DataSources:13619 RRDsProcessed:0
05/09/2008 09:57:00 AM - WEATHERMAP
: Poller[0] Weathermap 0.95b starting - Normal logging mode. Turn on DEBUG in Cacti for more information
05/09/2008 09:57:00 AM - WEATHERMAP: Poller[0] [Map 3] 1030_o25_wlan.conf: Map: d:\www\cacti\plugins\weathermap\configs\1030_o25_wlan.conf -> d:\www\cacti\plugins\weathermap\output\8405b0f47ac5fa6bd1f0.html & d:\www\cacti\plugins\weathermap\output\8405b0f47ac5fa6bd1f0.png
05/09/2008 10:02:01 AM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Scheduled Task, but 600 seconds have passed since the last poll!
05/09/2008 10:07:00 AM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
05/09/2008 10:07:00 AM - SYSTEM STATS: Time:298.7836 Method:spine Processes:1 Threads:1 Hosts:75 HostsPerProcess:75 DataSources:13619 RRDsProcessed:0
05/09/2008 10:07:00 AM - WEATHERMAP
: Poller[0] Weathermap 0.95b starting - Normal logging mode. Turn on DEBUG in Cacti for more information
05/09/2008 10:07:00 AM - WEATHERMAP: Poller[0] [Map 3] 1030_o25_wlan.conf: Map: d:\www\cacti\plugins\weathermap\configs\1030_o25_wlan.conf -> d:\www\cacti\plugins\weathermap\output\8405b0f47ac5fa6bd1f0.html & d:\www\cacti\plugins\weathermap\output\8405b0f47ac5fa6bd1f0.png
05/09/2008 10:12:00 AM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Scheduled Task, but 599 seconds have passed since the last poll!

PHP poller runs perfectly

Sorry for my bad english!
Back to top
feelgirl



Joined: 06 Apr 2008
Posts: 18
PostPosted: Fri May 09, 2008 8:16 am    Post subject: Reply with quote
BSOD2600 wrote:
What makes you think there is an authentication or timezone problem?

Did you not see the rrdtool.exe update commands in the log file? If the files are not updated, then is quite possible you have a NTFS permission problem. Make sure IUSR and IIS_WPG accounts have modify rights on the rrd files.


I'm make sure the accounts :IUSR and IIS_WPG have modify rights on the rrd files.

when I use cmd.php,rrd file can write .when I use spine ,the rrd file can't write.

MY question is :when use cmd.php,which account to updata rrd file.

and when use spine,which accounts to updata rrd file .

Is relation for the account to run the php.exe and poller.hph?
Back to top
BSOD2600
Cacti Moderator


Joined: 08 May 2004
Posts: 6767
Location: WA, USA
PostPosted: Fri May 09, 2008 12:06 pm    Post subject: Reply with quote
feelgirl wrote:
MY question is :when use cmd.php,which account to updata rrd file.

and when use spine,which accounts to updata rrd file .

Is relation for the account to run the php.exe and poller.hph?

You can always use something like Sysinternals Process Monitor to find out .

Anyways, both cmd.php/spine should run with the credentials which your cacti scheduled task runs under. When you are viewing graphs, then the web server account (IUSR/IIS_WPG) are used to launch cmd.exe/rrdtool.exe.
Back to top
feelgirl



Joined: 06 Apr 2008
Posts: 18
PostPosted: Sat May 10, 2008 8:51 pm    Post subject: Reply with quote
05/11/2008 01:38:09 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\AppServ\www\cacti\rra\xgs8512_traffic_in_610.rrd --template traffic_out:traffic_in 1210498686:385750353681862:226869153635784
I saw the rrdtool is update the rrd file .
and I'm sure the IUSR and IIS_WPG accounter have right to Complete control the rrd file.

where is Me Neglect ?
Back to top
feelgirl



Joined: 06 Apr 2008
Posts: 18
PostPosted: Sat May 10, 2008 10:44 pm    Post subject: Reply with quote
05/11/2008 01:38:09 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\AppServ\www\cacti\rra\xgs8512_traffic_in_610.rrd --template traffic_out:traffic_in 1210498686:385750353681862:226869153635784
I saw the rrdtool is update the rrd file .
and I'm sure the IUSR and IIS_WPG accounter have right to Complete control the rrd file.

where is Me Neglect ?

05/11/2008 02:03:09 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='612' and rrd_name='traffic_out' and time='2008-05-11 10:03:06'"

WHY It will delete the data?
Back to top
BSOD2600
Cacti Moderator


Joined: 08 May 2004
Posts: 6767
Location: WA, USA
PostPosted: Sat May 10, 2008 11:00 pm    Post subject: Reply with quote
Remind me again, whats your current problem?

Have you followed http://docs.cacti.net/node/283 yet?

It's deleting the temporary data from the poller_output table. this is completely. normal.
Back to top
feelgirl



Joined: 06 Apr 2008
Posts: 18
PostPosted: Mon May 12, 2008 9:09 pm    Post subject: Reply with quote
BSOD2600 wrote:
Remind me again, whats your current problem?

Have you followed http://docs.cacti.net/node/283 yet?

It's deleting the temporary data from the poller_output table. this is completely. normal.


I think My current problem is the right to modfy the rrd file.

I'm use Administrator accounter to run the php.exe and poller.php when I use cmd.php.
When use spine.exe ,the accounter need change to cactiuser to run the php.exe and poller.php.

Mybe I need change accounter to cactiuser to run the php.exe and poller.php when I first run the cacti.
Back to top
BSOD2600
Cacti Moderator


Joined: 08 May 2004
Posts: 6767
Location: WA, USA
PostPosted: Tue May 13, 2008 1:06 pm    Post subject: Reply with quote
The user which the Cacti scheduled task is executed under, will use its permissions to run cmd.php/spine.exe, rrdtool.exe, cmd.exe, etc.

If think you've already assigned all the permissions correctly, it might be time to follow HOWTO: Debug Windows NTFS permission problems.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Cacti Forum Index -> Help: Windows Specific All times are GMT - 5 Hours
Page 1 of 1

 



Powered by phpBB © 2001, 2005 phpBB Group