How do I install the mysql plugin?
My setup is via tunneling the cloud database so I can test locally as if it were a localhost, as recommended in the documentation.
What I have done so far is to configure the ssh tunnel, connect to the Xojo cloud mysql with Sequel pro (and mysql manager too), created a database and inserted data with Sequel pro.
In the web app (xojo project) I inserted a mysql database component, which accepts the credentials and supposedly connects to the database.
The on the main form, added an event Shown, where it connects to the database (debugged it step by step), but when doing a query it returns nil, like so:
// Initialization seem to connect ok to the server and to the database
DataList.DeleteAllRows
Dim sql As String
sql = “SELECT * FROM customer_main”
Dim data As RecordSet
data = db.SQLSelect(sql) // HERE IT RETURNS NIL. IT SHOULD RETURN A DATASET
It is failing to retrieve the records. According to documentation, I should work the same when local testing as if deployed to xojocloud.
That is why I thought maybe I still need the plugin. In the documentation it says I should copy a mysql plugin. I assumed it was done just by inserting a mysql community database in the project.
Please, I need some guidance here.
JD