Getting crazy with MySQL... Again!

["BARDE, CEDRIC" <CE...@disney.com>]

Hi all,

I still cannot use Jetspeed with MySQL... I have tried to connect to my
database via MySQLCC and it works properly with a user I have defined. I am
using the same user in Torque.props but I get this exception when hitting
http://localhost:8080/jetspeed :

Horrible Exception: org.apache.jetspeed.om.profile.ProfileException:
java.lang.RuntimeException: Could not get profile from DB at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfil
e(JetspeedProfilerService.java:414) at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(Jet
speedProfilerService.java:287) at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(Jet
speedProfilerService.java:440) at
org.apache.jetspeed.services.Profiler.getProfile(Profiler.java:123) at
org.apache.jetspeed.modules.actions.JetspeedAccessController.doPerform(Jetsp
eedAccessController.java:99) at
org.apache.turbine.modules.Action.perform(Action.java:87) at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
org.apache.turbine.Turbine.doGet(Turbine.java:476) at
javax.servlet.http.HttpServlet.service(HttpServlet.java) at
javax.servlet.http.HttpServlet.service(HttpServlet.java) at
org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:574)
at org.apache.tomcat.core.Handler.invoke(Handler.java:322) at
org.apache.tomcat.core.Handler.service(Handler.java:235) at
org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:485) at
org.apache.tomcat.facade.RequestDispatcherImpl.doForward(RequestDispatcherIm
pl.java:272) at
org.apache.tomcat.facade.RequestDispatcherImpl.forward(RequestDispatcherImpl
.java:174) at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:423)
at index_1._jspService(index_1.java:51) at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at
javax.servlet.http.HttpServlet.service(HttpServlet.java) at
org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:574)
at org.apache.tomcat.core.Handler.invoke(Handler.java:322) at
org.apache.tomcat.core.Handler.service(Handler.java:235) at
org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:485) at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:91
7) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:833)
at
org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10I
nterceptor.java:176) at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:516) at java.lang.Thread.run(Thread.java:479) 

And I still don't have a clue on what to do...

Thanx a lot in advance for your help!
Ced

__________________________________
Cédric BARDE
Disneyland Resort Paris - Information Services
Bâtiment Robin Hood - BP 100
77777 Marne-La-Vallée
Tél : 01 64 74 65 49
Fax : 01 64 74 65 65
Email : cedric.barde@disney.com


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: Getting crazy with MySQL... Again!

[David Sean Taylor <da...@bluesunrise.com>]

> -----Original Message-----
> From: BARDE, CEDRIC [mailto:CEDRIC.BARDE@disney.com]
> Sent: Thursday, November 28, 2002 9:29 AM
> To: 'Jetspeed Users'
> Subject: Getting crazy with MySQL... Again!
>
>
> Hi all,
>
> I still cannot use Jetspeed with MySQL... I have tried to connect to my
> database via MySQLCC and it works properly with a user I have
> defined. I am
> using the same user in Torque.props but I get this exception when hitting
> http://localhost:8080/jetspeed :
>
> Horrible Exception: org.apache.jetspeed.om.profile.ProfileException:
> java.lang.RuntimeException: Could not get profile from DB at
> org.apache.jetspeed.services.profiler.JetspeedProfilerService.fall
> backProfil
> e(JetspeedProfilerService.java:414) at
> org.apache.jetspeed.services.profiler.JetspeedProfilerService.getP
> rofile(Jet

You failed to mention that you switched over to the DBPSML feature.
Was that your intention?

Also, maybe try to take it one step at a time.
Can you connect to MySQL with Jetspeed?
Assuming that you have the source code, try running the db unit test (ant
unittest-security)

There is a document describing how to configure DBPSML:

http://jakarta.apache.org/jetspeed/site/psml_db.html

Which version of Jetspeed are you using now?



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>