I can't see graphs

[emgongon]

Hi all, I have installed Red Hat Enterprise Linux AS release 3, , php-4.3.2.tar.gz, mysql-standard-4.0.26-pc-linux-gnu-i686-glibc23.tar.gz, rrdtool-1.0.49.tar.gz and cacti-0.8.6g.tar.gz. I can't see graphs, anyone can help me?

Too, this error:
Call to undefined function: mysql_connect() in /usr/local/apache2/htdocs/cacti-0.8.6g/lib/adodb/drivers/adodb-mysql.inc.php

[rkramer]

you can make it into cacti just not see graphs? That would be unusual if you get that message. If you did a compile of php you need to ensure it is compiled with mysql support, that error message indicates you do not have that in there.

[emgongon]

Hi, I can see graphs but I can´t insert data. Can you help me?

[rony]

What are the permissions of the mysql user that cacti users to access it's database?

Code: Select all

select * from mysql.user where User = '<cactiuser>';

Replace user with the user that cacti users.

[emgongon]

Hi rony, I have reviewed permissions of the mysql user that cacti users to access it's database and :

# /include/config.php

$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "melisa.upo.es";
$database_username = "cic";
$database_password = " ";

Code: Select all

mysql> select * from mysql.user where User = 'cic';
+---------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
| Host          | User | Password         | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections |
+---------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
| melisa.upo.es | cic  | N        | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          | N            | N          | N                     | N                | N            | N               | N                |          |            |             |              |             0 |           0 |               0 |
+---------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
1 row in set (0.00 sec)

what do you think about it?

[rony]

The user has no permissions.....

Run the following sql query to correct the issue:

Code: Select all

GRANT ALL ON cacti.* TO cactiuser@localhost;
flush privileges;