Comment 3 for bug 1023550

Revision history for this message
Hauke Duden (h-ns-duden) wrote :

I cannot send you the one we use on the server. However, this one should work:

hosts = www.ubuntu.com
user = testuser
password = testpassword
dbname = testdb
query = SELECT toAddress FROM mailgw_aliases WHERE fromAddress='%s'

If you get the following error then the problem still persists:
www.ubuntu.com: Unknown MySQL server host 'www.ubuntu.com'

If you get a "connection refused" error (or similar) then you know that the DNS name was resolved correctly and the error happens when the connection is made (which likely fails because www.ubuntu.com probably does not host a public mysql DB). So that means that the fix works.