Hi Scott! Hi Jetspeed-Users! I got it finally. It was a missing line in the sql script 'turbine-postgres.sql' provided for postgresql. The table 'TURBINE_USER' needed the additional column 'PASSWORD_CHANGED timestamp' The error was caused by accessing this column. Don't know why I got this error message.
But know I'm fighting the next problem. It seems to be that type imcompatibility thing as it is described on this site: http://db.apache.org/torque/postgres-howto.html Each time I try to create a new user I end up with: org.apache.jetspeed.services.security.UserException: Failed to create account 'cs': Bad conversion: java.lang.NumberFormatException: For input string: etc etc... com.workingdogs.village.DataSetException: Bad conversion: java.lang.NumberFormatException: For input string: " etc. etc. at com.workingdogs.village.Value.asInt(Unknown Source) at com.workingdogs.village.Value.setPreparedStatementValue(Unknown Source) at com.workingdogs.village.Record.saveWithInsert(Unknown Source) at com.workingdogs.village.Record.save(Unknown Source) at com.workingdogs.village.Record.save(Unknown Source) etc, etc, What I did so far: 1. Got the newest version of the village api 2. Tried the patch, but I learned that the version of Field.java doesn't contain the code pieces that should be replaced 3. Got the latest Postgresql JDBC-Driver Still the same. Any ideas? Harry -----Urspr�ngliche Nachricht----- Von: Weaver, Scott [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 1. April 2003 16:12 An: 'Jetspeed Users List' Betreff: RE: Newbie: Can't Jetspeed get starting with postgresql Hi Harald, Are you sure the Torque OM was built correctly? Try re-running "war" task and re-deploy. This is what line 166 looks line in the TurbineUserManagement class. criteria.add(TurbineUserPeer.LOGIN_NAME, principal.getName()); The only thing I can see causing the NoClassDefFoundError would not being able to load the TurbineUserPeer class. I know it's not much help but it's somewhere to start. hth, *===================================* * Scott T Weaver������������������� * * Jakarta Jetspeed Portal Project�� * * [EMAIL PROTECTED] * *===================================* � > -----Original Message----- > From: Harald Schl��er [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 01, 2003 7:43 AM > To: '[EMAIL PROTECTED]' > Subject: Newbie: Can't Jetspeed get starting with postgresql > > Dear Jetspeed-with-postgresql-users! > > I want to replace Jetspeeds dafault Hypersonic database by a > postgresql database. The database is already set up with the Jetspeed > SQL scripts for postgresql. > > My first impression was that actually everything is set up properly. > The database runs correctly and a connection seems to be possible. At > least the database rejects unknown users > in the torque configuration. > > But when I start Jetspeed it ends up with an error message. > > Are there any configuration secrets? > Could somebody give me an example how to configure Jetspeed with a > Postgresql database or tell me where I can find such an example? > > > Here's what Jetspeed says: > > Horrible Exception: java.lang.NoClassDefFoundError > at > org.apache.jetspeed.services.security.turbine.TurbineUserManagement.ge > tUse > r( > TurbineUserManagement.java:166) > at > org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserMa > na > gement.java:98) > at > org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAno > ny > mousUser(TurbineAuthentication.java:215) > at > org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jetsp > ee > dAuthentication.java:107) > at > org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSec > ur > ity.java:159) > at > org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(Tem > pl > ateSessionValidator.java:97) > at > org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(Jet > sp > eedSessionValidator.java:103) > at org.apache.turbine.modules.Action.perform(Action.java:87) > at > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) > at org.apache.turbine.Turbine.doGet(Turbine.java:521) > etc, etc: > > > Here're my components: > > Tomcat 4.1.18 > Jetspeed-1.4-b3 > postgresql-7.3.2 > > > Here's my torque configuration: > > torque.database.default=default > torque.database.default.adapter=postgresql > torque.dsfactory.default.connection.driver = org.postgresql.Driver > torque.dsfactory.default.connection.url = > jdbc:postgresql://127.0.0.1:5432/Jetspeed > torque.dsfactory.default.connection.user = HA > torque.dsfactory.default.connection.password = > > torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDat > aSou > rc > eFactory > > torque.dsfactory.default.pool.defaultMaxConnections=10 > torque.dsfactory.default.pool.maxExpiryTime=3600 > torque.dsfactory.default.pool.connectionWaitTimeout=10 > > torque.database.logInterval=0 torque.idbroker.cleverquantity=true > torque.manager.useCache = true > > Thank you in advance! > > Harald Schl��er --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
