>If I delete the table will ASSP recreate it from file? yes, assp will create all configured tables at startup
>What’s the best way to restore the database tables? if configured assp has made databasetables backups to the mysql folder read the database section of the GUI, fill the importfolder, run an import Thomas Von: "James Brown via Assp-test" <assp-test@lists.sourceforge.net> An: "ASSP development mailing list" <assp-test@lists.sourceforge.net> Kopie: "James Brown" <jlbr...@bordo.com.au> Datum: 20.09.2020 11:11 Betreff: [Assp-test] "Error: FIRSTKEY (ldaplist): Can't execute select statement: MySQL server has gone away" My mail server rebooted itself and when it came up, MySQL gave this error: 2020-09-20T08:41:44.966301Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2020-09-20T08:41:44.966320Z 0 [ERROR] InnoDB: Page [page id: space=54, page number=39362] log sequence number 1092955697132 is in the future! Current system log sequence number 939392966672. I ran: sudo rm /usr/local/var/mysql/ib_logfile0 And sudo rm /usr/local/var/mysql/ib_logfile1 And it started up OK and other programs (eg Dovecot) could connect to it Ok. But ASSP is having problems connecting to it: Sep-20-20 18:24:51 [init] Try using mysql database <ASSP> for selected tables Sep-20-20 18:24:52 [init] Using table <whitelist> in mysql Database <ASSP> instead of file /Applications/assp/whitelist Sep-20-20 18:24:52 [init] Using table <persblack> in mysql Database <ASSP> instead of file /Applications/assp/persblack Sep-20-20 18:24:52 [init] Using table <redlist> in mysql Database <ASSP> instead of file /Applications/assp/redlist Sep-20-20 18:24:52 [init] Using table <delaydb> in mysql Database <ASSP> instead of file /Applications/assp/delaydb Sep-20-20 18:24:52 [init] Using table <delaywhitedb> in mysql Database <ASSP> instead of file /Applications/assp/delaydb.white Sep-20-20 18:24:52 [init] Using table <pbwhite> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.white.db Sep-20-20 18:24:52 [init] Using table <pbblack> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.black.db Sep-20-20 18:24:52 [init] Using table <rblcache> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.rbl.db Sep-20-20 18:24:52 [init] Using table <uriblcache> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.uribl.db Sep-20-20 18:24:52 [init] Using table <ptrcache> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.ptr.db Sep-20-20 18:24:52 [init] Using table <mxacache> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.mxa.db Sep-20-20 18:24:52 [init] Using table <rwlcache> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.rwl.db Sep-20-20 18:24:52 [init] Using table <spfcache> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.spf.db Sep-20-20 18:24:52 [init] Using table <sbcache> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.sb.db Sep-20-20 18:24:52 [init] Using table <pbtrap> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.trap.db Sep-20-20 18:24:52 [init] Using table <dkimcache> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.dkim.db Sep-20-20 18:24:52 [init] Using table <batvtag> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.batv.db Sep-20-20 18:24:52 [init] Using table <backdns> in mysql Database <ASSP> instead of file /Applications/assp/pb/pbdb.back.db Sep-20-20 18:24:52 [init] Using table <spamdb> in mysql Database <ASSP> instead of file /Applications/assp/spamdb Sep-20-20 18:24:52 [init] Using table <spamdbhelo> in mysql Database <ASSP> instead of file /Applications/assp/spamdb.helo Sep-20-20 18:24:52 [init] Using table <hmmdb> in mysql Database <ASSP> instead of file /Applications/assp/HMMdb Sep-20-20 18:24:52 [init] Using table <ldaplist> in mysql Database <ASSP> instead of file /Applications/assp/ldaplist Sep-20-20 18:24:52 [init] Info: adminusersdb (/Applications/assp/095bf7ffa01dc5080508ff2f6c1baf3094edef43bb1819b882da2131d50868fd317544b1c4163223504f07d92f73490574184c46b340f32746c9ca702ab2ce6753a363a0641b5240c3172440e5750ba995705e4ccef8ee722059737b61b050935e2e14e8163a8e058a4a639e6dcea52e006a511da1) - loaded Sep-20-20 18:24:52 [init] Info: adminusersdb (/Applications/assp/095bf7ffa01dc5080508ff2f6c1baf3094edef43bb1819b882da2131d50868fd317544b1c4163223504f07d92f73490574184c46b340f32746c9ca702ab2ce6753a363a0641b5240c3172440e5750ba995705e4ccef8ee722059737b61b050935e2e14e8163a8e058a4a639e6dcea52e006a511da1.right) - loaded Sep-20-20 18:24:54 [init] Database count statement failed (hmmdb): Lost connection to MySQL server during query Sep-20-20 18:24:54 [init] Error: FIRSTKEY (hmmdb): Can't execute select statement: MySQL server has gone away Running: ASSP version 2.6.4 *SPAM-Evaporator* build 20224 mySQL version 5.7 What’s the best way to restore the database tables? If I delete the table will ASSP recreate it from file? Thanks, James._______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test DISCLAIMER: ******************************************************* This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the individual to whom it is addressed. This email was multiple times scanned for viruses. There should be no known virus in this email! *******************************************************
_______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test
