| At line 1 added 15 lines |
| __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. |
|
|
| At line 17 added one line |
| /* Script for MYSQL to make the DB tables needed for CrushFTP. */ |
| At line 3 changed one line |
| CREATE TABLE `domain_root_list` ( |
| # Dump of table DOMAIN_ROOT_LIST |
| # ------------------------------------------------------------ |
|
| CREATE TABLE `DOMAIN_ROOT_LIST` ( |
| At line 6 changed one line |
| `path` varchar(255) default NULL |
| `path` varchar(255) default NULL, |
| `sort_order` int(11) default NULL |
| At line 31 added 2 lines |
| # Dump of table EVENTS5 |
| # ------------------------------------------------------------ |
| At line 12 changed one line |
| CREATE TABLE `events` ( |
| CREATE TABLE `EVENTS5` ( |
| At line 14 changed 19 lines |
| `SQL_FIELD_name` varchar(255) NOT NULL default '', |
| `command` varchar(255) NOT NULL default '', |
| `event_dir_data` varchar(255) NOT NULL default '', |
| `event_if_list` varchar(255) NOT NULL default '', |
| `event_action_list` varchar(255) NOT NULL default '', |
| `event_user_action_list` varchar(255) NOT NULL default '', |
| `event_after_list` varchar(255) NOT NULL default '', |
| `event_plugin_list` varchar(255) NOT NULL default '', |
| `SQL_FIELD_from` varchar(255) NOT NULL default '', |
| `SQL_FIELD_to` varchar(255) NOT NULL default '', |
| `cc` varchar(255) NOT NULL default '', |
| `bcc` varchar(255) NOT NULL default '', |
| `subject` varchar(255) NOT NULL default '', |
| `body` varchar(255) NOT NULL default '', |
| `event_always_cb` varchar(10) NOT NULL default 'false', |
| `event_after_cb` varchar(10) NOT NULL default 'false', |
| `event_now_cb` varchar(10) NOT NULL default 'false', |
| `event_if_cb` varchar(10) NOT NULL default 'false', |
| `sort_order` int(11) default NULL |
| `event_name` varchar(255) NOT NULL default '', |
| `prop_name` varchar(255) NOT NULL default '', |
| `prop_value` text NOT NULL |
| At line 37 changed one line |
| CREATE TABLE `inheritance` ( |
| # Dump of table INHERITANCE |
| # ------------------------------------------------------------ |
|
| CREATE TABLE `INHERITANCE` ( |
| At line 40 changed one line |
| `sort_order` int(11) default NULL |
| `sort_order` int(11) default NULL, |
| `server_group` varchar(50) default NULL |
| At line 45 changed one line |
| CREATE TABLE `ip_restrictions` ( |
| # Dump of table IP_RESTRICTIONS |
| # ------------------------------------------------------------ |
|
| CREATE TABLE `IP_RESTRICTIONS` ( |
| At line 68 added 2 lines |
| # Dump of table USER_PROPERTIES |
| # ------------------------------------------------------------ |
| At line 56 changed one line |
| CREATE TABLE `user_properties` ( |
| CREATE TABLE `USER_PROPERTIES` ( |
| At line 59 changed one line |
| `prop_value` varchar(255) default NULL |
| `prop_value` varchar(2000) default NULL |
| At line 79 added 2 lines |
| # Dump of table USERS |
| # ------------------------------------------------------------ |
| At line 65 changed one line |
| CREATE TABLE `users` ( |
| CREATE TABLE `USERS` ( |
| At line 75 changed one line |
| CREATE TABLE `vfs` ( |
| # Dump of table VFS |
| # ------------------------------------------------------------ |
|
| CREATE TABLE `VFS` ( |
| At line 85 changed one line |
| CREATE TABLE `vfs_permissions` ( |
| # Dump of table VFS_PERMISSIONS |
| # ------------------------------------------------------------ |
|
| CREATE TABLE `VFS_PERMISSIONS` ( |
| At line 116 added 2 lines |
| # Dump of table WEB_BUTTONS |
| # ------------------------------------------------------------ |
| At line 94 changed one line |
| CREATE TABLE `web_buttons` ( |
| CREATE TABLE `WEB_BUTTONS` ( |
| At line 123 added 2 lines |
| `for_menu` varchar(10) default NULL, |
| `for_context_menu` varchar(10) default NULL, |
| At line 103 changed one line |
| CREATE TABLE `web_customizations` ( |
| # Dump of table WEB_CUSTOMIZATIONS |
| # ------------------------------------------------------------ |
|
| CREATE TABLE `WEB_CUSTOMIZATIONS` ( |
| At line 142 added 2 lines |
| # Dump of table GROUPS |
| # ------------------------------------------------------------ |
| At line 113 changed one line |
| CREATE TABLE `groups` ( |
| CREATE TABLE `GROUPS` ( |
| At line 151 added 21 lines |
|
|
| # 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; |
|
