I finally managed to connect to the remote MySql8 db this morning, with the default db.
What I found out was that if I create a docker target and select ‘none’ for the db then whatever I try to do - the default db just won’t connect, I get the above mentioned file missing errors and other errors.
If I select a DB as the target and then try to change the settings or both db.json files, I continue to get timeout errors regardless of what I try. It just fails.
Working Order:
- Create the Docker Remote WITH a MySql DB chosen in the target. Doesn’t really mater what credentials go in there - but I input the expected remote credentials.
- Once the target has been created I then go back to the target and THEN change the databsae settings to ‘None’.
- I then go and change both db.json files to match the remote db credentials. Now it works.
- But then there is the issue of applying all the DB Manager changes, for example if the original Docker DB was created with dummy data. I had to use an external service (workbench) to recreate the DB schema so that the stored db changes would be able to be applied (as it needed to drop those tables).
So, clearly either some files are missing when setting up without a db in target settings on creation, and if you leave the target for the default db - you cannot connect to a remote db without then removing that.
I’d say from a UX perspective, this isn’t great, and especially for any new to using Wappler this may be quite an uncomfortable experience - especially requiring them to edit the db.json files manually.
Anyway, it’s working so over to you guys for review/improvements. Feel free to unlist.