Michael, I have been trying to get Postgres to work with Jetspeed 1.4b3 for several weeks with no success. Did you have to change build.properties in the Torque directory and rebuild Jetspeed, or did you just take a fresh build of Jetspeed and change the sql scripts and the torque.properties file?
Could you attach the complete set of files you have changed? Thanks in advance. Jamie. --- Michael Rothrock <[EMAIL PROTECTED]> wrote: > NB, it seems to have issues with postgresql 7.3, but > 7.2 (I'm using > 7.2.3-5.80) appears to work. > > -- Michael > > On 4/1/03 6:55 PM, "Michael Rothrock" > <[EMAIL PROTECTED]> wrote: > > > 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 > === message truncated === __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
