The qpopper list archive ending on 9 Jun 2011

Topics covered in this issue include:

  1. qpopper mysql "sql query fetch row failed ()"
       Fred Krug <fkrug at hpo dot net>
       Tue, 14 Sep 2010 19:41:12 +0900
  2. qpopper mysql -- "sql query fetch row failed ()"
       Fred Krug <fkrug at hpo dot net>
       Tue, 21 Sep 2010 14:45:41 +0900
  3. 
       
       
  4. 
       
       
  5. access contemporaneous
       "Salvatore" <sasa at shoponweb dot it>
       Thu, 26 May 2011 10:12:26 +0200
  6. Re: access contemporaneous
       Randall Gellens <randy at qualcomm dot com>
       Thu, 26 May 2011 15:11:43 -0700
  7. RE: access contemporaneous
       "Salvatore" <sasa at shoponweb dot it>
       Fri, 27 May 2011 10:32:27 +0200
  8. Qpopper 4.1 (released) available
       Randall Gellens <randy at qualcomm dot com>
       Wed, 1 Jun 2011 13:55:15 -0700
  9. Qpopper 4.1 (released) available
       Randall Gellens <randy at qualcomm dot com>
       Wed, 1 Jun 2011 13:55:15 -0700
 10. RE: access contemporaneous
       Randall Gellens <randy at qualcomm dot com>
       Wed, 1 Jun 2011 13:59:13 -0700
 11. Call for Testers
       Doug Hardie <bc979 at lafn dot org>
       Thu, 9 Jun 2011 01:10:49 -0700

Date: Tue, 14 Sep 2010 19:41:12 +0900
From: Fred Krug <fkrug at hpo dot net>
Subject: qpopper mysql "sql query fetch row failed ()"

  I have just installed qpopper with the mysql patch on my CentOS server 
and am having a problem querying the database. I've had this working on 
various other linux servers without any problem. If I query the default 
database it works but if I query one of the virtual database it fails.

Qpopper version 4.0.18-mysql-0.16 (standalone)

When I telnet to the default database it works:
telnet localhost 110
popper[26256]: (v4.0.18-mysql-0.16) Servicing request from 
"server.domain.com" at 127.0.0.1+OK ready
User exampleuser
+OK Password required for exampleuser.
Pass examplepass
+OK exampleuser has 0 visible messages (0 hidden) in 0 octets

However, if I telnet to a virtual database it fails:
telnet localhost 110
popper[26256]: (v4.0.18-mysql-0.16) Servicing request from 
"server.domain.com" at 127.0.0.1+OK ready
User exampleuser@differentdomain.com 
<mailto:exampleuser@differentdomain.com>
<21>Sep 14 13:59:54 popper[25647]: exampleuse@differentdomain.com 
<mailto:exampleuse@differentdomain.com>: ERROR: sql query fetch row 
failed (). User may not exist+OK Password required for exampleuse.

The query seems to chop off the last letter of the UserId when I use 
@domain.com

Any advice would much be appreciated.

All the best
Fred

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Date: Tue, 21 Sep 2010 14:45:41 +0900
From: Fred Krug <fkrug at hpo dot net>
Subject: qpopper mysql -- "sql query fetch row failed ()"

  I have just installed qpopper with the mysql patch on my CentOS 5.5 
server and am having a problem querying the database. I've had this 
working on various other linux servers without any problem. If I query 
the default database it works but if I query one of the virtual database 
it fails.

When I telnet to the default database it works:
telnet localhost 110
popper[26256]: (v4.0.18-mysql-0.16) Servicing request from 
"server.domain.com" at 127.0.0.1+OK ready
User exampleuser
+OK Password required for exampleuser.
Pass examplepass
+OK exampleuser has 0 visible messages (0 hidden) in 0 octets

However, if I telnet to a virtual database it fails:
telnet localhost 110
popper[26256]: (v4.0.18-mysql-0.16) Servicing request from 
"server.domain.com" at 127.0.0.1+OK ready
User exampleuser@differentdomain.com
<21>Sep 14 13:59:54 popper[25647]: exampleuse@differentdomain.com: 
ERROR: sql query fetch row failed () User may not exist+OK Password 
required forexampleuse.
NOTE:Missing letter "r" at the end of UserID.

The query seems to chop off the last letter of the UserId when I use 
@domain.com

**********************************************

Additional information regarding the set up.

-Mysql 5.1.50 tarball
./configure \
--prefix=/usr/local/mysql \
--disable-maintainer-mode \
--with-mysqld-user=mysql \
--with-unix-socket-path=/tmp/mysql.sock \
--without-comment \
--without-debug \
--without-bench

This is the same database that I've been using for years and earlier 
versions of qpopper have always worked.

I inserted a test user/domain.

[QUOTE]mysql> INSERT INTO radcheck (id, UserName, attribute, value, uid, 
gid,domain, alias, is_alias, net_id) VALUES ('999', 'exampleuser', '', 
'test','500', '12', 'differentdomain.com', '', 'no', 'exampleuser');
Query OK, 1 row affected (0.03 sec)[/QUOTE]

When I log on to the database all looks fine:
mysql> select * from radcheck where net_id = 'exampleuser';
+-----+----------+-----------+-------+-----+-----+-------------+-------+----------+---------+
| id  | UserName | attribute | value | uid | gid | domain      | alias | 
is_alias | net_id  |
+-----+----------+-----------+-------+-----+-----+-------------+-------+----------+---------+
| 999 | exampleuser  |               | test  | 500 |  12 | 
differentdomain.com |       | no       | exampleuser |
+-----+----------+-----------+-------+-----+-----+-------------+-------+----------+---------+
1 row in set (0.00 sec)

I granted mailadmin full permission.

[QUOTE]> grant all privileges on radius.* to 'mailadmin'@'localhost' 
identified by 'secret';

 >flush privileges;[/QUOTE]



I download Qpopper qpopper4.0.19.tar.gz (this is the version mysql patch 
was written for) and the patch qpopper3.1.2-mysql-0.1.patch. I patched 
it (no errors) and compiled/made it (no errors).

./configure  \
--with-mysqlconfig=/etc/mysql-popper.conf  \
--enable-mysql  \
--with-mysqllibpath=/usr/local/mysql/lib/mysql  \
--with-mysqlincludepath=/usr/local/mysql/include/mysql  \
--enable-standalone  \
--enable-shy  \
--enable-servermode

This is a copy of mysql-popper.conf
[QUOTE]MysqlAuthHost localhost
MyslAuthPort 3306
MysqlAuthDb radius
MysqlAuthTable radcheck
MysqlAuthUsername mailadmin
MysqlAuthPassword secret
MysqlAuthUsernameField username
MysqlAuthPasswordField value
MysqlAuthDomainField domain
MysqlAuthAliasField alias
AliasField is_alias
MysqlAuthAliasNo no
MysqlAuthPasswordMethod both
MysqlAuthDefaultDomain domain.com
MysqlAuthUIDField uid
MysqlAuthGIDField gid
MysqlAuthUID mail
MysqlAuthGID mail
POP_MAILDIR /var/spool/virtual_mail[/QUOTE]

This set up has always worked for me in the past but it isn't working 
with the new qpopper/patch. As I mentioned, it is chopping the last 
letter off the UserID. I've dug through the logs but couldn't find 
anything that would point me in the right direction. Any advice on how 
to solve this would be greatly appreciated.

All the best
Fred

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

From: "Salvatore" <sasa at shoponweb dot it>
Subject: access contemporaneous
Date: Thu, 26 May 2011 10:12:26 +0200

Hello, on more accounts I have problem because there are log-on contemporary
(ie from PC and from Blackberry), I have this error:

May 24 13:53:59 mail popper[15553]: xxxx at x.x.x.x (x.x.x.x): -ERR [IN-USE]
/var/mail/.xxxx.pop lock busy!  Is another session active? (11)

Is possible resolve this problem ?
Regards.



-
 Salvatore.

Date: Thu, 26 May 2011 15:11:43 -0700
From: Randall Gellens <randy at qualcomm dot com>
Subject: Re: access contemporaneous

At 10:12 AM +0200 5/26/11, Salvatore wrote:

>  Hello, on more accounts I have problem because there are log-on contemporary
>  (ie from PC and from Blackberry), I have this error:
>
>  May 24 13:53:59 mail popper[15553]: xxxx at x.x.x.x (x.x.x.x): -ERR [IN-USE]
>  /var/mail/.xxxx.pop lock busy!  Is another session active? (11)
>
>  Is possible resolve this problem ?
>  Regards.

Hi Salvatore,

Are you using server mode?  That reduces the lock time, which can 
reduce the frequency of getting this error.  But, even when the error 
does occur, the client getting the error should retry and be able to 
get in then because the other client has exited.

-- 
Randall Gellens
Opinions are personal;    facts are suspect;    I speak for myself only
-------------- Randomly selected tag: ---------------
  "I am not a number!
   I am a free numeric variable!"

From: "Salvatore" <sasa at shoponweb dot it>
Subject: RE: access contemporaneous
Date: Fri, 27 May 2011 10:32:27 +0200

"Randall Gellens" wrote:

> Are you using server mode?  That reduces the lock time, which can
> reduce the frequency of getting this error.  But, even when the error
> does occur, the client getting the error should retry and be able to
> get in then because the other client has exited.

Yes, I use qpopper in server mode and not in standalone mode.
How I can reduce further the frequency error ?
Thanks in advance.



-
 Salvatore.

Date: Wed, 1 Jun 2011 13:55:15 -0700
From: Randall Gellens <randy at qualcomm dot com>
Subject: Qpopper 4.1 (released) available

Qpopper 4.1.0 is available at 
<ftp://ftp.qualcomm.com/eudora/servers/unix/popper/>.

The full list of changes is in the distribution.

I apologize for the extended delay in releasing 4.1 and wish to give 
special thanks to all those who contributed and helped.

-- 
Randall Gellens
Opinions are personal;    facts are suspect;    I speak for myself only
-------------- Randomly selected tag: ---------------
A long-forgotten loved one will appear soon.  Buy the negatives
at any price.

Date: Wed, 1 Jun 2011 13:55:15 -0700
From: Randall Gellens <randy at qualcomm dot com>
Subject: Qpopper 4.1 (released) available

Qpopper 4.1.0 is available at 
<ftp://ftp.qualcomm.com/eudora/servers/unix/popper/>.

The full list of changes is in the distribution.

I apologize for the extended delay in releasing 4.1 and wish to give 
special thanks to all those who contributed and helped.

-- 
Randall Gellens
Opinions are personal;    facts are suspect;    I speak for myself only
-------------- Randomly selected tag: ---------------
A long-forgotten loved one will appear soon.  Buy the negatives
at any price.

Date: Wed, 1 Jun 2011 13:59:13 -0700
From: Randall Gellens <randy at qualcomm dot com>
Subject: RE: access contemporaneous

At 10:32 AM +0200 5/27/11, Salvatore wrote:

>  Yes, I use qpopper in server mode and not in standalone mode.
>  How I can reduce further the frequency error ?
>  Thanks in advance.

Hi Salvatore,

Is it the case that only some of your users are getting this error? 
You might want to see how large their mail spools are; larger files 
take more time to process.

Also, are you using caches?  Caches further reduce the time it takes 
Qpopper to initially process the spool.

Finally, when these errors occur, how frequent are they?  I am 
wondering if you might have users who have set their mail client to 
check mail every 60 or 90 seconds or something like that.

-- 
Randall Gellens
Opinions are personal;    facts are suspect;    I speak for myself only
-------------- Randomly selected tag: ---------------
There's only one corner of the universe you can be certain of
improving that's your own self.               --Aldous Huxley

From: Doug Hardie <bc979 at lafn dot org>
Subject: Call for Testers
Date: Thu, 9 Jun 2011 01:10:49 -0700

Qpopper 4.1.0 is now out.  I have a reasonably un-tested port ready for 
testing.  My test machine is currently configured for dovecot because of 
a client who absolutely has to have that.  So it will be a couple of 
weeks before I can try it out.  It compiles fine.  Even APOP now 
compiles.  If you would like to test this, let me know and I will send 
the port files.