Dear Wiki user,
You have subscribed to a wiki page or wiki category on "Spamassassin Wiki" for change notification.
The following page has been changed by TimHunter:
http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeBayes
------------------------------------------------------------------------------
debug: bayes: Using username: <username>
If you do not see the above text, then the SQL query was not
- successful, and you should see any error messages reported.
+ successful, and you should see any error messages reported. Note that
+ the "unable to initialize database for <username> user" message can be
+ ignored at this point -- see below for more details.
This code has been tested using MySQL as the RDMS, with basic tests
against PostgreSQL and SQLite. It does require a database that allows
@@ -213, +215 @@
o Optionally you can run 'sa-learn --clear' to remove the DBM based
bayes files.
o Modify your local.cf file according to the directions above.
+ o Run 'sa-learn --spam <sample spam message>' to initialize the
+ database.
o Run 'sa-learn --restore backup.txt' to restore your bayes data to
the SQL database.
NOTE: sa-learn must be run as the user who's data you are loading, or
you must make use of the bayes_sql_override_username config
option.
+
+ NOTE: failure to use 'sa-learn --spam <msg>' on an initial spam message
+ will result in the error message
+ "bayes: unable to initialize database for <username> user, aborting!"
+
}}}
[[Anchor(comments)]]
@@ -226, +235 @@
Please enter comments here. You can type @''''''SIG@ to insert your signature. -- DuncanFindlay [[DateTime(2005-08-22T02:48:38Z)]]
+ I found [http://www200.pair.com/mecham/spam/debian-spamassassin-sql.html "Migrating our Debian Anti-Spam Anti-Virus Gateway Email Server's Bayes database to MySQL"] very helpful in stepping me through MySQL setup & migration of my existing DBM Bayes database. -- TimHunter [[DateTime(2006-12-13T17:07:21Z)]]
+
You have subscribed to a wiki page or wiki category on "Spamassassin Wiki" for change notification.
The following page has been changed by TimHunter:
http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeBayes
------------------------------------------------------------------------------
debug: bayes: Using username: <username>
If you do not see the above text, then the SQL query was not
- successful, and you should see any error messages reported.
+ successful, and you should see any error messages reported. Note that
+ the "unable to initialize database for <username> user" message can be
+ ignored at this point -- see below for more details.
This code has been tested using MySQL as the RDMS, with basic tests
against PostgreSQL and SQLite. It does require a database that allows
@@ -213, +215 @@
o Optionally you can run 'sa-learn --clear' to remove the DBM based
bayes files.
o Modify your local.cf file according to the directions above.
+ o Run 'sa-learn --spam <sample spam message>' to initialize the
+ database.
o Run 'sa-learn --restore backup.txt' to restore your bayes data to
the SQL database.
NOTE: sa-learn must be run as the user who's data you are loading, or
you must make use of the bayes_sql_override_username config
option.
+
+ NOTE: failure to use 'sa-learn --spam <msg>' on an initial spam message
+ will result in the error message
+ "bayes: unable to initialize database for <username> user, aborting!"
+
}}}
[[Anchor(comments)]]
@@ -226, +235 @@
Please enter comments here. You can type @''''''SIG@ to insert your signature. -- DuncanFindlay [[DateTime(2005-08-22T02:48:38Z)]]
+ I found [http://www200.pair.com/mecham/spam/debian-spamassassin-sql.html "Migrating our Debian Anti-Spam Anti-Virus Gateway Email Server's Bayes database to MySQL"] very helpful in stepping me through MySQL setup & migration of my existing DBM Bayes database. -- TimHunter [[DateTime(2006-12-13T17:07:21Z)]]
+