PDA

View Full Version : ubuntu problem with mysql socket



mark_
2007-10-25, 06:17
Hi

I've just tried to get my slimserver running within a Xen VM (ubuntu edgy) and have problems between the mysql and slimserver sockets. I used the slimdevices stable source in the sources.list and had not prior installation of MySQL. Now I find that netstat has port 3306 up on the loopback device 127.0.0.1 but no ports 9xxx. the /var/log/slimserver/slimserver.log has an error:

ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQL server through socket '/var/cache/slimserver/slimserver-mysql.sock' [2]

ps -ef | egrep "slim|mysql" shows that mysqld has a different socket.

Do I have to change the universal MySQL settings in /etc/mysql or can I force the use of /var/cache/slimserver/my.cnf (which looks like the correct MySQL config file for slimserver?)

Thanks

M

Mark Miksis
2007-10-25, 06:31
ps -ef | egrep "slim|mysql" shows that mysqld has a different socket.

What is the different socket? Can we see this output?

mark_
2007-10-25, 07:18
Thanks for the quick response Fletch... I had to mess around a bit with ssh / sftp to get the goods off without typing it by hand...

Regards

M

# ps -ef | egrep "slim|mysql"
root 6397 1 0 15:23 tty1 00:00:00 /bin/sh /usr/bin/mysqld_safe
mysql 6434 6397 0 15:23 tty1 00:00:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root 6435 6397 0 15:23 tty1 00:00:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
106 6482 1 0 15:23 ? 00:00:00 /bin/bash /usr/sbin/slimserver_safe /usr/sbin/slimserver --prefsfile /etc/slimserver/slimserver.pref --logfile /var/log/slimserver/slimserver.log --cachedir /var/cache/slimserver
root 7088 1 0 15:59 ? 00:00:00 /sbin/mount.smbfs \\server\music /srv/music -o ro username slimserver uid 106 gid 100 guest
106 7168 6482 5 16:12 ? 00:00:00 /usr/bin/perl -w /usr/sbin/slimserver --prefsfile /etc/slimserver/slimserver.pref --logfile /var/log/slimserver/slimserver.log --cachedir /var/cache/slimserver
root 7171 2761 0 16:12 tty1 00:00:00 grep -E slim|mysql

Mark Miksis
2007-10-25, 08:02
That looks like Ubuntu's mysql daemon. SS should start another mysqld using it's own defaults. Anything else interesting in slimserver.log, perhaps about not being able to find or start mysqld?

mark_
2007-10-25, 09:29
Hi Fletch

No nothing else of interest in the logs. I just restarted the VM to see. THis is about all:

2007-10-25 18:26:53 Slimserver died. Restarting.
2007-10-25 18:27:29.3401 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQL server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-25 18:27:30 Slimserver died. Restarting.



My guess is that the MySQL installed by the Debian stable package is using MySQL defaults rather than the Slimserver ones. There was no instance of MySQL before it ran apt-get install slimserver (using the slimdevices entry in sources.list)

Mark Miksis
2007-10-25, 09:44
No nothing else of interest in the logs.

How about in /var/cache/slimserver/mysql-error-log.txt?


There was no instance of MySQL before it ran apt-get install slimserver (using the slimdevices entry in sources.list)

This is normal. The slimserver deb requires mysql-server so it gets installed. Apparently it is set to start by default. SS should still start it's own instance unless you've specifically set it up not to.

mark_
2007-10-25, 10:33
No such file in /var/...
.
root@slimserv:/var# ls -l /var/cache/slimserver/mysql-error-log.txt
ls: /var/cache/slimserver/mysql-error-log.txt: No such file or directory
root@slimserv:/var# find /var/ -name "mysql-error-log.txt"
root@slimserv:/var#

Mark Miksis
2007-10-25, 10:44
OK, let's turn on some debugging. Can you start with --d_files --d_paths --d_startup --d_mysql?

mark_
2007-10-25, 11:32
Sorry for the long post. I've had to edit it to cut it down to the limit of 10000...

First time around I ran slimserver as root by accident (root is the only real user on this VM) [1], the second run was much shorter, with the --user slimserver.[2] It seemed to crash, so I rebooted and restarted it again with similar results [3].

root@slimserv:/var# which slimserver
/usr/sbin/slimserver

[1]
root@slimserv:/var# script slimserver.debug.log
Script started on Thu Oct 25 19:56:15 2007
qlot@slimserv:/var# /usr/sbin/slimserver --d_files --d_paths --d_startup --d_mys
Got @INC containing:
/usr/sbin
/etc/perl
/usr/local/lib/perl/5.8.8
/usr/local/share/perl/5.8.8
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.8
/usr/share/perl/5.8
/usr/local/lib/site_perl
.

Extended @INC to contain:
/usr/share/slimserver/lib
/usr/sbin
/etc/perl
/usr/local/lib/perl/5.8.8
/usr/local/share/perl/5.8.8
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.8
/usr/share/perl/5.8
/usr/local/lib/site_perl
.

Loaded module: [Time::HiRes] ok!
Loaded module: [DBD::mysql] ok!
Loaded module: [DBI] ok!
Loaded module: [XML::Parser::Expat] ok!
Loaded module: [HTML::Parser] ok!
Loaded module: [Compress::Zlib] ok!
Loaded module: [Digest::SHA1] ok!
Loaded module: [YAML::Syck] ok!
Loaded module: [GD] ok!
Module [Locale::Hebrew] failed to load: [Can't locate Locale/Hebrew.pm in @INC (@INC contains: /usr/share/slimserver/lib /usr/sbin /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at (eval 17) line 2.
BEGIN failed--compilation aborted at (eval 17) line 2.
]
The following modules are loaded after the first attempt:
YAML/Syck.pm => /usr/lib/perl5/YAML/Syck.pm
IO/Handle.pm => /usr/lib/perl/5.8/IO/Handle.pm
re.pm => /usr/lib/perl/5.8/re.pm
HTML/Parser.pm => /usr/lib/perl5/HTML/Parser.pm
File/Spec/Functions.pm => /usr/share/perl/5.8/File/Spec/Functions.pm
List/Util.pm => /usr/lib/perl/5.8/List/Util.pm
POSIX.pm => /usr/lib/perl/5.8/POSIX.pm
SelectSaver.pm => /usr/share/perl/5.8/SelectSaver.pm
/usr/lib/perl/5.8/auto/POSIX/load_imports.al => /usr/lib/perl/5.8/auto/POSIX/load_imports.al
Getopt/Long.pm => /usr/share/perl/5.8/Getopt/Long.pm
GD/Polygon.pm => /usr/lib/perl5/GD/Polygon.pm
Compress/Zlib.pm => /usr/lib/perl5/Compress/Zlib.pm
DBD/mysql.pm => /usr/lib/perl5/DBD/mysql.pm
Cwd.pm => /usr/lib/perl/5.8/Cwd.pm
warnings.pm => /usr/share/perl/5.8/warnings.pm
Slim/Utils/OSDetect.pm => /usr/share/perl5/Slim/Utils/OSDetect.pm
Digest/base.pm => /usr/share/perl/5.8/Digest/base.pm
Fcntl.pm => /usr/lib/perl/5.8/Fcntl.pm
Symbol.pm => /usr/share/perl/5.8/Symbol.pm
Scalar/Util.pm => /usr/lib/perl/5.8/Scalar/Util.pm
Exporter.pm => /usr/share/perl/5.8/Exporter.pm
File/Spec.pm => /usr/share/perl/5.8/File/Spec.pm
/usr/lib/perl/5.8/auto/POSIX/autosplit.ix => /usr/lib/perl/5.8/auto/POSIX/autosplit.ix
FindBin.pm => /usr/share/perl/5.8/FindBin.pm
warnings/register.pm => /usr/share/perl/5.8/warnings/register.pm
XSLoader.pm => /usr/lib/perl/5.8/XSLoader.pm
Slim/bootstrap.pm => /usr/share/perl5/Slim/bootstrap.pm
Digest/SHA1.pm => /usr/lib/perl5/Digest/SHA1.pm
Time/HiRes.pm => /usr/lib/perl/5.8/Time/HiRes.pm
IO/Seekable.pm => /usr/lib/perl/5.8/IO/Seekable.pm
XML/Parser/Expat.pm => /usr/lib/perl5/XML/Parser/Expat.pm
DBI.pm => /usr/lib/perl5/DBI.pm
GD/Image.pm => /usr/lib/perl5/GD/Image.pm
Config.pm => /usr/lib/perl/5.8/Config.pm
File/Basename.pm => /usr/share/perl/5.8/File/Basename.pm
IO.pm => /usr/lib/perl/5.8/IO.pm
Carp.pm => /usr/share/perl/5.8/Carp.pm
FileHandle.pm => /usr/share/perl/5.8/FileHandle.pm
File/Spec/Unix.pm => /usr/share/perl/5.8/File/Spec/Unix.pm
Exporter/Heavy.pm => /usr/share/perl/5.8/Exporter/Heavy.pm
vars.pm => /usr/share/perl/5.8/vars.pm
strict.pm => /usr/share/perl/5.8/strict.pm
constant.pm => /usr/share/perl/5.8/constant.pm
/usr/lib/perl5/auto/Compress/Zlib/autosplit.ix => /usr/lib/perl5/auto/Compress/Zlib/autosplit.ix
Config_heavy.pl => /usr/lib/perl/5.8/Config_heavy.pl
IO/File.pm => /usr/lib/perl/5.8/IO/File.pm
overload.pm => /usr/share/perl/5.8/overload.pm
AutoLoader.pm => /usr/share/perl/5.8/AutoLoader.pm
HTML/Entities.pm => /usr/lib/perl5/HTML/Entities.pm
lib.pm => /usr/lib/perl/5.8/lib.pm
GD.pm => /usr/lib/perl5/GD.pm
DynaLoader.pm => /usr/lib/perl/5.8/DynaLoader.pm

The following optional modules failed to load on the first attempt: [Locale::Hebrew] - will try again

Module [Locale::Hebrew] failed to load: [Can't locate Locale/Hebrew.pm in @INC (@INC contains: /usr/sbin /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at (eval 18) line 2.
BEGIN failed--compilation aborted at (eval 18) line 2.
]
The following modules are loaded after the second attempt:

[snip, I can live without Hebrew support quite well in fact]

The following optional modules failed to load: [Locale::Hebrew] after their second try.

2007-10-25 19:56:35.1284 ERROR: Cannot write to preferences file /root/slimserver.pref, any changes made will not be preserved for the next startup of the server

2007-10-25 19:56:35.1302 Use of uninitialized value in negation (-) at /usr/share/perl5/Slim/Utils/Misc.pm line 1157.
2007-10-25 19:56:35.1312 Use of uninitialized value in join or string at /usr/share/perl/5.8/File/Spec/Unix.pm line 37.
2007-10-25 19:56:35.1314 Use of uninitialized value in join or string at /usr/share/perl/5.8/File/Spec/Unix.pm line 37.
2007-10-25 19:56:35.4730 Checking for mDNSResponderPosix in /usr/sbin/Bin/x86_64-linux-gnu-thread-multi/mDNSResponderPosix
2007-10-25 19:56:35.4738 Checking for mDNSResponderPosix in /usr/sbin/Bin/linux/mDNSResponderPosix
2007-10-25 19:56:35.4743 Checking for mDNSResponderPosix in /usr/share/slimserver/Bin/mDNSResponderPosix
2007-10-25 19:56:35.4748 Checking for mDNSResponderPosix in /usr/local/sbin/mDNSResponderPosix
2007-10-25 19:56:35.4755 Checking for mDNSResponderPosix in /usr/local/bin/mDNSResponderPosix
2007-10-25 19:56:35.4760 Checking for mDNSResponderPosix in /usr/sbin/mDNSResponderPosix
2007-10-25 19:56:35.4765 Checking for mDNSResponderPosix in /usr/bin/mDNSResponderPosix
2007-10-25 19:56:35.4770 Checking for mDNSResponderPosix in /sbin/mDNSResponderPosix
2007-10-25 19:56:35.4776 Checking for mDNSResponderPosix in /bin/mDNSResponderPosix
2007-10-25 19:56:35.4781 Checking for mDNSResponderPosix in /usr/bin/X11/mDNSResponderPosix
2007-10-25 19:56:35.4787 Checking for mDNSResponderPosix in /usr/games/mDNSResponderPosix
2007-10-25 19:56:35.4793 Checking for mDNSResponderPosix in /usr/bin/mDNSResponderPosix
2007-10-25 19:56:35.4795 Checking for mDNSResponderPosix in /usr/local/bin/mDNSResponderPosix
2007-10-25 19:56:35.4796 Checking for mDNSResponderPosix in /usr/libexec/mDNSResponderPosix
2007-10-25 19:56:35.4797 Checking for mDNSResponderPosix in /sw/bin/mDNSResponderPosix
2007-10-25 19:56:35.4802 Checking for mDNSResponderPosix in /usr/sbin/mDNSResponderPosix
2007-10-25 19:56:35.4803 Found binary undef for mDNSResponderPosix
2007-10-25 19:56:35.5032 Use of uninitialized value in join or string at /usr/share/perl/5.8/File/Spec/Unix.pm line 37.
2007-10-25 19:56:35.5039 Use of uninitialized value in join or string at /usr/share/perl/5.8/File/Spec/Unix.pm line 37.
2007-10-25 19:56:35.5047 Use of uninitialized value in join or string at /usr/share/perl/5.8/File/Spec/Unix.pm line 37.
2007-10-25 19:56:35.5049 Use of uninitialized value in join or string at /usr/share/perl/5.8/File/Spec/Unix.pm line 37.
2007-10-25 19:56:35.5050 Use of uninitialized value in join or string at /usr/share/perl/5.8/File/Spec/Unix.pm line 37.
mkdir /MySQL: Permission denied at /usr/share/perl5/Slim/Utils/MySQLHelper.pm line 156
2007-10-25 19:56:35.5197 Use of uninitialized value in sprintf at /usr/share/perl5/Slim/Utils/MySQLHelper.pm line 467.
root@slimserv:/var# date
Thu Oct 25 19:56:41 CEST 2007
root@slimserv:/var#
root@slimserv:/var# exit

Script done on Thu Oct 25 19:56:49 2007

[2]
Then I ran is as user slimserver (the line wraps, unfortunately)

root@slimserv:/var# cat slimserver.debug.log
Script started on Thu Oct 25 20:02:15 2007
-d_startup --d_mysql/usr/sbin/slimserver --user slimserver --d_files --d_paths -
strict.pm did not return a true value at /usr/sbin/slimserver line 15.
BEGIN failed--compilation aborted at /usr/sbin/slimserver line 15.
root@slimserv:/var#
root@slimserv:/var#
root@slimserv:/var#
Script done on Thu Oct 25 20:04:01 2007
root@slimserv:/var#

[3]
After reboot... just to be thorough. (Line wrapped again...)

root@slimserv:~# /etc/init.d/slimserver stop
Stopping SlimServer Audio Server.
root@slimserv:~#
startup --d_mysql/usr/sbin/slimserver --user slimserver --d_files --d_paths --d_
strict.pm did not return a true value at /usr/sbin/slimserver line 15.
BEGIN failed--compilation aborted at /usr/sbin/slimserver line 15.
root@slimserv:~# tail -f /var/log/slimserver/slimserver.log
2007-10-25 20:23:40 Slimserver died. Restarting.
[snip]
2007-10-25 20:23:40 Slimserver died. Restarting.
2007-10-25 20:23:40 slimserver_safe stopped.

Mark Miksis
2007-10-25, 11:53
Running SS as root can mess things up by changing ownership of some files. Let's clean up and try again.

As root:


/etc/init.d/slimserver stop
rm /etc/slimserver/slimserver.conf
rm /var/log/slimserver/*
rm -rf /usr/share/slimserver/Cache/

Edit /etc/sysconfig/slimserver and add the debugging options to SLIMOPTIONS.

As root:


/etc/init.d/slimserver start

Look for errors in the log file. If this isn't the first time you've run SS as root, that could be the cause of your original problem

mark_
2007-10-25, 12:33
There was no /etc/sysconfig/slimserver, I there was an empty SLIMOPTIONS line in /etc/init.d/slimserver which I hope does the same thing.

root@slimserv:/etc/slimserver# grep -i options /etc/init.d/slimserver
SLIMOPTIONS=" --d_files --d_paths --d_startup --d_mysql"
$SLIMOPTIONS
$SLIMOPTIONS
root@slimserv:/etc/slimserver#

When I restart the thing it loops, looks broken...

root@slimserv:/etc/slimserver# /etc/init.d/slimserver start
root@slimserv:/etc/slimserver# tail -f /var/log/slimserver/slimserver.log

[...]
2007-10-25 21:31:01 Slimserver died. Restarting.
2007-10-25 21:31:01 Slimserver died. Restarting.
[...]

root@slimserv:/etc/slimserver# /etc/init.d/slimserver stop

Mark Miksis
2007-10-25, 12:42
There was no /etc/sysconfig/slimserver, I there was an empty SLIMOPTIONS line in /etc/init.d/slimserver which I hope does the same thing.

root@slimserv:/etc/slimserver# grep -i options /etc/init.d/slimserver
SLIMOPTIONS=" --d_files --d_paths --d_startup --d_mysql"
$SLIMOPTIONS
$SLIMOPTIONS
root@slimserv:/etc/slimserver#

Sorry, I'm mixing up Debian and Red Hat. Should be in /etc/default instead of /etc/sysconfig. Your edit to the init file won't quite work because the next few lines overwrite it with the empty string from the /etc/default file. Either edit the file in /etc/default or move your changes down a few lines after the file is read in.

mark_
2007-10-25, 12:46
OK

root@slimserv:/etc/slimserver# cat /etc/default/slimserver
# User to run slimserver as
SLIMUSER=slimserver

SLIMOPTIONS="--d_files --d_paths --d_startup --d_mysql"
root@slimserv:/etc/slimserver#
root@slimserv:/etc/slimserver# /etc/init.d/slimserver start root@slimserv:/etc/slimserver# tail -f /var/log/slimserver/slimserver.log

[snip]
2007-10-25 21:45:18 Slimserver died. Restarting.
2007-10-25 21:45:18 Slimserver died. Restarting.
2007-10-25 21:45:18 Slimserver died. Restarting.
2007-10-25 21:45:18 Slimserver died. Restarting.
[snip]

root@slimserv:/etc/slimserver# /etc/init.d/slimserver stop
Stopping SlimServer Audio Server.
root@slimserv:/etc/slimserver#

Mark Miksis
2007-10-25, 13:02
There's nothing else in the log except that one line? That message comes from slimserver_safe which I'm not really familiar with. I'm not sure why it would get stuck there...

mark_
2007-10-25, 13:11
yeah, keeps looping that line. Here we go:

root@slimserv:/etc/slimserver# head /var/log/slimserver/slimserver.log
2007-10-25 21:30:49 slimserver_safe started.
2007-10-25 21:30:49 Slimserver died. Restarting.
2007-10-25 21:30:49 Slimserver died. Restarting.
2007-10-25 21:30:49 Slimserver died. Restarting.
2007-10-25 21:30:50 Slimserver died. Restarting.
2007-10-25 21:30:50 Slimserver died. Restarting.
2007-10-25 21:30:50 Slimserver died. Restarting.
2007-10-25 21:30:50 Slimserver died. Restarting.
2007-10-25 21:30:50 Slimserver died. Restarting.
2007-10-25 21:30:50 Slimserver died. Restarting.
root@slimserv:/etc/slimserver# tail /var/log/slimserver/slimserver.log
2007-10-25 21:46:19 Slimserver died. Restarting.
2007-10-25 21:46:19 Slimserver died. Restarting.
2007-10-25 21:46:19 Slimserver died. Restarting.
2007-10-25 21:46:19 Slimserver died. Restarting.
2007-10-25 21:46:19 Slimserver died. Restarting.
2007-10-25 21:46:19 Slimserver died. Restarting.
2007-10-25 21:46:19 Slimserver died. Restarting.
2007-10-25 21:46:19 Slimserver died. Restarting.
2007-10-25 21:46:19 Slimserver died. Restarting.
2007-10-25 21:46:19 slimserver_safe stopped.
root@slimserv:/etc/slimserver# wc -l /var/log/slimserver/slimserver.log
12842 /var/log/slimserver/slimserver.log
root@slimserv:/etc/slimserver#

mark_
2007-10-26, 04:28
Hi Fletch

I tried to tinker with the MySQL instance to get it to start using the Slimserver settings in /var/cache/slimserver/my.cnf. This didn't work and I reset the settings.

Then I ran apt-get --purge mysql* and slimserver, deleted the /etc/mysql/, /etc/slimserver and /var/cache/slimserver folders, ran apt-get update and apt-get install slimserver using the testing repository in the sources.list, but it didn-t work so I've reinstalled the image (see next post)

Original MySQL:

root@slimserv:~# /etc/init.d/mysql status
/usr/bin/mysqladmin Ver 8.41 Distrib 4.1.15, for pc-linux-gnu on x86_64
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.1.15-Debian_1ubuntu5-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 14 hours 31 min 54 sec

Threads: 1 Questions: 27 Slow queries: 0 Opens: 21 Flush tables: 1 Open tables: 15 Queries per second avg: 0.001
root@slimserv#

I changed the /etc/init.d/mysql accordingly, but it didn't work.

root@slimserv:~# grep cnf /etc/init.d/mysql
#CONF=/etc/mysql/my.cnf
CONF=/var/cache/slimserver/my.cnf
MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
# mysqladmin likes to read /root/.my.cnf. This is usually not what I want
if [ ! -r /etc/mysql/my.cnf ]; then
/bin/echo -e "\nWARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz"
# * As a passwordless mysqladmin (e.g. via ~/.my.cnf) must be possible
root@slimserv:~#

Then I renamed these "my.cnf" files to "my.cnf.ORIG" and linked all of them to /var/cache/slimserver/my.cnf.

root@slimserv:~# mv /etc/mysql/my.cnf /etc/mysql/my.cnf.ORIG
root@slimserv:~# ln -s /var/cache/slimserver/my.cnf /etc/mysql/my.cnf

... stop / started them ...

root@slimserv:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/cache/slimserver/slimserver-mysql.sock' exists!
root@slimserv:~#

root@slimserv:~# rm /var/cache/slimserver/slimserver-mysql.sock
rm: cannot remove `/var/cache/slimserver/slimserver-mysql.sock': No such file or directory
root@slimserv:~#

/var/log/messages just has "slimserv -- MARK --" for this period.

mark_
2007-10-26, 04:57
Hi Fletch

Now I've recreated the VM using Ubuntu/Dapper, because I was hoping this'd be more stable. Now I've got base install with the *only* extra package installed via apt-get being slimserver from debian.slimdevices.com stable main (apart from some Samba packages). I've edited the allowedHosts and audiodir settings of /etc/slimserver/slimserver.pref but that is all. So it's clean now, but I'm still at the same problem with MySQL connections. I wonder if its possible to force the settings for whatever instance of MySQL is running?

# grep slim /etc/apt/sources.list
deb http://debian.slimdevices.com stable main

After the install the logfile reports:

# cat /var/log/slimserver/slimserver.log
2007-10-26 13:24:00 slimserver_safe started.
2007-10-26 13:24:05.0843 Use of uninitialized value in join or string at /usr/share/perl/5.8/File/Spec/Unix.pm line 36.
2007-10-26 13:24:05.0857 Use of uninitialized value in join or string at /usr/share/perl/5.8/File/Spec/Unix.pm line 36.
2007-10-26 13:24:36.2605 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQL server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-26 13:24:37 Slimserver died. Restarting.

# ps -ef | egrep "mysql|slim"
root 4822 1 0 13:23 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe
mysql 4859 4822 0 13:23 pts/0 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root 4860 4822 0 13:23 pts/0 00:00:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
106 4968 1 0 13:24 ? 00:00:00 /bin/bash /usr/sbin/slimserver_safe /usr/sbin/slimserver --prefsfile /etc/slimserver/slimserver.pref --logfile /var/log/slimserver/slimserver.log --cachedir /var/cache/slimserver
106 4970 4968 4 13:24 ? 00:00:01 /usr/bin/perl -w /usr/sbin/slimserver --prefsfile /etc/slimserver/slimserver.pref --logfile /var/log/slimserver/slimserver.log --cachedir /var/cache/slimserver
root 4975 3008 0 13:24 pts/0 00:00:00 grep -E mysql|slim

root@slimserv:~# /etc/init.d/mysql status
/usr/bin/mysqladmin Ver 8.41 Distrib 4.1.15, for pc-linux-gnu on x86_64
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.1.15-Debian_1ubuntu5-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 6 min 52 sec

Threads: 1 Questions: 27 Slow queries: 0 Opens: 21 Flush tables: 1 Open tables: 15 Queries per second avg: 0.066

After a reboot, the logfile loops slowly through until I stop the slimserver:

2007-10-26 13:51:14 Slimserver died. Restarting.
2007-10-26 13:51:48.6063 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQL server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-26 13:51:49 Slimserver died. Restarting.
2007-10-26 13:52:23.2758 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQL server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-26 13:52:23 Slimserver died. Restarting.
2007-10-26 13:52:58.3183 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQL server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-26 13:52:59 Slimserver died. Restarting.
2007-10-26 13:53:33.6562 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQL server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-26 13:53:34 Slimserver died. Restarting.
2007-10-26 13:54:09.8899 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQL server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-26 13:54:10 Slimserver died. Restarting.

mark_
2007-10-26, 05:26
... same results after I updated to Testing (6.5.5), but it was worth a try...

M

Mark Miksis
2007-10-30, 10:57
mark,

Please see the 2nd half of http://forums.slimdevices.com/showthread.php?t=39636. It looks like you need to install libgd-gd2-perl.

mark_
2007-10-30, 11:12
I just tried to restart the MySQL server by swapping /etc/mysql/my.cnf file with the /var/cache/slimserver/my.cnf version, as well as for /etc/mysql/debian.cnf but it didn't work.

Any ideas how I can get MySql to fire up using the Slimserver settings?

Thanks

root@slimserv:~# mv /etc/mysql/my.cnf /etc/mysql/my.cnf.orig
root@slimserv:~# cp /var/cache/slimserver/my.cnf /etc/mysql/my.cnf
root@slimserv:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.
root@slimserv:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
root@slimserv:~# touch /var/run/mysqld/mysqld.sock
root@slimserv:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
root@slimserv:~#

# grep "18:5" /var/log/debug.log
# grep "18:5" /var/log/debug
Oct 30 18:56:55 slimserv /etc/init.d/mysql[5908]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Oct 30 18:56:55 slimserv /etc/init.d/mysql[5908]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Oct 30 18:56:55 slimserv /etc/init.d/mysql[5908]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Oct 30 18:56:55 slimserv /etc/init.d/mysql[5908]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Oct 30 18:56:55 slimserv /etc/init.d/mysql[5908]:
Oct 30 18:57:18 slimserv /etc/init.d/mysql[6022]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Oct 30 18:57:18 slimserv /etc/init.d/mysql[6022]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Oct 30 18:57:18 slimserv /etc/init.d/mysql[6022]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)'
Oct 30 18:57:18 slimserv /etc/init.d/mysql[6022]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Oct 30 18:57:18 slimserv /etc/init.d/mysql[6022]:

/var/log/slimserver/slimserver.log sort of loops:

2007-10-30 19:05:59 Slimserver died. Restarting.
2007-10-30 19:06:35.8354 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQ
L server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-30 19:06:36 Slimserver died. Restarting.
2007-10-30 19:07:11.3852 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQ
L server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-30 19:07:13 Slimserver died. Restarting.
2007-10-30 19:07:48.0592 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQ
L server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-30 19:07:49 Slimserver died. Restarting.
2007-10-30 19:08:23.7934 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQ
L server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-30 19:08:25 Slimserver died. Restarting.
2007-10-30 19:09:00.2682 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQ
L server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-30 19:09:01 Slimserver died. Restarting.
2007-10-30 19:09:35.5739 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQ
L server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-30 19:09:36 Slimserver died. Restarting.
2007-10-30 19:10:11.9953 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQ
L server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-10-30 19:10:12 Slimserver died. Restarting.

mark_
2007-10-30, 11:38
Thanks... I think our posts crossed. I'll try it when the system is online again.

mark_
2007-11-02, 11:26
Hi

Installed libgd-gd2-perl as well as nearly everything else, and now I get more debug output. My music is mounted R/O on a Samba share BTW. At the bottom is the MySQL status and netstat -ant output.

/var/log/mysql.err and mysql.log are empty

/var/log/slimserver/slimserver.log loops with the following:

2007-11-02 18:20:00 Slimserver died. Restarting.
2007-11-02 18:20:03.8608 Got /srv/music from file url file:///srv/music
2007-11-02 18:20:03.9632 extracted: /srv/music from file:///srv/music
2007-11-02 18:20:03.9642 Got /var/cache/slimserver from file url file:///var/cache/slimserver
2007-11-02 18:20:03.9645 extracted: /var/cache/slimserver from file:///var/cache/slimserver
2007-11-02 18:20:04.9216 Checking for mDNSResponderPosix in /usr/sbin/Bin/x86_64-linux-gnu-thread-multi/mDNSResponderPosix
2007-11-02 18:20:04.9224 Checking for mDNSResponderPosix in /usr/sbin/Bin/linux/mDNSResponderPosix
2007-11-02 18:20:04.9226 Checking for mDNSResponderPosix in /usr/share/slimserver/Bin/mDNSResponderPosix
2007-11-02 18:20:04.9227 Checking for mDNSResponderPosix in /usr/local/sbin/mDNSResponderPosix
2007-11-02 18:20:04.9234 Checking for mDNSResponderPosix in /usr/local/bin/mDNSResponderPosix
2007-11-02 18:20:04.9236 Checking for mDNSResponderPosix in /sbin/mDNSResponderPosix
2007-11-02 18:20:04.9240 Checking for mDNSResponderPosix in /bin/mDNSResponderPosix
2007-11-02 18:20:04.9244 Checking for mDNSResponderPosix in /usr/sbin/mDNSResponderPosix
2007-11-02 18:20:04.9245 Checking for mDNSResponderPosix in /usr/bin/mDNSResponderPosix
2007-11-02 18:20:04.9249 Checking for mDNSResponderPosix in /usr/bin/mDNSResponderPosix
2007-11-02 18:20:04.9250 Checking for mDNSResponderPosix in /usr/local/bin/mDNSResponderPosix
2007-11-02 18:20:04.9251 Checking for mDNSResponderPosix in /usr/libexec/mDNSResponderPosix
2007-11-02 18:20:04.9253 Checking for mDNSResponderPosix in /sw/bin/mDNSResponderPosix
2007-11-02 18:20:04.9255 Checking for mDNSResponderPosix in /usr/sbin/mDNSResponderPosix
2007-11-02 18:20:04.9258 Found binary undef for mDNSResponderPosix
2007-11-02 18:20:04.9429 MySQLHelper: createConfig() Creating config from file: [/usr/share/slimserver/MySQL/my.tt] -> [/var/cache/slimserver/my.cnf].
2007-11-02 18:20:05.6383 MySQLHelper: init() Creating system tables..
2007-11-02 18:20:05.6400 Checking for mysqld in /usr/sbin/Bin/x86_64-linux-gnu-thread-multi/mysqld
2007-11-02 18:20:05.6402 Checking for mysqld in /usr/sbin/Bin/linux/mysqld
2007-11-02 18:20:05.6403 Checking for mysqld in /usr/share/slimserver/Bin/mysqld
2007-11-02 18:20:05.6403 Checking for mysqld in /usr/local/sbin/mysqld
2007-11-02 18:20:05.6407 Checking for mysqld in /usr/local/bin/mysqld
2007-11-02 18:20:05.6412 Checking for mysqld in /sbin/mysqld
2007-11-02 18:20:05.6416 Checking for mysqld in /bin/mysqld
2007-11-02 18:20:05.6421 Checking for mysqld in /usr/sbin/mysqld
2007-11-02 18:20:05.6422 Found binary /usr/sbin/mysqld for mysqld
2007-11-02 18:20:05.6423 MySQLHelper: startServer() About to start MySQL with command: [/usr/sbin/mysqld --defaults-file=/var/cache/slimserver/my.cnf]
2007-11-02 18:20:35.9041 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQL server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

2007-11-02 18:20:36 Slimserver died. Restarting

root@slimserv:~# /etc/init.d/mysql status
/usr/bin/mysqladmin Ver 8.41 Distrib 4.1.15, for pc-linux-gnu on x86_64
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.1.15-Debian_1ubuntu5-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 49 min 52 sec

Threads: 1 Questions: 31 Slow queries: 0 Opens: 21 Flush tables: 1 Open tables: 15 Queries per second avg: 0.010

root@slimserv:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.

root@slimserv:~# /etc/init.d/slimserver stop
Stopping SlimServer Audio Server.

root@slimserv:~# /etc/init.d/slimserver start
Starting SlimServer Audio Server.

root@slimserv:~# /etc/init.d/mysql status
MySQL is stopped.

root@slimserv:~# netstat -an
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 192.168.2.5:4722 192.168.1.2:445 ESTABLISHED
tcp6 0 0 :::22 :::* LISTEN

Mark Miksis
2007-11-02, 12:26
2007-11-02 18:20:05.6422 Found binary /usr/sbin/mysqld for mysqld
2007-11-02 18:20:05.6423 MySQLHelper: startServer() About to start MySQL with command: [/usr/sbin/mysqld --defaults-file=/var/cache/slimserver/my.cnf]
2007-11-02 18:20:35.9041 ERROR: MySQLHelper: createSystemTables() Couldn't connect to database: [Can't connect to local MySQL server through socket '/var/cache/slimserver/slimserver-mysql.sock' (2)]

OK, so it found mysqld but still couldn't start it for some reason.

What's the output of:
ps -ef | egrep 'slim|mysqld'
both after a start and after a stop?

Anything in /var/cache/slimserver/mysql-error-log.txt this time?

mark_
2007-11-03, 02:29
Hi Fletch

Thanks. I had a memory exception error and increased the RAM from 56MB to 128 MB.

* After issuing /etc/init.d/mysql stop & restarting both it seems to work.

I guess it's to do with the start order of the two daemons but need to experiment. Do you have any suggestions?

* There is no mysql-error-log.txt

root@slimserv:~# less /var/cache/slimserver/mysql-error-log.txt
/var/cache/slimserver/mysql-error-log.txt: No such file or directory
root@slimserv:~# ls /var/cache/slimserver/
MySQL my.cnf
root@slimserv:~# ls /var/cache/slimserver/MySQL/
root@slimserv:~# ls -la /var/cache/slimserver/MySQL/
total 8
drwxr-xr-x 2 slimserver nogroup 4096 Nov 2 18:09 .
drwxr-xr-x 3 slimserver nogroup 4096 Nov 2 18:09 ..
root@slimserv:~#

AFTER FRESH BOOT
root@slimserv:~# ps -ef | egrep 'slim|mysqld'
root 2734 1 0 08:48 ? 00:00:00 /sbin/mount.smbfs \\server\music /srv/music -o ro username slimserver uid 104 gid 100 guest
root 2938 1 0 08:48 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe
mysql 2978 2938 0 08:48 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root 2979 2938 0 08:48 ? 00:00:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
104 3021 1 0 08:48 ? 00:00:00 /bin/bash /usr/sbin/slimserver_safe /usr/sbin/slimserver --prefsfile /etc/slimserver/slimserver.pref --logfile /var/log/slimserver/slimserver.log --cachedir /var/cache/slimserver --d_files --d_paths --d_startup --d_mysql
104 3027 3021 3 08:48 ? 00:00:02 /usr/bin/perl -w /usr/sbin/slimserver --prefsfile /etc/slimserver/slimserver.pref --logfile /var/log/slimserver/slimserver.log --cachedir /var/cache/slimserver --d_files --d_paths --d_startup --d_mysql
104 3104 3027 0 08:48 ? 00:00:00 /usr/sbin/mysqld --defaults-file=/var/cache/slimserver/my.cnf
root 3133 3119 0 08:50 tty1 00:00:00 grep -E slim|mysqld
root@slimserv:~#

AFTER STOP
(Curious! MySQL is using the Slimserver defaults now!)
root@slimserv:~#
root@slimserv:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.
root@slimserv:~# /etc/init.d/slimserver stop
Stopping SlimServer Audio Server.
root@slimserv:~# ps -ef | egrep 'slim|mysqld'
root 2734 1 0 08:48 ? 00:00:00 /sbin/mount.smbfs \\server\music /srv/music -o ro username slimserver uid 104 gid 100 guest
104 3027 1 2 08:48 ? 00:00:02 /usr/bin/perl -w /usr/sbin/slimserver --prefsfile /etc/slimserver/slimserver.pref --logfile /var/log/slimserver/slimserver.log --cachedir /var/cache/slimserver --d_files --d_paths --d_startup --d_mysql
104 3168 3027 0 08:50 ? 00:00:00 /usr/sbin/mysqld --defaults-file=/var/cache/slimserver/my.cnf
root 3178 3119 0 08:50 tty1 00:00:00 grep -E slim|mysqld
root@slimserv:~#
root@slimserv:~#

RESTART SLIMSERVER ONLY
(looks better, included netstat output)
root@slimserv:~# /etc/init.d/slimserver start
Starting SlimServer Audio Server.
root@slimserv:~# ps -ef | egrep 'slim|mysqld'
root 2734 1 0 08:48 ? 00:00:00 /sbin/mount.smbfs \\server\music /srv/music -o ro username slimserver uid 104 gid 100 guest
104 3185 1 0 08:52 ? 00:00:00 /bin/bash /usr/sbin/slimserver_safe /usr/sbin/slimserver --prefsfile /etc/slimserver/slimserver.pref --logfile /var/log/slimserver/slimserver.log --cachedir /var/cache/slimserver --d_files --d_paths --d_startup --d_mysql
104 3187 3185 78 08:52 ? 00:00:02 /usr/bin/perl -w /usr/sbin/slimserver --prefsfile /etc/slimserver/slimserver.pref --logfile /var/log/slimserver/slimserver.log --cachedir /var/cache/slimserver --d_files --d_paths --d_startup --d_mysql
104 3188 3187 8 08:52 ? 00:00:00 /usr/sbin/mysqld --defaults-file=/var/cache/slimserver/my.cnf
root 3203 3119 0 08:52 tty1 00:00:00 grep -E slim|mysqld
root@slimserv:~#
root@slimserv:~# netstat -ant
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:9090 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:9092 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:9000 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:3483 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:9092 127.0.0.1:34952 ESTABLISHED
tcp 0 0 127.0.0.1:34955 127.0.0.1:9092 TIME_WAIT
tcp 0 0 127.0.0.1:34954 127.0.0.1:9092 TIME_WAIT
tcp 0 0 127.0.0.1:34953 127.0.0.1:9092 TIME_WAIT
tcp 0 0 127.0.0.1:34952 127.0.0.1:9092 ESTABLISHED
tcp 0 0 192.168.2.5:38036 192.168.1.2:445 ESTABLISHED
tcp6 0 0 :::22 :::* LISTEN
root@slimserv:~#

After starting up my slimdevice it downloaded the firmware and connected:

root@slimserv:~# !netstat
netstat -ant
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:9090 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:9092 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:9000 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:3483 0.0.0.0:* LISTEN
tcp 0 0 192.168.2.5:9090 192.168.2.3:52565 ESTABLISHED
tcp 0 0 127.0.0.1:9092 127.0.0.1:34952 ESTABLISHED
tcp 0 0 192.168.2.5:3483 192.168.1.4:32483 ESTABLISHED
tcp 0 0 127.0.0.1:34952 127.0.0.1:9092 ESTABLISHED
tcp 0 0 192.168.2.5:38036 192.168.1.2:445 ESTABLISHED
tcp6 0 0 :::22 :::* LISTEN
root@slimserv:~#

Mark Miksis
2007-11-03, 09:31
So this looks like it's all working, right?


* After issuing /etc/init.d/mysql stop & restarting both it seems to work.

I guess it's to do with the start order of the two daemons but need to experiment. Do you have any suggestions?

As I mentioned earlier, you should never have to manually start mysqld. If you're not using it for something else, just stop it and leave it stopped. Slimserver will start up it's own instance automatically. See here:


mysql 2978 2938 0 08:48 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock

This is the system daemon that slimserver doesn't need.


104 3104 3027 0 08:48 ? 00:00:00 /usr/sbin/mysqld --defaults-file=/var/cache/slimserver/my.cnf

This is the one that slimserver started itself.

mark_
2007-11-03, 11:57
OK, I stopped the MySQL init script, and rebooted to make sure. Great, it works!

I guess the MySQL startup links were added by default.

It's so nice to be able to listen to my music again. Thanks for your help & patience, Fletch!

root@slimserv:~# update-rc.d -f mysql remove
Removing any system startup links for /etc/init.d/mysql ...
/etc/rc0.d/K20mysql
/etc/rc1.d/K20mysql
/etc/rc2.d/K20mysql
/etc/rc3.d/K20mysql
/etc/rc4.d/K20mysql
/etc/rc5.d/K20mysql
/etc/rc6.d/K20mysql
root@slimserv:~#
root@slimserv:~# reboot