Can't Connect between KSc on different machine and MariaDB on another machine

[Tahmeed702]

I followed this instructions to link KSC and MariaDB, which are on separate machines: https://support.kaspersky.com/ksc/14.2/210277. However, it didn't work. I've attached some screenshots, an error sql file, and an ini.sql file. I give the instance name as the Mariadb server's IP address, create a database named "KAV" in Mariadb, try to connect, and after the installation of KSC was completed, I encounter the "Hide initialization indicator" loop, which keeps running while I wait for hours. I'm not sure why KSC isn't connecting to Mariadb; Please share documentation that explains how to connect KSC to one machine and Mariadb to another?

[Tahmeed702]

Solved and related documentation is shared

 

1.  Make sure you have both side ping connectivity between DBMS machine and Ksc machine 

 

2.  Stop Windows Firewall in DBMS machine 

 

3. From Advance sharing settings , tick check these things. So That you can access file through network 

\\192.168.0.3

 

4. Make IP address static in both DBMS machine and Ksc machine 

 

5. Install MariaDB 10.5 in a Machine, during installation set password for “root” and then end installation process as default, 

 

6. Got to my.ini file of MaraDB add the blue marked settings below [mysqld] and set “innodb_buffer_pool_size= value ” the value should be 80% of the KAV database 

 

6. Create database using cmd “create database KAV;”

 

These are all setup process for DBMS machine 

 

Now We will work in ksc machine 

Make your ksc machine’s ip address as static 

 

1. During Ksc admin server setup set database as “Mysql and MariaDB”

 

 

2. Set server address “Ip address” in DBMS instance name section

 

3. Now set root password for MariaDB which you have set during installation of MariaDB 

Then hopefully ksc  will get connected to dbms machine.

Edited September 28 by Tahmeed702