Hi all.
I'm trying to install Roundcube 0.5.2 on a debian server using postgresql and I'm desperately looking for a tutorial, a how-to...
A pointer to any lead would be appreciated.
Here are more details concerning the context and the issue(s) I am facing.
Before last week-end, il was running a nice debian lenny with a roundcube (0.3, I believe) installed by decompressing an archive in /usr/share/roundcube.
After the upgrade to squeeze (which broke a few things...), I thought I might as well upgrade to a newer version of roundcube.
A backport package being provided, I decided to use it : http://packages.debian.org/squeeze-backports/roundcube (along with the package for pgsql, and all necessary dependencies)
It seems like a lot of things have changed between 0.3 and 0.5. Perhaps the debian packagers have introduced modifications as well.
The installation used to involve accessing roundcube through its web page (URL/installer) and following the online configuration (database, etc). It looks like this does not existe anymore.
Concerning the DB, the config used to go like : pgsql://roundcube:password@localhost/roundcube
and now it is in /etc/roundcube/debian-db.php, generated from /etc/dbconfig-common/roundcube.conf
(Or perhaps is this specific to debian packaging ?)
Apparently I did not manage to configure the DB access correctly :
The error messages are :
On the web page DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator.
/var/log/apache2/error.log MDB2 Error: not found (-4): no RDBMS driver specified
/var/log/roundcube/errors DB Error: no RDBMS driver specified in /usr/share/roundcube/program/include/rcube_mdb2.php on line 101 (GET /)
I believe I entered the correct access parameters but I don't know where I indicated that postgresql is to be used (except when choosing its only .deb package).
/etc/roundcube/debian-db.php :
$dbuser='roundcube';
$dbpass='password';
$basepath='';
$dbname='roundcube';
$dbserver='';
$dbport='';
$dbtype='';
(It is a single server installation).
I don't understand all parameters in /etc/dbconfig-common/roundcube.conf
# dbc_dbtype: type of underlying database to use # this exists primarily to let dbconfig-common know what database # type to use when a package supports multiple database types. # don't change this value unless you know for certain that this # package supports multiple database types dbc_dbtype=''
Should I modify dbc_dbtype ?
Is there a guide for these parameters, apart from the comments ? Am I supposed to modify this file anyway ? Or is there any installer I didn't find already ?
Remarks :
- First mistake, I thought the package would not install in the same place
as the installation I was already using, so I didn't move /usr/share/roundcube before processing. Therefore, I may have lost some of my old config (config directory was not modified, though). Anyway, it should not be an issue if I manage to get the new version up and running. I moved /usr/share/roundcube, then uninstalled through aptitude, then reinstalled, to get a clean directory. I don't think this is important but I might be wrong.
- I already have a database populated, so it's rather like an upgrade than
an installation, but I don't really mind losing it in the process : I've got a backup, and anyway, correct me if I'm wrong, but it is not much information (personnal settings, identities, and such, not a real issue for my users).
Thank you for any help. And sorry if it is an easy one, I swear I've been searching and I feel kinda stuck.
Mon, 4 Jul 2011 12:39:16 +0200 Jérôme a écrit:
Hi.
Still trying...
I figured out a lot of stuff since my first email (like dbconfig and all,...).
I'm now stuck a few steps further with "db.inc.php was not found" error.
I don't understand why db.inc.php is needed. I thought debian-db.php should do the trick, shouldn't it ?
Here's what I did :
I did a little bit of cleanup, since I had messed up in roundcube directories, and started again from zero using the backported 0.5 packages.
I issued a "dpkg-reconfigure -plow roundcube-core" and asked for the creation of a new DB, so as to ensure nothing from the former install interferes.
dpkg-reconfigure -plow roundcube-core dbconfig-common: writing config to /etc/dbconfig-common/roundcube.conf Replacing config file /etc/roundcube/debian-db.php with new version creating postgres user roundcube: already exists. resetting password: success. creating database roundcube_0_5: success. verifying database roundcube_0_5 exists: success. populating database via sql... warning: ident method specified but local account doesn't exist. warning: ident method specified but local account doesn't exist. done. dbconfig-common: flushing administrative password Reloading web server config: apache2
Here's what I have now :
/usr/share/roundcube $ ll total 64 -rw-r----- 1 root root 1494 Jul 5 20:58 apache.conf -rw-r--r-- 1 root root 1145 Feb 18 2010 .htaccess -rw-r--r-- 1 root root 10571 Apr 20 11:03 index.php -rw-r--r-- 1 root root 25890 Jun 2 12:43 main.inc.php.dist drwxr-xr-x 3 root root 4096 Jul 5 20:53 plugins drwxr-xr-x 7 root root 4096 Jul 5 20:53 program -rw-r--r-- 1 root root 26 Mar 22 2008 robots.txt drwxr-xr-x 3 root root 4096 Jul 5 20:53 skins
/etc/roundcube $ ll total 32 -rw-r----- 1 root www-data 546 Jul 5 23:01 debian-db.php -rw-r----- 1 root www-data 25828 Jul 5 21:01 main.inc.php
The new DB is created with the tables that are new to roundcube 0.5 (such as contactgroupmembers).
/etc/roundcube/debian-db.php seems to be correct : $dbuser='roundcube'; $dbpass='password'; $basepath=''; $dbname='roundcube_0_5'; $dbserver=''; $dbport=''; $dbtype='pgsql';
(As I said I don't think losing the content of the database should be an issue, and if it happenned to be, I suppose I might be able to sort this out using the old database and the commands in /usr/share/dbconfig-common/data/roundcube/upgrade/pgsql/0.5-1)
The complete error message is
CONFIGURATION ERROR db.inc.php was not found. Please read the INSTALL instructions!
Well I didn't find any INSTALL instructions.
dpkg -L roundcube-pgsql roundcube-core roundcube | grep INSTALL
yields nothing.
And http://trac.roundcube.net/wiki/Howto_Install does not seem appropriate, though I couldn't tell whether it is just outdated or whether it is due to debian specificities.
For instance, I don't have any installation or config directory. Should I create a config directory manually ? What should I put in there ?
Thanks for any help.
On Tue, 5 Jul 2011 23:41:33 +0200, Jérôme wrote:
see install in tarball, the error is only exists in debian, so dont blame roundcube maintainers, report this to bugs.debian.org to have deb packages fixed
On Wed, July 6, 2011 3:46 pm, Benny Pedersen wrote:
Hi.
Actually, I'm not blaming anyone but myself.
My first attempt was bound to fail, as I tried to be clever and did things I should'nt have.
For my second attempt, I decided to do it a cleaner way and started from zero. Failure again. I would blame neither roundcube nor debian for that. (I'm missing files that do appear in the debian package file lists. I wonder what happenned to them...)
Anyway my initial request was about a tutorial and I finally found one. It describes how to proceed in my configuration :
[fr] http://medspx.homelinux.org/blog/Debian/roundcube.html
Straightforward. No trick. It does not look like the debian packages need fixing.
It's pretty close to what I did, though. I'll try to sort this out as soon as I can.
Hi.
I added and chowned the missing db.inc... file manually in /etc/roundcube and it seems to be working fine.
I would't blame the mess on the debian package. People seem to be using it without an issue. I might have screwed up myself one way or another.
I didn't pay that much attention to the chanlelogs and I didn't see much difference with version 3 until I noticed the threading was implemented. Awesome ! Congratulations for that and for the other improvements. This webmail is really great work.
-
"Jérôme" -
Benny Pedersen -
Jérôme