Results 1 to 6 of 6

Thread: MySQL on VPS doin my head in!

  1. #1
    Not a good person scaryjim's Avatar
    Join Date
    Jan 2009
    Location
    Gateshead
    Posts
    15,196
    Thanks
    1,231
    Thanked
    2,291 times in 1,874 posts
    • scaryjim's system
      • Motherboard:
      • Dell Inspiron
      • CPU:
      • Core i5 8250U
      • Memory:
      • 2x 4GB DDR4 2666
      • Storage:
      • 128GB M.2 SSD + 1TB HDD
      • Graphics card(s):
      • Radeon R5 230
      • PSU:
      • Battery/Dell brick
      • Case:
      • Dell Inspiron 5570
      • Operating System:
      • Windows 10
      • Monitor(s):
      • 15" 1080p laptop panel

    MySQL on VPS doin my head in!

    Dunno if anyone will be able to help, but I've got some real issues with my VPS and I'm turning to Hexus - you're my only hope!

    Basically, a variety of services died on their rear ends yesterday, for no apparent reason. When I phoned support they claimed there was a node out last night, but that is meant to have been resolved now. However, today I couldn't get any websites or email services on my VPS.

    Tonight, I've SSHed to the server and managed to get Apache and q-mail started, but MySQL just will not start. I've had a look at the obvious log files and can't see anything useful, but I'm a long way from a linux expert these days.

    So, where should I be looking for more assistance? Which log file holds the critical piece of information I'm missing? And what's the best way to go about trying to start the service aside from using the script @ /etc/init.d/mysql (in case it's an issue with the start-up script)?

    AFAIK, the VPS runs MySQL 5.0.22 on Ubuntu 6.06, I've had a quck google but couldn't find anything immediately useful (my google-fu is weak )...


    EDIT
    OK, after poking around with Virtuozzo I found that there was an update available for MySQL on my VPS, installed it, and we're all good! No idea what scuppered it in the first place mind you. It's a good job I'm not sitting at my desk though - it'd have a head-shaped impression if I was
    Last edited by scaryjim; 18-05-2010 at 10:21 PM.

  2. #2
    Senior Member burble's Avatar
    Join Date
    May 2007
    Location
    Olney
    Posts
    1,138
    Thanks
    8
    Thanked
    90 times in 89 posts

    Re: MySQL on VPS doin my head in!

    Have a look in /var/log and see if there is anything MySQL related there. Also have a look at /var/log/messages and see if anything shows there when you try to start it.

    Are they really using Ubuntu 6.06? That was released in June (I think) 2006, so even if it were the LTS version (Long Term Support) it would be a couple of years out of support.

  3. Received thanks from:

    scaryjim (18-05-2010)

  4. #3
    Senior Member watercooled's Avatar
    Join Date
    Jan 2009
    Posts
    11,478
    Thanks
    1,541
    Thanked
    1,029 times in 872 posts

    Re: MySQL on VPS doin my head in!

    The server version is still supported until June 2011: http://en.wikipedia.org/wiki/Ubuntu_...elease_history

  5. #4
    Senior Member burble's Avatar
    Join Date
    May 2007
    Location
    Olney
    Posts
    1,138
    Thanks
    8
    Thanked
    90 times in 89 posts

    Re: MySQL on VPS doin my head in!

    So it is - I stand corrected.

  6. #5
    Not a good person scaryjim's Avatar
    Join Date
    Jan 2009
    Location
    Gateshead
    Posts
    15,196
    Thanks
    1,231
    Thanked
    2,291 times in 1,874 posts
    • scaryjim's system
      • Motherboard:
      • Dell Inspiron
      • CPU:
      • Core i5 8250U
      • Memory:
      • 2x 4GB DDR4 2666
      • Storage:
      • 128GB M.2 SSD + 1TB HDD
      • Graphics card(s):
      • Radeon R5 230
      • PSU:
      • Battery/Dell brick
      • Case:
      • Dell Inspiron 5570
      • Operating System:
      • Windows 10
      • Monitor(s):
      • 15" 1080p laptop panel

    Re: MySQL on VPS doin my head in!

    Yeah, I've spent most of the evening searching through everything in /var/log, with nothing obviously indicating what the problem was besides MySQL not starting! Sorted now thanks to the pragmatic approach of seeing if there's an update to the software that's failed, but I'm still not happy that I couldn't find anything. /var/log/messages has virtually nothing in it, /var/log/debug had the exact same messages I got from trying to start the service from the command line, and the mysql specific logs had nothing in them *at all*

    As to the age of Ubuntu 6.06, I took out the VPS at least 2, and possibly (more likely!) 3 years ago, and haven't bothered updating the software since then as it was doing everything I needed it to. But I was considering switching hosts this renewal anyway, so I'll probably end up on newer software be default

    Anyway, it's just another reinforcement of my need to move hosting...

  7. #6
    Gentoo Ricer
    Join Date
    Jan 2005
    Location
    Galway
    Posts
    11,048
    Thanks
    1,016
    Thanked
    944 times in 704 posts
    • aidanjt's system
      • Motherboard:
      • Asus Strix Z370-G
      • CPU:
      • Intel i7-8700K
      • Memory:
      • 2x8GB Corsiar LPX 3000C15
      • Storage:
      • 500GB Samsung 960 EVO
      • Graphics card(s):
      • EVGA GTX 970 SC ACX 2.0
      • PSU:
      • EVGA G3 750W
      • Case:
      • Fractal Design Define C Mini
      • Operating System:
      • Windows 10 Pro
      • Monitor(s):
      • Asus MG279Q
      • Internet:
      • 240mbps Virgin Cable

    Re: MySQL on VPS doin my head in!

    does mysqld start if you attempt to execute it directly?
    Quote Originally Posted by Agent View Post
    ...every time Creative bring out a new card range their advertising makes it sound like they have discovered a way to insert a thousand Chuck Norris super dwarfs in your ears...

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 12
    Last Post: 23-12-2008, 12:57 AM
  2. Do you want a Northern or Southern head with that pint?
    By 0iD in forum General Discussion
    Replies: 22
    Last Post: 30-10-2007, 05:58 PM
  3. MySQL extension for PHP 5.2.3 not working
    By Jerrythafast in forum Help! Quick Relief From Tech Headaches
    Replies: 18
    Last Post: 13-06-2007, 08:03 PM
  4. Making PHP and MySQL Talk?
    By Dav0s in forum Software
    Replies: 4
    Last Post: 18-09-2005, 10:53 PM
  5. Guy doesnt notice 5 inch knife going into his head
    By Swafe in forum General Discussion
    Replies: 3
    Last Post: 21-03-2005, 02:35 AM

Posting Permissions

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