Remote Linux SQL
Websites listing xml error
17 - 07 - 2020
Version 1.4.7 has been released
11 - 08 - 2020Remote 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 )
Ubuntu
For ubuntu you will need to make sure you install cifs-utils by running:
apt-get install cifs-utils
File: /etc/fstab
//SCPServer/SQLBackupTmp /mnt/sqlbackuptmp cifs username=SQLBackupTmp,password=password,uid=mssql,_netdev,x-systemd.automount 0 0
SolidCP Configuration
Databases Location: This is the local location the databases are usually found (The default is /var/opt/mssql/data/).
Backup Options:
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.
Trevor Robinson
- Co-Founder of SolidCP/FuseCP
- More then 15 years of experience with Linux and Unix.
- Open source enthusiast
- More then 15 years of experience with Linux and Unix.
- Open source enthusiast
