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 )
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)
Log in
JSPWiki