Hi Marcel, mysql-virtual.cf seem to be fine now, but postfix still complains about mysql-mydestination.cf (Invalid query template) How should mysql-mydestination.cf should look like?
Thomas > Hello, > > > For Postfix version 2.2 and later the sql lookup syntax has changed. > > http://www.postfix.org/MYSQL_README.html > > Cyurs SASL has a similar syntax when you use the auxprop sql plugin > > instead of pam_mysql. > > http://asg.web.cmu.edu/cyrus/download/sasl/options.html > > > > I do not find any information on the list or in the documentation and > > because i'm not very familiar with the SQL syntax, i can't get > > web-cyradm to work. > > I would be very happy if someone could send me the output of the files > > mysql-*.cf, imapd.conf and smtpd.conf. > > Can i use unix domain sockets for the option sql_hostnames > > with the SASL > > auxprop plugin sql? > > i think all you have to do is to modify the postfix mysql lookup maps! > > In the old versions the lookup tables look like this: > > # the user name and password to log into the mysql server > hosts = localhost > user = mail > password = secret > # the database name on the servers > dbname = mail > # the table name > table = virtual > # > select_field = dest > where_field = alias > additional_conditions = and status = '1' > > That means he uses the database -> mail and pass and username and the sql > statemant is like this: > > SELECT dest FROM virtual WHERE alias = '%s' AND status='1' > > In the new syntax you must use something like this: > > # The user name and password to log into the mysql server. > user = someone > password = some_password > > # The database name on the servers. > dbname = customer_database > > # For Postfix 2.2 and later The SQL query template. > # See mysql_table(5) for details. > query = SELECT dest FROM virtual WHERE alias='%s' AND status='1' > > I thing, all you have to do is to modify the postfix mysql-maps > to get the same result as the old syntax it does. And use the saslauthd > instead of the auxprob plugin. > > Regards Marcel > > .::::::::::::::::::::::::::::::::::::::::::::::::::::::. > > Marcel Hartmann > Tel. 04 41 - 960 34 49 Fax 04 41 - 960 34 47 > Internet www.marcel-hartmann.com > e-Mail [EMAIL PROTECTED] > > `::::::::::::::::::::::::::::::::::::::::::::::::::::::` > > _______________________________________________ > This mailing list is hosted and supported > by bit-heads GmbH | http://www.bit-heads.ch > > _______________________________________________ > Web-cyradm mailing list > [email protected] > http://www.web-cyradm.org/mailman/listinfo/web-cyradm _______________________________________________ This mailing list is hosted and supported by bit-heads GmbH | http://www.bit-heads.ch _______________________________________________ Web-cyradm mailing list [email protected] http://www.web-cyradm.org/mailman/listinfo/web-cyradm
