I tried the org.gjt.mm.mysql.Driver as well and to no avail. It is strange because I had it working and had to completely rebuild my system and enforce tighter firewall settings. Are there ports that need to be open for mysql and Torque/jetspeed to work together!? They are on the same machine. I have tcp ports 80, 8080, 3306, ssh, and the port to my cvspserver open and that is it (incoming). Otherwise my build is the same other than that I switched from Redhat 7.3 to 8.0.
I have also made sure that the mysql-connector*..jar does not have permission problems (it is in $CATALINA_HOME/common/lib). I guess I will try putting it in webapps/jetspeed/WEB-INF/lib but now I am really just shooting in the dark. Thanks for any help, Casey -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 6:14 AM To: [EMAIL PROTECTED] Subject: Re: MySQL Problems Importance: Low I think I remember reading on this list that Torque has problems w/ mysql's driver; try using org.gjt.mm.mysql.Driver instead. i.e. torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver hth, stu >>>> [EMAIL PROTECTED] 03/10/03 12:56AM >>> Hello, I have read others' problems connecting with mySql and still can't get past this error: Horrible Exception: java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): There was no DataSourceFactory configured for the connection sriportaldb at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseTu rbineUserPeer.java:154) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTur bineUserPeer.java:128).......... Here is a snippet from my Torque.properties file: # ------------------------------------------------------------------- # These are your database settings. Look in the # org.apache.pool.* packages for more information. # # The parameters to connect to the default database. You MUST # configure these properly. # ------------------------------------------------------------------- torque.database.default=sriportaldb #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 ## ##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.TorqueDataSourc eFactory # 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 torque.dsfactory.default.connection.driver = com.mysql.jdbc.Driver torque.dsfactory.default.connection.url = jdbc:mysql://localhost/sriportaldb?user=xxx&password=xxxx torque.dsfactory.default.connection.user = xxx torque.dsfactory.default.connection.password =xxxx #database.adaptor=DBMM #database.adaptor.DBMM=org.gjt.mm.mysql.Driver I can connect and see my sriportaldb database through phpMyAdmin and populated it with populatemysql (or whatever it is called) I have tried it with the port (3306) in the connection string and also without the username/password parameters. I also saw that someone else solved their problems with the #database.adaptor=DBMM #database.adaptor.DBMM=org.gjt.mm.mysql.Driver settings but that did not seem to help me. I also opened up port 3306 on my server to see if that could have something to do with it but no dice. Any other settings in any other file that I need? Thanks for any help, Casey --------------------------------------------------------------------- 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]
