mysql error with cactiez 0.7

Addons for Cacti and discussion about those addons

Moderators: Developers, Moderators

Post Reply
bgp65530
Posts: 3
Joined: Tue Dec 18, 2012 12:07 am

mysql error with cactiez 0.7

Post by bgp65530 »

hi,I installed cactiez0.7 in vmware,but there is something wrong.
The server's IP is:10.63.49.249.my randomized cactiuser mysql password is:
root : 2M9pkum2
cactiuser : Eqt/B1MN

but when i open the web,the error information is:
FATAL: Cannot connect to MySQL server on '127.0.0.1'. Please make sure you have specified a valid MySQL database name in 'include/config.php'
when i chang the password in 'include/config.php' ,the error is:
Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'cactiuser'@'localhost' (using password: YES) in /var/www/html/lib/adodb/drivers/adodb-mysqli.inc.php on line 83 Can not connect

but the randomized cactiuser mysql password is right,i can login to mysql with the two users and password.

i find the same problem in the http://forums.cacti.net/viewtopic.php?f=5&t=48682, but i don't know how to solve it
doiggl
Cacti User
Posts: 222
Joined: Wed Dec 16, 2009 6:32 am

Re: mysql error with cactiez 0.7

Post by doiggl »

Hello,
You may want to have a look at the thread in:

http://forums.mysql.com/read.php?11,34014,46593
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

--Glenn
doiggl
Cacti User
Posts: 222
Joined: Wed Dec 16, 2009 6:32 am

Re: mysql error with cactiez 0.7

Post by doiggl »

Hello,
As administrator create cacti database ,cacti id, credentials and schema.
example only. replace with your settings.

running following commands from mysql prompt:

>use mysql;
>drop database if exists cactidb;
>create database cactidb;
>drop user 'cacti'@'localhost';
>create user 'cacti'@'localhost' IDENTIFIED BY 'cacti';
>grant all on cactidb.* TO cacti@localhost IDENTIFIED BY 'cacti';
>flush privileges;
>select Host,Db,User from db;
>show databases;
>select user,host from mysql.user;

to logon to cacti database with mysql and generate the cacti schema - replace with your settings.

#mysql -u cacti -pcacti -b cactidb < /srv/www/cacti/cacti.sql

to logon to cacti database with mysql
#mysql -u cacti -pcacti -b cactidb

Using this for reference material:
http://en.opensuse.org/Cacti

--Glenn
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests