Re: About creating database

2 msg	postfix + gmail + multiusers
2 msg	strange question regarding lmtp
3 msg	Updated amavisd-new; can't send/receive mail
8 msg	RPM 'n stuff
7 msg	DSN setup
4 msg	Local Users on Virtual Domains?
5 msg	postfix + courier + active directory 2003
12 msg	Fail to test postfix
2 msg	Global groups

About creating database
\ Stephen Liu (14 Jun 2007)
. \ Mark Watts (14 Jun 2007)
. . \ Stephen Liu (14 Jun 2007)
. \ Mark Watts (14 Jun 2007)
. . \ Stephen Liu (14 Jun 2007)
. \ mouss (14 Jun 2007)
. . \ Stephen Liu (14 Jun 2007)

3 msg	Misunderstanding of transport map format VS mas...
2 msg	Problems Backscatter
5 msg	question about receive_override_options
4 msg	specific whitelisting
3 msg	Real unknown host ???
2 msg	Another question about logs...
4 msg	fallback_relay not getting used
3 msg	Maildir
6 msg	Outgoing Mail Copy
1 msg	Close to getting SASL and SMTP AUTH on OS X wor...

Subject:	Re: About creating database
Group:	Postfix-users
From:	Stephen Liu
Date:	14 Jun 2007

Hi mouss,

Tks for your advice.

> > mysql> GRANT all privileges on mail.* TO vmailuser@localhost
> IDENTIFIED
> > BY 'pass
> > word123' ;
> >
>
> I hope there is no line break inside the password and that this is
> just
> your mailer...

No line break, one line only.

> there's a bug on the page: no database specified (see Mark's post).
>
> Use this instead:
> # mysql -u vmail -p"password123" mail < postfix_virtual.sql.

Noted with tks.

> since you gave vmailuser all privileges (if not, use root here. but
> you
> need to a specify the db).

Could you please explain in more detail ??? Tks.

> > What shall be its owner and permission ???
> >
>
> postfix doesn't care since it does not use this. note that postfix
> doesn't need "ALL PRIVILEGES" since it only reads from the db.
>
> anyway, this file is used only once to create the tables. so nobody
> cares to whom it belongs...

Noted with tks.

> > I'll copy the script there on the file. UID and GIU are 2007.
> >
> >
> > Please advise. TIA
> >
> > What other attention I have to pay ???
> >
>
> I see some bad advice in the howto... for example:
>
> - why change maildrop flags? This is bad advice.
>
> - I find it horrible to store mail under /usr/local.
>
> - what is smtpd_sasl2_auth_enable?
>
> - check_recipient_access mysql:/etc/postfix/mysql-recipient.cf is not
>
> only useless (reject_unlisted_recipient is the right check here), it
> is
> dangerous (an error in the table and you're an open relay).
>
> you may contact the author...

Noted.

B.R.
Stephen

Send instant messages to your online friends http://uk.messenger.yahoo.com