MySQL#
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.
Due to licensing, we cannot include the MySQL jar file. So here is the link for it.
https://dev.mysql.com/downloads/connector/j/5.1.html
Direct link: https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.47.zip
The DB driver classname for MYSQL is "com.mysql.cj.jdbc.Driver".
And from that download, the only thing you care about is this one file: mysql-connector-java-5.0.8-bin.jar
Place that inside the CrushFTP10/plugins/lib, and in the user config, choose this file as your db_driver_file. Then test.
/* Script for MYSQL to make the DB tables needed for CrushFTP. */
# Dump of table DOMAIN_ROOT_LIST
# ------------------------------------------------------------
CREATE TABLE `DOMAIN_ROOT_LIST` (
`userid` int(11) NOT NULL default '0',
`domain` varchar(255) default NULL,
`path` varchar(255) default NULL,
`sort_order` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Dump of table EVENTS5
# ------------------------------------------------------------
CREATE TABLE `EVENTS5` (
`userid` int(11) NOT NULL default '0',
`event_name` varchar(255) NOT NULL default '',
`prop_name` varchar(255) NOT NULL default '',
`prop_value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Dump of table INHERITANCE
# ------------------------------------------------------------
CREATE TABLE `INHERITANCE` (
`userid` int(11) default NULL,
`inherit_username` varchar(255) default NULL,
`sort_order` int(11) default NULL,
`server_group` varchar(50) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Dump of table IP_RESTRICTIONS
# ------------------------------------------------------------
CREATE TABLE `IP_RESTRICTIONS` (
`userid` int(11) NOT NULL default '0',
`start_ip` varchar(255) default NULL,
`type` varchar(1) default NULL,
`stop_ip` varchar(255) default NULL,
`sort_order` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Dump of table USER_PROPERTIES
# ------------------------------------------------------------
CREATE TABLE `USER_PROPERTIES` (
`userid` int(11) default NULL,
`prop_name` varchar(255) default NULL,
`prop_value` varchar(2000) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Dump of table USERS
# ------------------------------------------------------------
CREATE TABLE `USERS` (
`userid` int(11) NOT NULL auto_increment,
`username` varchar(255) default NULL,
`password` varchar(255) default NULL,
`server_group` varchar(50) default NULL,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
# Dump of table VFS
# ------------------------------------------------------------
CREATE TABLE `VFS` (
`userid` int(11) default NULL,
`url` varchar(255) default NULL,
`type` varchar(50) default NULL,
`path` varchar(255) default NULL,
`sort_order` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Dump of table VFS_PERMISSIONS
# ------------------------------------------------------------
CREATE TABLE `VFS_PERMISSIONS` (
`userid` int(11) default NULL,
`path` varchar(255) default NULL,
`privs` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Dump of table WEB_BUTTONS
# ------------------------------------------------------------
CREATE TABLE `WEB_BUTTONS` (
`userid` int(11) 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(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Dump of table WEB_CUSTOMIZATIONS
# ------------------------------------------------------------
CREATE TABLE `WEB_CUSTOMIZATIONS` (
`userid` int(11) NOT NULL default '0',
`sql_field_key` varchar(255) default NULL,
`sql_field_value` varchar(255) default NULL,
`sort_order` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Dump of table GROUPS
# ------------------------------------------------------------
CREATE TABLE `GROUPS` (
`groupname` varchar(255) default NULL,
`userid` int(11) default NULL,
`server_group` varchar(50) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Dump of table MODIFIED_TIMES
# ------------------------------------------------------------
CREATE TABLE `MODIFIED_TIMES` (
`SERVER_GROUP` varchar(50) default NULL,
`PROP_NAME` varchar(255) default NULL,
`PROP_VALUE` varchar(255) default NULL,
PRIMARY KEY (`SERVER_GROUP`,`PROP_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Dump of table VFS_PROPERTIES. New in v6.4
# ------------------------------------------------------------
CREATE TABLE `VFS_PROPERTIES` (
`userid` int(11) default NULL,
`path` varchar(1024) default NULL,
`prop_name` varchar(255) default NULL,
`prop_value` varchar(2000) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;