yes, that was it, I should not run turbine-postgresql.sql , populate-postgresql.sql and then dbpsml-schema.sql because in this order I remove the previously populated tables from the database. thanks!
On Thu, 15 Aug 2002, David Sean Taylor wrote: > > org.apache.jetspeed.services.security.LoginException: Failed > > to get anonymous user: > > org.apache.jetspeed.services.security.UnknownUserException: > > Unknown user 'anon' at > > This question seems obvious but thought I'd double check: > > Do you have the anonymous user in your TURBINE_USER table? > The script should have inserted this line : > > INSERT INTO TURBINE_USER > VALUES(3,'anon','anon','Anonymous','User','[EMAIL PROTECTED]','CONFIRMED > ',NULL,NULL,'2001-11-11 18:45:41.671','F',NULL); > > > -----Original Message----- > > From: def [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 15, 2002 6:01 AM > > To: [EMAIL PROTECTED] > > Subject: problems while configuring jetspeed to use a psml database > > > > > > > > I am using postgresql 7.2.1 and jetspeed 1.4b2 (checked from cvs > > yesterday) and > > I am having trouble when trying to configure my postgresql with > > jetspeed. I have > > made all the appropriate steps described in the site: > > > > 1) run the ' turbine-postgres.sql', ' populate-postgres.sql' > > > > 2) build torque with dbpsml.properties and build.properties set > > as seen below: > > > > database=postgresql > > databaseUrl = jdbc:postgresql://127.0.0.1/postgres > > databaseDriver = org.postgresql.Driver > > databaseUser = postgres > > databasePassword = > > databaseHost = localhost > > 3) run ' dbpsml-schema.sql', 'security-schema.sql' > > > > 4) configure JetspeedResource.properties : > > > > > > services.PsmlManager.classname=org.apache.jetspeed.services.psmlma > > nager.db.DatabasePsmlManagerService > > services.PsmlImportManager.classname=org.apache.jetspeed.services. > > psmlmanager.CastorPsmlManagerService > > > > 5) run 'ant import' successfully > > > > 6) the tables in postgres database are: > > > > Name | Type | Owner > > ---------------------------------+----------+---------- > > id_table | table | postgres > > jetspeed_group_prof_psml_id_seq | sequence | postgres > > jetspeed_group_profile | table | postgres > > jetspeed_role_profi_psml_id_seq | sequence | postgres > > jetspeed_role_profile | table | postgres > > jetspeed_user_profi_psml_id_seq | sequence | postgres > > jetspeed_user_profile | table | postgres > > turbine_group | table | postgres > > turbine_group_group_id_seq | sequence | postgres > > turbine_permi_permission_id_seq | sequence | postgres > > turbine_permission | table | postgres > > turbine_role | table | postgres > > turbine_role_permission | table | postgres > > turbine_role_role_id_seq | sequence | postgres > > turbine_scheduled_job | table | postgres > > turbine_user | table | postgres > > turbine_user_group_role | table | postgres > > (17 rows) > > > > > > but when I start jetspeed I get the following error message: > > > > Horrible Exception: > > org.apache.jetspeed.services.security.LoginException: Failed > > to get anonymous user: > > org.apache.jetspeed.services.security.UnknownUserException: > > Unknown user 'anon' at > > org.apache.jetspeed.services.security.turbine.TurbineAuthenticatio > > n.getAnonymousUser(TurbineAuthentication.java:194) at > > org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUs > > er(JetspeedAuthentication.java:107) at > > org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(Jet > > speedSecurity.java:157) at > > org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPer > > form(TemplateSessionValidator.java:97) at > > org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPer > > form(JetspeedSessionValidator.java:103) at > > org.apache.turbine.modules.Action.perform(Action.java:87) > > . > > . > > . > > > > > > bottom line, I cannot configure jetspeed use postgresql for a > > psml database, > > what can I do? > > > > ps. why in jetspeed version 1.4b1 I cannot run "ant import" in the /build > > directory ? this was a bug ? > > > > > > -- > > 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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
