peterlukacs
Forum Replies Created
Viewing 2 replies - 1 through 2 (of 2 total)
-
Forum: Plugins
In reply to: [Redis Object Cache] WP_REDIS_DATABASE isnt change anything (?)Dear Till, thank you for your fast reply, i moved it to the top, and its working now!
Please think about to add this information to your configuration description on github (at least), it would be really useful.I also got trouble to install it, the error message was the same. Sadly i cant use any “donor” wordpress installation.
Whats worked for me is that i found the database shema in this file:
/lib/wfSchema.php
Fron the lineprivate static $tables = array(
You have to convert the php array to sql (basically copy the array and edit the first and the last line, for example:
"wfBlocks7" => "(
toCREATE TABLE wp_wfBlocks7 (
, and delete the closing ‘”‘.Here is the entire schema (NOTICE: i used the 7.5.11 version):
CREATE TABLE wp_wfBlocks7 ( <code>id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT, <code>type</code> int(10) unsigned NOT NULL DEFAULT '0', <code>IP</code> binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', <code>blockedTime</code> bigint(20) NOT NULL, <code>reason</code> varchar(255) NOT NULL, <code>lastAttempt</code> int(10) unsigned DEFAULT '0', <code>blockedHits</code> int(10) unsigned DEFAULT '0', <code>expiration</code> bigint(20) unsigned NOT NULL DEFAULT '0', <code>parameters</code> text, PRIMARY KEY (<code>id</code>), KEY <code>type</code> (<code>type</code>), KEY <code>IP</code> (<code>IP</code>), KEY <code>expiration</code> (<code>expiration</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfConfig ( <code>name</code> varchar(100) NOT NULL, <code>val</code> longblob, <code>autoload</code> enum('no','yes') NOT NULL DEFAULT 'yes', PRIMARY KEY (<code>name</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfCrawlers ( <code>IP</code> binary(16) NOT NULL DEFAULT '0000000000000000', <code>patternSig</code> binary(16) NOT NULL, <code>status</code> char(8) NOT NULL, <code>lastUpdate</code> int(10) unsigned NOT NULL, <code>PTR</code> varchar(255) DEFAULT '', PRIMARY KEY (<code>IP</code>,<code>patternSig</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfFileChanges ( <code>filenameHash</code> char(64) NOT NULL, <code>file</code> varchar(1000) NOT NULL, <code>md5</code> char(32) NOT NULL, PRIMARY KEY (<code>filenameHash</code>) ) CHARSET=utf8; CREATE TABLE wp_wfHits ( <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT, <code>attackLogTime</code> double(17,6) unsigned NOT NULL, <code>ctime</code> double(17,6) unsigned NOT NULL, <code>IP</code> binary(16) DEFAULT NULL, <code>jsRun</code> tinyint(4) DEFAULT '0', <code>statusCode</code> int(11) NOT NULL DEFAULT '200', <code>isGoogle</code> tinyint(4) NOT NULL, <code>userID</code> int(10) unsigned NOT NULL, <code>newVisit</code> tinyint(3) unsigned NOT NULL, <code>URL</code> text, <code>referer</code> text, <code>UA</code> text, <code>action</code> varchar(64) NOT NULL DEFAULT '', <code>actionDescription</code> text, <code>actionData</code> text, PRIMARY KEY (<code>id</code>), KEY <code>k1</code> (<code>ctime</code>), KEY <code>k2</code> (<code>IP</code>,<code>ctime</code>), KEY <code>attackLogTime</code> (<code>attackLogTime</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfIssues ( <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT, <code>time</code> int(10) unsigned NOT NULL, <code>lastUpdated</code> int(10) unsigned NOT NULL, <code>status</code> varchar(10) NOT NULL, <code>type</code> varchar(20) NOT NULL, <code>severity</code> tinyint(3) unsigned NOT NULL, <code>ignoreP</code> char(32) NOT NULL, <code>ignoreC</code> char(32) NOT NULL, <code>shortMsg</code> varchar(255) NOT NULL, <code>longMsg</code> text, <code>data</code> text, PRIMARY KEY (<code>id</code>), KEY <code>lastUpdated</code> (<code>lastUpdated</code>), KEY <code>status</code> (<code>status</code>), KEY <code>ignoreP</code> (<code>ignoreP</code>), KEY <code>ignoreC</code> (<code>ignoreC</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfPendingIssues ( <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT, <code>time</code> int(10) unsigned NOT NULL, <code>lastUpdated</code> int(10) unsigned NOT NULL, <code>status</code> varchar(10) NOT NULL, <code>type</code> varchar(20) NOT NULL, <code>severity</code> tinyint(3) unsigned NOT NULL, <code>ignoreP</code> char(32) NOT NULL, <code>ignoreC</code> char(32) NOT NULL, <code>shortMsg</code> varchar(255) NOT NULL, <code>longMsg</code> text, <code>data</code> text, PRIMARY KEY (<code>id</code>), KEY <code>lastUpdated</code> (<code>lastUpdated</code>), KEY <code>status</code> (<code>status</code>), KEY <code>ignoreP</code> (<code>ignoreP</code>), KEY <code>ignoreC</code> (<code>ignoreC</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfTrafficRates ( <code>eMin</code> int(10) unsigned NOT NULL, <code>IP</code> binary(16) NOT NULL DEFAULT '0000000000000000', <code>hitType</code> enum('hit','404') NOT NULL DEFAULT 'hit', <code>hits</code> int(10) unsigned NOT NULL, PRIMARY KEY (<code>eMin</code>,<code>IP</code>,<code>hitType</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfLocs ( <code>IP</code> binary(16) NOT NULL DEFAULT '0000000000000000', <code>ctime</code> int(10) unsigned NOT NULL, <code>failed</code> tinyint(3) unsigned NOT NULL, <code>city</code> varchar(255) DEFAULT '', <code>region</code> varchar(255) DEFAULT '', <code>countryName</code> varchar(255) DEFAULT '', <code>countryCode</code> char(2) DEFAULT '', <code>lat</code> float(10,7) DEFAULT '0.0000000', <code>lon</code> float(10,7) DEFAULT '0.0000000', PRIMARY KEY (<code>IP</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfLogins ( <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT, <code>hitID</code> int(11) DEFAULT NULL, <code>ctime</code> double(17,6) unsigned NOT NULL, <code>fail</code> tinyint(3) unsigned NOT NULL, <code>action</code> varchar(40) NOT NULL, <code>username</code> varchar(255) NOT NULL, <code>userID</code> int(10) unsigned NOT NULL, <code>IP</code> binary(16) DEFAULT NULL, <code>UA</code> text, PRIMARY KEY (<code>id</code>), KEY <code>k1</code> (<code>IP</code>,<code>fail</code>), KEY <code>hitID</code> (<code>hitID</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfReverseCache ( <code>IP</code> binary(16) NOT NULL DEFAULT '0000000000000000', <code>host</code> varchar(255) NOT NULL, <code>lastUpdate</code> int(10) unsigned NOT NULL, PRIMARY KEY (<code>IP</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfStatus ( <code>id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT, <code>ctime</code> double(17,6) unsigned NOT NULL, <code>level</code> tinyint(3) unsigned NOT NULL, <code>type</code> char(5) NOT NULL, <code>msg</code> varchar(1000) NOT NULL, PRIMARY KEY (<code>id</code>), KEY <code>k1</code> (<code>ctime</code>), KEY <code>k2</code> (<code>type</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfHoover ( <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT, <code>owner</code> text, <code>host</code> text, <code>path</code> text, <code>hostKey</code> varbinary(124) DEFAULT NULL, PRIMARY KEY (<code>id</code>), KEY <code>k2</code> (<code>hostKey</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfFileMods ( <code>filenameMD5</code> binary(16) NOT NULL, <code>filename</code> varchar(1000) NOT NULL, <code>knownFile</code> tinyint(3) unsigned NOT NULL, <code>oldMD5</code> binary(16) NOT NULL, <code>newMD5</code> binary(16) NOT NULL, <code>SHAC</code> binary(32) NOT NULL DEFAULT '00000000000000000000000000000000', <code>stoppedOnSignature</code> varchar(255) NOT NULL DEFAULT '', <code>stoppedOnPosition</code> int(10) unsigned NOT NULL DEFAULT '0', <code>isSafeFile</code> varchar(1) NOT NULL DEFAULT '?', PRIMARY KEY (<code>filenameMD5</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfBlockedIPLog ( <code>IP</code> binary(16) NOT NULL DEFAULT '0000000000000000', <code>countryCode</code> varchar(2) NOT NULL, <code>blockCount</code> int(10) unsigned NOT NULL DEFAULT '0', <code>unixday</code> int(10) unsigned NOT NULL, <code>blockType</code> varchar(50) NOT NULL DEFAULT 'generic', PRIMARY KEY (<code>IP</code>,<code>unixday</code>,<code>blockType</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfSNIPCache ( <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT, <code>IP</code> varchar(45) NOT NULL DEFAULT '', <code>expiration</code> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, <code>body</code> varchar(255) NOT NULL DEFAULT '', <code>count</code> int(10) unsigned NOT NULL DEFAULT '0', <code>type</code> int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (<code>id</code>), KEY <code>expiration</code> (<code>expiration</code>), KEY <code>IP</code> (<code>IP</code>), KEY <code>type</code> (<code>type</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfKnownFileList ( <code>id</code> int(11) unsigned NOT NULL AUTO_INCREMENT, <code>path</code> text NOT NULL, PRIMARY KEY (<code>id</code>) ) DEFAULT CHARSET=utf8; CREATE TABLE wp_wfNotifications ( <code>id</code> varchar(32) NOT NULL DEFAULT '', <code>new</code> tinyint(3) unsigned NOT NULL DEFAULT '1', <code>category</code> varchar(255) NOT NULL, <code>priority</code> int(11) NOT NULL DEFAULT '1000', <code>ctime</code> int(10) unsigned NOT NULL, <code>html</code> text NOT NULL, <code>links</code> text NOT NULL, PRIMARY KEY (<code>id</code>) ) DEFAULT CHARSET=utf8;; CREATE TABLE wp_wfLiveTrafficHuman ( <code>IP</code> binary(16) NOT NULL DEFAULT '0000000000000000', <code>identifier</code> binary(32) NOT NULL DEFAULT '00000000000000000000000000000000', <code>expiration</code> int(10) unsigned NOT NULL, PRIMARY KEY (<code>IP</code>,<code>identifier</code>), KEY <code>expiration</code> (<code>expiration</code>) ) DEFAULT CHARSET=utf8;
- This reply was modified 2 years, 4 months ago by peterlukacs.
Viewing 2 replies - 1 through 2 (of 2 total)