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:	About creating database
Group:	Postfix-users
From:	Stephen Liu
Date:	14 Jun 2007

Hi folks,

OpenBSD 4.0 x86_64
Postfix-2.4.3
Mysql
($ mysql --version
mysql Ver 14.12 Distrib 5.0.24a, for unknown-openbsd4.0 (x86_64) using
readline 4.3)

According to;

http://www.postfixvirtual.net/postfixconf.html#postfix

I issued following SQL commands to create a database named "mail" and a
user "vmailuser" with password "password123"

$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.24a-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE DATABASE mail;
Query OK, 1 row affected (0.03 sec)

mysql> GRANT all privileges on mail.* TO vmailuser@localhost IDENTIFIED
BY 'pass
word123' ;
Query OK, 0 rows affected (0.03 sec)

mysql> GRANT all privileges on mail.* TO vmailuser IDENTIFIED
BY 'pass
word123' ;
Query OK, 0 rows affected (0.00 sec)

mysql> use mail;
Database changed
mysql> show tables;
Empty set (0.03 sec)

mysql> \q
Bye
* end *

No complaint indicated.

Coming to "Create SQL FILE", on which directory shall I create the file
"postfix_virtual.sql" so that it can be evoked on running;

# mysql -u root -p < postfix_virtual.sql

What shall be its owner and permission ???

I'll copy the script there on the file. UID and GIU are 2007.

Please advise. TIA

What other attention I have to pay ???

B.R.
Stephen Liu

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