On Tue, August 29, 2006 09:45, Anders Norrbring wrote: > Benny Pedersen skrev: >> On Tue, August 29, 2006 08:16, Anders Norrbring wrote: >> >>> [6204] dbg: bayes: unable to initialize database for vscan user, aborting! >> >> from a new sql database this is default error, means that there is no data >> to work with so far > > Well, there actually IS one post in the DB.. When I run spamassassin -D > --lint it connects as root, and both reads and writes to the database.
sa-laern --dump magic -u root sa-laern --dump magic -u vscan >>> Shouldn't SA try to contact MySQL as "username" and not as "vscan"? The >>> processes runs as the user vscan. >> in next life of spamassassin :-) > But what's the bayes_sql_username config parameter good for then? it will lock to unix user name to the value of username with means you will only have one user in sql if its set sa-laern will report the same data in my above example, eg -u root will use -u vscan data from sql just dont set it and later do sa-laern --claen since all data will be lost then even if you only wanted it to be for -u root > I also tried to set bayes_sql_override_username = username, no luck > there either. sa-learn --dump magic -u username and still this is not working since you cant have email adresses as unix accounts got it ? but on the other hand sa-learn --dump magic -u [EMAIL PROTECTED] works in sql -- "This message was sent using 100% recycled spam mails."
