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

[Bhuvan K. <bh...@sw...>]

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