|
From: <ju...@kl...> - 2011-01-07 14:30:51
|
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 |
