Important Note for MySQL 5.x Users - NOT SUPPORTED YET!!

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

rpingar
Cacti User
Posts: 86
Joined: Mon Jun 07, 2004 8:17 am

Post by rpingar »

howto parteciapte into the betatesting?

thanks
Rosario
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Look in the annoucement forum
ikemeyer
Posts: 5
Joined: Sun Jan 01, 2006 2:21 pm

Post by ikemeyer »

I haven't had any major problems with Cacti 0.8.6h and MySQL 5.0.17, however, I did run across some problems with authentication using php5.1.1 and ended up downgrading to php4.3.11. If this says much the script that failed using php5.1.1 was "adodb-mysql.inc.php" and the message was generic ".. does not support this method of authentication..." The only workaround I found for php5.1.1 was to leave the password blank. Just my $0.02.

:o
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Although, MySQL 5 support is now in cacti 0.8.6h, you must NOT have the sql-mode variable set, otherwise it will cause problems.
paulbeard206
Cacti User
Posts: 150
Joined: Sat Jul 30, 2005 2:15 pm

cacti and MySQL 5.1 issues?

Post by paulbeard206 »

I am still unable to get access to cacti on

Code: Select all

Server version: 5.1.18-beta FreeBSD port: mysql-server-5.1.18
If I try to access the set up page, I 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 cactiuser -p cacti < cacti.sql

This error may also be generated if the cacti database user does not have correct permissions on the cacti database. Please ensure that the cacti database user has the ability to SELECT, INSERT, DELETE, UPDATE, CREATE, ALTER, DROP, INDEX on the cacti database.
I have imported the sql statements, and I have created the user with those (or all) permissions.

What gives?

And just to be clear, the permissions seem OK from looking the database, and I can login as the cactiuser from the database host and from another system.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Please check
- snmp-mysql is installed
- /etc/php.ini configures the mysql extension
- ./include/config.php is configured for access to the cacti db
- httpd is restarted after any change to /etc/php.ini
Reinhard
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests