cacti and mysql-proxy

[maxximus]

Hello,

I have Cacti 0.8.8a running a fedora 16 x64 server, using other server as mysql db. Recently I've installed mysql-proxy, to have HA on the mysql servers. All sites hosted on that server, using mysql-proxy are working fine (except cacti).
Cacti is not working with mysql. I've tried 2 minor sql configurations with different results:
1 - If I use the following configuration (cacti/include/config.php):
$database_hostname = "127.0.0.1";
$database_port = "3305";

when I try to open cacti via browser, I got the following error:
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'

2- - If I use the following configuration (cacti/include/config.php):
$database_hostname = "127.0.0.1:3305";
#$database_port = "3305";

Cacti opens OK, I can loggin to cacti, but data from servers is not updated

Anybody can help?
Thanks

[elbuit]

Are you sure that mysql are runing on tcp 3305 and not in tcp 3306?

Do a "telnet 127.0.0.1 3305"

Mysql listen at port 3306 by default.

[maxximus]

Hello Cacti team,

I've also the same problem with other versions of cacti. My actual version is 0.8.8c.
Can't understand why cacti does not work with mysql-proxy at port 3305.

Could this be a next release ou patch feature?

This is important for mysql HA architectures.

Hope you can help on this.

Best regards,
Nuno Carrilho

[maxximus]

Hello Cacti team,

Just to inform that I upgraded today cacti 0.8.8f to 0.8.8h.

Cacti DOES now work with mysql-proxy at 127.0.0.1 port 3305.

Thanks.