Online demo Privacy policy

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
current:upgrade [2018/04/30 15:27]
sj
current:upgrade [2018/08/03 22:00] (current)
sj
Line 265: Line 265:
 sphinx.conf (for all sql_query_pre settings!): sphinx.conf (for all sql_query_pre settings!):
 <​code>​sql_query_pre = SET NAMES utf8</​code>​ <​code>​sql_query_pre = SET NAMES utf8</​code>​
 +
 +Perform the following sql statements:
 +
 +<​code>​
 +alter table sph_index change column `from` `from` tinyblob default null;
 +alter table metadata change column `from` `from` varchar(255) not null;
 +alter table metadata change column `fromdomain` `fromdomain` varchar(255) not null;
 +alter table metadata change column `message_id` `message_id` varchar(255) not null;
 +alter table attachment change column `name` `name` tinyblob default null;
 +alter table sph_index change column `body` `body` mediumblob default null;
 +alter table sph_index change column `subject` `subject` blob default null;
 +</​code>​
 +
 +And add the following jobs to piler'​s crontab:
 +
 +<​code>​
 +*/5 * * * * /​usr/​bin/​find /​var/​piler/​error -type f|wc -l > /​var/​piler/​stat/​error
 +3 * * * * /​usr/​local/​libexec/​piler/​watch_sphinx_main_index.sh
 +</​code>​
 +
Google Analytics Alternative