|
List Info
Thread: Receiving mail
|
|
| Receiving mail |
|
2006-03-10 18:03:11 |
> I made that change and this is the error message i get,
>
> server localhost: Can't connect to local MySQL server
through socket
> '/var/lib/mysql/mysql.sock' (2)
>
> This is my dbmail.conf,
>
>
> [DBMAIL]
> # Database settings
> # host for database, set to localhost if database is om
> # the same host as dbmail and you want to use a local
socket
> # for connecting.
> host=localhost
>
> # if you want to use TCP/IP for connecting to the
database,
> sqlport=3306
>
> # and have the database running on a non-standard port.
> # when using a local socket connection to the database,
fill
> # in the path to the socket here (e.g.
/var/run/mysql.sock)
> #sqlsocket=/var/lib/mysql/mysql.sock
> sqlsocket=/tmp/mysql.sock
>
> I had to uninstall MySQL 5.0.18 and re-install 4.1.16
and now mysock is in
> tmp. Why can't dbmail.conf find it?
>
> Jim
This isn't dbmail complaining it can't find the .sock
file, it's Postfix.
Configure that, and you'll be okay.
-Micah
_______________________________________________
Dbmail mailing list
Dbmail dbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|
|
| Receiving mail |
|
2006-03-10 20:40:42 |
>From: Micah Stevens <micah9250x.com>
>Reply-To: DBMail mailinglist <dbmaildbmail.org>
>To: DBMail mailinglist <dbmaildbmail.org>
>Subject: Re: [Dbmail] Receiving mail
>Date: Fri, 10 Mar 2006 10:03:11 -0800
>
> > I made that change and this is the error message i
get,
> >
> > server localhost: Can't connect to local MySQL
server through socket
> > '/var/lib/mysql/mysql.sock' (2)
> >
> > This is my dbmail.conf,
> >
> >
> > [DBMAIL]
> > # Database settings
> > # host for database, set to localhost if database
is om
> > # the same host as dbmail and you want to use a
local socket
> > # for connecting.
> > host=localhost
> >
> > # if you want to use TCP/IP for connecting to the
database,
> > sqlport=3306
> >
> > # and have the database running on a non-standard
port.
> > # when using a local socket connection to the
database, fill
> > # in the path to the socket here (e.g.
/var/run/mysql.sock)
> > #sqlsocket=/var/lib/mysql/mysql.sock
> > sqlsocket=/tmp/mysql.sock
> >
> > I had to uninstall MySQL 5.0.18 and re-install
4.1.16 and now mysock is
>in
> > tmp. Why can't dbmail.conf find it?
> >
> > Jim
>
>This isn't dbmail complaining it can't find the .sock
file, it's Postfix.
>Configure that, and you'll be okay.
>
>-Micah
>_______________________________________________
>Dbmail mailing list
>Dbmaildbmail.org
>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
Which postfix file, it's not master, main...I think I
opened all of them..
Thanks,
Jim
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|
|
| Receiving mail |
|
2006-03-10 21:58:22 |
On Friday 10 March 2006 12:40 pm, Jim Douglas wrote:
> >This isn't dbmail complaining it can't find the
.sock file, it's Postfix.
> >Configure that, and you'll be okay.
> >
> >-Micah
> >_______________________________________________
> >Dbmail mailing list
> >Dbmaildbmail.org
> >htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
> Which postfix file, it's not master, main...I think I
opened all of them..
>
> Thanks,
> Jim
It's in the .cf file that's reference in main.cf.. for
example if you are
using this:
local_recipient_maps = mysql_local_recipient_maps.cf
look in the mysql_local_recipient_maps.cf. Inside will be
the user/pw info as
well as a hosts = line. This is how you specify the sock
file, or a
127.0.0.1 to force TCP/IP.
-Micah
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|
|
| Receiving mail |
|
2006-03-10 22:29:49 |
>From: Micah Stevens <micah9250x.com>
>Reply-To: DBMail mailinglist <dbmaildbmail.org>
>To: DBMail mailinglist <dbmaildbmail.org>
>Subject: Re: [Dbmail] Receiving mail
>Date: Fri, 10 Mar 2006 13:58:22 -0800
>
>On Friday 10 March 2006 12:40 pm, Jim Douglas wrote:
> > >This isn't dbmail complaining it can't find
the .sock file, it's
>Postfix.
> > >Configure that, and you'll be okay.
> > >
> > >-Micah
> >
>_______________________________________________
> > >Dbmail mailing list
> > >Dbmaildbmail.org
> > >htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> > Which postfix file, it's not master, main...I
think I opened all of
>them..
> >
> > Thanks,
> > Jim
>
>It's in the .cf file that's reference in main.cf.. for
example if you are
>using this:
>
>local_recipient_maps = mysql_local_recipient_maps.cf
>
>look in the mysql_local_recipient_maps.cf. Inside will
be the user/pw info
>as
>well as a hosts = line. This is how you specify the
sock file, or a
>127.0.0.1 to force TCP/IP.
>
>-Micah
>_______________________________________________
>Dbmail mailing list
>Dbmaildbmail.org
>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
The sock problem is solved, now this fro mthe error log,
Mar 10 17:18:09 cpe-66-65-161-178 postfix/smtpd[9236]:
NOQUEUE: reject: RCPT
from web42207.mail.yahoo.com[66.218.93.208]: 550
<oursxyxyxy.org>:
Recipient address rejected: User unknown in local recipient
table;
from=<pxyahoo.com> to=<oursxyxyxy.org>..
I added added xyxyxy.org to mydestination for dbmail and
postfix is not
connecting to the database.
This is what I have for dbmail,
mailbox_transport = dbmail-lmtp:localhost:25
local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf
When I change local_recipient_maps to,
local_recipient_maps =
I get this error,
Mar 10 17:23:19 cpe-66-65-161-178 postfix/lmtp[9323]:
3E0FF4D1BA5:
to=<oursxyxyxy.org>,
relay=localhost.phil.rr.com[127.0.0.1], delay=0,
status=bounced (host localhost.phil.rr.com[127.0.0.1]
refused to talk to me:
502 Error: command not implemented)
Jim
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|
|
| Receiving mail |
|
2006-03-10 22:37:12 |
On Friday 10 March 2006 2:29 pm, Jim Douglas wrote:
> Mar 10 17:18:09 cpe-66-65-161-178 postfix/smtpd[9236]:
NOQUEUE: reject:
> RCPT from web42207.mail.yahoo.com[66.218.93.208]: 550
<oursxyxyxy.org>:
> Recipient address rejected: User unknown in local
recipient table;
> from=<pxyahoo.com> to=<oursxyxyxy.org>..
>
> I added added xyxyxy.org to mydestination for dbmail
and postfix is not
> connecting to the database.
This means exactly what it says, user was not found in the
local recipient
table, it has nothing to do with mydestination.
-Micah
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|
|
| Receiving mail |
|
2006-03-11 03:46:06 |
>From: Micah Stevens <micah9250x.com>
>Reply-To: DBMail mailinglist <dbmaildbmail.org>
>To: DBMail mailinglist <dbmaildbmail.org>
>Subject: Re: [Dbmail] Receiving mail
>Date: Fri, 10 Mar 2006 14:37:12 -0800
>
>On Friday 10 March 2006 2:29 pm, Jim Douglas wrote:
> > Mar 10 17:18:09 cpe-66-65-161-178
postfix/smtpd[9236]: NOQUEUE: reject:
> > RCPT from web42207.mail.yahoo.com[66.218.93.208]:
550 <oursxyxyxy.org>:
> > Recipient address rejected: User unknown in local
recipient table;
> > from=<pxyahoo.com> to=<oursxyxyxy.org>..
> >
> > I added added xyxyxy.org to mydestination for
dbmail and postfix is not
> > connecting to the database.
>
>This means exactly what it says, user was not found in
the local recipient
>table, it has nothing to do with mydestination.
>
>-Micah
>_______________________________________________
>Dbmail mailing list
>Dbmaildbmail.org
>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
I tried quite a few configuration changes before
backtracking and finding
that the dbmail-users command had a problem....
User unknown in local recipient table; from=<pwyahoo.com>
to=<osxyxyxy.org> proto=SMTP
helo=<web42202.mail.yahoo.com>
Mar 10 22:39:21 cpe-66-65-161-178 postfix/smtpd[8103]:
disconnect from
web42202.mail.yahoo.com[66.218.93.203]
Mar 10 22:39:36 cpe-66-65-161-178 dbmail/adduser[8109]:
dbmysql.c,db_connect: mysql_real_connect failed: Access
denied for user
'root''localhost' (using password: NO)
this was the command,
dbmail-users -a jim -w password -g 0 -m 25M -s jimxyxyxy.org
Why does it say access denied for 'root' when the adduser
command is adding
a user 'jim'?
I also re-created the MySql tables...
Peter
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|
|
| Receiving mail |
|
2006-03-11 13:35:00 |
Peter,
Try things one step at a time.
If dbmail-users complains about connecting to mysql,
there's NO way you
should even think about postfix yet.
'dbmail-users -l' should not complain, period. If it does,
your
dbmail.conf is not correct.
It sounds to me like you're new to mysql, new to postfix,
and new to
dbmail, and confusing issues to boot.
1) add a user 'dbmail' to mysql which has full permissions
on the dbmail
database. Something like 'GRANT ALL ON dbmail.* TO
dbmaillocalhost
IDENTIFIED BY 'somepassword'.
2) Make sure you can connect to the dbmail database in mysql
using that
user/password combo: mysql -u dbmail -psomepassword dbmail
3) edit dbmail.conf to make sure the user=, pass=, and db=
settings are
correct.
4) do 'dbmail-users -l'. If that doesn't work go back to
3)
5) add a dbmail user by running dbmail-users -a testuser -w
testpassword
6) try inserting a simple message into the INBOX of that
user:
cat >> testmessage.eml << EOF
From: somebodynowhere.org
To: testuserlocalhost
Subject: test
test
EOF
cat testmessage.eml | dbmail-smtp -u testuser
check the database make sure the message is there in the
dbmail_messageblks table
Once you make sure all this works as expected, move forward
to setting
up some real dbmail users with email aliases, and try to
hook up your
MTA (postfix).
If you do suspect there's a problem with dbmail, try
setting the
TRACE_LEVEL to 5, and start eyeballing the syslog.
Jim Douglas wrote:
>> From: Micah Stevens <micah9250x.com>
>> Reply-To: DBMail mailinglist <dbmaildbmail.org>
>> To: DBMail mailinglist <dbmaildbmail.org>
>> Subject: Re: [Dbmail] Receiving mail
>> Date: Fri, 10 Mar 2006 14:37:12 -0800
>>
>> On Friday 10 March 2006 2:29 pm, Jim Douglas wrote:
>> > Mar 10 17:18:09 cpe-66-65-161-178
postfix/smtpd[9236]: NOQUEUE: reject:
>> > RCPT from
web42207.mail.yahoo.com[66.218.93.208]: 550
>> <oursxyxyxy.org>:
>> > Recipient address rejected: User unknown in
local recipient table;
>> > from=<pxyahoo.com>
to=<oursxyxyxy.org>..
>> >
>> > I added added xyxyxy.org to mydestination for
dbmail and postfix is not
>> > connecting to the database.
>>
>> This means exactly what it says, user was not found
in the local
>> recipient
>> table, it has nothing to do with mydestination.
>>
>> -Micah
>> _______________________________________________
>> Dbmail mailing list
>> Dbmaildbmail.org
>> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>
> I tried quite a few configuration changes before
backtracking and
> finding that the dbmail-users command had a problem....
>
> User unknown in local recipient table; from=<pwyahoo.com>
> to=<osxyxyxy.org> proto=SMTP
helo=<web42202.mail.yahoo.com>
> Mar 10 22:39:21 cpe-66-65-161-178 postfix/smtpd[8103]:
disconnect from
> web42202.mail.yahoo.com[66.218.93.203]
> Mar 10 22:39:36 cpe-66-65-161-178 dbmail/adduser[8109]:
> dbmysql.c,db_connect: mysql_real_connect failed: Access
denied for user
> 'root''localhost' (using password: NO)
>
>
> this was the command,
> dbmail-users -a jim -w password -g 0 -m 25M -s jimxyxyxy.org
> Why does it say access denied for 'root' when the
adduser command is
> adding a user 'jim'?
>
> I also re-created the MySql tables...
>
> Peter
>
>
> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
--
____________________________________________________________
____
Paul Stevens paul at
nfg.nl
NET FACILITIES GROUP GPG/PGP:
1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|
|
| Receiving mail |
|
2006-03-11 18:04:56 |
>From: Paul J Stevens <paulnfg.nl>
>Reply-To: DBMail mailinglist <dbmaildbmail.org>
>To: DBMail mailinglist <dbmaildbmail.org>
>Subject: Re: [Dbmail] Receiving mail
>Date: Sat, 11 Mar 2006 14:35:00 +0100
>
>,
>
>Try things one step at a time.
>
>If dbmail-users complains about connecting to mysql,
there's NO way you
>should even think about postfix yet.
>
>'dbmail-users -l' should not complain, period. If it
does, your
>dbmail.conf is not correct.
>
>It sounds to me like you're new to mysql, new to
postfix, and new to
>dbmail, and confusing issues to boot.
>
>1) add a user 'dbmail' to mysql which has full
permissions on the dbmail
>database. Something like 'GRANT ALL ON dbmail.* TO
dbmaillocalhost
>IDENTIFIED BY 'somepassword'.
>
>2) Make sure you can connect to the dbmail database in
mysql using that
>user/password combo: mysql -u dbmail -psomepassword
dbmail
>
>3) edit dbmail.conf to make sure the user=, pass=, and
db= settings are
>correct.
>
>4) do 'dbmail-users -l'. If that doesn't work go back
to 3)
>
>5) add a dbmail user by running dbmail-users -a testuser
-w testpassword
>
>6) try inserting a simple message into the INBOX of that
user:
>cat >> testmessage.eml << EOF
>From: somebodynowhere.org
>To: testuserlocalhost
>Subject: test
>
>test
>EOF
>cat testmessage.eml | dbmail-smtp -u testuser
>
>check the database make sure the message is there in the
>dbmail_messageblks table
>
>
>Once you make sure all this works as expected, move
forward to setting
>up some real dbmail users with email aliases, and try to
hook up your
>MTA (postfix).
>
>If you do suspect there's a problem with dbmail, try
setting the
>TRACE_LEVEL to 5, and start eyeballing the syslog.
>
>
>
>Jim Douglas wrote:
> >> From: Micah Stevens <micah9250x.com>
> >> Reply-To: DBMail mailinglist <dbmaildbmail.org>
> >> To: DBMail mailinglist <dbmaildbmail.org>
> >> Subject: Re: [Dbmail] Receiving mail
> >> Date: Fri, 10 Mar 2006 14:37:12 -0800
> >>
> >> On Friday 10 March 2006 2:29 pm, Jim Douglas
wrote:
> >> > Mar 10 17:18:09 cpe-66-65-161-178
postfix/smtpd[9236]: NOQUEUE:
>reject:
> >> > RCPT from
web42207.mail.yahoo.com[66.218.93.208]: 550
> >> <oursxyxyxy.org>:
> >> > Recipient address rejected: User unknown
in local recipient table;
> >> > from=<pxyahoo.com>
to=<oursxyxyxy.org>..
> >> >
> >> > I added added xyxyxy.org to mydestination
for dbmail and postfix is
>not
> >> > connecting to the database.
> >>
> >> This means exactly what it says, user was not
found in the local
> >> recipient
> >> table, it has nothing to do with
mydestination.
> >>
> >> -Micah
> >>
_______________________________________________
> >> Dbmail mailing list
> >> Dbmaildbmail.org
> >> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> >
> > I tried quite a few configuration changes before
backtracking and
> > finding that the dbmail-users command had a
problem....
> >
> > User unknown in local recipient table;
from=<pwyahoo.com>
> > to=<osxyxyxy.org> proto=SMTP
helo=<web42202.mail.yahoo.com>
> > Mar 10 22:39:21 cpe-66-65-161-178
postfix/smtpd[8103]: disconnect from
> > web42202.mail.yahoo.com[66.218.93.203]
> > Mar 10 22:39:36 cpe-66-65-161-178
dbmail/adduser[8109]:
> > dbmysql.c,db_connect: mysql_real_connect failed:
Access denied for user
> > 'root''localhost' (using password: NO)
> >
> >
> > this was the command,
> > dbmail-users -a jim -w password -g 0 -m 25M -s
jimxyxyxy.org
> > Why does it say access denied for 'root' when
the adduser command is
> > adding a user 'jim'?
> >
> > I also re-created the MySql tables...
> >
> > Peter
> >
> >
> > _______________________________________________
> > Dbmail mailing list
> > Dbmaildbmail.org
> > htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
>
>
>--
>
____________________________________________________________
____
> Paul Stevens
paul at nfg.nl
> NET FACILITIES GROUP GPG/PGP:
1024D/11F8CD31
> The Netherlands________________________________http://www.nfg.nl
>_______________________________________________
>Dbmail mailing list
>Dbmaildbmail.org
>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
When I login to mysql with
mysql -u dbmail -p
it prompts for a password, I enter it and can connect. No
problem.
When I try to connect with,
dbmail-users -l
I get
Opening connection to database...
Failed. Could not connect to database (check log)
Command Failed.
This is my dbmail.conf, I know the socket, username,
password, database are
correct...
Thanks for your help..
# $Id: dbmail.conf 1539 2004-12-27 21:41:07Z paul $
# (c) 2000-2002 IC&S, The Netherlands
#
# Configuration file for DBMAIL
# This configuration file needs to be run through
dbmail-config to be
effective
# after that, changes are effective inmediatly
[DBMAIL]
# Database settings
host=localhost # host for database, set to
localhost if database is
om
# the same host as dbmail and you
want to use a
local socket
# for connecting.
sqlport=3306 # if you want to use TCP/IP for
connecting to the
database,
# and have the database running on a
non-standard
port.
# when using a local socket
connection to the
database, fill
# in the path to the socket here
(e.g.
/var/run/mysql.sock)
sqlsocket=/var/lib/mysql/mysql.sock
user=dbmail # user to connect as to database
pass=mypassword # password for user to database
db=dbmail # name of database
# postmaster's email address.
POSTMASTER=p1yoo.com
# trace level for dbmail-util
TRACE_LEVEL=2
[SMTP]
SENDMAIL=/usr/sbin/sendmail # sendmail executable for
forwarding mail
AUTO_NOTIFY=no
AUTO_REPLY=no
TRACE_LEVEL=2
[LMTP]
# the user that dbmail-lmtpd will run as (need to be root to
bind to a
port<1024)
EFFECTIVE_USER=root
# the group that dbmail-lmtpd will run as
EFFECTIVE_GROUP=dbmail
BINDIP=* # the ipaddress the dbmail-lmtpd server has to
bind
# to, * for all adresses. Use 127.0.0.1 to only
# bind to localhost.
PORT=24 # the port number the dbmail-lmtpd server has
to bind to.
NCHILDREN=20 # default number of LMTP handlers (each is
a process)
MAXCHILDREN=10 # max. number of LMTP handlers
MINSPARECHILDREN=2
MAXSPARECHILDREN=4
MAXCONNECTS=10000 # the maximum number of connections a
default childs
makes
TIMEOUT=300 # the time (s) before the dbmail-lmtpd
should shutdown a
connection which is being idle.
RESOLVE_IP=yes # if yes, the lmtp daemon
resolves IP
numbers to DNS names in the log
TRACE_LEVEL=2
MAX_ERRORS=500
[POP]
EFFECTIVE_USER=nobody # the user that dbmail-pop3d will
run as (need to
be root to bind to a port<1024)
EFFECTIVE_GROUP=nogroup # the group that
dbmail-pop3d will run as
BINDIP=* # the ipaddress the dbmail-pop3d server has to
bind to, * for
all addresses
PORT=110 # the port number the dbmail-pop3d server has
to bind to.
NCHILDREN=50 # default number of POP3 handlers (each is
a process)
MAXCHILDREN=200 # mac. number of POP3 handlers
MINSPARECHILDREN=2
MAXSPARECHILDREN=4
MAXCONNECTS=10000 # the maximum number of connections a
default childs
makes
TIMEOUT=300 # the time (s) before the dbmail-pop3d
should shutdown a
connection which is being idle.
RESOLVE_IP=yes # if yes, the pop daemon
resolves IP
numbers to DNS names in the log
POP_BEFORE_SMTP=no
TRACE_LEVEL=2
[IMAP]
EFFECTIVE_USER=nobody
EFFECTIVE_GROUP=nogroup
BINDIP=*
PORT=143
NCHILDREN=50
MAXCHILDREN=200 # mac. number of IMAPD handlers
MINSPARECHILDREN=2
MAXSPARECHILDREN=4
MAXCONNECTS=10000 # the maximum number of connections a
default childs
makes
TIMEOUT=4000 # the time (s) before the dbmail-imapd
should shutdown a
connection which is being idle.
RESOLVE_IP=yes # if yes, the imap daemon
resolves IP
numbers to DNS names in the log
IMAP_BEFORE_SMTP=no
TRACE_LEVEL=2
# end of configuration file
Opening connection to database...
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|
|
[1-8]
|
|