#1  
Old 28th September 2009, 17:20
kentsch kentsch is offline
Junior Member
 
Join Date: Aug 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error Adding a new server

I have an initial ISPCONFIG 3 server running and I am adding a second and am getting a GRANT error. The root user on the 1st box (master) has all rights to the database so I am confused as to the problem. Here is the dialog:

MySQL server hostname [localhost]:

MySQL root username [root]:

MySQL root password []: xxxxx

MySQL database to create [dbispconfig]:

MySQL charset [utf8]:

Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: y

MySQL master server hostname []: cp.hostname.com (I changed this name for the forum. The real hostname resolves just fine on the second box)

MySQL master server root username [root]:

MySQL master server root password []: xxxxx

MySQL master server database name [dbispconfig]:

Adding ISPConfig server record to database.

ERROR: Unable to create database user in master database: ispcsrv3 Error: You are not allowed to create a user with GRANT
Reply With Quote
Sponsored Links
  #2  
Old 28th September 2009, 17:32
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Looks strange indeed. Please try to login from the slave server to the master with the mysql command.
The command has to be executed on the shell of the slave server.

mysql -h cp.hostname.com -u root -p

and try to create a new user, e.g. test123" with grant.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 28th September 2009, 18:22
kentsch kentsch is offline
Junior Member
 
Join Date: Aug 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Till - I could login to the master server but I couldn't create the user. I went to the master server and gave root privileges to the mysql and information (cannot remember exact name) db's and then slave added fine.

I have the slave server added 3 times into the master db because of the grant error - I assume I can remove 2 of them by deleting from the proper place in the master db. Knowing how to do that would be helpful.

THanks again.
Reply With Quote
  #4  
Old 28th September 2009, 22:33
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
 
Default

You can delete the two wrong records from the "server" table in the master database e.g. with phpmyamin. The first record should be the one for the master server itself, the next tow ones should be the falsely added ones and the last one should be the correct record of the new slave server.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Tags
adding multiple servers

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
Random Questions dclardy General 9 3rd September 2009 23:39
I don't recieve mail. privir Installation/Configuration 2 3rd June 2009 22:08
Howtoforge the perfect Server(links) rini90 Installation/Configuration 0 14th December 2008 10:58
Problem with keeping Apache alive bobeq Server Operation 3 29th November 2007 16:11
Rejecting outbound mail tristanlee85 General 11 20th May 2007 17:04


All times are GMT +2. The time now is 21:37.


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