wol-portlet installation problem

[Raymond Cheng, modifié il y a 15 années.]

Hi,

I have tried to download the wol-portlet from svn repository.
I deploy it successfully and have a correct setting in "context.xml" for my JIRA database setting in "META-INF" folder.
Problem seems that it use the Liferay default datasource instead of my JIRA datasource.

Is it a bug for wol-portlet?
Do anyone know the workaround solution?


Thanks a lot
Raymond Cheng


ps: error log is attached

06:36:39,390 ERROR [MainServlet:665] com.liferay.portal.kernel.events.ActionExce
ption: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: SELECT command denie
d to user 'liferay'@'localhost' for table 'userbase'
com.liferay.portal.kernel.events.ActionException: com.mysql.jdbc.exceptions.MySQ
LSyntaxErrorException: SELECT command denied to user 'liferay'@'localhost' for t
able 'userbase'
at com.liferay.wol.hook.events.LoginPostAction.run(LoginPostAction.java:
245)
at com.liferay.portal.events.EventsProcessor._processEvent(EventsProcess
or.java:142)
at com.liferay.portal.events.EventsProcessor._process(EventsProcessor.ja
va:129)
at com.liferay.portal.events.EventsProcessor.process(EventsProcessor.jav
a:76)
at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:132)
at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(
SecureFilter.java:282)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:132)
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.doFi
lter(VirtualHostFilter.java:145)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:132)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:74)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewrit
eFilter.java:738)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: SELECT command d
enied to user 'liferay'@'localhost' for table 'userbase'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1313)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1448)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:93)
at com.liferay.wol.hook.events.LoginPostAction.addJiraUserId(LoginPostAc
tion.java:81)
at com.liferay.wol.hook.events.LoginPostAction.doRun(LoginPostAction.jav
a:259)
at com.liferay.wol.hook.events.LoginPostAction.run(LoginPostAction.java:
242)
... 34 more

[Brian Chan, modifié il y a 15 années.]

It's not a bug, it's how we have it set up here with a jira database and a liferay database.

We'll need to change a few of these things in wol-portlet to make it easier for others to use (right now, it's pretty much primed for our exact uses).

[Raymond Cheng, modifié il y a 15 années.]

Hi,

I have a new finding on this issue.
Follow the update as shown below and you can solve this problem.

Location: com.liferay.wol.hook.events.LoginPostAction

public static void addJiraUserId(User user) throws Exception {
...

con = DataAccess.getConnection("jdbc/JIRAPool");

...
}

Location: liferay-portal-tomcat-6.0-5.1.1\conf\Catalina\localhost\ROOT.xml

<Resource
name="jdbc/JIRAPool"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/jiradb?useUnicode=true&amp;characterEncoding=UTF-8&amp;emulateLocators=true&amp;useFastDateParsing=false"
username="jirauser"
password="password"
maxActive="20"
/>

I can deploy wol-portlet without exception. However, I have found the another problem.

I login to [e-mail] and see that the "Public Pages" and "Private Pages" of "My Places" have some problems.
All "Private Pages" and "Edit" button is missing.

After I shutdown the tomcat server and remove wol-portlet related files in server and start it again, the problem is not found,
Therefore, it must be come from the wol-portlet,

I still don't know the reason,
Can anyone suggest the solution or the area that I can investigate more?


Thanks a lot,
Raymond Cheng

[Raymond Cheng, modifié il y a 15 années.]

I have resolved the problem too.
Here is my solution.

Find a file named "portal.properties" located in "wol-portlet/docroot/WEB-INF/src" folder.

Comment all statements except the followings.

include-and-override=portal-ext.properties

layout.static.portlets.start.column-<1,2>


Although wol-portlet can deploy to server, exception is found when adding application.
Anyway, wol-portlet is installed successfully. The exception may require more time to resolve one by one.

I hope Liferay can become a powerful platform on Portal framework.


Thanks,
Raymond Cheng