Please note that these instructions are explicitly about setting up a router.
We would also like to point out that PaperOffice assumes no responsibility for the correctness and completeness of your facility on third-party software and hardware. To do this, contact the support of your internet provider or use our paid support if you need help.
If you need help from our technicians, you can purchase support units directly here or use your PaperOffice service agreement. To do this, contact your personal contact person or, if you do not yet have a service agreement, you can conclude this by sending an inquiry to firstname.lastname@example.org.
To be able to access the Paperoffice database from an external network, you must redirect the MySQL / MariaDB server port (usually 3306) to the internal IP address of our server or NAS.
For this you need:
- The internal IP of your server or NAS
- You must be able to access the router
- The public IP of your network. You also need to know whether this is a fixed or dynamic IP
If you have a NAS, access the control panel of your NAS via your browser and copy the internal IP till the colon ":"
If you installed the database on your own Windows server, open the cmd console of your server by pressing both the Windows key and the letter R at the same time.
A small window titled "Run" opens. Enter cmd and click the "OK" button. Once you're in the console, just type "ipconfig" and hit enter. You get something like this:
Copy the IPv4 address.
To access your router, open the cmd console from your computer by pressing the Windows key and the letter R at the same time.
A small window with the title "Run" opens. Enter cmd and click the "OK" button.
Once you're in the console, just type "ipconfig" and hit enter. You get something like this:
Kopieren Sie die Adresse "Default Gateway".
Access your router interface. To do this, open your browser and enter the address of the "Default Gateway", which you copied previously.
Then enter the access name and password. If you don't know, look at the back of your router. If these are missing or still not available, contact your internet retailer.
Depending on the manufacturer, you will find the menu in the firmware of the router, such as «NAT», «Virtual Server» or «Port Forwarding». You need to go to this option by browsing your router's various menus. You can usually find it in the "Advanced Options" section.
As soon as you are in the menu for the port configuration, you can usually discover an empty field or a "+" key. Entering is as easy as entering the data you copied in the following fields.
Service name: Here you can enter the name for the port forwarding. We recommend entering a self-explanatory name, such as PaperOffice DataBase. By default it is empty.
Protocol: Here you have to specify whether it uses the TCP, UDP or both protocols, in this case insert TCP .
External port: This is the port that must be opened in the router for the database server (usually 3306).
Internal IP address: Here you have to enter the IP address of the target computer from your network. Enter the internal IP of your NAS or server that you copied earlier.
Once this is done, all you have to do is apply the changes. The configuration for the entered ports is now complete.
Before you create a new database or connect PaperOffice to an existing database, you need to know your public IP address. To do this, please type in the web and enter the following address https://www.showmyip.com and copy your public IP address.
If you do not have a static IP address, you should use a dynamic DNS service such as https://account.dyn.com.
Install PaperOffice as usual (if not already installed) and start the database manager.
Click on the respective NAS or MariaDB -> CREATE NEW DATABASE and enter your public IP address under IP address.
Complete the installation.
Finished! You can now access the PaperOffice database from an external network.