topic Re: How to change database user ? in Alfresco Forum

How to change database user ?

jeremiebal — Fri, 26 Jun 2020 09:38:52 GMT

Hello

I installed an Alfresco 5.2 on Linux connected to a Postgres database installed on another server.
2 users have been created for the database:
dba_gedmut_alfresco: total rights to the alfresco scheme (CREATE / USAGE)
usr_gedmut_alfresco: classic rights (USE)

At the first launch, I use the user dba_gedmut_alfresco on alfresco-global.properties
so that it creates the structure of the schema with the tables and sequences.
Alfresco starts, everything is fine.

Now I have to switch to the user usr_gedmut_alfresco so that he can use the schema
without other permissions.
So i change in alfresco-global.properties.

Alfresco crashes at startup:
Caused by: org.alfresco.error.AlfrescoRuntimeException: 05260000
More than one Alfresco schema was found when querying the database metadata.
Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'.

No matter how much I search the net for a solution, no one says how to change the database user.

FYI, I deleted all SOLR indexes before relaunching but it didn't change anything, same error.

Anyone know how to change the database user?

Thanks a lot

Re: How to change database user ?

angelborroy — Fri, 26 Jun 2020 09:43:22 GMT

Are you using MySQL?

https://hub.alfresco.com/t5/alfresco-content-services-forum/more-than-one-alfresco-schema-on-export-restore-db/td-p/166426

Re: How to change database user ?

jeremiebal — Fri, 26 Jun 2020 13:49:30 GMT

Hi Angelborroy and thanks to answer me.

No, as i mentioned it, it's Postgres.

Contrary to what is written in the link page, it is not part of an export / import.
The base is the same and has 2 known users at Postgres level.
But only dba_gedmut_alfresco works. It was he who initialized the base.
When I change in alfresco-global.properties the user dba_gedmut_alfresco by usr_gedmut_alfresco, I get this error as if this user was looking for another scheme.
Ah yes, for information, the whole structure, tables, sequences, are in lower case.

Ps : excuse for my english, i'm french ^^

Re: How to change database user ?

EddieMay — Fri, 26 Jun 2020 17:00:04 GMT

Hi @jeremiebal,

Does this new postgres user have rights re: sequences? You wrote that the new user:

user usr_gedmut_alfresco so that he can use the schema without other permissions.

The user must have write rights on sequences. Can you check that usr_gedmut_alfresco has these permissions?

HTH,