SHOW:
|
|
- or go back to the newest paste.
| 1 | @loadnet | |
| 2 | telega | |
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | apt install -y kamailio kamailio-mysql-modules mc | |
| 7 | mcedit /etc/kamailio/kamctlrc | |
| 8 | ||
| 9 | ||
| 10 | DBENGINE=MYSQL | |
| 11 | DBHOST=10.20.7.116 | |
| 12 | DBPORT=3306 | |
| 13 | DBNAME=kamailio | |
| 14 | ||
| 15 | DBRWUSER="kamailio" | |
| 16 | DBRWPW="kamailiorw" | |
| 17 | ||
| 18 | DBROUSER="kamailioro" | |
| 19 | DBROPW="kamailioro" | |
| 20 | ||
| 21 | DBROOTUSER="mariadb" | |
| 22 | DBROOTPW="dbrootpw" | |
| 23 | CHARSET="latin1" | |
| 24 | ||
| 25 | kamdbctl create | |
| 26 | ||
| 27 | ||
| 28 | ||
| 29 | apt update | |
| 30 | apt install -y mariadb-server mc | |
| 31 | mysql_secure_installation | |
| 32 | ||
| 33 | ||
| 34 | kamailiorw | |
| 35 | mariadb | |
| 36 | GRANT ALL PRIVILEGES ON *.* TO 'kamailiorw'@'%' IDENTIFIED BY ''; | |
| 37 | GRANT ALL PRIVILEGES ON *.* TO 'kamailiorw'@'%' IDENTIFIED BY 'kamailiorw'; | |
| 38 | GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '1234566'; | |
| 39 | GRANT ALL PRIVILEGES ON *.* TO 'dbrootpw'@'%' IDENTIFIED BY '1234566'; | |
| 40 | FLUSH PRIVILEGES; | |
| 41 | ||
| 42 | ||
| 43 | find / -name *.cnf -print | |
| 44 | ||
| 45 | mcedit /etc/mysql/mariadb.conf.d/50-server.cnf | |
| 46 | ||
| 47 | 50-server.cnf | |
| 48 | # localhost which is more compatible and is not less secure. | |
| 49 | bind-address = 0.0.0.0 | |
| 50 | ||
| 51 | systemctl restart mariadb | |
| 52 | systemctl restart mysql | |
| 53 | ||
| 54 | ss -antpl | grep 3306 | |
| 55 | ss -tulpn | grep -E 'mysql|mariadb' | |
| 56 | ||
| 57 | mysql -h 10.20.7.116 -ukamailiorw -p | |
| 58 | ||
| 59 | mysql -h 10.20.7.116 -uroot -p1234566 | |
| 60 | SHOW DATABASES; | |
| 61 | SELECT User FROM mysql.user; | |
| 62 | SELECT host, user, password FROM mysql.user; | |
| 63 | SELECT `user`, `host`, IF(LENGTH(password)>0, password, authentication_string) AS `password` FROM `mysql`.`user`; | |
| 64 | ||
| 65 | SHOW GRANTS FOR 'kamailio'@'10.20.7.116'; | |
| 66 | DROP USER 'kamailio'@'10.20.7.116'; | |
| 67 | FLUSH PRIVILEGES; | |
| 68 | SHOW GRANTS FOR 'kamailioro'@'10.20.7.116'; | |
| 69 | DROP USER 'kamailioro'@'10.20.7.116'; | |
| 70 | FLUSH PRIVILEGES; | |
| 71 | ||
| 72 | ||
| 73 | systemctl stop mysql | |
| 74 | mysqld_safe --skip-grant-tables & | |
| 75 | ||
| 76 | mysql -u root | |
| 77 | ||
| 78 | ||
| 79 | mysql | |
| 80 | ||
| 81 | use mysql; | |
| 82 | update user set password=PASSWORD("1234566") where user = 'root';
| |
| 83 | flush privileges; | |
| 84 | exit; | |
| 85 | ||
| 86 | use mysql; | |
| 87 | update user set password=PASSWORD("kamailiorw") where user = 'root';
| |
| 88 | flush privileges; | |
| 89 | exit; | |
| 90 | ||
| 91 | ||
| 92 | SHOW DATABASES; | |
| 93 | DROP DATABASE `kamailio`; | |
| 94 | FLUSH PRIVILEGES; | |
| 95 | ||
| 96 | SHOW COLUMNS FROM `mysql`.`user`; | |
| 97 | SELECT `user`, `host`, IF(LENGTH(password)>0, password, authentication_string) AS `password` FROM `mysql`.`user`; | |
| 98 | SHOW GRANTS FOR 'kamailio'@'10.20.7.115'; | |
| 99 | DROP USER 'kamailio'@'10.20.7.115'; | |
| 100 | FLUSH PRIVILEGES; | |
| 101 | SHOW GRANTS FOR 'kamailio'@'10.20.7.116'; | |
| 102 | DROP USER 'kamailio'@'10.20.7.116'; | |
| 103 | FLUSH PRIVILEGES; | |
| 104 | SHOW GRANTS FOR 'kamailioro'@'10.20.7.115'; | |
| 105 | DROP USER 'kamailioro'@'10.20.7.115'; | |
| 106 | FLUSH PRIVILEGES; | |
| 107 | SHOW GRANTS FOR 'kamailioro'@'10.20.7.116'; | |
| 108 | DROP USER 'kamailioro'@'10.20.7.116'; | |
| 109 | FLUSH PRIVILEGES; | |
| 110 | ||
| 111 | ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
| 112 | ;;;6.1.0-10-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.38-2 (2023-07-27) x86_64 GNU/Linux;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
| 113 | ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
| 114 | Обновляем систему | |
| 115 | apt update -y | |
| 116 | apt upgrade -y | |
| 117 | ||
| 118 | Устанавливаем sql server mariadb | |
| 119 | apt install -y mariadb-server mc | |
| 120 | ||
| 121 | Настройка sql server*a | |
| 122 | mysql_secure_installation | |
| 123 | на root ставим этот пароль | |
| 124 | kamailiorw | |
| 125 | ||
| 126 | Открываем доступ к sql серверу | |
| 127 | mcedit /etc/mysql/mariadb.conf.d/50-server.cnf | |
| 128 | bind-address = 0.0.0.0 | |
| 129 | ||
| 130 | systemctl restart mariadb | |
| 131 | ||
| 132 | Даем доступ к логину root из любой подсети % | |
| 133 | ||
| 134 | mariadb | |
| 135 | CREATE USER 'kamailiorw'@'%' IDENTIFIED BY 'kamailiorw'; | |
| 136 | GRANT ALL PRIVILEGES ON *.* TO 'kamailiorw'@'%' WITH GRANT OPTION; | |
| 137 | FLUSH PRIVILEGES; | |
| 138 | EXIT; | |
| 139 | ||
| 140 | ||
| 141 | проверяем доступ от компа с kamailio | |
| 142 | mysql -h 10.20.1.114 -uroot -p | |
| 143 | kamailiorw | |
| 144 | ||
| 145 | SHOW DATABASES; | |
| 146 | SHOW TABLE STATUS FROM `kamailio`; | |
| 147 | ||
| 148 | DBENGINE=MYSQL | |
| 149 | DBHOST=10.20.7.116 | |
| 150 | DBPORT=3306 | |
| 151 | DBNAME=kamailio | |
| 152 | DBRWPW="kamailiorw" | |
| 153 | DBROUSER="kamailioro" | |
| 154 | DBROPW="kamailioro" | |
| 155 | DBROOTUSER="root" | |
| 156 | CHARSET="latin1" | |
| 157 | ||
| 158 | SELECT User, Host FROM mysql.user; | |
| 159 | ||
| 160 | SHOW GRANTS FOR kamailio@localhost; | |
| 161 | SHOW GRANTS FOR 'kamailioro'@'%'; | |
| 162 | ||
| 163 | ||
| 164 | GRANT USAGE ON *.* TO `kamailioro`@`%` IDENTIFIED BY PASSWORD 'kamailioro'; | |
| 165 | ||
| 166 | GRANT SELECT ON `kamailio`.* TO `kamailioro`@`%`; | |
| 167 | ||
| 168 | ||
| 169 | ||
| 170 | ||
| 171 | ||
| 172 | ||
| 173 | SELECT User FROM mysql.user; | |
| 174 | SELECT * FROM mysql.user WHERE User = 'kamailio'; | |
| 175 | SELECT * FROM mysql.user WHERE User = 'kamailioro'; | |
| 176 | SELECT * FROM mysql.user WHERE User = 'kamailiorw'; | |
| 177 | ||
| 178 | ||
| 179 | ||
| 180 | ALTER USER 'kamailio'@'localhost' IDENTIFIED BY 'kamailio' HOST '10.20.7%'; | |
| 181 | ||
| 182 | CREATE USER 'kamailio'@'ip_address' IDENTIFIED BY 'new_password'; | |
| 183 | ||
| 184 | SHOW DATABASES; | |
| 185 | USE kamailio | |
| 186 | DESCRIBE carrierroute; | |
| 187 | SHOW COLUMNS FROM carrierroute; | |
| 188 | ||
| 189 | SHOW TABLE STATUS FROM `kamailio`; | |
| 190 | ||
| 191 | +----------------+------------------+------+-----+---------+----------------+ | |
| 192 | | Field | Type | Null | Key | Default | Extra | | |
| 193 | +----------------+------------------+------+-----+---------+----------------+ | |
| 194 | | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | |
| 195 | | carrier | int(10) unsigned | NO | | 0 | | | |
| 196 | | domain | int(10) unsigned | NO | | 0 | | | |
| 197 | | scan_prefix | varchar(64) | NO | | | | | |
| 198 | | flags | int(11) unsigned | NO | | 0 | | | |
| 199 | | mask | int(11) unsigned | NO | | 0 | | | |
| 200 | | prob | float | NO | | 0 | | | |
| 201 | | strip | int(11) unsigned | NO | | 0 | | | |
| 202 | | rewrite_host | varchar(255) | NO | | | | | |
| 203 | | rewrite_prefix | varchar(64) | NO | | | | | |
| 204 | | rewrite_suffix | varchar(64) | NO | | | | | |
| 205 | | description | varchar(255) | YES | | NULL | | | |
| 206 | ||
| 207 | ||
| 208 | INSERT INTO carrierroute (id, carrier, domain, scan_prefix, flags, mask, prob, strip, rewrite_host, rewrite_prefix, rewrite_suffix, description) VALUES | |
| 209 | (1, ,,,,,,,,,,,); | |
| 210 | ||
| 211 | ||
| 212 | use openser; | |
| 213 | INSERT INTO carrier_name (carrier) VALUES ("default");
| |
| 214 | INSERT INTO domain_name (domain) VALUES ("default");
| |
| 215 | 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");
| |
| 216 | exit | |
| 217 |
