Please Help

[qcsti]

I upgraded my database to version 5.0.18 on mysql and after doing so I restored the data. Everything went well but now when I try to connect to my cacti server through my web interface I get page cannot be displayed. What else do I need to change or look at. Mysql administrator shows my database and it looks good. I have rebooted and restarted apache with no luck. Thanks

[rony]

What version of cacti are you running?

[qcsti]

0.8.6h and apache 2.x

[rony]

There is something about turning on old database support in mysql 5.x that you need to do.

I'm sorry, I don't recall the post where I saw someone talking about that.

[qcsti]

I've commented out the sql-mode line if that's what your referring to.

[qcsti]

Here is my current setup:
PHP5
MySQL 5.0.18
Cacti 0.8.6h
Net-snmp 1.2x
RRD Tool 1.2.10
Windows 2000 Server SP4
IIS 5.0

Everything was working fine until I updated mysql from 5.0.7beta to 5.0.18. The upgrade went without any errors, afterwards I got page could not be displayed from the webinterface. I reinstalled apache 2.x and I got to index of / page. I couldn't figure out why or how to change it so I decided to install IIS and use that instead. Now I get the following error:

Warning: mysql_pconnect() [function.mysql-pconnect]: Host 'somename@domain.com' is not allowed to connect to this MySQL server in C:\Inetpub\wwwroot\cacti\lib\adodb\drivers\adodb-mysql.inc.php on line 355
PHP has encountered a Stack overflow

Any suggestions please?

[qcsti]

I think I'm getting closer to having this fixed. Now when I go to myserver@mydomain.com I get a directory listing of the files. I've inserted an image. What am I doing wrong?[/img]

[BSOD2600]

1) Your MySQL error can be fixed by adding the following to your my.ini file
#Use old password encryption method (needed for 4.0 and older clients).
old-passwords

2) I'm not an apache user, but I believe your getting the contents of the folder listed because of a misconfiguration of the <directory> option.

[qcsti]

I added the old password field on .ini file and it didn't correct the issue. I had to do a reinstall of mysql and cacti 0.8.6g. I then restored my database and got cacti working again. Thanks for the suggestions.

[lard]

1) Your MySQL error can be fixed by adding the following to your my.ini file
#Use old password encryption method (needed for 4.0 and older clients).
old-passwords

2) I'm not an apache user, but I believe your getting the contents of the folder listed because of a misconfiguration of the <directory> option.

Yep - sounds like the problem as Apache doesnt have it's default document type setup in the conf file and therefore just indexed the default directory...

The problem with the error message can be resolved by allowing the localhost and the full DNS of your server to connect,

Lard

[qcsti]

How do you setup the document type in apache. I did the directory index settings per the setup instructions but I still get the same result. Thanks

[avigil72]

I had the same issue you have, or had, and this is how I resolved it:
cd /www/conf
cat httpd.conf | grep DirectoryIndex
There should be only one entry there more or less like next line:
DirectoryIndex index.php default.htm default.html index.html index.html.var
You can edit the file with vi:
vi httpd.conf
then find the first time DirectoryIndex appears, if you are not an experienced Lunix user, just press Esc, the i. You are in Insert mode, change the line to what I told you.
save and exit.
Try your page, otherwise, make sure there is a index.php in the cacti directory.
That should resolve it.

[avigil72]

There should only be one DirectoryIndex line in the httpd.conf file, if there are two or more, just delete them leaving one.