HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   ISPConfig 3 and creating db mysql from panel (http://www.howtoforge.com/forums/showthread.php?t=57907)

blustem 12th July 2012 13:08

ISPConfig 3 and creating db mysql from panel
 
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 13: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 13: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 13:27

Please see FAQ for debugging instructions:

http://www.faqforge.com/linux/debugg...-of-a-failure/

blustem 12th July 2012 13:39

nothing. command returns... finished.
I'm desperate. This is a server operating whit many domains...

till 12th July 2012 13:41

Quote:

nothing. command returns... finished.
Then you havent debugging enabled as decsribed in the faq.

blustem 12th July 2012 15:55

Quote:

Originally Posted by till (Post 281959)
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 18: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 19: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?


All times are GMT +2. The time now is 01:13.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.