B4J Question jRDC to mariadb connection problem

[John Naylor]

Hi all - I'm tearing what's left of my hair out here.

I have a wampserver set up and can happily connect to a database when using the following in the config.properties file of jRDC (Mariadb 10.3.12 and java version 1.8.0_191)

DriverClass=org.mariadb.jdbc.Driver
JdbcUrl=jdbc:mariadb://localhost/STARDB?characterEncoding=utf8
User=root
Password=

and with

[CODE}#AdditionalJar: mariadb-java-client-2.4.0
[/CODE]

in main. As expected I get the correct response when runing localhost:17178/test in a browser and my b4a project can load tables perfectly.

I added a user with all priveleges

User - MyUserName, Host - % , Password - MyPassword, ALL PRIVILEGES, Grant -Yes

Changing nothing but

User=MyUserName
Password=MyPassword

I get 'Error fetching connection' when trying the test.

In the jRDC log window I see 'java.sql.SQLInvalidAuthorizationSpecException: Access denied for user 'MyUserName@%'@'localhost' (using password: YES)'

Have I missed something in the jRDC settings that I need to tweak or is this purely something to do with how my database user is set up (I suspect it is but have no idea what I'm doing wrong)? Any help would be very much appreciated.

 

[DonManfred]

I get 'Error fetching connection' when trying the test.

?? What do you mean by saying trying the test?

The link you can use in a browser is not a RDC Endpoint.

 

[John Naylor]

?? What do you mean by saying trying the test?

The link you can use in a browser is not a RDC Endpoint.

WHen I use localhost:17178/test in my browser with root and no password I get

RemoteServer is running (02/07/2019 16:15:11)
Connection successful.

but when I change the username settings and do the same localhost:17178/test in my browser I get

RemoteServer is running (02/07/2019 16:17:47)
Error fetching connection.

 

[John Naylor]

Thanks for the quick response btw Manfred! I'm rather new to all this!

 

[josejad]

It seems you have some problem with the privileges, instead with jRDC2. Can you connect from another PC with phpMyAdmin and "MyUserName" and "password"?

You're missing the port number too in: (localhost:3306)?

JdbcUrl=jdbc:mariadb://localhost/STARDB?characterEncoding=utf8

but anyway you say it works for you before this

 

[John Naylor]

I just added the port number but got the same results - it works with root and no password but fails with a username & password.

When attempting to connect from anoher PC I get an error that I don't have permission to access /phpmyadmin

 

[josejad]

I think it's not a jRDC2 problem then.
Try some of this links, and when you have access with the new user and password from phpmyadmin to your database, try jRDC2 again:

https://stackoverflow.com/questions...ermission-to-access-phpmyadmin-on-this-server
https://www.google.es/search?q=mysql+Access+denied+for+user

 

[DonManfred]

RemoteServer is running (02/07/2019 16:15:11)
Connection successful.

Ohh, sorry for irritating then... I was not aware that RDC does a connetion even on the Test Endpoint.

 

[John Naylor]

I think it's not a jRDC2 problem then.
Try some of this links, and when you have access with the new user and password from phpmyadmin to your database, try jRDC2 again:

https://stackoverflow.com/questions...ermission-to-access-phpmyadmin-on-this-server
https://www.google.es/search?q=mysql+Access+denied+for+user

Thankyou! I'll get on that this evening and let you know where I get to

 

[OliverA]

Are you adding @% to the end of your username?

 

[John Naylor]

Are you adding @% to the end of your username?

Hi Oliver I have tried with & without but I'm getting the same result.

I'm getting more convinced it's something to do with priviliges but as far as I can see the user has all priviliges set - I tried running it on my VMS with the same results (accounts on that were created manually rather than imported from my local database so I'm sure I'm doing something wrong along the line somewhere).

 

[John Naylor]

Ok I seem to have sorted it at last!

I set up a new user with all privileges and a nice long password - user name Sausage, PW - MyNiceLongPasswordThatNobodyIsGoingToGuess - I fed in the name & PW to the config.properties file (without the @%) and it worked a treat. I did however notice one subtle difference between the working account and the one that fails.

I made yet another account, Bacon - and added in the difference and low and behold Bacon failed.

The difference was so simple and was in the password. The accounts that failed have special characters in their passwords. The working account uses just regular alphabet (upper and lower case) and numbers.

Thank you so much to everyone that has dropped in to help out!

 

[DonManfred]

great you got it sorted