Summary: | net-analyzer/cacti-0.8.6f-r1 - mysql errors after install | ||
---|---|---|---|
Product: | Gentoo Linux | Reporter: | Tremaine <tremaine> |
Component: | [OLD] Server | Assignee: | Gentoo Netmon project <netmon> |
Status: | RESOLVED WORKSFORME | ||
Severity: | normal | ||
Priority: | High | ||
Version: | unspecified | ||
Hardware: | x86 | ||
OS: | Linux | ||
Whiteboard: | |||
Package list: | Runtime testing required: | --- |
Description
Tremaine
2005-08-08 10:05:51 UTC
(In reply to comment #0) > After emerge of cacti-0.8.6f-r1, going to the cacti url: > Cannot connect to MySQL server on 'localhost'. Please make sure you have > specified a valid MySQL database name in 'include/config.php'. > > > From include/config.php > > > $database_type = "mysql"; > $database_default = "cacti"; > $database_hostname = "localhost"; > $database_username = "cactiuser"; > $database_password = "db password here"; Uhm, you did not follow the postinstall instructions for upgrading, did you? This was a fresh install, so I didn't use the upgrade instructions. That doesn't look like you changed the password for the mysql user. (In reply to comment #3) > That doesn't look like you changed the password for the mysql user. Yep, I did. I even logged into the mysql server with the username and password. The password noted in the paste from config.php is intentionally broken for the bug report. *pasted from above* From include/config.php $database_type = "mysql"; $database_default = "cacti"; $database_hostname = "localhost"; $database_username = "cactiuser"; $database_password = "db password here"; I'm able to log into mysql at the command line with cactiuser and the db password specified in config.php mysql -u cactiuser -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2479 to server version: 4.0.24 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> So your password is 'db password here' ? I'm not sure if you need to escape the spaces in the config file. I don't think its very wise at all to use that as your default password. Why in the world would you do that?! The password indicated in the config.php here in the bug report is not the password being used on the system where it is failing. For practical purposes in testing, we can pretend that the password is 123456. With a password of 123456 in config.php I get the errors previously noted. I am able to log into mysql with cactiuser and a password of 123456 and see the cacti db. Odd. In a fit of pique, I changed the password temporarily to the aforementioned 123456. It works. It would appear that the use of at least some special characters breaks authentication - this is likely something that should be fixed to allow for strong passwords and perhaps a warning in the meantime that the use of special characters is not supported in the current version. Itsnt really a problem with ebuild or package itself.... using spaces in password isnt the proper way. (In reply to comment #8) > Itsnt really a problem with ebuild or package itself.... using spaces in > password isnt the proper way. No spaces were used in the password. As a matter of course, I never post passwords. Ever. the "db password here" was not the password. It turns out that cacti does not handle the use of the $ char in passwords very well (at all) and that was the source of the problem. I've found a few apps that suffer from this problem, but it's certainly not universal. The $ should be an accepted character for passwords to encourage the use of stronger passwords involving special chars. |