Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: jeromio on December 04, 2015, 03:57:26 PM

Title: Login problems
Post by: jeromio on December 04, 2015, 03:57:26 PM
I can successfully login via the installer test (IMAP login test).

Connecting to ssl://localhost:993...
IMAP connect:  OK(SORT capability: yes)


However, I cannot login via the actual roundcube web login form. The logs for roundcube show

[04-Dec-2015 15:29:16 -0500]: <b2fcfsck> PHP Error: Access denied for new user [email protected]. 'auto_create_user' is disabled in /var/www/production/roundcube/program/include/rcmail.php on line 622 (POST /roundcube/?_task=login?_task=login&_action=login)

logs for dovecot show
Dec  4 15:55:20 localhost dovecot: auth-worker(1384): Debug: passwd([email protected],::1): lookup
Dec  4 15:55:20 localhost dovecot: auth-worker(1384): passwd([email protected],::1): unknown user
Dec  4 15:55:20 localhost dovecot: auth-worker(1384): Debug: sql([email protected],::1): SELECT '/var/vmail/motorco.co/test' as home, 'maildir:/var/vmail/motorco.co/test' as mail, 150 AS uid, 8 AS gid, concat('dirsize:storage=', quota) AS quota FROM mailbox WHERE username = '[email protected]' AND active = '1'
Dec  4 15:55:20 localhost dovecot: auth: Debug: master userdb out: USER#0113846045697#[email protected]#011home=/var/vmail/motorco.co/test#011mail=maildir:/var/vmail/motorco.co/test#011uid=150#011gid=8#011quota=dirsize:storage=0#011auth_token=b830d1d67841ac2819a6b26be4c568c16c6829b4
Dec  4 15:55:20 localhost dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=1386, TLS, session=<9lSfuRgmdQAAAAAAAAAAAAAAAAAAAAAB>
Dec  4 15:55:20 localhost dovecot: imap([email protected]): Disconnected: Logged out in=29 out=466
Dec  4 15:55:20 localhost dovecot: imap-login: Debug: SSL alert: close notify [::1]


Seems odd that I can log in via telnet (openssl) and via the test link in the installer script - but not via the actual login page?
Title: Re: Login problems
Post by: jeromio on December 04, 2015, 04:14:31 PM
For comparison, here is a successful login via the command line (telnet and openssl):

Dec  4 16:08:31 localhost dovecot: auth-worker(2045): Debug: pam([email protected],XX.XX.XX.XX): #1/1 style=1 msg=Password:
Dec  4 16:08:33 localhost dovecot: auth-worker(2045): pam([email protected],XX.XX.XX.XX): pam_authenticate() failed: Authentication failure (password mismatch?) (given password: testtest)
Dec  4 16:08:33 localhost dovecot: auth-worker(2045): Debug: sql([email protected],XX.XX.XX.XX): query: SELECT username as user, password, '/var/vmail/motorco.co/test' as userdb_home, 'maildir:/var/vmail/motorco.co/test' as userdb_mail, 150 as userdb_uid, 8 as userdb_gid FROM mailbox WHERE username = '[email protected]' AND active = '1'
Dec  4 16:08:33 localhost dovecot: auth: Debug: client passdb out: OK#0111#[email protected]
Dec  4 16:08:33 localhost dovecot: auth: Debug: master in: REQUEST#011148766721#0112040#0111#011e3a761527dde85e57b1b6e107fd7e23b#011session_pid=2047#011request_auth_token
Dec  4 16:08:33 localhost dovecot: auth-worker(2045): Debug: passwd([email protected],XX.XX.XX.XX): lookup
Dec  4 16:08:33 localhost dovecot: auth-worker(2045): passwd([email protected],XX.XX.XX.XX): unknown user
Dec  4 16:08:33 localhost dovecot: auth-worker(2045): Debug: sql([email protected],XX.XX.XX.XX): SELECT '/var/vmail/motorco.co/test' as home, 'maildir:/var/vmail/motorco.co/test' as mail, 150 AS uid, 8 AS gid, concat('dirsize:storage=', quota) AS quota FROM mailbox WHERE username = '[email protected]' AND active = '1'
Dec  4 16:08:33 localhost dovecot: auth: Debug: master userdb out: USER#011148766721#[email protected]#011home=/var/vmail/motorco.co/test#011mail=maildir:/var/vmail/motorco.co/test#011uid=150#011gid=8#011quota=dirsize:storage=0#011auth_token=60dc5c622f416d3a9d5a88ccf5fd09b41e1a1de8
Dec  4 16:08:33 localhost dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=XX.XX.XX>XX, lip=50.116.36.19, mpid=2047, TLS, session=<KoHh6BgmYwBGLF8E>

Title: Re: Login problems
Post by: jeromio on December 04, 2015, 04:48:28 PM
Erg. Nevermind. I am using postfixadmin to manage users and didn't realize that the roundcube database manages users separately from the email system.

So, I *am* logging in to email, but not to roundcube.
Title: Re: Login problems
Post by: SKaero on December 04, 2015, 05:39:21 PM
auto_create_user allows Roundcube to create the user records in the Roundcube database, it doesn't create new mail accounts.