[tpop3d-discuss] tpop3d newbie trouble with auth_mysql

Support support at bizland-inc.com
Fri, 23 Nov 2001 19:51:31 -0800


This is a multi-part message in MIME format.

------=_NextPart_000_0045_01C17458.3F7152E0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Howdy. I was wondering if someone had some clues for me on what I might =
be doing wrong...

I've been trying to get auth_mysql working with tpop3d. The auth_passwd =
works okay, so at least something's working correctly :)  (took it out =
though for testing)

Here's my conf file. I've eliminated as many variables as possible. Note =
too the dummy SQL I used where it should always return the same thing.

# tpop3d config file
auth-mysql-enable: yes
auth-mysql-mail-group: mail
auth-mysql-hostname: localhost
auth-mysql-database: pop
auth-mysql-username: root
auth-mysql-password:=20

auth-mysql-pass-query:  \
        SELECT '/var/spool/mail/moseley', '{plaintext}passwd', =
'moseley', 'mailspool' \
        FROM PopTestTable     =20



The mysql password is really just blank and no error pops up when I =
start with -dv

Client side:
[root@atia tpop3d-1.3.4]# telnet localhost 9110
Trying 127.0.0.1...
Connected to localhost.localdomain.
Escape character is '^]'.
+OK <2d18edcd02435417b04f53959fcc42cc@atia>
USER moseley
+OK Tell me your password.
PASS passwd
-ERR Lies! Try again!


Server side:
[root@atia tpop3d-1.3.5]# /usr/local/sbin/tpop3d -f /etc/tpop3d.conf -dv
experimental BSD mailbox metadata cache enabled
listener_new: gethostbyaddr(0.0.0.0): cannot resolve name
listener_new: 0.0.0.0: no domain suffix can be appended for this address
listener_new: 0.0.0.0: using fallback domain suffix `atia'
listening on address 0.0.0.0, port 9110, domain atia
1 authentication drivers successfully loaded
net_loop: tpop3d version 1.3.5 successfully started
connection_sendresponse: client [6]127.0.0.1/atia: sent `+OK =
<6d1787ddd8b453b642ed6cdcb0a580fc@atia>'
listeners_post_select: client [6]127.0.0.1/atia: connected
connection_parsecommand: client [6]127.0.0.1/atia: received `USER =
moseley'
connection_sendresponse: client [6]127.0.0.1/atia: sent `+OK Tell me =
your password.'
connection_parsecommand: client [6]127.0.0.1/atia: received `PASS [...]'
connection_sendresponse: client [6]127.0.0.1/atia: sent `-ERR Lies! Try =
again!'
connection_do: client `[6]127.0.0.1/atia': 1 authentication failures


The mysql server is up and running and can be connected to via command =
line. The data in it matches up with my query, but it seems like it =
should matter much anyway since I have it returning dummy data. The =
table as well exists and can be selected against.

I've been goofing with it all day with no luck. I've noticed however =
that I'm not seeing any connections to the database and mysqladmin =
processlist doesn't show anything. /usr/lib/mysql/libmysqlclient.so and =
/usr/include/mysql/mysql.h both exist and are fairly current.

Anybody have any clues for a totally clueless tpop3d newbie? Thanks!=20

P.S. If I've forgotten to include anything, I'll be happy to write back =
:)

------=_NextPart_000_0045_01C17458.3F7152E0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Howdy. I was wondering if someone had =
some clues=20
for me on what I might be doing wrong...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I've been trying to get auth_mysql =
working with=20
tpop3d. The auth_passwd works okay, so at least something's working =
correctly=20
:)&nbsp; (took it out though for testing)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Here's my conf file. I've eliminated as =
many=20
variables as possible. Note too the dummy SQL I used where it should =
always=20
return the same thing.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2># tpop3d config file</FONT></DIV><FONT =
face=3DArial=20
size=3D2>
<DIV>auth-mysql-enable: yes</DIV>
<DIV>auth-mysql-mail-group: mail</DIV>
<DIV>auth-mysql-hostname: localhost</DIV>
<DIV>auth-mysql-database: pop</DIV>
<DIV>auth-mysql-username: root<BR>auth-mysql-password: </DIV>
<DIV>&nbsp;</DIV>
<DIV>auth-mysql-pass-query:&nbsp;=20
\<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT=20
'/var/spool/mail/moseley', '{plaintext}passwd', 'moseley', 'mailspool'=20
\<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM=20
PopTestTable&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>The mysql password is really just blank and no error pops up when I =
start=20
with -dv</DIV>
<DIV>&nbsp;</DIV>
<DIV>Client side:</DIV>
<DIV>[root@atia tpop3d-1.3.4]# telnet localhost 9110<BR>Trying=20
127.0.0.1...<BR>Connected to localhost.localdomain.<BR>Escape character =
is=20
'^]'.<BR>+OK &lt;<A=20
href=3D"mailto:2d18edcd02435417b04f53959fcc42cc@atia">2d18edcd02435417b04=
f53959fcc42cc@atia</A>&gt;<BR>USER=20
moseley<BR>+OK Tell me your password.<BR>PASS passwd<BR>-ERR Lies! Try=20
again!</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>Server side:</DIV>
<DIV>[root@atia tpop3d-1.3.5]# /usr/local/sbin/tpop3d -f =
/etc/tpop3d.conf=20
-dv<BR>experimental BSD mailbox metadata cache enabled<BR>listener_new:=20
gethostbyaddr(0.0.0.0): cannot resolve name<BR>listener_new: 0.0.0.0: no =
domain=20
suffix can be appended for this address<BR>listener_new: 0.0.0.0: using =
fallback=20
domain suffix `atia'<BR>listening on address 0.0.0.0, port 9110, domain=20
atia<BR>1 authentication drivers successfully loaded<BR>net_loop: tpop3d =
version=20
1.3.5 successfully started<BR>connection_sendresponse: client =
[6]127.0.0.1/atia:=20
sent `+OK &lt;<A=20
href=3D"mailto:6d1787ddd8b453b642ed6cdcb0a580fc@atia>'">6d1787ddd8b453b64=
2ed6cdcb0a580fc@atia&gt;'</A><BR>listeners_post_select:=20
client [6]127.0.0.1/atia: connected<BR>connection_parsecommand: client=20
[6]127.0.0.1/atia: received `USER moseley'<BR>connection_sendresponse: =
client=20
[6]127.0.0.1/atia: sent `+OK Tell me your =
password.'<BR>connection_parsecommand:=20
client [6]127.0.0.1/atia: received `PASS =
[...]'<BR>connection_sendresponse:=20
client [6]127.0.0.1/atia: sent `-ERR Lies! Try again!'<BR>connection_do: =
client=20
`[6]127.0.0.1/atia': 1 authentication failures</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>The mysql server is up and running and can be connected to via =
command=20
line. The data in it matches up with my query, but it seems like it =
should=20
matter much anyway since I have it returning dummy data. The table as =
well=20
exists and can be selected against.</DIV>
<DIV>&nbsp;</DIV>
<DIV>I've been goofing with it all day with no luck. I've noticed =
however that=20
I'm not seeing any connections to the database and mysqladmin =
processlist=20
doesn't show anything. /usr/lib/mysql/libmysqlclient.so and=20
/usr/include/mysql/mysql.h both exist and are fairly current.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Anybody have any clues for a totally clueless tpop3d newbie? =
Thanks! </DIV>
<DIV>&nbsp;</DIV>
<DIV>P.S. If I've forgotten to include anything, I'll be happy to write =
back=20
:)</FONT></DIV></BODY></HTML>

------=_NextPart_000_0045_01C17458.3F7152E0--