![]() ![]() I assume for DBeaver specifically the cert needs to be installed on Windows OS.ġ - DBeaver interface (so that I can test it directly from Windows)Ģ - From web server (Ubuntu) where Magmi is located at the same destination as web site /var/www/html/magento2 SetupĪt the moment Local network, but I would like to make sure the setup will work once site go onto internet hosted setup I guess I need to do something extra so that it will work with MySQL. NOTE: I have tried using the Nginx cert/key set (readable as web-server user) (leaving CA value empty), but it does not authenticate me correctly. Keep value empty if one of the SSL Certificate settings are not used (for instance only SSL CA certificate) SSL Settings - If incorrect settings are used here, you may lock yourself out of these settings, only way to fix is to manually edit magmi.ini. ![]() Do I need to create a new SSL certificate/key set, or can I use the Nginx one - I have the local Nginx certificate/key, they are not CA signed, in otherwords just the cert/key created internallyįrom the SSL Configuration settings of Magmi web interface:.How would I go to setup SSL configuration so that I will be able to connect to MySQL that way?.In other words before you can access the /magmi.php, it verifies again ** **TO LOGIN to the web interface, you specify MySQL database details of Magento 2, and it verifies against a database user. I assume these settings are specifically requesting for certificate file location. There are no settings to connect via SSH Tunnel, only SSL settings : _SSL CA, SSL Cert, SSL Key. The problem is I use a 3rd party data importer for Magento 2 - Magmi which has a web-interface. I have successfully managed to connect to the database with SSH Tunnel when using a database management tool - DBeaver on Windows 10, so for normal database SQL queries I use manually I am able to work. I have read some answers here on serverfault that suggests it is not a good idea to open a MySQL port to the firewall, so I am trying to setup accordingly. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |