make HippoCMS talk to AmazonRDS

[bboyj...@gmail.com]

SO I was following the configuration(following link), and make it works for localhost. 
http://www.onehippo.org/7_8/library/deployment/configuring/configuring-hippo-7-for-mysql.html


    <Resource name="jdbc/repositoryDS" auth="Container" type="javax.sql.DataSource"
        maxActive="20" maxIdle="10" minIdle="2" initialSize="2" maxWait="10000"
        testOnBorrow="true" validationQuery="select 1 from dual"
        poolPreparedStatements="true" username="hippo" password="hippo"
        driverClassName="com.mysql.jdbc.Driver"
        url="jdbc:mysql://localhost:3306/hippo?autoReconnect=true&amp;characterEncoding=utf8" />


However, when i change the configuration to rds ,

    <Resource name="jdbc/repositoryDS" auth="Container" type="javax.sql.DataSource"
    maxActive="20" maxIdle="10" minIdle="2" initialSize="2" maxWait="10000"
    testOnBorrow="true" validationQuery="select 1 from dual"
    poolPreparedStatements="true" username="rdsUserName" password="rdsPassword"
    driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://rdsLink:3306/hippo?autoReconnect=true&amp;characterEncoding=utf8" />


I got such errors like this.


[INFO] [talledLocalContainer] javax.jcr.NamespaceException: wfdropbox: is not a registered namespace prefix.
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.core.NamespaceRegistryImpl.getURI(NamespaceRegistryImpl.java:467)
[INFO] [talledLocalContainer]   at org.hippoecm.repository.jackrabbit.SessionImplHelper.getNamespaceURI(SessionImplHelper.java:183)
[INFO] [talledLocalContainer]   at org.hippoecm.repository.jackrabbit.XASessionImpl.getNamespaceURI(XASessionImpl.java:177)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.core.SessionImpl.getURI(SessionImpl.java:584)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.spi.commons.conversion.NameParser.parse(NameParser.java:187)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.spi.commons.conversion.ParsingNameResolver.getQName(ParsingNameResolver.java:64)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.spi.commons.conversion.CachingNameResolver.getQName(CachingNameResolver.java:76)
[INFO] [talledLocalContainer]   at org.hippoecm.repository.jackrabbit.HippoNamePathResolver.getQName(HippoNamePathResolver.java:53)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.core.SessionImpl.getQName(SessionImpl.java:599)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.spi.commons.query.qom.QueryObjectModelFactoryImpl.checkNodeTypeName(QueryObjectModelFactoryImpl.java:1009)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.spi.commons.query.qom.QueryObjectModelFactoryImpl.selector(QueryObjectModelFactoryImpl.java:205)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.commons.query.sql2.Parser.parseSelector(Parser.java:135)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.commons.query.sql2.Parser.parseSource(Parser.java:167)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.commons.query.sql2.Parser.createQueryObjectModel(Parser.java:112)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.commons.query.sql2.SQL2QOMBuilder.createQueryObjectModel(SQL2QOMBuilder.java:55)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.core.query.QOMQueryFactory.createQuery(QOMQueryFactory.java:69)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.core.query.CompoundQueryFactory.createQuery(CompoundQueryFactory.java:67)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.core.query.QueryManagerImpl$2.perform(QueryManagerImpl.java:95)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.core.query.QueryManagerImpl$2.perform(QueryManagerImpl.java:91)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.core.session.SessionState.perform(SessionState.java:200)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.core.query.QueryManagerImpl.perform(QueryManagerImpl.java:197)
[INFO] [talledLocalContainer]   at org.apache.jackrabbit.core.query.QueryManagerImpl.createQuery(QueryManagerImpl.java:91)
[INFO] [talledLocalContainer]   at org.hippoecm.repository.decorating.QueryManagerDecorator.createQuery(QueryManagerDecorator.java:41)
[INFO] [talledLocalContainer]   at org.hippoecm.repository.impl.QueryManagerDecorator.createQuery(QueryManagerDecorator.java:39)
[INFO] [talledLocalContainer]   at org.onehippo.cms7.repository.wfdropbox.DropboxDaemonModule.run(DropboxDaemonModule.java:125)

[Jeroen Reijn]

Hi,

It's a bit unclear from your error message what's going wrong. I think it's important that we see the first ERROR message(s) in your log. Maybe you can attach the log files?

Regards,

Jeroen

--
Hippo Community Group: The place for all discussions and announcements about Hippo CMS (and HST, repository etc. etc.)
Most Hippo developers are active here and/or follow the Stackoverflow [hippo-cms] tag.
 
The old Nabble archive can be found here: http://hippo.2275632.n2.nabble.com/Hippo-CMS-7-f2274273.html
 
To post to this group, send email to hippo-c...@googlegroups.com
RSS: https://groups.google.com/group/hippo-community/feed/rss_v2_0_msgs.xml?num=50
---
You received this message because you are subscribed to the Google Groups "Hippo Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hippo-communi...@googlegroups.com.
Visit this group at http://groups.google.com/group/hippo-community.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Jeroen Reijn
Solution Architect
Hippo

Amsterdam - Oosteinde 11, 1017 WT Amsterdam
Boston - 1 Broadway, Cambridge, MA 02142

US +1 877 414 4776 (toll free)
Europe +31(0)20 522 4466
www.onehippo.com

http://about.me/jeroenreijn

[bboyj...@gmail.com]

log files attached.

[Jeroen Reijn]

Hi,

is this the first error message which you get? I would expect a different error.

Are the tables being populated in your remote DB?

Jeroen

log files attached.

--
Hippo Community Group: The place for all discussions and announcements about Hippo CMS (and HST, repository etc. etc.)
Most Hippo developers are active here and/or follow the Stackoverflow [hippo-cms] tag.
 
The old Nabble archive can be found here: http://hippo.2275632.n2.nabble.com/Hippo-CMS-7-f2274273.html
 
To post to this group, send email to hippo-c...@googlegroups.com
RSS: https://groups.google.com/group/hippo-community/feed/rss_v2_0_msgs.xml?num=50
---
You received this message because you are subscribed to the Google Groups "Hippo Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hippo-communi...@googlegroups.com.
Visit this group at http://groups.google.com/group/hippo-community.
For more options, visit https://groups.google.com/groups/opt_out.