qpopper mysql -- "sql query fetch row failed ()"

[Fred Krug]

 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 exampleu...@differentdomain.com
<21>Sep 14 13:59:54 popper[25647]: example...@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.

qpopper mysql "sql query fetch row failed ()"

[Fred Krug]

 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 exampleu...@differentdomain.com 

<21>Sep 14 13:59:54 popper[25647]: example...@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.

qpopper-mysql 0.15-test release

[The Little Prince]

My latest qpopper-mysql patch is now available for download at:
http://asteroid-b612.org/software/#qpopper

Changes in this test release are listed below.

qpopper-mysql is a patch to qpopper 4.0.x adding support for mysql
authentication, virtual domains, and Maildir-style mailboxes.


Changes from 0.14 to 0.15-test:
---
Updated patch for Qpopper 4.0.7, 4.0.8, 4.0.9

Thanx,

--Tony
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-
Anthony J. BiaccoSystems/Network Administrator
[EMAIL PROTECTED] http://www.asteroid-b612.org

"as I always say, why go Merlot, when you can call a Cab?"
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-

qpopper-mysql 0.13 release

[The Little Prince]

My latest qpopper-mysql patch is now available for download at:
http://asteroid-b612.org/software/#qpopper

Changes in this release are listed below.
Changes in this release will NOT be backported to a 4.0.3/4.0.4 patch.

qpopper-mysql is a patch to qpopper 4.0.x adding support for mysql
authentication, virtual domains, and Maildir-style mailboxes.

Changes from 0.12 to 0.13:
---
MAILDIR
 1.  Fixed a bug where the message list would be empty if we encountered
 a message file with a size of 0. We skip the file now.
 2.  Introduced functions maildir_get_flags(), maildir_put_flags(),
 and maildir_has_flags() to read, set, and check for maildir
 status flags in message filenames. This lets the LAST command
 work with a Maildir drop, for clients that won't get message
 status from UIDLs.
 We currently only use and set the 'S' flag, but will keep other 
 retrieved flags intact. --disable-status will be honored to not 
 set the 'S' flag.
 3.  If we encounter a Maildir/ message with no body, we make sure to 
 reset the inheader flag, so the next message doesn't show as 
 corrupted. Some MTAs do not add a blank line (\n) onto their Maildir/ 
 format messages, which triggers this.
MYSQL
 1.  Increased the size of the password field in the example mysql table
 structure from 32 to 64.
 2.  Added a note to the README.MYSQL file, that states the 
 mysql-popper.conf file should NOT be specified on the command line 
 with -f.


--Tony
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
Anthony J. BiaccoNetwork Administrator/Engineer
[EMAIL PROTECTED]  http://www.asteroid-b612.org

 "It's not easy bein' green..there's so many colors I'd rather be"
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.

Re: Qpopper + MySQL

[Ken Anderson]

You can set this as an option to ./configure like so:
--enable-mysql
--with-mysqlconfig=/etc/mysql-popper.conf 
--with-mysqllibpath=/usr/contrib/lib/mysql 
--with-mysqlincludepath=/usr/contrib/include/mysql
--enable-debugging

Ken A.

Christopher Chaduka wrote:
Hi there,

I have installed MySQL, Exim and Qpopper. However, if I telnet on port 
110, I get a connection refused. If I check the log file on the server, 
I see this:

Sep 29 21:53:50 lynx-new popper[25540]: Expected "set" or "reset", found 
"MysqlAuthHost" at line 2 of config file /etc/mysql-popper.conf 
[pop_config.c:1414]

If I put "set MysqlAuthHost", qpopper complains that MysqlAuthHost is 
not a valid set word.

What am I missing here? Is there supposed to be an /etc/popper.conf file 
somewhere? If so, how does it call /etc/mysql-popper.conf?

--

Kiri

Qpopper + MySQL

[Christopher Chaduka]

Hi there,

I have installed MySQL, Exim and Qpopper. However, if I telnet on port 110, 
I get a connection refused. If I check the log file on the server, I see this:

Sep 29 21:53:50 lynx-new popper[25540]: Expected "set" or "reset", found 
"MysqlAuthHost" at line 2 of config file /etc/mysql-popper.conf 
[pop_config.c:1414]

If I put "set MysqlAuthHost", qpopper complains that MysqlAuthHost is not a 
valid set word.

What am I missing here? Is there supposed to be an /etc/popper.conf file 
somewhere? If so, how does it call /etc/mysql-popper.conf?

--

Kiri 

Re: qpopper-mysql-0.12 release

[The Little Prince]

If anyone has downloaded my newest patch today (before 3:45pm MDT), please 
re-download it, as a bug was found in it. Sowwy.

Thanx,

--Tony
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
Anthony J. BiaccoNetwork Administrator/Engineer
[EMAIL PROTECTED]  http://www.asteroid-b612.org

   "You find magic from your god, and I find magic everywhere" 
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.


On Tue, 15 Jul 2003, The Little Prince wrote:

> My latest qpopper-mysql patch is now available for download at:
> http://asteroid-b612.org/software/#qpopper
> 
> Changes in this release are listed below.
> Changes in this release will NOT be backported to a 4.0.3/4.0.4 patch. You 
> will need this patch and 4.0.5 to gain any features/fixes between 
> 0.11/0.9.1 and 0.12
> 
> qpopper-mysql is a patch to qpopper 4.0.x adding support for mysql
> authentication, virtual domains, and Maildir-style mailboxes.
> 
> Changes from 0.11 to 0.12:
> ---
> MYSQL
>  1.  Added a new Mysql field option MysqlLoginHostsField. Can restrict 
>  certain users to certain hosts on multiple pop box systems. See file 
>  mysql-popper.conf for details on use.
>  2.  Have configure bail if we fail to get size for an unsigned long int.
>  Previously, configure would finish successfully, and then a make 
>  would fail on macros using that variable.
>  3.  Changed flow of errored logins, so that even if a mysql error 
>  occurs (such as the user doesn't exist), qpopper still asks for 
>  password, like normal qpopper. This takes away the problem of 
>  account probing.
>  4.  Fixed some strict compiler warnings.
>  5.  Updated README.MYSQL
> MAILDIR
>  1.  Changed file move in maildir_updt from rename() to link()/unlink()
>  instead. File copy and rename are now fallbacks, and stat checking
>  is done for success/failure. This was because Maildir with some 
>  NFS implementations does not like to make a newly rename()d file 
>  visible to all clients.
>  2.  Introduced maildir_sort function to sort messages of a Maildir/
>  style mailbox by modification time (oldest->newest), as this
>  is how an mbox style mailbox works too. Otherwise, messages would
>  be sorted by directory order, which may vary.
>  3.  Added ability to msg_ptr to skip hidden messages that are not the 
>  first one.
>  4.  Updated README.MAILDIR
> 
> 
> --Tony
> .-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
> Anthony J. BiaccoNetwork Administrator/Engineer
> [EMAIL PROTECTED]  http://www.asteroid-b612.org
> 
> "This will prove a brave kingdom to me, 
>   where I shall have my music for nothing"
> .-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
> 
> 
> 
> 

-- 
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
Anthony J. BiaccoNetwork Administrator/Engineer
[EMAIL PROTECTED]  http://www.asteroid-b612.org

   "You find magic from your god, and I find magic everywhere" 
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.

qpopper-mysql-0.12 release

[The Little Prince]

My latest qpopper-mysql patch is now available for download at:
http://asteroid-b612.org/software/#qpopper

Changes in this release are listed below.
Changes in this release will NOT be backported to a 4.0.3/4.0.4 patch. You 
will need this patch and 4.0.5 to gain any features/fixes between 
0.11/0.9.1 and 0.12

qpopper-mysql is a patch to qpopper 4.0.x adding support for mysql
authentication, virtual domains, and Maildir-style mailboxes.

Changes from 0.11 to 0.12:
---
MYSQL
 1.  Added a new Mysql field option MysqlLoginHostsField. Can restrict 
 certain users to certain hosts on multiple pop box systems. See file 
 mysql-popper.conf for details on use.
 2.  Have configure bail if we fail to get size for an unsigned long int.
 Previously, configure would finish successfully, and then a make 
 would fail on macros using that variable.
 3.  Changed flow of errored logins, so that even if a mysql error 
 occurs (such as the user doesn't exist), qpopper still asks for 
 password, like normal qpopper. This takes away the problem of 
 account probing.
 4.  Fixed some strict compiler warnings.
 5.  Updated README.MYSQL
MAILDIR
 1.  Changed file move in maildir_updt from rename() to link()/unlink()
 instead. File copy and rename are now fallbacks, and stat checking
 is done for success/failure. This was because Maildir with some 
 NFS implementations does not like to make a newly rename()d file 
 visible to all clients.
 2.  Introduced maildir_sort function to sort messages of a Maildir/
 style mailbox by modification time (oldest->newest), as this
 is how an mbox style mailbox works too. Otherwise, messages would
 be sorted by directory order, which may vary.
 3.  Added ability to msg_ptr to skip hidden messages that are not the 
 first one.
 4.  Updated README.MAILDIR


--Tony
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
Anthony J. BiaccoNetwork Administrator/Engineer
[EMAIL PROTECTED]  http://www.asteroid-b612.org

"This will prove a brave kingdom to me, 
  where I shall have my music for nothing"
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.

qpopper-mysql-0.11,0.9.1 release

[The Little Prince]

My latest qpopper-mysql patch is now available for download at:
http://asteroid-b612.org/software/#qpopper

Changes in this release are listed below. Changes also apply to a 
newly-released 0.9.1 (which still supports 4.0.3/4.0.4)

qpopper-mysql is a patch to qpopper 4.0.x adding support for mysql
authentication, virtual domains, and Maildir-style mailboxes.

Changes from 0.10 to 0.11:
---
 1.  Replaced all instances of PATH_MAX variable with hard-coded 256,
 as PATH_MAX doesn't get included by all platforms, esp. Solaris,
 causing failed compiles.
 2.  Updating README.MYSQL nad README.MAILDIR with info on how to
 report a problem or bug.

--Tony
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
Anthony J. BiaccoNetwork Administrator/Engineer
[EMAIL PROTECTED]  http://www.asteroid-b612.org

"This will prove a brave kingdom to me, 
  where I shall have my music for nothing"
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.

qpopper-mysql-0.10 release

[The Little Prince]

My latest qpopper-mysql patch is now available for download at:
http://asteroid-b612.org/software/#qpopper

Changes in this release are listed below.

qpopper-mysql is a patch to qpopper 4.0.x adding support for mysql
authentication, virtual domains, and Maildir-style mailboxes.

Changes from 0.9 to 0.10:
---
 1.  Updated patch to work against qpopper 4.0.5


--Tony
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
Anthony J. BiaccoNetwork Administrator/Engineer
[EMAIL PROTECTED]  http://www.asteroid-b612.org

"This will prove a brave kingdom to me, 
  where I shall have my music for nothing"
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.

qpopper-mysql-0.8.patch's stability

[Caram Bola]

The Little Prince's (Anthony J. Biacco's?) qpopper-mysql-0.8.patch 
patched, compiled (Maildir capability only, no MySQL) without 
incident against 4.0.4 sources on a Gentoo Linux 2.4.19 box.
The resulting popper daemon seems to be running well (in standalone 
mode) in the same box.

Although I have read the author's disclaimers and understand that 
this is a beta patch, I am still looking for users' comments as to 
its stability on a (very light load) production server.

Thank you.

Caram

qpopper-mysql-0.6 release

[The Little Prince]

My latest qpopper-mysql patch is now available for download at:
http://asteroid-b612.org/software/#qpopper

Changes in this release are listed below.

qpopper-mysql is a patch to qpopper 4.0.x adding support for mysql 
authentication, virtual domains, and Maildir-style mailboxes.


Changes from 0.5 to 0.6:
---
 1.  Fixed problem where the configure script would not find 
 mysql_connect with MySQL 4.x. Changed it to check for 
 mysql_real_connect instead.
 2.  Added support for defining the mail spool per-user in mysql table.
 Use optional "MysqlSpoolField" variable in mysql-popper.conf, or 
 optional "spool-file" variable in user config
 Added new p-> struct option p->spool_file to hold this.
 See README.MYSQL for more details
 3.  Put a check in the configure script for mysql.h
 4.  Changed the sample mysql row insert in Changes.MYSQL to show that 
 you CAN give the domain, uid, gid, status, and spool fields NULL 
 data values (for future use), but don't expect qpopper not to choke 
 if you tell it to look for data in these fields, and no data is 
 present. Except for spool. If you define the spool field and leave 
 the field's value NULL for a user, the server will generate the spool 
 path, while it will still use a value if it's not NULL/specified.
 5.  Changed the defaults for --with-mysqllibpath and 
 --with-mysqlincludepath, to /usr/lib/mysql and /usr/include/mysql, 
 respectively

--Tony
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
Anthony J. BiaccoNetwork Administrator/Engineer
[EMAIL PROTECTED]  http://www.asteroid-b612.org

"This will prove a brave kingdom to me, 
  where I shall have my music for nothing"
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.

qpopper+mysql

[dj van]

i am traying to install qpopper4.0.3-mysql-0.4.patch
wehn i make make in the terminal i get this error

RWIN -DUNIX pop_parse.c -o pop_parse.o
gcc -c -I.. -I.. -I. \
-I../mmangle -I../common  \
-g -O2 -traditional-cpp -DHAVE_CONFIG_H  -I/usr/local/MySQL/include -DDARWIN -DUNIX pop_pass.c -o pop_pass.o
pop_pass.c: In function `auth_user':
pop_pass.c:1194: warning: assignment makes pointer from integer without a cast
pop_pass.c:1201: invalid use of undefined type `struct spwd'
pop_pass.c:1201: dereferencing pointer to incomplete type
make[1]: *** [pop_pass.o] Fehler 1
make: *** [popper_server] Fehler 2


pleas help me 

van

qpopper-mysql-0.4 - new release

[The Little Prince]

Put on my software page (http://www.asteroid-b612.org/software) today a
new version of my qpopper mysql patch.
Changes from the last version are listed below.

Thank

--Tony


   Last updated: 4 April 2002

Changes from 0.3 to 0.4:
---
 1.  Added ability to do HOMEDIRMAIL with mysql authentication.
 "/home" is the default base path for the user's home directory
 (since we're not using /etc/passwd).
 You can change this by modifying MYSQL_DEFAULT_HOMEDIR in pop_user.c
 You can use this with a virtual setup and hashing.
 Example directory paths are /home/user, /home/u/s/user,
 /home/domain.com/user, /home/domain.com/u/s/user  (see README.MYSQL
 for all of them)
 2.  Changed error message for bad sql fetch to say "Authentication query
 failed, account may not exist." instead of saying that the password
 for that account is incorrect.
 3.  Added "md5" and "mysql" methods for password checking
 (for the MysqlAuthPasswordMethod option). Also added "any" method
 which will check all methods (since now there are more than 2). The
 "both" method can still be used. I left it in for compatibility.
 4.  Added hashing and virtual cases for user-opt/spool-opt paths
 in pop_config.c
 5.  Updated README.MYSQL


.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
Anthony J. BiaccoNetwork Administrator/Engineer
[EMAIL PROTECTED]  http://www.asteroid-b612.org

 "Strange, but it seems, there's a mutiny brewing inside of me"
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.

problem using qpopper+mysql

[Hubert Denkmair]

Hello,

I have to move a mail server to a new linux box
and I'm having real trouble now:

First I wanted to install the latest qpopper-4.0.3
which works perfectly as long as I don't activate
the mysql-patch I found.

As soon as I compile with the --enable-mysql
switch qpopper just quits after the connection
has been established by inetd.
I can't seem to get any debugging message
(yes, i tried to compile with --enable-debugging).

When I try to connect using telnet it looks like that:

/usr/lib # telnet linuxbox pop3
Trying aaa.bbb.ccc.ddd...
Connected to linuxbox.
Escape character is '^]'.
Connection closed by foreign host.
/usr/lib #


So I tried to use the very same qpopper/mysql-version
that I used on the old box (qpopper3.1.2 + exim-qpopper-mysql-0.11.2)
and I find the very same problem :(

what's going wrong?
help, anybody?

Hubert
[EMAIL PROTECTED]

qpopper-mysql-0.2

[Admin Mailing Lists]

This is version 0.2 of my native mysql support for qpopper 4.0.3
0.2 introduces more debugging calls of mysql auth and virtual domain 
support. See docs/Changes.MYSQL for all changes.

Due to limited testing, this patch is not recommended for a production
environment.

It can be found at http://www.asteroid-b612.org/software

Input, test results, and bug reports are appreciated.

-Tony




===
EASY and FREE access to your email anywhere: http://Mailreader.com/
===

Re: qpopper-mysql 4.03 does not read mail and mot receive mail

[Jean-Francois . Aubin/Externe]

Qpopper work without mysql patch. Qpopper read mail without mysql patch.
And i try to use the real spool   with option
--enable-spool-dir=/var/spool/mail. Qpopper doesnt work (same problems)

Thanks
J-F Aubin
[EMAIL PROTECTED]
-- Envoyé par Jean-Francois Aubin/Externe/Alcan le
2001/08/27 16:10 ---

Pour :[EMAIL PROTECTED]
cc :  [EMAIL PROTECTED]
Objet :   Re: qpopper-mysql 4.03 does not read mail and mot receive mail



NOTE: This is a personal email, do NOT reply to the list.

1) does qpopper work with this user WITHOUT the mysql patch?
2) why not use the real spool and not the symlink..i.e the configure
option --enable-spool-dir=/var/spool/mail

-Tony
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
Anthony J. Biacco   Network Administrator/Engineer
[EMAIL PROTECTED]   Intergrafix Internet Services

"Dream as if you'll live forever, live as if you'll die today"
http://www.asteroid-b612.orghttp://www.intergrafix.net
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.

On Fri, 24 Aug 2001 [EMAIL PROTECTED] wrote:

>  I have installed sendmail 8.10.1 with patch from Paul Khavine and
procmail
>  3.13 with patch. Sendmail is up and running with mysql. I have compiled
> qpopper-mysql with:
> ./configure  --enable-servermode --enable-shy --enable-specialauth
> --enable-temp-drop-dir=/var/spool/mail/.pop --disable-check-pw-max
> --enable-fast-update --prefix=/usr --disable-hash-dir-check
> --enable-standalone --enable-mysql --enable-log-login-mysql
> --with-mysqllibpath=/usr/lib/mysql
> --with-mysqlincludepath=/usr/include/mysql
> --with-mysqlconbfig=/etc/mysql-popper.conf
>
>
> I have mail in /var/spool/mail/jfaubin with permission 1777 for the tests
> I have a symbolic link /var/mail /var/spool/mail
>
>  I telnet localhost 110
>
>  Connected to localhost.localdomain.
>  Escape...
>
>  +OK ready
>user jfaubin
>pass password
>
>
>   The System must return:
>
> +ok jfaubin has 0 visible messages (0 hidden) in 0 octets.
>
> I include message from my syslog:
>
>  Aug 23 23:53:52 jfsrv01 popper[30289]: popper: Server: first fork();
>child=30290;
>> exiting [main.c:374]
>> Aug 23 23:53:52 jfsrv01 popper[30290]: popper: Server: child of
first
>fork();
>> pid=30290 [main.c:379]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: popper: Server: child of
second
>> fork(); pid=30291 [main.c:409]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: calling chdir() [main.c:422]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: closing file descs 1024 to 0
>[main.c:444]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: opened stream socket; sockfd
=
>4
>> [main.c:481]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: set stream socket options;
>sockfd
>> = 4 [main.c:498]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: did bind on stream socket;
>sockfd
>> = 4 [main.c:521]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: popper: Server: listening on
>0.0.0.0:110
>> [main.c:529]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: listening using socket fd 4
>[main.c:533]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: set fd 4 non-blocking (0x802)
>[main.c:547]
>> Aug 23 23:53:52 jfsrv01 popper[30290]: popper: Server: second fork
();
>child=30291;
>> exiting [main.c:404]
>> Aug 23 23:53:59 jfsrv01 popper[30291]: accept=6; sockfd=4;
clilen=16;
>cli_addr=127.0.0.1:38222
>> [main.c:607]
>> Aug 23 23:53:59 jfsrv01 popper[30291]: new connection; fd=6
>[main.c:894]
>> Aug 23 23:53:59 jfsrv01 popper[30291]: forked() for new connection;
>pid=30294
>> [main.c:969]
>> Aug 23 23:53:59 jfsrv01 popper[30294]: new child for connection
>[main.c:903]
>> Aug 23 23:53:59 jfsrv01 popper[30294]: newsockfd (6) flags: 0x2
>[main.c:924]
>> Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: Debugging turned on
>(-d)
>> [pop_init.c:708]
>> Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: timeout = 600 (-T)
>[pop_init.c:860]
>> Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: (v4.0.3-mysql-0.1)
>Servicing
>> request from "localhost" at 127.0.0.1 [pop_init.c:1152]
>> Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: before TLS;
>tls_support==0
>> [popper.c:194]
>> Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: Skipped TLS Init
>[popper.c:219]
>> Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: (v4.0.3-mysql-0.1)
>Intro
>> [popper.c:261]
>   

qpopper-mysql 4.03 does not read mail and mot receive mail

[Jean-Francois . Aubin/Externe]

Qpopper work without mysql patch. Qpopper read mail without mysql patch.
And i try to use the real spool   with option
--enable-spool-dir=/var/spool/mail. Qpopper doesnt work (same problems)

Thanks
J-F Aubin
[EMAIL PROTECTED]
-- Envoyé par Jean-Francois Aubin/Externe/Alcan le
2001/08/27 16:10 ---

Pour :[EMAIL PROTECTED]
cc :  [EMAIL PROTECTED]
Objet :   Re: qpopper-mysql 4.03 does not read mail and mot receive mail



NOTE: This is a personal email, do NOT reply to the list.

1) does qpopper work with this user WITHOUT the mysql patch?
2) why not use the real spool and not the symlink..i.e the configure
option --enable-spool-dir=/var/spool/mail

-Tony
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
Anthony J. Biacco   Network Administrator/Engineer
[EMAIL PROTECTED]   Intergrafix Internet Services

"Dream as if you'll live forever, live as if you'll die today"
http://www.asteroid-b612.orghttp://www.intergrafix.net
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.

On Fri, 24 Aug 2001 [EMAIL PROTECTED] wrote:

>  I have installed sendmail 8.10.1 with patch from Paul Khavine and
procmail
>  3.13 with patch. Sendmail is up and running with mysql. I have compiled
> qpopper-mysql with:
> ./configure  --enable-servermode --enable-shy --enable-specialauth
> --enable-temp-drop-dir=/var/spool/mail/.pop --disable-check-pw-max
> --enable-fast-update --prefix=/usr --disable-hash-dir-check
> --enable-standalone --enable-mysql --enable-log-login-mysql
> --with-mysqllibpath=/usr/lib/mysql
> --with-mysqlincludepath=/usr/include/mysql
> --with-mysqlconbfig=/etc/mysql-popper.conf
>
>
> I have mail in /var/spool/mail/jfaubin with permission 1777 for the tests
> I have a symbolic link /var/mail /var/spool/mail
>
>  I telnet localhost 110
>
>  Connected to localhost.localdomain.
>  Escape...
>
>  +OK ready
>user jfaubin
>pass password
>
>
>   The System must return:
>
> +ok jfaubin has 0 visible messages (0 hidden) in 0 octets.
>
> I include message from my syslog:
>
>  Aug 23 23:53:52 jfsrv01 popper[30289]: popper: Server: first fork();
>child=30290;
>> exiting [main.c:374]
>> Aug 23 23:53:52 jfsrv01 popper[30290]: popper: Server: child of
first
>fork();
>> pid=30290 [main.c:379]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: popper: Server: child of
second
>> fork(); pid=30291 [main.c:409]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: calling chdir() [main.c:422]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: closing file descs 1024 to 0
>[main.c:444]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: opened stream socket; sockfd
=
>4
>> [main.c:481]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: set stream socket options;
>sockfd
>> = 4 [main.c:498]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: did bind on stream socket;
>sockfd
>> = 4 [main.c:521]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: popper: Server: listening on
>0.0.0.0:110
>> [main.c:529]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: listening using socket fd 4
>[main.c:533]
>> Aug 23 23:53:52 jfsrv01 popper[30291]: set fd 4 non-blocking (0x802)
>[main.c:547]
>> Aug 23 23:53:52 jfsrv01 popper[30290]: popper: Server: second fork
();
>child=30291;
>> exiting [main.c:404]
>> Aug 23 23:53:59 jfsrv01 popper[30291]: accept=6; sockfd=4;
clilen=16;
>cli_addr=127.0.0.1:38222
>> [main.c:607]
>> Aug 23 23:53:59 jfsrv01 popper[30291]: new connection; fd=6
>[main.c:894]
>> Aug 23 23:53:59 jfsrv01 popper[30291]: forked() for new connection;
>pid=30294
>> [main.c:969]
>> Aug 23 23:53:59 jfsrv01 popper[30294]: new child for connection
>[main.c:903]
>> Aug 23 23:53:59 jfsrv01 popper[30294]: newsockfd (6) flags: 0x2
>[main.c:924]
>> Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: Debugging turned on
>(-d)
>> [pop_init.c:708]
>> Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: timeout = 600 (-T)
>[pop_init.c:860]
>> Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: (v4.0.3-mysql-0.1)
>Servicing
>> request from "localhost" at 127.0.0.1 [pop_init.c:1152]
>> Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: before TLS;
>tls_support==0
>> [popper.c:194]
>> Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: Skipped TLS Init
>[popper.c:219]
>> Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: (v4.0.3-mysql-0.1)
>Intro
>> [popper.c:261]
>   

qpopper-mysql 4.03 does not read mail and mot receive mail

[Jean-Francois . Aubin/Externe]

 I have installed sendmail 8.10.1 with patch from Paul Khavine and procmail
 3.13 with patch. Sendmail is up and running with mysql. I have compiled
qpopper-mysql with:
./configure  --enable-servermode --enable-shy --enable-specialauth
--enable-temp-drop-dir=/var/spool/mail/.pop --disable-check-pw-max
--enable-fast-update --prefix=/usr --disable-hash-dir-check
--enable-standalone --enable-mysql --enable-log-login-mysql
--with-mysqllibpath=/usr/lib/mysql
--with-mysqlincludepath=/usr/include/mysql
--with-mysqlconbfig=/etc/mysql-popper.conf


I have mail in /var/spool/mail/jfaubin with permission 1777 for the tests
I have a symbolic link /var/mail /var/spool/mail

 I telnet localhost 110

 Connected to localhost.localdomain.
 Escape...

 +OK ready
   user jfaubin
   pass password


  The System must return:

+ok jfaubin has 0 visible messages (0 hidden) in 0 octets.

I include message from my syslog:

 Aug 23 23:53:52 jfsrv01 popper[30289]: popper: Server: first fork();
   child=30290;
   > exiting [main.c:374]
   > Aug 23 23:53:52 jfsrv01 popper[30290]: popper: Server: child of first
   fork();
   > pid=30290 [main.c:379]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: popper: Server: child of second
   > fork(); pid=30291 [main.c:409]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: calling chdir() [main.c:422]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: closing file descs 1024 to 0
   [main.c:444]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: opened stream socket; sockfd =
   4
   > [main.c:481]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: set stream socket options;
   sockfd
   > = 4 [main.c:498]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: did bind on stream socket;
   sockfd
   > = 4 [main.c:521]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: popper: Server: listening on
   0.0.0.0:110
   > [main.c:529]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: listening using socket fd 4
   [main.c:533]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: set fd 4 non-blocking (0x802)
   [main.c:547]
   > Aug 23 23:53:52 jfsrv01 popper[30290]: popper: Server: second fork();
   child=30291;
   > exiting [main.c:404]
   > Aug 23 23:53:59 jfsrv01 popper[30291]: accept=6; sockfd=4; clilen=16;
   cli_addr=127.0.0.1:38222
   > [main.c:607]
   > Aug 23 23:53:59 jfsrv01 popper[30291]: new connection; fd=6
   [main.c:894]
   > Aug 23 23:53:59 jfsrv01 popper[30291]: forked() for new connection;
   pid=30294
   > [main.c:969]
   > Aug 23 23:53:59 jfsrv01 popper[30294]: new child for connection
   [main.c:903]
   > Aug 23 23:53:59 jfsrv01 popper[30294]: newsockfd (6) flags: 0x2
   [main.c:924]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: Debugging turned on
   (-d)
   > [pop_init.c:708]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: timeout = 600 (-T)
   [pop_init.c:860]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: (v4.0.3-mysql-0.1)
   Servicing
   > request from "localhost" at 127.0.0.1 [pop_init.c:1152]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: before TLS;
   tls_support==0
   > [popper.c:194]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: Skipped TLS Init
   [popper.c:219]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: (v4.0.3-mysql-0.1)
   Intro
   > [popper.c:261]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: +OK ready
   [popper.c:269]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: Qpopper ready for
   input
   > from (null) at localhost [127.0.0.1] [popper.c:306]
   > Aug 23 23:54:04 jfsrv01 /usr/sbin/popper[30294]: Received (12): "user
   jfaubin"
   > [pop_get_command.c:105]
   > Aug 23 23:54:04 jfsrv01 /usr/sbin/popper[30294]: home via mysql (9):
   '/var/mail'
   > [pop_user.c:404]
   > Aug 23 23:54:04 jfsrv01 /usr/sbin/popper[30294]: +OK Password required
   > for jfaubin. [pop_user.c:625]
   > Aug 23 23:54:04 jfsrv01 /usr/sbin/popper[30294]: user returned 1;
   CurrentState
   > now auth2 [popper.c:350]
   > Aug 23 23:54:04 jfsrv01 /usr/sbin/popper[30294]: Qpopper ready for
   input
   > from jfaubin at localhost [127.0.0.1] [popper.c:306]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: Received: "pass
   x"
   > [pop_get_command.c:96]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: ...built: (39)
   '/var/mail/'
   > [genpath.c:158]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: genpath Spool (1)
   [hash:
   > 0; home: NULL] for user 0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]
   @P?^]@X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]
   @\210?^]@\210?^]@\220?^]@\220?^]@\230?^]@\
   > 230?^]@ ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?
   ^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@
   > returning /var/mail/0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]@P?^]
   @X?^]@X?^]@`?^]@`?^]@h?^]@

Re: qpopper mysql

[Admin Mailing Lists]

On Tue, 21 Aug 2001, Yves Thommes wrote:

> Hi
> 
> I saw this questions already several times on this mailing-list but i never
> saw a single answer to it:
> 
> Where can i get a qpopper 4.x version with mysql support like the mysql
> qpopper patch for 3.x versions available from
> http://www.netd.co.za/mysql-mail/ ?
> We're running all our mail servers on exim with qpopper and the mysql
> patches and we're seriously considering to upgrade all our mail servers to
> qpopper 4 but if there are any mysql patches for qpopper 4x we're planning
> to move to qmail.
> 

It actually was covered on the list in a few messages. 
I have a patch against 3.1.2 and 4.0.3 at my software page,
http://www.asteroid-b612.org/software

NOTE: These patches do NOT have support for virtual domains.

-Tony
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
Anthony J. Biacco   Network Administrator/Engineer
[EMAIL PROTECTED]   Intergrafix Internet Services

"Dream as if you'll live forever, live as if you'll die today"
http://www.asteroid-b612.orghttp://www.intergrafix.net
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.

> please help
> thanks
> 
> best regards,
> yves
> 
> 

qpopper mysql

[Yves Thommes]

Hi

I saw this questions already several times on this mailing-list but i never
saw a single answer to it:

Where can i get a qpopper 4.x version with mysql support like the mysql
qpopper patch for 3.x versions available from
http://www.netd.co.za/mysql-mail/ ?
We're running all our mail servers on exim with qpopper and the mysql
patches and we're seriously considering to upgrade all our mail servers to
qpopper 4 but if there are any mysql patches for qpopper 4x we're planning
to move to qmail.

please help
thanks

best regards,
yves

QPopper + MySQL

[Nuno Teixeira]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hello to all,

Sometime a go, I've read that someone has interconnect a 3000 pop users
MySQL database with QPopper. I'm very interested in this connection, but I
don't know how to relate the two programs.

I want to know too, if anyone has done the same conection between Bind and
a SQL database for a lot of domains.

Thanks very much to all and to the excellent QPopper product,


- --
Nuno Teixeira
Dir. Técnico
pt-quorum.com



-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8
Comment: Made with pgp4pine 1.75-6

iQA/AwUBOq7Ca48HcgpjoE/HEQILnACfXqXOEDFKl2yTNlcWIBCBvuvKaeQAoL0x
zlMSByLq2mjT72jWkEBrEgia
=3SrL
-END PGP SIGNATURE-

Re: QPOPPER + Mysql

[Torsten Mueller]

Hey,

Paulo Santos schrieb:
> 
> Hello All
> 
> Can anybody to tell me if it´s possible run QPOPPER 3.1 with MySQL 3.23 ..
> 
> I´ve a big user database in MySQL and I´d like change my mail server to QPOPPER.
> 
> Thanks in advance!
> 
> Paulo
> -

In my opinion, there are 2 solutions:

1. http://www.riverstyx.net/qpopmysql/
This patch doesn't work for me with 3.1.2 , but if you are
a programmer, then is this the beginning of the simple
solution.

2. http://www.netd.co.za/mysql-mail/
This solution compiled fine for me with 3.1.2 , but it is 
originally designed for use with exim.

Greetings Torsten

QPOPPER + Mysql

[Paulo Santos]

Hello All 
 
Can anybody to tell me if it´s possible run QPOPPER 3.1 with MySQL 3.23 .. 
 
I´ve a big user database in MySQL and I´d like change my mail server to QPOPPER. 
 
Thanks in advance! 
 
Paulo 
-