Best backend/server support for wappler?

[jbrant308]

Hi all,
I have been trying to use A2 hosting for the past few months but so far have been unable to get things to workout correctly. I’m sure some of it is my lack of knowledge, and I would love to correct that, but I cant seem to find any solid detailed documentation for this service. I was wondering if there is a better service that can offer both a low cost shared server/database option for initial use, and a VPS for possible future development if needed? I’m trying to setup an ecommerce site. I havent been through all the wappler videos as of yet, but if there is one that details the database and server connection that would be perfect.
Thanks!

[psweb]

My personal preference is Docker, with Digital Ocean, super simple and fast to setup and use.

Docker: Local Databases

Sort of correct in what you are saying but just to clarify, NodeJS can be used without Docker, but if you want Docker as well as NodeJS together then this is sort of the setup. Before even opening Wappler, make sure you have the latest NodeJS installed (The LTS) version Next make sure you have Docker for Desktop installed, but for me I just installed it, and did nothing inside it at all. Open Wappler, create a new project, make sure to choose Hosting Type: Docker Hosting Server Model: NodeJS …

[Teodor]

What server model are you using and how is your local project set up - custom hosting / docker? How do you connect to your hosting - using ftp or some other method?

[jbrant308]

I was trying to use SFTP as shown in one of the youtube videos here, https://www.youtube.com/watch?v=GBOIssJOyh8, . I was able to connect to the server, which i spoke about in a previous post, but the database wouldnt connect. I was using a mySQL database that I created on cpanel.

[psweb]

Please give a screenshot of your database connection settings you entered, also if you get any error when trying to connect please tell us what it is.
Pretty often with cPanel you may need to whitelist the IP address you are connecting from if nothing else works.

Shared Titles Showing Bind Data rather than Actual Title

Make sure you look at your cPanel too, look under Remote MySQL to see if you need to add an Access Host. Keep in mind 99% of what you normally do, you use a connection to “localhost” which is the local loopback address of your server, therefore you have access, because your web hosted files and your MySQL database are on the same server and the server has security clearance to access its own SQL database. That is not to say that StackPath can though.

[jbrant308]

thanks psweb, I will read through this thread and go from there.