Change qlite to MYSQL

[goddleyeke]

I searched everywhere and didnt find this simple answer so I will post it for future installers.

To run MYSQL insteal of SQLITE, useful if you already have a MYSQL server or if your MYSQL server is on a seperate machine then the webserver you need to do 2 things.

First you must edit your web.config in the WWW for EZuGCC or WWWPanel for UGCC

edit

Code: Select all

    <add key="dbtype" value="sqlite"/>

to be

Code: Select all

    <add key="dbtype" value="mysql"/>

This will open up access for your web control panel, but now you need to change your montior to update from MYSQL, so open the ugccmon.cfg in monitor\System Folder and monitor\Configs and edit your [DBConfig] by following the instructions.

Your new line should look like:

Code: Select all

//Database configuration string
//Make sure this points to the same DB the panel uses!!!!!!
//Example for mysql
//Database=ugcc;Data Source=localhost;User Id=root;Password=pw
//Example for sqlite
//Data Source=c:\program files\ugcc\ugcc.db3
//Example for oledb
//Provider=Microsoft.Jet.OLEDB.4.0;data source=c:\program files\ugcc\ugcc.mdb
[DBConfig]
Database=YOURDBNAME;Data Source=YOURIP;User Id=YOURUSER;Password=YOURPASS