[courier-users] Cannot query MySQL thru Courier
I have Postfix and Courier-Imap (pop3) running on a MacOS X box, but I cannot get it to talk to the MySQL database. I can get into MySQL from the command line as the postfix user, but when I try pop3-ing in, it refuses to access the database. From my mysql log file: I can get in from command line: 020529 9:17:59 6 Connect postfix@localhost on 020529 9:18:12 6 Init DB tcsmail 6 Query show databases 6 Query show tables 6 Field List post_users 6 Field List transport 020529 9:18:23 6 Query show tables 020529 9:18:31 6 Query select * from post_users 020529 9:18:40 6 Quit but when I try to POP in: 020529 9:20:20 8 Connect postfix@localhost on 8 Init DB Access denied for user: 'postfix@localhost' to database 'tcsmail' 8 Quit Out of frustration, I granted user postfix all privileges, but even that failed. Suggestions ? ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
[courier-users] Cannot query MySQL thru Courier - Update
I am more certain the problem is in the Courier settings, because when I sent out the last message, thru Postfix, running from Pine, I saw this scroll by in the MySQL log: 020529 9:31:56 13 Connect postfix@localhost on tcsmail 13 Query select maildir from post_users where id = '[EMAIL PROTECTED]' 13 Query select maildir from post_users where id = '@lists.sourceforge.net' 14 Connect postfix@localhost on tcsmail 14 Query select transport from transport where domain = 'lists.sourceforge.net' 14 Query select transport from transport where domain = '.sourceforge.net' 14 Query select transport from transport where domain = '.net' 15 Connect postfix@localhost on tcsmail 15 Query select maildir from post_users where id = 'lists.sourceforge.net' So that says that user postfix can access database tcsmail on localhost just fine. ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Cannot query MySQL thru Courier - Update
[EMAIL PROTECTED] wrote on 29.05.2002 09:40 -0400: I am more certain the problem is in the Courier settings Yes, remove trailing spaces (and other typos) from authmysqlrc Roland ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Cannot query MySQL thru Courier - Update
There are no trailing spaces. Here are the contents of my authmysqlrc file. I welcome any suggestions as to the problems MYSQL_SERVERlocalhost MYSQL_USERNAME postfix MYSQL_PASSWORD *** MYSQL_OPT 0 MYSQL_DATABASE tcsmail MYSQL_USER_TABLEpost_users MYSQL_CRYPT_PWFIELD password DEFAULT_DOMAIN MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD id MYSQL_HOME_FIELDhome MYSQL_NAME_FIELDname On Wed, 29 May 2002, Roland Schneider wrote: [EMAIL PROTECTED] wrote on 29.05.2002 09:40 -0400: I am more certain the problem is in the Courier settings Yes, remove trailing spaces (and other typos) from authmysqlrc Roland ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Cannot query MySQL thru Courier - Update
[EMAIL PROTECTED] wrote on 29.05.2002 10:34 -0400: There are no trailing spaces. 020529 9:20:20 8 Connect postfix@localhost on 8 Init DB Access denied for user: 'postfix@localhost' to database 'tcsmail' 8 Quit This excerpt shows some junk after the database-name, trailing spaces are the most common problem with authmysql. Roland ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Cannot query MySQL thru Courier - Update
I looked at the source that picks up the environment variables. Sort of a weird way to handle character strings. Maybe I will code a replacement and offer it as a contribution to the project. On Wed, 29 May 2002, Roland Schneider wrote: [EMAIL PROTECTED] wrote on 29.05.2002 10:34 -0400: There are no trailing spaces. 020529 9:20:20 8 Connect postfix@localhost on 8 Init DB Access denied for user: 'postfix@localhost' to database 'tcsmail' 8 Quit This excerpt shows some junk after the database-name, trailing spaces are the most common problem with authmysql. Roland ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
