Re: courier+mysql
<radek@gate3.p-x.pl> writes:
> zahaszowalem wiec uid i gid w authmysqlrc zrestartowalem CALY server i
> w logach nadal mam query z uid i gid i oczywiscie poczty nie wydaje :(
> jak poprawic zapytanie do bazy ??
Rozwiazania sa co najmniej dwa:
1. W authmysqlrc mozesz skorzystac z MYSQL_SELECT_CLAUSE, np.:
MYSQL_SELECT_CLAUSE \
SELECT EmailAddress, "", Password, "", "", \
'/var/spool/postfix/virtual', MailDirLocation, \
Quota, FullName, "" \
FROM Mailbox \
WHERE EmailAddress = "'$(local_part)'@'$(domain)'"
2. Do tabeli Mailbox mozesz dodac brakujace kolumny, np.:
ALTER TABLE Mailbox ADD COLUMN uid SMALLINT UNSIGNED NOT NULL \
DEFAULT '12345' AFTER Password;
ALTER TABLE Mailbox ADD COLUMN gid SMALLINT UNSIGNED NOT NULL \
DEFAULT '54321' AFTER uid;
Wybor nalezy do Ciebie!
P.
Reply to: