User is not the replication it is 'root' (or) mysqladm Thanks, Dilipkumar Database Engineering mailto: dilipkumar.par...@eds.com Pager mail:9884430...@nma.vodafone.in
-----Original Message----- From: Shanmugam, Dhandapani Sent: Thursday, December 24, 2009 2:48 PM To: Parikh, Dilip Kumar; Jeetendra Ranjan; mysql@lists.mysql.com Subject: RE: Slave is not updated by the way did you flush the privileges on the master? What is the output you get, when you log in as root user on the mysql master server and issue the below command: select * from mysql.user where user='replication'\G; -D -----Original Message----- From: Parikh, Dilip Kumar [mailto:dilipkumar.par...@eds.com] Sent: Thursday, December 24, 2009 2:43 PM To: Jeetendra Ranjan; mysql@lists.mysql.com Subject: RE: Slave is not updated You can see in the logs, access denied So give trying for hostname or with full domain or Grant replication slave on *.* to 'mysqladm'@'95.%' identified by 'xxxxxx'; Grant replication slave on *.* to 'mysqladm'@'hostname identified by 'xxxxxx'; Flush privileges; it should work. Thanks, Dilipkumar Database Engineering mailto: dilipkumar.par...@eds.com Pager mail:9884430...@nma.vodafone.in -----Original Message----- From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com] Sent: Thursday, December 24, 2009 2:31 PM To: Shanmugam, Dhandapani; Parikh, Dilip Kumar; mysql@lists.mysql.com Subject: Re: Slave is not updated 091223 5:55:22 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000001' position: 4 091223 5:55:22 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 6:55:42 [Note] /usr/sbin/mysqld: Normal shutdown 091223 6:55:42 [Note] Slave I/O thread killed while connecting to master 091223 6:55:42 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 091223 6:55:42 [Note] Error reading relay log event: slave SQL thread was killed 091223 6:55:42 InnoDB: Starting shutdown... 091223 6:55:45 InnoDB: Shutdown completed; log sequence number 0 407843552 091223 6:55:45 [Note] /usr/sbin/mysqld: Shutdown complete 091223 6:58:30 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-97-74-85-42-bin' to avoid this problem. 091223 6:58:30 InnoDB: Started; log sequence number 0 407843552 091223 6:58:30 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 091223 6:58:30 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000001' position: 98 091223 6:58:30 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 7:03:32 [Note] /usr/sbin/mysqld: Normal shutdown 091223 7:03:32 [Note] Slave I/O thread killed while connecting to master 091223 7:03:32 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 091223 7:03:32 [Note] Error reading relay log event: slave SQL thread was killed 091223 7:03:32 InnoDB: Starting shutdown... 091223 7:03:33 InnoDB: Shutdown completed; log sequence number 0 407843552 091223 7:03:33 [Note] /usr/sbin/mysqld: Shutdown complete 091223 7:03:38 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-97-74-85-42-bin' to avoid this problem. 091223 7:03:38 InnoDB: Started; log sequence number 0 407843552 091223 7:03:38 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 091223 7:03:38 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000002' position: 98 091223 7:03:38 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 7:03:44 [Note] /usr/sbin/mysqld: Normal shutdown 091223 7:03:44 [Note] Slave I/O thread killed while connecting to master 091223 7:03:44 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 091223 7:03:44 [Note] Error reading relay log event: slave SQL thread was killed 091223 7:03:52 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-97-74-85-42-bin' to avoid this problem. 091223 7:03:52 InnoDB: Started; log sequence number 0 407843552 091223 7:03:52 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 091223 7:03:52 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000003' position: 98 091223 7:03:52 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 7:04:09 InnoDB: Error: table `horde/horde_sessionhandler` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html 091223 7:30:52 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111' errno: 2013 retry-time: 60 retries: 86400 091223 7:31:52 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 7:46:14 [Note] Slave I/O thread killed while connecting to master 091223 7:46:14 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 091223 7:46:14 [Note] Error reading relay log event: slave SQL thread was killed 091223 7:46:28 [Note] Slave SQL thread initialized, starting replication in log 'ip-208-109-238-76-bin.000041' at position 17907, relay log '/var/lib/mysql/mysql-relay-bin.000001' position: 4 091223 7:46:28 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 7:47:20 [Note] Slave I/O thread killed while connecting to master 091223 7:47:20 [Note] Slave I/O thread exiting, read up to log 'ip-208-109-238-76-bin.000041', position 17907 091223 7:47:20 [Note] Error reading relay log event: slave SQL thread was killed 091223 7:47:40 [Note] Slave SQL thread initialized, starting replication in log 'ip-208-109-238-76-bin.000041' at position 17906, relay log '/var/lib/mysql/mysql-relay-bin.000001' position: 4 091223 7:47:40 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 8:07:20 [Note] Slave I/O thread killed while connecting to master 091223 8:07:20 [Note] Slave I/O thread exiting, read up to log 'ip-208-109-238-76-bin.000041', position 17906 091223 8:07:20 [Note] Error reading relay log event: slave SQL thread was killed 091223 8:07:37 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000001' position: 4 091223 8:07:37 [ERROR] Slave I/O thread: error connecting to master 't...@201.107.236.77:3306': Error: 'Access denied for user 'test'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 8:12:59 [Note] Slave I/O thread killed while connecting to master 091223 8:12:59 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 091223 8:12:59 [Note] Error reading relay log event: slave SQL thread was killed 091223 8:13:12 [Note] Slave SQL thread initialized, starting replication in log 'ip-208-109-238-76-bin.000041' at position 174925, relay log '/var/lib/mysql/mysql-relay-bin.000001' position: 4 091223 8:13:12 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 8:15:19 [Note] Slave I/O thread killed while connecting to master 091223 8:15:19 [Note] Slave I/O thread exiting, read up to log 'ip-208-109-238-76-bin.000041', position 174925 091223 8:15:19 [Note] Error reading relay log event: slave SQL thread was killed 091223 23:19:24 [Note] /usr/sbin/mysqld: Normal shutdown 091223 23:19:24 InnoDB: Starting shutdown... 091223 23:19:27 InnoDB: Shutdown completed; log sequence number 0 407845542 091223 23:19:27 [Note] /usr/sbin/mysqld: Shutdown complete 091223 23:20:25 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-97-74-85-42-bin' to avoid this problem. 091223 23:20:25 InnoDB: Started; log sequence number 0 407845542 091223 23:20:25 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 091223 23:20:31 [Note] /usr/sbin/mysqld: Normal shutdown 091223 23:20:31 InnoDB: Starting shutdown... 091223 23:20:32 InnoDB: Shutdown completed; log sequence number 0 407845542 091223 23:20:32 [Note] /usr/sbin/mysqld: Shutdown complete 091223 23:20:37 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-97-74-85-42-bin' to avoid this problem. 091223 23:20:37 InnoDB: Started; log sequence number 0 407845542 091223 23:20:37 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 091223 23:55:20 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=ip-97-74-85-42-relay-bin' to avoid this problem. 091224 0:00:16 [Note] Slave SQL thread initialized, starting replication in log 'ip-208-109-238-76-bin.000042' at position 4436, relay log './ip-97-74-85-42-relay-bin.000001' position: 4 091224 0:00:16 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091224 1:04:48 [Note] Slave I/O thread killed while connecting to master 091224 1:04:48 [Note] Slave I/O thread exiting, read up to log 'ip-208-109-238-76-bin.000042', position 4436 091224 1:04:48 [Note] Error reading relay log event: slave SQL thread was killed 091224 1:07:59 [Note] Slave SQL thread initialized, starting replication in log 'ip-208-109-238-76-bin.000042' at position 4702, relay log './ip-97-74-85-42-relay-bin.000001' position: 4 091224 1:07:59 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 Thanks Jeetendra Ranjan ----- Original Message ----- From: "Shanmugam, Dhandapani" <dhandapani.shanmu...@eds.com> To: "Jeetendra Ranjan" <jeetendra.ran...@sampatti.com>; "Parikh, Dilip Kumar" <dilipkumar.par...@eds.com>; <mysql@lists.mysql.com> Sent: Thursday, December 24, 2009 2:15 PM Subject: RE: Slave is not updated > > > Jeetendra, > > Can you paste the error log here. > > -D > > -----Original Message----- > From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com] > Sent: Thursday, December 24, 2009 1:49 PM > To: Parikh, Dilip Kumar; mysql@lists.mysql.com > Subject: Re: Slave is not updated > > Hi Dilip, > > Thanks for your response > > I already run the below command at master: > > grant replication slave on *.* to 'mysqladm'@'95.84.86.41' identified by > 'admmysql'; > > > Thanks > Jeetendra Ranjan > > > ----- Original Message ----- > From: "Parikh, Dilip Kumar" <dilipkumar.par...@eds.com> > To: "Jeetendra Ranjan" <jeetendra.ran...@sampatti.com>; > <mysql@lists.mysql.com> > Sent: Thursday, December 24, 2009 1:10 PM > Subject: RE: Slave is not updated > > >> You can see connecting to master means it is not able to establish the >> connection from slave to master, give the grants as (replication > client >> etc..) >> and then try again. >> >> Thanks, >> Dilipkumar >> Database Engineering >> Pager mail:9884430...@nma.vodafone.in >> >> -----Original Message----- >> From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com] >> Sent: Thursday, December 24, 2009 1:05 PM >> To: mysql@lists.mysql.com >> Subject: Slave is not updated >> >> Hi, >> >> I am getting this information from slave >> >> mysql> show slave status \G; >> *************************** 1. row *************************** >> Slave_IO_State: Connecting to master >> Master_Host: 201.107.236.77 >> Master_User: root >> Master_Port: 3306 >> Connect_Retry: 60 >> Master_Log_File: ip-201-107-236-77-bin.000042 >> Read_Master_Log_Pos: 4702 >> Relay_Log_File: ip-95-84-86-41-relay-bin.000001 >> Relay_Log_Pos: 98 >> Relay_Master_Log_File: ip-201-107-236-77-bin.000042 >> Slave_IO_Running: No >> Slave_IO_Running: Yes >> Replicate_Do_DB: >> Replicate_Ignore_DB: >> Replicate_Do_Table: >> Replicate_Ignore_Table: >> Replicate_Wild_Do_Table: >> Replicate_Wild_Ignore_Table: >> Last_Errno: 0 >> Last_Error: >> Skip_Counter: 0 >> Exec_Master_Log_Pos: 4702 >> Relay_Log_Space: 98 >> Until_Condition: None >> Until_Log_File: >> Until_Log_Pos: 0 >> Master_SSL_Allowed: No >> Master_SSL_CA_File: >> Master_SSL_CA_Path: >> Master_SSL_Cert: >> Master_SSL_Cipher: >> Master_SSL_Key: >> Seconds_Behind_Master: NULL >> >> >> The Slave_IO_Running is always No even after repeating below steps so >> many times >> >> stop slave >> >> CHANGE MASTER TO .... >> >> and >> >> start slave >> >> >> >> Please guide why this is always NO and how do i enable it ? >> >> Regards >> Jeetendra Ranjan > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=dhandapani.shanmu...@eds.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dhandapani.shanmu...@eds.com
