Thread: [Webcollab-users] unable to connect to database after installation webcollab 3.00
Brought to you by:
andrewsimpson
Menu
▾
▴
webcollab-users
|
From: Bhuvan K. <bh...@sw...> - 2012-01-04 12:22:15
|
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 |
|
From: Andrew S. <and...@co...> - 2012-01-04 20:14:31
|
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 |
|
From: Andrew S. <and...@co...> - 2012-01-04 20:25:22
|
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. > Actually, further to my previous email: Can you look in /var/log under apache2 and postgresql error logs and see what has been logged? I am sure there will be something interesting. Andrew |
|
From: Bhuvan K. <bh...@sw...> - 2012-01-05 10:40:09
|
Hi Andrew,
Thanks for the quick reply. If their is any irc channel were we
could discuss and work on the issue at the same time that would be
really helpful for me. I am available anytime just let me know when you
are free, If any one else is available for the irc meet even that is
encouraging. If you prefer mails even that is fine with me. I will check
with what you have told about enabling debug while installing webcollab.
Also i will check the logs and get back to you.
Regards,
Bhuvan
On Thursday 05 January 2012 01:40 AM, Andrew Simpson wrote:
> 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.
>>
> Actually, further to my previous email: Can you look in /var/log under apache2 and postgresql
> error logs and see what has been logged? I am sure there will be something interesting.
>
> Andrew
>
>
> ------------------------------------------------------------------------------
> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
> infrastructure or vast IT resources to deliver seamless, secure access to
> virtual desktops. With this all-in-one solution, easily deploy virtual
> desktops for less than the cost of PCs and save 60% on VDI infrastructure
> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
> _______________________________________________
> Webcollab-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/webcollab-users
|
|
From: Bhuvan K. <bh...@sw...> - 2012-01-05 11:05:03
|
I am attaching the relavent log details from apache, postgresql and webcollab. I enabled debug in the config.php and tried installing. I got this error on the screen. Database server error: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "site_name" does not exist LINE 1: UPDATE site_name SET manager_name='WebCollab Project Managem... ^ check the attachments for more details. Regards, Bhuvan |
|
From: Andrew S. <and...@co...> - 2012-01-05 19:41:12
|
On Thu, 05 Jan 2012 16:34:47 +0530 Bhuvan Krishna <bh...@sw...> wrote: > I am attaching the relavent log details from apache, postgresql and > webcollab. I enabled debug in the config.php and tried installing. I got > this error on the screen. > > Database server error: > SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "site_name" does not > exist LINE 1: UPDATE site_name SET manager_name='WebCollab Project > Managem... ^ > > check the attachments for more details. > > Regards, > Bhuvan Bhuvan, Thanks. That's not too hard to fix. What has happened is that you've created the database manually, but not created the tables from the database schema. This is why WebCollab can connect to the database, but fails to insert data into the (non-existent) tables. The database table schema is in [webcollab]/db and is 'schema-pgsql.sql'. There are some instructions in [webcollab]/docs, but basically something like this will work: # psql -U 'database_user' -e 'database_name' < schema-pgsql.sql I'll add another error trap to the setup program to look for this condition. Andrew |
|
From: Bhuvan K. <bh...@sw...> - 2012-01-06 06:17:39
|
Thanks for the input. I realized this error after i posted to the list. Now when i try to give the command for creating the schema i get a peer auth error which is entirely postgres error. I am trying to fix it. Thanks for the help. Regards, Bhuvan On Friday 06 January 2012 12:55 AM, Andrew Simpson wrote: > On Thu, 05 Jan 2012 16:34:47 +0530 > Bhuvan Krishna<bh...@sw...> wrote: > >> I am attaching the relavent log details from apache, postgresql and >> webcollab. I enabled debug in the config.php and tried installing. I got >> this error on the screen. >> >> Database server error: >> SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "site_name" does not >> exist LINE 1: UPDATE site_name SET manager_name='WebCollab Project >> Managem... ^ >> >> check the attachments for more details. >> >> Regards, >> Bhuvan > Bhuvan, > > Thanks. That's not too hard to fix. > > What has happened is that you've created the database manually, but not created the tables from the > database schema. > > This is why WebCollab can connect to the database, but fails to insert data into the > (non-existent) tables. > > The database table schema is in [webcollab]/db and is 'schema-pgsql.sql'. There are some > instructions in [webcollab]/docs, but basically something like this will work: > > # psql -U 'database_user' -e 'database_name'< schema-pgsql.sql > > I'll add another error trap to the setup program to look for this condition. > > Andrew > > ------------------------------------------------------------------------------ > Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex > infrastructure or vast IT resources to deliver seamless, secure access to > virtual desktops. With this all-in-one solution, easily deploy virtual > desktops for less than the cost of PCs and save 60% on VDI infrastructure > costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox > _______________________________________________ > Webcollab-users mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/webcollab-users |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X