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)
-   -   Can't create database (http://www.howtoforge.com/forums/showthread.php?t=40765)

briandelshasta 6th November 2009 19:12

Can't create database
 
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 21: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 21: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 22: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 12:54

Quote:

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 15: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 15:51

Which ispconfig version?

rootfive 9th November 2009 18:59

ISPConfig 3.0.1.6 running on CentOS 5.4

s0l0n 6th June 2010 10:15

database shown in ISPConfig3 but not in Mysql
 
I have the same problem: database is shown as created in ISPConfig3 but it does not exists in Mysql. I've connected with user root in phpmyadmin and there is no database created.

I installed ispconfig 3.0.2.1 with centos 5.5 as in The Perfect Server - CentOS 5.5 x86_64 [ISPConfig 3]

There are no errors. I looks like ISPConfig doesn't even try to create the databases in MySql. It just insert them in dbispconfig database.

mike_p 7th June 2010 08:41

Quote:

Originally Posted by briandelshasta (Post 209896)
I've logged into the mysql cli and the database is not there.

How are you checking whether the database is there? If the mysql user you are logging in as doesn't have rights to the database, then it won't report it's existence.

If thats the case then your problem is the same as the other guys on this thread.

In all these cases, it has to be some unusual configuration because, obviously, the majority of people using ISPConfig don't have the problem.

@rootfive - the clear recommndation will be to upgrade to version 3.0.2.1


All times are GMT +2. The time now is 08:58.

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