You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by Steve Davis <st...@digitalevergreen.com> on 2001/06/24 21:11:10 UTC
Database scripts out of date
Could someone with CVS commit permission update the
jakarta-jetspeed/src/sql/external directory to include the
latest scripts from jakarta-turbine/src/sql. The current
scripts are not up to date for the version of Turbine that
is included in the CVS HEAD.
I am using mysql and there are 3 new scripts for Turbine
mysql-id-table-schema.sql
mysql-turbine-id-table-init.sql
mysql-turbine-security.sql
in addition to
mysql-turbine.sql
Turbine evidently needs an additional table "ID_TABLE" now to
create or delete a user. I was playing around with the new user/roles
admin and kept getting the following exception whenever I tried to
create or delete a user.
Exception: java.lang.reflect.InvocationTargetException
Stack Trace follows:
java.lang.reflect.InvocationTargetException:
java.sql.SQLException: General error: Table 'JETSPEED.ID_TABLE' doesn't
exist
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169)
at
org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78)
at com.workingdogs.village.Schema.schema(Schema.java:140)
at com.workingdogs.village.Schema.schema(Schema.java:107)
at com.workingdogs.village.DataSet.<init>(DataSet.java:167)
at
com.workingdogs.village.TableDataSet.<init>(TableDataSet.java:130)
at
org.apache.turbine.om.peer.BasePeer.doUpdate(BasePeer.java:1666)
at
org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:554)
at
org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:371)
at
org.apache.turbine.util.db.IDBroker.getIdAsBigDecimal(IDBroker.java:285)
at
org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:746)
at
org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:657)
at
org.apache.turbine.services.security.db.DBUserManager.createAccount(DBUs
erManager.java:399)
Thanks,
-- Steve Davis
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
RE: Database scripts out of date
Posted by David Sean Taylor <da...@bluesunrise.com>.
> Doesn't the TDK use Torque as well? It seems to me to be the
> best choice
> instead of having to fine tune each .sql script.
Yes, I agree.
I tried today to integrate the TDK Torque stuff with Jetspeed, but couldn't
get it to integrate.
So Im still perpetuating the scripts.
I hope to get some help from the TDK team later this week
Otherwise, we should leave the scripts in 1.3a2.
-------------------------------------
David Sean Taylor
taylor@apache.org
-------------------------------------
http://jakarta.apache.org/jetspeed
-------------------------------------
> -----Original Message-----
> From: Chris Anderson [mailto:cmda@mindspring.com]
> Sent: Sunday, June 24, 2001 12:45 PM
> To: jetspeed-dev@jakarta.apache.org; david@bluesunrise.com
> Subject: Re: Database scripts out of date
>
>
> Doesn't the TDK use Torque as well? It seems to me to be the
> best choice
> instead of having to fine tune each .sql script.
>
> ymmv
>
> Chris Anderson
>
> ----- Original Message -----
> From: "David Sean Taylor" <da...@bluesunrise.com>
> To: <je...@jakarta.apache.org>
> Sent: Sunday, June 24, 2001 3:39 PM
> Subject: RE: Database scripts out of date
>
>
> > > latest scripts from jakarta-turbine/src/sql. The current
> > > scripts are not up to date for the version of Turbine that
> > > is included in the CVS HEAD.
> >
> > Yes, i know.
> > We have been discussing this on some recent threads in the
> last week.
> >
> > I proposed distributing Torque with Jetspeed to keep the
> scripts in sync
> in
> > the future, but I received no response on my proposal.
> > I prefer distributing Torque, and removing the scripts.
> Anyone else have
> any
> > thoughts on this subject?
> >
> >
> > -------------------------------------
> > David Sean Taylor
> > taylor@apache.org
> > -------------------------------------
> > http://jakarta.apache.org/jetspeed
> > -------------------------------------
> >
> >
> >
> >
> > > -----Original Message-----
> > > From: Steve Davis [mailto:steve.davis@digitalevergreen.com]
> > > Sent: Sunday, June 24, 2001 12:11 PM
> > > To: jetspeed-user@jakarta.apache.org;
> jetspeed-dev@jakarta.apache.org
> > > Subject: Database scripts out of date
> > >
> > >
> > > Could someone with CVS commit permission update the
> > > jakarta-jetspeed/src/sql/external directory to include the
> > > latest scripts from jakarta-turbine/src/sql. The current
> > > scripts are not up to date for the version of Turbine that
> > > is included in the CVS HEAD.
> > >
> > > I am using mysql and there are 3 new scripts for Turbine
> > >
> > > mysql-id-table-schema.sql
> > > mysql-turbine-id-table-init.sql
> > > mysql-turbine-security.sql
> > >
> > > in addition to
> > >
> > > mysql-turbine.sql
> > >
> > > Turbine evidently needs an additional table "ID_TABLE" now to
> > > create or delete a user. I was playing around with the
> new user/roles
> > > admin and kept getting the following exception whenever I tried to
> > > create or delete a user.
> > >
> > > Exception: java.lang.reflect.InvocationTargetException
> > > Stack Trace follows:
> > > java.lang.reflect.InvocationTargetException:
> > > java.sql.SQLException: General error: Table
> > > 'JETSPEED.ID_TABLE' doesn't
> > > exist
> > > at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
> > > at
> org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
> > > at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
> > > at
> org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
> > > at
> org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
> > > at
> org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169)
> > > at
> > > org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78)
> > > at com.workingdogs.village.Schema.schema(Schema.java:140)
> > > at com.workingdogs.village.Schema.schema(Schema.java:107)
> > > at
> com.workingdogs.village.DataSet.<init>(DataSet.java:167)
> > > at
> > > com.workingdogs.village.TableDataSet.<init>(TableDataSet.java:130)
> > > at
> > > org.apache.turbine.om.peer.BasePeer.doUpdate(BasePeer.java:1666)
> > > at
> > > org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:554)
> > > at
> > > org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:371)
> > > at
> > > org.apache.turbine.util.db.IDBroker.getIdAsBigDecimal(IDBroker
> > > .java:285)
> > > at
> > > org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:746)
> > > at
> > > org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:657)
> > > at
> > > org.apache.turbine.services.security.db.DBUserManager.createAc
> > > count(DBUs
> > > erManager.java:399)
> > >
> > > Thanks,
> > >
> > > -- Steve Davis
> > >
> > >
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> jetspeed-dev-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail:
> jetspeed-dev-help@jakarta.apache.org
> > >
> > >
> >
> >
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> jetspeed-dev-help@jakarta.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
Re: Database scripts out of date
Posted by Chris Anderson <cm...@mindspring.com>.
Doesn't the TDK use Torque as well? It seems to me to be the best choice
instead of having to fine tune each .sql script.
ymmv
Chris Anderson
----- Original Message -----
From: "David Sean Taylor" <da...@bluesunrise.com>
To: <je...@jakarta.apache.org>
Sent: Sunday, June 24, 2001 3:39 PM
Subject: RE: Database scripts out of date
> > latest scripts from jakarta-turbine/src/sql. The current
> > scripts are not up to date for the version of Turbine that
> > is included in the CVS HEAD.
>
> Yes, i know.
> We have been discussing this on some recent threads in the last week.
>
> I proposed distributing Torque with Jetspeed to keep the scripts in sync
in
> the future, but I received no response on my proposal.
> I prefer distributing Torque, and removing the scripts. Anyone else have
any
> thoughts on this subject?
>
>
> -------------------------------------
> David Sean Taylor
> taylor@apache.org
> -------------------------------------
> http://jakarta.apache.org/jetspeed
> -------------------------------------
>
>
>
>
> > -----Original Message-----
> > From: Steve Davis [mailto:steve.davis@digitalevergreen.com]
> > Sent: Sunday, June 24, 2001 12:11 PM
> > To: jetspeed-user@jakarta.apache.org; jetspeed-dev@jakarta.apache.org
> > Subject: Database scripts out of date
> >
> >
> > Could someone with CVS commit permission update the
> > jakarta-jetspeed/src/sql/external directory to include the
> > latest scripts from jakarta-turbine/src/sql. The current
> > scripts are not up to date for the version of Turbine that
> > is included in the CVS HEAD.
> >
> > I am using mysql and there are 3 new scripts for Turbine
> >
> > mysql-id-table-schema.sql
> > mysql-turbine-id-table-init.sql
> > mysql-turbine-security.sql
> >
> > in addition to
> >
> > mysql-turbine.sql
> >
> > Turbine evidently needs an additional table "ID_TABLE" now to
> > create or delete a user. I was playing around with the new user/roles
> > admin and kept getting the following exception whenever I tried to
> > create or delete a user.
> >
> > Exception: java.lang.reflect.InvocationTargetException
> > Stack Trace follows:
> > java.lang.reflect.InvocationTargetException:
> > java.sql.SQLException: General error: Table
> > 'JETSPEED.ID_TABLE' doesn't
> > exist
> > at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
> > at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
> > at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
> > at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
> > at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
> > at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169)
> > at
> > org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78)
> > at com.workingdogs.village.Schema.schema(Schema.java:140)
> > at com.workingdogs.village.Schema.schema(Schema.java:107)
> > at com.workingdogs.village.DataSet.<init>(DataSet.java:167)
> > at
> > com.workingdogs.village.TableDataSet.<init>(TableDataSet.java:130)
> > at
> > org.apache.turbine.om.peer.BasePeer.doUpdate(BasePeer.java:1666)
> > at
> > org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:554)
> > at
> > org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:371)
> > at
> > org.apache.turbine.util.db.IDBroker.getIdAsBigDecimal(IDBroker
> > .java:285)
> > at
> > org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:746)
> > at
> > org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:657)
> > at
> > org.apache.turbine.services.security.db.DBUserManager.createAc
> > count(DBUs
> > erManager.java:399)
> >
> > Thanks,
> >
> > -- Steve Davis
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
RE: Database scripts out of date
Posted by Dirk Hamstra <di...@iona.com>.
>I proposed distributing Torque with Jetspeed to keep the scripts in sync in
>the future, but I received no response on my proposal.
>I prefer distributing Torque, and removing the scripts. Anyone
>else have any
>thoughts on this subject?
Ditch the scripts +1 on Torque
-Dirk
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
RE: Database scripts out of date
Posted by David Sean Taylor <da...@bluesunrise.com>.
> latest scripts from jakarta-turbine/src/sql. The current
> scripts are not up to date for the version of Turbine that
> is included in the CVS HEAD.
Yes, i know.
We have been discussing this on some recent threads in the last week.
I proposed distributing Torque with Jetspeed to keep the scripts in sync in
the future, but I received no response on my proposal.
I prefer distributing Torque, and removing the scripts. Anyone else have any
thoughts on this subject?
-------------------------------------
David Sean Taylor
taylor@apache.org
-------------------------------------
http://jakarta.apache.org/jetspeed
-------------------------------------
> -----Original Message-----
> From: Steve Davis [mailto:steve.davis@digitalevergreen.com]
> Sent: Sunday, June 24, 2001 12:11 PM
> To: jetspeed-user@jakarta.apache.org; jetspeed-dev@jakarta.apache.org
> Subject: Database scripts out of date
>
>
> Could someone with CVS commit permission update the
> jakarta-jetspeed/src/sql/external directory to include the
> latest scripts from jakarta-turbine/src/sql. The current
> scripts are not up to date for the version of Turbine that
> is included in the CVS HEAD.
>
> I am using mysql and there are 3 new scripts for Turbine
>
> mysql-id-table-schema.sql
> mysql-turbine-id-table-init.sql
> mysql-turbine-security.sql
>
> in addition to
>
> mysql-turbine.sql
>
> Turbine evidently needs an additional table "ID_TABLE" now to
> create or delete a user. I was playing around with the new user/roles
> admin and kept getting the following exception whenever I tried to
> create or delete a user.
>
> Exception: java.lang.reflect.InvocationTargetException
> Stack Trace follows:
> java.lang.reflect.InvocationTargetException:
> java.sql.SQLException: General error: Table
> 'JETSPEED.ID_TABLE' doesn't
> exist
> at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
> at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
> at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
> at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
> at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
> at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169)
> at
> org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78)
> at com.workingdogs.village.Schema.schema(Schema.java:140)
> at com.workingdogs.village.Schema.schema(Schema.java:107)
> at com.workingdogs.village.DataSet.<init>(DataSet.java:167)
> at
> com.workingdogs.village.TableDataSet.<init>(TableDataSet.java:130)
> at
> org.apache.turbine.om.peer.BasePeer.doUpdate(BasePeer.java:1666)
> at
> org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:554)
> at
> org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:371)
> at
> org.apache.turbine.util.db.IDBroker.getIdAsBigDecimal(IDBroker
> .java:285)
> at
> org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:746)
> at
> org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:657)
> at
> org.apache.turbine.services.security.db.DBUserManager.createAc
> count(DBUs
> erManager.java:399)
>
> Thanks,
>
> -- Steve Davis
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
Re: Database scripts out of date
Posted by Narayanan Natarajan <na...@nonhp-sg.exch.hp.com>.
Hi,
Could you please tell me the location where I can get the updated Scripts?
Kind Regards,
N.Natarajan
> I've updated these two scripts to match the latest turbine schema:
>
> - turbine-mysql.sql
> - turbine-oracle.sql
>
> Added two new scripts to populate the database:
>
> - populate-mysql.sql
> - populate-oracle.sql
>
> Here are some quick instructions for using Oracle and MySQL with Jetspeed.
> I hope it can help with the problems people have experienced recently.
> My apologies to Bruno and everyone for leaving the database scripts in
such
> a state.
>
> --------------------------------------------------------------------------
--
> ---------------------------
> ORACLE
> -----------------
>
> ... if you haven't already created a turbine schema, do so by loggin on to
> sqlplus as 'system' and create your schema like this:
>
> -- this is brute force, you may want to refine your grants and
> permissions...
> GRANT RESOURCE,DBA TO TURBINE IDENTIFIED BY TURBINE;
>
> ...run 'sqlplus' from the src/sql/external directory
> ....logon into your Turbine schema (TURBINE/TURBINE), and type:
>
> @turbine-oracle.sql
>
> ...look for errors...hopefully there arent' any
> ... and then
>
> @populate-oracle.sql
>
> ...modify your TR.p, commenting out:
>
> #database.default.driver=org.hsql.jdbcDriver
> #database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
> #database.default.username=sa
> #database.default.password=
>
> #database.adaptor=DBHypersonicSQL
> #database.adaptor.DBHypersonicSQL=org.hsql.jdbcDriver
>
> ...and adding:
>
> database.default.driver=oracle.jdbc.driver.OracleDriver
> database.default.url=jdbc:oracle:thin:@<host>:1521:<sid>
> database.default.username=turbine
> database.default.password=turbine
>
> database.adaptor=DBOracle
> database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
>
> ....don't forget to put classes12.zip in your classpath, and rename it:
>
> classes12.jar
>
> ... test it out
>
> --------------------------------------------------------------------------
--
> ---------------------------
> MYSQL
> ----------
>
> ...if you haven't already created a turbine database, create one:
>
> cd mysql/data
>
> md turbine
>
> ...run 'mysql' from the src/sql/external directory:
>
> connect turbine
>
> source turbine-mysql.sql
>
> ...look for errors...hopefully there arent' any
> ... and then
>
> source populate-mysql.sql
>
> ...modify your TR.p, commenting out:
>
> #database.default.driver=org.hsql.jdbcDriver
> #database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
> #database.default.username=sa
> #database.default.password=
>
> #database.adaptor=DBHypersonicSQL
> #database.adaptor.DBHypersonicSQL=org.hsql.jdbcDriver
>
> ...and adding:
>
> database.default.driver=org.gjt.mm.mysql.Driver
> database.default.url=jdbc:mysql://localhost/turbine # could be any
host...
> database.default.username=root
> database.default.password=
>
> database.adaptor=DBMM
> database.adaptor.DBMM=org.gjt.mm.mysql.Driver
>
> ....don't forget to put your mysql.jar in the classpath
>
> ... test it out
> --------------------------------------------------------------------------
--
> ---------------------------
> (REMINDER TO MYSELF: put these instructions in a FAQ later this week.)
>
> The other databases (db2, postgres, and sybase) haven't been converted
yet.
>
> Does anyone know if DB2 or Sybase have a trial version that I can test
with?
>
> I was trying to get Torque working, but I had some problems and now I've
ran
> out of time.
> So I just cranked out these patches for now.
> Will try to finish Torque support and the Security/Admin stuff when I get
> back Thursday.
>
> Good luck with the scripts. They seemed to work fine in my testing here on
> mySQL 3.23 and Oracle8.1.6
>
> Im going out of town for 3 days vacation...
>
> -------------------------------------
> David Sean Taylor
> taylor@apache.org
> -------------------------------------
> http://jakarta.apache.org/jetspeed
> -------------------------------------
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
Re: Database scripts out of date
Posted by Narayanan Natarajan <na...@nonhp-sg.exch.hp.com>.
Hi,
Could you please tell me the location where I can get the updated Scripts?
Kind Regards,
N.Natarajan
> I've updated these two scripts to match the latest turbine schema:
>
> - turbine-mysql.sql
> - turbine-oracle.sql
>
> Added two new scripts to populate the database:
>
> - populate-mysql.sql
> - populate-oracle.sql
>
> Here are some quick instructions for using Oracle and MySQL with Jetspeed.
> I hope it can help with the problems people have experienced recently.
> My apologies to Bruno and everyone for leaving the database scripts in
such
> a state.
>
> --------------------------------------------------------------------------
--
> ---------------------------
> ORACLE
> -----------------
>
> ... if you haven't already created a turbine schema, do so by loggin on to
> sqlplus as 'system' and create your schema like this:
>
> -- this is brute force, you may want to refine your grants and
> permissions...
> GRANT RESOURCE,DBA TO TURBINE IDENTIFIED BY TURBINE;
>
> ...run 'sqlplus' from the src/sql/external directory
> ....logon into your Turbine schema (TURBINE/TURBINE), and type:
>
> @turbine-oracle.sql
>
> ...look for errors...hopefully there arent' any
> ... and then
>
> @populate-oracle.sql
>
> ...modify your TR.p, commenting out:
>
> #database.default.driver=org.hsql.jdbcDriver
> #database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
> #database.default.username=sa
> #database.default.password=
>
> #database.adaptor=DBHypersonicSQL
> #database.adaptor.DBHypersonicSQL=org.hsql.jdbcDriver
>
> ...and adding:
>
> database.default.driver=oracle.jdbc.driver.OracleDriver
> database.default.url=jdbc:oracle:thin:@<host>:1521:<sid>
> database.default.username=turbine
> database.default.password=turbine
>
> database.adaptor=DBOracle
> database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
>
> ....don't forget to put classes12.zip in your classpath, and rename it:
>
> classes12.jar
>
> ... test it out
>
> --------------------------------------------------------------------------
--
> ---------------------------
> MYSQL
> ----------
>
> ...if you haven't already created a turbine database, create one:
>
> cd mysql/data
>
> md turbine
>
> ...run 'mysql' from the src/sql/external directory:
>
> connect turbine
>
> source turbine-mysql.sql
>
> ...look for errors...hopefully there arent' any
> ... and then
>
> source populate-mysql.sql
>
> ...modify your TR.p, commenting out:
>
> #database.default.driver=org.hsql.jdbcDriver
> #database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
> #database.default.username=sa
> #database.default.password=
>
> #database.adaptor=DBHypersonicSQL
> #database.adaptor.DBHypersonicSQL=org.hsql.jdbcDriver
>
> ...and adding:
>
> database.default.driver=org.gjt.mm.mysql.Driver
> database.default.url=jdbc:mysql://localhost/turbine # could be any
host...
> database.default.username=root
> database.default.password=
>
> database.adaptor=DBMM
> database.adaptor.DBMM=org.gjt.mm.mysql.Driver
>
> ....don't forget to put your mysql.jar in the classpath
>
> ... test it out
> --------------------------------------------------------------------------
--
> ---------------------------
> (REMINDER TO MYSELF: put these instructions in a FAQ later this week.)
>
> The other databases (db2, postgres, and sybase) haven't been converted
yet.
>
> Does anyone know if DB2 or Sybase have a trial version that I can test
with?
>
> I was trying to get Torque working, but I had some problems and now I've
ran
> out of time.
> So I just cranked out these patches for now.
> Will try to finish Torque support and the Security/Admin stuff when I get
> back Thursday.
>
> Good luck with the scripts. They seemed to work fine in my testing here on
> mySQL 3.23 and Oracle8.1.6
>
> Im going out of town for 3 days vacation...
>
> -------------------------------------
> David Sean Taylor
> taylor@apache.org
> -------------------------------------
> http://jakarta.apache.org/jetspeed
> -------------------------------------
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org
Re: Database scripts out of date
Posted by Narayanan Natarajan <na...@nonhp-sg.exch.hp.com>.
Hi,
Could you please tell me the location where I can get the updated Scripts?
Kind Regards,
N.Natarajan
> I've updated these two scripts to match the latest turbine schema:
>
> - turbine-mysql.sql
> - turbine-oracle.sql
>
> Added two new scripts to populate the database:
>
> - populate-mysql.sql
> - populate-oracle.sql
>
> Here are some quick instructions for using Oracle and MySQL with Jetspeed.
> I hope it can help with the problems people have experienced recently.
> My apologies to Bruno and everyone for leaving the database scripts in
such
> a state.
>
> --------------------------------------------------------------------------
--
> ---------------------------
> ORACLE
> -----------------
>
> ... if you haven't already created a turbine schema, do so by loggin on to
> sqlplus as 'system' and create your schema like this:
>
> -- this is brute force, you may want to refine your grants and
> permissions...
> GRANT RESOURCE,DBA TO TURBINE IDENTIFIED BY TURBINE;
>
> ...run 'sqlplus' from the src/sql/external directory
> ....logon into your Turbine schema (TURBINE/TURBINE), and type:
>
> @turbine-oracle.sql
>
> ...look for errors...hopefully there arent' any
> ... and then
>
> @populate-oracle.sql
>
> ...modify your TR.p, commenting out:
>
> #database.default.driver=org.hsql.jdbcDriver
> #database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
> #database.default.username=sa
> #database.default.password=
>
> #database.adaptor=DBHypersonicSQL
> #database.adaptor.DBHypersonicSQL=org.hsql.jdbcDriver
>
> ...and adding:
>
> database.default.driver=oracle.jdbc.driver.OracleDriver
> database.default.url=jdbc:oracle:thin:@<host>:1521:<sid>
> database.default.username=turbine
> database.default.password=turbine
>
> database.adaptor=DBOracle
> database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
>
> ....don't forget to put classes12.zip in your classpath, and rename it:
>
> classes12.jar
>
> ... test it out
>
> --------------------------------------------------------------------------
--
> ---------------------------
> MYSQL
> ----------
>
> ...if you haven't already created a turbine database, create one:
>
> cd mysql/data
>
> md turbine
>
> ...run 'mysql' from the src/sql/external directory:
>
> connect turbine
>
> source turbine-mysql.sql
>
> ...look for errors...hopefully there arent' any
> ... and then
>
> source populate-mysql.sql
>
> ...modify your TR.p, commenting out:
>
> #database.default.driver=org.hsql.jdbcDriver
> #database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
> #database.default.username=sa
> #database.default.password=
>
> #database.adaptor=DBHypersonicSQL
> #database.adaptor.DBHypersonicSQL=org.hsql.jdbcDriver
>
> ...and adding:
>
> database.default.driver=org.gjt.mm.mysql.Driver
> database.default.url=jdbc:mysql://localhost/turbine # could be any
host...
> database.default.username=root
> database.default.password=
>
> database.adaptor=DBMM
> database.adaptor.DBMM=org.gjt.mm.mysql.Driver
>
> ....don't forget to put your mysql.jar in the classpath
>
> ... test it out
> --------------------------------------------------------------------------
--
> ---------------------------
> (REMINDER TO MYSELF: put these instructions in a FAQ later this week.)
>
> The other databases (db2, postgres, and sybase) haven't been converted
yet.
>
> Does anyone know if DB2 or Sybase have a trial version that I can test
with?
>
> I was trying to get Torque working, but I had some problems and now I've
ran
> out of time.
> So I just cranked out these patches for now.
> Will try to finish Torque support and the Security/Admin stuff when I get
> back Thursday.
>
> Good luck with the scripts. They seemed to work fine in my testing here on
> mySQL 3.23 and Oracle8.1.6
>
> Im going out of town for 3 days vacation...
>
> -------------------------------------
> David Sean Taylor
> taylor@apache.org
> -------------------------------------
> http://jakarta.apache.org/jetspeed
> -------------------------------------
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org
Re: Database scripts out of date
Posted by Narayanan Natarajan <na...@nonhp-sg.exch.hp.com>.
Hi,
Could you please tell me the location where I can get the updated Scripts?
Kind Regards,
N.Natarajan
> I've updated these two scripts to match the latest turbine schema:
>
> - turbine-mysql.sql
> - turbine-oracle.sql
>
> Added two new scripts to populate the database:
>
> - populate-mysql.sql
> - populate-oracle.sql
>
> Here are some quick instructions for using Oracle and MySQL with Jetspeed.
> I hope it can help with the problems people have experienced recently.
> My apologies to Bruno and everyone for leaving the database scripts in
such
> a state.
>
> --------------------------------------------------------------------------
--
> ---------------------------
> ORACLE
> -----------------
>
> ... if you haven't already created a turbine schema, do so by loggin on to
> sqlplus as 'system' and create your schema like this:
>
> -- this is brute force, you may want to refine your grants and
> permissions...
> GRANT RESOURCE,DBA TO TURBINE IDENTIFIED BY TURBINE;
>
> ...run 'sqlplus' from the src/sql/external directory
> ....logon into your Turbine schema (TURBINE/TURBINE), and type:
>
> @turbine-oracle.sql
>
> ...look for errors...hopefully there arent' any
> ... and then
>
> @populate-oracle.sql
>
> ...modify your TR.p, commenting out:
>
> #database.default.driver=org.hsql.jdbcDriver
> #database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
> #database.default.username=sa
> #database.default.password=
>
> #database.adaptor=DBHypersonicSQL
> #database.adaptor.DBHypersonicSQL=org.hsql.jdbcDriver
>
> ...and adding:
>
> database.default.driver=oracle.jdbc.driver.OracleDriver
> database.default.url=jdbc:oracle:thin:@<host>:1521:<sid>
> database.default.username=turbine
> database.default.password=turbine
>
> database.adaptor=DBOracle
> database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
>
> ....don't forget to put classes12.zip in your classpath, and rename it:
>
> classes12.jar
>
> ... test it out
>
> --------------------------------------------------------------------------
--
> ---------------------------
> MYSQL
> ----------
>
> ...if you haven't already created a turbine database, create one:
>
> cd mysql/data
>
> md turbine
>
> ...run 'mysql' from the src/sql/external directory:
>
> connect turbine
>
> source turbine-mysql.sql
>
> ...look for errors...hopefully there arent' any
> ... and then
>
> source populate-mysql.sql
>
> ...modify your TR.p, commenting out:
>
> #database.default.driver=org.hsql.jdbcDriver
> #database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
> #database.default.username=sa
> #database.default.password=
>
> #database.adaptor=DBHypersonicSQL
> #database.adaptor.DBHypersonicSQL=org.hsql.jdbcDriver
>
> ...and adding:
>
> database.default.driver=org.gjt.mm.mysql.Driver
> database.default.url=jdbc:mysql://localhost/turbine # could be any
host...
> database.default.username=root
> database.default.password=
>
> database.adaptor=DBMM
> database.adaptor.DBMM=org.gjt.mm.mysql.Driver
>
> ....don't forget to put your mysql.jar in the classpath
>
> ... test it out
> --------------------------------------------------------------------------
--
> ---------------------------
> (REMINDER TO MYSELF: put these instructions in a FAQ later this week.)
>
> The other databases (db2, postgres, and sybase) haven't been converted
yet.
>
> Does anyone know if DB2 or Sybase have a trial version that I can test
with?
>
> I was trying to get Torque working, but I had some problems and now I've
ran
> out of time.
> So I just cranked out these patches for now.
> Will try to finish Torque support and the Security/Admin stuff when I get
> back Thursday.
>
> Good luck with the scripts. They seemed to work fine in my testing here on
> mySQL 3.23 and Oracle8.1.6
>
> Im going out of town for 3 days vacation...
>
> -------------------------------------
> David Sean Taylor
> taylor@apache.org
> -------------------------------------
> http://jakarta.apache.org/jetspeed
> -------------------------------------
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
RE: Database scripts out of date
Posted by David Sean Taylor <da...@bluesunrise.com>.
I've updated these two scripts to match the latest turbine schema:
- turbine-mysql.sql
- turbine-oracle.sql
Added two new scripts to populate the database:
- populate-mysql.sql
- populate-oracle.sql
Here are some quick instructions for using Oracle and MySQL with Jetspeed.
I hope it can help with the problems people have experienced recently.
My apologies to Bruno and everyone for leaving the database scripts in such
a state.
----------------------------------------------------------------------------
---------------------------
ORACLE
-----------------
... if you haven't already created a turbine schema, do so by loggin on to
sqlplus as 'system' and create your schema like this:
-- this is brute force, you may want to refine your grants and
permissions...
GRANT RESOURCE,DBA TO TURBINE IDENTIFIED BY TURBINE;
...run 'sqlplus' from the src/sql/external directory
....logon into your Turbine schema (TURBINE/TURBINE), and type:
@turbine-oracle.sql
...look for errors...hopefully there arent' any
... and then
@populate-oracle.sql
...modify your TR.p, commenting out:
#database.default.driver=org.hsql.jdbcDriver
#database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
#database.default.username=sa
#database.default.password=
#database.adaptor=DBHypersonicSQL
#database.adaptor.DBHypersonicSQL=org.hsql.jdbcDriver
...and adding:
database.default.driver=oracle.jdbc.driver.OracleDriver
database.default.url=jdbc:oracle:thin:@<host>:1521:<sid>
database.default.username=turbine
database.default.password=turbine
database.adaptor=DBOracle
database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
....don't forget to put classes12.zip in your classpath, and rename it:
classes12.jar
... test it out
----------------------------------------------------------------------------
---------------------------
MYSQL
----------
...if you haven't already created a turbine database, create one:
cd mysql/data
md turbine
...run 'mysql' from the src/sql/external directory:
connect turbine
source turbine-mysql.sql
...look for errors...hopefully there arent' any
... and then
source populate-mysql.sql
...modify your TR.p, commenting out:
#database.default.driver=org.hsql.jdbcDriver
#database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
#database.default.username=sa
#database.default.password=
#database.adaptor=DBHypersonicSQL
#database.adaptor.DBHypersonicSQL=org.hsql.jdbcDriver
...and adding:
database.default.driver=org.gjt.mm.mysql.Driver
database.default.url=jdbc:mysql://localhost/turbine # could be any host...
database.default.username=root
database.default.password=
database.adaptor=DBMM
database.adaptor.DBMM=org.gjt.mm.mysql.Driver
....don't forget to put your mysql.jar in the classpath
... test it out
----------------------------------------------------------------------------
---------------------------
(REMINDER TO MYSELF: put these instructions in a FAQ later this week.)
The other databases (db2, postgres, and sybase) haven't been converted yet.
Does anyone know if DB2 or Sybase have a trial version that I can test with?
I was trying to get Torque working, but I had some problems and now I've ran
out of time.
So I just cranked out these patches for now.
Will try to finish Torque support and the Security/Admin stuff when I get
back Thursday.
Good luck with the scripts. They seemed to work fine in my testing here on
mySQL 3.23 and Oracle8.1.6
Im going out of town for 3 days vacation...
-------------------------------------
David Sean Taylor
taylor@apache.org
-------------------------------------
http://jakarta.apache.org/jetspeed
-------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
RE: Database scripts out of date
Posted by David Sean Taylor <da...@bluesunrise.com>.
> create or delete a user. I was playing around with the new user/roles
> admin and kept getting the following exception whenever I tried to
> create or delete a user.
>
Steve,
The new user/role stuff is still under construction.
Should have this completed by end of this week...
Ive committed new scripts for mySQL and Oracle (see prev. email)
The implemented admin templates seem to work fine with mySQL now.
Please verify if you get a chance
thanks
David
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org