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 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.
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:
CONFIGURATION ERROR db.inc.php was not found. Please read the INSTALL instructions!
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:
On Tue, 5 Jul 2011 23:41:33 +0200, Jérôme wrote:
CONFIGURATION ERROR db.inc.php was not found. Please read the INSTALL instructions!
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
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