Биллинговая система Nodeny

mysql> CALL radreply('E4:8D:8C:B8:C6:83', 'dhcp_1_24');
+------+-------------------+-------------------+-----------+---+
| NULL | login             | Framed-IP-Address | usr_ip    | = |
+------+-------------------+-------------------+-----------+---+
| NULL | E4:8D:8C:B8:C6:83 | Framed-IP-Address | 10.0.1.82 | = |
+------+-------------------+-------------------+-----------+---+
1 row in set (0,01 sec)

+------+-------------------+-----------------+-----+---+
| NULL | login             | Session-Timeout | 600 | = |
+------+-------------------+-----------------+-----+---+
| NULL | E4:8D:8C:B8:C6:83 | Session-Timeout | 600 | = |
+------+-------------------+-----------------+-----+---+
1 row in set (0,01 sec)

Query OK, 0 rows affected (0,01 sec)

mysql> SELECT get_ip_by_tag('1', 'dhcp_1_saperka24');
+----------------------------------------+
| get_ip_by_tag('1', 'dhcp_1_saperka24') |
+----------------------------------------+
| 10.0.1.201                             |
+----------------------------------------+
1 row in set (0,01 sec)

ps aux | grep radi
freerad  25362  0.0  0.1 479884  6184 ?        Ssl  04:15   0:00 /usr/sbin/freeradius
root     25441  0.0  0.0  15476  1024 pts/8    S+   04:16   0:00 grep --color=auto radi

root@vps:~# radtest E4:8D:8C:B8:C6:83 '' 127.0.0.1 0 hardpass5
Sending Access-Request of id 243 to 127.0.0.1 port 1812
        User-Name = "E4:8D:8C:B8:C6:83"
        User-Password = ""
        NAS-IP-Address = 127.0.1.1
        NAS-Port = 0
        Message-Authenticator = 0x00000000000000000000000000000000
rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=243, length=20

mysql> call radcheck('E4:8D:8C:B8:C6:83');
ERROR 1305 (42000): PROCEDURE nodeny.radcheck does not exist

mysql> call radcheck('E4:8D:8C:B8:C6:83');
+------+-------------------+--------------------+-------+----+
| NULL | login             | Attribute          | Value | := |
+------+-------------------+--------------------+-------+----+
| NULL | E4:8D:8C:B8:C6:83 | Cleartext-Password |       | := |
+------+-------------------+--------------------+-------+----+
1 row in set (0,01 sec)

Query OK, 0 rows affected (0,01 sec)

scp /directory1/filename1 usern@destination_host:/directory2/filename2

ALTER DATABASE nodeny CHARACTER SET utf8 COLLATE utf8_general_ci;

mysqldump --routines -R -u root -p nodeny > nodeny.sql

mysqldump --routines -R --no-create-info --no-data --no-create-db --skip-opt -u root -p nodeny > nodeny_procedury.sql

mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER=37949; START SLAVE;

nano /etc/mysql/mysql.conf.d/mysqld.cnf

/etc/init.d/mysql restart

mysql -u root --password='hardpass'

GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

reset master;

USE nodeny;
FLUSH TABLES WITH READ LOCK;

SHOW MASTER STATUS;

cd /var/backups &&
mysqldump -R -u root --password='hardpass' nodeny > nodeny.sql && 
tar -czvf nodenyBD_280418.tar.gz nodeny.sql &&
cp nodenyBD_280418.tar.gz /usr/local/nodeny/htdocs/

nano /etc/mysql/mysql.conf.d/mysqld.cnf

wget my-sayt.net/htdocs/nodenyBD_280418.tar.gz &&
tar -xvf nodenyBD_280418.tar.gz -C /path/to/folder

mysql -u root --password='hardpass'
CREATE DATABASE nodeny;
quit;

mysql -u root --password='hardpass' nodeny < nodeny.sql

mysql -u root --password='hardpass'

CHANGE MASTER TO MASTER_HOST='217.10.20.1',MASTER_USER='slave_user', MASTER_PASSWORD='password';

START SLAVE;

UNLOCK TABLES;