Seperate Database for each instance

[Aston Pearl, modifié il y a 10 années.]

Hi,

I created 2 portal instances and i want to have 2 different database for each instance. Is it possible?


Thanks!!!

[Juan Gonzalez, modifié il y a 10 années.]

Take a look at User guide - Database sharding:

https://www.liferay.com/es/documentation/liferay-portal/6.2/user-guide/-/ai/liferay-clustering-liferay-portal-6-2-user-guide-20-en

[Aston Pearl, modifié il y a 10 années.]

I followed the guide but unable to solve my problem. LR default tables does not get created. Getting error that table does not exist.

i.e

13:04:30,572 ERROR [pool-2-thread-1][JDBCExceptionReporter:76] Table 'ft.user_' doesn't exist
13:04:30,599 ERROR [pool-2-thread-1][PortalInstances:375] java.lang.reflect.UndeclaredThrowableException

[Juan Gonzalez, modifié il y a 10 années.]

Liferay version?

I remember there was a bug which prevented to create the tables in a previous Liferay installation.

[Aston Pearl, modifié il y a 10 années.]

I am using Liferay 6.1.1 CE GA2

Thanks !!!

[Juan Gonzalez, modifié il y a 10 années.]

Ok Aston you're hitting this issue:

https://issues.liferay.com/browse/LPS-21808

If you upgrade to 6.1.2 GA3 should be working properly.

[Aston Pearl, modifié il y a 10 années.]

Thanks for your help. Can you tell me how can i achieve result with out migrating to 6.1.2 GA3

[Juan Gonzalez, modifié il y a 10 années.]

You should patch using github commits for that LPS.

[Aston Pearl, modifié il y a 10 années.]

I am not able to find commit location or files. can you provide me URL?

[Patrick Wolf, modifié il y a 10 années.]

https://github.com/liferay

[Aston Pearl, modifié il y a 10 années.]

Juan Gonzalez:

You should patch using github commits for that LPS.

Hi,

Sharding is done but i am not able to add or delete user. I am getting "You do not have the required permissions."

Error Log :-

08:19:20,118 ERROR [ajp-bio-8009-exec-4][UserPermissionImpl:173] com.liferay.portal.NoSuchContactException: No Contact exists with the primary key 19202
com.liferay.portal.NoSuchContactException: No Contact exists with the primary key 19202

Probably again LR bug.

Thanks

[Rahul Panchivala, modifié il y a 8 années.]

hii Juan Gonzalez,

Add this property to your portal-ext.property file to remove your error

value.object.entity.cache.enabled.com.liferay.portal.model.Contact=false