Hi, I'm experiencing problems with SQL users after I had a disk problem. I've seen that ISP config stores clear SQL password for each user. I'm trying SQL login with the same password stored on DB but it's not working for any users. I'm using ISP Config 3.0.5.3 on Debian. What I have to do?
ISPConfig 3.0.5.3 is not storing mysql passwords in clertext in the db. If you created the database users in a old ispconfig version > 3.0.5, then they might be cleartext passwords. Do the mysql users exist in the mysql.mysql table?
I've installed ISP Config two years ago. Here is what I have on mysql user table: Code: mysql> select User from user; +------------------+ | User | +------------------+ | ispconfig | | root | | debian-sys-maint | | phpmyadmin | | root |
There seem to be all mysql users mising of the client databases. Do you have a backup of the mysql.mysql database, to restore them? If not, then you can try to use the resync feature of ispconfig to recreate the users, but I'am not sure if it works when there are no users there at all as it might just try to update them.
Logging via ISP Config I can see all SQL users. I tried to create a new one but it still can't login. It seems to be the same thing it happened to me on http://www.howtoforge.com/forums/showpost.php?p=307437&postcount=6
Yes... Code: <?php $clientdb_host = 'localhost'; $clientdb_user = 'root'; $clientdb_password = 'mypasswordhere'; ?>
