hello
I install mysql + rouncube postfixadmin and I wish I could use the vacation plugin. but unable to connect.
error message:
Vacation plugin: query postfix.vacation it failed. Check and verify DSN That SELECT privileges on postfix.vacation are Granted to user 'postfix'.
Error message: MDB2 Error: no such table
Please read the INSTALL instructions!
my config.ini
[default]
driver = "virtual"
defaultsubject = "about me"
defaultbody = "default.txt"
dsn = "mysql: / / localhost *****:******/ postfix"
# dsn = "mysqli: / / localhost *****:******/ roundbase"
transport = "autoreply.charbon.re"
dbase = "postfix"
# dbase = "roundbase"
always_keep_copy = true
select_query = "SELECT destination FROM% m.virtual_aliases WHERE source = '% e' AND destination = '% g'"
delete_query = "DELETE FROM% m.virtual_aliases WHERE domain_id =% i AND source = '% e'"
insert_query = "INSERT INTO% m.virtual_aliases (domain_id, source, destination) VALUES (% i, '% e', '% g')"
domain_lookup_query = "SELECT id FROM postfix.virtual_domains WHERE name = '% d'"
if I put: =
createvacationconf=true I get the error message
This user must have UPDATE, INSERT and SELECT privileges to database 'postfix',
table 'vacation' and database 'postfix', table 'virtual_aliases'.
It Should not Be Able to access Roundcube's tables.
should I install the binary: apt-get install vacation?
thank you for your help
gilles
