#1  
Old 15th July 2010, 16:06
Gert-jan Gert-jan is offline
Junior Member
 
Join Date: Jul 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default Mysql on openSUSE 11.2 (i586)

Hi there,

I've a question:

I've installed Mysql (with YAST), but when i now want to start mysql i get an error:


Restarting service MySQL
Shutting down service MySQL done
Will update MySQL now, if you encounter any problems, please read following file:
/usr/share/doc/packages/mysql/README.SuSE
Running protected MySQL...
error: /var/run/mysql/protected/mysql.sock file didn't appeared...



I tried a lot but i don't know what to do now.
Can anyone help me?

greetz,

Gert-jan
Reply With Quote
Sponsored Links
  #2  
Old 16th July 2010, 10:27
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

Is this mysql an upgrade or a fresh installation?
Reply With Quote
The Following User Says Thank You to Mark_NL For This Useful Post:
Gert-jan (16th July 2010)
  #3  
Old 16th July 2010, 10:33
Gert-jan Gert-jan is offline
Junior Member
 
Join Date: Jul 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Mysql was already on that server and it worked.

but with some problems with the database, we've desided to remove mysql and reinstall it.......
And now it won't work......
Reply With Quote
  #4  
Old 16th July 2010, 10:57
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

Hmm make sure mysql is REALLY removed, don't upgrade OVER the old one, remove the old one first, then install the new version. should do the trick..

i'm reading a lot of threads and it always comes down to ppl who upgrade over the old one, instead of removing it first.


i assume the dir /var/run/mysql/protected/ exists?

what's the mysql socket location defined in your my.cnf?
Reply With Quote
  #5  
Old 16th July 2010, 11:04
Gert-jan Gert-jan is offline
Junior Member
 
Join Date: Jul 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Hi Mark,

First of all, thans for taking some time for me!

I've looked, and the dir /var/run/mysql/protected/ exists!
(It's an empty dir)

a part of the my.cnf (/etc/my.cnf):
-------------------------------------
[client]
#password = your_password
port = 3306
socket = /var/run/mysql/protected/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/run/mysql/protected/mysql.sock
skip-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
-----------------------------------------------



I re-installed mysql with yast.

First removed mysql and mysql client with yast, then rebooted the server, and then reinstalled mysql with yast.....
Reply With Quote
  #6  
Old 16th July 2010, 12:25
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

What user runs the mysqld process? is that user allowed to write in /var/run/mysql/protected ?

Code:
ps flax | grep mysql
grep mysql /etc/passwd
ls -al /var/run/mysql/protected
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Squirrelmail login failure Cracklefish Installation/Configuration 9 30th June 2010 20:38
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 11:27.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.