Hi! Try this to reproduce the bug:
Install hardy server i386, without any extras. Install Packages: • postgresql-8.3 • spamassassin • libdbd-pg-perl • libpg-perl Create spamassassin user+db on postgres: • $ sudo -i • # su - postgres • $ createuser -S -D -R -P sa • enter passwort "sa" twice • $ createdb -O sa sa • $ exit Create spamassassin Database tables, etc. • # psql -h localhost -U sa -d sa • > create language plpgsql; • > \i /usr/share/doc/spamassassin/sql/bayes_pg.sq * [CTRL-D] Configure Spamassassin to use postgres: Add this to /etc/spamassassin/local.cf: use_bayes 1 bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL bayes_sql_dsn DBI:Pg:dbname=sa bayes_sql_override_username sa bayes_sql_username sa bayes_sql_password sa bayes_auto_learn 1 Now, try to learn a mail: # sa-learn --spam /usr/share/doc/spamassassin/examples/sample-spam.txt Now you'll see the PostgreSQL error messages. Ciao Martin -- spamassassin chokes when using PostgreSQL as Bayes store https://bugs.launchpad.net/bugs/229646 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
