I've since moved the DB to a mySQL I already had running for Joomla + my
ERP-software and everything keeps working fabulously. Web interface is
snappy, songs play all day long without interruption ...
Needless to say, I'm quite happy again :-)
--
bakker_be
http://www.last.fm/user/Bakker_be
I'll have to try MySQL again in 7.6.0 on Windows. Maybe there have been
some unnanounced (or inadvertent) fixes.
--
JJZolx
JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10
View this thread:
bakker_be;592649 Wrote:
I've since moved the DB to a mySQL I already had running for Joomla + my
ERP-software and everything keeps working fabulously. Web interface is
snappy, songs play all day long without interruption ...
Needless to say, I'm quite happy again :-)
Aha you run your own
Mnyb;592762 Wrote:
Aha you run your own MySQL instance not the one that SBS runs by itself
:)
I've never figured how to use the system MySQL as there is no obvius
settings in sbs, you probably have to edit a configuration file
somewhere
It's just four lines in server.prefs.
Here
JJZolx;592763 Wrote:
It's just four lines in server.prefs.
Here are the default settings in 7.6 for SQLite:
Code:
dbpassword: ''
dbsource: dbi:SQLite:dbname=%s
dbtype: SQLite
dbusername: slimserver
Here is what it
Mnyb;592766 Wrote:
Thanks :) Now to figure the create MySQL user account and empty dB and
grant the user account permissions stuff, hmm have to check in on my
server MySQL to so if it's still up and running I might have turned it
off a couple of years ago...
SQLyog is a nice MySQL
Lot of views, no answers ...
I've solved the problem anyway :)
In a totally unrelated post I read that we could switch to MySQL using
the web interface. I tried that and I have no problems anymore.
Seems SQLite + my ~44000 song collection + Server 2008 R2 are not a
good combination :D
--
Amazing ! it is usually so that Sqlite works and MySQL is broken in 7.6
Apparently Win 2008 server R2 is an exception off that rule.
--
Mnyb
Main hifi: Touch + CIA PS +MeridianG68J MeridianHD621 MeridianG98DH and
assorted