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 are the default settings in 7.6 for SQLite:
Code:
--------------------
dbpassword: ''
dbsource: dbi:SQLite:dbname=%s
dbtype: SQLite
dbusername: slimserver
--------------------
Here is what it looks like when you switch to MysQL, using the SbS
instance of MySQL:
Code:
--------------------
dbpassword: ''
dbsource: dbi:mysql:hostname=127.0.0.1;port=9092;database=slimserver
dbtype: MySQL
dbusername: slimserver
--------------------
To change it to use your own instance of MySQL, shut down the server
and edit server.prefs to look something like this (assuming MySQL is
running on the same server and on the standard port 3306):
Code:
--------------------
dbpassword: mysqluserPassword
dbsource: dbi:mysql:hosname=127.0.0.1;port=3306;database=mydatabasename
dbtype: MySQL
dbusername: mysqluser
--------------------
You'll should have already created the MySQL user account and the
(empty) database in MySQL and granted the user account the necessary
permissions to read, write and alter the database.
* The 'dbtype' entry is new to SbS 7.6.0. It's case sensitive.
** If you use the web UI to switch to SQLite and then switch back to
MySQL your server.prefs edits will be lost and SbS will be pointing
back again to the SbS instance of MySQL.
--
JJZolx
------------------------------------------------------------------------
JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10
View this thread: http://forums.slimdevices.com/showthread.php?t=83448
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
