RE: [Dbmail-dev] Re: table prefix and configs

2004-01-08 Thread Mark Mackay - Orcon
Hi [EMAIL PROTECTED] - Thanks for your comments, but I don't know if I explained myself right, although I'd love alternate ideas for dealing with our complicated needs: To start off with we have a database full of users, including say "mark". Mark connects through to pop3.ispa.co.nz and is us

Re: [Dbmail-dev] Re: table prefix and configs

2004-01-09 Thread Aaron Stone
Actually, I think a much better way of doing this is to give DBMail a few 'keywords' that can be used in configurable auth queries. [AUTH] auth_user_exists = SELECT name AS %user_name%, uid AS %user_idnr% FROM radius.usernames WHERE name = %auth_user_name% AND ipaddr = %auth_ip_address% Something

RE: [Dbmail-dev] Re: table prefix and configs

2004-01-10 Thread Mark Mackay - Orcon
> Actually, I think a much better way of doing this is to give > DBMail a few 'keywords' that can be used in configurable auth queries. Absolutely -- this is exactly what I had in mind. I only thing the queries that relate to determining a user's user_idnr are the ones that need to be customizabl