Mike, I believe the difference is that you're using MySQL for the database. I'm using flat files in /home/user/.spamassassin. In my case when I run as 'root' sa-learn looks for the database in /root/.spamassassin since that is the current user's SA database location. In your case the database location is always MySQL which doesn't depend on UNIX file permissions or path parameters.
Thanks! Jason Morrill IT Manager Child & Family Agency of Southeastern Connecticut (860) 443-2896 x1422 > > Are you sure? I do something similar to what you're doing - using a script > running as root to traverse user spam directories and learn from messages - > and there's no entry in my bayes_vars table for root. I use this to invoke > it: > > sa-learn -u $username --prefs-file=/dev/null --spam --no-sync $file > > I'm using SA 3.1.1 with a MySQL 5.0 database, if it makes a difference. >
