+ Post New Thread
Results 1 to 4 of 4
Virtual Learning Platforms Thread, Autoupdate killed mysql so no moodle in Technical; Just done an automatic update on opensuse and now mysql is not working propery I get this Code: rcmysql status ...
  1. #1

    Join Date
    Jan 2009
    Posts
    9
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Autoupdate killed mysql so no moodle

    Just done an automatic update on opensuse and now mysql is not working propery

    I get this
    Code:
    rcmysql status
    Checking for service MySQL: checkproc: Empty pid file /var/lib/mysql/mysqld.pid for /usr/sbin/mysqld
                                                                         unused
    SUSEMOODLE:~ # rcmysql try-restart
    checkproc: Empty pid file /var/lib/mysql/mysqld.pid for /usr/sbin/mysqld
    
                                                                         failed
    SUSEMOODLE:~ # rcmysql restart
    Restarting service MySQL 
    Shutting down service MySQL                                          done
    Updating MySQL privilege database... 
                                                                         failed
    Which means moodle does'nt work
    Error: Database connection failed.

    It is possible that the database is overloaded or otherwise not running properly.

    The site administrator should also check that the database details have been correctly specified in config.php

    Any ideas how to get mysql back up and running

  2. #2

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,812
    Thank Post
    110
    Thanked 585 Times in 506 Posts
    Blog Entries
    1
    Rep Power
    224
    Tried removing the pid file?

    Code:
    rm /var/lib/mysql/mysqld.pid

  3. #3

    Join Date
    Jan 2009
    Posts
    9
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    i can remove the file like you said
    but now get
    Code:
    Restarting service MySQL 
    Shutting down service MySQL                                          done
    Updating MySQL privilege database... 
                                                                         failed

  4. #4
    kesomir's Avatar
    Join Date
    Mar 2008
    Location
    London
    Posts
    288
    Thank Post
    15
    Thanked 28 Times in 23 Posts
    Rep Power
    18
    try setting ownership of /var/lib/mysql with whatever user runs mysql on opensuse.

    Make a copy first?

SHARE:
+ Post New Thread

Similar Threads

  1. Update Killed my server.
    By ICT_GUY in forum Windows Server 2008
    Replies: 18
    Last Post: 26th November 2008, 11:00 AM
  2. Oh my God, they killed Chef!
    By MK-2 in forum General Chat
    Replies: 3
    Last Post: 11th August 2008, 10:24 AM
  3. Pars Killed My Computer
    By FN-GM in forum MIS Systems
    Replies: 0
    Last Post: 20th December 2007, 07:36 PM
  4. Ofsted killed my intarweb!!!
    By Norphy in forum General Chat
    Replies: 30
    Last Post: 6th December 2006, 04:55 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •