I updated my Ubuntu 7.10 to 8.04 last night, and ran into a few minor
issues.
I am using a custom MySQL setup, since I have a MySQL server installed
already on the machine, I am using that for my SqueezeCenter data. This
ran fine until I upgraded the distribution.
The solution for it is not too hard though. You need to find out what
IP address MySQL binds to. You can do so by viewing (and maybe editing)
the following file:
Code:
--------------------
/etc/mysql/my.cnf
--------------------
Look for the following entry:
Code:
--------------------
bind-address = 127.0.0.1
--------------------
The default setting for this is localhost, as shown above. But this
meant I could no longer make any connections to the server from other
machines in my network. I changed the value to the following:
Code:
--------------------
bind-address = 10.10.100.110
--------------------
After doing this, my SqueezeCenter would no longer work, it failed to
connect to the database. In order to get it to work, I had to change
the address SqueezeCenter uses to connect to the MySQL database. Stop
SqueezeCenter, and edit the following file:
Code:
--------------------
/var/lib/squeezecenter/prefs/server.prefs
--------------------
Locate the following line:
Code:
--------------------
dbsource: dbi:mysql:hostname=127.0.0.1;port=3306;database=squeezecenter
--------------------
Change the hostname address to match what you have set for the
bind-address in the MySQL configuration.
Code:
--------------------
dbsource: dbi:mysql:hostname=10.10.100.110;port=3306;database=squeezecenter
--------------------
Save the file, start SqueezeCenter again, and everything should be
working as it did.
Hope this helps someone facing the same problem.
--
furonfour
------------------------------------------------------------------------
furonfour's Profile: http://forums.slimdevices.com/member.php?userid=17114
View this thread: http://forums.slimdevices.com/showthread.php?t=46807
_______________________________________________
unix mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/unix
