PDA

View Full Version : Can't create database


briandelshasta
6th November 2009, 20:12
I've create a couple databases, both with the admin account and with client accounts. Now for some reason when I create a database in ISPConfig 3 is doesn't actually exist in mysql. ISPConfig does not seem to notice any problem and does display the database, but obviously no webapps can connect to the non-existent db.

Does anyone know where to begin troubleshooting this?

Thanks

rootfive
6th November 2009, 22:31
Database is created but it does not grant privileges to user. Use phpmyadmin to give privileges and it will be ok.

briandelshasta
6th November 2009, 22:45
Perhaps I wasn't clear. The database is not getting created. I've logged into the mysql cli and the database is not there.
I thinking some privs got messed up for the ispconfig user maybe, but I can't remember where to find those creds.

rootfive
6th November 2009, 23:06
I finished ispconfig3 this morning on CentOS5.4 and I have no problem creating database, the only problem is it does not grant rights.

till
7th November 2009, 13:54
I finished ispconfig3 this morning on CentOS5.4 and I have no problem creating database, the only problem is it does not grant rights.

Then you must have installed ispconfig with a wrong mysql user. When the installer aksks for a mysql user, you have to use the root user, otherweise ispconfig does not have the rights later to create new mysql users and databases.

rootfive
9th November 2009, 16:50
I installed with the right user. ISPConfig create the database and user. The only thing is it does not grant the permission to user for the created database. When I grant the user permission from myphpadmin it works fine. Otherwise joomla give me it cannot connect to database. I am not sure it is either bug or installation problem. I followed the procedure of perfect setup with ISPconfig 3 and centos5.4

Thanks

till
9th November 2009, 16:51
Which ispconfig version?

rootfive
9th November 2009, 19:59
ISPConfig 3.0.1.6 running on CentOS 5.4