View Full Version : ISPConfig 3 and creating db mysql from panel
blustem
12th July 2012, 12:08
Hi guys,
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!
System:
Debian 6 64
ISP Config 3.0.4.6 (updated)
till
12th July 2012, 12:12
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.
blustem
12th July 2012, 12:20
Hello Till,
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.
till
12th July 2012, 12:27
Please see FAQ for debugging instructions:
http://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/
blustem
12th July 2012, 12:39
nothing. command returns... finished.
I'm desperate. This is a server operating whit many domains...
till
12th July 2012, 12:41
nothing. command returns... finished.
Then you havent debugging enabled as decsribed in the faq.
blustem
12th July 2012, 14:55
Then you havent debugging enabled as decsribed in the faq.
Yes...
Before
* * * * * /usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log
After
#* * * * * /usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log
Then run command:
/usr/local/ispconfig/server/server.sh
Result "now"
/usr/bin/fail2ban-client
/sbin/iptables
/sbin/ip6tables
finished.
Re run and result is
finished.
till
12th July 2012, 17:14
No, you did just 2 of the 3 nescessary steps, please reread the faq. Debugging has to be enabled in the ispconfig interface first.
blustem
12th July 2012, 18:04
Ok Till,
I enabled debugging on ispconfig and the result is:
Creating db prova from ISPC and run by terminal
> /usr/local/ispconfig/server/server.sh
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
finished.
Second step
Removing db and run
> /usr/local/ispconfig/server/server.sh
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
finished.
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?
vBulletin® v3.8.7, Copyright ©2000-2013, vBulletin Solutions, Inc.