Thread: Alias mappings
View Single Post
  #5  
Old 27th January 2008, 20:18
rusty rusty is offline
Member
 
Join Date: Dec 2007
Posts: 45
Thanks: 5
Thanked 0 Times in 0 Posts
Default

See below for the file requested.

My mysql database was setup by the script that comes with postfixadmin.

As mentioned in my initial post, if I alter the address field in the alias table, delivery fails completely (so it is sucessfully accessing the mysql db).

I have also used this file with the last line commented and all the others uncommented:
mysql_virtual_alias_maps.cf
*********
user = myuser
password = mypassword
hosts = 127.0.0.1
dbname = mail
#table = alias
#select_field = goto
#where_field = address
#additional_conditions = and active = '1'
query = SELECT goto FROM alias WHERE address='%s' AND active = '1'
Reply With Quote