Dotaz: Postfix + virtual + domenovy kos

[mira]

Dobry den,
mam postfix s ucty v mysql a mam takovy dotaz. Mam tabulky virtual a user (+ dalsi), v tabulce user jsou dva uzivatele user1@domena.tld a user2@domena.tld. Chci pro zbytek domeny udelat domenovy kos, ktery bude chodit treba na user1, takze do tabulky virtual zadam email: @domena.tld a destination user1@domena.tld.
To sice funguje, ale posila to vsechny emaily na user1 i ty, co jsou posilany na user2. Da se to vyresit tim, ze do virtualu pridam email: user2@domena.tld a destination user2@domena.tld.
Koukal sem do logu mysql a postfix v tabulce user jediny co hledal bylo to kde email='domena.tld' (tomu nerozumim, ale budiz).

Takze otazka: je potreba vytvaret zaznam jak v user tabulce tak i v tabulce virtual (pokud je pro zbytek domeny nastaven domenovy kos)?

Odpovědi

[jm]

Takze otazka: je potreba vytvaret zaznam jak v user tabulce tak i v tabulce virtual (pokud je pro zbytek domeny nastaven domenovy kos)?

Ano.

[mira]

Dik, to bylo rychly.
Ale kdyz uz sme u toho, tak proc postfix hleda v tabulce user to, kde email='domena.tld' a ne email='user2@domena.tld'???

[jm]

To opravdu nevim, muzu maximalne tak uvest, jak to vypada u me

# mysql-users.cf
user            = user
password        = password
dbname          = mail
table           = users
select_field    = maildir
where_field     = email
additional_conditions = and postfix = 'y'
hosts           = unix:/var/run/mysqld/mysqld.sock

# mysql-virtual.cf
user            = user
password        = password
dbname          = mail
table           = virtual
select_field    = destination
where_field     = email
hosts           = unix:/var/run/mysqld/mysqld.sock

#database dump
--
-- Table structure for table `users`
--

CREATE TABLE users (
  id int(11) NOT NULL auto_increment,
  email varchar(128) NOT NULL default '',
  crypt varchar(128) NOT NULL default '',
  name tinytext NOT NULL,
  uid int(11) NOT NULL default '1000',
  gid int(11) NOT NULL default '1000',
  homedir tinytext NOT NULL,
  maildir tinytext NOT NULL,
  quota tinytext NOT NULL,
  postfix enum('n','y') NOT NULL default 'y',
  PRIMARY KEY  (id),
  UNIQUE KEY email (email)
) TYPE=InnoDB;

--
-- Table structure for table `virtual`
--

CREATE TABLE virtual (
  id int(11) NOT NULL auto_increment,
  email varchar(128) NOT NULL default '',
  destination varchar(128) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=InnoDB;

[mira]

To mam hodne podobne a asi nebudu daleko od pravdy, kdyz reknu, ze je nas na internetu urcite vic.
Slo mi jen o princip, ale neni to dulezite.