![]() Replace with a secure password, which can be different than the SSH password. Your organization may require a different process, but the simplest way to create this user is to execute the following query when logged into Azure as a user with the right to grant privileges: GRANT SELECT ON *. In the next step, you’ll create a database user for Stitch. To finish creating the user, alter the permissions on the /home/ directory to allow access via SSH: chown -R : /home/Ĭhmod -R 700 /home//.ssh Copy the entire key into the authorized_keys file as follows: touch /home//.ssh/authorized_keys To ensure the user has access to the database, we need to import the Public Key into authorized_keys. To create the new user, run the following commands as root on your Linux server: adduser -p Note that anything inside square brackets - is something you need to define when running the commands yourself. In these cases, it’s necessary to run a command like AllowUsers to allow the Stitch user access to the server. Important: If the sshd_config file associated with the server is not set to the default option, only certain users will have server access - this will prevent a successful connection to Stitch. ![]() The Public Key will display, along with the other SSH fields. ![]() When the credentials page displays, click the Encryption Type menu and select the SSH Tunnel option.On the Stitch Dashboard page, click the Add an Integration button.If the key isn’t properly installed, Stitch will be unable to access your database. The Public Key is used to authorize the Stitch Linux user. If you aren’t using an SSH tunnel to connect, you can skip this step. Whitelist the following IPs before continuing onto the next step: Whitelist Stitch’s IP Addressesįor the connection to be successful, you’ll need to configure your firewall to allow access from our IP addresses. * These steps are only required if you’re using an SSH tunnel to connect the database to Stitch. You’ll need some tech expertise to complete the setup, so we recommend looping in a developer or a member of your tech team to help out if you haven’t done this before.Ĭonnecting an Azure database is a seven-step process: In this article, we’ll walk you through connecting your Microsoft Azure database to Stitch. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |