-----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
