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: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
db_driver_file | sqljdbc.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(255) default NULL, path varchar(255) default NULL ) CREATE TABLE EVENTS5 ( userid int NOT NULL default '0', event_name varchar(255) NOT NULL default '', prop_name varchar(255) NOT NULL default '', prop_value text NOT NULL ) CREATE TABLE INHERITANCE ( userid int default NULL, inherit_username varchar(255) default NULL, sort_order int default NULL ) CREATE TABLE IP_RESTRICTIONS ( userid int NOT NULL default '0', start_ip varchar(255) default NULL, type varchar(1) default NULL, stop_ip varchar(255) default NULL, sort_order int default NULL ) CREATE TABLE USER_PROPERTIES ( userid int default NULL, prop_name varchar(255) default NULL, prop_value varchar(2000) default NULL ) CREATE TABLE USERS ( userid int NOT NULL IDENTITY (1, 1) NOT FOR REPLICATION, username varchar(255) default NULL, password varchar(255) default NULL, server_group varchar(50) default NULL, PRIMARY KEY (userid) ) CREATE TABLE VFS ( userid int default NULL, url varchar(255) default NULL, type varchar(50) default NULL, path varchar(255) default NULL, sort_order int default NULL ) CREATE TABLE VFS_PERMISSIONS ( userid int default NULL, path varchar(255) default NULL, privs varchar(255) default NULL ) CREATE TABLE WEB_BUTTONS ( userid int NOT NULL default '0', sql_field_key varchar(255) default NULL, sql_field_value varchar(255) default NULL, for_menu varchar(10) default NULL, for_context_menu varchar(10) default NULL, sort_order int default NULL ) CREATE TABLE WEB_CUSTOMIZATIONS ( userid int NOT NULL default '0', sql_field_key varchar(255) default NULL, sql_field_value varchar(255) default NULL, sort_order int default NULL ) CREATE TABLE GROUPS ( groupname varchar(255) default NULL, userid int default NULL, server_group varchar(50) default NULL ) CREATE TABLE MODIFIED_TIMES ( server_group varchar(50) default NULL, prop_name varchar(255) default NULL, prop_value varchar(255) default NULL ) CREATE TABLE VFS_PROPERTIES ( userid int default NULL, path varchar(1024) default NULL, prop_name varchar(255) default NULL, prop_value varchar(2000) 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 particular version was published on 29-Dec-2020 05:25 by Ben Spink.
G’day (anonymous guest)
Log in
JSPWiki