[Spamassassin Wiki] Update of "BetterDocumentation/SqlReadmeBayes" by TimHunter

[Apache Wiki <wi...@apache.org>]

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)]]
+