Hi all, I installed ASSP 2.01 RC 0.5.26 on Debian Lenny. The mail user accounts are held in a postgresql database (V 8.3.8), so I decided to stay with postgresql for ASSP's tables. On startup ASSP falls back to files instead of database tables and I find errors like these in my postgres.log:
2009-11-22 21:30:30 CET FEHLER: Typ »varbinary« existiert nicht bei Zeichen 33 2009-11-22 21:30:30 CET ANWEISUNG: create table whitelist (pkey varbinary(254) primary key,pvalue varbinary(255)) This "varbinary" apparently does not exist with Postgresql. I dared change line 6022 in assp.pl from: 'Pg' => [qw/ varbinary(254) varbinary(255) int 0 0 /], to 'Pg' => [qw/ bytea bytea int 0 0 /], This way I get ASSP up and running. Yet I wonder about the number of DB connections. ASSP opens 133 connections to the postgresql database right from the start, even without any mail traffic. Is it a bug or a feature? :-) I did not find a place where I could tune this. Best regards Dirk Kulmsee ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test
