Here is my 'config.inc.php' setting in vacation plugin.
?php
/*
+-----------------------------------------------------------------------+
| Configuration file for vacation module |
| |
| Copyright (C) 2009 Boris HUISGEN <bhuisgen@hbis.fr> |
| Licensed under the GNU GPL |
+-----------------------------------------------------------------------+
*/
$config = array();
// allow vacation start/end dates
$config['vacation_gui_vacationdate'] = TRUE;
// allow vacation subject
$config['vacation_gui_vacationsubject'] = TRUE;
// allow HTML for vacation message
$config['vacation_gui_vacationmessage_html'] = FALSE;
// allow sending message to be keep in inbox
$config['vacation_gui_vacationkeepcopyininbox'] = FALSE;
// allow vacation forwarder
$config['vacation_gui_vacationforwarder'] = FALSE;
// default vacation subject
$config['vacation_subject_default'] = 'Out of office';
// default vacation message
$config['vacation_message_default'] = 'I\'m currently out of office.';
// vacation start/end date format
$config['vacation_dateformat'] = 'm/d/Y';
// jquery calendar (jqueryui plugin must be enabled)
$config['vacation_jquery_calendar'] = TRUE;
$config['vacation_jquery_dateformat'] = 'mm/dd/yy';
// add MIME header before the message
$config['vacation_message_mime'] = '';
// allow multiple forwarders
$config['vacation_forwarder_multiple'] = TRUE;
$config['vacation_forwarder_separator'] = ';';
// driver used for backend storage
$config['vacation_driver'] = 'SQL';
/*
* SQL driver
*/
// database DSN
$config['vacation_sql_dsn'] =
'mysql://roundcubeuser:XXXXX@localhost/roundcubedb';
// read data queries
$config['vacation_sql_read'] =
array("SELECT subject AS vacation_subject, body AS vacation_message, " .
"active AS vacation_enable FROM vacation " .
"WHERE email=%username AND domain=%email_domain;"
);
// write data queries
$config['vacation_sql_write'] =
array("DELETE FROM vacation WHERE email=%email AND " .
"domain=%email_domain;",
"DELETE from vacation_notification WHERE on_vacation=%email;",
"DELETE FROM alias WHERE address=%email AND " .
"domain=%email_domain;",
"INSERT INTO vacation (email,domain,subject,body,created," .
"active) VALUES (%email,%email_domain,%vacation_subject," .
"%vacation_message,NOW(),%vacation_enable);",
"INSERT INTO alias (address,goto,domain,created,modified," .
"active) " .
"SELECT %email,CONCAT(%email,',',%email_local,'#',%email_domain,'@'," .
"'autoreply.my.domain'),%email_domain,NOW(),NOW(),1 " .
"FROM mailbox WHERE username=%email AND " .
"domain=%email_domain AND %vacation_enable=1;",
"INSERT INTO alias (address,goto,domain,created,modified," .
"active) " .
"SELECT %email,%email,%email_domain,NOW(),NOW(),1 " .
"FROM mailbox WHERE username=%email AND " .
"domain=%email_domain AND %vacation_enable=0;"
);
// end vacation config file
And this is 'config.inc.php' setting in Roundcube.
<?php
/* Local configuration for Roundcube Webmail */
// PEAR database DSN for read/write operations
// format is db_provider://user:password@host/database
// For examples see http://pear.php.net/manual/en/package.database.mdb2.intro-dsn.php
// currently supported db_providers: mysql, mysqli, pgsql, sqlite, mssql or sqlsrv
$config['db_dsnw'] = 'mysql://roundcubeuser:XXXXX@localhost/roundcubedb';
// ----------------------------------
// LOGGING/DEBUGGING
// ----------------------------------
// system error reporting, sum of: 1 = log; 4 = show, 8 = trace
$config['debug_level'] = 4;
// ----------------------------------
// IMAP
// ----------------------------------
// The mail host chosen to perform the log-in.
// Leave blank to show a textbox at login, give a list of hosts
// to display a pulldown menu or set one host as string.
// To use SSL/TLS connection, enter hostname with prefix ssl:// or tls://
// Supported replacement variables:
// %n - hostname ($_SERVER['SERVER_NAME'])
// %t - hostname without the first part
// %d - domain (http hostname $_SERVER['HTTP_HOST'] without the first part)
// %s - domain name after the '@' from e-mail address provided at login screen
// For example %n = mail.domain.tld, %t = domain.tld
// WARNING: After hostname change update of mail_host column in users table is
// required to match old user data records with the new host.
$config['default_host'] = '127.0.0.1';
// ----------------------------------
// SMTP
// ----------------------------------
// SMTP server host (for sending mails).
// To use SSL/TLS connection, enter hostname with prefix ssl:// or tls://
// If left blank, the PHP mail() function is used
// Supported replacement variables:
// %h - user's IMAP hostname
// %n - hostname ($_SERVER['SERVER_NAME'])
// %t - hostname without the first part
// %d - domain (http hostname $_SERVER['HTTP_HOST'] without the first part)
// %z - IMAP domain (IMAP hostname without the first part)
// For example %n = mail.domain.tld, %t = domain.tld
$config['smtp_server'] = '127.0.0.1';
// provide an URL where a user can get support for this Roundcube installation
// PLEASE DO NOT LINK TO THE ROUNDCUBE.NET WEBSITE HERE!
$config['support_url'] = '';
// this key is used to encrypt the users imap password which is stored
// in the session record (and the client cookie if remember password is enabled)
.
// please provide a string of exactly 24 chars.
$config['des_key'] = '9ZSczqPIoh1J6dXm+EB%n=B0';
// ----------------------------------
// PLUGINS
// ----------------------------------
// List of active plugins (in plugins/ directory)
$config['plugins'] = array('vacation');
// ----------------------------------
// USER INTERFACE
// ----------------------------------
// default messages sort column. Use empty value for default server's sorting,
// or 'arrival', 'date', 'subject', 'from', 'to', 'fromto', 'size', 'cc'
$config['message_sort_col'] = 'subject';
// the default locale setting (leave empty for auto-detection)
// RFC1766 formatted language name like en_US, de_DE, de_CH, fr_FR, pt_BR
$config['language'] = 'en_US';
// display remote inline images
// 0 - Never, always ask
// 1 - Ask if sender is not in address book
// 2 - Always show inline images
$config['show_images'] = 1;
// compose html formatted messages by default
// 0 - never, 1 - always, 2 - on reply to HTML message, 3 - on forward or reply
to HTML message
$config['htmleditor'] = 1;
// default setting if preview pane is enabled
$config['preview_pane'] = true;
// Set to true to never delete messages immediately
// Use 'Purge' to remove messages marked as deleted
$config['flag_for_deletion'] = true;
// lifetime of message cache
// possible units: s, m, h, d, w
$config['message_cache_lifetime'] = '10d';
PS. I update Roundcube so from main.inc.php, db.inc.php to default.inc.php,config.inc.php.