<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Michael C. Neel wrote:<br>
<br>
<span style="white-space: pre;">> There may be a problem in 1.0rc1
in using MySQL, which I'm trying to<br>
> do to see how it would go. Currently you get the traceback:<br>
> <br>
> ...... msginfoDB = MessageInfoDB(message_info_db_name) elif<br>
> options["Storage", "persistent_use_database"] is False or \ <br>
> options["Storage", "persistent_use_database"] == "pickle":
msginfoDB<br>
> = MessageInfoPickle(message_info_db_name)<br>
> <br>
> <br>
> I'm not sure exactly how MySQL is supposed to work, I can't find
docs<br>
> on it other than source code comments =). My impressions is the<br>
> msgingo.db is *not* placed into the mysql database at this time,
only<br>
> the hammie.db.<br>
> <br>
>> /You need to set the [Storage] persistent_use_database option
to<br>
>> "mysql". You can do this via the web interface, I believe, or
just<br>
>> by manually editing your configuration file. The 'name' of your<br>
>> database should be something like:<br>
>> <br>
>> host:localhost user:username pass:password dbname:database_name<br>
>> <br>
>> (If you leave any one item out, they default to:<br>
>> <br>
>> host = "localhost" username = "root" password = "" db_name =<br>
>> "spambayes" )<br>
>> <br>
>> You need to set the mySQL db up yourself first, creating the<br>
>> appropriate database. The table "bayes" will be created by<br>
>> SpamBayes.<br>
>> <br>
>> Feedback would be great! /<br>
>></span><br>
Well, I have also got the error<br>
<br>
D:\Python23\Scripts>python sb_imapfilter.py -b<br>
Traceback (most recent call last):<br>
File "sb_imapfilter.py", line 121, in ?<br>
from spambayes.UserInterface import UserInterfaceServer<br>
File "D:\PYTHON23\Lib\site-packages\spambayes\UserInterface.py", line
89, in ?<br>
<br>
from spambayes import Stats<br>
File "D:\PYTHON23\Lib\site-packages\spambayes\Stats.py", line 34, in ?<br>
from spambayes.message import msginfoDB<br>
ImportError: cannot import name msginfoDB<br>
<br>
As I have said, I am using the latest CVS from the public server. I
have set my mysql server to have the default values of having a user
root, password {none} with a database of 'spambayes'. My
bayescustomize.ini is as follows<br>
<br>
[Storage]<br>
messageinfo_storage_file:<br>
persistent_storage_file:<br>
persistent_use_database:mysql<br>
[imap]<br>
password:wouldntyouliketoknow<br>
server:imap.myrealbox.com<br>
username:seepassword<br>
<br>
I have tried the default "messageinfo_storage_file:" and
"persistent_storage_file:" lines, as well as setting them to
"messageinfo_storage_file:<span style="white-space: pre;">host:localhost
user:root pass:dbname:spambayes" and </span>"persistent_storage_file:<span
style="white-space: pre;">host:localhost user:root
pass:dbname:spambayes"<br>
AND tried setting the last lines without the password part.<br>
<br>
As you can see, I've tried everything I could think of.<br>
<br>
Any help would be greatly appreciated.<br>
<br>
Alex Brooks<br>
<br>
(again)<br>
</span>
</body>
</html>