You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Bradford Stephens <br...@gmail.com> on 2017/10/31 18:14:29 UTC
Not parsing james-database.properties?
Hi,
I'm using the 3.1.0-SNAPSHOT build from github as of Oct 12.
I'm trying to use mysql as a user store. I've confirmed my connection and
credentials work via command line. I'm using the guice+jpa docker image.
The mysql driver is in the extensions-jars directory and I see it loaded.
The error I'm seeing is:
<openjpa-2.4.2-r422266:1777108 fatal user error>
org.apache.openjpa.util.UserException: A connection could not be obtained
for driver class "com.mysql.jdbc.Driver" and URL "jdbc:mysql://
mailtestcluster.cluster-cqb1ky32n165.us-east-1.rds.amazonaws.com:3306/james".
You may have specified an invalid URL.
...
Caused by: java.sql.SQLException: Access denied for user
''@'104.153.230.195' (using password: NO)
As you can see, it has the user as '' and has no password. Is this a clue?
My james-database.properties is:
database.driverClassName=com.mysql.jdbc.Driver
database.url=jdbc:mysql://dbhost:3306/james
database.username=admin
database.password=password
vendorAdapter.database=MYSQL
openjpa.streaming=false
Thanks!
--
Bradford Stephens
roboticprofit.com
Data for Driving Revenue
Re: Not parsing james-database.properties?
Posted by Bradford Stephens <br...@gmail.com>.
Hi! Any wisdom on this?
On Tue, Oct 31, 2017 at 1:14 PM, Bradford Stephens <
bradfordstephens@gmail.com> wrote:
> Hi,
>
> I'm using the 3.1.0-SNAPSHOT build from github as of Oct 12.
>
> I'm trying to use mysql as a user store. I've confirmed my connection and
> credentials work via command line. I'm using the guice+jpa docker image.
> The mysql driver is in the extensions-jars directory and I see it loaded.
>
> The error I'm seeing is:
> <openjpa-2.4.2-r422266:1777108 fatal user error> org.apache.openjpa.util.UserException:
> A connection could not be obtained for driver class "com.mysql.jdbc.Driver"
> and URL "jdbc:mysql://mailtestcluster.cluster-cqb1ky32n165.us-east-
> 1.rds.amazonaws.com:3306/james". You may have specified an invalid URL.
> ...
> Caused by: java.sql.SQLException: Access denied for user
> ''@'104.153.230.195' (using password: NO)
>
> As you can see, it has the user as '' and has no password. Is this a clue?
>
>
> My james-database.properties is:
>
> database.driverClassName=com.mysql.jdbc.Driver
> database.url=jdbc:mysql://dbhost:3306/james
> database.username=admin
> database.password=password
> vendorAdapter.database=MYSQL
> openjpa.streaming=false
>
> Thanks!
>
> --
> Bradford Stephens
> roboticprofit.com
> Data for Driving Revenue
>
--
Bradford Stephens
roboticprofit.com
Data for Driving Revenue