-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 On Saturday 12 July 2003 08:41, Dan Egli wrote: > 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 > Oddly enough, the TMDA end of things, is pretty straight-forward to me. It is creating and getting data into the MySQL end of things that has me confused. To simplify things, I tried using webmin's MySQL module. Didn't get very far.
I've got the tmda end of things pretty much ready to go already.. Will work on it more after going to an early Terminator 3 show. "I'll be back." ;-) - -- Robin Lynn Frank | Director of Operations | Paradigm-Omega, LLC � 2003 Paradigm-Omega, LLC. All rights reserved. Unauthorized reproduction or dissemination is prohibited. If the PGP signature is missing, please forward it to [EMAIL PROTECTED] Incoming mail with S/MIME or detatched PGP Signatures will be considered unsigned. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/EC/8mq9pLlRaCV8RA29xAJ9/bELSA//1Kbnl0J+rKztAlfZgpQCeOHmz EWtjPNxP0Kc3OKKu5tkWvN8= =QNr1 -----END PGP SIGNATURE----- _____________________________________________ tmda-users mailing list ([EMAIL PROTECTED]) http://tmda.net/lists/listinfo/tmda-users
