Thanks for your fast response Stijn,
I did populate and the database is all there as per the scripts with 3 users, jetspeed, tommy and anon, and I can query them via a PHP web page using the configured account details.
I did however use the turbine-mysql-4.sql script, would that make any difference as opposed to the turbine-mysql.sql script?
Thanks, JJ
On 18/06/2004, at 11:09 AM, Stijn de Witt wrote:
Check if the turbine tables are created. use the commands
use <databasename>; show tables;
in mysql. If it does not show a table named turbine user, that explains it.
If that is the case, you need to execute the scripts
src/sql/external/turbine-mysql.sql and src/sql/external/populate-mysql.sql.
Also, look here:
http://portals.apache.org/jetspeed-1/database.html
Hope that helps, -Stijn
----- Original Message ----- From: "John & Emer Jennings" <[EMAIL PROTECTED]> To: "Jetspeed Users List" <[EMAIL PROTECTED]> Sent: Friday, June 18, 2004 2:48 AM Subject: Error Migrating from Hypersonic-SQL to MySQL database
Hi,
Im getting the following error migrating from Hypersonic-SQL to MySQL database
org.apache.jetspeed.om.profile.ProfileException: java.lang.NullPointerException
I noted some other users with the same problem but I couldn't see any response or suggestions.
Re The Mail Archive
Same problem at; http://www.mail-archive.com/jetspeed-user%40jakarta.apache.org/ msg12178.html
I'm a complete newbe to Jetspeed and mail lists so apologies if I've missed the replies, I'm just looking to use Jetspeed.
What am I doing wrong? Would greatly appreciate any help to end sleepless nights.
Configuration details below.
Cheers, JJ
------------------------------------------ John Jennings
[EMAIL PROTECTED] ------------------------------------------
Error migrating from Hypersonic-SQL to MySQL database *********************************************
Using jakarta-tomcat-5.0.25 binary version on a Mac 10.3.4
MySQL version 4.0.18-standard
Default install seems to work fine out-of-the-box.
********************************************* Installation - Database Configuration http://portals.apache.org/jetspeed-1/install.html
'modify BOTH the project.properties in the root directory and the webapp/WEB-INF/conf/Torque.properties file...'
There was no project.properties, I assume because I'm using a binary install? (Did try using one though but it didn't make any difference and since I'm not using Maven I don't expect it to do anything??.)
********************************************* Mods to Torque.properties
#MySQL configured JJ 15/06/2004 torque.database.default=jetspeed ## torque.database.default.adapter=hypersonic torque.database.default.adapter=mysql ### torque.database.default.adapter=oracle ### torque.database.default.adapter=mssql
## ## Using torque's old pool ## #MySQL configured JJ 15/06/2004 - commented out the fields below
## torque.dsfactory.default.connection.driver = org.hsqldb.jdbcDriver ## torque.dsfactory.default.connection.url = jdbc:hsqldb:${webappRoot}/WEB-INF/db/jetspeed ## torque.dsfactory.default.connection.user = sa ## torque.dsfactory.default.connection.password =
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDat aS
ourceFactory
# The number of database connections to cache per ConnectionPool
instance (specified per database)
torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=3600
torque.dsfactory.default.pool.connectionWaitTimeout=10
### MySQL #MySQL configured JJ 15/06/2004 - uncommented the fields below
torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/jetspeed torque.dsfactory.default.connection.user = phpuser torque.dsfactory.default.connection.password = phppass
********************************************* Built the jetspeed database in MySQL using the scripts populate-mysql.sql and turbine-mysql-4.sql.
Seemed to build and populate correctly. Can connect & query jetspeed database via PHP from web page using above account details.
Another Java app running on Tomcat - contineo - connnects to its MySQL database OK using the above parameters.
Copying contineo have put mysql-connector-java-3.0.11-stable-bin.jar in
directory as per below;
/usr/local/jakarta-tomcat-5.0.25/webapps/jetspeed/WEB-INF/lib/mysql- connector-java-3.0.11-stable-bin.jar
Made no difference.
********************************************* http://localhost:8080/jetspeed/
Jetspeed opens with the following error;
There has been an Error! Reason: org.apache.jetspeed.om.profile.ProfileException: java.lang.NullPointerException
Get/Post Data:
template = /html/ShowError.vm
Stacktrace:
org.apache.jetspeed.om.profile.ProfileException:
java.lang.NullPointerException
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallback Pr
ofile(JetspeedProfilerService.java:502)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfi le
(JetspeedProfilerService.java:245)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfi le
(JetspeedProfilerService.java:528)
at
org.apache.jetspeed.services.Profiler.getProfile(Profiler.java:87)
...
*********************************************
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
