At 04:32 PM 2/12/2007, Ian C Roberts wrote: >> All, >> >> I have a slight problem with amavis and per user settings in a mysql >> database. I have created the tables from the sql readme doc that >> came with amavis and granted SELECT to the user that is configured in >> amavisd,conf as follows...
>> maillog >> ... >> Feb 12 22:14:48 freebsd postfix/smtp[67985]: warning: connect to >> mysql server localhost: Can't connect to local MySQL server through >> socket '/tmp/mysql.sock' (2) >> Feb 12 22:14:48 freebsd postfix/smtp[67985]: fatal: mysql:/etc/ >> postfix/sql/transport(0,lock|fold_fix): table lookup problem > Postfix can't do its own sql lookups anymore. This has nothing > (directly) to do with amavisd-new. Maybe you inadvertently changed > something in the postfix or MySQL setup, or maybe MySQL isn't running. > -- > Noel Jones Thanks for the reply Noel. All i am changing is the $sql_dsn_lookup in amavisd.conf file. This file was previously adjusted with my default settings. When I comment it out and restart amavisd-new everything is fine. I have not idea why postfix smtp process is behaving like this when I ask amavis to do sql lookup for user settings....Please help Thanks, Ian ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/