[gentoo-server] Help with qmail-mysql

[Ronald Vazquez]

Hello:

I installed qmail-mysql and have been trying to get the thing to delive 
mail locally.  I can delive email to an external server but not 
locally.  I added a new user to the system and I was able to deliver 
email to that user until I added the database entries for that user.  
Once there was data in mysql for the new user, delivery to his maildir 
stopped.  I took a chance and wrote Iain Patterson directly but he among 
other couple of things instructed me to look into the way Gentoo patches 
the software.  The log extract and Iain's reply are below.


@4000000043fb982c304f60d4 new msg 215108
@4000000043fb982c30518b84 info msg 215108: bytes 310 from 
<root@××××××××××××.com> qp 29201 uid 0
@4000000043fb982c316b8aec starting delivery 108: msg 215108 to local 
rvazquez@××××××××××××.com
@4000000043fb982c316bd13c status: local 1/10 remote 0/20
@4000000043fb982c31f55844 delivery 108: failure: 
qmail-local:_usage:_qmail-local_[_-nN_]_user_homedir_local_dash_ext_domain_sender_aliasempty/
@4000000043fb982c31fb7a94 status: local 0/10 remote 0/20
@4000000043fb982c3451843c bounce msg 215108 qp 29205
@4000000043fb982c3453977c end msg 215108
@4000000043fb982c34613bac new msg 241987
@4000000043fb982c346283cc info msg 241987: bytes 951 from <> qp 29205 
uid 206
@4000000043fb982c34682534 query: select username, ext from virtual where 
(virtual_username='' or virtual_username='root') and 
virtual_host='ex.mycompany.com' order by virtual_username desc limit 1;
@4000000043fb982c3594165c starting delivery 109: msg 241987 to local 
rvazquez@××××××××××××.com
@4000000043fb982c35945cac status: local 1/10 remote 0/20
@4000000043fb982c361d3004 delivery 109: failure: 
qmail-local:_usage:_qmail-local_[_-nN_]_user_homedir_local_dash_ext_domain_sender_aliasempty/
@4000000043fb982c3622e4f4 status: local 0/10 remote 0/20
@4000000043fb982c372ec32c bounce msg 241987 qp 29209
@4000000043fb982c3730ce9c end msg 241987
@4000000043fb982c373e2c7c new msg 241982
@4000000043fb982c373f749c info msg 241982: bytes 1499 from <#@[]> qp 
29209 uid 206
@4000000043fb982c37453544 query: select username, ext from virtual where 
(virtual_username='' or virtual_username='postmaster') and 
virtual_host='ex.mycompany.com' order by virtual_username desc limit 1;
@4000000043fb982c382c68c4 starting delivery 110: msg 241982 to local 
rvazquez@××××××××××××.com
@4000000043fb982c382c9b8c status: local 1/10 remote 0/20
@4000000043fb982c38b572cc delivery 110: failure: 
qmail-local:_usage:_qmail-local_[_-nN_]_user_homedir_local_dash_ext_domain_sender_aliasempty/
@4000000043fb982c38bb4ecc status: local 0/10 remote 0/20
@4000000043fb982c38bc509c triple bounce: discarding bounce/241982
@4000000043fb982c38bddf0c end msg 241982


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

  Your message to ron is not being delivered.  The bounce is going out 
to the remote system.
Note the error from qmail-local.  Something's not quite right there.

  You might try running qmail-local from the commandline:

    qmail-local -n ron ~ron ron "" "" ex.mycompany.com root ""

  That should say something.  If so you need to investigate why 
qmail-local was spitting out an
error by tracing it, replacing it with a debugging script or something.

  Did qmail ever work without MySQL?  I don't really know how gentoo 
arranges the patching.


************************************************
Tried the following:
qmail-local -n ron ~ron ron "" "" ex.mycompany.com root ""
query: select alias_username, alias_host from alias where username='ron' 
and alias='';
forward rvazquez@××××××××××××.com
did 0+1+0

Yes, qmail works if I add a new user to the system whose data is not yet 
in mysql.


Thanks in advance,
Ronald Vazquez

-- 
gentoo-server@g.o mailing list