{"id":719,"date":"2014-09-03T14:03:37","date_gmt":"2014-09-03T17:03:37","guid":{"rendered":"http:\/\/blog.abratel.com.br\/?p=719"},"modified":"2014-09-03T14:10:09","modified_gmt":"2014-09-03T17:10:09","slug":"atualizando-roundcube-freebsd","status":"publish","type":"post","link":"https:\/\/blog.abratel.com.br\/?p=719","title":{"rendered":"Atualizando RoundCube Freebsd – Instalando PluginManager"},"content":{"rendered":"

Verificando a vers\u00e3o do roundcube atual<\/strong>
\npkg_info -Ix roundcube
\npkg_info -R roundcube”*”<\/p>\n

Atualizar o ports<\/strong>
\nportsnap fetch
\nportsnap update<\/p>\n

Iremos instalar algumas aplica\u00e7\u00f5es necess\u00e1rias ao funcionamento visual de novas vers\u00f5es do roundcube<\/strong>
\npkg_add -rv perl (ou instale do ports)<\/p>\n

cd \/usr\/ports\/ftp\/curl\/
\n make install clean<\/p>\n

cd \/usr\/ports\/ftp\/php5-curl
\nmake install clean<\/p>\n

cd \/usr\/ports\/lang\/php5-extensions\/
\n make config<\/p>\n

cd \/usr\/ports\/www\/pecl-APC\/ && make install
\n(instalar padr\u00e3o)<\/p>\n

cd \/usr\/ports\/lang\/php5
\nmake config
\n\"options_for_php5_5_3_8_fit_content_width1\"<\/a>
\nmake install clean<\/p>\n

cd \/usr\/ports\/lang\/php5-extensions
\nmake config
\n\"options_for_php5_extensions_1_6_fit_content_width\"<\/a>
\nmake install clean<\/p>\n

cd \/usr\/ports\/graphics\/php5-gd
\nmake install clean<\/p>\n

Pode-se visualizar as instala\u00e7\u00f5es posteriormente:
\nfind \/usr\/ports -type d -iname “php5-*”<\/p>\n

Realize um backup do que possui no momento:<\/strong>
\ncp -r \/usr\/local\/www\/roundcube \/usr\/local\/www\/roundcube.01-09-2014
\nmysqldump -u root -pSENHA rcube > \/usr\/local\/www\/roundcube.01-09-2014\/backup_banco.sql<\/p>\n

cd \/usr\/ports\/mail\/roundcube
\nmake install clean<\/p>\n

Aumentando o tamanho do upload<\/strong>
\nNo arquivo php.ini
\napc.rfc1867 = on
\npost_max_size = 20M
\nupload_max_filesize = 15M
\nmax_file_uploads = 300<\/p>\n

Verificar se o limite esta .htaccess dentro do diret\u00f3rio roundcube ou se esta dentro do apache (como no meu caso).<\/strong>
\n\/usr\/local\/etc\/apache22\/httpd.conf
\nphp_value\tupload_max_filesize\t10M
\nphp_value\tpost_max_size\t\t20M
\nphp_value\tmemory_limit\t\t128M<\/p>\n

Instala\u00e7\u00e3o do pluginManager<\/strong><\/p>\n

Baixar o plugin Manager no site oficial do roundcube:
\nhttps:\/\/myroundcube.com\/myroundcube-plugins\/plugin-manager<\/p>\n

Ativa-lo e destivar todos os demais plugins:
\nvim \/usr\/local\/www\/roundcube\/config\/main.inc.php
\n$rcmail_config[‘plugins’] = array(‘plugin_manager’);<\/p>\n

Envia-lo descompactado junto aos outros plugins dispon\u00edveis neste .zip baixado para o diret\u00f3rio roundcube\/plugins.<\/p>\n

No primeiro acesso v\u00e1 em configura\u00e7\u00f5es e ap\u00f3s em GERENCIAR PLUGINS –> CONFIGURA\u00c7\u00d5ES.
\nIr\u00e1 aparecer uma chave na qual voc\u00ea dever\u00e1 criar um arquivo com o nome desta na raiz do roundcube a fim de autorizar este usu\u00e1rio. <\/p>\n

touch \/usr\/local\/www\/roundcube\/esloqh4uin7u1il790cpiail87.myrc<\/p>\n

Ap\u00f3s criada poder\u00e1 prosseguir.<\/p>\n

Em momentos poder\u00e1 ser solicitado o aceite para criar tabelas do pluginmanager ou demais plugins. Sempre ter\u00e1 que aceitar.
\nAp\u00f3s ativar o plugin e relogar no roundcube ele sempre ir\u00e1 perguntar sobre a aceita\u00e7\u00e3o da inser\u00e7\u00e3o da tabela (caso o plugin tenha necessidade como o Calend\u00e1rio, exemplo abaixo):
\n\"Imagem<\/a><\/p>\n

Ap\u00f3s feito toda a habilita\u00e7\u00e3o do plugin_manager, tudo dever\u00e1 ser configurado por ele, at\u00e9 mesmo os plugins antigos.<\/p>\n

Tutorial Completo PLUGIN_MANAGER:<\/strong>
\nhttps:\/\/www.youtube.com\/watch?v=EnmJ_cnkKq0
\nhttps:\/\/www.youtube.com\/watch?v=J95qNUWf1Ms<\/p>\n

Meu banco rcube<\/strong><\/p>\n

create database rcube;
\nuse rcube;<\/p>\n

SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;
\nSET time_zone = “+00:00″;<\/p>\n

\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;
\n\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;
\n\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;
\n\/*!40101 SET NAMES utf8 *\/;<\/p>\n

DROP TABLE IF EXISTS `cache`;
\nCREATE TABLE IF NOT EXISTS `cache` (
\n `cache_key` varchar(128) character set ascii NOT NULL,
\n `created` datetime NOT NULL default ‘1000-01-01 00:00:00’,
\n `data` longtext NOT NULL,
\n `user_id` int(10) unsigned NOT NULL,
\n `expires` datetime default NULL,
\n KEY `user_cache_index` (`user_id`,`cache_key`),
\n KEY `expires_index` (`expires`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `cache_index`
\n—<\/p>\n

DROP TABLE IF EXISTS `cache_index`;
\nCREATE TABLE IF NOT EXISTS `cache_index` (
\n `user_id` int(10) unsigned NOT NULL,
\n `mailbox` varchar(255) character set utf8 collate utf8_bin NOT NULL,
\n `valid` tinyint(1) NOT NULL default ‘0’,
\n `data` longtext NOT NULL,
\n `expires` datetime default NULL,
\n PRIMARY KEY (`user_id`,`mailbox`),
\n KEY `expires_index` (`expires`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `cache_messages`
\n—<\/p>\n

DROP TABLE IF EXISTS `cache_messages`;
\nCREATE TABLE IF NOT EXISTS `cache_messages` (
\n `user_id` int(10) unsigned NOT NULL,
\n `mailbox` varchar(255) character set utf8 collate utf8_bin NOT NULL,
\n `uid` int(11) unsigned NOT NULL default ‘0’,
\n `data` longtext NOT NULL,
\n `flags` int(11) NOT NULL default ‘0’,
\n `expires` datetime default NULL,
\n PRIMARY KEY (`user_id`,`mailbox`,`uid`),
\n KEY `expires_index` (`expires`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `cache_shared`
\n—<\/p>\n

DROP TABLE IF EXISTS `cache_shared`;
\nCREATE TABLE IF NOT EXISTS `cache_shared` (
\n `cache_key` varchar(255) character set ascii NOT NULL,
\n `created` datetime NOT NULL default ‘1000-01-01 00:00:00’,
\n `data` longtext NOT NULL,
\n `expires` datetime default NULL,
\n KEY `cache_key_index` (`cache_key`),
\n KEY `expires_index` (`expires`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `cache_thread`
\n—<\/p>\n

DROP TABLE IF EXISTS `cache_thread`;
\nCREATE TABLE IF NOT EXISTS `cache_thread` (
\n `user_id` int(10) unsigned NOT NULL,
\n `mailbox` varchar(255) character set utf8 collate utf8_bin NOT NULL,
\n `data` longtext NOT NULL,
\n `expires` datetime default NULL,
\n PRIMARY KEY (`user_id`,`mailbox`),
\n KEY `expires_index` (`expires`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `carddav_contactgroupmembers`
\n—<\/p>\n

DROP TABLE IF EXISTS `carddav_contactgroupmembers`;
\nCREATE TABLE IF NOT EXISTS `carddav_contactgroupmembers` (
\n `contactgroup_id` int(10) unsigned NOT NULL,
\n `contact_id` int(10) unsigned NOT NULL,
\n `created` datetime NOT NULL default ‘1000-01-01 00:00:00’,
\n PRIMARY KEY (`contactgroup_id`,`contact_id`),
\n KEY `carddav_contactgroupmembers_contact_index` (`contact_id`),
\n KEY `contact_id` (`contact_id`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `carddav_contactgroups`
\n—<\/p>\n

DROP TABLE IF EXISTS `carddav_contactgroups`;
\nCREATE TABLE IF NOT EXISTS `carddav_contactgroups` (
\n `contactgroup_id` int(10) unsigned NOT NULL auto_increment,
\n `user_id` int(10) unsigned NOT NULL,
\n `changed` datetime NOT NULL default ‘1000-01-01 00:00:00’,
\n `del` tinyint(1) NOT NULL default ‘0’,
\n `name` varchar(128) NOT NULL default ”,
\n `addressbook` int(10) unsigned default NULL,
\n PRIMARY KEY (`contactgroup_id`),
\n KEY `carddav_contactgroups_user_index` (`user_id`,`del`),
\n KEY `addressbook` (`addressbook`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `carddav_contacts`
\n—<\/p>\n

DROP TABLE IF EXISTS `carddav_contacts`;
\nCREATE TABLE IF NOT EXISTS `carddav_contacts` (
\n `carddav_contact_id` int(10) unsigned NOT NULL auto_increment,
\n `carddav_server_id` int(10) unsigned NOT NULL,
\n `user_id` int(10) unsigned NOT NULL,
\n `etag` varchar(255) default NULL,
\n `last_modified` varchar(128) NOT NULL,
\n `vcard_id` varchar(255) default NULL,
\n `vcard` longtext NOT NULL,
\n `words` text,
\n `firstname` varchar(128) default NULL,
\n `surname` varchar(128) default NULL,
\n `name` varchar(255) default NULL,
\n `email` varchar(255) default NULL,
\n PRIMARY KEY (`carddav_contact_id`),
\n UNIQUE KEY `carddav_server_id` (`carddav_server_id`,`user_id`,`vcard_id`),
\n KEY `user_id` (`user_id`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `carddav_server`
\n—<\/p>\n

DROP TABLE IF EXISTS `carddav_server`;
\nCREATE TABLE IF NOT EXISTS `carddav_server` (
\n `carddav_server_id` int(10) unsigned NOT NULL auto_increment,
\n `user_id` int(10) unsigned NOT NULL,
\n `url` varchar(255) collate utf8_unicode_ci NOT NULL,
\n `username` varchar(128) collate utf8_unicode_ci NOT NULL,
\n `password` varchar(128) collate utf8_unicode_ci NOT NULL,
\n `label` varchar(128) collate utf8_unicode_ci NOT NULL,
\n `read_only` tinyint(1) NOT NULL,
\n `autocomplete` tinyint(1) NOT NULL default ‘1’,
\n `idx` int(10) default NULL,
\n `edt` tinyint(1) default NULL,
\n `subscribed` tinyint(1) unsigned NOT NULL default ‘1’,
\n PRIMARY KEY (`carddav_server_id`),
\n KEY `user_id` (`user_id`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `collected_contacts`
\n—<\/p>\n

DROP TABLE IF EXISTS `collected_contacts`;
\nCREATE TABLE IF NOT EXISTS `collected_contacts` (
\n `contact_id` int(10) unsigned NOT NULL auto_increment,
\n `changed` datetime NOT NULL default ‘1000-01-01 00:00:00’,
\n `del` tinyint(1) NOT NULL default ‘0’,
\n `name` varchar(128) character set utf8 collate utf8_unicode_ci NOT NULL default ”,
\n `email` text character set utf8 collate utf8_unicode_ci NOT NULL,
\n `firstname` varchar(128) character set utf8 collate utf8_unicode_ci NOT NULL default ”,
\n `surname` varchar(128) character set utf8 collate utf8_unicode_ci NOT NULL default ”,
\n `vcard` longtext character set utf8 collate utf8_unicode_ci,
\n `words` text character set utf8 collate utf8_unicode_ci,
\n `user_id` int(10) unsigned NOT NULL,
\n PRIMARY KEY (`contact_id`),
\n KEY `user_collected_contacts_index` (`user_id`,`del`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=52 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `contactgroupmembers`
\n—<\/p>\n

DROP TABLE IF EXISTS `contactgroupmembers`;
\nCREATE TABLE IF NOT EXISTS `contactgroupmembers` (
\n `contactgroup_id` int(10) unsigned NOT NULL,
\n `contact_id` int(10) unsigned NOT NULL,
\n `created` datetime NOT NULL default ‘1000-01-01 00:00:00’,
\n PRIMARY KEY (`contactgroup_id`,`contact_id`),
\n KEY `contactgroupmembers_contact_index` (`contact_id`)
\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `contactgroups`
\n—<\/p>\n

DROP TABLE IF EXISTS `contactgroups`;
\nCREATE TABLE IF NOT EXISTS `contactgroups` (
\n `contactgroup_id` int(10) unsigned NOT NULL auto_increment,
\n `user_id` int(10) unsigned NOT NULL,
\n `changed` datetime NOT NULL default ‘1000-01-01 00:00:00’,
\n `del` tinyint(1) NOT NULL default ‘0’,
\n `name` varchar(128) NOT NULL default ”,
\n PRIMARY KEY (`contactgroup_id`),
\n KEY `contactgroups_user_index` (`user_id`,`del`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `contacts`
\n—<\/p>\n

DROP TABLE IF EXISTS `contacts`;
\nCREATE TABLE IF NOT EXISTS `contacts` (
\n `contact_id` int(10) unsigned NOT NULL auto_increment,
\n `changed` datetime NOT NULL default ‘1000-01-01 00:00:00’,
\n `del` tinyint(1) NOT NULL default ‘0’,
\n `name` varchar(128) NOT NULL default ”,
\n `email` text NOT NULL,
\n `firstname` varchar(128) NOT NULL default ”,
\n `surname` varchar(128) NOT NULL default ”,
\n `vcard` longtext,
\n `words` text,
\n `user_id` int(10) unsigned NOT NULL,
\n PRIMARY KEY (`contact_id`),
\n KEY `user_contacts_index` (`user_id`,`del`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=517 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `db_config`
\n—<\/p>\n

DROP TABLE IF EXISTS `db_config`;
\nCREATE TABLE IF NOT EXISTS `db_config` (
\n `id` int(11) NOT NULL auto_increment,
\n `env` varchar(255) character set latin1 NOT NULL,
\n `conf` longtext character set latin1 NOT NULL,
\n `admin` varchar(128) character set latin1 NOT NULL,
\n PRIMARY KEY (`id`)
\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `dictionary`
\n—<\/p>\n

DROP TABLE IF EXISTS `dictionary`;
\nCREATE TABLE IF NOT EXISTS `dictionary` (
\n `user_id` int(10) unsigned default NULL,
\n `language` varchar(5) NOT NULL,
\n `data` longtext NOT NULL,
\n UNIQUE KEY `uniqueness` (`user_id`,`language`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `events`
\n—<\/p>\n

DROP TABLE IF EXISTS `events`;
\nCREATE TABLE IF NOT EXISTS `events` (
\n `event_id` int(11) unsigned NOT NULL auto_increment,
\n `component` varchar(6) NOT NULL default ‘vevent’,
\n `uid` text,
\n `priority` int(1) NOT NULL default ‘0’,
\n `recurrence_id` int(10) default NULL,
\n `exdates` text,
\n `user_id` int(10) unsigned NOT NULL default ‘0’,
\n `start` int(11) NOT NULL default ‘0’,
\n `end` int(11) NOT NULL default ‘0’,
\n `due` int(11) NOT NULL default ‘0’,
\n `complete` int(3) NOT NULL default ‘0’,
\n `expires` int(11) NOT NULL default ‘0’,
\n `tzname` varchar(255) default ‘UTC’,
\n `rr` varchar(1) default NULL,
\n `recurring` text NOT NULL,
\n `occurrences` int(11) default ‘0’,
\n `byday` text,
\n `bymonth` text,
\n `bymonthday` text,
\n `summary` varchar(255) NOT NULL,
\n `description` text NOT NULL,
\n `location` varchar(255) NOT NULL default ”,
\n `categories` varchar(255) NOT NULL default ”,
\n `labels` varchar(255) NOT NULL default ”,
\n `created` datetime default NULL,
\n `modified` datetime default NULL,
\n `caldav` text,
\n `url` text,
\n `status` varchar(25) default NULL,
\n `organizer` varchar(255) default NULL,
\n `attendees` varchar(255) default NULL,
\n `timestamp` timestamp NULL default CURRENT_TIMESTAMP,
\n `del` int(1) NOT NULL default ‘0’,
\n `reminder` int(10) default NULL,
\n `reminderservice` text,
\n `remindermailto` text,
\n `remindersent` int(10) default NULL,
\n `notified` int(1) NOT NULL default ‘0’,
\n `client` text,
\n PRIMARY KEY (`event_id`),
\n KEY `user_id_fk_events` (`user_id`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `events_cache`
\n—<\/p>\n

DROP TABLE IF EXISTS `events_cache`;
\nCREATE TABLE IF NOT EXISTS `events_cache` (
\n `event_id` int(11) unsigned NOT NULL auto_increment,
\n `component` varchar(6) collate utf8_unicode_ci NOT NULL default ‘vevent’,
\n `uid` text character set utf8,
\n `priority` int(1) NOT NULL default ‘0’,
\n `recurrence_id` int(10) default NULL,
\n `exdates` text character set utf8,
\n `user_id` int(10) unsigned NOT NULL default ‘0’,
\n `start` int(11) NOT NULL default ‘0’,
\n `end` int(11) NOT NULL default ‘0’,
\n `due` int(11) NOT NULL default ‘0’,
\n `complete` int(3) NOT NULL default ‘0’,
\n `expires` int(11) NOT NULL default ‘0’,
\n `tzname` varchar(255) collate utf8_unicode_ci default ‘UTC’,
\n `rr` varchar(1) character set utf8 default NULL,
\n `recurring` text character set utf8 NOT NULL,
\n `occurrences` int(11) default ‘0’,
\n `byday` text character set utf8,
\n `bymonth` text character set utf8,
\n `bymonthday` text character set utf8,
\n `summary` varchar(255) character set utf8 NOT NULL,
\n `description` text character set utf8 NOT NULL,
\n `location` varchar(255) character set utf8 NOT NULL default ”,
\n `categories` varchar(255) character set utf8 NOT NULL default ”,
\n `labels` varchar(255) collate utf8_unicode_ci NOT NULL default ”,
\n `created` datetime default NULL,
\n `modified` datetime default NULL,
\n `caldav` text character set utf8,
\n `url` text collate utf8_unicode_ci,
\n `status` varchar(25) collate utf8_unicode_ci default NULL,
\n `organizer` varchar(255) collate utf8_unicode_ci default NULL,
\n `attendees` varchar(255) collate utf8_unicode_ci default NULL,
\n `timestamp` timestamp NULL default CURRENT_TIMESTAMP,
\n `del` int(1) NOT NULL default ‘0’,
\n `reminder` int(10) default NULL,
\n `reminderservice` text character set utf8,
\n `remindermailto` text character set utf8,
\n `remindersent` int(10) default NULL,
\n `notified` int(1) NOT NULL default ‘0’,
\n `client` text character set utf8,
\n PRIMARY KEY (`event_id`),
\n KEY `user_id_fk_events_cache` (`user_id`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `events_caldav`
\n—<\/p>\n

DROP TABLE IF EXISTS `events_caldav`;
\nCREATE TABLE IF NOT EXISTS `events_caldav` (
\n `event_id` int(11) unsigned NOT NULL auto_increment,
\n `component` varchar(6) NOT NULL default ‘vevent’,
\n `uid` text,
\n `priority` int(1) NOT NULL default ‘0’,
\n `recurrence_id` int(10) default NULL,
\n `exdates` text,
\n `user_id` int(10) unsigned NOT NULL default ‘0’,
\n `start` int(11) default ‘0’,
\n `end` int(11) default ‘0’,
\n `due` int(11) NOT NULL default ‘0’,
\n `complete` int(3) NOT NULL default ‘0’,
\n `expires` int(11) default ‘0’,
\n `tzname` varchar(255) default ‘UTC’,
\n `rr` varchar(1) default NULL,
\n `recurring` text NOT NULL,
\n `occurrences` int(11) default ‘0’,
\n `byday` text,
\n `bymonth` text,
\n `bymonthday` text,
\n `summary` varchar(255) NOT NULL,
\n `description` text NOT NULL,
\n `location` varchar(255) NOT NULL default ”,
\n `categories` varchar(255) NOT NULL default ”,
\n `labels` varchar(255) NOT NULL default ”,
\n `created` datetime default NULL,
\n `modified` datetime default NULL,
\n `caldav` text,
\n `url` text,
\n `status` varchar(25) default NULL,
\n `organizer` varchar(255) default NULL,
\n `attendees` varchar(255) default NULL,
\n `timestamp` timestamp NULL default CURRENT_TIMESTAMP,
\n `del` int(1) NOT NULL default ‘0’,
\n `reminder` int(10) default NULL,
\n `reminderservice` text,
\n `remindermailto` text,
\n `remindersent` int(10) default NULL,
\n `notified` int(1) NOT NULL default ‘0’,
\n `client` text,
\n PRIMARY KEY (`event_id`),
\n KEY `user_id_fk_events_caldav` (`user_id`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `identities`
\n—<\/p>\n

DROP TABLE IF EXISTS `identities`;
\nCREATE TABLE IF NOT EXISTS `identities` (
\n `identity_id` int(10) unsigned NOT NULL auto_increment,
\n `user_id` int(10) unsigned NOT NULL,
\n `changed` datetime NOT NULL default ‘1000-01-01 00:00:00’,
\n `del` tinyint(1) NOT NULL default ‘0’,
\n `standard` tinyint(1) NOT NULL default ‘0’,
\n `name` varchar(128) NOT NULL,
\n `organization` varchar(128) NOT NULL default ”,
\n `email` varchar(128) NOT NULL,
\n `reply-to` varchar(128) NOT NULL default ”,
\n `bcc` varchar(128) NOT NULL default ”,
\n `signature` text,
\n `html_signature` tinyint(1) NOT NULL default ‘0’,
\n PRIMARY KEY (`identity_id`),
\n KEY `user_identities_index` (`user_id`,`del`),
\n KEY `email_identities_index` (`email`,`del`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=141 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `plugin_manager`
\n—<\/p>\n

DROP TABLE IF EXISTS `plugin_manager`;
\nCREATE TABLE IF NOT EXISTS `plugin_manager` (
\n `id` int(10) NOT NULL auto_increment,
\n `conf` text NOT NULL,
\n `value` text,
\n `type` text,
\n PRIMARY KEY (`id`)
\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1064 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `reminders`
\n—<\/p>\n

DROP TABLE IF EXISTS `reminders`;
\nCREATE TABLE IF NOT EXISTS `reminders` (
\n `reminder_id` int(10) unsigned NOT NULL auto_increment,
\n `user_id` int(10) unsigned NOT NULL,
\n `events` int(10) unsigned default NULL,
\n `cache` int(10) unsigned default NULL,
\n `caldav` int(10) unsigned default NULL,
\n `type` text,
\n `props` text,
\n `runtime` int(11) NOT NULL,
\n PRIMARY KEY (`reminder_id`),
\n KEY `reminders_ibfk_1` (`user_id`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `searches`
\n—<\/p>\n

DROP TABLE IF EXISTS `searches`;
\nCREATE TABLE IF NOT EXISTS `searches` (
\n `search_id` int(10) unsigned NOT NULL auto_increment,
\n `user_id` int(10) unsigned NOT NULL,
\n `type` int(3) NOT NULL default ‘0’,
\n `name` varchar(128) NOT NULL,
\n `data` text,
\n PRIMARY KEY (`search_id`),
\n UNIQUE KEY `uniqueness` (`user_id`,`type`,`name`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `session`
\n—<\/p>\n

DROP TABLE IF EXISTS `session`;
\nCREATE TABLE IF NOT EXISTS `session` (
\n `sess_id` varchar(128) NOT NULL,
\n `created` datetime NOT NULL default ‘1000-01-01 00:00:00’,
\n `changed` datetime NOT NULL default ‘1000-01-01 00:00:00’,
\n `ip` varchar(40) NOT NULL,
\n `vars` mediumtext NOT NULL,
\n PRIMARY KEY (`sess_id`),
\n KEY `changed_index` (`changed`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `system`
\n—<\/p>\n

DROP TABLE IF EXISTS `system`;
\nCREATE TABLE IF NOT EXISTS `system` (
\n `name` varchar(64) NOT NULL,
\n `value` mediumtext,
\n PRIMARY KEY (`name`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Estrutura da tabela `users`
\n—<\/p>\n

DROP TABLE IF EXISTS `users`;
\nCREATE TABLE IF NOT EXISTS `users` (
\n `user_id` int(10) unsigned NOT NULL auto_increment,
\n `username` varchar(128) character set utf8 collate utf8_bin NOT NULL,
\n `mail_host` varchar(128) NOT NULL,
\n `created` datetime NOT NULL default ‘1000-01-01 00:00:00’,
\n `last_login` datetime default NULL,
\n `language` varchar(5) default NULL,
\n `preferences` longtext,
\n PRIMARY KEY (`user_id`),
\n UNIQUE KEY `username` (`username`,`mail_host`)
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=139 ;<\/p>\n

—
\n— Constraints for dumped tables
\n—<\/p>\n

—
\n— Limitadores para a tabela `cache`
\n—
\nALTER TABLE `cache`
\n ADD CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `cache_index`
\n—
\nALTER TABLE `cache_index`
\n ADD CONSTRAINT `user_id_fk_cache_index` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `cache_messages`
\n—
\nALTER TABLE `cache_messages`
\n ADD CONSTRAINT `user_id_fk_cache_messages` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `cache_thread`
\n—
\nALTER TABLE `cache_thread`
\n ADD CONSTRAINT `user_id_fk_cache_thread` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `carddav_contactgroupmembers`
\n—
\nALTER TABLE `carddav_contactgroupmembers`
\n ADD CONSTRAINT `carddav_contactgroupmembers_ibfk_1` FOREIGN KEY (`contactgroup_id`) REFERENCES `carddav_contactgroups` (`contactgroup_id`) ON DELETE CASCADE ON UPDATE CASCADE,
\n ADD CONSTRAINT `carddav_contactgroupmembers_ibfk_2` FOREIGN KEY (`contact_id`) REFERENCES `carddav_contacts` (`carddav_contact_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `carddav_contactgroups`
\n—
\nALTER TABLE `carddav_contactgroups`
\n ADD CONSTRAINT `carddav_contactgroups_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
\n ADD CONSTRAINT `carddav_contactgroups_ibfk_2` FOREIGN KEY (`addressbook`) REFERENCES `carddav_server` (`carddav_server_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `carddav_contacts`
\n—
\nALTER TABLE `carddav_contacts`
\n ADD CONSTRAINT `carddav_contacts_ibfk_1` FOREIGN KEY (`carddav_server_id`) REFERENCES `carddav_server` (`carddav_server_id`) ON DELETE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `carddav_server`
\n—
\nALTER TABLE `carddav_server`
\n ADD CONSTRAINT `carddav_server_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `collected_contacts`
\n—
\nALTER TABLE `collected_contacts`
\n ADD CONSTRAINT `user_id_fk_collected_contacts` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `contactgroupmembers`
\n—
\nALTER TABLE `contactgroupmembers`
\n ADD CONSTRAINT `contactgroup_id_fk_contactgroups` FOREIGN KEY (`contactgroup_id`) REFERENCES `contactgroups` (`contactgroup_id`) ON DELETE CASCADE ON UPDATE CASCADE,
\n ADD CONSTRAINT `contact_id_fk_contacts` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `contactgroups`
\n—
\nALTER TABLE `contactgroups`
\n ADD CONSTRAINT `user_id_fk_contactgroups` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `contacts`
\n—
\nALTER TABLE `contacts`
\n ADD CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `dictionary`
\n—
\nALTER TABLE `dictionary`
\n ADD CONSTRAINT `user_id_fk_dictionary` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `events`
\n—
\nALTER TABLE `events`
\n ADD CONSTRAINT `events_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `events_cache`
\n—
\nALTER TABLE `events_cache`
\n ADD CONSTRAINT `events_cache_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `events_caldav`
\n—
\nALTER TABLE `events_caldav`
\n ADD CONSTRAINT `events_caldav_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `identities`
\n—
\nALTER TABLE `identities`
\n ADD CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `reminders`
\n—
\nALTER TABLE `reminders`
\n ADD CONSTRAINT `reminders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

—
\n— Limitadores para a tabela `searches`
\n—
\nALTER TABLE `searches`
\n ADD CONSTRAINT `user_id_fk_searches` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;<\/p>\n

\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/;
\n\/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS *\/;
\n\/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION *\/;<\/p>\n

Posto abaixo meus arquivos:
\nvim \/usr\/local\/www\/roundcube\/config\/main.inc.php<\/strong>
\n\/sendmail or to syslog
\n$rcmail_config[‘smtp_log’] = true;<\/p>\n

\/\/ Log successful logins to \/userlogins or to syslog
\n$rcmail_config[‘log_logins’] = true;<\/p>\n

\/\/ Log session authentication errors to \/session or to syslog
\n$rcmail_config[‘log_session’] = true;<\/p>\n

\/\/ Log SQL queries to \/sql or to syslog
\n$rcmail_config[‘sql_debug’] = true;<\/p>\n

\/\/ Log IMAP conversation to \/imap or to syslog
\n$rcmail_config[‘imap_debug’] = true;<\/p>\n

\/\/ Log LDAP conversation to \/ldap or to syslog
\n$rcmail_config[‘ldap_debug’] = true;<\/p>\n

\/\/ Log SMTP conversation to \/smtp or to syslog
\n$rcmail_config[‘smtp_debug’] = true;<\/p>\n

\/\/ ———————————-
\n\/\/ IMAP
\n\/\/ ———————————-<\/p>\n

\/\/ The mail host chosen to perform the log-in.
\n\/\/ Leave blank to show a textbox at login, give a list of hosts
\n\/\/ to display a pulldown menu or set one host as string.
\n\/\/ To use SSL\/TLS connection, enter hostname with prefix ssl:\/\/ or tls:\/\/
\n\/\/ Supported replacement variables:
\n\/\/ %n – hostname ($_SERVER[‘SERVER_NAME’])
\n\/\/ %t – hostname without the first part
\n\/\/ %d – domain (http hostname $_SERVER[‘HTTP_HOST’] without the first part)
\n\/\/ %s – domain name after the ‘@’ from e-mail address provided at login screen
\n\/\/ For example %n = mail.domain.tld, %t = domain.tld
\n\/\/ WARNING: After hostname change update of mail_host column in users table is
\n\/\/ required to match old user data records with the new host.
\n$rcmail_config[‘default_host’] = ‘127.0.0.1’;<\/p>\n

\/\/ TCP port used for IMAP connections
\n$rcmail_config[‘default_port’] = 143;<\/p>\n

\/\/ IMAP AUTH type (DIGEST-MD5, CRAM-MD5, LOGIN, PLAIN or null to use
\n\/\/ best server supported one)
\n$rcmail_config[‘imap_auth_type’] = NULL;<\/p>\n

\/\/ If you know your imap’s folder delimiter, you can specify it here.
\n\/\/ Otherwise it will be determined automatically
\n$rcmail_config[‘imap_delimiter’] = NULL;<\/p>\n

\/\/ If IMAP server doesn’t support NAMESPACE extension, but you’re
\n\/\/ using shared folders or personal root folder is non-empty, you’ll need to
\n\/\/ set these options. All can be strings or arrays of strings.
\n\/\/ Folders need to be ended with directory separator, e.g. “INBOX.”
\n\/\/ (special directory “~” is an exception to this rule)
\n\/\/ These can be used also to overwrite server’s namespaces
\n$rcmail_config[‘imap_ns_personal’] = NULL;
\n$rcmail_config[‘imap_ns_other’] = NULL;
\n$rcmail_config[‘imap_ns_shared’] = NULL;<\/p>\n

$rcmail_config[‘imap_root’] = ‘mail’;
\n\/\/ By default IMAP capabilities are readed after connection to IMAP server
\n\/\/ In some cases, e.g. when using IMAP proxy, there’s a need to refresh the list
\n\/\/ after login. Set to True if you’ve got this case.
\n$rcmail_config[‘imap_force_caps’] = false;<\/p>\n

\/\/ By default list of subscribed folders is determined using LIST-EXTENDED
\n\/\/ extension if available. Some servers (dovecot 1.x) returns wrong results
\n\/\/ for shared namespaces in this case. http:\/\/trac.roundcube.net\/ticket\/1486225
\n\/\/ Enable this option to force LSUB command usage instead.
\n$rcmail_config[‘imap_force_lsub’] = false;<\/p>\n

\/\/ Some server configurations (e.g. Courier) doesn’t list folders in all namespaces
\n\/\/ Enable this option to force listing of folders in all namespaces
\n$rcmail_config[‘imap_force_ns’] = false;<\/p>\n

\/\/ IMAP connection timeout, in seconds. Default: 0 (no limit)
\n$rcmail_config[‘imap_timeout’] = 0;<\/p>\n

\/\/ Optional IMAP authentication identifier to be used as authorization proxy
\n$rcmail_config[‘imap_auth_cid’] = NULL;<\/p>\n

\/\/ Optional IMAP authentication password to be used for imap_auth_cid
\n$rcmail_config[‘imap_auth_pw’] = NULL;<\/p>\n

\/\/ Type of IMAP indexes cache. Supported values: ‘db’, ‘apc’ and ‘memcache’.
\n$rcmail_config[‘imap_cache’] = NULL;<\/p>\n

\/\/ Enables messages cache. Only ‘db’ cache is supported.
\n$rcmail_config[‘messages_cache’] = false;<\/p>\n

\/\/ ———————————-
\n\/\/ SMTP
\n\/\/ ———————————-<\/p>\n

\/\/ SMTP server host (for sending mails).
\n\/\/ To use SSL\/TLS connection, enter hostname with prefix ssl:\/\/ or tls:\/\/
\n\/\/ If left blank, the PHP mail() function is used
\n\/\/ Supported replacement variables:
\n\/\/ %h – user’s IMAP hostname
\n\/\/ %n – hostname ($_SERVER[‘SERVER_NAME’])
\n\/\/ %t – hostname without the first part
\n\/\/ %d – domain (http hostname $_SERVER[‘HTTP_HOST’] without the first part)
\n\/\/ %z – IMAP domain (IMAP hostname without the first part)
\n\/\/ For example %n = mail.domain.tld, %t = domain.tld
\n$rcmail_config[‘smtp_server’] = ‘127.0.0.1’;<\/p>\n

\/\/ SMTP port (default is 25; use 587 for STARTTLS or 465 for the
\n\/\/ deprecated SSL over SMTP (aka SMTPS))
\n$rcmail_config[‘smtp_port’] = 587;<\/p>\n

\/\/ SMTP username (if required) if you use %u as the username Roundcube
\n\/\/ will use the current username for login
\n$rcmail_config[‘smtp_user’] = ‘%u’;<\/p>\n

\/\/ SMTP password (if required) if you use %p as the password Roundcube
\n\/\/ will use the current user’s password for login
\n$rcmail_config[‘smtp_pass’] = ‘%p’;<\/p>\n

\/\/ SMTP AUTH type (DIGEST-MD5, CRAM-MD5, LOGIN, PLAIN or empty to use
\n\/\/ best server supported one)
\n$rcmail_config[‘smtp_auth_type’] = ‘LOGIN’;<\/p>\n

\/\/ Optional SMTP authentication identifier to be used as authorization proxy
\n$rcmail_config[‘smtp_auth_cid’] = NULL;<\/p>\n

\/\/ Optional SMTP authentication password to be used for smtp_auth_cid
\n$rcmail_config[‘smtp_auth_pw’] = NULL;<\/p>\n

\/\/ SMTP HELO host
\n\/\/ Hostname to give to the remote server for SMTP ‘HELO’ or ‘EHLO’ messages
\n\/\/ Leave this blank and you will get the server variable ‘server_name’ or
\n\/\/ localhost if that isn’t defined.
\n$rcmail_config[‘smtp_helo_host’] = ”;<\/p>\n

\/\/ SMTP connection timeout, in seconds. Default: 0 (no limit)
\n\/\/ Note: There’s a known issue where using ssl connection with
\n\/\/ timeout > 0 causes connection errors (https:\/\/bugs.php.net\/bug.php?id=54511)
\n$rcmail_config[‘smtp_timeout’] = 0;<\/p>\n

\/\/ ———————————-
\n\/\/ SYSTEM
\n\/\/ ———————————-<\/p>\n

\/\/ THIS OPTION WILL ALLOW THE INSTALLER TO RUN AND CAN EXPOSE SENSITIVE CONFIG DATA.
\n\/\/ ONLY ENABLE IT IF YOU’RE REALLY SURE WHAT YOU’RE DOING!
\n$rcmail_config[‘enable_installer’] = true;<\/p>\n

\/\/ don’t allow these settings to be overriden by the user
\n$rcmail_config[‘dont_override’] = array();<\/p>\n

\/\/ provide an URL where a user can get support for this Roundcube installation
\n\/\/ PLEASE DO NOT LINK TO THE ROUNDCUBE.NET WEBSITE HERE!
\n$rcmail_config[‘support_url’] = ”;<\/p>\n

\/\/ replace Roundcube logo with this image
\n\/\/ specify an URL relative to the document root of this Roundcube installation
\n$rcmail_config[‘skin_logo’] = NULL;<\/p>\n

\/\/ automatically create a new Roundcube user when log-in the first time.
\n\/\/ a new user will be created once the IMAP login succeeds.
\n\/\/ set to false if only registered users can use this service
\n$rcmail_config[‘auto_create_user’] = true;<\/p>\n

\/\/ Enables possibility to log in using email address from user identities
\n$rcmail_config[‘user_aliases’] = false;<\/p>\n

\/\/ use this folder to store log files (must be writeable for apache user)
\n\/\/ This is used by the ‘file’ log driver.
\n$rcmail_config[‘log_dir’] = ‘logs\/’;<\/p>\n

\/\/ use this folder to store temp files (must be writeable for apache user)
\n$rcmail_config[‘temp_dir’] = ‘temp\/’;<\/p>\n

\/\/ lifetime of message cache
\n\/\/ possible units: s, m, h, d, w
\n$rcmail_config[‘message_cache_lifetime’] = ’10d’;<\/p>\n

\/\/ enforce connections over https
\n\/\/ with this option enabled, all non-secure connections will be redirected.
\n\/\/ set the port for the ssl connection as value of this option if it differs from the default 443
\n$rcmail_config[‘force_https’] = false;<\/p>\n

\/\/ tell PHP that it should work as under secure connection
\n\/\/ even if it doesn’t recognize it as secure ($_SERVER[‘HTTPS’] is not set)
\n\/\/ e.g. when you’re running Roundcube behind a https proxy
\n\/\/ this option is mutually exclusive to ‘force_https’ and only either one of them should be set to true.
\n$rcmail_config[‘use_https’] = false;<\/p>\n

\/\/ Allow browser-autocompletion on login form.
\n\/\/ 0 – disabled, 1 – username and host only, 2 – username, host, password
\n$rcmail_config[‘login_autocomplete’] = 2;<\/p>\n

\/\/ Forces conversion of logins to lower case.
\n\/\/ 0 – disabled, 1 – only domain part, 2 – domain and local part.
\n\/\/ If users authentication is case-insensitive this must be enabled.
\n\/\/ Note: After enabling it all user records need to be updated, e.g. with query:
\n\/\/ UPDATE users SET username = LOWER(username);
\n$rcmail_config[‘login_lc’] = 0;<\/p>\n

\/\/ Includes should be interpreted as PHP files
\n$rcmail_config[‘skin_include_php’] = true;<\/p>\n

\/\/ display software version on login screen
\n$rcmail_config[‘display_version’] = false;<\/p>\n

\/\/ Session lifetime in minutes
\n$rcmail_config[‘session_lifetime’] = 30;<\/p>\n

\/\/ Session domain: .example.org
\n$rcmail_config[‘session_domain’] = ”;<\/p>\n

\/\/ Session name. Default: ‘roundcube_sessid’
\n$rcmail_config[‘session_name’] = NULL;<\/p>\n

\/\/ Session authentication cookie name. Default: ‘roundcube_sessauth’
\n$rcmail_config[‘session_auth_name’] = NULL;<\/p>\n

\/\/ Session path. Defaults to PHP session.cookie_path setting.
\n$rcmail_config[‘session_path’] = NULL;<\/p>\n

\/\/ Backend to use for session storage. Can either be ‘db’ (default) or ‘memcache’
\n\/\/ If set to memcache, a list of servers need to be specified in ‘memcache_hosts’
\n\/\/ Make sure the Memcache extension (http:\/\/pecl.php.net\/package\/memcache) version >= 2.0.0 is installed
\n$rcmail_config[‘session_storage’] = ‘db’;<\/p>\n

\/\/ Use these hosts for accessing memcached
\n\/\/ Define any number of hosts in the form of hostname:port or unix:\/\/\/path\/to\/socket.file
\n$rcmail_config[‘memcache_hosts’] = NULL; \/\/ e.g. array( ‘localhost:11211’, ‘192.168.1.12:11211’, ‘unix:\/\/\/var\/tmp\/memcached.sock’ );<\/p>\n

\/\/ check client IP in session athorization
\n$rcmail_config[‘ip_check’] = false;<\/p>\n

\/\/ check referer of incoming requests
\n$rcmail_config[‘referer_check’] = false;<\/p>\n

\/\/ X-Frame-Options HTTP header value sent to prevent from Clickjacking.
\n\/\/ Possible values: sameorigin|deny. Set to false in order to disable sending them
\n$rcmail_config[‘x_frame_options’] = ‘sameorigin’;<\/p>\n

\/\/ this key is used to encrypt the users imap password which is stored
\n\/\/ in the session record (and the client cookie if remember password is enabled).
\n\/\/ please provide a string of exactly 24 chars.
\n$rcmail_config[‘des_key’] = ‘K9ke+2j47tRzyOkiBEo8+TpJ’;<\/p>\n

\/\/ Automatically add this domain to user names for login
\n\/\/ Only for IMAP servers that require full e-mail addresses for login
\n\/\/ Specify an array with ‘host’ => ‘domain’ values to support multiple hosts
\n\/\/ Supported replacement variables:
\n\/\/ %h – user’s IMAP hostname
\n\/\/ %n – hostname ($_SERVER[‘SERVER_NAME’])
\n\/\/ %t – hostname without the first part
\n\/\/ %d – domain (http hostname $_SERVER[‘HTTP_HOST’] without the first part)
\n\/\/ %z – IMAP domain (IMAP hostname without the first part)
\n\/\/ For example %n = mail.domain.tld, %t = domain.tld
\n$rcmail_config[‘username_domain’] = ‘chances.com.br’;<\/p>\n

\/\/ This domain will be used to form e-mail addresses of new users
\n\/\/ Specify an array with ‘host’ => ‘domain’ values to support multiple hosts
\n\/\/ Supported replacement variables:
\n\/\/ %h – user’s IMAP hostname
\n\/\/ %n – http hostname ($_SERVER[‘SERVER_NAME’])
\n\/\/ %d – domain (http hostname without the first part)
\n\/\/ %z – IMAP domain (IMAP hostname without the first part)
\n\/\/ For example %n = mail.domain.tld, %t = domain.tld
\n$rcmail_config[‘mail_domain’] = ”;<\/p>\n

\/\/ Password charset.
\n\/\/ Use it if your authentication backend doesn’t support UTF-8.
\n\/\/ Defaults to ISO-8859-1 for backward compatibility
\n$rcmail_config[‘password_charset’] = ‘ISO-8859-1’;<\/p>\n

\/\/ How many seconds must pass between emails sent by a user
\n$rcmail_config[‘sendmail_delay’] = 0;<\/p>\n

\/\/ Maximum number of recipients per message. Default: 0 (no limit)
\n$rcmail_config[‘max_recipients’] = 0;<\/p>\n

\/\/ Maximum allowednumber of members of an address group. Default: 0 (no limit)
\n\/\/ If ‘max_recipients’ is set this value should be less or equal
\n$rcmail_config[‘max_group_members’] = 0;<\/p>\n

\/\/ add this user-agent to message headers when sending
\n$rcmail_config[‘useragent’] = ‘Roundcube Webmail’;<\/p>\n

\/\/ use this name to compose page titles
\n$rcmail_config[‘product_name’] = ‘Chances Webmail’;<\/p>\n

\/\/ try to load host-specific configuration
\n\/\/ see http:\/\/trac.roundcube.net\/wiki\/Howto_Config for more details
\n$rcmail_config[‘include_host_config’] = false;<\/p>\n

\/\/ path to a text file which will be added to each sent message
\n\/\/ paths are relative to the Roundcube root folder
\n$rcmail_config[‘generic_message_footer’] = ‘webmail’;<\/p>\n

\/\/ path to a text file which will be added to each sent HTML message
\n\/\/ paths are relative to the Roundcube root folder
\n$rcmail_config[‘generic_message_footer_html’] = ”;<\/p>\n

\/\/ add a received header to outgoing mails containing the creators IP and hostname
\n$rcmail_config[‘http_received_header’] = false;<\/p>\n

\/\/ Whether or not to encrypt the IP address and the host name
\n\/\/ these could, in some circles, be considered as sensitive information;
\n\/\/ however, for the administrator, these could be invaluable help
\n\/\/ when tracking down issues.
\n$rcmail_config[‘http_received_header_encrypt’] = false;<\/p>\n

\/\/ This string is used as a delimiter for message headers when sending
\n\/\/ a message via mail() function. Leave empty for auto-detection
\n$rcmail_config[‘mail_header_delimiter’] = NULL;<\/p>\n

\/\/ number of chars allowed for line when wrapping text.
\n\/\/ text wrapping is done when composing\/sending messages
\n$rcmail_config[‘line_length’] = 72;<\/p>\n

\/\/ send plaintext messages as format=flowed
\n$rcmail_config[‘send_format_flowed’] = true;<\/p>\n

\/\/ According to RFC2298, return receipt envelope sender address must be empty.
\n\/\/ If this option is true, Roundcube will use user’s identity as envelope sender for MDN responses.
\n$rcmail_config[‘mdn_use_from’] = false;<\/p>\n

\/\/ Set identities access level:
\n\/\/ 0 – many identities with possibility to edit all params
\n\/\/ 1 – many identities with possibility to edit all params but not email address
\n\/\/ 2 – one identity with possibility to edit all params
\n\/\/ 3 – one identity with possibility to edit all params but not email address
\n\/\/ 4 – one identity with possibility to edit only signature
\n$rcmail_config[‘identities_level’] = 0;<\/p>\n

\/\/ Mimetypes supported by the browser.
\n\/\/ attachments of these types will open in a preview window
\n\/\/ either a comma-separated list or an array: ‘text\/plain,text\/html,text\/xml,image\/jpeg,image\/gif,image\/png,application\/pdf’
\n$rcmail_config[‘client_mimetypes’] = NULL; # null == default<\/p>\n

\/\/ Path to a local mime magic database file for PHPs finfo extension.
\n\/\/ Set to null if the default path should be used.
\n$rcmail_config[‘mime_magic’] = ‘\/usr\/share\/misc\/magic’;<\/p>\n

\/\/ Absolute path to a local mime.types mapping table file.
\n\/\/ This is used to derive mime-types from the filename extension or vice versa.
\n\/\/ Such a file is usually part of the apache webserver. If you don’t find a file named mime.types on your system,
\n\/\/ download it from http:\/\/svn.apache.org\/repos\/asf\/httpd\/httpd\/trunk\/docs\/conf\/mime.types
\n$rcmail_config[‘mime_types’] = NULL;<\/p>\n

\/\/ path to imagemagick identify binary
\n$rcmail_config[‘im_identify_path’] = NULL;<\/p>\n

\/\/ path to imagemagick convert binary
\n$rcmail_config[‘im_convert_path’] = NULL;<\/p>\n

\/\/ Size of thumbnails from image attachments displayed below the message content.
\n\/\/ Note: whether images are displayed at all depends on the ‘inline_images’ option.
\n\/\/ Set to 0 to display images in full size.
\n$rcmail_config[‘image_thumbnail_size’] = 240;<\/p>\n

\/\/ maximum size of uploaded contact photos in pixel
\n$rcmail_config[‘contact_photo_size’] = 160;<\/p>\n

\/\/ Enable DNS checking for e-mail address validation
\n$rcmail_config[‘email_dns_check’] = false;<\/p>\n

\/\/ Disables saving sent messages in Sent folder (like gmail) (Default: false)
\n\/\/ Note: useful when SMTP server stores sent mail in user mailbox
\n$rcmail_config[‘no_save_sent_messages’] = false;<\/p>\n

\/\/ ———————————-
\n\/\/ PLUGINS
\n\/\/ ———————————-<\/p>\n

\/\/ List of active plugins (in plugins\/ directory)<\/p>\n

\/\/$rcmail_config[‘plugins’] = array(qmailadmin);
\n$rcmail_config[‘plugins’] = array(‘plugin_manager’);
\n\/\/<\/p>\n

\/\/ ———————————-
\n\/\/ USER INTERFACE
\n\/\/ ———————————-<\/p>\n

\/\/ default messages sort column. Use empty value for default server’s sorting,
\n\/\/ or ‘arrival’, ‘date’, ‘subject’, ‘from’, ‘to’, ‘fromto’, ‘size’, ‘cc’
\n$rcmail_config[‘message_sort_col’] = ”;<\/p>\n

\/\/ default messages sort order
\n$rcmail_config[‘message_sort_order’] = ‘DESC’;<\/p>\n

\/\/ These cols are shown in the message list. Available cols are:
\n\/\/ subject, from, to, fromto, cc, replyto, date, size, status, flag, attachment, ‘priority’
\n$rcmail_config[‘list_cols’] = array(‘subject’, ‘status’, ‘fromto’, ‘date’, ‘size’, ‘flag’, ‘attachment’);<\/p>\n

\/\/ the default locale setting (leave empty for auto-detection)
\n\/\/ RFC1766 formatted language name like en_US, de_DE, de_CH, fr_FR, pt_BR
\n$rcmail_config[‘language’] = ‘pt_BR’;<\/p>\n

\/\/ use this format for date display (date or strftime format)
\n$rcmail_config[‘date_format’] = ‘d-m-Y’;<\/p>\n

\/\/ give this choice of date formats to the user to select from
\n\/\/ Note: do not use ambiguous formats like m\/d\/Y
\n$rcmail_config[‘date_formats’] = array(‘Y-m-d’, ‘d-m-Y’, ‘Y\/m\/d’, ‘m\/d\/Y’, ‘d\/m\/Y’, ‘d.m.Y’, ‘j.n.Y’);<\/p>\n

\/\/ use this format for time display (date or strftime format)
\n$rcmail_config[‘time_format’] = ‘H:i’;<\/p>\n

\/\/ give this choice of time formats to the user to select from
\n$rcmail_config[‘time_formats’] = array(‘G:i’, ‘H:i’, ‘g:i a’, ‘h:i A’);<\/p>\n

\/\/ use this format for short date display (derived from date_format and time_format)
\n$rcmail_config[‘date_short’] = ‘D H:i’;<\/p>\n

\/\/ use this format for detailed date\/time formatting (derived from date_format and time_format)
\n$rcmail_config[‘date_long’] = ‘d-mY H:i’;<\/p>\n

\/\/ store draft message is this mailbox
\n\/\/ leave blank if draft messages should not be stored
\n\/\/ NOTE: Use folder names with namespace prefix (INBOX. on Courier-IMAP)
\n$rcmail_config[‘drafts_mbox’] = ‘Drafts’;<\/p>\n

\/\/ store spam messages in this mailbox
\n\/\/ NOTE: Use folder names with namespace prefix (INBOX. on Courier-IMAP)
\n$rcmail_config[‘junk_mbox’] = ‘Junk’;<\/p>\n

\/\/ store sent message is this mailbox
\n\/\/ leave blank if sent messages should not be stored
\n\/\/ NOTE: Use folder names with namespace prefix (INBOX. on Courier-IMAP)
\n$rcmail_config[‘sent_mbox’] = ‘Sent’;<\/p>\n

\/\/ move messages to this folder when deleting them
\n\/\/ leave blank if they should be deleted directly
\n\/\/ NOTE: Use folder names with namespace prefix (INBOX. on Courier-IMAP)
\n$rcmail_config[‘trash_mbox’] = ‘Trash’;<\/p>\n

\/\/ display these folders separately in the mailbox list.
\n\/\/ these folders will also be displayed with localized names
\n\/\/ NOTE: Use folder names with namespace prefix (INBOX. on Courier-IMAP)
\n$rcmail_config[‘default_folders’] = array(‘INBOX’, ‘Drafts’, ‘Sent’, ‘Junk’, ‘Trash’);<\/p>\n

\/\/ automatically create the above listed default folders on first login
\n$rcmail_config[‘create_default_folders’] = true;<\/p>\n

\/\/ protect the default folders from renames, deletes, and subscription changes
\n$rcmail_config[‘protect_default_folders’] = true;<\/p>\n

\/\/ if in your system 0 quota means no limit set this option to true
\n$rcmail_config[‘quota_zero_as_unlimited’] = false;<\/p>\n

\/\/ Make use of the built-in spell checker. It is based on GoogieSpell.
\n\/\/ Since Google only accepts connections over https your PHP installatation
\n\/\/ requires to be compiled with Open SSL support
\n$rcmail_config[‘enable_spellcheck’] = true;<\/p>\n

\/\/ Enables spellchecker exceptions dictionary.
\n\/\/ Setting it to ‘shared’ will make the dictionary shared by all users.
\n$rcmail_config[‘spellcheck_dictionary’] = false;<\/p>\n

\/\/ Set the spell checking engine. ‘googie’ is the default. ‘pspell’ is also available,
\n\/\/ but requires the Pspell extensions. When using Nox Spell Server, also set ‘googie’ here.
\n$rcmail_config[‘spellcheck_engine’] = ‘googie’;<\/p>\n

\/\/ For a locally installed spellcheker, specify the URI to call it, for example:
\n\/\/ ‘http:\/\/’ . $_SERVER[‘HTTP_HOST’] . ‘\/spellchecker.php?lang=’
\n\/\/ Leave empty to use the Google spell checking service, what means
\n\/\/ that the message content will be sent to Google in order to check spelling
\n$rcmail_config[‘spellcheck_uri’] = ”;<\/p>\n

\/\/ These languages can be selected for spell checking.
\n\/\/ Configure as a PHP style hash array: array(‘en’=>’English’, ‘de’=>’Deutsch’);
\n\/\/ Leave empty for default set of available language.
\n$rcmail_config[‘spellcheck_languages’] = NULL;<\/p>\n

\/\/ Makes that words with all letters capitalized will be ignored (e.g. GOOGLE)
\n$rcmail_config[‘spellcheck_ignore_caps’] = false;<\/p>\n

\/\/ Makes that words with numbers will be ignored (e.g. g00gle)
\n$rcmail_config[‘spellcheck_ignore_nums’] = false;<\/p>\n

\/\/ Makes that words with symbols will be ignored (e.g. g@@gle)
\n$rcmail_config[‘spellcheck_ignore_syms’] = false;<\/p>\n

\/\/ Use this char\/string to separate recipients when composing a new message
\n$rcmail_config[‘recipients_separator’] = ‘,’;<\/p>\n

\/\/ don’t let users set pagesize to more than this value if set
\n$rcmail_config[‘max_pagesize’] = 1000;<\/p>\n

\/\/ Minimal value of user’s ‘refresh_interval’ setting (in seconds)
\n$rcmail_config[‘min_refresh_interval’] = 60;<\/p>\n

\/\/ Enables files upload indicator. Requires APC installed and enabled apc.rfc1867 option.
\n\/\/ By default refresh time is set to 1 second. You can set this value to true
\n\/\/ or any integer value indicating number of seconds.
\n$rcmail_config[‘upload_progress’] = true;<\/p>\n

\/\/ Specifies for how many seconds the Undo button will be available
\n\/\/ after object delete action. Currently used with supporting address book sources.
\n\/\/ Setting it to 0, disables the feature.
\n$rcmail_config[‘undo_timeout’] = 0;<\/p>\n

\/\/ ———————————-
\n\/\/ ADDRESSBOOK SETTINGS
\n\/\/ ———————————-<\/p>\n

\/\/ This indicates which type of address book to use. Possible choises:
\n\/\/ ‘sql’ (default), ‘ldap’ and ”.
\n\/\/ If set to ‘ldap’ then it will look at using the first writable LDAP
\n\/\/ address book as the primary address book and it will not display the
\n\/\/ SQL address book in the ‘Address Book’ view.
\n\/\/ If set to ” then no address book will be displayed or only the
\n\/\/ addressbook which is created by a plugin (like CardDAV).
\n$rcmail_config[‘address_book_type’] = ‘sql’;<\/p>\n

\/\/ In order to enable public ldap search, configure an array like the Verisign
\n\/\/ example further below. if you would like to test, simply uncomment the example.
\n\/\/ Array key must contain only safe characters, ie. a-zA-Z0-9_
\n$rcmail_config[‘ldap_public’] = array();<\/p>\n

\/\/ If you are going to use LDAP for individual address books, you will need to
\n\/\/ set ‘user_specific’ to true and use the variables to generate the appropriate DNs to access it.
\n\/\/
\n\/\/ The recommended directory structure for LDAP is to store all the address book entries
\n\/\/ under the users main entry, e.g.:
\n\/\/
\n\/\/ o=root
\n\/\/ ou=people
\n\/\/ uid=user@domain
\n\/\/ mail=contact@contactdomain
\n\/\/
\n\/\/ So the base_dn would be uid=%fu,ou=people,o=root
\n\/\/ The bind_dn would be the same as based_dn or some super user login.
\n\/*
\n * example config for Verisign directory
\n *
\n$rcmail_config[‘ldap_public’][‘Verisign’] = array(
\n ‘name’ => ‘Verisign.com’,
\n \/\/ Replacement variables supported in host names:
\n \/\/ %h – user’s IMAP hostname
\n \/\/ %n – hostname ($_SERVER[‘SERVER_NAME’])
\n \/\/ %t – hostname without the first part
\n \/\/ %d – domain (http hostname $_SERVER[‘HTTP_HOST’] without the first part)
\n \/\/ %z – IMAP domain (IMAP hostname without the first part)
\n \/\/ For example %n = mail.domain.tld, %t = domain.tld
\n ‘hosts’ => array(‘directory.verisign.com’),
\n ‘port’ => 389,
\n ‘use_tls’ => false,
\n ‘ldap_version’ => 3, \/\/ using LDAPv3
\n ‘network_timeout’ => 10, \/\/ The timeout (in seconds) for connect + bind arrempts. This is only supported in PHP >= 5.3.0 with OpenLDAP 2.x
\n ‘user_specific’ => false, \/\/ If true the base_dn, bind_dn and bind_pass default to the user’s IMAP login.
\n \/\/ %fu – The full username provided, assumes the username is an email
\n \/\/ address, uses the username_domain value if not an email address.
\n \/\/ %u – The username prior to the ‘@’.
\n \/\/ %d – The domain name after the ‘@’.
\n \/\/ %dc – The domain name hierarchal string e.g. “dc=test,dc=domain,dc=com”
\n \/\/ %dn – DN found by ldap search when search_filter\/search_base_dn are used
\n ‘base_dn’ => ”,
\n ‘bind_dn’ => ”,
\n ‘bind_pass’ => ”,
\n \/\/ It’s possible to bind for an individual address book
\n \/\/ The login name is used to search for the DN to bind with
\n ‘search_base_dn’ => ”,
\n ‘search_filter’ => ”, \/\/ e.g. ‘(&(objectClass=posixAccount)(uid=%u))’
\n \/\/ DN and password to bind as before searching for bind DN, if anonymous search is not allowed
\n ‘search_bind_dn’ => ”,
\n ‘search_bind_pw’ => ”,
\n \/\/ Default for %dn variable if search doesn’t return DN value
\n ‘search_dn_default’ => ”,
\n \/\/ Optional authentication identifier to be used as SASL authorization proxy
\n \/\/ bind_dn need to be empty
\n ‘auth_cid’ => ”,
\n \/\/ SASL authentication method (for proxy auth), e.g. DIGEST-MD5
\n ‘auth_method’ => ”,
\n \/\/ Indicates if the addressbook shall be hidden from the list.
\n \/\/ With this option enabled you can still search\/view contacts.
\n ‘hidden’ => false,
\n \/\/ Indicates if the addressbook shall not list contacts but only allows searching.
\n ‘searchonly’ => false,
\n \/\/ Indicates if we can write to the LDAP directory or not.
\n \/\/ If writable is true then these fields need to be populated:
\n \/\/ LDAP_Object_Classes, required_fields, LDAP_rdn
\n ‘writable’ => false,
\n \/\/ To create a new contact these are the object classes to specify
\n \/\/ (or any other classes you wish to use).
\n ‘LDAP_Object_Classes’ => array(‘top’, ‘inetOrgPerson’),
\n \/\/ The RDN field that is used for new entries, this field needs
\n \/\/ to be one of the search_fields, the base of base_dn is appended
\n \/\/ to the RDN to insert into the LDAP directory.
\n ‘LDAP_rdn’ => ‘cn’,
\n \/\/ The required fields needed to build a new contact as required by
\n \/\/ the object classes (can include additional fields not required by the object classes).
\n ‘required_fields’ => array(‘cn’, ‘sn’, ‘mail’),
\n ‘search_fields’ => array(‘mail’, ‘cn’), \/\/ fields to search in
\n \/\/ mapping of contact fields to directory attributes
\n \/\/ for every attribute one can specify the number of values (limit) allowed.
\n \/\/ default is 1, a wildcard * means unlimited
\n ‘fieldmap’ => array(
\n \/\/ Roundcube => LDAP:limit
\n ‘name’ => ‘cn’,
\n ‘surname’ => ‘sn’,
\n ‘firstname’ => ‘givenName’,
\n ‘jobtitle’ => ‘title’,
\n ‘email’ => ‘mail:*’,
\n ‘phone:home’ => ‘homePhone’,
\n ‘phone:work’ => ‘telephoneNumber’,
\n ‘phone:mobile’ => ‘mobile’,
\n ‘phone:pager’ => ‘pager’,
\n ‘street’ => ‘street’,
\n ‘zipcode’ => ‘postalCode’,
\n ‘region’ => ‘st’,
\n ‘locality’ => ‘l’,
\n \/\/ if you country is a complex object, you need to configure ‘sub_fields’ below
\n ‘country’ => ‘c’,
\n ‘organization’ => ‘o’,
\n ‘department’ => ‘ou’,
\n ‘jobtitle’ => ‘title’,
\n ‘notes’ => ‘description’,
\n \/\/ these currently don’t work:
\n \/\/ ‘phone:workfax’ => ‘facsimileTelephoneNumber’,
\n \/\/ ‘photo’ => ‘jpegPhoto’,
\n \/\/ ‘manager’ => ‘manager’,
\n \/\/ ‘assistant’ => ‘secretary’,
\n ),
\n \/\/ Map of contact sub-objects (attribute name => objectClass(es)), e.g. ‘c’ => ‘country’
\n ‘sub_fields’ => array(),
\n \/\/ Generate values for the following LDAP attributes automatically when creating a new record
\n ‘autovalues’ => array(
\n \/\/ ‘uid’ => ‘md5(microtime())’, \/\/ You may specify PHP code snippets which are then eval’ed
\n \/\/ ‘mail’ => ‘{givenname}.{sn}@mydomain.com’, \/\/ or composite strings with placeholders for existing attributes
\n ),
\n ‘sort’ => ‘cn’, \/\/ The field to sort the listing by.
\n ‘scope’ => ‘sub’, \/\/ search mode: sub|base|list
\n ‘filter’ => ‘(objectClass=inetOrgPerson)’, \/\/ used for basic listing (if not empty) and will be &’d with search queries. example: status=act
\n ‘fuzzy_search’ => true, \/\/ server allows wildcard search
\n ‘vlv’ => false, \/\/ Enable Virtual List View to more efficiently fetch paginated data (if server supports it)
\n ‘numsub_filter’ => ‘(objectClass=organizationalUnit)’, \/\/ with VLV, we also use numSubOrdinates to query the total number of records. Set this filter to get all numSubOrdinates attributes for counting
\n ‘sizelimit’ => ‘0’, \/\/ Enables you to limit the count of entries fetched. Setting this to 0 means no limit.
\n ‘timelimit’ => ‘0’, \/\/ Sets the number of seconds how long is spend on the search. Setting this to 0 means no limit.
\n ‘referrals’ => true|false, \/\/ Sets the LDAP_OPT_REFERRALS option. Mostly used in multi-domain Active Directory setups<\/p>\n

\/\/ definition for contact groups (uncomment if no groups are supported)
\n \/\/ for the groups base_dn, the user replacements %fu, %u, $d and %dc work as for base_dn (see above)
\n \/\/ if the groups base_dn is empty, the contact base_dn is used for the groups as well
\n \/\/ -> in this case, assure that groups and contacts are separated due to the concernig filters!
\n ‘groups’ => array(
\n ‘base_dn’ => ”,
\n ‘scope’ => ‘sub’, \/\/ search mode: sub|base|list
\n ‘filter’ => ‘(objectClass=groupOfNames)’,
\n ‘object_classes’ => array(“top”, “groupOfNames”),
\n ‘member_attr’ => ‘member’, \/\/ name of the member attribute, e.g. uniqueMember
\n ‘name_attr’ => ‘cn’, \/\/ attribute to be used as group name
\n ),
\n);
\n*\/<\/p>\n

\/\/ An ordered array of the ids of the addressbooks that should be searched
\n\/\/ when populating address autocomplete fields server-side. ex: array(‘sql’,’Verisign’);
\n$rcmail_config[‘autocomplete_addressbooks’] = array(‘sql’);<\/p>\n

\/\/ The minimum number of characters required to be typed in an autocomplete field
\n\/\/ before address books will be searched. Most useful for LDAP directories that
\n\/\/ may need to do lengthy results building given overly-broad searches
\n$rcmail_config[‘autocomplete_min_length’] = 1;<\/p>\n

\/\/ Number of parallel autocomplete requests.
\n\/\/ If there’s more than one address book, n parallel (async) requests will be created,
\n\/\/ where each request will search in one address book. By default (0), all address
\n\/\/ books are searched in one request.
\n$rcmail_config[‘autocomplete_threads’] = 0;<\/p>\n

\/\/ Max. numer of entries in autocomplete popup. Default: 15.
\n$rcmail_config[‘autocomplete_max’] = 15;<\/p>\n

\/\/ show address fields in this order
\n\/\/ available placeholders: {street}, {locality}, {zipcode}, {country}, {region}
\n$rcmail_config[‘address_template’] = ‘{street}
{locality} {zipcode}
{country} {region}’;<\/p>\n

\/\/ Matching mode for addressbook search (including autocompletion)
\n\/\/ 0 – partial (*abc*), default
\n\/\/ 1 – strict (abc)
\n\/\/ 2 – prefix (abc*)
\n\/\/ Note: For LDAP sources fuzzy_search must be enabled to use ‘partial’ or ‘prefix’ mode
\n$rcmail_config[‘addressbook_search_mode’] = 0;<\/p>\n

\/\/ ———————————-
\n\/\/ USER PREFERENCES
\n\/\/ ———————————-<\/p>\n

\/\/ Use this charset as fallback for message decoding
\n$rcmail_config[‘default_charset’] = ‘ISO-8859-1’;<\/p>\n

\/\/ skin name: folder from skins\/
\n$rcmail_config[‘skin’] = ‘googie_larry’;<\/p>\n

\/\/ show up to X items in messages list view
\n$rcmail_config[‘mail_pagesize’] = 50;<\/p>\n

\/\/ show up to X items in contacts list view
\n$rcmail_config[‘addressbook_pagesize’] = 50;<\/p>\n

\/\/ sort contacts by this col (preferably either one of name, firstname, surname)
\n$rcmail_config[‘addressbook_sort_col’] = ‘surname’;<\/p>\n

\/\/ the way how contact names are displayed in the list
\n\/\/ 0: display name
\n\/\/ 1: (prefix) firstname middlename surname (suffix)
\n\/\/ 2: (prefix) surname firstname middlename (suffix)
\n\/\/ 3: (prefix) surname, firstname middlename (suffix)
\n$rcmail_config[‘addressbook_name_listing’] = 0;<\/p>\n

\/\/ use this timezone to display date\/time
\n\/\/ valid timezone identifers are listed here: php.net\/manual\/en\/timezones.php
\n\/\/ ‘auto’ will use the browser’s timezone settings
\n$rcmail_config[‘timezone’] = ‘America\/Sao_Paulo’;<\/p>\n

\/\/ prefer displaying HTML messages
\n$rcmail_config[‘prefer_html’] = true;<\/p>\n

\/\/ display remote inline images
\n\/\/ 0 – Never, always ask
\n\/\/ 1 – Ask if sender is not in address book
\n\/\/ 2 – Always show inline images
\n$rcmail_config[‘show_images’] = 2;<\/p>\n

\/\/ open messages in new window
\n$rcmail_config[‘message_extwin’] = false;<\/p>\n

\/\/ open message compose form in new window
\n$rcmail_config[‘compose_extwin’] = false;<\/p>\n

\/\/ compose html formatted messages by default
\n\/\/ 0 – never, 1 – always, 2 – on reply to HTML message, 3 – on forward or reply to HTML message
\n$rcmail_config[‘htmleditor’] = 1;<\/p>\n

\/\/ show pretty dates as standard
\n$rcmail_config[‘prettydate’] = true;<\/p>\n

\/\/ save compose message every 300 seconds (5min)
\n$rcmail_config[‘draft_autosave’] = 60;<\/p>\n

\/\/ default setting if preview pane is enabled
\n$rcmail_config[‘preview_pane’] = false;<\/p>\n

\/\/ Mark as read when viewed in preview pane (delay in seconds)
\n\/\/ Set to -1 if messages in preview pane should not be marked as read
\n$rcmail_config[‘preview_pane_mark_read’] = 0;<\/p>\n

\/\/ Clear Trash on logout
\n$rcmail_config[‘logout_purge’] = false;<\/p>\n

\/\/ Compact INBOX on logout
\n$rcmail_config[‘logout_expunge’] = false;<\/p>\n

\/\/ Display attached images below the message body
\n$rcmail_config[‘inline_images’] = true;<\/p>\n

\/\/ Encoding of long\/non-ascii attachment names:
\n\/\/ 0 – Full RFC 2231 compatible
\n\/\/ 1 – RFC 2047 for ‘name’ and RFC 2231 for ‘filename’ parameter (Thunderbird’s default)
\n\/\/ 2 – Full 2047 compatible
\n$rcmail_config[‘mime_param_folding’] = 0;<\/p>\n

\/\/ Set true if deleted messages should not be displayed
\n\/\/ This will make the application run slower
\n$rcmail_config[‘skip_deleted’] = false;<\/p>\n

\/\/ Set true to Mark deleted messages as read as well as deleted
\n\/\/ False means that a message’s read status is not affected by marking it as deleted
\n$rcmail_config[‘read_when_deleted’] = true;<\/p>\n

\/\/ Set to true to never delete messages immediately
\n\/\/ Use ‘Purge’ to remove messages marked as deleted
\n$rcmail_config[‘flag_for_deletion’] = false;<\/p>\n

\/\/ Default interval for auto-refresh requests (in seconds)
\n\/\/ These are requests for system state updates e.g. checking for new messages, etc.
\n\/\/ Setting it to 0 disables the feature.
\n$rcmail_config[‘refresh_interval’] = 60;<\/p>\n

\/\/ If true all folders will be checked for recent messages
\n$rcmail_config[‘check_all_folders’] = false;<\/p>\n

\/\/ If true, after message delete\/move, the next message will be displayed
\n$rcmail_config[‘display_next’] = false;<\/p>\n

\/\/ 0 – Do not expand threads
\n\/\/ 1 – Expand all threads automatically
\n\/\/ 2 – Expand only threads with unread messages
\n$rcmail_config[‘autoexpand_threads’] = 2;<\/p>\n

\/\/ When replying:
\n\/\/ -1 – don’t cite the original message
\n\/\/ 0 – place cursor below the original message
\n\/\/ 1 – place cursor above original message (top posting)
\n$rcmail_config[‘reply_mode’] = false;<\/p>\n

\/\/ When replying strip original signature from message
\n$rcmail_config[‘strip_existing_sig’] = true;<\/p>\n

\/\/ Show signature:
\n\/\/ 0 – Never
\n\/\/ 1 – Always
\n\/\/ 2 – New messages only
\n\/\/ 3 – Forwards and Replies only
\n$rcmail_config[‘show_sig’] = 1;<\/p>\n

\/\/ Use MIME encoding (quoted-printable) for 8bit characters in message body
\n$rcmail_config[‘force_7bit’] = false;<\/p>\n

\/\/ Defaults of the search field configuration.
\n\/\/ The array can contain a per-folder list of header fields which should be considered when searching
\n\/\/ The entry with key ‘*’ stands for all folders which do not have a specific list set.
\n\/\/ Please note that folder names should to be in sync with $rcmail_config[‘default_folders’]
\n$rcmail_config[‘search_mods’] = NULL; \/\/ Example: array(‘*’ => array(‘subject’=>1, ‘from’=>1), ‘Sent’ => array(‘subject’=>1, ‘to’=>1));<\/p>\n

\/\/ Defaults of the addressbook search field configuration.
\n$rcmail_config[‘addressbook_search_mods’] = NULL; \/\/ Example: array(‘name’=>1, ‘firstname’=>1, ‘surname’=>1, ‘email’=>1, ‘*’=>1);<\/p>\n

\/\/ ‘Delete always’
\n\/\/ This setting reflects if mail should be always deleted
\n\/\/ when moving to Trash fails. This is necessary in some setups
\n\/\/ when user is over quota and Trash is included in the quota.
\n$rcmail_config[‘delete_always’] = false;<\/p>\n

\/\/ Directly delete messages in Junk instead of moving to Trash
\n$rcmail_config[‘delete_junk’] = false;<\/p>\n

\/\/ Behavior if a received message requests a message delivery notification (read receipt)
\n\/\/ 0 = ask the user, 1 = send automatically, 2 = ignore (never send or ask)
\n\/\/ 3 = send automatically if sender is in addressbook, otherwise ask the user
\n\/\/ 4 = send automatically if sender is in addressbook, otherwise ignore
\n$rcmail_config[‘mdn_requests’] = 0;<\/p>\n

\/\/ Return receipt checkbox default state
\n$rcmail_config[‘mdn_default’] = 0;<\/p>\n

\/\/ Delivery Status Notification checkbox default state
\n\/\/ Note: This can be used only if smtp_server is non-empty
\n$rcmail_config[‘dsn_default’] = 0;<\/p>\n

\/\/ Place replies in the folder of the message being replied to
\n$rcmail_config[‘reply_same_folder’] = false;<\/p>\n

\/\/ Sets default mode of Forward feature to “forward as attachment”
\n$rcmail_config[‘forward_attachment’] = false;<\/p>\n

\/\/ Defines address book (internal index) to which new contacts will be added
\n\/\/ By default it is the first writeable addressbook.
\n\/\/ Note: Use ‘0’ for built-in address book.
\n$rcmail_config[‘default_addressbook’] = true;<\/p>\n

\/\/ Enables spell checking before sending a message.
\n$rcmail_config[‘spellcheck_before_send’] = false;<\/p>\n

\/\/ Skip alternative email addresses in autocompletion (show one address per contact)
\n$rcmail_config[‘autocomplete_single’] = false;<\/p>\n

\/\/ Default font for composed HTML message.
\n\/\/ Supported values: Andale Mono, Arial, Arial Black, Book Antiqua, Courier New,
\n\/\/ Georgia, Helvetica, Impact, Tahoma, Terminal, Times New Roman, Trebuchet MS, Verdana
\n$rcmail_config[‘default_font’] = ”;<\/p>\n

\/\/ end of config file<\/p>\n

vim\/usr\/local\/www\/roundcube\/config\/db.inc.php<\/strong>
\n\n","protected":false},"excerpt":{"rendered":"

Verificando a vers\u00e3o do roundcube atual pkg_info -Ix roundcube pkg_info -R roundcube”*” Atualizar o ports portsnap fetch portsnap update Iremos instalar algumas aplica\u00e7\u00f5es necess\u00e1rias ao funcionamento visual de novas vers\u00f5es do roundcube pkg_add -rv perl (ou instale do ports) cd \/usr\/ports\/ftp\/curl\/ make install clean cd…<\/p>\n","protected":false},"author":1,"featured_media":726,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[10],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/719"}],"collection":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=719"}],"version-history":[{"count":4,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/719\/revisions"}],"predecessor-version":[{"id":728,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/719\/revisions\/728"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/media\/726"}],"wp:attachment":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}