Don't use UTF8 for the DB-tables - the records may contain some UTF8 data but at all! If there is some UTF8 conversion to do - ASSP will do that! I've used Windows1252 and template0 to create the DB but any other single byte characterset should work.
You should switch to 0.6.10: - open the GUI - export all data - change 'adminusersdbNoBIN' to 1 (on) - shutdown assp - replace assp.pl and assp_database_readme.txt with the latest versions - delete the DB in PG-Admin - create the DB (single byte charset) in PG-Admin - copy/move the exported files to the import dir - rename them to *.rpl (or use any other ASSP formated file) - start assp - the import will run automaticly at startup - wait until the import has finished for all tables - restart assp to freeup memory Thomas "Dirk Kulmsee" <[email protected]> 06.12.2009 23:06 Bitte antworten an ASSP development mailing list <[email protected]> An "'ASSP development mailing list'" <[email protected]> Kopie Thema Re: [Assp-test] Antwort: ASSP 2.01_RC0.6.09 / Postgres / assp_db_import.cfg > Ive tested the following: > > - Postgres 8.4 on Win32 > - assp_db_import.cfg 2.0.1_1.0.0 > - assp.pl 2.0.1_RC0.6.10 > > whithout any DB-errors! Thanks for your effort Thomas. You are really working quickly on this. But I'm sorry to say that I still see same "fetchrow_arrayref" error with spamdb. I have the same versions of assp.pl and assp_db_import.cfg, but I use Postgres 8.3.8 on Debian Lenny. The system locale is UTF8 and so is the database. Could this be a cause for concern? I activated some Postgres logging and get lines like these: Dec 6 22:46:35 mail postgres[15680]: [3-1] 2009-12-06 22:46:35 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:46:35 mail postgres[15680]: [3-2] 2009-12-06 22:46:35 CET TIPP: Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit der Kodierung übereinstimmt, Dec 6 22:46:35 mail postgres[15680]: [3-3] die der Server erwartet, welche durch »client_encoding« bestimmt wird. Dec 6 22:46:35 mail postgres[15680]: [3-4] 2009-12-06 22:46:35 CET ANWEISUNG: select pvalue,pfrozen from spamdb where pkey=$1 Dec 6 22:46:35 mail postgres[15680]: [3-5] #011 Dec 6 22:46:36 mail postgres[15570]: [3-1] 2009-12-06 22:46:36 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:46:36 mail postgres[15570]: [3-2] 2009-12-06 22:46:36 CET TIPP: Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit der Kodierung übereinstimmt, Dec 6 22:46:36 mail postgres[15570]: [3-3] die der Server erwartet, welche durch »client_encoding« bestimmt wird. Dec 6 22:46:36 mail postgres[15570]: [3-4] 2009-12-06 22:46:36 CET ANWEISUNG: select pvalue,pfrozen from spamdb where pkey=$1 Dec 6 22:46:36 mail postgres[15570]: [3-5] #011 (Sorry if its ugly to read, but rsyslog apparently does not guess the message encoding right.) At the same time the mail.log shows: Dec 6 22:46:36 mail assp[14480]: [Worker_1] Error: Worker_1: Can't call method "fetchrow_arrayref" on an undefined value at /usr/local/share/perl/5.10.0/Tie/RDBM.pm line 166. Dec 6 22:46:36 mail assp[14480]: [Worker_1] Info: auto restart died worker Worker_1 Dec 6 22:46:36 mail assp[14480]: [Worker_1] Worker_1 started Dec 6 22:46:36 mail assp[14480]: [Worker_2] Error: Worker_2: Can't call method "fetchrow_arrayref" on an undefined value at /usr/local/share/perl/5.10.0/Tie/RDBM.pm line 166. Dec 6 22:46:36 mail assp[14480]: [Worker_2] Info: auto restart died worker Worker_2 Dec 6 22:46:36 mail assp[14480]: [Worker_2] Worker_2 started There are different byte sequences Postgresql complains about: Dec 6 21:59:17 mail postgres[12247]: [3-1] 2009-12-06 21:59:17 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xfc Dec 6 22:13:17 mail postgres[13856]: [3-1] 2009-12-06 22:13:17 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:14:34 mail postgres[13811]: [3-1] 2009-12-06 22:14:34 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe47374 Dec 6 22:22:26 mail postgres[14538]: [3-1] 2009-12-06 22:22:26 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:33:21 mail postgres[14658]: [3-1] 2009-12-06 22:33:21 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe47374 Dec 6 22:35:23 mail postgres[15215]: [3-1] 2009-12-06 22:35:23 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:37:27 mail postgres[15366]: [3-1] 2009-12-06 22:37:27 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:38:13 mail postgres[14549]: [3-1] 2009-12-06 22:38:13 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:38:34 mail postgres[15470]: [3-1] 2009-12-06 22:38:34 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:38:34 mail postgres[15522]: [3-1] 2009-12-06 22:38:34 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:40:26 mail postgres[15551]: [3-1] 2009-12-06 22:40:26 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe9 Dec 6 22:46:35 mail postgres[15680]: [3-1] 2009-12-06 22:46:35 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:46:36 mail postgres[15570]: [3-1] 2009-12-06 22:46:36 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:47:26 mail postgres[15986]: [3-1] 2009-12-06 22:47:26 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:49:29 mail postgres[16005]: [3-1] 2009-12-06 22:49:29 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc3 Dec 6 22:50:04 mail postgres[16123]: [3-1] 2009-12-06 22:50:04 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe47374 Dec 6 22:59:18 mail postgres[16164]: [3-1] 2009-12-06 22:59:18 CET FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xfc I am still hopeful Dirk Kulmsee ------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ Assp-test mailing list [email protected] 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! ******************************************************* ------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ Assp-test mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/assp-test
