Hi all,
I'm trying to run Mifos 1.2.2 on Ubuntu 9.04 (Jaunty) with the
following packages:
- mysql-server-5.0
- tomcat6
- sun-java5-jdk
- sun-java5-jre
- libmysql-java (provides /usr/share/java/mysql-connector-java-5.1.6.jar)
The Mifos WAR file is in /var/lib/tomcat6/webapps/ and the
`deploymifosDB.properties` file is in /usr/share/tomcat6/lib. The
`deploymifosDB.properties` file contains:
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost:3306/mifos
hibernate.connection.username=mifos
hibernate.connection.password=mifos
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.show_sql=false
hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory
hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider
hibernate.connection.isolation=2
hibernate.c3p0.acquire_increment=1
hibernate.c3p0.idle_test_period=100
hibernate.c3p0.max_size=20
hibernate.c3p0.max_statements=0
hibernate.c3p0.min_size=5
hibernate.c3p0.timeout=100
When I try to start Mifos from the Tomcat Web Application Manager, it
fails with the error message:
java.lang.Error:
org.mifos.framework.exceptions.AppNotConfiguredException: JDBC Driver
class not found: com.mysql.jdbc.driver
But when I remove `deploymifosDB.properties` from
/usr/share/tomcat6/lib, the Tomcat Web Application Manager is able to
run it. When I try to access Mifos, it gives me this error instead:
---MIFOS ERROR---
Mifos Database Error
A database error occurred. Correct the error and restart the
application. Details:
Unable to connect to database.
Possible causes:
* MySQL is not running
* MySQL is listening on a different port than Mifos is expecting
* incorrect username or password
More about configuring your database connection.
More details:
java.sql.SQLException: Connections could not be acquired from the
underlying database!
Mifos database connection using default settings. Connection
URL=jdbc:mysql://localhost:3306/mifos?useUnicode=true&characterEncoding=UTF-8.
Username=root. Password=********
---MIFOS ERROR---
This leads me to believe that it is able to use the JDBC driver and is
using the default configuration when it was compiled. Can someone
point me in the right direction?
Thanks!
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
