Has anyone tested amavisd-new sql connection via dns name?
Or, question is if amavisd-new DBI connection fails, does it make a dns
request or did it cache the dns request (SQL replication is a different
question)
Instead of:
@lookup_sql_dsn = ( ['DBI:mysql:host=localhost;dbname=mail', 'amavis',
''] );
This:
@lookup_sql_dsn = ( ['DBI:mysql:host=sqlhost.loc;dbname=mail', 'amavis',
''] );
Where sqlhost.loc is a local dns zone with two entries:
sqlhost.loc IN A 127.0.0.1
sqlhost.loc IN A {backupip}
Some background:
Freebsd, using CARP for ip failover, using mysql replication.
The 'backupup' is intended to be the CARP virtual address.
I was hoping that DBI would connect to 'localhost' via socket first if
it could, then if that sql server fails, do a dns lookup and pull the
second ip.
Again, not looking for a discussion on sql replication OR carp, just
amavisd-new
(well, second question, what does postfix and SA do in same situation)
If no one has tested this, I will and post results.
--
Michael Scheidell, CTO
SECNAP Network Security Corporation
http://www.secnap.com
-----------------------------------------------------------------
This email has been scanned and certified safe by SpammerTrap(tm)
For Information please see http://www.spammertrap.com
-----------------------------------------------------------------
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
