Debian Asterisk Realtime

1  apt update &&  o apt update

2  apt-get install unixodbc odbcinst

3  apt-get install alembic

Install MariaDB

4  apt install mariadb-server -y

5 systemctl enable mariadb.service

6 systemctl status mariadb.service

Change root mysql pass

1. mysqladmin -u root -p password 'asterisk'

create the asterisk db

2. mysqladmin -u root -pasterisk create asterisk

3 check the db

mysql -u root -p -D asterisk

First, install Alembic: and the  mysql module

 apt-get install python3-mysqldb

 apt-get install alembic

Then, move to the Asterisk source directory containing the Alembic scripts:

# cd contrib/ast-db-manage/

Next, edit the config.ini.sample file and change the sqlalchemy.url option, e.g.

sqlalchemy.url = mysql://root:asterisk@localhost/asterisk

such that the URL matches the username and password required to access your database.

Then rename the config.ini.sample file to config.ini

# cp config.ini.sample config.ini

Finally, use Alembic to setup the database tables:

# alembic -c config.ini upgrade head

You'll see something similar to:

# alembic -c config.ini upgrade head
INFO  [alembic.migration] Context impl MySQLImpl.
INFO  [alembic.migration] Will assume non-transactional DDL.
INFO  [alembic.migration] Running upgrade None -> 4da0c5f79a9c, Create tables
INFO  [alembic.migration] Running upgrade 4da0c5f79a9c -> 43956d550a44, Add tables for pjsip
#

 mysql -u root -p -D asterisk

mysql> show tables;
+--------------------+
| Tables_in_asterisk |
+--------------------+
| alembic_version    |
| iaxfriends         |
| meetme             |
| musiconhold        |
| ps_aors            |
| ps_auths           |
| ps_contacts        |
| ps_domain_aliases  |
| ps_endpoint_id_ips |
| ps_endpoints       |
| sippeers           |
| voicemail          |
+--------------------+
12 rows in set (0.00 sec)
mysql> quit

 https://www.asterisk.org/configuring-realtime-voicemail-on-debian/

Initial ODBC Setup

7 apt-get install odbc-mariadb

8   dpkg -L odbc-mariadb

9   nano  /etc/odbc.ini

[asterisk]

Description = MySQL Server

Driver = MySQL ODBC Driver

Database = asterisk

Server = localhost

User = root

Password = asterisk

Port = 3306

Socket = /var/run/mysqld/mysqld.sock

10   nano  /etc/odbcinst.ini 

[MariaDB Unicode]

Driver=libmaodbc.so

Description=MariaDB Connector/ODBC(Unicode)

Threading=0

UsageCount=1

[MySQL ODBC Driver]

Description = MySQL Connector/ODBC

Driver = /usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so

11  test connection

odbcinst -q -d
echo “select 1” | isql -v asterisk

Install Asterisk

 1  wget http://downloads.asterisk.org/pub/telephony/asterisk/asterisk-22-current.tar.gz

 

2 tar zxvf asterisk*

3 rm *.gz

4 cd asterisk*

 5 contrib/scripts/install_prereq install

6 ./configure --libdir=/usr/lib64 --with-pjproject-bundled --with-jansson-bundled && make menuselect && make && make install

   7 make samples

  8  make config

   9 ldconfig

    10 /etc/init.d/asterisk start

   11 asterisk -rvvvvvvvv

 

 if shared library error 

     ldd /usr/sbin/asterisk

  

    find / -name 'libasteriskssl.so.1'

     ln -s /usr/lib64/libasteriskssl.so.1 /lib/x86_64-linux-gnu

     ln -s /usr/lib64/libasteriskpj.so.2 /lib/x86_64-linux-gnu

    ldconfig

     systemctl start asterisk

     asterisk -rvvvvvvvv

Configure asterisk ODBC files

/etc/asterisk/res_odbc.conf

[asterisk]

enabled => yes

dsn => asterisk

username => root

password => asterisk

pre-connect => yes

/etc/asterisk/cdr_adaptive_odbc.conf

[asterisk]

connection=asterisk

table=cdr

alias start => calldate

	module reload res_odbc.so Check connection asterisk_realtime*CLI> odbc show all ODBC DSN Settings -----------------   Name:   asterisk   DSN:    asterisk     Number of active connections: 1 (out of 1)     Logging: Disabled Asterisk relatime configuration  /etc/asterisk/sorcery.conf [res_pjsip] ; Realtime PJSIP configuration wizard endpoint=realtime,ps_endpoints auth=realtime,ps_auths aor=realtime,ps_aors domain_alias=realtime,ps_domain_aliases contact=realtime,ps_contacts [res_pjsip_endpoint_identifier_ip] identify=realtime,ps_endpoint_id_ips [res_pjsip_outbound_registration] registration=realtime,ps_registrations /etc/asterisk/extconfig.conf ps_endpoints => odbc,asterisk ps_auths => odbc,asterisk ps_aors => odbc,asterisk ps_domain_aliases => odbc,asterisk ps_endpoint_id_ips => odbc,asterisk ps_contacts => odbc,asterisk ps_registrations = odbc,asterisk etc/asterisk/modules.conf preload => res_odbc.so preload => res_config_odbc.so noload => chan_sip.so  /etc/asterisk/pjsip.conf [transport-udp] type=transport protocol=udp bind=0.0.0.0 /etc/asterisk/extensions.conf [testing] exten=>_x.,1,Dial(PJSIP/${EXTEN},120) same=>n,hangup()

RESTART the asterisk service after add the transport

core restart now

ALTER TABLE ps_contacts

ADD COLUMN qualify_2xx_only VARCHAR(255) AFTER qualify_timeout;

https://hotkey404.com/fix-missing-asterisk-library-error-libasteriskssl-so-1-libasteriskpj-so-2-not-found/

https://docs.vultr.com/how-to-install-mariadb-on-debian-12

https://asterisk-rd.blogspot.com/search?q=rocky

sudo apt install apache2

sudo apt install php php-mysql php-cli

sudo systemctl status apache2

sudo systemctl enable apache2

sudo systemctl restart apache2


1. Disable UFW (Temporarily)

sudo ufw disable

2. Check UFW Status
sudo ufw status


3. Remove UFW (Optional)
sudo apt remove --purge ufw