Hai Everyone,
I'm creating a small task. stuck with in setup for database using workbench .
3. Database Setup: • You can install MySQL or PostgreSQL on your local machine. • Use Ngrok to expose the local database, eliminating the need for an external database server.
can you helpout in this scenario..
regards,
saikiran marepally
Hi @Saikiran Marepally,
You can refer to the forum discussion. Hope it helps.
https://docs.uibakery.io/concepts/data-sources/connecting-local-database-via-ngrok
https://ngrok.com/docs/guides/site-to-site-connectivity/dbs/
Note: Your OutSystems environment runs in the cloud. So any database it must connect to must also be accessible from the cloud (i.e. internet).
Please also read this comment: https://www.outsystems.com/forums/discussion/39229/setting-up-mysql-database-connection-with-outsystems/#Post141799
Thank You.
Hi All,
firstly I went to workbench 8.0 . Create a database and tables too. then after went to ngrok sign up and access the authentication code in command prompt.
mysql: ./ngrok tcp 3306 its will given find the Forwarding line and copy the host and the port. go service center under connect database . given database details. for connections but it error. can you please helpout in this scenario..
Sure, I can help you. If possible, please share a screenshot of the error or provide more detailed information to help me better understand the issue.
@Saikiran Marepally : You have selected the wrong DMBS - it should be MySQL instead of SQL Server / Azure SQL.
Also do try to connect to the newly create route from your local machine eg : mysql -h 0.tcp.in.ngrok.io -P 16175 -u <username> -p and see if this works. If this is not working it means routes are not properly setup.
@Saikiran Marepally : This is not what I meant. After selecting DBMS as MySQL , server should be 0.tcp.in.ngrok.io:16175
Before you attempt to do this try connecting from your local computer by going to the terminal and see this is working.
I Create newly route from your local machine . But Its shows error. please help me out in this scenario..
@Saikiran Marepally,
I’ve already tried using the IP address and even attempted advanced configuration by manually entering the connection string parameters, but it still didn’t work. I also set up Ngrok as a virtual server connected to the local server, but that didn’t help either. None of the approaches seems to be working.
I’ve also looked into various solutions, but they don’t appear to be specific to OutSystems. It might be best to ask in the Ngrok community. Please let me know if you come across any working solution.
@Saikiran Marepally , @Nilesh Trivedi
I successfully set up MySQL on my local machine and used ngrok to expose it to the internet. After signing up for ngrok, I downloaded the standalone version and configured the authentication token. I then started ngrok with the command ngrok tcp 3306 to tunnel the MySQL port. Note that ngrok requires credit card verification for TCP tunnels, even on free accounts. In OutSystems Service Center, I configured the database connection using Advanced Configuration. The connection string had to include the SslMode=None parameter to work correctly, as earlier attempts were failing due to its absence.
Thank you, @Siya.