Hi sorry im new to wappler. I am unable to connect to the database in app connect. However when i use the same info and do a direct database connection in the database manager i can connect. But when i try to connect from server connect i use the same credentials and i get an error message that says connection unsuccessful. Can anyone maybe help me. Thank you so much
Hi @downtownsocks, welcome to Wappler!
Can you give a bit more info, maybe some screenshots? What database type are you using? What server model? The more info you can give, the more chance we can help.
The server is hostgator php MySQL server. The domain is a sub domain. Would this be the cause? Maybe the target root folder is not set right in the ftp. I been reading other post and suspecting this. If I do not set the root directory to the sub domain in the target setting would this cause this?
A subdomain is fine. You should have the MySQL connection details (server, database, username and password) so you should create an action file in Server Connect, put a Database Connection action in there and enter those details. There’s a Test Connection button which will tell you if it’s working or not. There might be restrictions on the server for what IPs can connect to the database but that isn’t usually an issue as Wappler (as far as I’m aware) does it’s connecting via scripts so it’s a local connection as far as the server is concerned.
When you have the connection working, remember to click the links icon in Server Connect (next to the Name in the Connection Properties) so that those details can be used in all your action files without needing to re-enter them every time.
Hi Kenneth,
Nice to see you here
Is your ftp target properly setup? What happens when you click test connection in the target options? What error do you see? Can you post a screenshot?
Thanks everyone for help. Not sure what happened but i tested the same connection on a different domain on the same server and was able to connect successfully. I checked and rechecked all the passwords and info and everything seems to be ok. Seems like a file is missing or something on that domain. I dont know. But thanks for your support.