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
Are you using MySQL?
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 ^^
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,
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.