Does not create database using the panel

[andrelop]

Hello,

We have a Plesk 11 Linux server where users and the admin user can't create databases at all using the panel. This servers has also a remote database server (MySQL) configured and databases can't be created either using the local MySQL instance or this remote database server.

However, if we use the /opt/psa/bin/database binary we can create databases both locally and remotely using :

# /opt/psa/bin/database --create <database> -domain <domain> -type mysql -server <mysql_server_ip>:3306

If using the command above we can create the database and it appears on the panel. If we try to use the same parameters (database name, domain, etc) through the panel, as soon as we click the "OK" button after filling the database creation form, the OK button turns to "Wait" and it won't finish. We already tried it several times and waited for more than an hour.

Does anyone know what could be wrong in this case ?

 

[IgorG]

Have you tried to troubleshoot it with help of Plesk logs investigation?
http://kb.parallels.com/111283

 

[andrelop]

Have you tried to troubleshoot it with help of Plesk logs investigation?
http://kb.parallels.com/111283

IgorG,

The only line I can see in the logs while using the Plesk panel and trying to create the database is :

::ffff:1.2.3.4 server.domain:8443 - [22/Jul/2013:11:57:25 -0300] "GET /smb/database/create HTTP/1.1" 200 14033 "https://server.domain.ws:8443/smb/database/list" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.71 Safari/537.36"

This is the log of the database listing interface, which is generated when the database listing is accessed. No log is generated when the database creationg is called using the OK button. Tht button just turns to "Please Wait" and stays like this indefinitely. No timeout happens. The waiting goes on for hours if nothing is done.

Do you have any other idea ?

 

[andrelop]

IgorG,

The only line I can see in the logs while using the Plesk panel and trying to create the database is :

::ffff:1.2.3.4 server.domain:8443 - [22/Jul/2013:11:57:25 -0300] "GET /smb/database/create HTTP/1.1" 200 14033 "https://server.domain.ws:8443/smb/database/list" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.71 Safari/537.36"

This is the log of the database listing interface, which is generated when the database listing is accessed. No log is generated when the database creationg is called using the OK button. Tht button just turns to "Please Wait" and stays like this indefinitely. No timeout happens. The waiting goes on for hours if nothing is done.

Do you have any other idea ?

Just to let you guys know, a reboot fixed the problem. Don't know yet which was the problem, but it's gone now.