beta installer, SPINE dosen't work because!!

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

MadX
Posts: 31
Joined: Wed Apr 23, 2008 7:10 pm

beta installer, SPINE dosen't work because!!

Post by MadX »

cmd.php is working OK but when switch to spine all graphs stops updating.

i have checked the mysql also and did full repair with the two commands:
1- mysqlcheck --auto-repair --databases cacti
2- php repair_database.php

it show`s that every thing is OK with the tables


there were somthings i found out:
1- that the default spine.confs that comes with the beta installer has miss config, like this

DB_Host 127.0.0.1
DB_Database mysql
DB_User cactiuser
DB_Pass cactiuser
DB_Port 3306

when it should be

DB_Host 127.0.0.1
DB_Database cacti
DB_User cactiuser
DB_Pass cactipw
DB_Port 3306

as u can see "DB_Database" should point to cacti`s table not to mysql, also in mysql database under "user administration" i have add 127.0.0.1 uder the cacti user so it will allow connections from cactiuser@127.0.0.1

just like it already allow`s cactiuser@localhost, ====>SPINE need`s this to access the database.
there were errors in the debug logs about not able to connect to the database, and the cacti`s table in the mysql where not beign updated befor i fix the above two problems.


2- i have checked the NTFS permessions and i have gave IUSR full permessions to spine.exe, sh.exe, rra files, and to the cacti folder. before that the rra files where not being updated. but now they are

and now there is no errors in the debug logs when using spine, and the rra files is being updated, but still the graphs stop`s once i switch to SPINE


Info:
Operating System: Windows 2003 Sp2
Webserver: Apache Http server 2.2.9
Cacti: Version 0.8.7b
Spine: Version 0.8.7a that comes with the latest beta installer of cacti
MySQL: version 5 that comes with the latest beta installer of cacti
PHP: 5.2 that comes with the latest beta installer of cacti
RRDTool (Cygwin or Win32 version): that comes with the latest beta installer of cacti
Net-SNMP: version 5.4.1.3 that comes with the latest beta installer of cacti
Cygwin (cygwin1.dll version): that comes with the latest beta installer of cacti
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Hmm interesting, I'll have to check into it once home. Since Cacti/spine 0.8.7c is right around the corner, I'm going to hold off updating the installer until its released and deamed stable. Might even include Apache with it, if I'm feeling up to it...
User avatar
TheWitness
Developer
Posts: 17004
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

I sent Tony the win32 binary. Don't know why he did not post it.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

TheWitness wrote:I sent Tony the win32 binary. Don't know why he did not post it.
Well its posted here, http://forums.cacti.net/viewtopic.php?t=29486 but still not claimed stable yet ;-)
MadX
Posts: 31
Joined: Wed Apr 23, 2008 7:10 pm

Post by MadX »

wondring y not submitting a compiled SPINE file.

i have tride the Cygwin compiling proccess but had some errors with it, gues i`ll have to give it a nother try if no one submit compiled one.


any one !!
User avatar
TheWitness
Developer
Posts: 17004
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Attached.
Attachments
spine.zip
(616.31 KiB) Downloaded 162 times
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
MadX
Posts: 31
Joined: Wed Apr 23, 2008 7:10 pm

Post by MadX »

thank you, i`ll try it right away.
MadX
Posts: 31
Joined: Wed Apr 23, 2008 7:10 pm

Post by MadX »

even the rra files is not being updated using the attatched compiled spine.

with no errors in the debug but still all graphs stops onc switching to spine.
User avatar
TheWitness
Developer
Posts: 17004
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

That has nothing to do with Spine. If you run it in medium and the data is flowing to the screen, then your problem is more with poller.php and rrdtool.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
MadX
Posts: 31
Joined: Wed Apr 23, 2008 7:10 pm

Post by MadX »

with the spine u attatched the data is not flowing to the screen when polling under debug.

but when using the spine that comes with the beta installer the data is flowing to the screen once it run`s under debug.

still spine not working.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

For testing, if you run spine manually at the command prompt, what happens?
MadX
Posts: 31
Joined: Wed Apr 23, 2008 7:10 pm

Post by MadX »

it show`s me tons of lines and data just like what cmd.php show`s

under debug
MadX
Posts: 31
Joined: Wed Apr 23, 2008 7:10 pm

Post by MadX »

any ideas ? i`m still trying every thing i can think of.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Ok, so sounds like it works. Make sure the NTFS permissions on spine's files are set correct for cacti (IUSR_, the scheduled task user, etc) all have read/execute rights.
MadX
Posts: 31
Joined: Wed Apr 23, 2008 7:10 pm

Re: beta installer, SPINE dosen't work because!!

Post by MadX »

MadX wrote:2- i have checked the NTFS permessions and i have gave IUSR full permessions to spine.exe, sh.exe, rra files, and to the cacti folder. before that the rra files where not being updated. but now they are
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests