Link to home
Start Free TrialLog in
Avatar of mshaikh22
mshaikh22

asked on

Postfix Access table issue, New account emails are not being recorded in the acccess table running Exchange 2003

Dear Experts,

Over past two weeks, new email address are not being recorded in the access.db. I am running exchange 2003 enterprise and running postfix as mail relay and normally when we create new email account, the email address gets recorded in postfix access table which enables it to relay emails externally and receive emails from external users.

but if I email that account from my gmail account, the email gets bounced back stating rejected.

Can you please let me know, when can we do to resolve this. There was some kind of tool that runs on exchange that scans ad for new emails and updates  postfix, not sure but that not running anymore.

Please help, experts.

SOLUTION
Avatar of svgmuc
svgmuc
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mshaikh22
mshaikh22

ASKER

i run that command manually postmap access
its still doesnt do anything
the email address dont exist in the access table
tried adding them manually by doing nano access.db
entered the email address manually and save the access.db file restarted postfix.

Worked a few times and after that stopped working
looks the email addresses i put disppear afterward now it doesnt save at all.
Hello Experts,


Just wanted to see if anyone has experience this issue before caz im still wondering how to solve this riddle.
Please let me know as soon as you can,

Need help with this. I keep manually entering email address in the access.db table. But it disappears after a few days
Can you please tell why do the email address that I enter in the database access.db disappear.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you for that svgmuc. Could you please tell me know where can i look for the cron jobs.
Am I suppose to enter email address manually in the access.db or does the cron job run and does update the emails for me.

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
this is what i see


0 0,6,12,18,21 * * *       /usr/bin/freshclam
0 0 * * *       /usr/bin/sa-update
0,10,30,50 * * * * /usr/local/bin/exchange-email-push
0 23 * * * find /home/quarantine/ -mtime +10 -exec rm -f {} \;
0,10,30,50 * * * * /usr/local/bin/exchange-email-push

how does this work

exchange-email-push
Connected to ex0svr
220 Microsoft FTP Service
500 'AUTH GSSAPI': command not understood
500 'AUTH KERBEROS_V4': command not understood
KERBEROS_V4 rejected as an authentication type
331 Anonymous access allowed, send identity (e-mail name) as password.
230 Anonymous user logged in.
Local directory now /etc/postfix
local: public.emails remote: public.emails
227 Entering Passive Mode (10,168,1,35,134,203).
125 Data connection already open; Transfer starting.
226 Transfer complete.
313123 bytes received in 0.016 seconds (2e+04 Kbytes/s)
local: users.emails remote: users.emails
227 Entering Passive Mode (10,168,1,35,134,206).
125 Data connection already open; Transfer starting.
226 Transfer complete.
334851 bytes received in 0.018 seconds (1.9e+04 Kbytes/s)
221
can i get some help on this please.
help please

0,10,30,50 * * * * /usr/local/bin/exchange-email-push

how does this work

exchange-email-push
Connected to ex0svr
220 Microsoft FTP Service
500 'AUTH GSSAPI': command not understood
500 'AUTH KERBEROS_V4': command not understood
KERBEROS_V4 rejected as an authentication type
331 Anonymous access allowed, send identity (e-mail name) as password.
230 Anonymous user logged in.
Local directory now /etc/postfix
local: public.emails remote: public.emails
227 Entering Passive Mode (10,168,1,35,134,203).
125 Data connection already open; Transfer starting.
226 Transfer complete.
313123 bytes received in 0.016 seconds (2e+04 Kbytes/s)
local: users.emails remote: users.emails
227 Entering Passive Mode (10,168,1,35,134,206).
125 Data connection already open; Transfer starting.
226 Transfer complete.
334851 bytes received in 0.018 seconds (1.9e+04 Kbytes/s)
221
This is just the output of a script.
According to the crontab line, it is run at the full hour, at 10min after the full hour, at 30min after the full hour and 10min to the full hour. (Strange schedule)

It transfers 2 files via FTP, public.emails and users.emails from the server to the postfix server.

I cannot see any other information from this output.
Apologies for getting back you  on this.

Could you please help me with this, im thinking whenever this script runs it remove the manually entered email address in access db. Now there something missing in exhcange that prevents the script from running. What could that be.

thank you./


This is the is the script

#!/bin/bash

EXCHANGE=exchange2003
USER=anonymous
NACCESS=access.new
TMP=access.tmp

ftp -v -n "$EXCHANGE" << EOF
user "$USER" sysadmin
lcd /etc/postfix/
get public.emails
get users.emails
quit
EOF
if [ "$?" -ne 0 ]; then
        echo "FTP Exchange push failed to grab new files"
        exit 1
fi


cd /etc/postfix/
# make a copy of the current
cp -f access access.old
cat access.header > "$NACCESS"
cat /dev/null > "$TMP"
/bin/egrep -o '(smtp|SMTP):(.*)' users.emails | sed 's/^smtp://' | sed 's/^SMTP://' | awk '{ print $0"\tOK"; }' >> "$TMP"
/bin/egrep -o '(smtp|SMTP):(.*)' public.emails | sed 's/^smtp://' | sed 's/^SMTP://' | awk '{ print $0"\tOK"; }' >> "$TMP"
sort -u "$TMP" >> "$NACCESS"
mv "$NACCESS" access

#--- update the system
postmap /etc/postfix/access
postfix reload

ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Good troubleshooting steps