Re: [AMaViS-user] sql lookups (more questions with *maps)

2007-10-13 Thread Ray
On Thursday 04 October 2007 4:43:41 pm Gary V wrote: > > > On 10/4/07, Ray wrote: > > > > I think I understand a little more about what is going on. The system > > > > is set up so that you create one table, that is specific to > > > > amavis-new. It then performs it's own lookup on that table with

Re: [AMaViS-user] sql lookups (more questions with *maps)

2007-10-04 Thread Gary V
> > On 10/4/07, Ray wrote: > > > I think I understand a little more about what is going on. The system is > > > set up so that you create one table, that is specific to amavis-new. It > > > then performs it's own lookup on that table with it's own, built in, > > > select statement. (details in docu

Re: [AMaViS-user] sql lookups (more questions with *maps)

2007-10-04 Thread Ray
On Thursday 04 October 2007 12:31:15 pm Gary V wrote: > On 10/4/07, Ray wrote: > > I think I understand a little more about what is going on. The system is > > set up so that you create one table, that is specific to amavis-new. It > > then performs it's own lookup on that table with it's own, buil

Re: [AMaViS-user] sql lookups (more questions with *maps)

2007-10-04 Thread Gary V
On 10/4/07, Ray wrote: > > I think I understand a little more about what is going on. The system is set > up so that you create one table, that is specific to amavis-new. It then > performs it's own lookup on that table with it's own, built in, select > statement. (details in documentation) > Am I

Re: [AMaViS-user] sql lookups (more questions with *maps)

2007-10-04 Thread Ray
On Wednesday 03 October 2007 3:54:20 pm Gary V wrote: > On 10/3/07, Ray wrote: > > On Tuesday 02 October 2007 2:09:04 pm Ray wrote: > > > Hello, > > > I am new to amavis. I am trying to use the sql lookup for some of the > > > @*_*_maps. <...> > > > Ray > > > > I have gone through the "amavisd.con

Re: [AMaViS-user] sql lookups (more questions with *maps)

2007-10-03 Thread Gary V
On 10/3/07, Ray wrote: > On Tuesday 02 October 2007 2:09:04 pm Ray wrote: > > Hello, > > I am new to amavis. I am trying to use the sql lookup for some of the > > @*_*_maps. > > I have found > > http://www.ijs.si/software/amavisd/README.sql-mysql.txt > > and > > http://www.ijs.si/software/amavisd/R

Re: [AMaViS-user] sql lookups (more questions with *maps)

2007-10-03 Thread Ray
On Tuesday 02 October 2007 2:09:04 pm Ray wrote: > Hello, > I am new to amavis. I am trying to use the sql lookup for some of the > @*_*_maps. > I have found > http://www.ijs.si/software/amavisd/README.sql-mysql.txt > and > http://www.ijs.si/software/amavisd/README.sql.txt > and > http://www.ijs.si

[AMaViS-user] sql lookups

2007-10-02 Thread Ray
Hello, I am new to amavis. I am trying to use the sql lookup for some of the @*_*_maps. I have found http://www.ijs.si/software/amavisd/README.sql-mysql.txt and http://www.ijs.si/software/amavisd/README.sql.txt and http://www.ijs.si/software/amavisd/README.lookups.txt but I don't understand how

Re: [AMaViS-user] SQL lookups and MySQL configuration

2006-06-19 Thread Mark Martinec
Peter, > I have had a running setup using SQL (MySQL) lookups for a while now. > Now I am rethinking the SQL config since what I have in there has ended > up being very simple (about 20 @domain entries all pointing to the same > default policy). I doubt it is worth having. I am looking for the >

Re: [AMaViS-user] SQL lookups and MySQL configuration

2006-06-18 Thread Michael Scheidell
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Peter > Sent: Sunday, June 18, 2006 7:58 AM > To: amavis-new > Subject: [AMaViS-user] SQL lookups and MySQL configuration > > > I have had a running setup using SQL

[AMaViS-user] SQL lookups and MySQL configuration

2006-06-18 Thread Peter
I have had a running setup using SQL (MySQL) lookups for a while now. Now I am rethinking the SQL config since what I have in there has ended up being very simple (about 20 @domain entries all pointing to the same default policy). I doubt it is worth having. I am looking for the main rationale b

Re: [AMaViS-user] SQL Lookups.

2006-05-18 Thread Mark Martinec
Benedict. > I have created a mysql database based on cutting and pasting bits out of > README.sql.txt which creates 4 tables, mailaddr, policy, users and wblist. Ok. > Am I right in thinking that if I set a policy up in the policy table, then > set up a user in the users table, then I can modify

[AMaViS-user] SQL Lookups.

2006-05-18 Thread Benedict White
I just wanted to ask some questions about how that works, as I am having trouble understanding the documentation. I have created a mysql database based on cutting and pasting bits out of README.sql.txt which creates 4 tables, mailaddr, policy, users and wblist. Am I right in thinking that if I s

Re: [AMaViS-user] SQL lookups and maddr table

2006-02-24 Thread Mark Martinec
Paolo, > >> Why domain in maddr table is in 'subdomain fields in reverse' format? > > To facilitate producing a quick by-domain summary report by a single > > SELECT. > I think this kind of query is not in the documentation, right? The schema is documented, the rest is up to your needs, imaginat

Re: [AMaViS-user] SQL lookups and maddr table

2006-02-24 Thread Bartłomiej Syryjczyk
Paolo Cravero as2594 napisał(a): Mark, I think this kind of query is not in the documentation, right? Do you have any ready-to-use examples for this kind of reports? Perhaps they were posted on this list so they're in the archives?! Hint: SUBSTRING_INDEX(domain, '.', 1) --

Re: [AMaViS-user] SQL lookups and maddr table

2006-02-24 Thread Paolo Cravero as2594
Mark Martinec wrote: Why domain in maddr table is in 'subdomain fields in reverse' format? To facilitate producing a quick by-domain summary report by a single SELECT. Mark, I think this kind of query is not in the documentation, right? Do you have any ready-to-use examples for this kind of

Re: [AMaViS-user] SQL lookups and maddr table

2006-02-23 Thread Mark Martinec
guzik, > Why domain in maddr table is in 'subdomain fields in reverse' format? To facilitate producing a quick by-domain summary report by a single SELECT. It is not used for anyhing else. The address in normal order is available in other fields. Mark ---

[AMaViS-user] SQL lookups and maddr table

2006-02-22 Thread Bartłomiej Syryjczyk
HELO, Why domain in maddr table is in 'subdomain fields in reverse' format? guzik --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webc

[AMaViS-user] sql lookups giving weird errors

2006-02-15 Thread Alistair Ross
Hi everyone, I had a lot of problems recently with mail being identified as spam. This is still the case. Around 20% of spam is still getting through, but i'm working through the problem. I noticed that as per the amavis documentation: "No spam-related headers inserted? Here are some reasons: @

Re: [AMaViS-user] sql lookups for non-local recipients?

2005-10-13 Thread Mark Martinec
David, > I've been tweaking my amavisd-new config to try and get some efficiency > savings. One thing I did was turn off spam scanning for non-local > recipients via bypass_spam_checks_maps. Ok, although checking outgoing mail for spam can save admin's ass when some internal PCs (or a telecommut

[AMaViS-user] sql lookups for non-local recipients?

2005-10-12 Thread David R Bosso
Howdy, I've been tweaking my amavisd-new config to try and get some efficiency savings. One thing I did was turn off spam scanning for non-local recipients via bypass_spam_checks_maps. This seems to work fine, but I see that amavisd is still attempting all the per-user sql lookups for non-l