It's very simple to set up, you only need to create (or edit) a file named 'db.conf' at the server installation directory.

Its content must be like the following:


<dbconfig>

  <providername>mysql</providername>

  <connectionstring>Server=_SERVER_;User
ID=_USER_;Password=_PASSWORD_;Database={0};Pooling=true</connectionstring>

  <databasepath></databasepath>

</dbconfig>

replacing the parameters _SERVER_, _USER_ and _PASSWORD_ with the appropiate ones according to the server configuration that you want to use. Thus, a valid 'db.conf' file in our development environment would be:


<dbconfig>

  <providername>mysql</providername>

  <connectionstring>Server=venus;User
ID=myuser;Password=mypwd;Database={0};Pooling=true</connectionstring>

  <databasepath></databasepath>

</dbconfig>

Finally, we must set the mysql configuration parameter max_allowed_packet to support up to 10MB. If you require more information about how configure this parameter, you can take a look at this article.

by Ruben at 3:38 PM under backend , mysql , plastic