I'm in the process of deploying on postgresql as well, so I spent some time investigating this. Just to be sure my own settings didn't break anything, I started with a completely clean CVS dist, and a completely new deployment.
1) I modified the turbine-postgres.sql file, adding the PASSWORD_CHANGED timestamp field. This MUST be the last field in the table, right after the oid. 2) I modified the populate-postgres.sql script, adding a NULL value at the end of the insert statements for each of the three users corresponding to the new timestamp field. 3) I deployed and started tomcat. Everything seemed to work. The postgresql scripts appear to be incorrect, but are easy to modify. It is *essential* that you put the field in the place that's specified in the Torque schema, though. Here, I'll attach the modified files. Good luck! -- Michael On 4/1/03 8:35 AM, "Harald Schl��er" <[EMAIL PROTECTED]> wrote: > 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] > > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
