How to Host MixERP in Interserver Shared Hosting?

MixERP not only supports multi-tenancy but also shared hosting environments. In this tutorial I will show you how to host MixERP with SQL Server in one of the most popular ASP.net hosting service providers-- Interserver.

Hosting MixERP with Interserver

Because of their awesome support and blazingly fast servers, Interserver is regarded as one of the best and most affordable web hosting companies. Having been a professional web host for over 19 years, Interserver have been praised for their server quality, speed, and friendly support staff.

Purchase Interserver ASP.net Hosting

Purchase any ASP.net web hosting plan that fits your need. Once your account is activated, log in to your Plesk control panel.

Download Hosting File

Download the file mixerp.interserver.net.zip. Extract it somewhere and you will see the following files:

  • db.bak
  • site.zip

Step 1: Create a New SQL Server 2017 Database

Log in to your hosting control panel. On the dashboard, click "Databases" and then click "Add New Database".

Create a New SQL Server Database
  • Enter the name of your database and do not forget to select "MS SQL" from the dropdown list.
  • Select your website from the "Related Site" dropdown list.
  • Put a tick on "Create database user".
  • For "Database user name", enter "frapid_db_user" and type a strong password and confirm it. Note: if you have "&" character in your password, you will need to escape it on configuration file (SQLServer.config).
  • Put a tick on the "User has access to all database within selected subscription".
  • Leave the "Remote access" rules to "Use the system firewall rules".
  • Click OK.
Take a good note of everything you've entered in this form because you will need this information later.

Create Database User for Reporting Engine

New SQL Server Database

Your database is now created but you still need to add a user for Reporting module. Create a user called "report_user" for read-only access. Click on "User Management" link on top-right corner of the page. Now click the button "Add Database User".

Add a New SQL Server User Called report_user

Select "MS SQL" from the dropdown list.

  • For "Database user name", enter "report_user" and type a strong password and confirm it. Note: if you have "&" character in your password, you will need to escape it on configuration file (SQLServer.config).
  • Leave the "Database" dropdown list to "Any".
  • Leave the "Remote access" rules to "Use the system firewall rules".
  • Click OK.

Change access of "report_user" to read-only

Now, click on the newly created user "report_user".

Make the user report_user read-only

Now change the dropdown list "Role" to "Read Only" and click OK.

Restore Database

Restore Database from Backup

Click on "Databases" on your control panel dashboard and click "Import Dump" and upload the file "db.bak" you've downloaded and extracted earlier and press OK. Wait for this process to complete. Once this gets done, refresh the page. You will notice that now there are numerous tables in the database.

Step 2: Remove Default Files and Upload Site

Before you upload the site, you need to delete the default landing site contents present in the "httpdocs" directory.

Delete Default Files

Click on "Files" on your control panel dashboard. Click on "httpdocs". Select all files by clicking on the checkbox on the table header on the first column and remove all files by pressing "Remove" button.

Upload the file site.zip

Once you've removed all files, click "Upload" button and point it to "site.zip" you've downloaded and extracted earlier.

Extract the Uploaded File

Once the upload is complete, select the file "site.zip" and click "Extract Files" button. Put a tick mark on the option "Replace existing files" and press OK.

File List after Extracting

The files are now extracted to your website's root folder "httpdocs".

Step 3: Editing Configuration Files

Congratulations for making this far. You will now need to edit the two configuration files, namely "DomainsApproved.json" and "SQLServer.config".

Click on the directory "Resources" with a "plural s" and then "Configs" and then "DomainsApproved.json".

DomainsApproved.json file
  • Enter your DNS domain name in "DomainName" key.
  • Enter the database name you've created earlier in "DatabaseName" key.
  • Press OK.

Now edit the file "SQLServer.config" file similarly.

SQLServer.config file
  • On the "Server" key, enter "".\MSSQLSERVER2017".
  • Enter the password for the user "frapid_db_user" in the key "SuperUserPassword".
  • Enter the password for the user "frapid_db_user" again in the key "Password".
  • Enter the password for the user "report_user" in the key "ReportUserPassword".
  • Click OK to save.
Network Library

Change the value for the key "NetworkLibrary" only if your website cannot establish connection to your SQL Server. For more information on what exactly to enter, follow this link. https://www.connectionstrings.com/define-sql-server-network-protocol/

Connection Info
Connection Information of Your Database

If you are confused, you can go back to "Databases" and then click "Connection Info". This will display the connection information of your database.

Step 4: Rename Tenant Directory

Rename the Tenant Directory

Navigate to the file manager and click on the directory "Tenants" on the root folder (httpdocs). Rename the existing directory to exactly match your database name.

Check Your Site

You can check your site now. Open a browser window and point the url to your domain name. If you see errors, edit web.config file and add the following line inside <system.web> node.

<customErrors mode="Off" / >

This will enable you to troubleshoot errors and get the ball rolling.

Log in to Admin Area

On your MixERP website, click on the button "Admin Area".

  • Email: demo@mixerp.org
  • Password: Demo@4321
  • Select "Default" office.
  • Click on "Sign In" button.

Contact us if you need help. Cheers!

Binod Nirvan
Binod Nirvan
2019-05-17T17:57:15.548Z