Android Question Can't get RDC to run

[microbox]

Hi, I know there is a tutorial regarding how to run properly the rdc example. But I feel I'm getting no where..kindly help me out. I know it's simple but I guess not for me.
1. My target is to connect to MySql.

DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://192.168.1.100/test?characterEncoding=utf8

#SQL Server
#DriverClass=net.sourceforge.jtds.jdbc.Driver
#JdbcUrl=jdbc:jtds:sqlserver://<database server ip>/<database>
User=root
Password=""
ServerPort=17178
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true

#commands
sql.create_table=CREATE TABLE animals (\
    id INT NOT NULL AUTO_INCREMENT,\
    name CHAR(30) NOT NULL,\
    image BLOB,\
    PRIMARY KEY (id))
sql.insert_animal=INSERT INTO animals VALUES (null, ?,?)
sql.select_animal=SELECT name, image FROM animals WHERE name = ?

This is what I have in the config.propoerties.
When I right click and run as administrator the RunRLC I have the following output.

But when I try to open status connection in a browser by entering http://127.0.0.1:17178/?method=test I have this result...

and I'm not sure what this error mean

Thank you for the time.

 

[Erel]

Is the password supposed to be empty? If yes then remove the two quotes.

 

[microbox]

Hi Erel... thanks but I got the same result. Even when I edit and supplied a password to MySql it's the same.

DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://192.168.1.100/test?characterEncoding=utf8

#SQL Server
#DriverClass=net.sourceforge.jtds.jdbc.Driver
#JdbcUrl=jdbc:jtds:sqlserver://<database server ip>/<database>
User=root
Password=mypass

ServerPort=17178
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true

#commands
sql.create_table=CREATE TABLE animals (\
    id INT NOT NULL AUTO_INCREMENT,\
    name CHAR(30) NOT NULL,\
    image BLOB,\
    PRIMARY KEY (id))
sql.insert_animal=INSERT INTO animals VALUES (null, ?,?)
sql.select_animal=SELECT name, image FROM animals WHERE name = ?

 

[Erel]

Remove the quotes from the password.

 

[microbox]

Remove the quotes from the password.

..sorry I was late to hit the save button. I have the same result...

 

[Erel]

Access denied error means that the server didn't accept the credentials. You need to double check the values and the server configuration.
http://dev.mysql.com/doc/refman/5.1/en/access-denied.html

 

[alienhunter]

hi where is your mysql running xampp or other server ?
you have to specify the :3306 port where your mysql is running

DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://192.168.1.100:3306/test?characterEncoding=utf8

 

[microbox]

..thanks again Erel, I will have a look.

 

[microbox]

hi where is your mysql running xampp or other server ?
you have to specify the :3306 port where your mysql is running

DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://192.168.1.100:3306/test?characterEncoding=utf8

hello..I have it in xampp and I try it out, but did not work..thanks for the time.

 

[alienhunter]

now we are getting closer
when i started i had problems too
make sure your xampp is runnnig under the port

then make sure you are able o connect to mysql you will get a weird message in your browser

if not you have to get xampp configured ... we go from there

forgot : make sure if you have skype shut it down then start xampp then start skype

 

[microbox]

Hi..I attache some pics to show what I have running.

When I type in the localhost:3306 to the browser it downloads a file(i have 3 them now) with the following content

I don't have skype installed on my machine...any clue what I'm doing wrong?

 

[alienhunter]

Hi..I attache some pics to show what I have running.
View attachment 25788
When I type in the localhost:3306 to the browser it downloads a file(i have 3 them now) with the following contentView attachment 25789
View attachment 25790
I don't have skype installed on my machine...any clue what I'm doing wrong?

i do not know what those i-download files are but you are able to connect to mysql now make sure that you have a "test" database in your mysql
this will work then with the example from erel
make sure that the "test" database as user rights that you need
you should be able to run the example now
or ?

edit : did you configured something in xampp or it comes out of the box, i do not remember any more if i changed something in xampp have to go to work and look on my servers , i got mysgl postgres and msql running with RDC with different batch files in the same way from the same computer

 

[microbox]

i do not know what those i-download files are but you are able to connect to mysql now make sure that you have a "test" database in your mysql
this will work then with the example from erel
make sure that the "test" database as user rights that you need
you should be able to run the example now
or ?

edit : did you configured something in xampp or it comes out of the box, i do not remember any more if i changed something in xampp have to go to work and look on my servers , i got mysgl postgres and msql running with RDC with different batch files in the same way from the same computer

Hi, I will try to play some more later on and post my result here...thanks.