Adobe Experience Manager Sites & More

avinasht6348431 · 11/19/18

Hi Team,

configured storage config as DSRP. created one community site using default available site templates. published the site .

From publish , i was not able to add comments/blog/qna on to the site. (from dev console error is "uncaught syntax error unexpected token U")

But when i change the storage config from DSRP to JSRP , it works fine and i can see UGC too in crx. Using AEM 6.4.

Kindly help me in understanding the issue.

Thanks,

Avinash

avinasht6348431 · 2/12/19

Can Anyone help me on this??

Gaurav-Behl · 2/13/19

Did you setup correctly?

MySQL Configuration for DSRP

check this -

Change the MySQL database to default to UTF8 :

edit file /etc/my.cnf
in the [client] section, add the following line:
default-character-set=utf8
in the [mysqld] section, add the following line:
character-set-server=utf8

avinasht6348431 · 2/15/19

Hi Gaurav,

Here is how i configured things for communities.

Created community site using the available templates . under “/content/sites/usitycommunity/en” site is created.
Storage configuration updated as DSRP and added Solr configurations.
Solr OSGI configurations updated and indexing the community site which is created.
Whitelisted the Solr bundle.
Successfully pages are indexed in Solr.
Jdbc configurations are updated.
From the Community site created ,trying to post a question. Below is the response.

Request URL: http://localhost:4502/content/sites/usitycommunity/en/questions/jcr:content/content/primary/qna.soci...

Request Method: POST

Status Code: 201 Created

Remote Address: [::1]:4502

Referrer Policy: no-referrer-when-downgrade

Content-Length: 355

Content-Type: application/json;charset=utf-8

Date: Fri, 15 Feb 2019 09:14:21 GMT

Location: /content/usergenerated/asi/rdbms/content/sites/usitycommunity/en/questions/jcr:content/content/primary/qna/usity-tDe9

X-Content-Type-Options: nosniff

Accept: application/json, text/javascript, */*; q=0.01

Accept-Encoding: gzip, deflate, br

Accept-Language: en-US,en;q=0.9

Connection: keep-alive

Content-Length: 105

Content-Type: application/x-www-form-urlencoded; charset=UTF-8

Cookie: cq-authoring-mode=TOUCH; cq-forms-formsanddocuments-listing=card; cq-communities-sites=content; SessionPersistence=CLIENTCONTEXT%3A%3DvisitorId%253Danonymous%7CPROFILEDATA%3A%3DauthorizableId%253Danonymous; login-token=5a56cb92-9326-4ad8-879b-ac6dfb7fa13f%3a119f6f72-2388-44a9-a4f7-1e9915c6ac4c_964cb5676645c61920663789e0f87d55%3acrx.default

CSRF-Token: eyJleHAiOjE1NTAyMjI2NTQsImlhdCI6MTU1MDIyMjA1NH0.ua6Y-82p6yrHfIsfhCnztDqB4EOkwQd8dxykv5qjiwQ

Host: localhost:4502

Origin: http://localhost:4502

Referer: http://localhost:4502/content/sites/usitycommunity/en/questions.html

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36

X-Requested-With: XMLHttpRequest

id: nobot

:operation: social:createQnaPost

subject: Usity

message: What is Accelerator?

_charset_: UTF-8

8. Question won’t get submitted.And even data is not saving to DB.

Kindly let me know where am going wrong.

avinasht6348431 · 2/16/19

Can anyone help me on this plz??

Gaurav-Behl · 2/17/19

Can you validate that you've followed the setup exactly as mentioned in articles -

DSRP - Relational Database Storage Resource Provider

MySQL Configuration for DSRP

test the database connection in silo, enable logs and check the queries for solr and mysql..

avinasht6348431 · 2/17/19

Hi @gauravb41175071,

Thanks,I configured correctly as per the docs.

Attached the jdbc config.

Also whenever I try to submit anything from community site following error is seen.

Following is the error logs :

18.02.2019 11:20:58.545 *WARN* [0:0:0:0:0:0:0:1 [1550469058541] GET /content/sites/accelarator/en/questions.html HTTP/1.1] com.day.cq.wcm.webservicesupport.impl.ConfigurationManagerImpl Cloud service /libs/settings/cloudconfigs/translation/msft-translation/msft_trial not found

18.02.2019 11:20:58.582 *INFO* [Apache Sling Resource Resolver Finalizer Thread] com.adobe.granite.repository Service [8850, [org.apache.jackrabbit.oak.api.jmx.SessionMBean]] ServiceEvent UNREGISTERING

18.02.2019 11:20:58.613 *ERROR* [0:0:0:0:0:0:0:1 [1550469058541] GET /content/sites/accelarator/en/questions.html HTTP/1.1] com.adobe.cq.social.commons.comments.impl.CommentSocialComponentResourceListImpl Repository problem while fetching comments.

javax.jcr.RepositoryException: java.lang.IllegalStateException: Pool not open

at com.adobe.cq.social.commons.comments.impl.CommentSocialComponentResourceListImpl.getComments(CommentSocialComponentResourceListImpl.java:235) [com.adobe.cq.social.cq-social-commons:1.9.47]

at com.adobe.cq.social.commons.comments.impl.CommentSocialComponentResourceListImpl.prefetchForGetAsMap(CommentSocialComponentResourceListImpl.java:184) [com.adobe.cq.social.cq-social-commons:1.9.47]

at com.adobe.cq.social.commons.comments.api.AbstractCommentCollection.initCommentsWithPrefetch(AbstractCommentCollection.java:359) [com.adobe.cq.social.cq-social-commons:1.9.47]

at com.adobe.cq.social.commons.comments.api.AbstractCommentCollection.getAsMap(AbstractCommentCollection.java:346) [com.adobe.cq.social.cq-social-commons:1.9.47]

Gaurav-Behl · 2/18/19

You got the rootcause & next steps -

com.day.cq.wcm.webservicesupport.impl.ConfigurationManagerImpl Cloud service /libs/settings/cloudconfigs/translation/msft-translation/msft_trial not found //check the cloud config again and fix it. Not sure if you're using it in your use case?

Repository problem while fetching comments.

javax.jcr.RepositoryException: java.lang.IllegalStateException: Pool not open // Your db connection is not configured properly, check the configurations, schema name and test it without communities with sample db package that it works fine and thereafter test with communities.

Connecting to SQL Databases

Adobe Experience Manager Help | Querying and Persisting Adobe Experience Manager data into MySQL