MSSQL#
IMPORTANT: due to the security updates since CrushFTP version 10.5.2+ any JDBC driver jar file needs to be placed into the CrushFTP10/plugins/lib/ directory, or it won't load.
These screenshots should help as an example of what to enter. In this example, I put the driver file into my CrushFTP program folder. You could also use absolute paths.
Driver download link: https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16
| db_driver_file | mssql-jdbc-12.4.0.jre11.jar |
|---|---|
| db_driver | com.microsoft.sqlserver.jdbc.SQLServerDriver |
| db_url | jdbc:sqlserver://192.168.0.100:1433;databaseName=crushftp |
Some documentation from MS on the driver usage: http://msdn.microsoft.com/en-us/library/ms378428
/* Script for MS SQL to make the DB tables needed for CrushFTP. */
CREATE TABLE DOMAIN_ROOT_LIST (
userid int NOT NULL default '0',
domain varchar(8000) default NULL,
path varchar(8000) default NULL,
sort_order int default NULL
)
CREATE TABLE EVENTS5 (
userid int NOT NULL default '0',
event_name varchar(8000) NOT NULL default '',
prop_name varchar(8000) NOT NULL default '',
prop_value text NOT NULL
)
CREATE TABLE INHERITANCE (
userid int default NULL,
inherit_username varchar(8000) default NULL,
server_group varchar(8000) default NULL,
sort_order int default NULL
)
CREATE TABLE IP_RESTRICTIONS (
userid int NOT NULL default '0',
start_ip varchar(8000) default NULL,
type varchar(1) default NULL,
stop_ip varchar(8000) default NULL,
sort_order int default NULL
)
CREATE TABLE USER_PROPERTIES (
userid int default NULL,
prop_name varchar(8000) default NULL,
prop_value varchar(MAX) default NULL
)
CREATE TABLE USERS (
userid int NOT NULL IDENTITY (1, 1) NOT FOR REPLICATION,
username varchar(8000) default NULL,
password varchar(8000) default NULL,
server_group varchar(8000) default NULL,
PRIMARY KEY (userid)
)
CREATE TABLE VFS (
userid int default NULL,
url varchar(8000) default NULL,
type varchar(8000) default NULL,
path varchar(8000) default NULL,
sort_order int default NULL
)
CREATE TABLE VFS_PERMISSIONS (
userid int default NULL,
path varchar(8000) default NULL,
privs varchar(8000) default NULL
)
CREATE TABLE WEB_BUTTONS (
userid int NOT NULL default '0',
sql_field_key varchar(8000) default NULL,
sql_field_value varchar(8000) default NULL,
for_menu varchar(8000) default NULL,
for_context_menu varchar(8000) default NULL,
sort_order int default NULL
)
CREATE TABLE WEB_CUSTOMIZATIONS (
userid int NOT NULL default '0',
sql_field_key varchar(8000) default NULL,
sql_field_value varchar(MAX),
sort_order int default NULL
)
CREATE TABLE GROUPS (
groupname varchar(8000) default NULL,
userid int default NULL,
server_group varchar(8000) default NULL
)
CREATE TABLE MODIFIED_TIMES (
server_group varchar(8000) default NULL,
prop_name varchar(8000) default NULL,
prop_value varchar(8000) default NULL
)
CREATE TABLE VFS_PROPERTIES (
userid int default NULL,
path varchar(8000) default NULL,
prop_name varchar(8000) default NULL,
prop_value varchar(8000) default NULL
)