I downloaded dbslayer to use, but ran into a problem and I could use some help.

21 views
Skip to first unread message

blackstag

unread,
Dec 7, 2009, 11:22:14 PM12/7/09
to dbslayer
I downloaded dbslayer to use, but ran into a problem and I could use
some help.

* I'm using mac osx 10.6.2 snow leopard. ARP is pre-installed.
* I've installed dbslayer and can run the service using:
dbslayer -c /etc/my.cnf -s localhost

In mysql I have a database named "learn"...

From terminal:

mysql> use learn;
Database changed
mysql> select * from tb1;
+------------+-----------------------+--------------+----+
| name | email | phone_number | ID |
+------------+-----------------------+--------------+----+
| Daisy Duck | car...@blackstag.com | 5554321 | 1 |
| Daffy Duck | car...@blackstag.com | 5554320 | 2 |
+------------+-----------------------+--------------+----+
2 rows in set (0.00 sec)

So I run:

http://localhost:9090/db?{"SQL":"select%20*%20from%20tb1;"}

and get:

{"MYSQL_ERRNO" : 1046 , "MYSQL_ERROR" : "No database selected" ,
"SERVER" : "localhost"}

how in the URL do I specify which database to use?

or any other ideas would be appreciated.

Please & Thanks

blackstag

unread,
Dec 7, 2009, 11:34:40 PM12/7/09
to dbslayer
even tried:

http://localhost:9090/db?{"SQL":"select%20learn.*%20from%20tb1%20learn;"}

but same answer....

blackstag

unread,
Dec 8, 2009, 10:06:59 PM12/8/09
to dbslayer
nevermind - I got it fixed.... newb error
Reply all
Reply to author
Forward
0 new messages