nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

How to change database user ?

jeremiebal

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

Find more posts tagged with

Alfresco Content Services

Comments

angelborroy

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

jeremiebal

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 ^^

EddieMay

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,