Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #21  
Old 25th February 2010, 19:11
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,183
Thanks: 829
Thanked 5,415 Times in 4,258 Posts
Default

Yes, sorry I forgot that. Please redo the steps to truncate the database, remove this first warning line and then load the data back into the db. Afterwards install subeversion (on debian: apt-get install subversion) and run:

ispconfig_update.sh

then select svn as release. I already uploaded some fixes for the updater to avaoid the warning message problem that you ha dand the update should go trough then.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Sponsored Links
  #22  
Old 25th February 2010, 19:15
dclardy dclardy is offline
Senior Member
 
Join Date: Sep 2009
Location: Dallas, TX
Posts: 347
Thanks: 10
Thanked 47 Times in 28 Posts
Default

That fixed the issue. Everything is correctly filled in now. The update worked perfectly.
Reply With Quote
  #23  
Old 25th February 2010, 19:26
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,183
Thanks: 829
Thanked 5,415 Times in 4,258 Posts
Default

Good to hear that it works now
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #24  
Old 25th February 2010, 19:30
dclardy dclardy is offline
Senior Member
 
Join Date: Sep 2009
Location: Dallas, TX
Posts: 347
Thanks: 10
Thanked 47 Times in 28 Posts
Default

I tried to install another system, and join it to this one.

The users created in the mysql table have no permissions. What permissions should they have?

Also, what is the script that I run to force the server to connect to the remote mysql database.

Thanks.
Reply With Quote
  #25  
Old 25th February 2010, 19:33
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,183
Thanks: 829
Thanked 5,415 Times in 4,258 Posts
Default

Quote:
The users created in the mysql table have no permissions. What permissions should they have?
Before you want to add a slave, you will have to configure the root mysql user on the master server so that you are able to connect with the mysql root user from the slave to the master. So before you install ispconfig on the slave, test it on the slave with:

mysql -h master.server.com -u root -p

Quote:
Also, what is the script that I run to force the server to connect to the remote mysql database.
install.php does this all during installation. If you install failed, run the uninstall.php on the slave and afterwards install again after you corrected the root user permissions as I decribed above.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #26  
Old 25th February 2010, 19:39
dclardy dclardy is offline
Senior Member
 
Join Date: Sep 2009
Location: Dallas, TX
Posts: 347
Thanks: 10
Thanked 47 Times in 28 Posts
Default

My setup is just a little different. I have had multiple servers setup for awhile on my end. The user could connect no problem, but I am behind a router that I have built.

The ISPCOnfig user uses the correct IP address, but it still uses the server2.example.com name. I have to change it router.example.com. This allows that user to connect to the other mysql database. In a forum somewhere, I saw that you could force the slave to try to update its information by checking for changes. I was wondering what that command was. I have enabled debugging so that I can see if it is connecting properly.
Reply With Quote
  #27  
Old 25th February 2010, 19:44
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,183
Thanks: 829
Thanked 5,415 Times in 4,258 Posts
Default

There is no command that can force updates. But what you can do is to run:

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

as root on the shell and check the output. If there are pending updates for this server, you will seee them getting applied then. Also be aware that you have to enable debugging in the server settings in ispconfig now and not in the config file as it was before.

Also be aware that the permissions of the ispconfig user might have been changed, so its absolutely nescessary to run the 3.0.2 update on the slave and let ispconfig update the permissions and server settings, othwerwise you might get problems like you had with the apps vhost after the first failed update. So reconfiguring the root user to enable it to connect from the slave to the master and then run upadte.php on the slave is absolutely nescessary for a working setup.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.

Last edited by till; 25th February 2010 at 19:46.
Reply With Quote
  #28  
Old 25th February 2010, 19:51
dclardy dclardy is offline
Senior Member
 
Join Date: Sep 2009
Location: Dallas, TX
Posts: 347
Thanks: 10
Thanked 47 Times in 28 Posts
Default

That is what I was looking for. It just says finished.

It appears that everything is working fine. The sites are getting created. Mail works.

I am unable to login into ISPConfig on the slave. The passwords are different for the admin user. I have changed them it in phpmyadmin to try to make it work, but still no luck even after restarting mysql.

Am I missing something?
Reply With Quote
  #29  
Old 25th February 2010, 19:59
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,183
Thanks: 829
Thanked 5,415 Times in 4,258 Posts
 
Default

Quote:
I am unable to login into ISPConfig on the slave. The passwords are different for the admin user. I have changed them it in phpmyadmin to try to make it work, but still no luck even after restarting mysql.
Slaves in ispconfig never have an interface. If you would login into the interface on a slave, you would destroy the replication as you would get conflicting database entry and the replication script would stop.
__________________
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
ISPConfig installation into multiple OpenVZ containers letezo Installation/Configuration 11 3rd March 2009 22:47
ISPConfig 3.0.0.6 Beta released till General 38 21st September 2008 19:15
ISPConfig 2.3.2-dev released till General 9 4th June 2007 10:46
ISPConfig 2.3.1-dev released till General 0 8th May 2006 22:18
ISPConfig remoting plugin Beta 2 released till General 14 29th April 2006 14:13


All times are GMT +2. The time now is 12:36.


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