Koozali.org: home of the SME Server

startup error - mysql privileges

Offline Jáder

  • *
  • 1,099
  • +0/-0
    • LinuxFacil
startup error - mysql privileges
« on: March 11, 2011, 01:59:02 PM »
Hi

Big problem on a SME 7.5.x server.
background: server had several updates missing, so yesterday I did an ' yum update' and it show 170MB to update.
I did all updates and after hours (8pm) did the signal to post-upgrade/reboot.
Server did not returned! :(
And server is 50 km away.

Local technician is in front of server and say there are a problem with HDD (they´re RAID1) because startup stopped at "fixing mysql privileges" or something like that.

I ask for a disk check (on startup) and check stops at 3.7% with HDD light allways on! BAD NEWS.

I ask to remove 2nd HDD (older one) and try again: nothing... same error.

I ask to remove 1st HDD and try again: boot and stops at "LI" ... that´s strange... I think would be GRUB in use... this is a SME7.x server reinstalled some time ago!
  The same message occour if 2nd HDD is connected in place of 1st one.

I ask to a interative startup, it stops at "Message Bus" service... earlier than in a normal startup.

My only idea would be restart on new pair of HDDs, and try to recovery data from older after installation.


This idea would be start to be implemented in about to 4 hours (time to me to go till there and to they find a new pair of HDDs).

Other idea would be remove that script trying to fix mysql privileges and watch if server run without it.
I try switch to second console (CTRL+F2) but local person say it´s asking for username but after root is typed it never ask for password!
Even if this works I don´t know where find that script (/etc/init.d/local ??) to comment it...

Right now I´m a little lost... without GOOD ideas.

Anyone has another tip/idea ?

BTW: I´m sure this has a HDD media failure as primary reason.
I´m just not sure why second HDD just do not start right, as if 1st one has failed... maybe it failed too... but in this case appears to be a software (and not hardware failure) and I´ll report as bug on bugzilla.

Regards.

Jáder


...

Offline byte

  • *
  • 2,183
  • +2/-0
Re: startup error - mysql privileges
« Reply #1 on: March 11, 2011, 03:11:31 PM »
Local technician is in front of server and say there are a problem with HDD (they´re RAID1) because startup stopped at "fixing mysql privileges" or something like that.

Be good to find out exactly where it stopped rather than "something like that" :) and more details, also were the local tech able to switch terminal locally and log in or was the hardware locked/freezed i.e any response from pressing CAPS key ?


Quote
I ask for a disk check (on startup) and check stops at 3.7% with HDD light allways on! BAD NEWS.

How long did you wait once it stopped at 3.7% ?

Quote
I ask to remove 2nd HDD (older one) and try again: nothing... same error.

What error do you mean? Please give full details.

Quote
I ask to remove 1st HDD and try again: boot and stops at "LI"  ... that´s strange... I think would be GRUB in use... this is a SME7.x server reinstalled some time ago!  The same message occour if 2nd HDD is connected in place of 1st one.

Correct SME Server uses GRUB and the fact "LI" (http://linux.about.com/od/linux101/l/blnewbie4_1_2.htm) comes up tells you something is amiss

Quote
I try switch to second console (CTRL+F2) but local person say it´s asking for username but after root is typed it never ask for password!
Even if this works I don´t know where find that script (/etc/init.d/local ??) to comment it...

Strange again, was this server enabled with ssh to outside world?

Quote
BTW: I´m sure this has a HDD media failure as primary reason.
I´m just not sure why second HDD just do not start right, as if 1st one has failed... maybe it failed too... but in this case appears to be a software (and not hardware failure) and I´ll report as bug on bugzilla.

If it was harddrive failure then the "admin" would have received emails notifying them of an impending failure, also if it turns out to be the drives I hope a good backup is in place.

--[byte]--

Have you filled in a Bug Report over @ http://bugs.contribs.org ? Please don't wait to be told this way you help us to help you/others - Thanks!

Offline Jáder

  • *
  • 1,099
  • +0/-0
    • LinuxFacil
Re: startup error - mysql privileges
« Reply #2 on: March 12, 2011, 12:53:58 PM »
byte
Be good to find out exactly where it stopped rather than "something like that" :) and more details, also were the local tech able to switch terminal locally and log in or was the hardware locked/freezed i.e any response from pressing CAPS key ?
No, the console appears to work, caps is on/off as requested but HDD lights just stay on.
Remember HDD failure!
Quote
How long did you wait once it stopped at 3.7% ?
more than 10min...maybe 15min.
I went local, start SME using "linux rescue" and SME mounted partitions in /mnt/sysimage
Most of data was there so I copy it to another HDD.
Quote
Correct SME Server uses GRUB and the fact "LI" (http://linux.about.com/od/linux101/l/blnewbie4_1_2.htm) comes up tells you something is amiss
Yes... I'm new about RAID1 ... so I suspect RAID1 do not write the MBR, this HDD has been used as a SME6 previously (PLEASE don't make questions about this... it's a HDD IDE 80GB!)
Quote
Strange again, was this server enabled with ssh to outside world?
Yes, it was, so I tried to access it... but no go.
Even if SMB service was up (had past that point on startup on a normal boot), server was tottally offline.

Quote
If it was harddrive failure then the "admin" would have received emails notifying them of an impending failure, also if it turns out to be the drives I hope a good backup is in place.
That's strange to me too... I have all admin e-mails forwarded to a gmail account, just to be able to watch them without login each server... there is nothing there about hdd failure.


I'll considerate this problem as a warning... and learn more about RAID1 and MBR.
I'll make a lot of tests using old IDE 40GB HDD to learn how to fix this quickly... this was a nightmare: 6hours working to restore minimum capacity (coping some Firebird data and user data).
Now I have more work to restore/recover as many e-mails as possible from old HDD.

Thank you by your help... after my tests, I hope to document RAID1 recovery on wiki... for peace of mind of others when his time arrives! :)
...