Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 6th November 2009, 20:12
briandelshasta briandelshasta is offline
Junior Member
 
Join Date: Sep 2009
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 6th November 2009, 22:31
rootfive rootfive is offline
Junior Member
 
Join Date: Nov 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Database is created but it does not grant privileges to user. Use phpmyadmin to give privileges and it will be ok.
Reply With Quote
  #3  
Old 6th November 2009, 22:45
briandelshasta briandelshasta is offline
Junior Member
 
Join Date: Sep 2009
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Reply With Quote
  #4  
Old 6th November 2009, 23:06
rootfive rootfive is offline
Junior Member
 
Join Date: Nov 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I finished ispconfig3 this morning on CentOS5.4 and I have no problem creating database, the only problem is it does not grant rights.
Reply With Quote
  #5  
Old 7th November 2009, 13:54
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,045
Thanks: 841
Thanked 5,661 Times in 4,468 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 9th November 2009, 16:50
rootfive rootfive is offline
Junior Member
 
Join Date: Nov 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #7  
Old 9th November 2009, 16:51
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,045
Thanks: 841
Thanked 5,661 Times in 4,468 Posts
Default

Which ispconfig version?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #8  
Old 9th November 2009, 19:59
rootfive rootfive is offline
Junior Member
 
Join Date: Nov 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ISPConfig 3.0.1.6 running on CentOS 5.4
Reply With Quote
  #9  
Old 6th June 2010, 11:15
s0l0n s0l0n is offline
Junior Member
 
Join Date: Jun 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.
Reply With Quote
  #10  
Old 7th June 2010, 09:41
mike_p mike_p is offline
Senior Member
 
Join Date: Mar 2010
Location: Surrey, England
Posts: 140
Thanks: 9
Thanked 28 Times in 17 Posts
 
Default

Quote:
Originally Posted by briandelshasta View Post
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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot create mysql database cnocera Installation/Configuration 1 9th May 2009 19:20
Create mysql database uses host ip application uses hostname toolswizard General 3 5th March 2009 19:31
Create mysql database manually Danielss89 Installation/Configuration 1 17th January 2007 22:32
phpmyadmin can create a second database for 1 database plans? danf.1979 General 1 29th December 2005 14:29
./install doesn't create database benjami Installation/Configuration 3 26th November 2005 15:25


All times are GMT +2. The time now is 23:34.


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