LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices



Reply
 
Search this Thread
Old 09-17-2007, 09:15 PM   #1
Swakoo
Member
 
Registered: Apr 2005
Distribution: Red Hat / Fedora / CentOS
Posts: 508

Rep: Reputation: 30
Exclamation Mysql problem: after changing root password, cannot start onboot


I have a master-master setup (using heartbeat) and recently, the 1st master password has been lost.. so I change it by stopping the service, and restarting it using --skip-grant-tables. thereafter i change it but when i try to restart the service I get a "MySQL manager or server PID file could not be found" error.

I tried removing my entire my.cnf and the service work. I figure it is something to do with the replication (corrupted?) but i have no idea how I should go about restoring/troubleshooting.. anyone can guide?

Right now, I manually start mysql by executing mysqld -uroot --relay-log=db1-relay-bin

Replication is still working, just that it cannot start on boot...



thanks!@

Last edited by Swakoo; 09-17-2007 at 10:37 PM.
 
Old 09-17-2007, 10:54 PM   #2
Swakoo
Member
 
Registered: Apr 2005
Distribution: Red Hat / Fedora / CentOS
Posts: 508

Original Poster
Rep: Reputation: 30
this is what is in the db1.hostname.err in /var/lib/mysql

Quote:
070918 10:06:11 InnoDB: Started; log sequence number 0 43655
^G/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.000036' not found (Errcode: 13)
070918 10:06:11 [ERROR] Failed to open log (file '/var/log/mysql/mysql-bin.000036', errno 13)
070918 10:06:11 [ERROR] Could not open log file
070918 10:06:11 [ERROR] Can't init tc log
070918 10:06:11 [ERROR] Aborting
 
Old 09-17-2007, 11:02 PM   #3
Swakoo
Member
 
Registered: Apr 2005
Distribution: Red Hat / Fedora / CentOS
Posts: 508

Original Poster
Rep: Reputation: 30
Ok I realise when I start mysql as "root" it works, but as "mysql" it doesn't

the following are the onscreen output as follows:

as 'root'
Quote:
[root@db1 mysql]# 070918 10:21:10 InnoDB: Started; log sequence number 0 43655
070918 10:21:10 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
070918 10:21:10 [Note] Starting crash recovery...
070918 10:21:10 [Note] Crash recovery finished.
070918 10:21:10 [Warning] 'user' entry 'root@db1.hostname.com' ignored in --skip-name-resolve mode.
070918 10:21:10 [Note] mysqld: ready for connections.
Version: '5.0.37-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
070918 10:21:10 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000017' at position 10949, relay log './db1-relay-bin.003698' position: 235
070918 10:21:10 [Note] Slave I/O thread: connected to master 'slave2@192.168.69.2:3306', replication started in log 'mysql-bin.000017' at position 10949
As 'mysql'
Quote:
[1] 7476
[root@db1 mysql]# 070918 10:21:01 InnoDB: Started; log sequence number 0 43655
mysqld: File '/var/log/mysql/mysql-bin.000038' not found (Errcode: 13)
070918 10:21:01 [ERROR] Failed to open log (file '/var/log/mysql/mysql-bin.000038', errno 13)
070918 10:21:01 [ERROR] Could not open log file
070918 10:21:01 [ERROR] Can't init tc log
070918 10:21:01 [ERROR] Aborting

070918 10:21:01 InnoDB: Starting shutdown...

[root@db1 mysql]# 070918 10:21:04 InnoDB: Shutdown completed; log sequence number 0 43655
070918 10:21:04 [Note] mysqld: Shutdown complete


[1]+ Exit 1 mysqld --user=mysql --relay-log=db1-relay-bin
Seems like they are pointing to different log files... no?

thanks again!
 
Old 09-18-2007, 05:37 AM   #4
Swakoo
Member
 
Registered: Apr 2005
Distribution: Red Hat / Fedora / CentOS
Posts: 508

Original Poster
Rep: Reputation: 30
ok i found out mine problem

somehow, the permissioning of the log files were switched to root, thereby create errcode 13, which is permission denied. i just chown the files back to mysql, and it work.

whew.

thanks for reading people!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql - problem on creating root password satimis Linux - Server 7 03-29-2007 03:12 AM
Problem setting root password after reinstalling mysql Venkatesh_cts Linux - Newbie 4 11-23-2006 09:05 AM
MySQL not starting after changing root password Temujin_12 Linux - Software 3 05-19-2006 11:40 AM
Big problem changed root password for mysql can't login pls comment johnnydangerous Linux - Software 5 07-08-2005 02:22 AM
mysql - problem with start and password CharlesButters Linux - General 0 11-09-2001 04:15 PM


All times are GMT -5. The time now is 07:25 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration