Roundcube

From Wiki

Jump to: navigation, search

So a few people said to me how squirrelmail was slow and another few people who had 1000's of emails in their inbox and squirrelmail wouldn't cut it.

I did think of using ilohamail as it was on apt-get, but I heard and used roundcube before, so I said I'd go with that, even though it wasn't on apt-get for lenny.

Setup Roundcube on Debian Lenny with SQLite

As I only had a few users using webmail, sqlite would suffice. I chose to install via svn, as hopefully upgrading it will be nice and easy. I'll also have to keep an eye on the news and announcements: http://sourceforge.net/export/rss2_projnews.php?group_id=139281 and http://roundcube.net/news

cd /var/www/
mkdir roundcube
cd roundcube
svn co https://svn.roundcube.net/tags/roundcubemail/v0.3.1 .
#get latest version number from: https://svn.roundcube.net/tags/roundcubemail/
#choose p to accept cert.

chgrp -R www-data temp
chgrp -R www-data logs
chmod -R 775 temp
chmod -R 775 logs
#not sure how this will work when going svn sw to update. Might be easier to go chmod 777. Will see.

mkdir db
sqlite -init SQL/sqlite.initial.sql db/sqlite.db
#type .exit to exit sqlite.
chgrp -R www-data db
chmod -R 775 db

#Website http://url/roundcube/installer
#Next 3 lines may not be necessary:
#apt-get install sqlite2
#apt-get install php5-sqlite
#/etc/init.d/apache2 reload

#Step 2 of Installer:
#Database setup
SQLite - Database type
Database Server - blank
Database Name - /var/www/roundcube/db/sqlite.db
Database Username - blank
Database Password - blank

#IMAP Settings
default_host: ssl://mail.burkesys.com
default_port: 993

#SMTP Settings
smtp_server: mail.burkesys.com

#Display Settings
pagesize: 30
preview_pane: tick
draft_autosave: 3 min 

#Make the two files as asked.
#When at end of installer:
#chmod 000 installer (folder)

#Login.
#Couple of tweaks.
Login: Settings - Identities

Notes

I was happy I could use ssl on 993 as I have imap 143 blocked at the firewall. I think roundcube bottom posts (as opposed to top post) when replying to emails. I think this will be fixed down the line. It wasn't much of an issue.

Issues

chmod 777 or setting the permissions on sqlite.db was unsufficient on its own. The folder in which sqlite.db is located must be writable by the server (to create temp lock files). As a result I chose to create a db folder and to place sqlite.db in that! Otherwise you might get this error:

[08-Jan-2010 01:19:38 +0000]: DB Error: MDB2 Error: unknown error Query: _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO users (created, last_login, username, mail_host, alias, language) VALUES (now(), now(), 'sburke', 'localhost', , 'en_US')] [Native code: 14] [Native message: unable to open database file]  in /home/sburke/public_html/rc/roundcubemail-0.3.1/program/include/rcube_mdb2.php on line 627 (POST /stephen/rc/roundcubemail-0.3.1/?_task=&_action=login)
[08-Jan-2010 01:19:38] MDB2 Error: unknown error (-1): lastInsertID: [Error message: Could not get last insert ID]
[Last executed query: INSERT INTO users
       (created, last_login, username, mail_host, alias, language)
      VALUES (now(), now(), 'sburke', 'localhost', , 'en_US')]
[Native code: 14]
[Native message: unable to open database file]

The actual config for sqlite is:

$rcmail_config['db_dsnw'] = 'sqlite:////var/www/roundcube/db/sqlite.db?mode=0646';
#thats 4 forward slashes!!

Dont use sqlite3 to create the sqlite.db. It wont work. Looks good apart from that.

References: http://fak3r.com/2005/11/15/howto-install-roundcube-webmail-from-svn-was-cvs-on-freebsd/
http://www.roundcubeforum.net/5-release-support/18-resolved-issues/2247-sqlite-problem-solved.html
http://www.howtoforge.com/forums/archive/index.php/t-27452.html
http://trac.roundcube.net/wiki/Howto_Install

Personal tools