MySQL support? Take domain info from MySQL? Can ASSP forward to different Mail Servers based on Domain Name?

[KJS]

Hi Everyone!

I am using MySQL for my postfix mail accounts and I am wanting ASSP to
take the info from the same MySQL database if possible for stuff like
email address etc. SpamLovers, LoacAddresses, NoProcessing etc.

Is this going to be possible?

Also, I have not used ASSP for a while and I am wondering if it can
forward to different mail servers based on the domain name yet? e.g
@domain1.com goes to 192.168.1.2 and @domain2.com goes to 10.0.0.1. The
only way I have been able to do this in the past is to sit ASSP on top
of an MTA like Postfix and have that relaying the mail to another mail
server.

TIA

KJS

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Assp-user mailing list
Assp-user@...
https://lists.sourceforge.net/lists/listinfo/assp-user

[KJS]

KJS wrote:

> Hi Everyone!
>
> I am using MySQL for my postfix mail accounts and I am wanting ASSP to
> take the info from the same MySQL database if possible for stuff like
> email address etc. SpamLovers, LoacAddresses, NoProcessing etc.
>
> Is this going to be possible?
>
> Also, I have not used ASSP for a while and I am wondering if it can
> forward to different mail servers based on the domain name yet? e.g
> @domain1.com goes to 192.168.1.2 and @domain2.com goes to 10.0.0.1.
> The only way I have been able to do this in the past is to sit ASSP on
> top of an MTA like Postfix and have that relaying the mail to another
> mail server.
>
> TIA
>
> KJS
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Assp-user mailing list
Assp-user@...
https://lists.sourceforge.net/lists/listinfo/assp-user

[K Post]

I can't speak to the MySQL question as we use flat files here.

As for your question about using different mail servers based on the
domain name, the answer is "sort of."  ASSP can't do exactly this
because the connection to the smtp server is established at the time
of connection, not after the rcpt to is sent.  Do you can't directly
specifiy what server is used for what domain name.

However, you CAN tell assp to connect to diffrent SMTP servers based
on the IP address that the connection came in on.  So, if you have a
system with multiple IP addresses, you can use
SMTP Destination Routing Table (smtpDestinationRT) to control what goes where.

You'd control what domain goes to what ASSP ip using MX records in DNS.

Then for smtpDestinationRT you'd do something like:
141.120.110.1=>141.120.110.129:25|141.120.110.2=>141.120.110.130:125|141.120.110.3=>141.120.110.130:125

This would direct anyting coming in on 141.120.110.1 to port 25 on
141.120.110.129, anything on 141.120.110.2 to port 125 of
141.120.110.130, and anything on 141.120.110.3 to port 125 of
141.120.1.130

Hope this helps.

On Fri, Nov 6, 2009 at 7:37 AM, KJS <lists@...> wrote:

> KJS wrote:
>> Hi Everyone!
>>
>> I am using MySQL for my postfix mail accounts and I am wanting ASSP to
>> take the info from the same MySQL database if possible for stuff like
>> email address etc. SpamLovers, LoacAddresses, NoProcessing etc.
>>
>> Is this going to be possible?
>>
>> Also, I have not used ASSP for a while and I am wondering if it can
>> forward to different mail servers based on the domain name yet? e.g
>> @domain1.com goes to 192.168.1.2 and @domain2.com goes to 10.0.0.1.
>> The only way I have been able to do this in the past is to sit ASSP on
>> top of an MTA like Postfix and have that relaying the mail to another
>> mail server.
>>
>> TIA
>>
>> KJS
>>
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Assp-user mailing list
> Assp-user@...
> https://lists.sourceforge.net/lists/listinfo/assp-user
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Assp-user mailing list
Assp-user@...
https://lists.sourceforge.net/lists/listinfo/assp-user

[KJS]

K Post wrote:

> I can't speak to the MySQL question as we use flat files here.
>
> As for your question about using different mail servers based on the
> domain name, the answer is "sort of."  ASSP can't do exactly this
> because the connection to the smtp server is established at the time
> of connection, not after the rcpt to is sent.  Do you can't directly
> specifiy what server is used for what domain name.
>
> However, you CAN tell assp to connect to diffrent SMTP servers based
> on the IP address that the connection came in on.  So, if you have a
> system with multiple IP addresses, you can use
> SMTP Destination Routing Table (smtpDestinationRT) to control what goes where.
>
> You'd control what domain goes to what ASSP ip using MX records in DNS.
>
> Then for smtpDestinationRT you'd do something like:
> 141.120.110.1=>141.120.110.129:25|141.120.110.2=>141.120.110.130:125|141.120.110.3=>141.120.110.130:125
>
> This would direct anyting coming in on 141.120.110.1 to port 25 on
> 141.120.110.129, anything on 141.120.110.2 to port 125 of
> 141.120.110.130, and anything on 141.120.110.3 to port 125 of
> 141.120.1.130
>
>  

Hummm, could end up using lots of IP addresses! Guess I am stuck with
Postfix then...

Thanks.

Anyone know about the MySQL stuff?

TIA

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Assp-user mailing list
Assp-user@...
https://lists.sourceforge.net/lists/listinfo/assp-user

[K Post]

Out of curiosity, why do you need each unique domain to go to a
different mail server?  Maybe if you explain, someone here can help
you come up with an alternate solution.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Assp-user mailing list
Assp-user@...
https://lists.sourceforge.net/lists/listinfo/assp-user