Hi Stijn,
Thanks for your reply and the details about your torque.properties. Thank you, I am now working.
The issue for me lay in not knowing what to call the database as I couldn't find any reference to it in the database configuration notes and the scripts don't create the database, so I tried using jetspeed from somebody else's Email but I configured torque.database.default=jetspeed as they had done, since I didn't understand how jetspeed selected the database in its connection parameters.
Your torque.database.default=default set me right.
I then ran into the 'can only create 4 users error'. I'd seen it earlier reported which is related to the auto increment parameter in the table create script - it also effected the Groups and others. I noticed David Sean Taylor had said he'd fixed the problem and so I tried the other script turbine-mysql.sql, which does fix the problem.
So I believe there is an issue with the turbine-mysql-4.sql script.
However, I noticed that turbine-mysql.sql doesn't fix an issue in the Create date field whereby new accounts are populated with 00000000000000.
Is this an issue or have I done something else wrong??
Thanks very much for your kind assistance.
Cheers, JJ
On 18/06/2004, at 9:13 PM, Stijn de Witt wrote:
No that shouldn't matter (I'm assuming you are running on mysql 4... :p )
Maybe you have made a mistake in your db configuration...
Check webapp/WEB-INF/conf/torque.properties. Here are my settings for mysql:
torque.database.default=default torque.database.default.adapter=mysql
### MySQL 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 = root torque.dsfactory.default.connection.password =
Also check your log: webapp/WEB-INF/log/jetspeed.log, but unfortunately the
ProfileException doesn't log a lot of detail. I guess it's a bit of trial
and error...
-Stijn
----- Original Message ----- From: "John & Emer Jennings" <[EMAIL PROTECTED]> To: "Jetspeed Users List" <[EMAIL PROTECTED]> Sent: Friday, June 18, 2004 3:35 AM Subject: Re: Error Migrating from Hypersonic-SQL to MySQL database
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.TorqueD at
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.fallba ck
Pr
ofile(JetspeedProfilerService.java:502)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getPro fi
le
(JetspeedProfilerService.java:245)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getPro fi
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Cheers, JJ
------------------------------------------ John Jennings
[EMAIL PROTECTED] ------------------------------------------
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
