Re: A MySQL connection setup issue

2019-01-04 Thread Marc Chamberlin
Hi Garry -  Took quite a bit of sleuthing but I think I have made progress, at least solved one thing only to encounter another... Isn't that the way programming goes? LOL  Anywise it appears I made a mistake in granting privileges in MariaDB, I had executed the following - MariaDB [mysql]> gr

Re: A MySQL connection setup issue

2019-01-04 Thread Garry Hurley
One other thing. While there are entries in wrapper.conf to allow you to add files to the classpath, ONLY the lib folder is valid in James, so all of your jar files - including the sql files and any custom jars - MUST be in [JAMES_INSTALL_PATH]/lib and not some subdirectory. Even if you point to

Re: A MySQL connection setup issue

2019-01-04 Thread Marc Chamberlin
Hi Garry, and thanks for your thoughts also... Still no joy however...  The vendor class (database.driverClassName) in my configuration is the same as what you show here. Ditto for all the other parameters except for the database.url. I created a database called mail (not maildb) in MariaDB so

Re: A MySQL connection setup issue

2019-01-04 Thread Marc Chamberlin
Hi Sailbabu, Thanks for your thoughts but no joy...  MARIADB and MYSQL are identical in all respects, AFAIK, and according to OpenSUSE documentation fully compatible. Anywise, when I tried to change the vendorAdapter name as you suggested, to MARIADB, James threw a different exception basically

Re: A MySQL connection setup issue

2019-01-04 Thread Marc Chamberlin
Hi Simon and thanks for your thoughts...  Yes my usersrepository.xml is the same as the one on github.  The only difference was that I was using the MD5 algorithm and the github was using SHA-512. On a lark I changed mine to SHA-512 also but no joy... I didn't really expect that to make a diffe

Re: A MySQL connection setup issue

2019-01-04 Thread Garry Hurley
A few things I forgot to mention, make sure you have granted your user access to log in remotely, and that you have created whatever database you want to connect to (just do the create database ''; and it will work). Also, once you get past that point, you will likely find that the JPA classes don'

Re: A MySQL connection setup issue

2019-01-04 Thread Garry Hurley
The vendor class on the driver is supposed to match, but also be certain you are using Mariadb and not MySQL database and MariaDB client in your Linux distro. My config, which does work in the current branch (3.3.0 SNAPSHOT), is as follows. It goes without saying that your mileage my vary, and tha

Re: A MySQL connection setup issue

2019-01-04 Thread Saibabu Vallurupalli
your configurations are incorrect is what the error shows and I see you have got: vendorAdapter.database=MYSQL This should be : vendorAdapter.database=MARIADB Try changing this. Thanks, Sai On Fri, Jan 4, 2019 at 2:39 AM Marc Chamberlin wrote: > > (Thanks Benoit, Saibabu, and Simon for taking

Re: A MySQL connection setup issue

2019-01-04 Thread Simon Levesque
Hi Marc, I am no James expert, but with the information here, since it is the UsersRepository that has issue, do you have a usersrepository.xml config with https://github.com/foilen/foilen-infra-plugins-core/blob/master/src/main/resources/com/foilen/infra/resource/email/james/usersrepository.xml ?