RE: Getting crazy with MySQL... Again!

2002-11-29 Thread BARDE, CEDRIC 
I am using Jetspeed 1.4b1.
I came back to the standard version of Jetspeed, using PSML files and not
DBPSML. I have created a DatabaseBrowserPortlet that retrieves data from my
MySQL database, and it works perfectly. So I assume Jetspeed can connect to
my database, right ?
I am completely lost! What do I have to do now? Do I have to follow the
instructions given in the PSML DB chapter? I think that it is what I did the
first time...
For me, the next step now is to modify the Torque.props file and the
JetspeedResources.props file. Am I right?

Thanx anyway for your time (and your patience...)
Ced

__
Cédric BARDE
Disneyland Resort Paris - Information Services
Bâtiment Robin Hood - BP 100
7 Marne-La-Vallée
Tél : 01 64 74 65 49
Fax : 01 64 74 65 65
Email : [EMAIL PROTECTED]

> -Original Message-
> From: David Sean Taylor [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 28, 2002 7:02 PM
> To:   Jetspeed Users List
> Subject:      RE: Getting crazy with MySQL... Again!
> 
> 
> 
> > -Original Message-
> > From: BARDE, CEDRIC [mailto:[EMAIL PROTECTED]]
> > 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:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: Getting crazy with MySQL... Again!

2002-11-28 Thread David Sean Taylor 


> -Original Message-
> From: BARDE, CEDRIC [mailto:[EMAIL PROTECTED]]
> 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:   
For additional commands, e-mail:

Re: Getting crazy with MySQL!!!

2002-11-27 Thread Steve 
Not to be to simplistic, but - as you are on windows - remember case
sensitivity when it comes to database name, username, and password
in your .properties file

Steve B.

- Original Message -
From: "BARDE, CEDRIC" <[EMAIL PROTECTED]>
To: "'Jetspeed Users'" <[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 8:14 AM
Subject: Getting crazy with MySQL!!!


Hi all,

I still cannot make Jetspeed work properly with MySQL... I am using MySQL
3.23.51 for Windows, the mm.mysql-2.0.4 driver and Jetspeed 1.4b1.
My database is populated (I have used the scripts given with Jetspeed
sources) and I have modified TurbineResources.props...

First, I run MySQL Server, then Tomcat and finally, I try to hit
http://localhost:8080/jetspeed. But I get this error :

Horrible Exception: org.apache.jetspeed.services.security.LoginException:
Failed to get anonymous user:
org.apache.jetspeed.services.security.UserException: Failed to retrieve user
'anon': Connection object is null! at
org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnony
mousUser(TurbineAuthentication.java:194) at
org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jetspee
dAuthentication.java:107) at
org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecur
ity.java:157) at
org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(Templ
ateSessionValidator.java:97) at
org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(Jetsp
eedSessionValidator.java:103) 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:468) 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)

I cannot figure out what I am doing wrong.
If anyone could point me to the right direction, I would appreciate it a
lot!

Thanx in advance.
Ced

__
Cédric BARDE
Disneyland Resort Paris - Information Services
Bâtiment Robin Hood - BP 100
7 Marne-La-Vallée
Tél : 01 64 74 65 49
Fax : 01 64 74 65 65
Email : [EMAIL PROTECTED]


--
To unsubscribe, e-mail:

For additional commands, e-mail:



--
To unsubscribe, e-mail:   
For additional commands, e-mail:

Re: Getting crazy with MySQL!!!

2002-11-27 Thread Mike ERRECART 

Hi Cedric.
I think you're french, but i'll try to write in english in the case you're
not.
You say you modified TurbineResources.props...
What kind of modification have you made in TR.p to configure MySQL ?
I think the modifications need to be made to Torque.properties.

(commented in my Torque.props)
#database.default=default

#database.default.driver=org.hsql.jdbcDriver
#database.default.url=jdbc:HypersonicSQL:${webappRoot}/WEB-INF/db/jetspeed
#database.default.username=sa
#database.default.password=

Let me know if you still cannot connect.
I use JS with MySQL, had problems to configure it, but can't really remember
them all :o)



Hi all,

I still cannot make Jetspeed work properly with MySQL... I am using MySQL
3.23.51 for Windows, the mm.mysql-2.0.4 driver and Jetspeed 1.4b1.
My database is populated (I have used the scripts given with Jetspeed
sources) and I have modified TurbineResources.props...

First, I run MySQL Server, then Tomcat and finally, I try to hit
http://localhost:8080/jetspeed. But I get this error :

Horrible Exception: org.apache.jetspeed.services.security.LoginException:
Failed to get anonymous user:
org.apache.jetspeed.services.security.UserException: Failed to retrieve user
'anon': Connection object is null! at
org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnony
mousUser(TurbineAuthentication.java:194) at
org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jetspee
dAuthentication.java:107) at
org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecur
ity.java:157) at
org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(Templ
ateSessionValidator.java:97) at
org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(Jetsp
eedSessionValidator.java:103) 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:468) 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)

I cannot figure out what I am doing wrong.
If anyone could point me to the right direction, I would appreciate it a
lot!

Thanx in advance.
Ced

__
Cédric BARDE
Disneyland Resort Paris - Information Services
Bâtiment Robin Hood - BP 100
7 Marne-La-Vallée
Tél : 01 64 74 65 49
Fax : 01 64 74 65 65
Email : [EMAIL PROTECTED]


--
To unsubscribe, e-mail:

For additional commands, e-mail:




--
To unsubscribe, e-mail:   
For additional commands, e-mail:

Re: Getting crazy with MySQL!!!

2002-11-27 Thread Stefan Kuhn 
Hi Cedric,
I would expect it be a problem with access rights, i. e. the user you define 
in TR.properties has not the appropriate access rights on the database. This 
is according to my experience a very common problem which shows up various 
error messages not really giving hints to the problem. For example, it could 
be that you can access the database vi mysql and not via torque, because your 
machine is called localhost and in TR.properties you define the connection 
with 127.0.0.1. It the user has only the right to access the database from 
localhost, but not from 127.0.01, Turbine/Jetspeed will not work
HTH 
Stefan

Am Mittwoch, 27. November 2002 14:14 schrieben Sie:
> Hi all,
>
> I still cannot make Jetspeed work properly with MySQL... I am using MySQL
> 3.23.51 for Windows, the mm.mysql-2.0.4 driver and Jetspeed 1.4b1.
> My database is populated (I have used the scripts given with Jetspeed
> sources) and I have modified TurbineResources.props...
>
> First, I run MySQL Server, then Tomcat and finally, I try to hit
> http://localhost:8080/jetspeed. But I get this error :
>
> Horrible Exception: org.apache.jetspeed.services.security.LoginException:
> Failed to get anonymous user:
> org.apache.jetspeed.services.security.UserException: Failed to retrieve
> user 'anon': Connection object is null! at
> org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnon
>y mousUser(TurbineAuthentication.java:194) at
> org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jetspe
>e dAuthentication.java:107) at
> org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecu
>r ity.java:157) at
> org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(Temp
>l ateSessionValidator.java:97) at
> org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(Jets
>p eedSessionValidator.java:103) 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:468) 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(RequestDispatcherI
>m pl.java:272) at
> org.apache.tomcat.facade.RequestDispatcherImpl.forward(RequestDispatcherImp
>l .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:9
>1 7) at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:833) at
> org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10
>I nterceptor.java:176) at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja
>v a:516) at java.lang.Thread.run(Thread.java:479)
>
> I cannot figure out what I am doing wrong.
> If anyone could point me to the right direction, I would appreciate it a
> lot!
>
> Thanx in advance.
> Ced
>
> __
> Cédric BARDE
> Disneyland Resort Paris - Information Services
> Bâtiment Robin Hood - BP 100
> 7 Marne-La-Vallée
> Tél : 01 64 74 65 49
> Fax : 01 64 74 65 65
> Email : [EMAIL PROTECTED]

-- 
Stefan Kuhn M. A.
MPI of Chemical Ecology, Winzerlaer Str. 10, Beutenberg Campus, 07745 
Jena, Germany
Tel: +49(0)3641 571261 - Fax: +49(0)3641 571202

--
To unsubscribe, e-mail:   
For additional commands, e-mail:

RE: Getting crazy with MySQL!!!

2002-11-27 Thread Luta, Raphael (VUN) 
This is most likely an access right issue between Tomcat and MySQL:
Jetspeed doesn't seem to be able to connect to MySQL.

Check your MySQL access rights and tests with the command line utility
to makje sure that the user Jetspeed is configured with can indeed 
connect to the database.

> -Message d'origine-
> De : BARDE, CEDRIC [mailto:[EMAIL PROTECTED]]
> Envoyé : mercredi 27 novembre 2002 14:15
> À : 'Jetspeed Users'
> Objet : Getting crazy with MySQL!!!
> 
> 
> Hi all,
> 
> I still cannot make Jetspeed work properly with MySQL... I am 
> using MySQL
> 3.23.51 for Windows, the mm.mysql-2.0.4 driver and Jetspeed 1.4b1.
> My database is populated (I have used the scripts given with Jetspeed
> sources) and I have modified TurbineResources.props...
> 
> First, I run MySQL Server, then Tomcat and finally, I try to hit
> http://localhost:8080/jetspeed. But I get this error :
> 
> Horrible Exception: 
> org.apache.jetspeed.services.security.LoginException:
> Failed to get anonymous user:
> org.apache.jetspeed.services.security.UserException: Failed 
> to retrieve user
> 'anon': Connection object is null! at
> org.apache.jetspeed.services.security.turbine.TurbineAuthentic
> ation.getAnony
> mousUser(TurbineAuthentication.java:194) at
> org.apache.jetspeed.services.JetspeedAuthentication.getAnonymo
> usUser(Jetspee
> dAuthentication.java:107) at
> org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser
> (JetspeedSecur
> ity.java:157) at
> org.apache.jetspeed.modules.actions.TemplateSessionValidator.d
> oPerform(Templ
> ateSessionValidator.java:97) at
> org.apache.jetspeed.modules.actions.JetspeedSessionValidator.d
> oPerform(Jetsp
> eedSessionValidator.java:103) 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:468) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java) at
> org.apache.tomcat.facade.ServletHandler.doService(ServletHandl
> er.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(Reque
> stDispatcherIm
> pl.java:272) at
> org.apache.tomcat.facade.RequestDispatcherImpl.forward(Request
> DispatcherImpl
> .java:174) at
> org.apache.jasper.runtime.PageContextImpl.forward(PageContextI
> mpl.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(ServletHandl
> er.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(ContextM
> anager.java:91
> 7) at 
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:833)
> at
> org.apache.tomcat.modules.server.Http10Interceptor.processConn
> ection(Http10I
> nterceptor.java:176) at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> nt.java:494)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.jav
> a:516) at java.lang.Thread.run(Thread.java:479) 
> 
> I cannot figure out what I am doing wrong.
> If anyone could point me to the right direction, I would 
> appreciate it a
> lot!
> 
> Thanx in advance.
> Ced
> 
> __
> Cédric BARDE
> Disneyland Resort Paris - Information Services
> Bâtiment Robin Hood - BP 100
> 7 Marne-La-Vallée
> Tél : 01 64 74 65 49
> Fax : 01 64 74 65 65
> Email : [EMAIL PROTECTED]
> 
> 
> --
> To unsubscribe, e-mail:   

For additional commands, e-mail:


--
To unsubscribe, e-mail:   
For additional commands, e-mail: