kmamysql

apt install -y kamailio kamailio-mysql-modules mc
mcedit /etc/kamailio/kamctlrc


DBENGINE=MYSQL
DBHOST=10.20.7.116
DBPORT=3306
DBNAME=kamailio

DBRWUSER="kamailio"
DBRWPW="kamailiorw"

DBROUSER="kamailioro"
DBROPW="kamailioro"

DBROOTUSER="mariadb"
DBROOTPW="dbrootpw"
CHARSET="latin1"

kamdbctl create



apt update
apt install -y mariadb-server mc
mysql_secure_installation


kamailiorw
mariadb
GRANT ALL PRIVILEGES ON *.* TO 'kamailiorw'@'%' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON *.* TO 'kamailiorw'@'%' IDENTIFIED BY 'kamailiorw';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '1234566';
GRANT ALL PRIVILEGES ON *.* TO 'dbrootpw'@'%' IDENTIFIED BY '1234566';
FLUSH PRIVILEGES;


find / -name *.cnf -print

mcedit /etc/mysql/mariadb.conf.d/50-server.cnf

50-server.cnf
# localhost which is more compatible and is not less secure.
bind-address            = 0.0.0.0

systemctl restart mariadb
systemctl restart mysql

ss -antpl | grep 3306
ss -tulpn | grep -E 'mysql|mariadb'

mysql -h 10.20.7.116 -ukamailiorw -p

mysql -h 10.20.7.116 -uroot -p1234566
SHOW DATABASES;
SELECT User FROM mysql.user;
SELECT host, user, password FROM mysql.user;
SELECT `user`, `host`, IF(LENGTH(password)>0, password, authentication_string) AS `password` FROM `mysql`.`user`;

SHOW GRANTS FOR 'kamailio'@'10.20.7.116';
DROP USER 'kamailio'@'10.20.7.116';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'kamailioro'@'10.20.7.116';
DROP USER 'kamailioro'@'10.20.7.116';
FLUSH PRIVILEGES;


systemctl stop mysql
mysqld_safe --skip-grant-tables &

mysql -u root


mysql

use mysql;
update user set password=PASSWORD("1234566") where user = 'root';
flush privileges;
exit;

use mysql;
update user set password=PASSWORD("kamailiorw") where user = 'root';
flush privileges;
exit;


SHOW DATABASES;
DROP DATABASE `kamailio`;
FLUSH PRIVILEGES;

SHOW COLUMNS FROM `mysql`.`user`;
SELECT `user`, `host`, IF(LENGTH(password)>0, password, authentication_string) AS `password` FROM `mysql`.`user`;
SHOW GRANTS FOR 'kamailio'@'10.20.7.115';
DROP USER 'kamailio'@'10.20.7.115';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'kamailio'@'10.20.7.116';
DROP USER 'kamailio'@'10.20.7.116';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'kamailioro'@'10.20.7.115';
DROP USER 'kamailioro'@'10.20.7.115';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'kamailioro'@'10.20.7.116';
DROP USER 'kamailioro'@'10.20.7.116';
FLUSH PRIVILEGES;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;6.1.0-10-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.38-2 (2023-07-27) x86_64 GNU/Linux;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
Обновляем систему
apt update -y
apt upgrade -y

Устанавливаем sql server mariadb
apt install -y mariadb-server mc

Настройка sql server*a
mysql_secure_installation
на root ставим этот пароль
kamailiorw

Открываем доступ к sql серверу
mcedit /etc/mysql/mariadb.conf.d/50-server.cnf
bind-address            = 0.0.0.0

systemctl restart mariadb

Даем доступ к логину root из любой подсети %

mariadb
CREATE USER 'kamailiorw'@'%' IDENTIFIED BY 'kamailiorw';
GRANT ALL PRIVILEGES ON *.* TO 'kamailiorw'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;


проверяем доступ от компа с kamailio
mysql -h 10.20.1.114 -uroot -p
kamailiorw

SHOW DATABASES;
SHOW TABLE STATUS FROM `kamailio`;

DBENGINE=MYSQL
DBHOST=10.20.7.116
DBPORT=3306
DBNAME=kamailio
DBRWPW="kamailiorw"
DBROUSER="kamailioro"
DBROPW="kamailioro"
DBROOTUSER="root"
CHARSET="latin1"

SELECT User, Host FROM mysql.user;

SHOW GRANTS FOR kamailio@localhost;
SHOW GRANTS FOR 'kamailioro'@'%';


GRANT USAGE ON *.* TO `kamailioro`@`%` IDENTIFIED BY PASSWORD 'kamailioro';

GRANT SELECT ON `kamailio`.* TO `kamailioro`@`%`;






SELECT User FROM mysql.user;
SELECT * FROM mysql.user WHERE User = 'kamailio';
SELECT * FROM mysql.user WHERE User = 'kamailioro';
SELECT * FROM mysql.user WHERE User = 'kamailiorw';



ALTER USER 'kamailio'@'localhost' IDENTIFIED BY 'kamailio' HOST '10.20.7%';

CREATE USER 'kamailio'@'ip_address' IDENTIFIED BY 'new_password';

SHOW DATABASES;
USE kamailio
DESCRIBE carrierroute;
SHOW COLUMNS FROM carrierroute;

SHOW TABLE STATUS FROM `kamailio`;

+----------------+------------------+------+-----+---------+----------------+
| Field          | Type             | Null | Key | Default | Extra          |
+----------------+------------------+------+-----+---------+----------------+
| id             | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| carrier        | int(10) unsigned | NO   |     | 0       |                |
| domain         | int(10) unsigned | NO   |     | 0       |                |
| scan_prefix    | varchar(64)      | NO   |     |         |                |
| flags          | int(11) unsigned | NO   |     | 0       |                |
| mask           | int(11) unsigned | NO   |     | 0       |                |
| prob           | float            | NO   |     | 0       |                |
| strip          | int(11) unsigned | NO   |     | 0       |                |
| rewrite_host   | varchar(255)     | NO   |     |         |                |
| rewrite_prefix | varchar(64)      | NO   |     |         |                |
| rewrite_suffix | varchar(64)      | NO   |     |         |                |
| description    | varchar(255)     | YES  |     | NULL    |                |


INSERT INTO carrierroute (id, carrier, domain, scan_prefix, flags, mask, prob, strip, rewrite_host, rewrite_prefix, rewrite_suffix, description) VALUES
(1, ,,,,,,,,,,,);


use openser;
INSERT INTO carrier_name (carrier) VALUES ("default");
INSERT INTO domain_name (domain) VALUES ("default");
INSERT INTO carrierroute (carrier,domain,scan_prefix,flags,mask,prob,strip,rewrite_host,rewrite_prefix,rewrite_suffix,description) VALUES("1","1","1000","0","0","1","0","PEER-01","","","FRANCE");
exit