There's nobody that can help me ? Are two weeks that I try to make to work courier/mysql ...
Thanks -----Messaggio originale----- Da: Simone Gommaraschi [mailto:[EMAIL PROTECTED]] Inviato: mercoled� 20 febbraio 2002 11.47 A: [EMAIL PROTECTED] Oggetto: Mysql auth problem - can't login Hello, I need help for that problem Scenario: ---------------------------------------------------------------------------- --------------------------------------------------------------------------- OS = RedHat 7.2 Rpm Package installed : postfix-1.1.3-1 - mta courier-imap-mysql-1.4.2.20020131-1.7.2 - create by rpm -ta from tar.gz courier-imap-1.4.2.20020131-1.7.2 - create by rpm -ta from tar.gz Process running: 21883 ? S 0:00 /usr/lib/courier-imap/libexec/authlib/authdaemond.mysql start 21887 ? S 0:00 \_ /usr/lib/courier-imap/libexec/authlib/authdaemond.mysql start 21888 ? S 0:00 \_ /usr/lib/courier-imap/libexec/authlib/authdaemond.mysql start 21893 ? S 0:00 \_ /usr/lib/courier-imap/libexec/authlib/authdaemond.mysql start 21894 ? S 0:00 \_ /usr/lib/courier-imap/libexec/authlib/authdaemond.mysql start 21895 ? S 0:00 \_ /usr/lib/courier-imap/libexec/authlib/authdaemond.mysql start 21897 ? S 0:00 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -stderrlogger=/usr/lib/ courier-imap/libexec/logger -stderrloggername=imapd -ma 21901 ? S 0:00 /usr/lib/courier-imap/libexec/logger imapd 21915 ? S 0:00 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -stderrlogger=/usr/lib/ courier-imap/libexec/logger -stderrloggername=imapd-ssl 21918 ? S 0:00 /usr/lib/courier-imap/libexec/logger imapd-ssl 21933 ? S 0:00 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -stderrlogger=/usr/lib/ courier-imap/libexec/logger -stderrloggername=pop3d -ma 21937 ? S 0:00 /usr/lib/courier-imap/libexec/logger pop3d 21951 ? S 0:00 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -stderrlogger=/usr/lib/ courier-imap/libexec/logger -stderrloggername=pop3d-ssl 21954 ? S 0:00 /usr/lib/courier-imap/libexec/logger pop3d-ssl 22788 pts/0 S 0:00 /bin/sh /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --log 22818 pts/0 S 0:00 \_ /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/va r/lib/mysql --user=mysql --pid-file=/var/run/mysqld 22820 pts/0 S 0:00 \_ /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/va r/lib/mysql --user=mysql --pid-file=/var/run/my 22821 pts/0 S 0:00 \_ /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/va r/lib/mysql --user=mysql --pid-file=/var/ru 22822 pts/0 S 0:00 \_ /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/va r/lib/mysql --user=mysql --pid-file=/var/ru Configuration file: /usr/lib/courier-imap/etc/authmysqlrc MYSQL_SERVER localhost MYSQL_USERNAME username MYSQL_PASSWORD pwd MYSQL_SOCKET /var/mysql/mysql.sock #MYSQL_PORT 3306 MYSQL_OPT 0 MYSQL_DATABASE maildb MYSQL_USER_TABLE passwd MYSQL_CRYPT_PWFIELD crypt # MYSQL_CLEAR_PWFIELD clear #DEFAULT_DOMAIN MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD id MYSQL_HOME_FIELD home MYSQL_NAME_FIELD name #MYSQL_MAILDIR_FIELD maildir #MYSQL_QUOTA_FIELD quota ...omissing... Database : # MySQL dump 8.14 # # Host: localhost Database: maildb #-------------------------------------------------------- # Server version 3.23.41-log # # Table structure for table 'passwd' # CREATE TABLE passwd ( id char(128) NOT NULL default '', crypt char(128) NOT NULL default '', clear char(128) NOT NULL default '', name char(128) NOT NULL default '', uid int(10) unsigned NOT NULL default '65534', gid int(10) unsigned NOT NULL default '65534', home char(255) NOT NULL default '', maildir char(255) NOT NULL default '', quota char(255) NOT NULL default '', KEY id (id) ) TYPE=MyISAM; # # Dumping data for table 'passwd' # INSERT INTO passwd VALUES ('1','abc','','simone',65534,65534,'','',''); Problem: 1) I can't login pop3 and imap and in mysql-query-logfile can't see query and/or connection from courier [root@cartman mysql]# telnet localhost 110 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. +OK Hello there. user 1 +OK Password required. pass abc -ERR Login failed. 2) User may insert on hand by sql insert ??? no command from courier package are available to do this ??? 3) where /usr/lib/courier-imap/libexec/logger store data logfile ??? TIA ---------------------------------------------------------------------------- --------------------------------------------------------------------------- http://www.sfondo.it - La tua biblioteca d'immagini per il desktop - wallpapers e sfondi gratis - cartoline _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
