Re: [Postfixadmin-devel] Email account created via postfixadmin not recognised by imap (dovecot)

[Rudi F. <rud...@go...>]

Check the mysql table and our documentation.
There is no column called email. It is called username.
Am 07.01.2011 15:31 schrieb "ju...@kl..." <ju...@kl...>:
> On Fri, 7 Jan 2011 14:02:12 +0100, Christian Boltz
> <pos...@cb...> wrote:
>> Am Friday 07 January 2011 schrieb J4:
>>> I had postfixadmin working, and a few days I created an account
>>> in it (1234@xxxinfo). The account could login, send email & so on.
>>> Today, I added another test account, but the account would not log
>>> in.
>>
>>> I compared the entries for each account in mysql and noticed that
>>> these differed:
>>>
>>> mysql> select * from mailbox;
>>>
>>> | 12...@xx... | $1111111111111 | S.L TEST | ...
>>> | te...@xx... | $11111111111111 | test Test | xxx.info/test/
>>> ...
>>
>>> mysql> select * from virtual_users;
>>
>>> | 1 | 1 | xxxx | 12...@xx... |
>>
>>> mysql> select * from virtual_aliases;
>>
>>> | 1 | 1 | 12...@xx... | 12...@xx... |
>>> | 2 | 1 | 12...@xx... | fre...@kl... |
>>
>> Seeing your table names, I'd say you must be zed1 from IRC ;-)
>
> Hi Christian ,
> Yep. I'm still having mix-up problems.
>
>>
>> It looks like you still suffer from the mixup of
>> a) the HOWTO you found somewhere on the web (virtual_* tables)
>> b) postfixadmin's tables (mailbox, alias etc. tables)
>>
>> I'm quite sure that your dovecot still uses the "virtual_users" table
>> -
>> change it to use the "mailbox" table and it should work.
>
> Changed the dovecot file dovecot-sql.conf to read:
> driver = mysql
> connect = host=127.0.0.1 dbname=xxxx user=xxxx password=xxxxx
> default_pass_scheme = PLAIN-MD5
> password_query = SELECT email as user, password FROM mailbox WHERE
> email='%u';
> ###password_query = SELECT email as user, password FROM virtual_users
> WHERE email='%u';
>
>
> I restarted dovecot, and now no-one could log in, so I deleted all
> accounts and domains via postfixadmin, and added one again, but the IMAP
> login still failed. Luckily there was a useful error messag:e
> Jan 7 14:20:24 logout dovecot: auth-worker(default):
> sql(te...@xx...,127.0.0.1): Password query failed: Unknown column
> 'email' in 'field list'
>
> Is the above query contained in the dovecot-sql.conf correct?
>
> I shall drop the virtual* tables.
>
> J.
>
>
>>
>> You should also remove the virtual_* tables to avoid future confusion
>> (a backup never hurts, but you probably won't need it ;-)
>> Postfixadmin does not use any virtual_* tables (except if you have
>> defined custom table names or a database prefix in the config, but
>> that's something you would know.)
>>
>> If something breaks ofter removing the virtual_* tables, you most
>> probably have to fix the configuration of the breaking service.
>>
>>> These errors keep popping up in the apache error.log, and I do not
>>> know whether these are related to the problem.
>>> [Fri Jan 07 11:36:29 2011] [error] [client 11.11.11.11] PHP Notice:
>>> Undefined index: flash in
>>>
>>> /www/postfixadmin/templates_c/0d1a714f76f647ac5097fa38ac2b35080d18dd1
>>> 2.file.header.tpl.php on line 54, referer: [...]
>>
>> Those errors are unrelated and only show that our migration to smarty
>> is
>> still not perfect ;-) But that are minor things, nothing that breaks
>> functionality.
>>
>>
>> Regards,
>>
>> Christian Boltz
>> --
>> Mmh. Nachdem alle hier anscheinend Mutt verwenden habe ich mal einen
>> Blick draufgeworfen. Dafür braucht man entweder ein Studium
>> (Schwerpunkt
>> Mutt) oder viel Zeit. Mal sehen was ich zuerst habe.
>> [Christian Wunderlich in suse-linux]
>>
>>
>>
------------------------------------------------------------------------------
>> Gaining the trust of online customers is vital for the success of any
>> company
>> that requires sensitive data to be transmitted over the Web. Learn
>> how to
>> best implement a security strategy that keeps consumers' information
>> secure
>> and instills the confidence they need to proceed with transactions.
>> http://p.sf.net/sfu/oracle-sfdevnl
>> _______________________________________________
>> Postfixadmin-devel mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>
> --
> NEOCRON: Cyberpunk FPS MMORG http://www.neocron.com
>
>
------------------------------------------------------------------------------
> Gaining the trust of online customers is vital for the success of any
company
> that requires sensitive data to be transmitted over the Web. Learn how to
> best implement a security strategy that keeps consumers' information
secure
> and instills the confidence they need to proceed with transactions.
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> Postfixadmin-devel mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel