Ok, I got it working and just in case it might help somebody else I will
post what I had to do:
First I followed all of the Moose instructions. The problem I was
having was caused by the fact that there are two configuration files for
MySql on the ReadyNas.
My setup:
ReadyNas NV+
Squeezecenter 7.2
PC client XP SP2
When I sshd into the nas I navigated to the directory
/usr/share/squeezecenter/MySQL
this is the directory that contains the my.tt file which looks like the
following:
Code:
--------------------
datadir = [% datadir %]
language = [% language %]
port = [% port || 9092 %]
socket = [% socket %]
pid-file = [% pidFile %]
log-error = [% errorLog %]
innodb_fast_shutdown = 1
max_connections = 4
thread_concurrency = 4
log-warnings = 0
# bind-address = [% bindAddress %]
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 = [% socket %]
--------------------
The only change I made to this file was to comment out the bind-address
option. I'm not sure this is even necessary but Ididn't bother to change
it back to test.
Now the part that had me stumped:
On the ReadyNas navigate to /etc/mysql
in this directory you will find my.cnf this file looks like:
Code:
--------------------
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = admin
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
- my.cnf 1/74 1%
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = admin
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
# bind-address = 127.0.0.1
#skip-networking
innodb_buffer_pool_size = 6M
key_buffer_size = 16k
myisam_sort_buffer_size = 16k
max_connection = 20
#
# * Fine Tuning
#
key_buffer = 16k
max_allowed_packet = 16M
thread_stack = 128K
#
- my.cnf 1/74 1%
#skip-networking
innodb_buffer_pool_size = 6M
key_buffer_size = 16k
myisam_sort_buffer_size = 16k
max_connection = 20
#
# * Fine Tuning
#
key_buffer = 16k
max_allowed_packet = 16M
thread_stack = 128K
#
# * Query Cache Configuration
#
query_cache_limit = 1048576
query_cache_size = 32768
query_cache_type = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql.log
#log = /var/log/mysql/mysql.log
#
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
#log-bin = /var/log/mysql/mysql-bin.log
# See /etc/mysql/debian-log-rotate.conf for the number of files kept.
max_binlog_size = 16384
#binlog-do-db = include_database_name
#binlog-ignore-db = include_database_name
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
- my.cnf 74/74 100%
--------------------
The line to find here is the skip-networking line. This line needs to
be commented out.
Once I commented the line I had to go back and set the port to 3306 and
the user to slimserver with no password.
Now it works like a charm. I hope this helps.
--
ckllrvlk
------------------------------------------------------------------------
ckllrvlk's Profile: http://forums.slimdevices.com/member.php?userid=7237
View this thread: http://forums.slimdevices.com/showthread.php?t=63075
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
