Skip to content

Latest commit

 

History

History
46 lines (33 loc) · 1.9 KB

part-2-editing-db-configuration-file.md

File metadata and controls

46 lines (33 loc) · 1.9 KB
Raw

#Editing DB Configuration

Edit one of the following files using Visual Studio or any text editor of your choice.

WebForms

src/FrontEnd/MixERP.Net.FrontEnd/Resource/Configuration/DbServer.xml

MVC

src-beta2/Web/MixERP.Net.Web.UI/Resource/Configuration/DbServer.xml

##File Contents

<configuration>
  <appSettings>
    <add key="Server" value="localhost" />
    <add key="Port" value="5432" />
    <add key="Database" value="mixerp" />
    <add key="UserId" value="mix_erp" />
    <add key="Password" value="change-on-deployment" />

    <add key="PostgreSQLBinDirectory" value="C:\Program Files\PostgreSQL\9.3\bin\" />
    <add key="DatabaseBackupDirectory" value="/Resource/Backups/" />
  </appSettings>
</configuration>

###Configuration Explained

Key Configuration
Server The hostname or IP address of your development PostgreSQL Server instance. Usually "localhost".
Port The port on which the PostgreSQL server is listening. Usually "5432".
Database The name of the database in which you have installed (run) MixERP database script
UserId MixERP database script will create a user mix_erp. Leave it as it is.
Password Password for the above user. The default password is "change-on-deployment". If you happen to change the password, change it here as well.
PostgreSQLBinDirectory Depending upon where you installed PostgreSQL server, provide the correct location of the bin directory.
DatabaseBackupDirectory Provide the path where you want to keep your database backups. If you host MixERP, make sure that the IIS user has write access to the path.

##Related Topics