Has anyone had experiencing interacting with data on linode hosting?

[Mike_T]

Client is hosting a wordpress site on Linode and I’ve been asked to interact with the database using an app I have built on Appsheet. Hoping there are no issues and it works and acts like an AWS host?

[Steve]

help.appsheet.com

API: The Essentials

How to use the API to make changes to your app.

help.appsheet.com

Introduction to Webhooks

How to post to web services and social media.

[Mike_T]

Steve, thanks for these! I’m actually attempting a more direct approach and maybe you or someone else can help me. I’m very new to all of the mySQL database connections but I’m learning fast. I am attempting to access a wordpress database with Appsheet directly. I have a database name, ip address, UN & PW. I’m having the wordpress developer check on his side but I’m still getting an error. Since I’m a noob, I want to make sure that I was given the correct info and i’m entering it correctly. Error message:

Add Sql info:

[Steve]

I’m afraid I have no experience with databases. Have you searched help.appsheet.com?

[Mike_T]

Thanks for the reply. I think I’m going to pull the plug on database access idea and stick with wordpress API and webhooks. Someone suggested to me that this is probably more secure option and also future proof in case changes are made to the data models in the database.

Still a little over my head but I think there is more support going this direction…besides if Steve doesn’t have experience doing it…it’s probably not worth doing!!!

[Steve]

Mike_T:

besides if Steve doesn’t have experience doing it…it’s probably not worth doing!!!

Oh, definitely not the case here! Databases are hugely useful for AppSheet apps, but I would suggest that you’re playing with very advanced topics. Perhaps find a simpler approach to start?

[Bellave_Jayaram]

Most likely, you haven’t added the ip addresses (from where Appsheet will be connecting) to access the WP MySQL server. Have you done this step -Managing IP Addresses and Firewall Information | AppSheet Help Center ?

[Mike_T]

Thanks for this. I’m looking into this now. Working with a 3rd party so the process of connecting these is grueling.

[Mike_T]

@Bellave_Jayaram UPDATE: Success!!!
Thanks again for this response! I was able to connect once all of the IP addresses were added to the Firewall.

I also found this video very helpful: How to Make an App Using Your SQL Data - YouTube

[Bellave_Jayaram]

Very cool. Keep us posted on how you are interfacing between Wordpress and the app (what kinda of things you are doing, how it’s helpful, roadblocks etc.) when you find time.