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(BaseTurbineUserPeer.java:154)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTurbineUserPeer.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.TorqueDataSourceFactory # 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]
