Share My Creation [B4J] MySQL API Server (Key + Token) and [B4X] User Login Apps

Updates:
For latest version of B4J Web API Server, working with cross platform B4X client apps and web front-end, please check Web API Template supporting MySQL and SQLite backend

Finally I would like to share my B4J API server written in B4J.
Compare to my previous PHP API, this API server implements user access token to authorize user to consume the API.

SQL.zip - SQL script to create necessary database and tables in MySQL server.
jAPI.zip - Source code for server app (B4J).
B4A.zip - Source code for client app using default template (B4A)
B4X.zip - Source code for client app using B4XPages template (B4A, B4i and B4J)

Live server: https://api.puterise.com:17179

12 Jan 2021: Attached B4J client sample. This is a beta version. Some bugs and features will be fixed in the future.
13 Jan 2021: Attached B4X client sample. This is a beta version. Some bugs and features will be fixed in the future. B4J.zip removed.

 

[pixet]

There are no errors reported,
the only message displayed "[{" result ": - 1," message ":" Error-Not-Activated "}]"
The table: "tbl_users_log" contains in the field log_type = "[Not Actived] email", the table "tbl_error" is empty.
If I try to log in, it replies that the user is not active.
How can I force user activation?
Thank you

 

[aeric]

There are no errors reported,
the only message displayed "[{" result ": - 1," message ":" Error-Not-Activated "}]"
The table: "tbl_users_log" contains in the field log_type = "[Not Actived] email", the table "tbl_error" is empty.
If I try to log in, it replies that the user is not active.
How can I force user activation?
Thank you

Activation email. You can also append the user activation code from user table to the URL.

For example:

https://api.puterise.com:17179/user/activate/vhbgroalh90akyyypt0ah3qjo5gpb0bx

API documentation:

https://api.puterise.com:17179/user

 

[pixet]

[SOLVED],
the suggested actions worked.
Thank you