Topic: Maillog Error: maildrop[4756]: Cannot determine my username.

[Zen]

Hi, after the recent update of my sme 8.1, it stopped receive any email. They are all in qmail queue and in qmail log i've this error:

Code: [Select]

delivery 145: deferral: /usr/bin/maildrop:_Cannot_determine_my_username./
This for all the users and groups. Is there a solution?

Thanks in advance,
Bye

[Zen]

Maildrop is not a part of the core, but...in which contrib have I installed it? User-panel? Vacation?
If I remove this contrib, can i solve the problem?

[Zen]

Update...
in

Code: [Select]

/home/e-smith/files/users/user01 I found some files

Code: [Select]

.mailfilter
.procmailrc
.qmail
.qmail-default
.qmail-junkmail
.vacation.msg
.mailfilter.log
.mailfilter.log.1
.mailfilter.log.2
Now, moving all this files, I started to receive again but i've lost all the qmail queue. How can i retrieve all those messages?
What is strange is that those files were not recreated as I expected.

Edit:
The files have been recreated after a qmHandle -a command.

The strange is, until the file .qmail is in the folder, i can't receive anything; only when the file .qmail is deleted or moved and after a qmHandle -a I start to receive my emails. Everytime i must repeat this procedure or i give that error.

[Stefano]

.qmail file is necessary for qmail to work
You are watching in the wrong direction..

[Zen]

Any suggestion on where to watch?

My steps (as you can see on this log):

Code: [Select]

Sep 25 14:42:44 Updated: glibc-common-2.5-118.el5_10.3.i386
Sep 25 14:43:04 Updated: glibc-2.5-118.el5_10.3.i686
Sep 25 14:43:08 Updated: bash-3.2-33.el5.1.i386
Sep 25 14:43:11 Updated: openssl-0.9.8e-28.el5.sme.i386
Sep 25 14:43:12 Updated: php-common-5.3.3-15.el5.sme.i386
Sep 25 14:43:13 Updated: php-cli-5.3.3-15.el5.sme.i386
Sep 25 14:43:13 Updated: php-pdo-5.3.3-15.el5.sme.i386
Sep 25 14:43:14 Updated: php-5.3.3-15.el5.sme.i386
Sep 25 14:43:15 Updated: php-mbstring-5.3.3-15.el5.sme.i386
Sep 25 14:43:20 Updated: php-devel-5.3.3-15.el5.sme.i386
Sep 25 14:43:21 Updated: php-xml-5.3.3-15.el5.sme.i386
Sep 25 14:43:21 Updated: php-gd-5.3.3-15.el5.sme.i386
Sep 25 14:43:22 Updated: php-imap-5.3.3-15.el5.sme.i386
Sep 25 14:43:22 Updated: php-ldap-5.3.3-15.el5.sme.i386
Sep 25 14:43:24 Updated: nscd-2.5-118.el5_10.3.i386
Sep 25 14:43:29 Updated: 7:squid-2.6.STABLE21-7.el5_10.i386
Sep 25 14:43:29 Updated: php-mysql-5.3.3-15.el5.sme.i386
Sep 25 14:44:00 Installed: kernel-PAE-2.6.18-371.12.1.el5.i686
Sep 25 14:44:00 Updated: procmail-3.22-17.1.2.el5_10.i386
Sep 25 14:44:30 Installed: kernel-2.6.18-371.12.1.el5.i686
Sep 25 16:30:48 Installed: giflib-4.1.3-7.3.3.el5.i386
Sep 25 16:30:48 Installed: giflib-utils-4.1.3-7.3.3.el5.i386
Sep 25 16:30:48 Erased: libungif-progs
Sep 25 16:30:49 Erased: libungif
Sep 25 16:32:29 Erased: maildrop [b]<---- my mistake in panic [/b]
Sep 25 16:51:35 Updated: smeserver-mailsorting-1.2-45.el5.sme.noarch
Sep 25 17:04:12 Installed: maildrop-2.5.0-13.el5.i386
Sep 25 17:28:44 Updated: smeserver-userpanel-0.9-16.el5.sme.noarch
removing maildrop, obviously qmail said:

Code: [Select]

2014-09-25 16:33:40.423076500 delivery 257: deferral: /bin/sh:_/usr/bin/maildrop:_No_such_file_or_directory/After reinstalling maildrop, qmail returned the previous message:

Code: [Select]

delivery 145: deferral: /usr/bin/maildrop:_Cannot_determine_my_username./Removing all the .qmail files and forcing qmail to send the queue, all seems working, but, when the .qmail file reappears, i must delete it again...but, now seems not always, for example, one minute ago i received an email without doing nothing.

I don't know where can I watch to solve this problem

[Stefano]

First of all remove maildrop or, if possible, disable it

Then, start studying SME's template concepts (here and in the developers' manual)

[Zen]

Did it, but without success.

[Stefano]

Please describe exactly what you did and how

[Zen]

From web panel i launched an update using the button:

Code: [Select]

14:42:44 Updated: glibc-common-2.5-118.el5_10.3.i386
Sep 25 14:43:04 Updated: glibc-2.5-118.el5_10.3.i686
Sep 25 14:43:08 Updated: bash-3.2-33.el5.1.i386
Sep 25 14:43:11 Updated: openssl-0.9.8e-28.el5.sme.i386
Sep 25 14:43:12 Updated: php-common-5.3.3-15.el5.sme.i386
Sep 25 14:43:13 Updated: php-cli-5.3.3-15.el5.sme.i386
Sep 25 14:43:13 Updated: php-pdo-5.3.3-15.el5.sme.i386
Sep 25 14:43:14 Updated: php-5.3.3-15.el5.sme.i386
Sep 25 14:43:15 Updated: php-mbstring-5.3.3-15.el5.sme.i386
Sep 25 14:43:20 Updated: php-devel-5.3.3-15.el5.sme.i386
Sep 25 14:43:21 Updated: php-xml-5.3.3-15.el5.sme.i386
Sep 25 14:43:21 Updated: php-gd-5.3.3-15.el5.sme.i386
Sep 25 14:43:22 Updated: php-imap-5.3.3-15.el5.sme.i386
Sep 25 14:43:22 Updated: php-ldap-5.3.3-15.el5.sme.i386
Sep 25 14:43:24 Updated: nscd-2.5-118.el5_10.3.i386
Sep 25 14:43:29 Updated: 7:squid-2.6.STABLE21-7.el5_10.i386
Sep 25 14:43:29 Updated: php-mysql-5.3.3-15.el5.sme.i386
Sep 25 14:44:00 Installed: kernel-PAE-2.6.18-371.12.1.el5.i686
Sep 25 14:44:00 Updated: procmail-3.22-17.1.2.el5_10.i386
Sep 25 14:44:30 Installed: kernel-2.6.18-371.12.1.el5.i686Then i tried to remove maildrop, always from webpanel, pressing the button "Remove additional software".
After this i tried to re-install mailsorting, cause i thought that it would have installed maildrop, but it did not.
So i open a console session and i wrote:

Code: [Select]

yum install maildrop --enablerepo=smecontribs(after every single operation i gave the

Code: [Select]

signal-event post-upgrade; signal-event restart)
After this i tried to reinstall also userpanel (cause i think that one of these operation could "reset" my server to a functionally state).
The last passage was

Code: [Select]

yum --enablerepo=smecontribs install smeserver-userpanel.
After i used MC and tried to remove my .qmail file and the other files in my folder (because some time ago i solved in this way another problem)...and seems it works, for a little, until .qmail isn't recreated.

[Zen]

Ah, i have also verify the file and folders permissions and seem all ok.

This is my .qmail file:

Code: [Select]

#------------------------------------------------------------
#              !!DO NOT MODIFY THIS FILE!!
#
# Manual changes will be lost when this file is regenerated.
#
# Please read the developer's guide, which is available
# at http://www.contribs.org/development/
#
# Copyright (C) 1999-2006 Mitel Networks Corporation
#------------------------------------------------------------


| condredirect alberto-junkmail headermatch 'X-Spam-Status: Yes'


# Forward not set
# Vacation Message not set
| /usr/bin/maildrop ; if [ $? -ne 0 ] ; then exit -1; else exit 99; fi;
./Maildir/




[Zen]

i verified my other (not updated) server, and my qmail file is different.

Code: [Select]

#------------------------------------------------------------
#              !!DO NOT MODIFY THIS FILE!!
#
# Manual changes will be lost when this file is regenerated.
#
# Please read the developer's guide, which is available
# at http://www.contribs.org/development/
#
# Copyright (C) 1999-2006 Mitel Networks Corporation
#------------------------------------------------------------


| condredirect alberto-junkmail headermatch 'X-Spam-Status: Yes'
# Forward not set
./Maildir/


removed this line

Code: [Select]

| /usr/bin/maildrop ; if [ $? -ne 0 ] ; then exit -1; else exit 99; fi;again seem it works...

(i know isn't the right way to precede, because is "a tentoni" but...now my priority is to solve this problem )

[DanB35]

You may have a custom template fragment doing bad things.  Try this:

# ls -alhF /etc/e-smith/templates-user-custom/.qmail

If anything is in there, what are the contents of those files?

I'm not sure I agree about maildrop not being part of the standard distro--the RPM is part of the ISO.  Don't know if it's installed by default, though it is installed in my SME 8.1 VM, and I don't recall customizing it at all.

[Zen]

Code: [Select]

[root@server ~]# ls -alhF /etc/e-smith/templates-user-custom/.qmail     
ls: /etc/e-smith/templates-user-custom/.qmail: No such file or directory
[root@server ~]#


[DanB35]

OK, how about this:

# grep maildrop /etc/e-smith/templates-user/.qmail/*

[Zen]

Code: [Select]

[root@server users]# grep maildrop /etc/e-smith/templates-user/.qmail/*
/etc/e-smith/templates-user/.qmail/50Filter:      return '| /usr/bin/maildrop ; if [ $? -ne 0 ] ; then exit -1; else exit 99; fi;'
/etc/e-smith/templates-user/.qmail/50Filter:        if ($qmail{FilterType} eq 'maildrop' );
/etc/e-smith/templates-user/.qmail/76Filter:      return '| /usr/bin/maildrop ; if [ $? -ne 0 ] ; then exit -1; else exit 99; fi;'
/etc/e-smith/templates-user/.qmail/76Filter:        if ($qmail{FilterType} eq 'maildrop' );
[root@server users]#

uhm...that line

Code: [Select]

| /usr/bin/maildrop ; if [ $? -ne 0 ] ; then exit -1; else exit 99; fi; is the same that is in "/home/e-smith/files/users/alberto/.qmail" that i don't have in my other clean server.

[DanB35]

# rpm -qf /etc/e-smith/templates-user/.qmail/50Filter

[Zen]

...nothing happened

Code: [Select]

Last login: Thu Sep 25 19:36:17 2014 from pc-00089.domain.it
[root@server ~]#  rpm -qf /etc/e-smith/templates-user/.qmail/50Filter
smeserver-mailsorting-1.2-45.el5.sme
[root@server~]#


[Daniel B.]

This is probably the smeserver-mailsorting contrib. You should open a bug

[DanB35]

No, something did happen; it returned the name of the RPM it belongs to.  As the other Daniel B. said, looks like there could be a bug in that RPM, so open a bug report.  In the meantime, you could remove it.

[Zen]

ok
For now i just commented all the lines

Code: [Select]

| /usr/bin/maildrop ; if [ $? -ne 0 ] ; then exit -1; else exit 99; fi; in my .qmail files (i've about 10 users, not a long operation).
Now i'll try to open a bug report, hope that is not my server a little messed up.

Thanks again for yours support ^_^

[Zen]

http://bugs.contribs.org/show_bug.cgi?id=8572 ^_^

[Stefano]

your solution will work until you'll reconfigure your server..

post the output of

Code: [Select]

/sbin/e-smith/audittools/templates
rpm -qa | grep -i drop

thank you

[CharlieBrady]

Now, moving all this files, I started to receive again but i've lost all the qmail queue.

You made a fundamental mistake. You changed your system without knowing what was wrong with it, and without knowing what you were doing.

The process should be 1) observe 2) diagnose and then 3) correct.

How can i retrieve all those messages?

You can't until you know where they are. And then the answer will be, maybe you can't retrieve them. That's why you should have left them safely in the mail queue until you properly diagnosed your problem.

You should look in your qmail log files and try to determine what happened to those messages when you deleted all the files that you shouldn't have deleted.

[Zen]

your solution will work until you'll reconfigure your server..

post the output of

Code: [Select]

/sbin/e-smith/audittools/templates
rpm -qa | grep -i drop

thank you

Yep, i know...it's temporary until i don't find a better solution, but I needed to solve the problem quickly enough.
The results:

Code: [Select]

login as: root
root@192.168.0.50's password:
Last login: Fri Sep 26 08:15:38 2014 from pc-00089.server.it
[root@server~]# /sbin/e-smith/audittools/templates
/etc/e-smith/templates-custom/var/service/qpsmtpd/config/peers/0/17check_basicheaders: MANUALLY_ADDED, OVERRIDE
/etc/e-smith/templates-custom/var/service/qpsmtpd/config/peers/local/17check_basicheaders: MANUALLY_ADDED, OVERRIDE
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings03Debugger: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings20VerisignPayflowPro: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings04Logging: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/65FopenWrappers: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings08MySQL: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings15Informix: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings10PostgresSQL: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings18Assertion: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/60FileUploads: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings14browscap: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/30ErrorHandling: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings12Sybase-CT: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings11Sybase: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings17MSSQL: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/10LanguageOptions: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings01Syslog: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings02mailfunction: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings09mSQL: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings06SQL: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings07ODBC: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings19IngresII: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/40DataHandling: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/00PHP: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/template-begin: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings21Sockets: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/50PathsDirectories: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/20ResourceLimits: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings13bcmath: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings05Java: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/15ExposePHP: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/etc/php.ini/80ModuleSettings16Session: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/squid/squid.conf/72MaxHeaderSize: OWNED_BY_RPM, ADDITION
/etc/e-smith/templates-custom/etc/squid/squid.conf/75SizeOfCache: OWNED_BY_RPM, ADDITION
/etc/e-smith/templates-custom/etc/squid/squid.conf/70StoreAvgObjectSize: OWNED_BY_RPM, OVERRIDE
[root@server~]# rpm -qa | grep -i drop
maildrop-2.5.0-13.el5
[root@server ~]#


[Zen]

You made a fundamental mistake. You changed your system without knowing what was wrong with it, and without knowing what you were doing.

The process should be 1) observe 2) diagnose and then 3) correct.

I know, i tried but the diagnose process was not so easy. I didn't find any information about my logs.

You can't until you know where they are. And then the answer will be, maybe you can't retrieve them. That's why you should have left them safely in the mail queue until you properly diagnosed your problem.

You should look in your qmail log files and try to determine what happened to those messages when you deleted all the files that you shouldn't have deleted.

When i have moved the files and launched a

Code: [Select]

qmHandle -a, all the queued messages arrived to my users, the qmail log didn't report anything strange, but, after the receipt of the queue, the problem has returned and some new .qmail files were written inside my users folders.
After this i checked what was inside this file and I found a line i don't have in my clean sme.

At the end i restored the previous files, that ones i had moved, and I have commented the line i wrote some message ago. In my qmail log, after the "solution" all seemed to work well, i didn't see any particular message.

Not a good solution but never had some big mistake with emails, just with RBL list or other lists, nothing serious.
Until the server is running, I can prepare another virtual machine with a new clean installation, restore my affa backup and do some tests on it.

[CharlieBrady]

Your problems will be solved by doing:

rpm -e smeserver-mailsorting
signal-event post-upgrade
signal-event reboot

[Zen]

Code: [Select]

[root@server~]# rpm -e smeserver-mailsorting

##################################
to disable procmail or maildrop
config delprop qmail FilterType
signal-event email-update
##################################

[root@server ~]#

i have to delete also the filter type?

Code: [Select]

[root@server~]# config show qmail FilterType
qmail=service
    FilterType=maildrop
    MaxMessageSize=30000000
    VacationDelay=-t1d
    status=enabled
[root@server~]#


[stephdl]

Not sure that is related but do you have a rule that can break the mailsorting contribs ?

See http://wiki.contribs.org/Mailsorting#Create_Rules

[CharlieBrady]

Not sure that is related but do you have a rule that can break the mailsorting contribs ?

stephdl, please ask that question via bugzilla. Bug 8572.

[CharlieBrady]

Code: [Select]

[root@server~]# rpm -e smeserver-mailsorting

##################################
to disable procmail or maildrop
config delprop qmail FilterType
signal-event email-update
##################################

[root@server ~]#

i have to delete also the filter type?

That's a badly designed contrib - it shouldn't be asking those questions - it should "just work".

I don't think you need to delete the FilterType property. But there should be no problem if you do remove it, and it is easy to do.

The FilterType property isn't used anywhere in base SME server templates.

-bash-3.00$ pwd
/etc/e-smith
-bash-3.00$ grep -r FilterType *templates*
-bash-3.00$