Websites listing xml error17 - 07 - 2020
Version 1.4.7 has been released11 - 08 - 2020
Remote Linux SQL
This guide explains the settings required to use an remote SQL Server installed on Ubunu 18.04.
The Guide does assume the following:
- You are using SolidCP 1.4.7+
- SQL is installed on Linux (https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver15)
- a UNC share is setup on the server running SolidCP Server
Microsoft ODBC Driver for SQL Server is installed on SolidCP Server ( https://docs.microsoft.com/en-us/sql/connect/odbc/microsoft-odbc-driver-for-sql-server )
For ubuntu you will need to make sure you install cifs-utils by running:
apt-get install cifs-utils
//SCPServer/SQLBackupTmp /mnt/sqlbackuptmp cifs username=SQLBackupTmp,password=password,uid=mssql,_netdev,x-systemd.automount 0 0
Databases Location: This is the local location the databases are usually found (The default is /var/opt/mssql/data/).
SolidCP Server backup path: This is the Windows location of the share you have created.
Network path or linux mount point: This is the mount point you have set in the fstab.