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 25th January 2011, 16:42
AmpSys AmpSys is offline
Junior Member
 
Join Date: Dec 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem creating MySQL dbs in Multi-Server Configuration

Hey Guys,

Long time lurker, first time poster here.

We are running a multi-server ISPCONFIG3 platform which was setup per the Administrator guide for ISPCONFIG3.

The configuration is such that there are 5 dedicated ISPCONFIG servers as follows:
Code:
Server                                            |                   IP         
web1 (ISPCONFIG console loaded here)              |               10.10.10.15
mail1                                             |               10.10.10.14
ns1                                               |               10.10.10.11
ns2                                               |               10.10.10.13
db1                                               |               10.10.10.16
The installation guide was followed to the "T" - all servers are Debian Lenny 5.07 VMs.

There are no issue in creating sites, FTP users, adding/removing/editing DNS records, propagation of these between ns1 and ns2 servers, or problems with mail accounts/databases on mail1.

However, whenever we create a database & user, it is NOT being created at db1. Ironically, the first website and db we setup did work, but something since has broken and we can't seem to figure it out.

/etc/mysql/my.cnf has been checked and confirmed to be listening on all interfaces (both web1 and db1).

Does anyone have any suggestions/advice on what we can check to try and correct?

Thanks in advance for your help!
Reply With Quote
Sponsored Links
  #2  
Old 25th January 2011, 17:09
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,046
Thanks: 826
Thanked 5,386 Times in 4,231 Posts
Default

Have you changed the password of the mysql root user on the db server? If yous, please change it in /usr/local/ispconfig/server/lib/mysql_clientdb.conf file too or ispconfig is not able to create databases anymore.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 25th January 2011, 17:14
AmpSys AmpSys is offline
Junior Member
 
Join Date: Dec 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till View Post
Have you changed the password of the mysql root user on the db server? If yous, please change it in /usr/local/ispconfig/server/lib/mysql_clientdb.conf file too or ispconfig is not able to create databases anymore.
Hi Till,

Thanks for the quick reply! There haven't been any password changes to the MySQL root user (at least, best I know), but I'll check the file suggested and advise.

Question - does it matter if the root account on all servers use the same password?

*Edit - Confirmed - there have been no password changes after checking the file.

Last edited by AmpSys; 25th January 2011 at 17:24.
Reply With Quote
  #4  
Old 25th January 2011, 21:37
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,046
Thanks: 826
Thanked 5,386 Times in 4,231 Posts
Default

Please enable logelevel debug for the db server in ispconfig under system > server config. Then run:

/usr/local/ispconfig/server/server.sh

on the db server as root and post the output that you get on the screen.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 26th January 2011, 01:09
AmpSys AmpSys is offline
Junior Member
 
Join Date: Dec 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till View Post
Please enable logelevel debug for the db server in ispconfig under system > server config. Then run:

/usr/local/ispconfig/server/server.sh

on the db server as root and post the output that you get on the screen.
Here's the output:

Code:
db1:~# /usr/local/ispconfig/server/server.sh
25.01.2011-19:07 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
25.01.2011-19:07 - DEBUG - No Updated records found, starting only the core.
25.01.2011-19:07 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
finished.
Reply With Quote
  #6  
Old 26th January 2011, 08:24
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,046
Thanks: 826
Thanked 5,386 Times in 4,231 Posts
Default

Thats ok.

1) You are sure that you selected this db server as target for the new database and not one of the other nodes?
2) Have you deleted any records in the ispconfig database manually or did you try to reset ispconfig somehow after your first working tests?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 10:49
SSL don't work please help me walner8080 Installation/Configuration 8 26th September 2010 12:07
Need some Hints to "The Perfect Server - Debian Lenny (Debian 5.0) [ISPConfig 3]" wahid HOWTO-Related Questions 10 25th August 2010 15:18
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
subdomain and mail relay configuration aranthorn Installation/Configuration 24 3rd September 2007 22:53


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


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