Ispconfig 3 mysql user problem

I created a database user, and after login through phpmyadmin with root access I couldn't find new user created. I found the user in table of ispconfig database but it didn't creat a mysql user. Some help pls ?


Best regards,

Andrej Sovanek

 

Update. I reinstalled whole os again and followed the steps in this tutorial. http://www.howtoforge.com/perfect-server-debian-wheezy-apache2-bind-dovecot-ispconfig-3-p5

Still got the same problem, adding mysql users via ispconfig doesn't create actuall mysql users...

Anyone got this problem ?

 

It's correct. It creates database all fine.

 

same problem

same problem for me.(ispconfig 3.0.5.2)
root password is correct in mysql_clientdb.conf.
does not create any mysql user or database.

 

I have the same problem

 

Hello,

I am working on ISP Config 3 till 3 weeks. I have installed ISP Config 3 on 2 machines. I have my procedure to install it for NGINX/PHP5FPM.

Today I am installing on a new VM a DEBIAN 8 / NGINX / PHP5FPM and Mysql server.

I am connecting fine on my page https:/ /myserver : 8080/ then login fine.

The problem is that when I create a "DB User" on "Sites" the user is never created.

I have done the configuration a lot of times since last 3 weeks. Today I reinstall 3 times my Debian 8 but I cannot understand where is the problem.
I am sure of my Mysql Root password.

I check it also here: cat /usr/local/ispconfig/server/lib/mysql_clientdb.conf this is good, when i Copy paste my password, I can enter fine in my phpmyadmin page.

is it something doing with Debian update? where can i find the problem that my DB User is never created?
I can see my new db mysql user in "ISPConfig" in "Database users" but never created on the mysqlserver and I cant see my user in "Database" when creating a new database.

 

Hello till. thanks for your message.

I have enter the "root" password only. (i have done 10 times the installation, and 3 times this morning on VMs).

Fo your information:

MySQL server hostname[localhost]:
MySQL root username[root]:
MySQL root password[]: I put text only here where I put password only Here (in the other (nothing)
MySQL database tocreate[dbispconfig]:
MySQL charset[utf8]:
The next two questions are about the internal ISPConfig database user andpassword.
It isrecommended toaccept the defaults which are'ispconfig'asusername andarandom password.
Ifyou useadifferent password,useonly numbers andchars forthe password.
ISPConfig mysql database username[ispconfig]:
ISPConfig mysql database password[437da0f1XXXXXXXXXXXXX]:

My :
root@XXXXXX:/home/supadm# cat /usr/local/ispconfig/server/lib/mysql_clientdb.conf
<?php

$clientdb_host = 'localhost';
$clientdb_user = 'root';
$clientdb_password = 'PASSSWORD';

I can connect fine on mysql with my "password" from here and I can see the "ispconfig table".

Should I reinstall another 4th time with entering "root" for username....?

I am a little I cannot understand why I can not create DB user from Ispconfig Panel.

many thanks

 

I did what you suggest to me.

I try to create a db user, no one has been created, I try to created DB, MY DB is Created without "user" linked in Ispconfig, I can see my DB in Phpmyadmin but no users.

18.12.2015-16:23 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
18.12.2015-16:23 - DEBUG - Found 2 changes, starting update process.
18.12.2015-16:23 - DEBUG - Calling function 'db_user_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_insert'.
18.12.2015-16:23 - DEBUG - Processed datalog_id 13
18.12.2015-16:23 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
18.12.2015-16:23 - DEBUG - Created MySQL database: c0databasetest
18.12.2015-16:23 - DEBUG - Processed datalog_id 14
18.12.2015-16:23 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock

please find enclosed the log also. I have some problem with "Unlinked OID".


many thanks

 

ok for php5-snmp.

my Mysql Password contains '%' and '@' as specials characters. (and it is the same as other root password on other vm)

I can create through phpmyadmin a new DB and I can also create a new user.
the problem remain on the creation of the user through my IspConfig3.

 

I created 2 test db in Ispconfig, but it is never attached a user in Ispconfig. -> I cant assign user because there are never "users" loaded in the list but you can see the users at the screenshot, they never have been created in Mysql.
I created 6 mysql user in Ispconfig but they never created in mysql.

I created on db through phpmyadmin name "test" and a user named "testx" with root login to test it.

please find the screenshot

 

Clearly, I am a little bit confused. I created one Client.
On this Client, I would like to created different "websites" and also different "mysql user", for example right now, I can't load my "db users" as you see in my screenshot.

1) i created 3 differents test user for a client.
2) they are never loaded through the Database (add)

 

I feell sorry, I did not understand why I did not check this setting.

I miss to put the "CLIENT" on the "WebSite", I apologize !

Sometimes, we go very fast and we missed some important step, finally my DB Users automated created after 1 min,

is it exactly a time when creating a db or user or something else for the CRON?

many thanks for your support Till,

have a wonderful day,