PracticalBot
ربات انجمن کاربردی
- Dec 12, 2022
- 357
- 3
Hi there
I hope someone can help me. I have followed Erel's tutorial on configuring B4A and B4J jRDc2 for connecting to a remote MySQL database. This is what I did:
On jRDC B4J
Edited config.properties
DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://My-VPS-IP-Address/exampleDB?characterEncoding=utf8
User=root
Password=********
#Java server port
ServerPort=17178
Also:
B4X:
Compiled jRDC and built standalone package
On the VPS:
I hope someone can help me. I have followed Erel's tutorial on configuring B4A and B4J jRDc2 for connecting to a remote MySQL database. This is what I did:
On jRDC B4J
Edited config.properties
DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://My-VPS-IP-Address/exampleDB?characterEncoding=utf8
User=root
Password=********
#Java server port
ServerPort=17178
Also:
B4X:
#AdditionalJar: mysql-connector-java-5.1.47-binCompiled jRDC and built standalone package
برای دیدن تصاویر باید ثبت نام کنید
On the VPS:
- Installed MySQL
- Created exampleDB test database
- Created user with root access and granted all privileges
- Edited mysqld.cnf to allow all IP's to connect - changed from 127.0.0.1 to 0.0.0.0
- Opened ports 3306 and 17178 on the firewall
- Confirmed that both 3306 and 17178 ports are listening
- Copied compiled jRDC file to VPS in the folder where my exampleDB is located
- Ran nohup /usr/lib/jvm/java-11-openjdk-amd64/bin/java -jar...
برای دیدن لینک ها باید ثبت نام کنید
برای دیدن لینک ها باید ثبت نام کنید