Important forum update

This forum is migrating to one unified Wix community forum starting July 26th, and will be read-only during the process.

Members

To see this working, head to your live site.

Wayne Atwood

Feb 13, 2023

Edited: Feb 13, 2023

External Database Configuration for Ubuntu

in Velo Pro Discussion

I have a VPS running Ubuntu 20.04. I installed the External Database Adapter from official github link for velo-external-db using Docker and I'm able to run the service but I get a message that says it can't connect to my MySQL database. How do I configure velo-external-db to connect and set my secret key. I'm not using Google Cloud or the others listed with detailed instructions.

Can you tell me how to set the configuration?

10 comments

10 Comments

Wayne Atwood

Feb 16, 2023

Best Answer

I have tested the Wix Velo External Database Adapter and it works on a KVM VPS Running Ubuntu 20.04, Nginx and MySQL 8.

https://github.com/wix/velo-external-db

The reverse proxy using Nginx worked listening on port 443 for port 8080. I installed an SSL certificate. I also had to set the CLOUD_VENDOR=aws. Lastly, I had to install MySQL 8 because MariaDB gave an error message when connecting to wix. I also had to set a MySQL User with mysql_native_password. Perhaps there are other solutions but this worked for me.

CREATE USER 'mysql_username'@'%'IDENTIFIED WITH mysql_native_password BY 'mysql_user_password';

I had to set my database to receive outside connections and then I tested to make sure I could connect with HeidiSQL before I proceed to check the velo adapters connection.

I ran the docker with this command:

docker run -p 8080:8080 -e CLOUD_VENDOR=aws -e TYPE=mysql -e SECRET_KEY=yoursecret -e HOST=external_ip_of_mysql_database -e USER=mysql_username -e PASSWORD=mysql_user_password -e DB=name_of_your_database docker_image_id

I finally have this set up.

Thanks for your help.

AmandaM

Feb 17, 2023

•

Replying to

Wayne! I am so glad you were able to get this working. If you have time, I think this information would really benefit the community as a stand alone tutorial post. Please feel free to post the steps to complete a setup like this in the Tips, Tutorials category when/if you have time.

Unknown member

Feb 13, 2023

Hey Wayne,

How do you run the adapter? Are you providing any environment variables?

Wayne Atwood

Feb 14, 2023

Replying to

I really appreciate this. It worked! I hope your answer will help many others as well.

I'm using the docker command -p 8080:8080 to run the wix adapter on port 8080 since I have LiteSpeed running on port 80 and 443. However, I can't make a https connection to the wix adapter and don't know how to set this up. Any help would be appreciated.

Unknown member

Feb 15, 2023

Replying to

Generally I would try to go for a reverse proxy such as Nginx. You can configure it to listen on any port you like and forward its requests to localhost:8080 (the local address of the adapter).

In Nginx's configuration you will need to configure its ssl certificate.

But before you try this I would also check if LiteSpeed can do the same thing.

Unknown member

Feb 13, 2023

Best Answer

Replying to

Let's try to set these set of environment variables:


CLOUD_VENDOR = 'azure' (please note that although you are not running on azure type here azure)
TYPE = 'mysql'
SECRET_KEY = '<the secret key that you will provide in the editor>'
HOST = '<the hostname or an IP address of your mysql instance>'
USER = '<mysql username>'
PASSWORD = '<mysql password>'
DB = '<the name of the database which you want to connect>'

so when you run the docker it would look something like this:

docker run -e CLOUD_VENDOR=azure -e TYPE=mysql -e SECRET_KEY=... -e HOST=... -e USER=... -e PASSWORD=... -e DB=...

Wayne Atwood

Feb 13, 2023

Sure. Here's the link: https://github.com/wix/velo-external-db I would have posted it in my original post but the forum wouldn't let me post a link.

AmandaM

Feb 13, 2023

•

Replying to

Yes, it's common for bot accounts to join and link spam so we do restrict on new members. Thanks for adding this, I will check it out and see what I can find for you

AmandaM

Feb 13, 2023

•

Can you post a link to the github reference you are using and any relevant code that might help someone visiting this post? I have not set this up myself but can ask internally and pass along the github link to make sure there isn't something else you should be using

How can we make the product better?

Wishlist Page is the official platform for requesting new features. You can vote, comment, and track the status of the requested features.