(Thanks Benoit, Saibabu, and Simon for taking the time/trouble to answer my previous question on MySQL. It helped a lot!)
I have managed to get a little further setting up James 3.2.0 Spring with MySQL/MariaDB but have ran into a problem which Google is not being helpful. I appear to be having troubles with getting a connection going between James and the MariaDB server. I will provide a description of what I have done and then I will show the exception message I am getting which is stopping James from starting up... First of all I downloaded the MariaDB Connector/J .jar file from https://downloads.mariadb.org/connector-java/ and installed it in the conf/lib directory within the James installation. I then set up a database and user in MariaDB as follows - > mysql --user=root -p MariaDB [mysql]> create database mail; MariaDB [mysql]> create user 'james'@'localhost' identified by 'apassword'; MariaDB [mysql]> grant all privileges on mail to 'james'@'localhost'; I also created a system user for james and assigned it the same password. Next I edited the james-database.properties file as follows - database.driverClassName=org.mariadb.jdbc.Driver database.url=jdbc:mariadb://127.0.0.1:3306/mail database.username=james database.password=apassword vendorAdapter.database=MYSQL openjpa.streaming=false datasource.testOnBorrow=true datasource.validationQueryTimeoutSec=2 datasource.validationQuery=select 1 Telnetting to localhost port 3306 does show that the mariadb server is responding but hard to say exactly what is being communicated because a lot of the text has non-printable characters. I assume it is working OK... Upon starting up James I am getting exceptions with a huge amount of stack walkback messages, but I will try to capture just what appears to be relevant - INFO 22:03:05,852 | org.apache.james.domainlist.lib.AbstractDomainList | Set autodetectIP to: true WARN 22:03:06,000 | org.apache.james.container.spring.context.JamesServerApplicationContext | Exception encountered during context initial ization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'auth enticator' defined in class path resource [META-INF/org/apache/james/spring-mailbox-authenticator.xml]: Unsatisfied dependency expressed th rough constructor argument with index 0 of type [org.apache.james.user.api.UsersRepository]: : Error creating bean with name 'usersreposito ry': Invocation of init method failed; nested exception is <openjpa-3.0.0-r422266:1833209 nonfatal general error> org.apache.openjpa.persis tence.PersistenceException: There were errors initializing your configuration: <openjpa-3.0.0-r422266:1833209 fatal user error> org.apache. openjpa.util.UserException: A connection could not be obtained for driver class "null" and URL "null". You may have specified an invalid U RL. at org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:272) at org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:258) at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory(JDBCConfigurationImpl.java:735) ... (Lots more trace back messages followed by -) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'james@localhost'@'l ocalhost' (using password: YES)) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) and these exceptions/stack trace walkbacks repeat several time in the log file. Kinda hard for this poor soul to grok and I sure would appreciate it if wiser eyes could provide me with some ideas/pointers. I would be willing to send the entire log file if that would help, but warning it is a LOT! I am missing something simple probably.... Thanks again in advance for helping me over this bump... Marc... Linux Counter
