This is version . It is not the current version, and thus it cannot be edited.
[Back to current version]   [Restore this version]

Download the latest mysql connector J for you mysql server from their website.

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

I suggest placing the mysql-connector-java-5.0.8-bin.jar file from this in the plugins/lib folder of CrushFTP and giving it the name "mysql.jar".

Then edit the prefs.XML file and set the following items:

<stats_db_url>jdbc:mysql://127.0.0.1:3306/crushftp_stats</stats_db_url>
<stats_db_driver>com.mysql.jdbc.Driver</stats_db_driver>
<stats_db_user>root</stats_db_user>
<stats_db_driver_file>plugins/lib/mysql.jar</stats_db_driver_file>

Use MySQL WOrkbench and make a new DB with the name "crushftp_stats" (or adjust the URL above to reference the name you choose.) Below is the schema to put in it:

CREATE TABLE META_INFO (
  RID double NOT NULL,
  SESSION_RID double NOT NULL,
  TRANSFER_RID double NOT NULL,
  ITEM_KEY varchar(100) default NULL,
  ITEM_VALUE varchar(2000) default NULL,
  PRIMARY KEY  (RID)
);

CREATE TABLE SESSIONS (
  RID double NOT NULL,
  SESSION varchar(100) default NULL,
  SERVER_GROUP varchar(50) default NULL,
  USER_NAME varchar(100) default NULL,
  START_TIME datetime default NULL,
  END_TIME datetime default NULL,
  SUCCESS_LOGIN varchar(10) default NULL,
  IP varchar(50) default NULL,
  PRIMARY KEY  (RID)
);

CREATE TABLE TRANSFERS (
  RID double NOT NULL,
  SESSION_RID double NOT NULL,
  START_TIME datetime default NULL,
  DIRECTION varchar(8) default NULL,
  PATH varchar(255) default NULL,
  FILE_NAME varchar(2000) default NULL,
  URL varchar(2000) default NULL,
  SPEED int default NULL,
  TRANSFER_SIZE double default NULL,
  IGNORE_SIZE varchar(1) default NULL,
  PRIMARY KEY  (RID)
);

That is it. now the statistics data should be going to the MySQL tables, and reports will automatically run against those tables too.

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
insert_methods.png 112.2 kB 1 29-Dec-2020 05:25 krivacsz
jpg
sql_stats1.jpg 163.2 kB 1 29-Dec-2020 05:25 Ada Csaba
« This particular version was published on 29-Dec-2020 05:25 by Ben Spink.
G’day (anonymous guest)
CrushFTP10 | What's New

Referenced by
General Settings

JSPWiki