[courier-users] Courier-IMAP and MySQL problem
Hi I installed Courier-IMAP using RPMs, and together with authlib and authmysql. I can login fine using authpam, everything works fine with that. The problem is when I try to use authmysql. Here's my line in the authdaemonrc file: authmodulelist=authmysql authpam My db schema is the same as in the /etc/authlib/authmysqlrc file, and the password was generated using mysql's encrypt function. To double check, I also tried using Perl's crypt function to generate the password but this didn't work either. Here's the output from the log when I try to login with the authmysql user: Dec 27 16:25:53 vps authdaemond: stopping authdaemond children Dec 27 16:25:53 vps authdaemond: modules=authmysql authpam, daemons=5 Dec 27 16:25:53 vps authdaemond: Installing libauthmysql Dec 27 16:25:53 vps authdaemond: file not found Dec 27 16:25:53 vps authdaemond: Installing libauthpam Dec 27 16:25:53 vps authdaemond: Installation complete: authpam As you can see, it's saying that it can't find libauthmysql, but it is installed. If I try to install the rpm again, it tells me that libauthmysql is already installed. I'm using CentOS 3 on an AMD64 machine. Thanks. -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
I believe you have to somehow tell Courier where authlibmysql is installed. Usually, you do this from the command line: export LD_LIBRARY_PATH=location of authlibmysql:$LD_LIBRARY_PATH Then restart courier. Try that hopefully it works for you. On Tue, 27 Dec 2005 16:32:37 [EMAIL PROTECTED] wrote: Hi I installed Courier-IMAP using RPMs, and together with authlib and authmysql. I can login fine using authpam, everything works fine with that. The problem is when I try to use authmysql. Here's my line in the authdaemonrc file: authmodulelist=authmysql authpam My db schema is the same as in the /etc/authlib/authmysqlrc file, and the password was generated using mysql's encrypt function. To double check, I also tried using Perl's crypt function to generate the password but this didn't work either. Here's the output from the log when I try to login with the authmysql user: Dec 27 16:25:53 vps authdaemond: stopping authdaemond children Dec 27 16:25:53 vps authdaemond: modules=authmysql authpam, daemons=5 Dec 27 16:25:53 vps authdaemond: Installing libauthmysql Dec 27 16:25:53 vps authdaemond: file not found Dec 27 16:25:53 vps authdaemond: Installing libauthpam Dec 27 16:25:53 vps authdaemond: Installation complete: authpam As you can see, it's saying that it can't find libauthmysql, but it is installed. If I try to install the rpm again, it tells me that libauthmysql is already installed. I'm using CentOS 3 on an AMD64 machine. Thanks. -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Lyndon Tiu --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
Hi Thanks for your reply. Sorry if this next question is a bit stupid, but my Linux knowledge is very limited! How do I find out where the rpm for authlibmysql was installed? On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: I believe you have to somehow tell Courier where authlibmysql is installed. Usually, you do this from the command line: export LD_LIBRARY_PATH=location of authlibmysql:$LD_LIBRARY_PATH Then restart courier. Try that hopefully it works for you. On Tue, 27 Dec 2005 16:32:37 [EMAIL PROTECTED] wrote: Hi I installed Courier-IMAP using RPMs, and together with authlib and authmysql. I can login fine using authpam, everything works fine with that. The problem is when I try to use authmysql. Here's my line in the authdaemonrc file: authmodulelist=authmysql authpam My db schema is the same as in the /etc/authlib/authmysqlrc file, and the password was generated using mysql's encrypt function. To double check, I also tried using Perl's crypt function to generate the password but this didn't work either. Here's the output from the log when I try to login with the authmysql user: Dec 27 16:25:53 vps authdaemond: stopping authdaemond children Dec 27 16:25:53 vps authdaemond: modules=authmysql authpam, daemons=5 Dec 27 16:25:53 vps authdaemond: Installing libauthmysql Dec 27 16:25:53 vps authdaemond: file not found Dec 27 16:25:53 vps authdaemond: Installing libauthpam Dec 27 16:25:53 vps authdaemond: Installation complete: authpam As you can see, it's saying that it can't find libauthmysql, but it is installed. If I try to install the rpm again, it tells me that libauthmysql is already installed. I'm using CentOS 3 on an AMD64 machine. Thanks. -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
*embarassed* and here I was thinking that it would automatically pick up the installation from a registry or something, ala Windows. Here's the output: MySQL-server-standard-5.0.16-0.rhel4 MySQL-shared-standard-5.0.16-0.rhel3 courier-authlib-mysql-0.58-1 mysql-devel-3.23.58-16.RHEL3.1 MySQL-client-standard-5.0.16-0.rhel4 Thanks in advance for your help! On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: sarcarsm Aha! So if you don't know where it is, then how can Courier know where it is!?!!! /sarcasm Try this command and send me the output and then I can tell you more: rpm -qa|grep -i mysql On Tue, 27 Dec 2005 16:53:13 [EMAIL PROTECTED] wrote: Hi Thanks for your reply. Sorry if this next question is a bit stupid, but my Linux knowledge is very limited! How do I find out where the rpm for authlibmysql was installed? On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: I believe you have to somehow tell Courier where authlibmysql is installed. Usually, you do this from the command line: export LD_LIBRARY_PATH=location of authlibmysql:$LD_LIBRARY_PATH Then restart courier. Try that hopefully it works for you. On Tue, 27 Dec 2005 16:32:37 [EMAIL PROTECTED] wrote: Hi I installed Courier-IMAP using RPMs, and together with authlib and authmysql. I can login fine using authpam, everything works fine with that. The problem is when I try to use authmysql. Here's my line in the authdaemonrc file: authmodulelist=authmysql authpam My db schema is the same as in the /etc/authlib/authmysqlrc file, and the password was generated using mysql's encrypt function. To double check, I also tried using Perl's crypt function to generate the password but this didn't work either. Here's the output from the log when I try to login with the authmysql user: Dec 27 16:25:53 vps authdaemond: stopping authdaemond children Dec 27 16:25:53 vps authdaemond: modules=authmysql authpam, daemons=5 Dec 27 16:25:53 vps authdaemond: Installing libauthmysql Dec 27 16:25:53 vps authdaemond: file not found Dec 27 16:25:53 vps authdaemond: Installing libauthpam Dec 27 16:25:53 vps authdaemond: Installation complete: authpam As you can see, it's saying that it can't find libauthmysql, but it is installed. If I try to install the rpm again, it tells me that libauthmysql is already installed. I'm using CentOS 3 on an AMD64 machine. Thanks. -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
rpm -ql courier-authlib-mysql will list to you where libauthmysql is installed. Send me the output of the command above and I can tell you more. On Tue, 27 Dec 2005 16:58:50 [EMAIL PROTECTED] wrote: *embarassed* and here I was thinking that it would automatically pick up the installation from a registry or something, ala Windows. Here's the output: MySQL-server-standard-5.0.16-0.rhel4 MySQL-shared-standard-5.0.16-0.rhel3 courier-authlib-mysql-0.58-1 mysql-devel-3.23.58-16.RHEL3.1 MySQL-client-standard-5.0.16-0.rhel4 Thanks in advance for your help! On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: sarcarsm Aha! So if you don't know where it is, then how can Courier know where it is!?!!! /sarcasm Try this command and send me the output and then I can tell you more: rpm -qa|grep -i mysql On Tue, 27 Dec 2005 16:53:13 [EMAIL PROTECTED] wrote: Hi Thanks for your reply. Sorry if this next question is a bit stupid, but my Linux knowledge is very limited! How do I find out where the rpm for authlibmysql was installed? On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: I believe you have to somehow tell Courier where authlibmysql is installed. Usually, you do this from the command line: export LD_LIBRARY_PATH=location of authlibmysql:$LD_LIBRARY_PATH Then restart courier. Try that hopefully it works for you. On Tue, 27 Dec 2005 16:32:37 [EMAIL PROTECTED] wrote: Hi I installed Courier-IMAP using RPMs, and together with authlib and authmysql. I can login fine using authpam, everything works fine with that. The problem is when I try to use authmysql. Here's my line in the authdaemonrc file: authmodulelist=authmysql authpam My db schema is the same as in the /etc/authlib/authmysqlrc file, and the password was generated using mysql's encrypt function. To double check, I also tried using Perl's crypt function to generate the password but this didn't work either. Here's the output from the log when I try to login with the authmysql user: Dec 27 16:25:53 vps authdaemond: stopping authdaemond children Dec 27 16:25:53 vps authdaemond: modules=authmysql authpam, daemons=5 Dec 27 16:25:53 vps authdaemond: Installing libauthmysql Dec 27 16:25:53 vps authdaemond: file not found Dec 27 16:25:53 vps authdaemond: Installing libauthpam Dec 27 16:25:53 vps authdaemond: Installation complete: authpam As you can see, it's saying that it can't find libauthmysql, but it is installed. If I try to install the rpm again, it tells me that libauthmysql is already installed. I'm using CentOS 3 on an AMD64 machine. Thanks. -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- Lyndon Tiu --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
Hi Lyndon Weird. The output's: [root]# rpm -ql courier-authlib-mysql (contains no files) [root]# On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: rpm -ql courier-authlib-mysql will list to you where libauthmysql is installed. Send me the output of the command above and I can tell you more. On Tue, 27 Dec 2005 16:58:50 [EMAIL PROTECTED] wrote: *embarassed* and here I was thinking that it would automatically pick up the installation from a registry or something, ala Windows. Here's the output: MySQL-server-standard-5.0.16-0.rhel4 MySQL-shared-standard-5.0.16-0.rhel3 courier-authlib-mysql-0.58-1 mysql-devel-3.23.58-16.RHEL3.1 MySQL-client-standard-5.0.16-0.rhel4 Thanks in advance for your help! On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: sarcarsm Aha! So if you don't know where it is, then how can Courier know where it is!?!!! /sarcasm Try this command and send me the output and then I can tell you more: rpm -qa|grep -i mysql On Tue, 27 Dec 2005 16:53:13 [EMAIL PROTECTED] wrote: Hi Thanks for your reply. Sorry if this next question is a bit stupid, but my Linux knowledge is very limited! How do I find out where the rpm for authlibmysql was installed? On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: I believe you have to somehow tell Courier where authlibmysql is installed. Usually, you do this from the command line: export LD_LIBRARY_PATH=location of authlibmysql:$LD_LIBRARY_PATH Then restart courier. Try that hopefully it works for you. On Tue, 27 Dec 2005 16:32:37 [EMAIL PROTECTED] wrote: Hi I installed Courier-IMAP using RPMs, and together with authlib and authmysql. I can login fine using authpam, everything works fine with that. The problem is when I try to use authmysql. Here's my line in the authdaemonrc file: authmodulelist=authmysql authpam My db schema is the same as in the /etc/authlib/authmysqlrc file, and the password was generated using mysql's encrypt function. To double check, I also tried using Perl's crypt function to generate the password but this didn't work either. Here's the output from the log when I try to login with the authmysql user: Dec 27 16:25:53 vps authdaemond: stopping authdaemond children Dec 27 16:25:53 vps authdaemond: modules=authmysql authpam, daemons=5 Dec 27 16:25:53 vps authdaemond: Installing libauthmysql Dec 27 16:25:53 vps authdaemond: file not found Dec 27 16:25:53 vps authdaemond: Installing libauthpam Dec 27 16:25:53 vps authdaemond: Installation complete: authpam As you can see, it's saying that it can't find libauthmysql, but it is installed. If I try to install the rpm again, it tells me that libauthmysql is already installed. I'm using CentOS 3 on an AMD64 machine. Thanks. -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
Hmmm. That kinda explains why courier cannot find the authlibmysql! OK. Send me the output of the command: ls -la the courier-authlib-mysql* You have to run this command where you have the courier-auth-lib rpm file. On Tue, 27 Dec 2005 17:11:48 [EMAIL PROTECTED] wrote: Hi Lyndon Weird. The output's: [root]# rpm -ql courier-authlib-mysql (contains no files) [root]# On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: rpm -ql courier-authlib-mysql will list to you where libauthmysql is installed. Send me the output of the command above and I can tell you more. On Tue, 27 Dec 2005 16:58:50 [EMAIL PROTECTED] wrote: *embarassed* and here I was thinking that it would automatically pick up the installation from a registry or something, ala Windows. Here's the output: MySQL-server-standard-5.0.16-0.rhel4 MySQL-shared-standard-5.0.16-0.rhel3 courier-authlib-mysql-0.58-1 mysql-devel-3.23.58-16.RHEL3.1 MySQL-client-standard-5.0.16-0.rhel4 Thanks in advance for your help! On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: sarcarsm Aha! So if you don't know where it is, then how can Courier know where it is!?!!! /sarcasm Try this command and send me the output and then I can tell you more: rpm -qa|grep -i mysql On Tue, 27 Dec 2005 16:53:13 [EMAIL PROTECTED] wrote: Hi Thanks for your reply. Sorry if this next question is a bit stupid, but my Linux knowledge is very limited! How do I find out where the rpm for authlibmysql was installed? On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: I believe you have to somehow tell Courier where authlibmysql is installed. Usually, you do this from the command line: export LD_LIBRARY_PATH=location of authlibmysql:$LD_LIBRARY_PATH Then restart courier. Try that hopefully it works for you. On Tue, 27 Dec 2005 16:32:37 [EMAIL PROTECTED] wrote: Hi I installed Courier-IMAP using RPMs, and together with authlib and authmysql. I can login fine using authpam, everything works fine with that. The problem is when I try to use authmysql. Here's my line in the authdaemonrc file: authmodulelist=authmysql authpam My db schema is the same as in the /etc/authlib/authmysqlrc file, and the password was generated using mysql's encrypt function. To double check, I also tried using Perl's crypt function to generate the password but this didn't work either. Here's the output from the log when I try to login with the authmysql user: Dec 27 16:25:53 vps authdaemond: stopping authdaemond children Dec 27 16:25:53 vps authdaemond: modules=authmysql authpam, daemons=5 Dec 27 16:25:53 vps authdaemond: Installing libauthmysql Dec 27 16:25:53 vps authdaemond: file not found Dec 27 16:25:53 vps authdaemond: Installing libauthpam Dec 27 16:25:53 vps authdaemond: Installation complete: authpam As you can see, it's saying that it can't find libauthmysql, but it is installed. If I try to install the rpm again, it tells me that libauthmysql is already installed. I'm using CentOS 3 on an AMD64 machine. Thanks. -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- Lyndon Tiu --- This SF.net email is sponsored by: Splunk Inc. Do you grep through
Re: [courier-users] Courier-IMAP and MySQL problem
On Tue, 27 Dec 2005 09:23:15 -0800 [EMAIL PROTECTED] wrote: Hmmm. That kinda explains why courier cannot find the authlibmysql! OK. Send me the output of the command: ls -la the courier-authlib-mysql* You have to run this command where you have the courier-auth-lib rpm file. I meant: ls -la courier-authlib-mysql* -- Lyndon Tiu --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
Hi Lyndon Here's the output: [root x86_64]# ls -la courier-authlib-mysql* -rw-r--r--1 root root 1583 Dec 14 22:16 courier-authlib-mysql-0.58-1.x86_64.rpm [root x86_64]# Are we going to uninstall the rpm and reinstall it? I already tried that earlier today as well. On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: On Tue, 27 Dec 2005 09:23:15 -0800 [EMAIL PROTECTED] wrote: Hmmm. That kinda explains why courier cannot find the authlibmysql! OK. Send me the output of the command: ls -la the courier-authlib-mysql* You have to run this command where you have the courier-auth-lib rpm file. I meant: ls -la courier-authlib-mysql* -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
Try these two commands: 1) See what's inside: rpm -qpl courier-authlib-mysql-0.58-1.x86_64.rpm 2) Force install: rpm -Uvh --force --nodeps courier-authlib-mysql-0.58-1.x86_64.rpm 3) Just curious: cat /proc/cpuinfo On Tue, 27 Dec 2005 17:30:01 [EMAIL PROTECTED] wrote: Hi Lyndon Here's the output: [root x86_64]# ls -la courier-authlib-mysql* -rw-r--r--1 root root 1583 Dec 14 22:16 courier-authlib-mysql-0.58-1.x86_64.rpm [root x86_64]# Are we going to uninstall the rpm and reinstall it? I already tried that earlier today as well. On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: On Tue, 27 Dec 2005 09:23:15 -0800 [EMAIL PROTECTED] wrote: Hmmm. That kinda explains why courier cannot find the authlibmysql! OK. Send me the output of the command: ls -la the courier-authlib-mysql* You have to run this command where you have the courier-auth-lib rpm file. I meant: ls -la courier-authlib-mysql* -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- Lyndon Tiu --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
Jonathan Chong wrote: *embarassed* and here I was thinking that it would automatically pick up the installation from a registry or something, ala Windows. The configure script usually will find the libraries, as long as they are installed properly. MySQL-server-standard-5.0.16-0.rhel4 MySQL-shared-standard-5.0.16-0.rhel3 courier-authlib-mysql-0.58-1 mysql-devel-3.23.58-16.RHEL3.1 MySQL-client-standard-5.0.16-0.rhel4 That is definitely not properly. How you managed that, I can only imagine. The package mysql-devel requires mysql of the same version, which you don't have installed. You've also got mixed versions of MySQL-shared-standard and the other MySQL packages. Don't --force the installation of packages. Remove all of the MySQL packages that you've got, and install a set of *matching* packages. Then, rebuild courier-authlib and courier when your MySQL installation is fixed. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
Very weird: 1) # rpm -qpl courier-authlib-mysql-0.58-1.x86_64.rpm (contains no files) 2) Probably won't work in the event of 1) but has some output: Preparing...### [100%] 1:courier-authlib-mysql ### [100%] 3) processor : 0 vendor_id : AuthenticAMD cpu family : 15 model : 4 model name : AMD Athlon(tm) 64 Processor 3000+ stepping: 10 cpu MHz : 1999.854 cache size : 512 KB fpu : yes fpu_exception : yes cpuid level : 1 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext lm 3dnowext 3dnow bogomips: 4015.47 TLB size: 1024 4K pages clflush size: 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: ts fid vid ttp On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: Try these two commands: 1) See what's inside: rpm -qpl courier-authlib-mysql-0.58-1.x86_64.rpm 2) Force install: rpm -Uvh --force --nodeps courier-authlib-mysql-0.58-1.x86_64.rpm 3) Just curious: cat /proc/cpuinfo On Tue, 27 Dec 2005 17:30:01 [EMAIL PROTECTED] wrote: Hi Lyndon Here's the output: [root x86_64]# ls -la courier-authlib-mysql* -rw-r--r--1 root root 1583 Dec 14 22:16 courier-authlib-mysql-0.58-1.x86_64.rpm [root x86_64]# Are we going to uninstall the rpm and reinstall it? I already tried that earlier today as well. On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: On Tue, 27 Dec 2005 09:23:15 -0800 [EMAIL PROTECTED] wrote: Hmmm. That kinda explains why courier cannot find the authlibmysql! OK. Send me the output of the command: ls -la the courier-authlib-mysql* You have to run this command where you have the courier-auth-lib rpm file. I meant: ls -la courier-authlib-mysql* -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
Hi Gordon Thanks for that. I've done as you advised and now have the following mysql versions installed: MySQL-client-standard-5.0.17-0.rhel4 MySQL-shared-standard-5.0.17-0.rhel4 courier-authlib-mysql-0.58-1 MySQL-devel-standard-5.0.17-0.rhel4 MySQL-standard-debuginfo-5.0.17-0.rhel4 MySQL-server-standard-5.0.17-0.rhel4 I'll now try to rebuild the rpm from source again and see if it builds the authlib-mysql rpm properly. On 27/12/05, Gordon Messmer [EMAIL PROTECTED] wrote: Jonathan Chong wrote: *embarassed* and here I was thinking that it would automatically pick up the installation from a registry or something, ala Windows. The configure script usually will find the libraries, as long as they are installed properly. MySQL-server-standard-5.0.16-0.rhel4 MySQL-shared-standard-5.0.16-0.rhel3 courier-authlib-mysql-0.58-1 mysql-devel-3.23.58-16.RHEL3.1 MySQL-client-standard-5.0.16-0.rhel4 That is definitely not properly. How you managed that, I can only imagine. The package mysql-devel requires mysql of the same version, which you don't have installed. You've also got mixed versions of MySQL-shared-standard and the other MySQL packages. Don't --force the installation of packages. Remove all of the MySQL packages that you've got, and install a set of *matching* packages. Then, rebuild courier-authlib and courier when your MySQL installation is fixed. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
Lyndon Tiu wrote: 2) Force install: rpm -Uvh --force --nodeps courier-authlib-mysql-0.58-1.x86_64.rpm Don't --force the installation of packages. If there's a dependency issue, it needs to be resolved, or the software won't work. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
So it was the mysql version that was the problem? Using a different version fixed it? On Tue, 27 Dec 2005 19:07:13 [EMAIL PROTECTED] wrote: Hi Gordon There were no dependency issues - just a warning from mysql about an id key hash - but it installed anyway and I assumed it's safe because I downloaded from the mysql website. In fact, courier-imap is now working with mysql authentication. Thank you so much! On 27/12/05, Gordon Messmer [EMAIL PROTECTED] wrote: Lyndon Tiu wrote: 2) Force install: rpm -Uvh --force --nodeps courier-authlib-mysql-0.58-1.x86_64.rpm Don't --force the installation of packages. If there's a dependency issue, it needs to be resolved, or the software won't work. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Lyndon Tiu --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
On Tue, 27 Dec 2005 10:45:17 -0800 [EMAIL PROTECTED] wrote: Lyndon Tiu wrote: 2) Force install: rpm -Uvh --force --nodeps courier-authlib-mysql-0.58-1.x86_64.rpm Don't --force the installation of packages. If there's a dependency issue, it needs to be resolved, or the software won't work. Unless you know what you are doing. -- Lyndon Tiu --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
Hi Lyndon Yes, it seems it was. I changed it to 5.0.17 (I think there was a conflict with version 3.23 that was installed with yum) and it built the rpm accordingly. I didn't need to rebuild courier-imap, just the authlib. On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: So it was the mysql version that was the problem? Using a different version fixed it? On Tue, 27 Dec 2005 19:07:13 [EMAIL PROTECTED] wrote: Hi Gordon There were no dependency issues - just a warning from mysql about an id key hash - but it installed anyway and I assumed it's safe because I downloaded from the mysql website. In fact, courier-imap is now working with mysql authentication. Thank you so much! On 27/12/05, Gordon Messmer [EMAIL PROTECTED] wrote: Lyndon Tiu wrote: 2) Force install: rpm -Uvh --force --nodeps courier-authlib-mysql-0.58-1.x86_64.rpm Don't --force the installation of packages. If there's a dependency issue, it needs to be resolved, or the software won't work. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
Great! At least you learned a few Linux tricks : And and Gordon Messmer mentioned, be careful about the commands you run ... On Tue, 27 Dec 2005 19:59:59 [EMAIL PROTECTED] wrote: Hi Lyndon Yes, it seems it was. I changed it to 5.0.17 (I think there was a conflict with version 3.23 that was installed with yum) and it built the rpm accordingly. I didn't need to rebuild courier-imap, just the authlib. On 27/12/05, Lyndon Tiu [EMAIL PROTECTED] wrote: So it was the mysql version that was the problem? Using a different version fixed it? On Tue, 27 Dec 2005 19:07:13 [EMAIL PROTECTED] wrote: Hi Gordon There were no dependency issues - just a warning from mysql about an id key hash - but it installed anyway and I assumed it's safe because I downloaded from the mysql website. In fact, courier-imap is now working with mysql authentication. Thank you so much! On 27/12/05, Gordon Messmer [EMAIL PROTECTED] wrote: Lyndon Tiu wrote: 2) Force install: rpm -Uvh --force --nodeps courier-authlib-mysql-0.58-1.x86_64.rpm Don't --force the installation of packages. If there's a dependency issue, it needs to be resolved, or the software won't work. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Lyndon Tiu -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- Lyndon Tiu --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] Courier-IMAP and MySQL problem
Lyndon Tiu writes: On Tue, 27 Dec 2005 10:45:17 -0800 [EMAIL PROTECTED] wrote: Lyndon Tiu wrote: 2) Force install: rpm -Uvh --force --nodeps courier-authlib-mysql-0.58-1.x86_64.rpm Don't --force the installation of packages. If there's a dependency issue, it needs to be resolved, or the software won't work. Unless you know what you are doing. And those who know what they're doing almost never use the --force option, instead choosing to fix the underlying dependency conflict. --force is to be used only as a result of a packaging error that you are aware of, and understand. If you do not understand the actual, underlying reason behind the dependency conflict that prevents a package from installing normally, using --force has little chance of succeeding; at best you'll be fooled into thinking that everything worked, because the software superficially appears to be working. Yet, it's only a matter of time before something bites you in the ass. pgpcv6WAZkScd.pgp Description: PGP signature
Re: [courier-users] Courier-IMAP and MySQL problem
On Tue, 27 Dec 2005 18:27:43 -0500 [EMAIL PROTECTED] wrote: If you do not understand the actual, underlying reason behind the dependency conflict that prevents a package from installing normally, using --force has little chance of succeeding; at best you'll be fooled into thinking that everything worked, because the software superficially appears to be working. Yet, it's only a matter of time before something bites you in the ass. As I said, only use it if you know what you are doing. -- Lyndon Tiu --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
[courier-users] Courier IMAP and MySQL and Quota
Hi list, I'm sure the answer to my question is somewhere on the net, but after reading about google pages, I still can't find the answer, which I think should be simple ;) I have a running system with Postfix - Courier-IMAP - MySQL for a virtual domain system, which works fine for some time now. But within a short period of time we want to use QUOTA's on the Maildirs We have enabled the Maildir++ option in Postfix, which adds the mailsize to the filenames. I also added a 'quota' column to the table from where Courier-IMAP looks up the user info and verified the QUOTA capability in the imapd config file... so far so good... But I really can't find what kind of information should be in the 'quota' column to make Courier report the quota to the client (squirrelmail in this testcase). I can remember something like: 100S, 1000C (But does Courier support ' number of messages' limiting?) but I really can't figure it out anymore... I'm almost sure that the size of the quota should be in bytes. And additional to this; I patched the Postfix Virtual Delivery Agent for supporting quota's, but this patch doesn't seem to give the option to send the mailbox a warning mail when reached at xx% of the quota... Any sugguestions on this one? Thanks in advance for sharing the requested info !!! - Casper "In the middle of difficulty lies opportunity." - Albert Einstein Cee-Kay bv Laurenspark 140 4835 GZ Breda The Netherlands http://www.Cee-Kay.net
Re: [courier-users] Courier IMAP and MySQL and Quota
Casper wrote: Hi list, I'm sure the answer to my question is somewhere on the net, but after reading about google pages, I still can't find the answer, which I think should be simple ;) I have a running system with Postfix - Courier-IMAP - MySQL for a virtual domain system, which works fine for some time now. But within a short period of time we want to use QUOTA's on the Maildirs We have enabled the Maildir++ option in Postfix, which adds the mailsize to the filenames. I don't remember that I enabled it or no on my mine I also added a 'quota' column to the table from where Courier-IMAP looks up the user info and verified the QUOTA capability in the imapd config file... so far so good... But I really can't find what kind of information should be in the 'quota' column to make Courier report the quota to the client (squirrelmail in this testcase). My mysqldump displays like this. It works fully but I don't know if this is the right: quota varchar(255) NOT NULL default '1', With this configuration: 2000 ~ 2Mo of quota I can remember something like: 100S, 1000C (But does Courier support ' number of messages' limiting?) but I really can't figure it out anymore... I'm almost sure that the size of the quota should be in bytes. And additional to this; I patched the Postfix Virtual Delivery Agent for supporting quota's, but this patch doesn't seem to give the option to send the mailbox a warning mail when reached at xx% of the quota... Any sugguestions on this one? Your postconf | grep virtual must give you virtual_mailbox_limit_maps= Thanks in advance for sharing the requested info !!! - Casper In the middle of difficulty lies opportunity. - Albert Einstein Cee-Kay bv Laurenspark 140 4835 GZ Breda The Netherlands http://www.Cee-Kay.net http://www.cee-kay.net/ :-) Manou --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
RE: [courier-users] courier imap and mysql
Jared Rhine at Sun, 07 Jul 2002 13:26:22 -0700 wrote: [Andrew == [EMAIL PROTECTED] on Thu, 04 Jul 2002 17:53:23 +0930 (CST)] Andrew No connections at all from courier... G'Day, Check that the mysql socket location (MYSQL_SOCKET in authmysqlrc) is set to the correct location. Someone on this list just recently had a no connections to mysql at all problem caused by not setting this parameter to the correct value for their configuration. netstat -l unix LISTENING /usr/lib/courier-imap/var/authdaemon/socket.tmp unix LISTENING /var/lib/mysql/mysql.sock in my authmysqlrc file MYSQL_SOCKET /var/lib/mysql/mysql.sock also if I specify host and port to connect, it don't use that either. So as you can see it points to where its 'sposed to. my biggest prob is the boss likes suse and won't change to another distro. Just wondering if anyone has success with installing courier imap (with mysql)onto a suse 7.1, using either a tar or using an rpm (as suse don't have a courier rpm in 7.1), let me know. This is so bizare I got no idea what to do. my boss doesn't want to move to another distro so I am sort of stuck between a rock and a hard place. Thanx for your help :) -- [EMAIL PROTECTED] One cannot mark the point without marking the path. cya Andrew --- This sf.net email is sponsored by:ThinkGeek Oh, it's good to be a geek. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
RE: [courier-users] courier imap and mysql
Hello, I did fix this problem... In my case, i re-edit the authmysqlrc file, and have removed the spaces and tabs... After, I have found in the internet, the great solution: The order of the fields in authmysqlrc is wrong. I use the select clause, and i guess that you should use too... # username, cryptpw, uid, gid, clearpw, home, maildir, quota, fullname The order above is wrong. The clearpw is after cryptpw... And for test purpose, you should give full permissions for the test user, in mysql db. You should use the strace software to debug the authentication daemon, and enable the log for all, in mysql. -- FreeShell's master http://omestre.freeshel.org On Mon, 2002-07-08 at 04:18, Andrew D wrote: Jared Rhine at Sun, 07 Jul 2002 13:26:22 -0700 wrote: [Andrew == [EMAIL PROTECTED] on Thu, 04 Jul 2002 17:53:23 +0930 (CST)] Andrew No connections at all from courier... G'Day, Check that the mysql socket location (MYSQL_SOCKET in authmysqlrc) is set to the correct location. Someone on this list just recently had a no connections to mysql at all problem caused by not setting this parameter to the correct value for their configuration. netstat -l unix LISTENING /usr/lib/courier-imap/var/authdaemon/socket.tmp unix LISTENING /var/lib/mysql/mysql.sock in my authmysqlrc file MYSQL_SOCKET /var/lib/mysql/mysql.sock also if I specify host and port to connect, it don't use that either. So as you can see it points to where its 'sposed to. my biggest prob is the boss likes suse and won't change to another distro. Just wondering if anyone has success with installing courier imap (with mysql)onto a suse 7.1, using either a tar or using an rpm (as suse don't have a courier rpm in 7.1), let me know. This is so bizare I got no idea what to do. my boss doesn't want to move to another distro so I am sort of stuck between a rock and a hard place. Thanx for your help :) -- [EMAIL PROTECTED] One cannot mark the point without marking the path. cya Andrew --- This sf.net email is sponsored by:ThinkGeek Oh, it's good to be a geek. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users --- This sf.net email is sponsored by:ThinkGeek Oh, it's good to be a geek. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
RE: [courier-users] courier imap and mysql
OMestre at 08 Jul 2002 10:09:53 -0300 wrote: Hello, G'Day, I did fix this problem... In my case, i re-edit the authmysqlrc file, and have removed the spaces and tabs... yep, did that some time ago, after advice from tony2001 ;) a copy of my config files is at http://www.awdcomp.com/tempfile It doesn't matter if I hash or unhash the server/port line. After, I have found in the internet, the great solution: The order of the fields in authmysqlrc is wrong. I use the select clause, and i guess that you should use too... Whats the point of this if it ain't connecting??? And for test purpose, you should give full permissions for the test user, in mysql db. You should use the strace software to debug the The same strace that I posted a few days is still at http://www.awdcomp.com/tempfile2 contains a strace of authdeamon and a link to strace of authdaemond authentication daemon, and enable the log for all, in mysql. yup did that too, thats how I know it ain't connecting ;) I have compiled exim on this box and uses mysql with no probs on the same table for smtp auth and delivery as what courier imap will be. The pop3 daemon also uses that same table with no probs. only diff that I can see is that exim and the pop3 daemon uses a port to connect to mysql and as far as I know courier wants to use the unix socket. If I try to use a port for courier it still don't work. I hope ur not as confused as I am. cya Andrew --- This sf.net email is sponsored by:ThinkGeek Oh, it's good to be a geek. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
RE: [courier-users] courier imap and mysql
G'Day, Continuing saga . have comiled yet again, with no error that makes the 'make' fail or 'make check' fail. However this time I took a look through the 'make' results and came across this make[1]: Entering directory `/usr/src/courier-imap-1.5.1/authlib' gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/include/mysql -g -O2 -Wall -I.. -I./.. -c authexit.c --snip-- gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/include/mysql -g -O2 -Wall -I.. -I./.. -c preauthmysql.c echo #define AUTHMYSQLRC /usr/lib/courier-imap/etc/authmysqlrc authmysqlrc.h gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/include/mysql -g -O2 -Wall -I.. -I./.. -c authmysqllib.c authmysqllib.c: In function `get_variable': authmysqllib.c:271: warning: field width is not type int (arg 3) gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/include/mysql -g -O2 -Wall -I.. -I./.. -c authsasl.c gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/include/mysql -g -O2 -Wall -I.. -I./.. -c authsaslcram.c --snip-- Could this possibly be the cause for no connection to mysql by couriers authdaemon? Thats the only error I see. Thanks again for your time and bearing with me :) Andrew --- This sf.net email is sponsored by:ThinkGeek Oh, it's good to be a geek. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
[courier-users] courier imap and mysql
[Andrew == [EMAIL PROTECTED] on Thu, 04 Jul 2002 17:53:23 +0930 (CST)] Andrew No connections at all from courier... Check that the mysql socket location (MYSQL_SOCKET in authmysqlrc) is set to the correct location. Someone on this list just recently had a no connections to mysql at all problem caused by not setting this parameter to the correct value for their configuration. -- [EMAIL PROTECTED] One cannot mark the point without marking the path. --- This sf.net email is sponsored by:ThinkGeek We have stuff for geeks like you. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] courier imap and mysql
On Thu, 04 Jul 2002 2:44:15 +0930 (CST) Andrew D [EMAIL PROTECTED] wrote: Ok I replaced tabs/spaces with a tab, no luck, replaced the tab with a single space and still no luck, I have even made sure there was no space/tabs after each value. Have you tried to run mysql with --log option to have a full log ? Try it and you'll see what courier talks to mysql. With best regards, Antony Dovgal aka tony2001 Linux user #276688 -- http://tony2001.narod.ru --- This sf.net email is sponsored by:ThinkGeek Caffeinated soap. No kidding. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
RE: [courier-users] courier imap and mysql
Antony Dovgal at Thu, 4 Jul 2002 10:57:18 +0300 wrote: On Thu, 04 Jul 2002 2:44:15 +0930 (CST) Andrew D [EMAIL PROTECTED] wrote: G'Day, Ok I replaced tabs/spaces with a tab, no luck, replaced the tab with a single space and still no luck, I have even made sure there was no space/tabs after each value. Have you tried to run mysql with --log option to have a full log ? Try it and you'll see what courier talks to mysql. Yeah that was the first thing I did, after I make installed and imap didn't work. No connections at all from courier, plenty from exim, me pop3 daemon and apache. I am thinking of building a gentoo box to see if its something to do with suse 7.1 I've had a few probs with suse and compiling stuff b4. Thanks for your help and thoughts :) With best regards, Antony Dovgal aka tony2001 Linux user #276688 -- http://tony2001.narod.ru Andrew --- This sf.net email is sponsored by:ThinkGeek Caffeinated soap. No kidding. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
RE: [courier-users] courier imap and mysql
Still got this prob with imap and mysql got everything defined and in the right place have just compiled exim 3.36 with mysql and it works perfectly a copy of my config files is at http://www.awdcomp.com/tempfile a copy of the results from strace of authdaemon http://www.awdcomp.com/tempfile2 Any help appreciated :) cya Andrew --- This sf.net email is sponsored by:ThinkGeek Caffeinated soap. No kidding. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
[courier-users] courier imap and mysql
Hi there, I have downloaded the source for courier-imap (1.4.5) and have compiled it without probs I have setup authdaemon and setup the authmysql file so that it connects to the db and retreives all data (file at bottom) However it doesn't even _connect_ to mysql to auth and retrieve the uid, maildir etc. mysql is running and returns valid results when I do queries myself (as the user specified by the authmysql file) all anything does is come back with AUTHFAILURE the log files show stuff all Jul 4 00:41:54 obelix authdaemond.mysql: authdaemon: modules=authmysql, daemons=2 is all it says There is no connection to mysql according to the mysql logs --snip-- # The server name, userid, and password used to log in. MYSQL_SERVERlocalhost MYSQL_USERNAME XX MYSQL_PASSWORD XX ##NAME: MYSQL_SOCKET:0 # # MYSQL_SOCKET can be used with MySQL version 3.22 or later, it specifies the # filesystem pipe used for the connection # MYSQL_SOCKET /var/lib/mysql/mysql.sock ##NAME: MYSQL_PORT:0 # # MYSQL_PORT can be used with MySQL version 3.22 or later to specify a port to # connect to. MYSQL_PORT 3306 --snip-- it doesn't seem to matter whether I change the server to local host or put ips or hostnames or what have u. all the other config files point to authdaemon and authmysql only oh btw this is a suse 7.1 box with mysql 3.23.33 In the archives someone mentioned this, but there was no fix (well that someone sent to the list) any help appreciated. TIA Andrew --- This sf.net email is sponsored by:ThinkGeek No, I will not fix your computer. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Re: [courier-users] courier imap and mysql
On Thu, 04 Jul 2002 1:19:57 +0930 (CST) Andrew D [EMAIL PROTECTED] wrote: the log files show stuff all Jul 4 00:41:54 obelix authdaemond.mysql: authdaemon: modules=authmysql, daemons=2 There is no connection to mysql according to the mysql logs I have had the same problem some days ago. The solution was: you need to divide varname (MYSQL_HOST) and value (host) with ONE whitespace. Hope it helps. With best regards, Antony Dovgal aka tony2001 Linux user #276688 -- http://tony2001.narod.ru --- This sf.net email is sponsored by:ThinkGeek No, I will not fix your computer. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
RE: [courier-users] courier imap and mysql
Antony Dovgal at Wed, 3 Jul 2002 19:30:09 +0300 wrote: On Thu, 04 Jul 2002 1:19:57 +0930 (CST) Andrew D [EMAIL PROTECTED] wrote: -snip- There is no connection to mysql according to the mysql logs I have had the same problem some days ago. The solution was: you need to divide varname (MYSQL_HOST) and value (host) with ONE whitespace. Ok I replaced tabs/spaces with a tab, no luck, replaced the tab with a single space and still no luck, I have even made sure there was no space/tabs after each value. Hope it helps. Nope sorry. :( With best regards, Antony Dovgal aka tony2001 Linux user #276688 --- This sf.net email is sponsored by:ThinkGeek No, I will not fix your computer. http://thinkgeek.com/sf ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
[courier-users] Courier-IMAP and MySQL SMTP Authentication
I am using Courier-IMAP POP3 daemon on a MacOS X box with a MySQL authentication setup so that mailbox users do not have a system login. I am using POP-Before-SMTP, but I want to do Authenticated SMTP, but that seems either to require PAM (which is coming in MacOS 10.2/Jaguar) or the whole courier bundle (which does not compile on MacOS X - separate issue which I will be pounding upon in the near future) Any suggestions ? --- Sponsored by: ThinkGeek at http://www.ThinkGeek.com/ ___ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
[courier-users] Courier-imap with mysql, not even trying to connect to mysql
I just installed a fresh new RH 7.3 environment and use courier-imap. I did the rpm stuff from the gz and got installed the courier-imap and courier-imap-mysql I kept two authentication modules : authpam and authmysql Jun 2 08:23:55 kaa authdaemond.mysql: authdaemon: modules=authpam authmysql, daemons=5 Pam athentication is working fine, however the mysql part is not !? This is what my authmysqlrc looks like: MYSQL_SERVERmysql.domain.com MYSQL_USERNAME user MYSQL_PASSWORD pass MYSQL_SOCKET/var/lib/mysql/mysql.sock MYSQL_PORT 3306 MYSQL_OPT 0 MYSQL_DATABASE users MYSQL_USER_TABLEaccounts MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD login MYSQL_HOME_FIELDhome MYSQL_NAME_FIELDname (a manual mysql -h mysql.domain.com -u user -ppass is working) I don't see any connection attempt to mysql, even when redirecting to another mysql server and tcpdump. It just looks like it is not doing anything with mysql. Guy, ___ 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] Courier-imap with mysql, not even trying to connect to mysql
Is your MySQL db on same host with Courier? In any case try to remove socket and leave only port. And if it's on same host then change MYSQL_SERVER to localhost. -- Original Message Starts Here - Guy I just installed a fresh new RH 7.3 environment and use courier-imap. I did the rpm stuff from the gz and got installed the courier-imap and courier-imap-mysql I kept two authentication modules : authpam and authmysql Jun 2 08:23:55 kaa authdaemond.mysql: authdaemon: modules=authpam authmysql, daemons=5 Pam athentication is working fine, however the mysql part is not !? This is what my authmysqlrc looks like: MYSQL_SERVERmysql.domain.com MYSQL_USERNAME user MYSQL_PASSWORD pass MYSQL_SOCKET/var/lib/mysql/mysql.sock MYSQL_PORT 3306 MYSQL_OPT 0 MYSQL_DATABASE users MYSQL_USER_TABLEaccounts MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD login MYSQL_HOME_FIELDhome MYSQL_NAME_FIELDname (a manual mysql -h mysql.domain.com -u user -ppass is working) I don't see any connection attempt to mysql, even when redirecting to another mysql server and tcpdump. It just looks like it is not doing anything with mysql. Guy, ___ 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] Courier-imap with mysql, not even trying to connect to mysql
Yes, it is local. I did the changes: port only, localhost as server. Same result, no trace of any connection to the mysql server. Guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Moshe Gurvich Sent: Sunday, June 02, 2002 8:47 AM To: [EMAIL PROTECTED] Subject: Re: [courier-users] Courier-imap with mysql, not even trying to connect to mysql Is your MySQL db on same host with Courier? In any case try to remove socket and leave only port. And if it's on same host then change MYSQL_SERVER to localhost. -- Original Message Starts Here - Guy I just installed a fresh new RH 7.3 environment and use courier-imap. I did the rpm stuff from the gz and got installed the courier-imap and courier-imap-mysql I kept two authentication modules : authpam and authmysql Jun 2 08:23:55 kaa authdaemond.mysql: authdaemon: modules=authpam authmysql, daemons=5 Pam athentication is working fine, however the mysql part is not !? This is what my authmysqlrc looks like: MYSQL_SERVERmysql.domain.com MYSQL_USERNAME user MYSQL_PASSWORD pass MYSQL_SOCKET/var/lib/mysql/mysql.sock MYSQL_PORT 3306 MYSQL_OPT 0 MYSQL_DATABASE users MYSQL_USER_TABLEaccounts MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD login MYSQL_HOME_FIELDhome MYSQL_NAME_FIELDname (a manual mysql -h mysql.domain.com -u user -ppass is working) I don't see any connection attempt to mysql, even when redirecting to another mysql server and tcpdump. It just looks like it is not doing anything with mysql. Guy, ___ 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 ___ 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] Courier-imap with mysql, not even trying to connect to mysql
You restarted the courier, right? -- Original Message Starts Here - Guy Yes, it is local. I did the changes: port only, localhost as server. Same result, no trace of any connection to the mysql server. Guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Moshe Gurvich Sent: Sunday, June 02, 2002 8:47 AM To: [EMAIL PROTECTED] Subject: Re: [courier-users] Courier-imap with mysql, not even trying to connect to mysql Is your MySQL db on same host with Courier? In any case try to remove socket and leave only port. And if it's on same host then change MYSQL_SERVER to localhost. -- Original Message Starts Here - Guy I just installed a fresh new RH 7.3 environment and use courier-imap. I did the rpm stuff from the gz and got installed the courier-imap and courier-imap-mysql I kept two authentication modules : authpam and authmysql Jun 2 08:23:55 kaa authdaemond.mysql: authdaemon: modules=authpam authmysql, daemons=5 Pam athentication is working fine, however the mysql part is not !? This is what my authmysqlrc looks like: MYSQL_SERVERmysql.domain.com MYSQL_USERNAME user MYSQL_PASSWORD pass MYSQL_SOCKET/var/lib/mysql/mysql.sock MYSQL_PORT 3306 MYSQL_OPT 0 MYSQL_DATABASE users MYSQL_USER_TABLEaccounts MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD login MYSQL_HOME_FIELDhome MYSQL_NAME_FIELDname (a manual mysql -h mysql.domain.com -u user -ppass is working) I don't see any connection attempt to mysql, even when redirecting to another mysql server and tcpdump. It just looks like it is not doing anything with mysql. Guy, ___ 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 ___ 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] Courier-imap with mysql,not even trying to connect to mysql
Did you fire up your mysql with logging turned on ? It could help. At 9:57 AM +0200 6/2/02, Guy wrote: Yes, it is local. I did the changes: port only, localhost as server. Same result, no trace of any connection to the mysql server. Guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Moshe Gurvich Sent: Sunday, June 02, 2002 8:47 AM To: [EMAIL PROTECTED] Subject: Re: [courier-users] Courier-imap with mysql, not even trying to connect to mysql Is your MySQL db on same host with Courier? In any case try to remove socket and leave only port. And if it's on same host then change MYSQL_SERVER to localhost. -- Original Message Starts Here - Guy I just installed a fresh new RH 7.3 environment and use courier-imap. I did the rpm stuff from the gz and got installed the courier-imap and courier-imap-mysql I kept two authentication modules : authpam and authmysql Jun 2 08:23:55 kaa authdaemond.mysql: authdaemon: modules=authpam authmysql, daemons=5 Pam athentication is working fine, however the mysql part is not !? This is what my authmysqlrc looks like: MYSQL_SERVERmysql.domain.com MYSQL_USERNAME user MYSQL_PASSWORD pass MYSQL_SOCKET/var/lib/mysql/mysql.sock MYSQL_PORT 3306 MYSQL_OPT 0 MYSQL_DATABASE users MYSQL_USER_TABLEaccounts MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD login MYSQL_HOME_FIELDhome MYSQL_NAME_FIELDname (a manual mysql -h mysql.domain.com -u user -ppass is working) I don't see any connection attempt to mysql, even when redirecting to another mysql server and tcpdump. It just looks like it is not doing anything with mysql. Guy, ___ 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 ___ 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 -- Dan White Sometimes I think the surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us. Calvin (Bill Watterson) ___ 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] Courier-imap with mysql, not even trying to connect to mysql
Yes, That from where I see absolutely no connection Guy -Original Message- From: Daniel E. White [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 02, 2002 10:17 AM To: Guy Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [courier-users] Courier-imap with mysql, not even trying to connect to mysql Did you fire up your mysql with logging turned on ? It could help. At 9:57 AM +0200 6/2/02, Guy wrote: Yes, it is local. I did the changes: port only, localhost as server. Same result, no trace of any connection to the mysql server. Guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Moshe Gurvich Sent: Sunday, June 02, 2002 8:47 AM To: [EMAIL PROTECTED] Subject: Re: [courier-users] Courier-imap with mysql, not even trying to connect to mysql Is your MySQL db on same host with Courier? In any case try to remove socket and leave only port. And if it's on same host then change MYSQL_SERVER to localhost. -- Original Message Starts Here - Guy I just installed a fresh new RH 7.3 environment and use courier-imap. I did the rpm stuff from the gz and got installed the courier-imap and courier-imap-mysql I kept two authentication modules : authpam and authmysql Jun 2 08:23:55 kaa authdaemond.mysql: authdaemon: modules=authpam authmysql, daemons=5 Pam athentication is working fine, however the mysql part is not !? This is what my authmysqlrc looks like: MYSQL_SERVERmysql.domain.com MYSQL_USERNAME user MYSQL_PASSWORD pass MYSQL_SOCKET/var/lib/mysql/mysql.sock MYSQL_PORT 3306 MYSQL_OPT 0 MYSQL_DATABASE users MYSQL_USER_TABLEaccounts MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD login MYSQL_HOME_FIELDhome MYSQL_NAME_FIELDname (a manual mysql -h mysql.domain.com -u user -ppass is working) I don't see any connection attempt to mysql, even when redirecting to another mysql server and tcpdump. It just looks like it is not doing anything with mysql. Guy, ___ 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 ___ 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 -- Dan White Sometimes I think the surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us. Calvin (Bill Watterson) ___ 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] Courier-imap with mysql, not even trying to connect to mysql
Right :( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Moshe Gurvich Sent: Sunday, June 02, 2002 9:56 AM To: [EMAIL PROTECTED] Subject: RE: [courier-users] Courier-imap with mysql, not even trying to connect to mysql You restarted the courier, right? -- Original Message Starts Here - Guy Yes, it is local. I did the changes: port only, localhost as server. Same result, no trace of any connection to the mysql server. Guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Moshe Gurvich Sent: Sunday, June 02, 2002 8:47 AM To: [EMAIL PROTECTED] Subject: Re: [courier-users] Courier-imap with mysql, not even trying to connect to mysql Is your MySQL db on same host with Courier? In any case try to remove socket and leave only port. And if it's on same host then change MYSQL_SERVER to localhost. -- Original Message Starts Here - Guy I just installed a fresh new RH 7.3 environment and use courier-imap. I did the rpm stuff from the gz and got installed the courier-imap and courier-imap-mysql I kept two authentication modules : authpam and authmysql Jun 2 08:23:55 kaa authdaemond.mysql: authdaemon: modules=authpam authmysql, daemons=5 Pam athentication is working fine, however the mysql part is not !? This is what my authmysqlrc looks like: MYSQL_SERVERmysql.domain.com MYSQL_USERNAME user MYSQL_PASSWORD pass MYSQL_SOCKET/var/lib/mysql/mysql.sock MYSQL_PORT 3306 MYSQL_OPT 0 MYSQL_DATABASE users MYSQL_USER_TABLEaccounts MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD login MYSQL_HOME_FIELDhome MYSQL_NAME_FIELDname (a manual mysql -h mysql.domain.com -u user -ppass is working) I don't see any connection attempt to mysql, even when redirecting to another mysql server and tcpdump. It just looks like it is not doing anything with mysql. Guy, ___ 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 ___ 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 ___ 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] Courier-imap with mysql, not even trying to connect to mysql
I found it: The authmysql was not into the courier-imap despite all the fies where there, that why it was not called at all. It seems that courier imap is not complainint when an unknown module namme is put into authdaemonrc ??? I re-did the two rpm, cleaned everything and re-installed the rpm. Working now !!! Thanks for the help Guy -Original Message- From: Daniel E. White [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 02, 2002 10:17 AM To: Guy Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [courier-users] Courier-imap with mysql, not even trying to connect to mysql Did you fire up your mysql with logging turned on ? It could help. At 9:57 AM +0200 6/2/02, Guy wrote: Yes, it is local. I did the changes: port only, localhost as server. Same result, no trace of any connection to the mysql server. Guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Moshe Gurvich Sent: Sunday, June 02, 2002 8:47 AM To: [EMAIL PROTECTED] Subject: Re: [courier-users] Courier-imap with mysql, not even trying to connect to mysql Is your MySQL db on same host with Courier? In any case try to remove socket and leave only port. And if it's on same host then change MYSQL_SERVER to localhost. -- Original Message Starts Here - Guy I just installed a fresh new RH 7.3 environment and use courier-imap. I did the rpm stuff from the gz and got installed the courier-imap and courier-imap-mysql I kept two authentication modules : authpam and authmysql Jun 2 08:23:55 kaa authdaemond.mysql: authdaemon: modules=authpam authmysql, daemons=5 Pam athentication is working fine, however the mysql part is not !? This is what my authmysqlrc looks like: MYSQL_SERVERmysql.domain.com MYSQL_USERNAME user MYSQL_PASSWORD pass MYSQL_SOCKET/var/lib/mysql/mysql.sock MYSQL_PORT 3306 MYSQL_OPT 0 MYSQL_DATABASE users MYSQL_USER_TABLEaccounts MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD login MYSQL_HOME_FIELDhome MYSQL_NAME_FIELDname (a manual mysql -h mysql.domain.com -u user -ppass is working) I don't see any connection attempt to mysql, even when redirecting to another mysql server and tcpdump. It just looks like it is not doing anything with mysql. Guy, ___ 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 ___ 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 -- Dan White Sometimes I think the surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us. Calvin (Bill Watterson) ___ 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