Roundcube Database Connection Error
Stuart Naylor
stuartiannaylor at thursbygarden.org
Mon Aug 4 21:27:56 CEST 2014
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
Its a new install with kolab 3.2 on debian 7.6
There is a database. Only one line in it though?
<?php
$config = array();
$config['db_dsnw'] = 'mysqli://roundcube:jAAAUQ6O1xogeEt@localhost/roundcube';
$config['session_domain'] = '';
$config['des_key'] = "SBKtYub3QqK4IW6k3lWHATAw";
$config['username_domain'] = 'kolab.lan';
$config['mail_domain'] = '';
// IMAP Server Settings
$config['default_host'] = 'tls://localhost';
$config['default_port'] = 143;
$config['imap_delimiter'] = '/';
$config['imap_force_lsub'] = true;
// Caching and storage settings
$config['imap_cache'] = 'db';
$config['imap_cache_ttl'] = '10d';
$config['messages_cache'] = 'db';
$config['message_cache_ttl'] = '10d';
$config['session_storage'] = 'db';
// SMTP Server Settings
$config['smtp_server'] = 'tls://localhost';
$config['smtp_port'] = 587;
$config['smtp_user'] = '%u';
$config['smtp_pass'] = '%p';
$config['smtp_helo_host'] = $_SERVER["HTTP_HOST"];
// LDAP Settings
$config['ldap_cache'] = 'db';
$config['ldap_cache_ttl'] = '1h';
// Kolab specific defaults
$config['product_name'] = 'Kolab Groupware';
$config['skin_logo'] = 'skins/kolab/images/kolab_logo.png';
$config['quota_zero_as_unlimited'] = false;
$config['login_lc'] = 2;
$config['auto_create_user'] = true;
$config['enable_installer'] = false;
// The SMTP server does not allow empty identities
$config['mdn_use_from'] = true;
// Plugins
$config['plugins'] = array(
'kolab_auth',
'acl',
'archive',
'calendar',
'jqueryui',
'kolab_activesync',
'kolab_addressbook',
'kolab_config',
'kolab_delegation',
'kolab_files',
'kolab_folders',
'libkolab',
'libcalendaring',
'managesieve',
'newmail_notifier',
'odfviewer',
'password',
'redundant_attachments',
'tasklist',
'threading_as_default',
// contextmenu must be after kolab_addressbook (#444)
'contextmenu',
);
// Do not show deleted messages, mark deleted messages as read,
// and flag them as deleted instead of moving them to the Trash
// folder.
$config['skip_deleted'] = true;
$config['read_when_deleted'] = true;
$config['flag_for_deletion'] = true;
$config['delete_always'] = true;
$config['session_lifetime'] = 180;
$config['password_charset'] = 'UTF-8';
$config['useragent'] = 'Kolab 3.1/Roundcube ' . RCUBE_VERSION;
$config['dont_override'] = Array('skin');
$config['message_sort_col'] = 'date';
$config['spellcheck_dictionary'] = true;
$config['spellcheck_ignore_caps'] = true;
$config['spellcheck_ignore_nums'] = true;
$config['spellcheck_ignore_syms'] = true;
$config['undo_timeout'] = 10;
$config['upload_progress'] = 2;
$config['address_template'] = '{street}<br/>{locality} {zipcode}<br/>{country} {region}';
$config['preview_pane'] = true;
$config['preview_pane_mark_read'] = 0;
$config['autoexpand_threads'] = 2;
$config['top_posting'] = 0;
$config['sig_above'] = false;
$config['mdn_requests'] = 0;
$config['mdn_default'] = false;
$config['dsn_default'] = false;
$config['reply_same_folder'] = false;
if (file_exists(RCUBE_CONFIG_DIR . '/' . $_SERVER["HTTP_HOST"] . '/' . basename(__FILE__))) {
include_once(RCUBE_CONFIG_DIR . '/' . $_SERVER["HTTP_HOST"] . '/' . basename(__FILE__));
}
// Re-apply mandatory settings here.
$config['debug_level'] = 0;
$config['devel_mode'] = false;
$config['log_driver'] = 'file';
$config['log_date_format'] = 'd-M-Y H:i:s,u O';
$config['syslog_id'] = 'roundcube';
$config['syslog_facility'] = LOG_USER;
$config['smtp_log'] = false;
$config['log_logins'] = true;
$config['log_session'] = false;
$config['sql_debug'] = false;
$config['memcache_debug'] = false;
$config['imap_debug'] = false;
$config['ldap_debug'] = false;
$config['smtp_debug'] = false;
$config['skin'] = 'larry';
$config['skin_include_php'] = false;
$config['mime_magic'] = null;
$config['im_identify_path'] = '/usr/bin/identify';
$config['im_convert_path'] = '/usr/bin/convert';
$config['log_dir'] = 'logs/';
$config['temp_dir'] = '/var/lib/roundcubemail/';
// Some additional default folders (archive plugin)
$config['archive_mbox'] = 'Archive';
// The Kolab daemon by default creates 'Spam'
$config['junk_mbox'] = 'Spam';
$config['default_folders'] = array('INBOX', 'Drafts', 'Sent', 'Spam', 'Trash', 'Archive');
$config['address_book_type'] = 'ldap';
$config['autocomplete_min_length'] = 3;
$config['autocomplete_threads'] = 0;
$config['autocomplete_max'] = 15;
$config['ldap_public'] = array(
'kolab_addressbook' => array(
'name' => 'Global Address Book',
'hosts' => Array('localhost'),
'port' => 389,
'use_tls' => false,
'base_dn' => 'ou=People,dc=kolab,dc=lan',
'user_specific' => true,
'bind_dn' => '%dn',
'bind_pass' => '',
'search_base_dn' => 'ou=People,dc=kolab,dc=lan',
'search_bind_dn' => 'uid=kolab-service,ou=Special Users,dc=kolab,dc=lan',
'search_bind_pw' => 'ITKuwsaAVledsrK',
'search_filter' => '(&(objectClass=inetOrgPerson)(mail=%fu))',
'writable' => false,
'LDAP_Object_Classes' => array("top", "inetOrgPerson"),
'required_fields' => array("cn", "sn", "mail"),
'LDAP_rdn' => 'uid',
'ldap_version' => 3, // using LDAPv3
'search_fields' => array('displayname', 'mail'),
'sort' => array('displayname', 'sn', 'givenname', 'cn'),
'scope' => 'sub',
'filter' => '(objectClass=inetOrgPerson)',
'vlv' => false,
'vlv_search' => false,
'fuzzy_search' => true,
'sizelimit' => '0',
'timelimit' => '0',
'fieldmap' => Array(
// Roundcube => LDAP
'name' => 'displayName',
'surname' => 'sn',
'firstname' => 'givenName',
'middlename' => 'initials',
'prefix' => 'title',
'email:primary' => 'mail',
'email:alias' => 'alias',
'email:personal' => 'mailalternateaddress',
'phone:main' => 'telephoneNumber',
'phone:work' => 'alternateTelephoneNumber',
'phone:mobile' => 'mobile',
'phone:work2' => 'blackberry',
'jobtitle' => 'title',
'manager' => 'manager',
'assistant' => 'secretary',
'photo' => 'jpegphoto'
),
'groups' => Array(
'base_dn' => 'ou=Groups,dc=kolab,dc=lan',
'filter' => '(&' . '(|(objectclass=groupofuniquenames)(objectclass=groupofurls))' . '(mail=*))',
'object_classes' => Array("top", "groupOfUniqueNames"),
'member_attr' => 'uniqueMember',
),
),
);
$config['autocomplete_addressbooks'] = Array(
'kolab_addressbook'
);
$config['autocomplete_single'] = true;
$config['htmleditor'] = 0;
$config['kolab_http_request'] = Array(
'ssl_verify_host' => false,
'ssl_verify_peer' => false,
);
?>
More information about the users
mailing list