Re: [Webcollab-users] unable to connect to database after installation webcollab 3.00

[Andrew S. <and...@co...>]

On Wed, 04 Jan 2012 17:31:38 +0530
Bhuvan Krishna <bh...@sw...> wrote:

> I have debian OS on which i am able to run drupal instances with any 
> problem I use postgresql as the database. While trying to install 
> webcollab i get a problem with connecting to the database. I did the 
> following steps.
> 
> 1) unpack webcollab-3.00.tar.gz to collab directory in /var/www
> 2) changed permission of /var/www/collab/config/config.php to 777
> 3) changed permission of /var/www/collab/files/filebase to 777
> 
> 4) create a database and user with these commands
> createuser collab --pwprompt --encrypted
> createdb collab --owner=collab
> 
> 
> 5) access the setup page through http://localhost/collab/setup.php
> 
> 6) select english as the language
> 
> 7) select no at the option of creating a database by webcollab
> 
> 8) give the credentials of database and other options.
> 
> when i select re-enter i get ok at the database name and other options 
> but database user and database password don't give an error or warning. 
> at the end it says that webcollab was successfully installed and when i 
> select write the configuration file it gives me a page that says unable 
> to connect to database but user and password of webcollab are admin and 
> admin123.
> 
> I am unable to figure out the problem. I checked with postgresql config 
> files in /etc/postgresq/9.1/main/... everything is fine in their.
> 
> Regards,
> Bhuvan

Thanks for the detailed report.  I have a test machine running Debian, though it is Postgresql 8.4
(not 9.1).

It appears that all goes well until WebCollab tries to connect with the database to write the
configuration data.  The message that you are seeing is a graceful exit from a database error.

Could you enable 'debugging' in the config file and install again?  This would cause the error
message from the database to be printed to the screen, and would be very helpful.

Interesting that in Step 4 the username and password are accepted - this step also tries to connect
to the database to test the connection is working.

I will look at the code and Postgresql 9.1 for issues too.

Andrew