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