Well, *you* are the persistent one I think...
You mention "sudo /usr/sbin...." but on my machine I get a different
result when trying it, compared to trying "sudo -u squeezeboxserver
/usr/sbin..."
I have not idea what a database is. Considering the file is in a cache,
I *suppose* it could be removed ??
For reference, here is what I get on my machine wrt running mysql, and
the contents of the my.cnf file. As you see, the server fails when
launched as root, and works (sticks to much I have to kill it) when
invoked as user squeezeboxserver.
Code:
--------------------
m...@montreux$ ps waxun | grep mysql
1000 13281 0.0 0.0 7544 824 pts/1 S+ 17:41 0:00 grep mysql
m...@montreux$ ps waxun | grep squeeze
1000 13283 0.0 0.0 7544 820 pts/1 S+ 17:41 0:00 grep squeeze
m...@montreux$ sudo /usr/sbin/mysqld
--defaults-file=/var/lib/squeezeboxserver/cache/my.cnf
101014 17:41:31 [Warning] '--skip-locking' is deprecated and will be removed
in a future release. Please use '--skip-external-locking' instead.
101014 17:41:31 [Warning] '--default-character-set' is deprecated and will be
removed in a future release. Please use '--character-set-server' instead.
101014 17:41:31 [Warning] '--default-collation' is deprecated and will be
removed in a future release. Please use '--collation-server' instead.
101014 17:41:31 [ERROR] Fatal error: Please read "Security" section of the
manual to find out how to run mysqld as root!
101014 17:41:31 [ERROR] Aborting
101014 17:41:31 [Note] /usr/sbin/mysqld: Shutdown complete
m...@montreux$ sudo -u squeezeboxserver /usr/sbin/mysqld
--defaults-file=/var/lib/squeezeboxserver/cache/my.cnf
101014 17:41:51 [Warning] '--skip-locking' is deprecated and will be removed
in a future release. Please use '--skip-external-locking' instead.
101014 17:41:51 [Warning] '--default-character-set' is deprecated and will be
removed in a future release. Please use '--character-set-server' instead.
101014 17:41:51 [Warning] '--default-collation' is deprecated and will be
removed in a future release. Please use '--collation-server' instead.
^Z
[1]+ Stopped sudo -u squeezeboxserver /usr/sbin/mysqld
--defaults-file=/var/lib/squeezeboxserver/cache/my.cnf
m...@montreux$ ps waxun | grep mysql
0 13287 0.0 0.1 22420 1228 pts/1 T 17:41 0:00 sudo -u
squeezeboxserver /usr/sbin/mysqld
--defaults-file=/var/lib/squeezeboxserver/cache/my.cnf
108 13288 0.4 1.9 131624 19996 pts/1 Sl 17:41 0:00 /usr/sbin/mysqld
--defaults-file=/var/lib/squeezeboxserver/cache/my.cnf
1000 13301 0.0 0.0 7544 820 pts/1 S+ 17:42 0:00 grep mysql
m...@montreux$ sudo kill -9 13288 13287
[1]+ Killed sudo -u squeezeboxserver /usr/sbin/mysqld
--defaults-file=/var/lib/squeezeboxserver/cache/my.cnf
m...@montreux$ cat /var/lib/squeezeboxserver/cache/my.cnf
# $Id$
#
# Squeezebox Server specific MySQL Server config.
[mysqld]
innodb
skip-locking
# If you want to have user permissions - you need to setup a valid user, and
# remove this line below.
skip-grant-tables
basedir = /usr/share/squeezeboxserver/MySQL
datadir = /var/lib/squeezeboxserver/cache/MySQL
tmpdir = /var/lib/squeezeboxserver/cache/MySQL
language = /usr/share/mysql/english
port = 9092
socket = /var/lib/squeezeboxserver/cache/squeezebox-mysql.sock
pid-file = /var/lib/squeezeboxserver/cache/squeezebox-mysql.pid
log-error = /var/lib/squeezeboxserver/cache/mysql-error-log.txt
innodb_fast_shutdown = 1
max_connections = 4
thread_concurrency = 4
log-warnings = 0
bind-address = 127.0.0.1
default-character-set = utf8
default-collation = utf8_general_ci
key_buffer = 2M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
[client]
socket = /var/lib/squeezeboxserver/cache/squeezebox-mysql.sock
m...@montreux$
--------------------
--
epoch1970
Daily dose delivered by: 2 SB Classic (fw 130), 1 SB Boom (fw 50)
SqueezeCenter 7.3.4 (Debian 5.0) with plugins: ContextMenu,
SaverSwitcher by Peter Watkins Server Power Control by Gordon Harris
WeatherTime by Martin Rehfeld IRBlaster by Gwendesign (Felix)
FindArt, CDplayer by bpa BBC iPlayer, SwitchPlayer by Triode
PowerSave by Jason Holtzapple TrackStat by Erland Isaksson.
------------------------------------------------------------------------
epoch1970's Profile: http://forums.slimdevices.com/member.php?userid=16711
View this thread: http://forums.slimdevices.com/showthread.php?t=82338
_______________________________________________
unix mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/unix
