topic Cannot connect to postgresql on server! in Alfresco Archive

Cannot connect to postgresql on server!

mustafa — Tue, 21 May 2013 14:39:58 GMT

I installed alfresco 4.2.c bundle ona linux64 machine. I want to connect to postgre by pgadmin 3 and manipulate the tables but I cannot. I need help.IP of the machine which alfresco bundle is installed is 10.10.17.72, tomcat, postgre and alfresco are running good and healthy =)My ip is 10.10.43.65db

Re: Cannot connect to postgresql on server!

bopolissimus — Wed, 22 May 2013 05:21:46 GMT

if your bundle is installed at /opt/alfresco-4.2.c

cd /opt/alfresco-4.2.c/alf_data/postgresql
edit (as sudo or as the owner of the file) pg_hba.conf

go to the end of the file and add:

host postgres alfresco 10.10.43.65/32 md5

and restart postgres (or just restart alfresco, simpler that way).

Re: Cannot connect to postgresql on server!

mustafa — Wed, 22 May 2013 12:48:29 GMT

Bopolissimus

I did that. Now I have this error ;



An Error has occured:
Error connecting to the server: FATAL: password authentication failed for user "alfresco"

‍‍‍‍‍‍

is there a different default password?

Re: Cannot connect to postgresql on server!

bopolissimus — Thu, 23 May 2013 03:36:10 GMT

Sorry, I had a typo. The pg_hba.conf line should instead be:

host alfresco alfresco 10.10.43.65/32 md5

after a restart, you should now be able to connect to postgres as the alfresco user. try this:

cd /opt/alfresco-4.2.c/postgresql/bin/
psql -h localhost -U alfresco alfresco

If that succeeds, alfresco will be able to connect to postgresql.

alternatively, if this is just for testing, you can do this:

host alfresco alfresco 10.10.43.65/32 trust

and restart alfresco.

that way, it'll always let you in regardless of password.

Re: Cannot connect to postgresql on server!

mustafa — Thu, 23 May 2013 09:00:00 GMT

Thanks Bopolissimus.=)
I can connect now. But still getting errors.


ERROR: column "datconfig" does not exist
LINE 1: …b.dattablespace AS spcoid, spcname, datallowconn, datconfig, …

‍‍‍‍‍

And the solution is to update pgadmin 1.8 to pgadmin 1.6.1
I have no idea why 1.6.1 is more up to date but it is =/

Now I can do anything . Thanks again Bopo 😃