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
