sslug-teknik team mailing list archive
-
sslug-teknik team
-
Mailing list archive
-
Message #74609
Re: cyrus sasl/imap/mysql
On Sat, 3 Jul 2004 16:38:39 +0200
"Mogens Melander" <mogens@xxxxxxxxxxxxx> wrote:
> Aha, jeg kom et skridt videre. Nu crasher imapd ikke mere, og jeg kan
> connecte til imapd.
>
> Foerst med telnet
>
> # telnet localhost imap
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> * OK server Cyrus IMAP4 v2.2.6 server ready
> . logout
> * BYE LOGOUT received
> . OK Completed
> Connection closed by foreign host.
>
> cyrus.log
>
> Jul 3 14:57:56 server imap[27223]: accepted connection
> Jul 3 14:59:02 server master[27070]: process 27223 exited, status 0
>
> Siden med imtest
>
> # imtest -m login -a mogens
> WARNING: no hostname supplied, assuming localhost
>
> S: * OK server Cyrus IMAP4 v2.2.6 server ready
> C: C01 CAPABILITY
> S: * CAPABILITY IMAP4 IMAP4rev1 ACL QUOTA LITERAL+ MAILBOX-REFERRALS
> NAMESPACE UIDPLUS ID NO_ATOMIC_RENAME UNSELECT CHILDREN MULTIAPPEND
> BINARY SORT THREAD=ORDEREDSUBJECT THREAD=REFERENCES ANNOTATEMORE IDLE
> S: C01 OK Completed Please enter your password:
> C: L01 LOGIN mogens {7}
> S: + go ahead
> C: <omitted>
> S: L01 NO Login failed: user not found
> Authentication failed. generic failure
> Security strength factor: 0
> C: Q01 LOGOUT
> Connection closed.
>
> Cyrus debug cyrus.log
>
> Jul 3 15:00:27 server master[27278]: about to exec
> /usr/local/cyrus/bin/imapd Jul 3 15:00:27 server imap[27278]:
> executed Jul 3 15:00:27 server imap[27278]: accepted connection
> Jul 3 15:00:31 server imap[27278]: badlogin:
> localhost [127.0.0.1] plaintext mogens SASL(-13): user not found:
> checkpass failed
> Jul 3 15:01:38 server master[27070]: process 27278 exited, status 0
>
> og i auth loggen
>
> Jul 3 15:00:27 server imap[27278]: sql auxprop plugin using mysql
> engine Jul 3 15:00:31 server imap[27278]: sql plugin Parse the
> username mogens Jul 3 15:00:31 server imap[27278]: sql plugin try and
> connect to a host Jul 3 15:00:31 server imap[27278]: sql plugin
> trying to open db '' on host '' Jul 3 15:00:31 server imap[27278]:
> sql plugin could not connect to host Jul 3 15:00:31 server
> imap[27278]: sql plugin couldn't connect to any host
>
> Det ser ud til at /etc/imapd.conf ikke bliver laest rigtigt. Den
> fanger auxprop/mysql men ikke host, db, user, password
>
> Jeg kan ikke se andet end at imapd.conf er lige efter bogen, eller
> hvad?
>
> configdirectory: /var/imap/config
> partition-default: /var/imap/mail
> lmtpsocket: /var/imap/socket/lmtp
> sievedir: /var/imap/sieve
> sieveusehomedir: false
> duplicate_db: skiplist
> hashimapspool: true
> sendmail: /usr/sbin/sendmail
> admins: cyrus
> postmaster: mogens@xxxxxxxxxxxxx
> sasl_pwcheck_method: auxprop
> sasl_auxprop_plugin: sql
> sasl_sql_engine: mysql
> sasl_mech_list: PLAIN
> sasl_mysql_hostname: localhost
> sasl_mysql_user: cyrus
> sasl_mysql_passwd: xxxxxxxx
> sasl_mysql_database: cyrus
> sasl_mysql_verbose: true
> sasl_sql_select: select passwd from users where login='%u'
> sasl_sql_insert: insert into users(realm, login, passwd)
> values('%r', '%u', '%v') sasl_sql_update: update users set
> passwd='%v' where login='%u'
>
Nu sidder jeg ikke med mine normale resourcer (links) men ved brug af
auxprop/sql motor så hedder det vist ikke
sasl_mysql_... men kun sasl_sql_...
Mvh
Jesper K. Pedersen
Follow ups
References