Android Question RDC config.properties MariaDB

[luke2012]

Hi All,
I'm trying to configure RDC framework (by @Erel) to connect a MariaDB database server.

The MariaDB database server is running within a machine with private IP (ex. 192.168.1.XX)
I not sure that the jdbc configuration is ok (see belove):

#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.
DriverClass=org.mariadb.jdbc.Driver
JdbcUrl=jdbc:mariadb://192.168.1.XX/test?characterEncoding=utf8

So my target is to set RDC to connect to the remote database server (MariaDB).

Thanks in advance for your help

 

[Erel]

Why are you using RDC instead of jRDC2?

 

[luke2012]

Why are you using RDC instead of jRDC2?

Good question So I you suggesting me to use jRDC2 that is better?

 

[Erel]

You should never start a new project based on an old version of a key component...

 

[Alexander Stolte]

jRDC2 is newer then the old RDC. It is recommended to use this and it is also worthwhile from the speed.

 

[luke2012]

Why are you using RDC instead of jRDC2?

So assuming to use JRDC2 (https://goo.gl/EbV8rr), I think that the jdbc configuration is the same as old RDC framework correct?

#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.
DriverClass=org.mariadb.jdbc.Driver
JdbcUrl=jdbc:mariadb://192.168.1.XX/test?characterEncoding=utf8

 

[DonManfred]

JdbcUrl=jdbc:mariadb://192.168.1.XX/test?characterEncoding=utf8

mariadb:// ???

Try http://

 

[Alexander Stolte]

same as old RDC framework correct?

from the 2 lines you post, yes.

 

[Alexander Stolte]

mariadb:// ???

Try http://

both works don.

in my jRDC's i use this:

JdbcUrl=jdbc:mysql://localhost/myDatabase?characterEncoding=utf8&useSSL=false&useUnicode=true

 

[luke2012]

both works don.

in my jRDC's i use this:

JdbcUrl=jdbc:mysql://localhost/myDatabase?characterEncoding=utf8&useSSL=false&useUnicode=true

The db server is a MariaDB version. So I suppose that the JdbcUrl should be a "jdbc:mariadb..." instead of "jdbc:mysql...". Correct ?

 

[OliverA]

According to (https://mariadb.com/kb/en/library/about-mariadb-connector-j/), yes. What happened to just trying? It would have either worked or failed, but in either cases something would have been learned.

 

[luke2012]

All Done! I did the jRDC2 setup:

RemoteServer is running (03/07/2018 16:53:19)
Error fetching connection.

Within the b4j log I read an error:

java.sql.SQLException: Host 'DESKTOP-ICOQJHD.fritz.box' is not allowed to connect to this MariaDB server

Why this? It seem that the MariaDB Server has an internal security that block the machine that called the test handler (http://localhost:17178/test)...

Note that the MariaDB server and jRDC server are running on different VMs (and IPs).

 

[OliverA]

MySQL, and most likely MariaDB, are configured initially to only accept access from the same server and block all outside access. Google is your friend in this case. Make sure your user is also set up to allow log ins from outside the server that the db is running on.