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

And from that download, the only thing you care about is this one file: mysql-connector-java-5.0.8-bin.jar

Place that somewhere, 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;

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-13) was last changed on 30-May-2019 21:34 by Ben Spink
G’day (anonymous guest)
CrushFTP9 | What's New

Referenced by
LeftMenu

JSPWiki