First tasks after installation - salehram/mikrotik-proxy-logger GitHub Wiki

After successful installation is completed, your first tasks should be:

• First, please read this important article Important notes before starting the application for the first time
• Prepare the user name and password of the SQL server to be used with the application, you need to supply a user name and password that has access to the SQL server and the desired database we want to create.
• Create the database in the SQL server (if it was not created already).
• Configure the application to connect to the database we created.
• Build the database tables (this can be done from inside the application by going to Setup -> Database server -> Build tables.

Information on how to create the database:

In order to create the database, please follow these steps:

• In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.
• Right-click Databases, and then click New Database.
• In New Database, enter a database name.
• If you want to change the owner name, click (…) to select another owner (the owner is the user name that will be used in the application to connect and login to to the database)
• Once you are done from the settings, click Ok.

For more information about how to create a SQL database, please check this link: https://technet.microsoft.com/en-us/library/ms186312%28v=sql.110%29.aspx

Information to setup the application to connect to the database we created:

There are two ways to achieve this task, the first one is using the built in tool to search and put the SQL server information, which can be accessed from inside the application by going to Setup -> Database server.

The second method is by manually creating the configuration file, through the following steps:

• Navigate to the application installation path, which should be in Program Files OR Program Files (x86) -> islinux
• Create a new folder and name it "config", if it was not created already.
• Open the newly created folder, and create a new file and name it "config.ini"
• Open the newly created "config.ini" file and and type the information of the database server in the following line order:
  • Database server name.
  • The SQL server instance name which has the mtpldb in it.
  • The SQL database name, the default name should be “mtpldb“.
  • The user name who has access to the database server and the database itself.
  • The password of the user name.
  • The IP address of the Mikrotik router which we will pull the accounting data from.
• Once all the 5 lines are filled, save and close the file, then restart the MTPL-Listener service.