Odhiambo WASHINGTON
2007-May-30 09:06 UTC
[Dovecot] Dovecot Authentication Problem (REVISED)
Hello List,
I am back again and I think I am edging closer to getting a solution.
I have done some modifications and now dovecot gives me a different
error message than before....
Here is what I have for the password_query and user_query
password_query = SELECT popbox.cleartext AS password FROM popbox, domain \
WHERE popbox.local_part = 'eddie' AND popbox.domain_name =
'demo.wananchi.com' \
AND popbox.domain_name = domain.domain_name;
+----------+
| password |
+----------+
| boeing8 |
+----------+
user_query = SELECT CONCAT(domain.path, '/', popbox.mbox_name) as home,
\
69 as uid, 6 as gid FROM popbox, domain WHERE popbox.local_part =
'eddie' \
AND popbox.domain_name = 'demo.wananchi.com' AND \
popbox.domain_name = domain.domain_name;
+--------------------------------------------+-----+-----+
| home | uid | gid |
+--------------------------------------------+-----+-----+
| /var/spool/virtual/demo.wananchi.com/eddie | 69 | 6 |
+--------------------------------------------+-----+-----+
When I test to connect to the pop3 daemon, this is what happens now:
root at ns2]#telnet 0 7173
Trying 0.0.0.0...
Connected to 0.
Escape character is '^]'.
+OK Welcome. Dovecot is Ready to serve your emails.
user eddie at demo.wananchi.com
+OK
pass boeing8
-ERR [IN-USE] Internal login failure. Refer to server log for more information.
Connection closed by foreign host.
...and this is what dovecot writes to the log:
[root at ns2]#less /var/log/dovecot.log
dovecot: May 30 12:00:04 Info: auth(default): client in: AUTH 1 PLAIN
service=POP3 secured lip=62.8.64.4 rip=62.8.64.4
resp=AGVkZGllQGRlbW8ud2FuYW5jaGkuY29tAGJvZWluZzgdovecot: May 30 12:00:04 Info:
auth-worker(default): mysql: Connected to localhost (virtualemail)
dovecot: May 30 12:00:04 Info: auth-worker(default): sql(eddie at
demo.wananchi.com,62.8.64.4): query: SELECT popbox.cleartext AS password FROM
popbox, domain WHERE popbox.local_part = 'eddie' AND popbox.domain_name
= 'demo.wananchi.com' AND popbox.domain_name = domain.domain_name
dovecot: May 30 12:00:04 Info: auth(default): client out: OK 1
user=eddie at demo.wananchi.com
dovecot: May 30 12:00:04 Info: auth(default): master in: REQUEST 2
36772 1
dovecot: May 30 12:00:04 Info: auth-worker(default): sql(eddie at
demo.wananchi.com,62.8.64.4): SELECT CONCAT(domain.path, '/',
popbox.mbox_name) as home, 69 as uid, 6 as gid FROM popbox, domain WHERE
popbox.local_part = 'eddie' AND popbox.domain_name =
'demo.wananchi.com' AND popbox.domain_name = domain.domain_name
dovecot: May 30 12:00:05 Error: child 39853 (auth-worker) killed with signal 11
dovecot: May 30 12:00:05 Info: auth(default): master out: FAIL 2
dovecot: May 30 12:00:05 Info: pop3-login: Internal login failure:
user=<eddie at demo.wananchi.com>, method=PLAIN, rip=62.8.64.4,
lip=62.8.64.4, secured
The output of dovecot -n:
# /usr/local/etc/dovecot.conf
base_dir: /var/run/dovecot/
log_path: /var/log/dovecot.log
protocols: pop3
listen: *:7173
ssl_disable: yes
disable_plaintext_auth: no
shutdown_clients: no
login_dir: /var/run/dovecot/login
login_executable: /usr/local/libexec/dovecot/pop3-login
login_greeting: Welcome. Dovecot is Ready to serve your emails.
login_process_size: 64
login_max_processes_count: 200
verbose_proctitle: yes
first_valid_uid: 69
first_valid_gid: 6
mail_extra_groups: exim
mail_location: maildir:/var/spool/virtual/%d/%n
mail_debug: yes
mail_executable: /usr/local/libexec/dovecot/pop3
mail_plugin_dir: /usr/local/lib/dovecot/pop3
pop3_uidl_format: %Mf
pop3_client_workarounds: outlook-no-nuls oe-ns-eoh
auth default:
mechanisms: plain login digest-md5 cram-md5
verbose: yes
debug: yes
debug_passwords: yes
passdb:
driver: sql
args: /usr/local/etc/dovecot-sql.conf
userdb:
driver: sql
args: /usr/local/etc/dovecot-sql.conf
socket:
type: listen
client:
path: /var/run/dovecot/auth-client
mode: 432
master:
path: /var/run/dovecot/auth-master
mode: 384
user: root
group: wheel
User's mail is stored in /var/spool/virtual/$domain/$user/{new,cur,tmp}
The path /var/spool/virtual/ is owned by uid:gid 69:6, and is writeable
by that uid.
I'd be happy to use a second brain and a third eye to help me figure out
the problem.
-Wash
http://www.netmeister.org/news/learn2quote.html
DISCLAIMER: See http://www.wananchi.com/bms/terms.php
--
+======================================================================+
|\ _,,,---,,_ | Odhiambo Washington <wash at wananchi.com>
Zzz /,`.-'`' -. ;-;;,_ | Wananchi Online Ltd. www.wananchi.com
|,4- ) )-,_. ,\ ( `'-'| Tel: +254 20 313985-9 +254 20 313922
'---''(_/--' `-'\_) | GSM: +254 722 743223 +254 733
744121
+======================================================================+
Democracy is a device that insures we shall be governed no better than
we deserve.
-- George Bernard Shaw
Odhiambo WASHINGTON
2007-May-31 12:55 UTC
[Dovecot] Dovecot Authentication Problem (REVISED) - update
| When I test to connect to the pop3 daemon, this is what happens now:
|
| root at ns2]#telnet 0 7173
| Trying 0.0.0.0...
| Connected to 0.
| Escape character is '^]'.
| +OK Welcome. Dovecot is Ready to serve your emails.
| user eddie at demo.wananchi.com
| +OK
| pass boeing8
| -ERR [IN-USE] Internal login failure. Refer to server log for more
information.
| Connection closed by foreign host.
|
|
| ...and this is what dovecot writes to the log:
| [root at ns2]#less /var/log/dovecot.log
| dovecot: May 30 12:00:04 Info: auth(default): client in: AUTH 1 PLAIN
service=POP3 secured lip=62.8.64.4 rip=62.8.64.4
resp=AGVkZGllQGRlbW8ud2FuYW5jaGkuY29tAGJvZWluZzg| dovecot: May 30 12:00:04 Info:
auth-worker(default): mysql: Connected to localhost (virtualemail)
| dovecot: May 30 12:00:04 Info: auth-worker(default): sql(eddie at
demo.wananchi.com,62.8.64.4): query: SELECT popbox.cleartext AS password FROM
popbox, domain WHERE popbox.local_part = 'eddie' AND popbox.domain_name
= 'demo.wananchi.com' AND popbox.domain_name = domain.domain_name
| dovecot: May 30 12:00:04 Info: auth(default): client out: OK 1
user=eddie at demo.wananchi.com
| dovecot: May 30 12:00:04 Info: auth(default): master in: REQUEST 2
36772 1
| dovecot: May 30 12:00:04 Info: auth-worker(default): sql(eddie at
demo.wananchi.com,62.8.64.4): SELECT CONCAT(domain.path, '/',
popbox.mbox_name) as home, 69 as uid, 6 as gid FROM popbox, domain WHERE
popbox.local_part = 'eddie' AND popbox.domain_name =
'demo.wananchi.com' AND popbox.domain_name = domain.domain_name
| dovecot: May 30 12:00:05 Error: child 39853 (auth-worker) killed with signal
11
| dovecot: May 30 12:00:05 Info: auth(default): master out: FAIL 2
| dovecot: May 30 12:00:05 Info: pop3-login: Internal login failure:
user=<eddie at demo.wananchi.com>, method=PLAIN, rip=62.8.64.4,
lip=62.8.64.4, secured
Here is a backtrace of the dovecot-auth crash:
[root at ns2]#gdb /usr/local/libexec/dovecot/dovecot-auth dovecot-auth.core
GNU gdb 4.18 (FreeBSD)
Copyright 1998 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for
details.
This GDB was configured as "i386-unknown-freebsd"...(no debugging
symbols found)...
Core was generated by `dovecot-auth'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /usr/lib/libcrypt.so.2...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libpam.so.1...(no debugging symbols found)...done.
Reading symbols from /usr/local/lib/compat/pkg/libmysqlclient.so.10...(no
debugging symbols found)...done.
Reading symbols from /usr/lib/libm.so.2...(no debugging symbols found)...done.
Reading symbols from /usr/local/lib/libsqlite3.so.8...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libc.so.4...(no debugging symbols found)...done.
Reading symbols from /usr/lib/libz.so.2...(no debugging symbols found)...done.
Reading symbols from /usr/libexec/ld-elf.so.1...(no debugging symbols
found)...done.
#0 0x805dc00 in userdb_blocking_lookup ()
(gdb) bt
#0 0x805dc00 in userdb_blocking_lookup ()
#1 0x805dd50 in userdb_blocking_lookup ()
#2 0x806175a in sql_drivers_register_all ()
#3 0x8060d1c in sql_query ()
#4 0x805de62 in userdb_blocking_lookup ()
#5 0x8055724 in auth_stream_is_empty ()
#6 0x80557f4 in auth_stream_is_empty ()
#7 0x8055894 in auth_stream_is_empty ()
#8 0x80668ac in io_loop_handler_run ()
#9 0x80662a1 in io_loop_run ()
#10 0x805770f in main ()
#11 0x804fd52 in _start ()
(gdb)
Is there anything else I need to provide? I really need to get this
working:-(
-Wash
http://www.netmeister.org/news/learn2quote.html
DISCLAIMER: See http://www.wananchi.com/bms/terms.php
--
+======================================================================+
|\ _,,,---,,_ | Odhiambo Washington <wash at wananchi.com>
Zzz /,`.-'`' -. ;-;;,_ | Wananchi Online Ltd. www.wananchi.com
|,4- ) )-,_. ,\ ( `'-'| Tel: +254 20 313985-9 +254 20 313922
'---''(_/--' `-'\_) | GSM: +254 722 743223 +254 733
744121
+======================================================================+
God did not create the world in seven days; he screwed around for six
days and then pulled an all-nighter.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 2243 bytes
Desc: not available
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20070531/a2b455d5/attachment-0002.bin>