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)
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.
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.
Please see FAQ for debugging instructions: http://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/
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.
No, you did just 2 of the 3 nescessary steps, please reread the faq. Debugging has to be enabled in the ispconfig interface first.
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?