I guess I have figured something out.
I use jetspeed-1.3a3.
I was following instruction on
http://jakarta.apache.org/jetspeed/site/psml_db.html,
but the turbine-mysql.sql and populate-mysql.sql under
src/sql is not good enough. One can modify
these two files as needed. I consulted mysql error
messages and jetspeed.script under WEB-INF/db.
thanks anyway,
Hong
On Mon, 1 Jul 2002, Hongbin Liu wrote:
>
>
> Greetings all:
>
> I try to make Jetspeed use PSML database instead of
> the flat file.
>
> I have created tables in mysql:
> | ID_TABLE |
> | JETSPEED_ANON_PROFILE |
> | JETSPEED_GROUP_PROFILE |
> | JETSPEED_ROLE_PROFILE |
> | JETSPEED_USER_PROFILE |
> | TURBINE_GROUP |
> | TURBINE_PERMISSION |
> | TURBINE_ROLE |
> | TURBINE_ROLE_PERMISSION |
> | TURBINE_SCHEDULED_JOB |
> | TURBINE_USER |
> | TURBINE_USER_GROUP_ROLE |
>
> I populated the tables using populate-mysql.sql (
> this script populate TURBINE_* but not JETSPEED_* ?),
> modified TurbineResource.Properties and Torque.properties
> to reflect mysql database settings, modified Jetspeed.properties
> to use DatabasePsmlManager.
>
> When I directed the browser to :8080/jetspeed, I got errors:
>
> Horrible Exception:
> org.apache.turbine.util.security.UnknownEntityException: Unknown user
> 'anon'
> at
>
>org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:178)
> at
>
>org.apache.turbine.services.security.BaseSecurityService.getUser(BaseSecurityService.java:329)
> at
>
>org.apache.jetspeed.services.security.JetspeedDBSecurityService.getAnonymousUser(JetspeedDBSecurityService.java:456)
> at
>
>org.apache.turbine.services.security.TurbineSecurity.getAnonymousUser(TurbineSecurity.java:246)
> at
>
>org.apache.turbine.modules.actions.sessionvalidator.TemplateSessionValidator.doPerform(TemplateSessionValidator.java:95)
> at
>
>org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(JetspeedSessionValidator.java:104)
> at org.apache.turbine.modules.Action.perform(Action.java:87)
>
> ...
>
> jetspeed.log has the following:
>
> [20:04:01,436 DEBUG] SELECT TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME,
> TURBINE_USER.PASSWORD_VALUE, TURBINE_USER.FIRST_NAME,
> TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE,
> TURBINE_USER.MODIFIED, TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN,
> TURBINE_USER.DISABLED, TURBINE_USER.OBJECTDATA FROM TURBINE_USER WHERE
> (TURBINE_USER.LOGIN_NAME='anon')
> [20:04:01,442 ERROR] Turbine.handleException: Unknown user 'anon'
>
>
> Could you please inform me what's wrong with it? populate-mysql.sql
> doesn't insert a Turbine user 'anon'; so should I manually insert this
> user 'anon' to TURBINE_USER? Besides, what is 'anon' about? I thank
> in advance for your help.
>
>
> regards,
>
> hong
>
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
>
>
****************************
Hongbin Liu
Campus View #111
Bloomington, IN 47408
Tel: (812)857-4837
Email: [EMAIL PROTECTED]
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
