cacti 安装错误!

lnycm

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 cactidb < 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.
我已经成功执行了mysql -u cactiuser -p cactidb < cacti.sql,在配置文件里保证Mysql连接的用户名、密码正确。

[ 本帖最后由 lnycm 于 2006-12-2 11:38 编辑 ]

ideovo

cactidb的权限问题，把权限分配给你新建的cacti用户

ideovo

mysql>; create database cactidb;
mysql>; grant all on cactidb.* to cactiuser;
mysql>; grant all on cactidb.* to cactiuser@localhost;
mysql>; set password for cactiuser@localhost=password('cactipw');
mysql>; exit

lnycm

您说的操作都做了,但是不行.我是用cactiuser导入的数据

Ksharp

把现在数据库已有的cacti创建的数据库drop掉再重新执行试试

lnycm

也试了,不行

remote_roamer

好像是cacti的数据库链接过多。我也遇到过这种问题。如果我频繁的刷新浏览器查看cacti的结果。会导致mysql很多链接不能释放。你可以重新启动一下apapche试试。我是这样解决的。

好像cacti的每次通过ie访问都会建立5个不释放的链接。不知道是不是bug。

[ 本帖最后由 remote_roamer 于 2006-12-7 00:40 编辑 ]

mynix

用root应该可以吧:
/usr/local/mysql/bin/mysql –u root –prootpw cactidb < cacti.sql

lnycm

用/usr/local/mysql/bin/mysql –u cactiuser –pcactipw cactidb < cacti.sql 可以导入数据，但是用http://ip/cacti的时候显示
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 cactidb < 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.