Online demo Privacy policy GoBD notes Blog

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
current:upgrade [2018/04/30 15:27]
sj
current:upgrade [2018/08/03 22:00]
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