Hi,
it's allready few years i use squeezebox audio devices, now we change to Squeezebox duet which doesn't work with slimserver anymore. thats why we have to move ahead to the new version squeezecenter 7.
first of all i installed the new port squeezecenter.7.2.1 on an testing server, it works fine. okee i thought now it's time to install on my liveserver but it doesnt work at all..
whats difefrent? 1. we have a mysql running allready with several db's on in. the port installer setup an seperate new mysql instance but i guess there is the problem..
as you can see tehre are conflicts with the main instance of my mysql server..
---------------------snip-------------------------------------
more mysql-error-log.txt
081126 13:34:47 InnoDB: Started; log sequence number 0 715949
081126 13:34:47 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
081126 13:34:47 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. The table is probably corrupted
081126 13:34:47 [ERROR] mysql.user has no `Event_priv` column at position 29
081126 13:34:47 [ERROR] Cannot open mysql.event
081126 13:34:47 [ERROR] Event Scheduler: An error occurred when initializing system tables.
081126 13:34:47 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.1.26-rc' socket: '/var/db/squeezecenter/cache/squeezecenter-mysql.sock' port: 9092 FreeBSD port: mysql-server-5.1.26
---------------------snap-------------------------------------
thats the first problem and i wish to have this squeezecenter in the same mysql as all the other db's too.
this is the squeezecenter's my.cf:
more my.cnf
---------------------snip-------------------------------------
# $Id$
#
# SqueezeCenter 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/local/squeezecenter/MySQL
datadir = /var/db/squeezecenter/cache/MySQL
language = /usr/local/squeezecenter/MySQL
port = 9092
socket = /var/db/squeezecenter/cache/squeezecenter-mysql.sock
pid-file = /var/db/squeezecenter/cache/squeezecenter-mysql.pid
log-error = /var/db/squeezecenter/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/db/squeezecenter/cache/squeezecenter-mysql.sock
---------------------snap-------------------------------------
does anyone have experience or any idea how i can succeed with this?
i'am relatively unexperienced in such things... ;-)
regards
marcel
it's allready few years i use squeezebox audio devices, now we change to Squeezebox duet which doesn't work with slimserver anymore. thats why we have to move ahead to the new version squeezecenter 7.
first of all i installed the new port squeezecenter.7.2.1 on an testing server, it works fine. okee i thought now it's time to install on my liveserver but it doesnt work at all..
whats difefrent? 1. we have a mysql running allready with several db's on in. the port installer setup an seperate new mysql instance but i guess there is the problem..
as you can see tehre are conflicts with the main instance of my mysql server..
---------------------snip-------------------------------------
more mysql-error-log.txt
081126 13:34:47 InnoDB: Started; log sequence number 0 715949
081126 13:34:47 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
081126 13:34:47 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. The table is probably corrupted
081126 13:34:47 [ERROR] mysql.user has no `Event_priv` column at position 29
081126 13:34:47 [ERROR] Cannot open mysql.event
081126 13:34:47 [ERROR] Event Scheduler: An error occurred when initializing system tables.
081126 13:34:47 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.1.26-rc' socket: '/var/db/squeezecenter/cache/squeezecenter-mysql.sock' port: 9092 FreeBSD port: mysql-server-5.1.26
---------------------snap-------------------------------------
thats the first problem and i wish to have this squeezecenter in the same mysql as all the other db's too.
this is the squeezecenter's my.cf:
more my.cnf
---------------------snip-------------------------------------
# $Id$
#
# SqueezeCenter 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/local/squeezecenter/MySQL
datadir = /var/db/squeezecenter/cache/MySQL
language = /usr/local/squeezecenter/MySQL
port = 9092
socket = /var/db/squeezecenter/cache/squeezecenter-mysql.sock
pid-file = /var/db/squeezecenter/cache/squeezecenter-mysql.pid
log-error = /var/db/squeezecenter/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/db/squeezecenter/cache/squeezecenter-mysql.sock
---------------------snap-------------------------------------
does anyone have experience or any idea how i can succeed with this?
i'am relatively unexperienced in such things... ;-)
regards
marcel