SELECT password FROM mailbox WHERE username = someone please tell me what is going on? With authdaemond using this query I get an error saying no password for username : the machine was working great 2 weeks ago the sql query that authdaemond was using was this: SELECT username, crypt, clear, 'XXXX', 'XXXX', 'xxxxxxx' CONCAT(xxxxxx) The query they are using now is as follows: Now 2 weeks later I have come back to double check everything and cacn't figure out why sasl and authdaemond are using the wrong query. I could send and recieve mail with no problem. At one time I had everything working perfect. I have installed everything according to HOW TO's similar to this one. Change the line that starts with "authmodulelist" to read: Open /usr/local/courier/etc/authdaemonrc (if it doesn't exist, make a copy from authdaemonrc.dist located in the same directory). Of course you will have to substitue the username and password for the one you created earlier. To conserve time writing this document, I will paste the contents of the required files that allow Postfix to communicate with MySQL.Īdditional_conditions = and type = 'recipient'Īdditional_conditions = and type = 'sender'Īdditional_conditions = and type = 'client'Īdditional_conditions = and postfix = 'y' Once again, the following is borrowed from Martin List-Petersen's document. Virtual_gid_maps = mysql:/etc/postfix/mysql-virtual-gid.cf Virtual_uid_maps = mysql:/etc/postfix/mysql-virtual-uid.cf Virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-maps.cf Virtual_maps = mysql:/etc/postfix/mysql-virtual.cf Transport_maps = mysql:/etc/postfix/mysql-transport.cf Relocated_maps = mysql:/etc/postfix/mysql-relocated.cf Smtpd_client_restrictions = check_client_access mysql:/etc/postfix/mysql-client.cfĪlias_maps = mysql:/etc/postfix/mysql-aliases.cf Smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-sender.cf Smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated,Ĭheck_recipient_access mysql:/etc/postfix/mysql-recipient.cf, Smtpd_sasl_security_options = noanonymous Smtpd_recipient_restrictions = permit_sasl_authenticated, permit_mynetworks, reject_unauth_destination Local_recipient_maps = $alias_maps $virtual_mailbox_maps unix:name When we get to testing, I will go into detail on what goes into those tables, for now just leave them empty.Īll mail for our virtual users will be stored in the following format: In this document I will only go over the postfix_users and postfix_virtual tables, as Martin List-Petersen does a great job at describing the rest. Type enum('recipient','sender','client') NOT NULL default 'recipient', Id int(10) unsigned NOT NULL auto_increment, Postfix enum('Y','N') NOT NULL default 'Y', Gid int(11) unsigned NOT NULL default '1004',Īccess enum('Y','N') NOT NULL default 'Y', Uid int(11) unsigned NOT NULL default '1004', Id int(11) unsigned NOT NULL auto_increment,ĭestination varchar(128) NOT NULL default '', To start off, you will use the following applications: Authentication will be done against MySQL and PAM.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |