RemoteDatabaseConnector - in my pc ?

[derez]

The Java server is just a middleware between the database server and the Android devices.
OK, got this fact.
Now, if I have a mysql database (created by b4a), how can I put it in my pc and have the RDC work with it ?
I guess it has to be defined in the server config.properties :
DriverClass= ....
JdbcUrl= ...

 

[Erel]

Now, if I have a mysql database (created by b4a)

Hmmm... I think you are confusing SQLite database with MySQL. You cannot create a MySQL database on the devie. MySQL is a database server.

You can install WAMP. It is an Apache server with MySQL and PhpMyAdmin which is a popular administration tool for MySQL databases.

 

[derez]

You are write, I used SQL lib which is SQLite.

 

[Erel]

@derez see this example: http://www.b4x.com/android/forum/threads/rdc-simple-way-to-create-your-own-back-end-database.31616/

 

[derez]

Installed wamp, solved few problems there and it works now

 

[alienhunter]

Installed wamp, solved few problems there and it works now

hi derez ,
would you share how you configured wamp/RDC "out of the box" ? to make it work
i am able to connect from the remote pc to wamp (see pic) but i cannot connect to the sql
there is not much info about this on the wamp forum (or i cannot find it )
i got RDC working with sqlite (thank you for your post)

thanks AH

 

[derez]

I succeeded to get the answer for "http://localhost:17178/?method=test" with no errors.
To get it I used root as username and no password, the same in the config.properties.
Then I switched to SQLite which doesn't need wamp and I had the DB ready.
I did some editing in the wamp about allowing only lan members to connect, I'll find it and post when I'll remember...

 

[derez]

The following is what I put in httpd.config (wamp\bin\apache\apache2.44\conf\)

#  onlineoffline tag - don't remove
    Order Deny,Allow
    Deny from all
    Allow from 127.0.0.1
    Allow from ::1
    Allow from localhost
    Allow from 192

Google for onlineoffline tag and find many posts about similar problems.

 

[alienhunter]

thanks i will give it try