Config Error... Upgrading From v0.9.5 to v1.0RC

[clifton11221]

I'm attempting to upgrade from version 0.9.5 to 1.0RC.  However, I'm stuck at step 3 (updating my database) because I'm receiving the following error:

Code Select Expand

The installer is disabled!

To enable it again, set $config['enable_installer'] = true; in RCUBE_CONFIG_DIR/config.inc.php

But when I look inside of the config.inc.php file, $config['enable_installer'] isn't there.

My RC is installed here.

[SKaero]

Then you'll need to add it.

[clifton11221]

OK... I manually added it, ran it again and now I'm getting the following error:

Code Select Expand

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.

Code Select Expand

<?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;


[SKaero]

You can manually run the SQL files to update the database. They are in the SQL folder in the main Roundcube folder.

[clifton11221]

I'm using MySQL.  However, there's a file titled mysql.initial.sql and there's a MySQL folder with a bunch of sql files in it.  Which one should I use?

[clifton11221]

I used the file 2013061000.sql in the SQL folder.  I went through the queries line by line and all was well except for the edits for the "cache_shared" table.  It appeared that the edits for this table were already in place.

So far all appears to be well.  I'll post back if I have any problems.

[SKaero]

If you read the top of the sql files it tells you what version the code is from so you know which files need to be run.

[clifton11221]

If you read the top of the sql files it tells you what version the code is from so you know which files need to be run.

I don't see where it shows the version of the code...

This is the top of the mysql.initial.sql file:

Code Select Expand

-- Roundcube Webmail initial database structure


/*!40014  SET FOREIGN_KEY_CHECKS=0 */;

-- Table structure for table `session`

CREATE TABLE `session` (
`sess_id` varchar(128) NOT NULL,
`created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`ip` varchar(40) NOT NULL,
`vars` mediumtext NOT NULL,
PRIMARY KEY(`sess_id`),
INDEX `changed_index` (`changed`)
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;


-- Table structure for table `users`


And this is the top of the file 2013061000.sql:

Code Select Expand

ALTER TABLE `cache` ADD `expires` datetime DEFAULT NULL;
ALTER TABLE `cache_shared` ADD `expires` datetime DEFAULT NULL;
ALTER TABLE `cache_index` ADD `expires` datetime DEFAULT NULL;
ALTER TABLE `cache_thread` ADD `expires` datetime DEFAULT NULL;
ALTER TABLE `cache_messages` ADD `expires` datetime DEFAULT NULL;

-- initialize expires column with created/changed date + 7days
UPDATE `cache` SET `expires` = `created` + interval 604800 second;

[SKaero]

It looks like there not doing it anymore, if you look at the 2013011000.sql file and earlier they have the comments.