LxCenter HyperVM & Kloxo Support

Forum



Members   Search      Help    Register    Login    Home
Home » Kloxo Community Support » Clustering (Master and Slaves) » MySQL on Slave(can't connect to datbase from web)
MySQL on Slave [message #98413] Thu, 31 May 2012 21:21 Go to next message
cramerhwood is currently offline cramerhwood  United States
Messages: 23
Registered: September 2011
Location: Dallas, TX
Member
I just set up a Master and Slave scenario and I'm trying to use the slave as the MySQL server. I am unable to get any of my websites to run on the new setup as none of them can connect to the database. I have changed the DB connections to reflect my slave server's FQDN and I have also tried using the IP address. I have even tried using the root username and password. I woudl greatly appreciate any direction someone can provide.

There are also some errors when I log into PHPMyAdmin that may or my not be related saying "mysqli extension is missing". I have also attached a few screenshots.

index.php?t=getfile&id=1654&private=0
  • Attachment: 2.jpg
    (Size: 78.05KB, Downloaded 176 times)
Re: MySQL on Slave [message #98474 is a reply to message #98413] Mon, 04 June 2012 15:08 Go to previous messageGo to next message
cramerhwood is currently offline cramerhwood  United States
Messages: 23
Registered: September 2011
Location: Dallas, TX
Member
No one? I was able to get a connection to MySQL by opening ports in IPTables. I'm not sure if this is the best way, but it works. I also don't understand why there isn't any documentation on how this is done properly. The problem with mysqli extensions still exists in both the master and the slave. Again, Any help would be greatly appreciated.
Re: MySQL on Slave [message #98486 is a reply to message #98474] Tue, 05 June 2012 04:52 Go to previous message
com2 is currently offline com2  Spain
Messages: 1119
Registered: August 2007
Location: Spain
Senior Master
Developer
Just three things that come to mind without further investigation not in any particular order:


  • Did you open the MySQL port in your iptables setup?
  • Standard users in Kloxo are for localhost connections (from the webserver on the same host as MySQL). You'll have to tweak the user..
  • May be there should be changed something to the MySQL configuration /etc/my.cnf that it actually listens on the right IP address and not on 127.0.0.1



Previous Topic:Slave to Master
Next Topic:master / slave config
Goto Forum:
  


Current Time: Sun May 19 14:10:38 EDT 2013

Total time taken to generate the page: 0.01065 seconds
.:: Contact :: Home :: Privacy ::.

Click here to lend your support to: LxCenter and make a donation at www.pledgie.com !

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software