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 >>> 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
