Thanks Ben. I just added the 4 inserts to all the database population scripts under src/sql/external in cvs
> -----Original Message----- > From: Ben Liang [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 25, 2002 8:06 AM > To: Jetspeed Users List > Subject: Re: DBPSML & MYSQL > > > 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.doPerfo > rm(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(DefaultPa > ge.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.internalDoFilt > er(Application > > FilterChain.java:247) > > > at > > > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > cationFilterCh > > ain.java:193) > > > at > > > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > rapperValve.ja > > va:243) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > > 66) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943 > > > ) > > at > > > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardC > ontextValve.ja > > va:190) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > > 66) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943 > > > ) > > at > > > > org.apache.catalina.core.StandardContext.invoke(StandardContex > t.java:2343) > > > at > > > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > Valve.java:180 > > ) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > > 66) > > > at > > > > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > spatcherValve. > > java:170) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > > 64) > > > at > > > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > Valve.java:170 > > ) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > > 64) > > > at > > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:4 > > 68) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > > 64) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943 > > > ) > > at > > > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > gineValve.java > > :174) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > > 66) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943 > > > ) > > at > > > > > > org.apache.catalina.connector.http.HttpProcessor.process(HttpP > rocessor.java: > > 1012) > > > at > > > > > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProce > ssor.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]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
