|
From: Rudi F. <rud...@go...> - 2011-01-07 14:38:52
|
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 |
