Re: Not parsing james-database.properties?

2017-11-13 Thread Bradford Stephens
Hi! Any wisdom on this?

On Tue, Oct 31, 2017 at 1:14 PM, Bradford Stephens <
bradfordsteph...@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:
>  
> 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


Not parsing james-database.properties?

2017-10-31 Thread Bradford Stephens
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:

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