Sorry 7.3. Julian
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Dan Egli > Sent: Saturday, July 12, 2003 10:42 AM > To: [EMAIL PROTECTED] > Subject: Re: TMDA with MySQL > > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Robin Lynn Frank wrote: > | Since the only thing on my agenda is seeing Terminator 3, I figured > I'd try to > | make the rest of the weekend "exciting" as well, by adding MySQL > support to > | TMDA. I've downloaded and will install the mysql extension for python. > | > | Here comes the hard part. I know nothing about MySQL. Is there some > kind of > | howto that would understandable by the clinically brain-dead, > like me? I > | looked at the documentation on the tmda site and it doesn't look too > | difficult. > | > | BTW, reply to the list only. We are still tuning our new server and > it is > | sending out mail with the local machine name. (Maybe this > weekend will be > | exciting, after all). > > Well... What kind of help are you specifically looking for? Making TMDA > Read from a MySQL Database for filters is easy. just add from-mysql (or > from-mysql -like) to your inbound filter file. For example, > from-mysql -like dan_whitelist > > the -like allows you to use the % mysql wildcard to match addresses. > i.e. I have twards the end of the list: [EMAIL PROTECTED] That > matches ANY address at shortcircuit.dyndns.org. > > Now add the MYSQL lines to your ./tmda/config or /etc/tmdarc file. The > lines you need are: > > MYSQL_ENABLED = 1 > MYSQL_DATABASE = <name of your database> > (I used mysql_database = "TMDA") > MYSQL_HOST = <your host, i.e. localhost> > MYSQL_USER = <the username you assign to TMDA using MySQL's grant cmd> > MYSQL_PASSWORD = <tmda's mysql password, assigned by grant command> > > > For example: those lines might look like this: > > MYSQL_ENABLED = 1 > MYSQL_DATABASE = "tmdalists" > MYSQL_HOST = "localhost" > MYSQL_USER = "tmdacheck" > MTSQL_PASSWORD = "e^54!8p" > > and NO, the password is not encrypted. Thats just a strong password. > It's clear text. > > > - --- Dan > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.2 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQE/ECxCxQEzeXtVwzoRApGOAJ42SGcy7jPCXf7MgDqkSVZGe7juBQCaAoIo > kAVM4rQ5lgfLlDRty/lNWnI= > =Mgq+ > -----END PGP SIGNATURE----- > > > _____________________________________________ > tmda-users mailing list ([EMAIL PROTECTED]) > http://tmda.net/lists/listinfo/tmda-users > > _____________________________________________ tmda-users mailing list ([EMAIL PROTECTED]) http://tmda.net/lists/listinfo/tmda-users
