OK... I manually added it, ran it again and now I'm getting the following error:
Check DB config
DSN (write): OK
sh: /home2/myinfo/public_html/mail/bin/updatedb.sh: Permission denied
Database schema update failed.
DB Schema: NOT OK(Database schema differs)
Missing columns in table 'cache': expires
Missing table 'cache_shared'
Missing columns in table 'cache_index': expires
Missing columns in table 'cache_thread': expires
Missing columns in table 'cache_messages': expires
Is there an SQL I can run to manually update the database?
Here is my config file. Please let me know if something is wrong with it.
<?php
/* Local configuration for Roundcube Webmail */
// ----------------------------------
// SQL DATABASE
// ----------------------------------
// Database connection string (DSN) for read+write operations
// Format (compatible with PEAR MDB2): db_provider://user:password@host/database
// Currently supported db_providers: mysql, pgsql, sqlite, mssql or sqlsrv
// For examples see http://pear.php.net/manual/en/package.database.mdb2.intro-dsn.php
// NOTE: for SQLite use absolute path: 'sqlite:////full/path/to/sqlite.db?mode=0646'
$config['db_dsnw'] = 'mysql://mywebsiteinfo@localhost/mydbinfo';
// ----------------------------------
// 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 - http hostname ($_SERVER['SERVER_NAME'])
// %d - domain (http hostname without the first part)
// %s - domain name after the '@' from e-mail address provided at login screen
// For example %n = mail.domain.tld, %d = domain.tld
$config['default_host'] = 'localhost';
// SMTP username (if required) if you use %u as the username Roundcube
// will use the current username for login
$config['smtp_user'] = '%u';
// SMTP password (if required) if you use %p as the password Roundcube
// will use the current user's password for login
$config['smtp_pass'] = '%p';
// 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'] = '';
// use this folder to store log files (must be writeable for apache user)
// This is used by the 'file' log driver.
$config['log_dir'] = 'logs/';
// use this folder to store temp files (must be writeable for apache user)
$config['temp_dir'] = 'temp/';
// If users authentication is not case sensitive this must be enabled.
// You can also use it to force conversion of logins to lower case.
// After enabling it all user records need to be updated, e.g. with query:
// UPDATE users SET username = LOWER(username);
$config['login_lc'] = false;
// 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'] = 'TlTgVbw42GtKAV0VneGnnVmq';
// use this name to compose page titles
$config['product_name'] = 'My Website Webmail';
// add this user-agent to message headers when sending
$config['useragent'] = 'My Website Webmail/RCMAIL_VERSION';
# null == default
// mime magic database
$config['mime_magic'] = '/usr/share/misc/magic';
// ----------------------------------
// PLUGINS
// ----------------------------------
// List of active plugins (in plugins/ directory)
$config['plugins'] = array('markasjunk', 'password', 'plugin_manager');
// These cols are shown in the message list. Available cols are:
// subject, from, to, cc, replyto, date, size, status, flag, attachment, 'priority'
$config['list_cols'] = array('subject', 'status', 'from', 'date', 'size', 'flag', 'attachment');
// use this format for date display (date or strftime format)
$config['date_format'] = 'm/d/Y';
// give this choice of date formats to the user to select from
$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');
// use this format for time display (date or strftime format)
$config['time_format'] = 'g:i a';
// use this format for detailed date/time formatting (derived from date_format and time_format)
$config['date_long'] = 'm/d/Y H:i';
// automatically create the above listed default folders on first login
$config['create_default_folders'] = true;
// Set the spell checking engine. 'googie' is the default. 'pspell' is also available,
// but requires the Pspell extensions. When using Nox Spell Server, also set 'googie' here.
$config['spellcheck_engine'] = 'pspell';
// skin name: folder from skins/
$config['skin'] = 'default';
// use this timezone to display date/time
$config['timezone'] = 'America/New York';
// compose html formatted messages by default
// 0 - never, 1 - always, 2 - on reply to HTML message only
$config['htmleditor'] = 1;
// Encoding of long/non-ascii attachment names:
// 0 - Full RFC 2231 compatible
// 1 - RFC 2047 for 'name' and RFC 2231 for 'filename' parameter (Thunderbird's default)
// 2 - Full 2047 compatible
$config['mime_param_folding'] = 0;
// If true, after message delete/move, the next message will be displayed
$config['display_next'] = false;
// Behavior if a received message requests a message delivery notification (read receipt)
// 0 = ask the user, 1 = send automatically, 2 = ignore (never send or ask)
// 3 = send automatically if sender is in addressbook, otherwise ask the user
// 4 = send automatically if sender is in addressbook, otherwise ignore
$config['mdn_requests'] = 2;
// Return receipt checkbox default state
$config['mdn_default'] = 2;
// lifetime of message cache
// possible units: s, m, h, d, w
$config['message_cache_lifetime'] = '10d';
// When replying or forwarding place sender's signature above existing message
$config['sig_above'] = true;
$config['enable_installer'] = true;