installation help

[greymatter]

Hi, I am using MySQL 4.1.12a, Php 4.3.10, Apache 2.0.54
on Windows XP SP2.

I am at the point where I need to import the default Cacti database. I am getting this message and not quite sure how to fix it.


C:\mysql\bin>mysql --user=root --password cacti < c:\apache2\htdocs\cacti\cacti.
sql
The system cannot find the path specified.


C:\mysql\bin>

Sorry im a noob. Do I need to manually create this myself? or am I doing something wrong?

[tomdemat]

I think the file cacti.sql doesn't placed on the directory you entered.
You maybe made an extract of cacti archive in a diffrerent directory.

Sorry for my english
I hope that will help you

Good luck
Tom

[greymatter]

thanks! you were right

[greymatter]

In the instruction it is asking me to point my web browser to

http://your-server/cacti

when i do this, I am receiving this error. Could someone help? I do not know what this means

Warning: mysql_connect(): Host 'cactibox.EXILICOM.COM' is not allowed to connect to this MySQL server in C:\Apache2\htdocs\cacti\lib\adodb\drivers\adodb-mysql.inc.php on line 339

Cannot connect to MySQL server on 'cactibox'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.

[TheWitness]

please put "localhost" in the config.php and not the entire fqdn. This should help. Otherwise, you need to grant addtional privileges to the web server in MySQL.

TheWitness

[greymatter]

Thanks for you help, but still a little confused

What do I put here?

$database_username = "??";
$database_password = "??";

Do I HAVE to create a cactiuser and password? or do i put "root" and password?

I changed it to localhost and now im getting this

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Apache2\htdocs\cacti\lib\adodb\drivers\adodb-mysql.inc.php on line 339

Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.

-----

this is what my config.php looks like:

/* make sure these values refect your actual database/host/user/password */
$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "cactiuser";
$database_password = "my password here";

::headache::

[TheWitness]

For just playing around the house, I use root. For production, I would use something else.

TheWitness

[greymatter]

Thanks for all the help. I need help with one last thing.

When i run php.exe

I get this error. I edited the php.ini with the proper location of the extensions. I also properly set the system variables. For some reason it cannot find the c:\php\mibs

anyone know how to fix this?



C:\php>php
Cannot find module (IP-MIB): At line 0 in (none)
Cannot find module (IF-MIB): At line 0 in (none)
Cannot find module (TCP-MIB): At line 0 in (none)
Cannot find module (UDP-MIB): At line 0 in (none)
Cannot find module (SNMPv2-MIB): At line 0 in (none)
Cannot find module (SNMPv2-SMI): At line 0 in (none)
Cannot find module (UCD-SNMP-MIB): At line 0 in (none)
Cannot find module (UCD-DEMO-MIB): At line 0 in (none)
Cannot find module (SNMP-TARGET-MIB): At line 0 in (none)
Cannot find module (SNMP-VIEW-BASED-ACM-MIB): At line 0 in (none)
Cannot find module (SNMP-COMMUNITY-MIB): At line 0 in (none)
Cannot find module (UCD-DLMOD-MIB): At line 0 in (none)
Cannot find module (SNMP-FRAMEWORK-MIB): At line 0 in (none)
Cannot find module (SNMP-MPD-MIB): At line 0 in (none)
Cannot find module (SNMP-USER-BASED-SM-MIB): At line 0 in (none)
Cannot find module (SNMP-NOTIFICATION-MIB): At line 0 in (none)
Cannot find module (SNMPv2-TM): At line 0 in (none)

[TheWitness]

php_snmp is looking for your mib files. If you don't have net-snmp installed, it is best to create the MIBDIRS environment variable and point it to the directory with the mibs. This is typically a subdirectory under php. If you do have net-snmp installed, point it to that MIB's location.

TheWitness

[greymatter]

Thanks for your help TheWitness, I really appreciate you helping out a nooby like myself.

I found I did not properly make the environment variables, so I fixed that. But, I am still having issues with the poller.php

Everytime it runs from the task scheduler I receive a whole mess of these errors.

C:\>cd php

C:\php>C:\php\php.exe c:\apache2\htdocs\cacti\poller.php
Content-type: text/html
X-Powered-By: PHP/4.3.10

<br />
<b>Warning</b>: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in <b>c:\apache2\htdocs\cacti\lib\adodb\drivers\adodb-mysql.inc.php</b> on line <b>340</b><br />

<br>Cannot connect to MySQL server on 'localhost'. Please make sure you have spe
cified a valid MySQL database name in 'include/config.php'.
C:\php>

What does this mean?

[BSOD2600]

Just like the message says... Cacti is unable to connect to the mysql database. If you search the forum, there are dozens of posts with others having the same problem.

In config.php change the server addy from localhost to 127.0.0.1.

[greymatter]

Thank you guys once again for the help. I was able to correct this issue by using the "old password" method.

Here's what I did:

Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Alternatively, use UPDATE and FLUSH PRIVILEGES:

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

Substitute the password you want to use for ``newpwd'' in the preceding examples. MySQL cannot tell you what the original password was, so you'll need to pick a new one.

Tell the server to use the older password hashing algorithm:

Start mysqld with the --old-passwords option.

Assign an old-format password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query:

mysql> SELECT Host, User, Password FROM mysql.user
-> WHERE LENGTH(Password) > 16;

For each account record displayed by the query, use the Host and User values and assign a password using the OLD_PASSWORD() function and either SET PASSWORD or UPDATE, as described earlier.


---

I also opened up my.ini which was located in my C:\mysql folder and added the statement under [mysqld]

old_passwords

--

For some reason Mysql was loading the .ini from c:\windows directory so I copied and pasted it into the windows folder.

This fixed everything.

[greymatter]

I ran this manually in DOS because I saw it run automatically as a scheduled task, and it just didn't look right. Would anyone know what is causing this? or if this is normal?

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

H:\>c:

C:\>cd php

C:\php>C:\php\php.exe c:\apache2\htdocs\cacti\poller.php

'cat' is not recognized as an internal or external command,
operable program or batch file.
'cat' is not recognized as an internal or external command,
operable program or batch file.
'uptime' is not recognized as an internal or external command,
operable program or batch file.
'who' is not recognized as an internal or external command,
operable program or batch file.
'ps' is not recognized as an internal or external command,
operable program or batch file.
OK
OK
OK
OK
Content-type: text/html
X-Powered-By: PHP/4.3.10

06/10/2005 01:50:39 PM - SYSTEM STATS: Time: 2.1622 s, Method: cmd.php, Processe
s: 1, Threads: N/A, Hosts: 2, Hosts/Process: 2

C:\php>

[TheWitness]

You are running scripts designed for *nix and not windows.

TheWitness

[greymatter]

I just did a fresh reinstall of everything and now when i run

php c:\apache2\htdocs\cacti\cacti.sql

i get this message

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

H:\>c:

C:\>cd php

C:\php>C:\php\php.exe c:\apache2\htdocs\cacti\poller.php
Content-type: text/html
X-Powered-By: PHP/4.3.11

There are no items in your poller cache or polling is disabled. Make sure you ha
ve at least one data source created. If you do, go to 'Utilities', and select 'C
lear Poller Cache'.
Creating directory: /USR
Creating directory: /USR/SNMP
Creating directory: /USR/SNMP/PERSIST

C:\php>

Is this normal?

Sorry for the 239048204283 questions! but you guys are helping a lot!