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. I suggest placing the jar file this contains 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>

Make a new DB and call it "crushftp_stats". Below is the schema for 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)
);

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 20-Aug-2020 04:28 krivacsz
jpg
sql_stats1.jpg 163.2 kB 1 07-Jul-2020 14:16 Ada Csaba
« This particular version was published on 25-Oct-2018 04:31 by Ben Spink.
G’day (anonymous guest)
CrushFTP9 | What's New

Referenced by
General Settings

JSPWiki