FreeBSD Port: squeezeboxserver-7.5.3, build okay but fails to start.

[Huib Smeets]

Hi,

just installed Squeezebox via ports collection on a clean installed FreeBSD 8.2 amd64, all dependencies where pulled in and the port was built without errors. 

Trying to start squezeboxserver fails, I starts but dies quicky:

/var/log/squeezeboxserver/server.log:

[11-03-04 22:28:10.0529] main::init (323) Starting Squeezebox Server (v7.5.3, r31792, Mon Jan 24 08:23:05 MST 2011) perl 5.010001
[11-03-04 22:28:46.0246] Slim::Utils::MySQLHelper::createSystemTables (510) FATAL: Couldn't connect to database: [Can't connect to local MySQL server through socket '/var/db/squeezeboxserver/cache/squeezebox-mysql.sock' (2)]

and in /var/db/squeezeboxserver/cache/mysql-error-log.txt

110304 22:28:13 InnoDB: The InnoDB memory heap is disabled
110304 22:28:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110304 22:28:13 InnoDB: Compressed tables use zlib 1.2.3
110304 22:28:13 InnoDB: Initializing buffer pool, size = 128.0M
110304 22:28:13 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
110304 22:28:13  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
110304 22:28:13  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
110304 22:28:13  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
110304 22:28:14  InnoDB: Waiting for the background threads to start
110304 22:28:15 InnoDB: 1.1.5 started; log sequence number 0
110304 22:28:15 [ERROR] /usr/local/libexec/mysqld: unknown option '--skip-locking'
110304 22:28:15 [ERROR] Aborting
110304 22:28:15  InnoDB: Starting shutdown...
110304 22:28:15  InnoDB: Shutdown completed; log sequence number 1595675
110304 22:28:15 [Note] /usr/local/libexec/mysqld: Shutdown complete

new tries to start keep complaining about the -skip-locking option

While installing squeezeboxserver it pulled in MySQL version 5.5.9

after commenting out the --skip-locking in MySQL/my.tt it does not start too, different error in var/db/squeezeboxserver/cache/mysql-error-log.txt

110304 23:22:56 InnoDB: The InnoDB memory heap is disabled
110304 23:22:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110304 23:22:56 InnoDB: Compressed tables use zlib 1.2.3
110304 23:22:56 InnoDB: Initializing buffer pool, size = 128.0M
110304 23:22:56 InnoDB: Completed initialization of buffer pool
110304 23:22:56 InnoDB: highest supported file format is Barracuda.
110304 23:22:56  InnoDB: Waiting for the background threads to start
110304 23:22:57 InnoDB: 1.1.5 started; log sequence number 1595675
110304 23:22:57 [ERROR] /usr/local/libexec/mysqld: unknown variable 'default-character-set=utf8'
110304 23:22:57 [ERROR] Aborting

110304 23:22:57  InnoDB: Starting shutdown...
110304 23:22:57  InnoDB: Shutdown completed; log sequence number 1595675
110304 23:22:57 [Note] /usr/local/libexec/mysqld: Shutdown complete

now it complains about an uknkown variable.

pkg_delete and new install: no succes, same error.

Hope this help to sort things out.

Huib Smeets
Netherlands