Jetspeed replys on turbine ID table to store the inital id for jetspeed table. Basically, you need to run the following to add entries into tubrine.id_table
# ----------------------------------------------------------------------- # Create ID_TABLE Entry for Jetsepped # ----------------------------------------------------------------------- INSERT INTO ID_TABLE VALUES(8,'JETSPEED_USER_PROFILE',120,10); INSERT INTO ID_TABLE VALUES(9,'JETSPEED_GROUP_PROFILE',120,10); INSERT INTO ID_TABLE VALUES(10,'JETSPEED_ROLE_PROFILE',120,10); INSERT INTO ID_TABLE VALUES(11,'JETSPEED_ANON_PROFILE',120,10); The instruction kind of assume you have port all turbine tables from HypersonicSQL to mySQL. Here's what we used for building the psml DB for mySQL. It combines several scripts from turbine, jetspeed, and patch I found in this mail list. Hope it helps Ben ----- Original Message ----- From: "Anthony Smith" <[EMAIL PROTECTED]> To: "Jetspeed Users List" <[EMAIL PROTECTED]> Sent: Monday, February 25, 2002 8:54 AM Subject: RE: DBPSML & MYSQL > "Make sure you added entry in turbine id table for all jetspeed table." > > --I don't understand this statement. I just followed what was on the > instructions. Can you explain further? > > -----Original Message----- > From: Ben Liang [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 25, 2002 8:46 AM > To: Jetspeed Users List > Subject: Re: DBPSML & MYSQL > > > We've done this with mySQL, and it works. Make sure you added entry in > turbine id table for all jetspeed table. Only thing we had problem with is > mySQL is not transactional, and we keep getting error in the log: > [Thu Feb 21 11:26:59 CST 2002] -- WARN -- IDBroker is being used with db > 'default', which does not support transactions. IDBroker attempts to use > transactions to limit the possibility of duplicate key generation. Without > transactions, duplicate key generation is possible if multiple JVMs are used > or other means are used to write to the database. > > maybe mySQL is not a good option for DBPSML. Anyone idea from the gurus? > > Ben > > > ----- Original Message ----- > From: "Anthony Smith" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, February 25, 2002 12:18 AM > Subject: DBPSML & MYSQL > > > > Did anypne ever get this working with mysql? > > > > Now before I login it says "Error fetching pane " and the same thing when > I > > login. When I try to go to Customize I get this on the screen? > > > > Horrible Exception: java.lang.NullPointerException at > > > org.apache.jetspeed.modules.actions.controls.Customize.doPerform(Customize.j > ava:119) > > at org.apache.turbine.modules.Action.perform(Action.java:87) at > > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at > > org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143) > > at org.apache.turbine.modules.Page.build(Page.java:90) at > > org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123) at > > org.apache.turbine.Turbine.doGet(Turbine.java:565) at > > javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > FilterChain.java:247) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > ain.java:193) > > at > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > va:243) > > at > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 66) > > at > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja > va:190) > > at > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 66) > > at > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343) > > at > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 > ) > > at > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 66) > > at > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. > java:170) > > at > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 64) > > at > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170 > ) > > at > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 64) > > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468) > > at > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 64) > > at > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java > :174) > > at > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 66) > > at > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > > > org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java: > 1012) > > at > > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107 > ) > > at java.lang.Thread.run(Thread.java:484) > > > > > > > > Mr. Smith > > > > "Having education and talent doesn't make you better than the world... it > > makes you responsible for it!" > > > > > > _________________________________________________________________ > > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > -- > 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]>
dbpsml-init.sql
Description: Binary data
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
