Author Topic: Config Error... Upgrading From v0.9.5 to v1.0RC  (Read 9600 times)

Offline clifton11221

  • Jr. Member
  • **
  • Posts: 17
Config Error... Upgrading From v0.9.5 to v1.0RC
« on: April 04, 2014, 06:16:58 PM »
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]
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.

« Last Edit: April 04, 2014, 06:20:08 PM by clifton11221 »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: Config Error... Upgrading From v0.9.5 to v1.0RC
« Reply #1 on: April 05, 2014, 01:08:02 AM »
Then you'll need to add it.

Offline clifton11221

  • Jr. Member
  • **
  • Posts: 17
Re: Config Error... Upgrading From v0.9.5 to v1.0RC
« Reply #2 on: April 05, 2014, 03:12:08 PM »
OK... I manually added it, ran it again and now I'm getting the following error:

Code: [Select]
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]
<?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;
« Last Edit: April 07, 2014, 02:18:57 PM by clifton11221 »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: Config Error... Upgrading From v0.9.5 to v1.0RC
« Reply #3 on: April 05, 2014, 06:02:08 PM »
You can manually run the SQL files to update the database. They are in the SQL folder in the main Roundcube folder.

Offline clifton11221

  • Jr. Member
  • **
  • Posts: 17
Re: Config Error... Upgrading From v0.9.5 to v1.0RC
« Reply #4 on: April 06, 2014, 12:41:49 AM »
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?

Offline clifton11221

  • Jr. Member
  • **
  • Posts: 17
Re: Config Error... Upgrading From v0.9.5 to v1.0RC
« Reply #5 on: April 07, 2014, 02:20:55 PM »
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.

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: Config Error... Upgrading From v0.9.5 to v1.0RC
« Reply #6 on: April 07, 2014, 04:33:34 PM »
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.

Offline clifton11221

  • Jr. Member
  • **
  • Posts: 17
Re: Config Error... Upgrading From v0.9.5 to v1.0RC
« Reply #7 on: April 09, 2014, 04:00:21 PM »
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]
-- 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]
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;

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: Config Error... Upgrading From v0.9.5 to v1.0RC
« Reply #8 on: April 10, 2014, 01:51:07 AM »
It looks like there not doing it anymore, if you look at the 2013011000.sql file and earlier they have the comments.