![]() ![]() ![]() User: A name of a user that has sufficient privileges to perform actions with a database. For example, in MySQL you can run SHOW DATABASES. In some cases, it is possible to run a query in a database command line to see names of all available databases. You can find the database name in the settings of your database server, or you can ask your database administrator. It can be an IP address 127.0.0.1 or a domain name localhost.ĭatabase: A name of the database to which you want to connect. Host: A hostname of a computer or other device that stores a database. Most database include the connection settings: Check your connection propertiesĮach database (MySQL, PostgreSQL, Oracle, or any other vendor) has its own connection settings. The telnet command allows you to check if the port is opened for communication. ![]() To see all available databases, the Commerce Intelligence user requires the permissions to run listDatabases.For security reasons, DBMS usually drops all telnet connections. When connecting to multiple databases, you can add the user by logging into MongoDB as an admin user and running the following commands. Bee sure to verify the mode before continuing. The steps for creating a MongoDB user varies depending on what mode your server is using. MongoDB servers have two run modes - one with the “auth” option (mongod - auth) and one without, which is the default. ![]() To finish creating the user, alter the permissions on the /home/rjmetric directory to allow access via SSH: chown -R rjmetric:rjmetric /home/rjmetricĬreating an Commerce Intelligence MongoDB user Copy the entire key into the authorized_keys file as follows: touch /home/rjmetric/.ssh/authorized_keys Remember the public key you retrieved in the first section? To ensure that the user has access to the database, you need to import the key into authorized_keys. To add the new user, run the following commands as root on your Linux server: adduser rjmetric -p You may restrict this user any way you like as long as it retains the right to connect to the MongoDB server. This can be a production or secondary machine, as long as it contains real-time (or frequently updated) data. In these cases, it is necessary to run a command like AllowUsers to allow the rjmetric user access to the server. If the sshd_config file associated with the server is not set to the default option, only certain users have server access - this prevents a successful connection to Commerce Intelligence. They are 54.88.76.97 and 34.250.211.151, but it is also on the MongoDB credentials page:Ĭreating a Linux user for Commerce Intelligence If you are a bit lost, here is how to navigate through Commerce Intelligence to retrieve the key:Īllow access to the Commerce Intelligence IP addressįor the connection to be successful, you must configure your firewall to allow access from your IP addresses. Leave this page open throughout the tutorial - you will need it in the next section and at the end. The public key is located underneath this form.After the MongoDB credentials page opens, change the Encrypted toggle to Yes.Go to Data > Connections and click Add New Data Source.The next section walks you through creating the user and import the keys. The public key is used to authorize the Commerce Intelligence Linux user. Retrieving the Commerce Intelligence public key Due to the technical nature of this setup, Adobe recommends you loop in a developer to help out if you have not done this before. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |