Hello, I've been migrating my SpamAssassin table from one database/user to a more proper user, database, and table-name, and am having a complication with the documented user_scores_sql_table...
Using this in the local.cf, for PostgreSQL: user_scores_dsn DBI:Pg:dbname=dbmail;host=localhost user_scores_sql_username %%% user_scores_sql_password %%% user_scores_sql_table spamassassin_rules The setup is to use the database, dbmail as shown. In there is a spamassassin table, which uses internal references for data storage. The spamassassin_rules is a view to lookup linked data, and return them in the same manner userprefs was originally. Using user_scores_sql_table isn't working, because it's still looking for a table, userprefs, as shown in the following log entry: Oct 18 13:38:40 %host% spamd[1617]: SQL Error: select preference, value from userpref where username = '%username%' OR username = 'GLOBAL' ERROR: Relation "userpref" does not exist -- Eric Renfro Myrddin Computers & Designs - CEO/President ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
