topic Re: Connecting Alfresco with postgresql in Alfresco Forum

Connecting Alfresco with postgresql

kazmi5 — Thu, 08 Jul 2021 14:35:45 GMT

Hello,

I am new to alfresco. I have a PostgreSQL server (13) installed. I am trying to connect it with my community addition. I have followed the steps mention on alfresco docs but I am not sure that both are connected or not.

Following are my questions:

1. How can I make sure PostpreSql and Alfresco are connected?

2. How can I see the files or tables of the PostgreSQL server on alfresco and vice versa?

Regards

Re: Connecting Alfresco with postgresql

cristinamr — Thu, 08 Jul 2021 15:40:42 GMT

Hi!

First at all: which Alfresco version are you using? Check the supported platforms to confirm if it is supported.

1. How can I make sure PostpreSql and Alfresco are connected?

If you are able to access into share UI, for sure it's working. Check you alfresco logs to see more details.

2. How can I see the files or tables of the PostgreSQL server on alfresco and vice versa?

You can login in PostgreSQL and see the tables, references and relates but it is not a simple task. It's complex and it's not recommeded to modify directly (bad practice). From alfresco UI you cannot check the tables.

Cheers,

Cris.

Re: Connecting Alfresco with postgresql

kazmi5 — Thu, 08 Jul 2021 19:29:35 GMT

Hi,

First of all thanks a lot for your reply. I have an alfresco 5.2 version.

(You can login in PostgreSQL and see the tables, references and relates but it is not a simple task. It's complex and it's not recommeded to modify directly (bad practice). From alfresco UI you cannot check the tables.)

So if I understand right you mean to say I can't see the files or tables of my PostgreSQL server from alfresco UI but I can see the data of alfresco from PostgreSQL server!!!???

(If you are able to access into share UI, for sure it's working. Check you alfresco logs to see more details.)

Pardon my negligence but how can I access share UI?

Regards,

Re: Connecting Alfresco with postgresql

cristinamr — Fri, 09 Jul 2021 07:26:52 GMT

Hi!

So if I understand right you mean to say I can't see the files or tables of my PostgreSQL server from alfresco UI but I can see the data of alfresco from PostgreSQL server!!!???

That's right: you can see the schema and tables from your database server. From Alfresco you'll see the "physical" documents, folder, user, etc...

Pardon my negligence but how can I access share UI?

Try to access to protocol://serverort/share e.g. https://localhost:8080/share You should have these details spacified in your alfresco-global.properties (deployed under <ALF_HOME>/tomcat/shared/classes/)

Let me know your progress.

Cris.

Re: Connecting Alfresco with postgresql

kazmi5 — Tue, 13 Jul 2021 22:36:23 GMT

Hi,

Thanks for the reply. I could not see anything. I don't know what's the issue may be a version problem, I am not sure.

But here is a quick question:

My lab where I work has an alfresco server and I can log in from the lab PC with my lab credentials to the alfresco server. I can see the dashboard.

If I install a MySQL or PostgreSQL server on the same computer, can I connect it with my alfresco dashboard??