Hi.
I had ASSP working fine in my personal server with MySQL 5.7, but I had to
switch to MariaDB 10.1 and ASSP stoped working with database!
I have access to the same database (I've tested with local command line
using the same user, password and DB name) and it's working, but ASSP
don't. Also, I've droped all tables so ASSP could create all again....but
it don't! And for least: I'm seeing some chinese chars on log! I don't have
any idea what's it!
This is my log (just some parts):
Apr-30-16 09:51:01 [init] Info: the DBI connection string is set to:
'DBI:mysql:database=assp;host=localhost'
Apr-30-16 09:51:01 [init] Info: start loading LDAPlist from
/usr/share/assp/ldaplist with approx. 128
Apr-30-16 09:51:01 [init] Info: LDAPlist loaded from
/usr/share/assp/ldaplist with 0 records
Apr-30-16 09:51:01 [init] Starting maintenance worker thread [10000] -
ThreadCycleTime is set to 3000 microseconds
Apr-30-16 09:51:02 [Worker_10000] Info: switched (DNS) nameserver order
from 192.168.22.1 , 200.175.5.139 to 192.168.22.1 , 200.175.5.139
䅰爭㌰ⴱ㘠〹㨵ㄺ〲⁛坯牫敲弱〰〰崠坨楴敬楳琠摡瑡扡獥牲潲㨠楮獴慬江摲楶敲⡭祳煬⤠晡楬敤㨠䍡渧琠汯慤‧⽵獲⽬楢⽰敲氵⽳楴敟灥牬⼵⸲㈮ㄯ砸㙟㘴楮畸桲敡搭浵汴椯慵瑯⽄䉄⽭祳煬⽭祳煬漧潲潤畬攠䑂䐺
㩭祳煬㨠汩扭祳煬捬楥湴漮㈰㨠捡湮潴灥渠獨慲敤扪散琠晩汥㨠乯畣栠晩汥爠摩牥捴潲礠慴
畳爯汩戯灥牬㔯㔮㈲⸱⽸㠶弶㐭汩湵砭瑨牥慤畬瑩⽄祮慌潡摥爮灭楮攠ㄹ㌮ਉ
慴�敶慬‵〸⤠汩湥″⁴桲敡搠ㄮਉ䍯浰楬慴楯
渠晡楬敤渠牥煵楲攠慴�敶慬‵〸⤠汩湥″⸊ॐ敲桡灳敱畩牥搠獨慲敤楢牡特爠摬氠楳渧琠楮獴慬汥搠睨敲攠數灥捴敤ਉ琠獵戠浡楮㨺楮楴䑂䡡獨敳楮攠㐴⁴桲敡搠ㄮApr-30-16
09:51:03 [Worker_10000] Worker_10000 started
Apr-30-16 09:51:03 [Worker_10000] Info: last delta Griplist download was
at: Apr-30-16 03:06:51
Apr-30-16 09:51:03 [init] Starting SMTP-worker-threads with ThreadCycleTime
set to 3000 microseconds
Apr-30-16 09:51:03 [init] Starting communication worker threads [1 to 3]
䅰爭㌰ⴱ㘠〹㨵ㄺ〵⁛坯牫敲弱崠坨楴敬楳琠摡瑡扡獥牲潲㨠楮獴慬江摲楶敲⡭祳煬⤠晡楬敤㨠䍡渧琠汯慤‧⽵獲⽬楢⽰敲氵⽳楴敟灥牬⼵⸲㈮ㄯ砸㙟㘴楮畸桲敡搭浵汴椯慵瑯⽄䉄⽭祳煬⽭祳煬漧潲潤畬攠䑂䐺㩭祳
煬㨠汩扭祳煬捬楥湴漮㈰㨠捡湮潴灥渠獨慲敤扪散琠晩汥㨠乯畣栠晩汥爠摩牥捴潲礠慴
畳爯汩戯灥牬㔯㔮㈲⸱⽸㠶弶㐭汩湵砭瑨牥慤畬瑩⽄祮慌潡摥爮灭楮攠ㄹ㌮ਉ
慴�敶慬‴㤸⤠汩湥″⁴桲敡搠㈮ਉ䍯浰楬慴楯渠晡
楬敤渠牥煵楲攠慴�敶慬‴㤸⤠汩湥″⸊ॐ敲桡灳敱畩牥搠獨慲敤楢牡特爠摬氠楳渧琠楮獴慬汥搠睨敲攠數灥捴敤ਉ琠獵戠浡楮㨺楮楴䑂䡡獨敳楮攠㐴⁴桲敡搠㈮Apr-30-16
09:51:06 [Worker_1] Worker_1 started
䅰爭㌰ⴱ㘠〹㨵ㄺ〷⁛坯牫敲弲崠坨楴敬楳琠摡瑡扡獥牲潲㨠楮獴慬江摲楶敲⡭祳煬⤠晡楬敤㨠䍡渧琠汯慤‧⽵獲⽬楢⽰敲氵⽳楴敟灥牬⼵⸲㈮ㄯ砸㙟㘴楮畸桲敡搭浵汴椯慵瑯⽄䉄⽭祳煬⽭祳煬漧潲潤畬攠䑂䐺㩭祳
煬㨠汩扭祳煬捬楥湴漮㈰㨠捡湮潴灥渠獨慲敤扪散琠晩汥㨠乯畣栠晩汥爠摩牥捴潲礠慴
畳爯汩戯灥牬㔯㔮㈲⸱⽸㠶弶㐭汩湵砭瑨牥慤畬瑩⽄祮慌潡摥爮灭楮攠ㄹ㌮ਉ
慴�敶慬‴㤸⤠汩湥″⁴桲敡搠㌮ਉ䍯浰楬慴楯渠晡
楬敤渠牥煵楲攠慴�敶慬‴㤸⤠汩湥″⸊ॐ敲桡灳敱畩牥搠獨慲敤楢牡特爠摬氠楳渧琠楮獴慬汥搠睨敲攠數灥捴敤ਉ琠獵戠浡楮㨺楮楴䑂䡡獨敳楮攠㐴⁴桲敡搠㌮Apr-30-16
09:51:08 [Worker_2] Worker_2 started
䅰爭㌰ⴱ㘠〹㨵ㄺ〹⁛坯牫敲弳崠坨楴敬楳琠摡瑡扡獥牲潲㨠楮獴慬江摲楶敲⡭祳煬⤠晡楬敤㨠䍡渧琠汯慤‧⽵獲⽬楢⽰敲氵⽳楴敟灥牬⼵⸲㈮ㄯ砸㙟㘴楮畸桲敡搭浵汴椯慵瑯⽄䉄⽭祳煬⽭祳煬漧潲潤畬攠䑂䐺㩭祳
煬㨠汩扭祳煬捬楥湴漮㈰㨠捡湮潴灥渠獨慲敤扪散琠晩汥㨠乯畣栠晩汥爠摩牥捴潲礠慴
畳爯汩戯灥牬㔯㔮㈲⸱⽸㠶弶㐭汩湵砭瑨牥慤畬瑩⽄祮慌潡摥爮灭楮攠ㄹ㌮ਉ
慴�敶慬‴㤸⤠汩湥″⁴桲敡搠㐮ਉ䍯浰楬慴楯渠晡
楬敤渠牥煵楲攠慴�敶慬‴㤸⤠汩湥″⸊ॐ敲桡灳敱畩牥搠獨慲敤楢牡特爠摬氠楳渧琠楮獴慬汥搠睨敲攠數灥捴敤ਉ琠獵戠浡楮㨺楮楴䑂䡡獨敳楮攠㐴⁴桲敡搠㐮Apr-30-16
09:51:10 [Worker_3] Worker_3 started
Apr-30-16 09:51:10 [init] Starting rebuild SpamDB worker thread [10001] -
ThreadCycleTime is set to 30 microseconds
䅰爭㌰ⴱ㘠〹㨵ㄺㄲ⁛坯牫敲弱〰〱崠坨楴敬楳琠摡瑡扡獥牲潲㨠楮獴慬江摲楶敲⡭祳煬⤠晡楬敤㨠䍡渧琠汯慤‧⽵獲⽬楢⽰敲氵⽳楴敟灥牬⼵⸲㈮ㄯ砸㙟㘴楮畸桲敡搭浵汴椯慵瑯⽄䉄⽭祳煬⽭祳煬漧潲潤畬攠䑂䐺
㩭祳煬㨠汩扭祳煬捬楥湴漮㈰㨠捡湮潴灥渠獨慲敤扪散琠晩汥㨠乯畣栠晩汥爠摩牥捴潲礠慴
畳爯汩戯灥牬㔯㔮㈲⸱⽸㠶弶㐭汩湵砭瑨牥慤畬瑩⽄祮慌潡摥爮灭楮攠ㄹ㌮ਉ
慴�敶慬‴㤳⤠汩湥″⁴桲敡搠㔮ਉ䍯浰楬慴楯
渠晡楬敤渠牥煵楲攠慴�敶慬‴㤳⤠汩湥″⸊ॐ敲桡灳敱畩牥搠獨慲敤楢牡特爠摬氠楳渧琠楮獴慬汥搠睨敲攠數灥捴敤ਉ琠獵戠浡楮㨺楮楴䑂䡡獨敳楮攠㐴⁴桲敡搠㔮Apr-30-16
09:51:13 [Worker_10001] Worker_10001 started
Apr-30-16 09:51:13 [Worker_10001] Info: found module /usr/share/assp/lib/
rebuildspamdb.pm version 7.32
Apr-30-16 09:51:14 [init] Info: starting general debug mode to file
/usr/share/assp/debug/1462020674.dbg
Apr-30-16 09:51:14 [init] All Threads are started
Apr-30-16 09:51:14 [init] Try using mysql database <assp> for selected
tables
䅰爭㌰ⴱ㘠〹㨵ㄺㄵ⁛楮楴崠坨楴敬楳琠摡瑡扡獥牲潲㨠楮獴慬江摲楶敲⡭祳煬⤠晡楬敤㨠䍡渧琠汯慤‧⽵獲⽬楢⽰敲氵⽳楴敟灥牬⼵⸲㈮ㄯ砸㙟㘴楮畸桲敡搭浵汴椯慵瑯⽄䉄⽭祳煬⽭祳煬漧潲潤畬攠䑂䐺㩭祳煬㨠
汩扭祳煬捬楥湴漮㈰㨠捡湮潴灥渠獨慲敤扪散琠晩汥㨠乯畣栠晩汥爠摩牥捴潲礠慴 畳爯汩戯灥牬㔯㔮㈲⸱⽸㠶弶㐭汩湵砭瑨牥慤畬瑩⽄祮慌潡摥爮灭楮攠ㄹ㌮ਉ
慴�敶慬‴㤱⤠汩湥″⸊ृ潭灩污瑩潮慩汥搠楮敱畩牥
琠⡥癡氠㐹ㄩ楮攠㌮ਉ健牨慰猠愠牥煵楲敤桡牥搠汩扲慲礠潲汬獮❴湳瑡汬敤⁷桥牥硰散瑥搊ठ慴畢慩渺㩩湩瑄䉈慳桥猠汩湥‴㐮Apr-30-16
09:51:15 [init] Warning: can not use defined database - switchi
ng over to use files instead of database assp!
Apr-30-16 09:51:15 [init] Error : DB-failover loading hashes from files
Apr-30-16 09:51:15 [init] Warning : setting configvalue for adminusersdb to
adminusers
Apr-30-16 09:51:15 [init] Warning : setting configvalue for adminusersdb to
adminusers
Apr-30-16 09:51:15 [init] Info: adminusersdb (/usr/share/assp/) - loaded
Apr-30-16 09:51:15 [init] Info: adminusersdb (/usr/share/assp/.right) -
loaded
Apr-30-16 09:51:15 [init] Error: COUNT: Can't call method "_prepare" on
unblessed reference at sub main::rdbm_COUNT line 9.
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Assp-user mailing list
Assp-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-user
