SQL issues with cacti server

[jtzako]

I recently took over admin of a redhat linux server that runs cacti to monitor thousands of network elements and have been having some issues.

The issues that ive been having is that the graphs have been having some big gaps in them and there are errors in the cacti logs indicating the SPINE poller lost connection to mysql.

I do not have access to the admin webpage for cacti (nobody has the login info) currently so that I will have to figure out at some point. I do have the root user/pass for the mysql database though.

Is there a guide someplace on troubleshooting cacti issues?

Any idea why I have the sql connection drops?
Any idea how I determine the login info for the cacti webpage?

[Rno]

User account is on the database, so you should be able to remove the password of Cacti user (admin), it's on Cacti database, SELECT * FROM `user_auth` the field on the table is password
it's an MD5 hash I think so you juste have to remove it. and then you will have access to Cacti GUI.

I'm using phpMyadmin to manage the database, that give my wome hint on how the mysql is working, and help to have information on it.
Other wise, you will have to figure out if the problem is the number of simultanous access to it.

maybe we can help if you provide log of cacti, and my.cnf

[jtzako]

User account is on the database, so you should be able to remove the password of Cacti user (admin), it's on Cacti database, SELECT * FROM `user_auth` the field on the table is password
it's an MD5 hash I think so you juste have to remove it. and then you will have access to Cacti GUI.

I'm using phpMyadmin to manage the database, that give my wome hint on how the mysql is working, and help to have information on it.
Other wise, you will have to figure out if the problem is the number of simultanous access to it.

maybe we can help if you provide log of cacti, and my.cnf

I'll look into getting phpMyAdmin installed and working so I can look into it further. I know I have some failed attempts and a LOT of aborted. Just not sure exactly why yet.