OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Subject: Mysql And Virtual
From: John Goodens (bseglobal.co.za)
Date: Thu Nov 02 2000 - 16:37:56 CST

Hello.

What must the query look like in mysql-virtual.cf for Virtual email?
What about implementing the below? Must each row just become a record in the
table?
what about the first line below? bit different from all the others.

Currently my virtual file looks like:
----------------------------------
mycom.com Accept mail for this domain
user1mycom.com user1
user2mycom.com user2
----------------------------------

I assume the following in my main.cf
-------------
virtual_maps = mysql:/etc/postfix/virtual-mysql.cf
-------------

and the following in virtual-mysql.cf
-------------
user= postfix
password = postfix22
db_name = postfix
table = virtual
hosts = localhost
-------------

My Mysql create table looks like:
-------------
create table virtual ( userid int AUTO_INCREMENT primary key,
   mailbox varchar(40),
   email varchar(40));
create unique index mbox_email_idx on virtual (mailbox, email);

-------------

Thanks!