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.TorqueDataS > 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.fallbackPr > ofile(JetspeedProfilerService.java:502) > at > org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile > (JetspeedProfilerService.java:245) > at > org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile > (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]
