Cacti Install - Tough going - PHP4.4.1 / mysql 5 / apache2.0

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

Moderators: Developers, Moderators

Post Reply
kneedeep.eu
Posts: 3
Joined: Fri Jan 13, 2006 10:23 am

Cacti Install - Tough going - PHP4.4.1 / mysql 5 / apache2.0

Post by kneedeep.eu »

Hi. - having issues getting cacti to work on Windows 2003 - i think php and apache are ok - IIS not configured on Server - No MS SQL.
(Followed THE CACTI MANUAL - IAN BERRY as best as possible)

1st section - is progross so far
2nd section - my issues right now
3rd section - previous issue
::::::::::::::::::::::::::::::::::::::::::::::::::::::
SECTION 1 -
Apache works / php works (with phpinfo.php anyway)
PHP.ini is in c:\winnt - with extensions working ok (given that apache
works)
HTTPD.CONF updated also ( loadmodule php4...etc)
mysql user root and cactiuser have GRANT ALL ON access to both dbs - mysql / cacti
cacti is associated mysql db.
$database info is correct for db / hostname / pass
cacti folder is in the htdoc dir
windows path has c:\php & mysql updated.

SECTION 2
A:When i type the url say http://10.10.10.10/cacti, i used to get "You have created a new database, but have not yet imported the 'cacti.sql' file. At the command line, execute the following to continue:
mysql -u cacti -p cactidb < cacti.sql" - any workaround ?

B: C:\Program Files\Apache Group\Apache2\bin>mysql --user=root -p fine < c:\cacti\cacti.sql
Enter password: ******
ERROR 1264 (22003) at line 1857: Out of range value adjusted for column 'availability' at row 1 - WHAT does this mean ?

so now i get page cannot be displayed - The page you are looking for is currently unavailable. PAGE BEING /cacti or /cacti/install

If i use this url http://localhost/cacti/auth_login.php i get the following message:
Fatal error: Call to undefined function: read_config_option() in C:\Program Files\Apache Group\Apache2\htdocs\cacti\auth_login.php on line 139

apologies - maybe too much info - any feedback welcomed & appreciated. K

Section 3 - messages about 30 times in IE window about authentication -(cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339 ) but both old-passwords option in my.ini & SET PASSWORD FOR 'here'@'host' = OLD_PASSWORD('root'); nailed this. after this i started to see the error about needing to import the cacti.sql having already done it.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

I bet you're using cacti 0.8.6h with mysql 5. Install the patches for cacti and then try importing the cacti.sql file again. Alternatively, you can comment out sql-mode from my.ini which will also allow you to import cacti.sql.
kneedeep.eu
Posts: 3
Joined: Fri Jan 13, 2006 10:23 am

Post by kneedeep.eu »

your right on versions - ill try that. thx for feedback.
Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests