Due to licensing, we cannot include the MySQL jar file. So here is the link for it.
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-12) was last changed on 20-Aug-2018 18:38 by Ada Csaba
G’day (anonymous guest)
Log in
JSPWiki