ISPConfig 3 and creating db mysql from panel
I have a problem that occurred yesterday and is as follows:
In panel ISPConfig 3, I created a new user, domain, database, and ... surprise, the database is not created!
I made other attempts, but the problem persists. ISPC does not seem to make the necessary operations to create user / database.
Through the tool mysql with the command show databases, the database engine does not actually exist;
the query select * from mysql.user I verified that the user is not created.
I do not know how to fix it.
Please help me. Thank you!
Debian 6 64
ISP Config 126.96.36.199 (updated)
The most likely reason is that you changed the mysql root password in the mysql database without changing it in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf as well.
having said that the root password was not changed,
password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf and password in the database match.
Please see FAQ for debugging instructions:
nothing. command returns... finished.
I'm desperate. This is a server operating whit many domains...
* * * * * /usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log
#* * * * * /usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log
Then run command:
Re run and result is
No, you did just 2 of the 3 nescessary steps, please reread the faq. Debugging has to be enabled in the ispconfig interface first.
I enabled debugging on ispconfig and the result is:
Creating db prova from ISPC and run by terminal
12.07.2012-15:38 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
12.07.2012-15:38 - DEBUG - Found 1 changes, starting update process.
12.07.2012-15:38 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
12.07.2012-15:38 - DEBUG - Created MySQL database: test
12.07.2012-15:38 - DEBUG - Processed datalog_id 1187
12.07.2012-15:38 - DEBUG - Remove Lock: usr/local/ispconfig/server/temp/.ispconfig_lock
Removing db and run
12.07.2012-15:43 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
12.07.2012-15:43 - DEBUG - Found 1 changes, starting update process.
12.07.2012-15:43 - DEBUG - Calling function 'db_delete' from plugin 'mysql_clientdb_plugin' raised by event 'database_delete'.
12.07.2012-15:43 - DEBUG - Dropping MySQL user: test
12.07.2012-15:43 - DEBUG - Dropping MySQL database: prova
12.07.2012-15:43 - DEBUG - Processed datalog_id 1189
12.07.2012-15:43 - DEBUG - Remove Lock: usr/local/ispconfig/server/temp/.ispconfig_lock
The db "prove" is correctly created and dropped in mysql only if I run /usr/local/ispconfig/server/server.sh
And now? I try to replace the crontab?
|All times are GMT +2. The time now is 01:08.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.