who is 'adconsent' ??. what is your replication user -naga
On Thu, Dec 24, 2009 at 3:01 PM, Jeetendra Ranjan < jeetendra.ran...@sampatti.com> wrote: > Here is the action i performed: > > mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO > 'xxxxxx'@'xx.xx.xx.xx' > IDENTIFIED BY 'xxxxxxxx'; > Query OK, 0 rows affected (0.00 sec) > > mysql> Flush privileges; > Query OK, 0 rows affected (0.00 sec) > > mysql> select * from mysql.user where user='adconsent' \G; > *************************** 1. row *************************** > Host: xx.xx.xx.xx > User: xxxxxxx > Password: *02BF3AAD3EDAAD0A1C45A98092B24BDC96172E16 > Select_priv: N > Insert_priv: N > Update_priv: N > Delete_priv: N > Create_priv: N > Drop_priv: N > Reload_priv: N > Shutdown_priv: N > Process_priv: N > File_priv: N > Grant_priv: N > References_priv: N > Index_priv: N > Alter_priv: N > Show_db_priv: N > Super_priv: N > Create_tmp_table_priv: N > Lock_tables_priv: N > Execute_priv: N > Repl_slave_priv: Y > Repl_client_priv: Y > Create_view_priv: N > Show_view_priv: N > Create_routine_priv: N > Alter_routine_priv: N > Create_user_priv: N > Event_priv: N > Trigger_priv: N > ssl_type: > ssl_cipher: > x509_issuer: > x509_subject: > max_questions: 0 > max_updates: 0 > max_connections: 0 > max_user_connections: 0 > 1 row in set (0.00 sec) > > > mysql> show slave status \G; > *************************** 1. row *************************** > Slave_IO_State: Connecting to master > Master_Host: xx.xx.xx.xx. > Master_User: xxxxx > > Master_Port: 3306 > Connect_Retry: 60 > Master_Log_File: ip-xxx-xxx-xxx-xx-bin.000042 > Read_Master_Log_Pos: 7220 > Relay_Log_File: ip-xx-xx-xx-xx-relay-bin.000001 > Relay_Log_Pos: 98 > Relay_Master_Log_File: ip-xxx-xxx-xxx-xx-bin.000042 > Slave_IO_Running: No > Slave_SQL_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: 7220 > > 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 > > > Thanks > Jeetendra Ranjan > ----- Original Message ----- From: "Shanmugam, Dhandapani" < > dhandapani.shanmu...@eds.com> > To: "Parikh, Dilip Kumar" <dilipkumar.par...@eds.com>; "Jeetendra Ranjan" > <jeetendra.ran...@sampatti.com>; <mysql@lists.mysql.com> > Sent: Thursday, December 24, 2009 2:47 PM > > 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 <mail%3a9884430...@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<mail%3a9884430...@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 >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=nagaraj....@gmail.com > >
