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_filemssql-jdbc-12.4.0.jre11.jar
db_drivercom.microsoft.sqlserver.jdbc.SQLServerDriver
db_urljdbc: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
)



Add new attachment

Only authorized users are allowed to upload new attachments.

List of attachments

Kind Attachment Name Size Version Date Modified Author Change note
png
driver_file.png 21.2 kB 2 29-Dec-2020 05:25 Ben Spink
png
url.png 17.2 kB 2 29-Dec-2020 05:25 Ben Spink
« This page (revision-17) was last changed on 17-Nov-2023 16:11 by Ada Csaba
G’day (anonymous guest)
CrushFTP10 | What's New

Referenced by
LeftMenu

JSPWiki