Compiling and Installing of RTPEngine on Debian Systems

Please follow the below steps to create *.deb packages of rtpengine

$ apt-get install aptitude dpkg-dev lsb-release markdown nfs-common netcat netcat-openbsd
$ cd /usr/local/src
$ git clone --single-branch --branch mr8.1.1 https://github.com/sipwise/rtpengine.git

If you want to transcode g729 then use the link to install libbcg729-dev package from the instruction given in RTPEngine documentation otherwise disable G729 with the following command

$ export DEB_BUILD_PROFILES="pkg.ngcp-rtpengine.nobcg729"

Now try the build deb package by going to main directory of rtpengine

$ cd rtpengine
$ dpkg-buildpackage
$ dpkg-checkbuilddeps
$ aptitude install debhelper default-libmysqlclient-dev gperf iptables-dev libavcodec-dev libavfilter-dev libavformat-dev libavutil-dev libbencode-perl libcrypt-openssl-rsa-perl libcrypt-rijndael-perl libcurl4-openssl-dev libcurl4-gnutls-dev libdigest-crc-perl libdigest-hmac-perl libevent-dev libglib2.0-dev libhiredis-dev libio-multiplex-perl libio-socket-inet6-perl libiptc-dev libjson-glib-dev libnet-interface-perl libpcap0.8-dev libpcre3-dev libsocket6-perl libspandsp-dev libssl-dev libswresample-dev libsystemd-dev libxmlrpc-core-c3-dev
$ dpkg-buildpackage

Now go to the parent directory and you will the *.deb packages of debain

$ cd ..
$ ls -lhtr
total 2.8M
drwxr-xr-x 16 root root 4.0K Dec 30 02:18 rtpengine
-rw-r--r--  1 root root 391K Dec 30 02:57 ngcp-rtpengine_8.1.1.2+0~mr8.1.1.2.tar.xz
-rw-r--r--  1 root root 1.9K Dec 30 02:57 ngcp-rtpengine_8.1.1.2+0~mr8.1.1.2.dsc
-rw-r--r--  1 root root 246K Dec 30 03:02 ngcp-rtpengine-daemon_8.1.1.2+0~mr8.1.1.2_amd64.deb
-rw-r--r--  1 root root 1.3M Dec 30 03:02 ngcp-rtpengine-daemon-dbgsym_8.1.1.2+0~mr8.1.1.2_amd64.deb
-rw-r--r--  1 root root  85K Dec 30 03:02 ngcp-rtpengine-recording-daemon_8.1.1.2+0~mr8.1.1.2_amd64.deb
-rw-r--r--  1 root root 369K Dec 30 03:02 ngcp-rtpengine-recording-daemon-dbgsym_8.1.1.2+0~mr8.1.1.2_amd64.deb
-rw-r--r--  1 root root  40K Dec 30 03:02 ngcp-rtpengine-iptables_8.1.1.2+0~mr8.1.1.2_amd64.deb
-rw-r--r--  1 root root 2.3K Dec 30 03:02 ngcp-rtpengine-iptables-dbgsym_8.1.1.2+0~mr8.1.1.2_amd64.deb
-rw-r--r--  1 root root  84K Dec 30 03:02 ngcp-rtpengine_8.1.1.2+0~mr8.1.1.2_all.deb
-rw-r--r--  1 root root  92K Dec 30 03:02 ngcp-rtpengine-kernel-source_8.1.1.2+0~mr8.1.1.2_all.deb
-rw-r--r--  1 root root  59K Dec 30 03:02 ngcp-rtpengine-kernel-dkms_8.1.1.2+0~mr8.1.1.2_all.deb
-rw-r--r--  1 root root  58K Dec 30 03:02 ngcp-rtpengine-utils_8.1.1.2+0~mr8.1.1.2_all.deb
-rw-r--r--  1 root root  15K Dec 30 03:02 ngcp-rtpengine_8.1.1.2+0~mr8.1.1.2_amd64.buildinfo
-rw-r--r--  1 root root 5.8K Dec 30 03:02 ngcp-rtpengine_8.1.1.2+0~mr8.1.1.2_amd64.changes

Now install rtpengine

$ dpkg -i ngcp-rtpengine-daemon_8.1.1.2+0~mr8.1.1.2_amd64.deb
$ dpkg -i ngcp-rtpengine-iptables_8.1.1.2+0~mr8.1.1.2_amd64.deb
$ dpkg -i ngcp-rtpengine-kernel-dkms_8.1.1.2+0~mr8.1.1.2_all.deb
$ dpkg -i  ngcp-rtpengine-recording-daemon_8.1.1.2+0~mr8.1.1.2_amd64.deb
$ dpkg -i  ngcp-rtpengine-recording-daemon_8.1.1.2+0~mr8.1.1.2_amd64.deb
$ dpkg -i ngcp-rtpengine_8.1.1.2+0~mr8.1.1.2_all.deb

Enjoy ;)

For distros other than Debian use to the following link

RESET MYSQL ROOT PASSWORD

To reset MySQL root password, you need to stop MySQL services.

$ systemctl stop mysqld
$ systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
$ systemctl start mysqld
$ mysql -u root
mysql> update user set authentication_string=PASSWORD("MyR00tPass") where User='root';
mysql> flush privileges;
mysql> exit

or for MySQL Version 8 
$ sudo mysqld_safe --skip-grant-tables --skip-networking &
$ mysql -u root -p 
mysql> update user set authentication_string=NULL where User='root';
mysql> exit
$ kill -9 mysqld
$ mysql -u root -p
Enter password: [ENTER]
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'MyR00tPass';
mysql> flush privileges;
mysql> exit
$ systemctl restart mysqld
$ mysql -u root -p 
Enter password: [PASSWORD]
mysql>

The root password has been updated. Please try to connect with an updated password

$ mysql -u root -p
mysql> create user 'bss'@'%' identified by 'passw0rd';
mysql> grant all on opensips.* to 'bss'@'%';
mysql> flush privileges;
mysql> exit

enjoy ;)

MySQL 8.0 installation on CentOS 7

MYSQL Server Installation step by step

$ yum remove `rpm -qa | grep mariadb`
$ yum install net-tools libxml2-devel.x86_64 libaio.x86_64 libaio-devel.x86_64 openssl.x86_64 openssl-devel.x86_64
$ wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-community-client-8.0.17-1.el7.x86_64.rpm
$ wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-community-server-8.0.17-1.el7.x86_64.rpm
$ wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-community-devel-8.0.17-1.el7.x86_64.rpm
$ wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-community-common-8.0.17-1.el7.x86_64.rpm
$ wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-community-libs-8.0.17-1.el7.x86_64.rpm
$ rpm -i mysql-community-common-8.0.17-1.el7.x86_64.rpm
$ rpm -i mysql-community-libs-8.0.17-1.el7.x86_64.rpm
$ rpm -i mysql-community-client-8.0.17-1.el7.x86_64.rpm
$ rpm -i mysql-community-server-8.0.17-1.el7.x86_64.rpm
$ systemctl start mysqld
$ grep 'temporary password' /var/log/mysqld.log
2018-08-27T21:52:41.002744Z 1 [Note] A temporary password is generated for root@localhost: GyD?Srgeq0IC
$ mysql_secure_installation
$ mysqladmin -u root -p version

For Debian follow this link and for MySQL5.7 you can follow this link

Enjoy ;)

Configure B2BUA Server using OpenSIPs

I used the topology hiding method in B2BUA Server.



Hamid Raza Hashmi hamid.hashmi006@gmail.com +92 300 968 22 85