Upgrading Roundcube from 0.9.5 to 1.1

[Thawee]

Hey everyone,

I am new to the forums, and I am trying to upgrade my roundcube from 0.9.5 to 1.1.

I am running ubuntu 14.04, and everything seems to go well until it tries to update the schema.

It fails with an unsupported driver error.

I am not sure how to get around this issue.

If anyone has an idea please let me know.

thanks!

[Thawee]

Bump

[SKaero]

What is the exact error?

[Thawee]

Sorry for the late reply,

Here is the exact output I get when running installto.sh

I installed it to my /var/lib/roundcube folder.

WARNING: Your configuration needs to be migrated!
We changed the configuration files structure and your two config files main.inc.php and db.inc.php have to be merged into one single file.
Do you want me to fix your local configuration? (y/N)
y
. backing up the current config file(s)...
. writing /var/lib/roundcube/config/config.inc.php...
Done.
Your configuration files are now up-to-date!
Executing database schema update.
ERROR: Configuration error. Unsupported database driver: All done.

I thought maybe the issue could be because I might have setup Roundcube to use sql-lite v3, but I noticed that when I checked mysql I have a database for roundcube, so I don't think my original thought was incorrect.

Any insight would be greatly appreciated.

Thanks for the reply

[SKaero]

What is in your $config['db_dsnw'] in the config.inc.php?

[Thawee]

Hi, It was set to Localhost, so I changed it to be this /$config['db_dsnw'] = 'mysql://<username>:PWD@localhost/roundcube/

Then I enabled $rcmail_config['enable_installer'] = true;

When I tried to run the http://<my site>/roundcube/installer

It wasn't there.  I image the reason is because i installed roundcube originally from apt-get install xxxx.

I copied my installer files from /var/lib/roundcube/installer to /var/www/html/rouncube I was able to access the installer.

I am now having an issue where I am unable to complete the installer and update my "mysql" database schema because the temp and log folders are not seen as writable.

Oddly enough, I am noticing that there are several locations where roundcube is installed.

/var/lib/roundcube
/etc/roundcube
/usr/share/roundcube
/var/www/html/roundcube

My understanding is that /var/lib/roundcube is the primary install location?

Anyhow, that's where I am at now

Thanks for your help  

[SKaero]

I can't comment on where the primary install location is since its not my server, but since you changed something in the /var/www/html/rouncube folder and the change showed up online I'd imagine thats the main folder.

[Thawee]

Is anyone familiar with how to update the roundcube mysql schema from 0.9.5 to 1.1?

[SKaero]

You can use the installer or you can the the update queries yourself.

[Thawee]

Interesting,

Any idea on how I can manually update the Mysql schema?

[ABerglund]

The schema update scripts the installer uses are found in the SQL folder in roundcubemail root.

[Thawee]

Thanks much appreciated,

I looked there, and it all looks like Greek to me, so how do I run the sql schema update scripts?

[Thawee]

Hey Everyone!

I wanted to give an update.

I was unable to correctly update from 0.9.5 stock install via apt-get with the latest version 1.1.1.

I am thinking the reason it wouldn't work is because in the stock install via apt-get it is customized and not standard.

I backed up all my install locations, and remove them.

I left the database in tact which worked out really well because when I started the install for 1.1.1 and configured the database it updated the schema from 0.9.5 to 1.1.1.

After that I was able to log into my email without much trouble.

Had a hick up with mail filtering but that was resolved by adjusting some settings.

Thanks for trying to help!

Cheers.