|
From: J4 <ju...@kl...> - 2011-01-07 11:31:30
|
Dear all,
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.
The IMP server is dovecot.
Error message:
a login te...@xx... fred
a NO [AUTHENTICATIONFAILED] Authentication failed.
* BYE Disconnected for inactivity.
closed
I compared the entries for each account in mysql and noticed that these
differed:
mysql> select * from mailbox;
| 12...@xx... | $1111111111111 | S.L TEST | xxx.info/1234/
| 10240000 | 1234 | xxx.info | 2011-01-04 15:41:24 | 2011-01-04
15:41:24 | 1 |
| te...@xx... | $11111111111111 | test Test | xxx.info/test/ |
5120000 | test | xxx.info | 2011-01-07 11:35:01 | 2011-01-07 11:36:29
| 1 |
The virtual_userstable only has this entry:
mysql> select * from virtual_users;
+----+-----------+----------------------------------+------------------------+
| id | domain_id | password |
email |
+----+-----------+----------------------------------+------------------------+
| 1 | 1 | xxxx | 12...@xx... |
+----+-----------+----------------------------------+------------------------+
1 row in set (0.00 sec)
mysql> select * from virtual_aliases;
+----+-----------+------------------------+------------------------+
| id | domain_id | source | destination |
+----+-----------+------------------------+------------------------+
| 1 | 1 | 12...@xx... | 12...@xx... |
| 2 | 1 | 12...@xx... | fre...@kl... |
+----+-----------+------------------------+------------------------+
Again, I don't know what has happened to cause this problem. The only
thing that was changed was the location of the postfixadmin directory on
apache. It was moved to a vhost.
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/0d1a714f76f647ac5097fa38ac2b35080d18dd12.file.header.tpl.php
on line 54, referer:
http://admin.xxx.info/edit-mailbox.php?username=test%40xxxx.info&domain=xxxx.info
[Fri Jan 07 11:36:29 2011] [error] [client 11.11.11.11] PHP Notice:
Undefined variable: motd_file in
/www/postfixadmin/smarty/libs/sysplugins/smarty_internal_data.php on
line 287, referer:
http://admin.xxxx.info/edit-mailbox.php?username=test%40xxxx.info&domain=xxxx.info
[Fri Jan 07 11:36:29 2011] [error] [client 11.11.11.11] PHP Notice:
Undefined variable: PALANG_pFooter_logged_as in
/www/postfixadmin/smarty/libs/sysplugins/smarty_internal_data.php on
line 287, referer:
http://admin.xxxx.info/edit-mailbox.php?username=test%40xxxx.info&domain=xxxx.info
Does anyone know what went amiss?
Best wishes, J
|
|
From: Christian B. <pos...@cb...> - 2011-01-07 13:02:33
|
Hello, 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 ;-) 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. 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] |
|
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 |
|
From: <ju...@kl...> - 2011-01-07 14:38:42
|
On Fri, 07 Jan 2011 14:32:50 +0100, "ju...@kl..." <ju...@kl...> wrote: > 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. There is something wrong with the mailbox table. mysql> select email from mailbox; ERROR 1054 (42S22): Unknown column 'email' in 'field list' mysql> describe mailbox; +------------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------------------+-------+ | username | varchar(255) | NO | PRI | NULL | | | password | varchar(255) | NO | | NULL | | | name | varchar(255) | NO | | NULL | | | maildir | varchar(255) | NO | | NULL | | | quota | bigint(20) | NO | | 0 | | | local_part | varchar(255) | NO | | NULL | | | domain | varchar(255) | NO | MUL | NULL | | | created | datetime | NO | | 0000-00-00 00:00:00 | | | modified | datetime | NO | | 0000-00-00 00:00:00 | | | active | tinyint(1) | NO | | 1 | | +------------+--------------+------+-----+---------------------+-------+ 10 rows in set (0.00 sec) I thought that maybe query should have been: password_query = SELECT username as user, password FROM mailbox WHERE email='%u'; mysql> select username as user,password from mailbox; +------------------------+------------------------------------+ | user | password | +------------------------+------------------------------------+ | te...@xx... | $1$xxxxxxx | +------------------------+------------------------------------+ ...But this did only gave the message: Jan 7 15:36:49 logout dovecot: auth-worker(default): sql(te...@xx...,127.0.0.1): Password query failed: Unknown column 'email' in 'where clause' |
|
From: J4 <ju...@kl...> - 2011-01-07 15:09:45
|
On 01/07/2011 04:07 PM, Valkum wrote: > The error says that in where clause second part of your query the column > email non exist. > > check it theres still email. > Am 07.01.2011 15:46, schrieb ju...@kl...: >> On Fri, 07 Jan 2011 14:32:50 +0100, "ju...@kl..." >> <ju...@kl...> wrote: >>> 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. >> >> >> >> There is something wrong with the mailbox table. >> >> mysql> select email from mailbox; >> ERROR 1054 (42S22): Unknown column 'email' in 'field list' >> mysql> describe mailbox; >> +------------+--------------+------+-----+---------------------+-------+ >> | Field | Type | Null | Key | Default | Extra >> | >> +------------+--------------+------+-----+---------------------+-------+ >> | username | varchar(255) | NO | PRI | NULL | >> | >> | password | varchar(255) | NO | | NULL | >> | >> | name | varchar(255) | NO | | NULL | >> | >> | maildir | varchar(255) | NO | | NULL | >> | >> | quota | bigint(20) | NO | | 0 | >> | >> | local_part | varchar(255) | NO | | NULL | >> | >> | domain | varchar(255) | NO | MUL | NULL | >> | >> | created | datetime | NO | | 0000-00-00 00:00:00 | >> | >> | modified | datetime | NO | | 0000-00-00 00:00:00 | >> | >> | active | tinyint(1) | NO | | 1 | >> | >> +------------+--------------+------+-----+---------------------+-------+ >> 10 rows in set (0.00 sec) >> >> I thought that maybe query should have been: >> >> password_query = SELECT username as user, password FROM mailbox WHERE >> email='%u'; >> >> mysql> select username as user,password from mailbox; >> +------------------------+------------------------------------+ >> | user | password | >> +------------------------+------------------------------------+ >> | te...@xx... | $1$xxxxxxx | >> +------------------------+------------------------------------+ >> >> ...But this did only gave the message: >> Jan 7 15:36:49 logout dovecot: auth-worker(default): >> sql(te...@xx...,127.0.0.1): Password query failed: Unknown column >> 'email' in 'where clause' >> >> Problem solved :) Thank-you. I had used the wrong template for mySQL. I should have used: dovecot-mysql.conf when I had used dovecot-sql.conf It all seems to work right now. Many thanks again for your advise. J |
|
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 |
