I am running v 2.2.1(12137). It appears that yesterday my mysql database got corrupted somehow, and then had too many connections open and wouldn't allow anything to connect at all.
I deleted the database, added all the .add files in to the dbimport directory. But only some of them get imported Now when I restart ASSP, I get the below messages in the log file: I have DoHMM disabled, so I don't know why it's even attempting to create/initialize the hmmdb table. But it also appears that even though 7 tables did load correctly, the HMMDb entry causes them all to revert back to using the file based files. 1. So any idea why the HMMdb error? 2. Any way to make it work for the successful ones, even if there's a problem in others? Many thanks Jul-01-12 13:23:47 [init] Try using mysql database <Assp> for selected tables Jul-01-12 13:23:48 [init] Using table <whitelist> in mysql Database <Assp> instead of file /usr/share/assp/whitelist Jul-01-12 13:23:48 [init] Using table <persblack> in mysql Database <Assp> instead of file /usr/share/assp/persblack Jul-01-12 13:23:48 [init] Using table <redlist> in mysql Database <Assp> instead of file /usr/share/assp/redlist Jul-01-12 13:23:48 [init] Using table <delaydb> in mysql Database <Assp> instead of file /usr/share/assp/delaydb Jul-01-12 13:23:48 [init] Using table <delaywhitedb> in mysql Database <Assp> instead of file /usr/share/assp/delaydb.white Jul-01-12 13:23:48 [init] Using table <spamdb> in mysql Database <Assp> instead of file /usr/share/assp/spamdb Jul-01-12 13:23:48 [init] Using table <spamdbhelo> in mysql Database <Assp> instead of file /usr/share/assp/spamdb.helo Jul-01-12 13:23:48 [init] HMMdb database error: Can't initialize data table: Can't create/write to file '/data/srv/www/htdocs/mysql/Assp/hmmdb.MYI' (Errcode: 13) at sub main::initDBHashes line 42 Jul-01-12 13:23:48 [init] Warning: can not use defined database - switching over to use files instead of database Assp! Jul-01-12 13:23:48 [init] Error : DB-failover loading hashes from files Jul-01-12 13:23:48 [init] Warning : setting configvalue for whitelistdb to whitelist Jul-01-12 13:23:48 [init] Info: Whitelist loaded from /usr/share/assp/whitelist with 6529 records Jul-01-12 13:23:48 [init] Info: Whitelist contains 6529 records - it is recommended to use a database for 'whitelistdb' -- # Jolly Farmer: Tim Jacob # Email: [email protected] <mailto:[email protected]> # Website: www.jollyfarmer.com <http://www.jollyfarmer.com> # Phone: 506-325-3850 <http://www.jollyfarmer.com/greenhouse/greenhousecontact.html> # 56 Crabbe Rd | Northampton, NB E7N 1R6 "Integrity, Quality, & Reliable Service Since 1967" ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Assp-test mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/assp-test
