Mysql password problems

[lerra]

I have problems when i create databases in my ispconfig, when i create a database, i se that it gets created with mysql client but the password is not set! I saw that i my ispconfig account (when i installed ispconfig) only had access to ispconfig database and not to *, now i changed to * but it still did not work, my newly created account does not get a passwd thats working, i have tryed to login with mysql too but it does not work..:( Any tip?

[falko]

When you create a new database in ISPConfig, e.g. web1_db1 with the user web1_u1, you simply have to specify a password. You can then log in with web1_u1 and this password.
If you go to the database form in ISPConfig, the password isn't shown in the password field, but it's still active. Maybe this has confused you?

[lerra]

No, i copy the password and paste it to the form to make sure its that and paste it to phpmyadmin and it does not work. I use the webX_uX login and the password. Any hint where to start looking? Mysql error logs does not say a thing

[till]

You can try to ogin with your root user to the mysql db and check if the webX_uX user exists in the mysql database in the user table.

[lerra]

It seams like its my my.cnf configuration, i have user my-large.cnf a bit modified, when I use that one it does not work, but when I use the standard my.cnf it works great. Anybody that knows what the different is in my-large that makes that so I can not login with a user account. root accounts works but not useraccounts created in my ispconfig.

[lerra]

Update: Seams like it works when i restart mysql server (can be the large cnf too) then it works, shud it be like this? Atleast automated:) My system is 64bits.. :)

[till]

ISPConfig reloads the mysql server after changing a user account.

[lerra]

It seams like mine does not, where shud i start looking? Coud this be because I run a 64 bits system?

[till]

It seams like mine does not, where shud i start looking? Coud this be because I run a 64 bits system?

No, i guess it's not a 64bit issue. As you posted that everything works when you use another my.cnf configuration, you shall start to look where the differences are and why your other config prevents the mysql reloading.

[lerra]

This is not because of my configuration, it was because of a simple restart. I am running with default configfile, user cant login untill i manualy restart the mysql process in init.d. Is there any logoutput from ispconfig when dealing with the system?
Realy wierd, i thinkt it was because of my "huge" cnf but that was only because i have restarted, it works with that one too if i just restart the mysqld.

I cant be the only one that runned in to this problem? I have tryed to run thrue the forum, i will do it again to ensure that i have not missed somthing.

[nok]

mysql doesn't restart automatically for me - any clues why this may be?

[lerra]

Do you have the same problem that i have? We cant be the only ones?

[falko]

mysql doesn't restart automatically for me - any clues why this may be?
Any error messages? What's in the logs?

[nok]

what log files does ISP Config use?

[till]

what log files does ISP Config use?

Have a look at your messages ory syslog file. Also if there are any mysql related logfiles in /var/log or /var/log/mysql you shall check them.

[lerra]

Nothing else becide my manual restarts! I have grep'ed them all, realy wierd. What script is doing the restart of the mysql? Maybe a wrong path or somthing?

[falko]

It's /etc/init.d/mysql or /etc/init.d/mysqld, that depends on your distribution.

[nok]

It's /etc/init.d/mysql or /etc/init.d/mysqld, that depends on your distribution.


what file of the ISPConfig does the restart (calls the restart of mysql)?


I'm using Debian Sarge

[falko]

It's in /root/ispconfig/scripts/lib/config.lib.php.

[lerra]

I use Debian Sarge too, I cant locate where in the config file when its executed, or it maybe restarts thrue mysql?
Nok, are u using root account for mysql when u installed ispconfig or did u create a ispconfig account? I created a ispconfig account..

[falko]

You must install ISPConfig as root!

[lerra]

Ow! How shud I do now? Is it posseble to just change the account to root?
I dont remember seeing that it was written that root account was a must, anyway:)

[falko]

Is ISPConfig working (can you log in)?
What's the name of the MySQL user in /home/admispconfig/ispconfig/lib/config.inc.php?

[lerra]

Yes, everything else becide mysql is working good. I created it with almoste all rights i think...
Cant find the row that the user info is at but its named ispconfig,

select * from user where User="ispconfig";
gave this

--------+-------------+--------------+---------------+-------------+-----------------+
| 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 |
+-----------+-----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
| localhost | ispconfig | xxxxxxxxxxxxxxxx | Y | Y | Y | Y | Y | Y | N | N | Y | N | N | N | Y | N | Y | N | Y | Y | N | N | N | | | | | 0 | 0 | 0 |
+-----------+-----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+


(copy paste to notepad or something to make it more readeble.

[lerra]

Wow, seams like its working, changed /home/admispconfig/ispconfig/lib/config.inc.php row 78 79 to root and rootpasswd and it worked:) Falk, please tell me if there is somthing critical with this:) Thansk for a great software

[falko]

Falk, please tell me if there is somthing critical with this:)No, that's the way it is intended to be.