 |
|
|
|
Next: Performance of Oracle on Windows 7
|
| Author |
Message |
External
Since: Jan 13, 2012
Posts: 1
|
(Msg. 1) Posted: Fri Jan 13, 2012 9:48 am
Post subject: Replication - Can't connect to replication server
Archived from groups: comp>databases>mysql (more info?)
|
|
|
Master machine running Kubuntu 10.04, MySQL 5.1.41
Replication machine running Kubuntu 10.04, MySQL 5.1.41
Learning replication.
Attempting to set up replication of a small database. When I attempt to
start the slave i Get the error message:
ERROR 2003 (HY000) Can't connect to MySQL server on w.x.y.z (111)
from the slave machine, I can ping w.x.y.z.
I have tried to connect with several different users, but all return the
same error message.
Anything I look at says that the servers are running, correctly
configured, and ready to go.
So:
- what does the (111) at the end of the message tell me?
- What specific settings do I need to verify?
- What have I missed?
Thanks for your time. |
|
| Back to top |
|
 | |
External
Since: Oct 01, 2009
Posts: 27
|
(Msg. 2) Posted: Fri Jan 13, 2012 11:27 am
Post subject: Re: Replication - Can't connect to replication server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
William Colls wrote:
>
> Master machine running Kubuntu 10.04, MySQL 5.1.41
> Replication machine running Kubuntu 10.04, MySQL 5.1.41
>
> Learning replication.
>
> Attempting to set up replication of a small database. When I attempt to
> start the slave i Get the error message:
>
> ERROR 2003 (HY000) Can't connect to MySQL server on w.x.y.z (111)
>
> from the slave machine, I can ping w.x.y.z.
>
> I have tried to connect with several different users, but all return the
> same error message.
>
> Anything I look at says that the servers are running, correctly
> configured, and ready to go.
The above says otherwise 
I have found that on debian at least you need to reconfigure mysqld from
default to accept on other than the unix socket or the loopback interface.
I forget where the exact switch is, or what to do with it..mysqld.conf
probably.
>
> So:
> - what does the (111) at the end of the message tell me?
> - What specific settings do I need to verify?
> - What have I missed?
>
> Thanks for your time. |
|
| Back to top |
|
| |
External
Since: Sep 20, 2011
Posts: 5
|
(Msg. 3) Posted: Fri Jan 13, 2012 11:27 am
Post subject: Re: Replication - Can't connect to replication server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
William Colls wrote:
>
> Master machine running Kubuntu 10.04, MySQL 5.1.41
> Replication machine running Kubuntu 10.04, MySQL 5.1.41
>
> When I attempt to start the slave i Get the error message:
>
> ERROR 2003 (HY000) Can't connect to MySQL server on w.x.y.z (111)
>
> I can ping w.x.y.z.
Ping is not enough. The MySQL slave connects it's master
at TCP port 3306.
> So:
> - what does the (111) at the end of the message tell me?
~ $perror 111
OS error code 111: Connection refused
> - What specific settings do I need to verify?
Check firewalls. Check MySQL GRANT on the master.
You must create a slave user there and allow connections
from the slave IP (or name if you have working DNS)
> - What have I missed?
You can test connection with the normal mysql command line
client. Just start it on the slave and try to connect to
the master, using slave user and password.
XL >> Stay informed about: Replication - Can't connect to replication server |
|
| Back to top |
|
| |
External
Since: Jan 14, 2008
Posts: 245
|
(Msg. 4) Posted: Fri Jan 13, 2012 11:27 am
Post subject: Re: Replication - Can't connect to replication server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Oct 01, 2009
Posts: 27
|
(Msg. 5) Posted: Fri Jan 13, 2012 12:26 pm
Post subject: Re: Replication - Can't connect to replication server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: May 18, 2008
Posts: 18
|
(Msg. 6) Posted: Fri Jan 13, 2012 3:26 pm
Post subject: Re: Replication - Can't connect to replication server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On 13-01-2012 16:28, The Natural Philosopher wrote:
> William Colls wrote:
>>
>> Master machine running Kubuntu 10.04, MySQL 5.1.41
>> Replication machine running Kubuntu 10.04, MySQL 5.1.41
>>
>> Learning replication.
>>
>> Attempting to set up replication of a small database. When I attempt
>> to start the slave i Get the error message:
>>
>> ERROR 2003 (HY000) Can't connect to MySQL server on w.x.y.z (111)
>>
>> from the slave machine, I can ping w.x.y.z.
>>
>> I have tried to connect with several different users, but all return
>> the same error message.
>>
>> Anything I look at says that the servers are running, correctly
>> configured, and ready to go.
>
> The above says otherwise
>
> I have found that on debian at least you need to reconfigure mysqld from
> default to accept on other than the unix socket or the loopback interface.
>
> I forget where the exact switch is, or what to do with it..mysqld.conf
> probably.
It's skip-networking
http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysq...skip-ne
So, in your my.cnf you should NOT have a line:
skip-networking
Because, if you have that, MySQL wont listen on port 3306
You can verify that by doing this (on a linux prompt):
# netstat -antp | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 3522/mysqld
--
Luuk >> Stay informed about: Replication - Can't connect to replication server |
|
| Back to top |
|
| |
External
Since: Jan 14, 2008
Posts: 245
|
(Msg. 7) Posted: Mon Jan 16, 2012 7:17 am
Post subject: Re: Replication - Can't connect to replication server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Jan 13, 4:48 pm, The Natural Philosopher
wrote:
> Captain Paralytic wrote:
> > On Jan 13, 3:30 pm, Axel Schwenke wrote:
> >> Ping is not enough. The MySQL slave connects it's master
> >> at TCP port 3306.
> > Or even "its master"
>
> Oh no. The apostrophe wars have strayed again,..
Might be the one that Waterstones threw away! >> Stay informed about: Replication - Can't connect to replication server |
|
| Back to top |
|
| |
| Related Topics: | Inside firewall access to outside firewall MySQL server - I have 2 Suse 9.1 boxes with similar configurations. I'm in the process of moving some PHP code from one server (192.168.0.100) to another (192.168.0.102). MySQL is running on each server, and the same PHP code can access its respective localhost..
Installing MySQL-Cluster: can't start management server - Hi, I'm finally trying to set up a MySQL-CLuster with this tutorial ( http://dev.mysql.com/tech-resources/articles/mysql-cluster-for-two-servers.html ) on openSUSE 11.2. I've been past stage 1 and nearly stage 2, but when I try to start the management..
Best way to issue hundreds of inserts/updates??? - Using mysql 4.0.23- What is the best way to execute several (hundreds of) inserts and updates? Rather than issuing tons of individual inserts and updates, can I send the strings to a text file and then have mysql do them all?? IE : query.txt insert..
MySQL freezes, brings XP machine to a grinding halt - I've been using MySQL for a while for fairly light database development on my XP machine. Currently, I am just starting a new project and have experienced some big problems with MySQL today both on my office machine and at home where running a particular...
login as user 'root' but do not have root privlages and my.. - Hi gang: I'm experiencing a problem with MySQL -- I updated MySQL from version 4.1.0 to 4.1.10 and now when I login as root it doesn't show all the databases I should have access to, nor it doesn't recognize me being logged in as root (via.. |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
