Re: Slave to host connection
You granted the proper priveleges for the slave machine on the master as specified in the instructions? You can ping each way? You have the master and slave port numbers set the same? They are both running the latest version? Running out of ideas. MCA Department PESIT wrote: Hi, i have edited the host file but still the error message is the same. There seems to be no problem in connecting the master to slave, but vice a versa, no luck. [root@linux] ~# mysql -h 192.168.1.2 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) Mathew At 09:07 AM 4/9/01 -0500, you wrote: To eliminate DNS problems, put each machine in the others /etc/hosts file. MCA Department PESIT wrote: Hi there, the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes, the master is running. the user name and password are correct. actually i dont think it gets to the state of actually verifying the user name and password. even if i do just a mysql -h 192.168.1.2 it gives me an immediate error at 192.168.1.5 [root@linux] /var/lib/mysql# mysql -h 192.168.1.2 -P 3306 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) there are no errors at the server side and the error log is clean Mathew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Slave to host connection
Hi there If you set the IP in mysql DB to localhost can you log on then with the right password and user name..? If you can the try changing it back. I always for get to flush my tables.! Simon -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 10 April 2001 14:59 To: MCA Department PESIT Cc: [EMAIL PROTECTED] Subject: Re: Slave to host connection You granted the proper priveleges for the slave machine on the master as specified in the instructions? You can ping each way? You have the master and slave port numbers set the same? They are both running the latest version? Running out of ideas. MCA Department PESIT wrote: Hi, i have edited the host file but still the error message is the same. There seems to be no problem in connecting the master to slave, but vice a versa, no luck. [root@linux] ~# mysql -h 192.168.1.2 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) Mathew At 09:07 AM 4/9/01 -0500, you wrote: To eliminate DNS problems, put each machine in the others /etc/hosts file. MCA Department PESIT wrote: Hi there, the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes, the master is running. the user name and password are correct. actually i dont think it gets to the state of actually verifying the user name and password. even if i do just a mysql -h 192.168.1.2 it gives me an immediate error at 192.168.1.5 [root@linux] /var/lib/mysql# mysql -h 192.168.1.2 -P 3306 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) there are no errors at the server side and the error log is clean Mathew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slave to host connection
i have granted the correct privileges to the slave machine on the master. like i said before it doesnt really come to that stage. had it come to that stage, it would have said something like Access Denied if the privileges were not proper. The 2 machines are able to ping each other. The versions are both new. for that matter, i created a user name on the slave machine and the master can connect to the slave using this. slave is 192.168.1.5 master is 192.168.1.2 i.e [at the master] mysql -h 192.168.1.5 -u master -p this is successful where master is a user name i created on the slave machine with appropriate privileges. [at the slave] mysql -h 192.168.1.2 -u slave -p does not work, where slave is a user name i created on the master machine with appropriate privileges. the error is [root@linux] ~# mysql -h 192.168.1.2 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) my etc/host file looks suspect, can you give me a typical example for a setup as mentioned above. although the entries seem okay, i will double check if you can give me a sample entry. my linux skills are limited hence the uncertainity. At 08:59 AM 4/10/01 -0500, you wrote: You granted the proper priveleges for the slave machine on the master as specified in the instructions? You can ping each way? You have the master and slave port numbers set the same? They are both running the latest version? Running out of ideas. MCA Department PESIT wrote: Hi, i have edited the host file but still the error message is the same. There seems to be no problem in connecting the master to slave, but vice a versa, no luck. [root@linux] ~# mysql -h 192.168.1.2 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) Mathew At 09:07 AM 4/9/01 -0500, you wrote: To eliminate DNS problems, put each machine in the others /etc/hosts file. MCA Department PESIT wrote: Hi there, the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes, the master is running. the user name and password are correct. actually i dont think it gets to the state of actually verifying the user name and password. even if i do just a mysql -h 192.168.1.2 it gives me an immediate error at 192.168.1.5 [root@linux] /var/lib/mysql# mysql -h 192.168.1.2 -P 3306 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) there are no errors at the server side and the error log is clean Mathew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slave to host connection
Hi there, the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes, the master is running. the user name and password are correct. actually i dont think it gets to the state of actually verifying the user name and password. even if i do just a mysql -h 192.168.1.2 it gives me an immediate error at 192.168.1.5 [root@linux] /var/lib/mysql# mysql -h 192.168.1.2 -P 3306 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) there are no errors at the server side and the error log is clean Mathew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slave to host connection
To eliminate DNS problems, put each machine in the others /etc/hosts file. MCA Department PESIT wrote: Hi there, the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes, the master is running. the user name and password are correct. actually i dont think it gets to the state of actually verifying the user name and password. even if i do just a mysql -h 192.168.1.2 it gives me an immediate error at 192.168.1.5 [root@linux] /var/lib/mysql# mysql -h 192.168.1.2 -P 3306 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) there are no errors at the server side and the error log is clean Mathew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slave to host connection
Hi there, the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes, the master is running. the user name and password are correct. actually i dont think it gets to the state of actually verifying the user name and password. even if i do just a mysql -h 192.168.1.2 it gives me an immediate error at 192.168.1.5 [root@linux] /var/lib/mysql# mysql -h 192.168.1.2 -P 3306 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) there are no errors at the server side and the error log is clean Mathew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php