Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 11th October 2012, 19:38
malcolm_itdc malcolm_itdc is offline
Junior Member
 
Join Date: Oct 2012
Location: Tbilisi, Georgia
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default ISPConfig single server - not creating mysql databases

I am new to ISPConfig but followed the tutorial (http://www.howtoforge.com/perfect-se...ispconfig-3-p6) to install version 3 of it and it and worked fine.

Set nice and simple mysql passwords with no special characters etc.

Created first client in the admin page fine, created site and assigned to the client no problem.

Tried to create a database for a client, seemed to work however no database was created.

The record exists in the dbispconfig database table web_database, but its just not there.

I can log in the database as root from the command prompt no problem but neither the client user or database are being created as I would have expected.

I have read a few posts regarding problems with hostnames / ip addresses or permissions which may be causing the issue but cant find a definitive post stating the solution for me to try.

I am on Centos 6.3 and installed everything according to the tutorial. My other issue is I cant even find an error anywhere to say it has hit any problems at all. I have looked in /var/log, /var/log/ispconfig, /var/log/ispconfig/http, and the mysql.log as well and the only thing i can see is in the access log saying that it saw me edit the database in the web page exiting with a 200 http code.

I must be missing something huge somewhere to even find an error message of some sort.... any ideas would be appreciated !!!
Reply With Quote
Sponsored Links
  #2  
Old 12th October 2012, 10:19
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

Ensure that the mysql root password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.con is correct and you might want to take a look here for debug instructions: http://www.howtoforge.com/forums/showthread.php?t=58408
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 12th October 2012, 10:42
malcolm_itdc malcolm_itdc is offline
Junior Member
 
Join Date: Oct 2012
Location: Tbilisi, Georgia
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Thanks that helped a lot. The root password was set right. Turned out to be that cron wasnt running in the first place as when I run the job manually it created the databases I expected. Guess it just wasnt part of the install or is expected to be running anyway.

Plus now its good to know that tasks are run through that process in ispconfig which I didnt know before.

Thanks for your help !!
Reply With Quote
  #4  
Old 12th October 2012, 14:05
malcolm_itdc malcolm_itdc is offline
Junior Member
 
Join Date: Oct 2012
Location: Tbilisi, Georgia
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

1 more question.... if I want to change the mysql root password (as i set it simple till i proved things), do i just need to edit this file :/usr/local/ispconfig/server/lib/mysql_clientdb.conf or are there other places as well??
Reply With Quote
  #5  
Old 12th October 2012, 14:17
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

Thats the only place for the mysql root password.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 12th October 2012, 14:43
malcolm_itdc malcolm_itdc is offline
Junior Member
 
Join Date: Oct 2012
Location: Tbilisi, Georgia
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

cool! works fine. thanks
Reply With Quote
Reply

Bookmarks

Tags
centos 6.3, install, ispconfig 3

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
Sending mail ISPConfig 3 but not receivind catza Installation/Configuration 20 19th May 2010 12:47
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
ISPConfig 2.2.14 released till General 48 19th July 2007 23:46
Problems with Postfix Mysql Courier PatrickAdrichem Installation/Configuration 3 13th April 2007 15:44
Webmail Relay Error palkat General 17 23rd April 2006 18:12


All times are GMT +2. The time now is 06:04.


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