connection files

database connection file

db_con.php

<?php

// Enable error reporting

//error_reporting(E_ALL);  // Report all errors

error_reporting(E_ERROR | E_PARSE);  // Show only errors and parse errors

ini_set('display_errors', 1);  // Display errors on the web page

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

// Database connection parameters

$host = "172.18.0.3";

$user = "root";

$password = "7133";

$database = "fm";

$mysqli = new mysqli("$host", "$user", "$password", "$database");

// Check for connection errors

if ($mysqli->connect_error) {

    die("Connection failed: " . $mysqli->connect_error);

}

?>

=============select function example=============

 #!/usr/bin/php -q

<?php

require(__DIR__."/getInfo.php");

$PhoneNum="$argv[1]";

$query_val_phone = "SELECT count(phoneNumber) as phoneNumber_num FROM users where phoneNumber='$PhoneNum'";

$registered=select($query_val_phone)[0]['phoneNumber_num'];

if($registered>0){

echo "EXEC Verbose \"User PhoneNum already registered\"\n";

echo "EXEC Goto \"music,100,1\"";

}

else {

echo "EXEC Verbose \"Phone number  $PhoneNum is not registered\"\n";

echo "EXEC Goto \"singup-en,sign-1,1\"";

} 

?>

-----------------

Function for  select.

 <?php

function select($query){

require(__DIR__."/db_con.php");

$result = $mysqli->query($query); 

if (!$result) {  // Check if the query failed

    printf("Error message: %s\n", $mysqli->error);

    exit();

}

$mysqli->close();  

 return $rows = $result->fetch_all(MYSQLI_ASSOC);  

}

?>

================

------------------------

Function for insert

function db_insert($query){

require(__DIR__."/db_con.php");

$result = $mysqli->query($query); 

if (!$result) {  // Check if the query failed

    printf("Error message: %s\n", $mysqli->error);

    exit();

}

$mysqli->close();  

 

}

$query="insert into bla bla";

db_insert($query); 

echo "EXEC Verbose \"$query\"\n";

// php cr_user.php "8297143421" "1982" "5001" "en" "cid"

?>

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

SIP registration process

 https://www.rfc-editor.org/rfc/rfc3261.html#section-10.3

getting read variable value from agi GET VAARIABLE

 #!/usr/bin/php

<?php

// Send the Read command to capture user input

echo "EXEC Read opt,demo-thanks,1\n";

flush(); // Ensure the command is sent to Asterisk

// Capture the response for EXEC Read

while (!feof(STDIN)) {

    $line = trim(fgets(STDIN));

    if (strpos($line, '200 result=') === 0) {

        break; // Stop reading after receiving the result

    }

}

// Send the GET VARIABLE command to retrieve the value of 'opt'

echo "GET VARIABLE opt\n";

flush(); // Ensure the command is sent to Asterisk

// Initialize a variable to store the result

$userInput = null;

// Capture the response for GET VARIABLE

while (!feof(STDIN)) {

    $line = trim(fgets(STDIN));

    if (preg_match('/^200 result=1 \((.*)\)$/', $line, $matches)) {

        $userInput = $matches[1]; // Store the captured value

        break;

    }

}

// Use the captured value

if ($userInput !== null) {

    echo "VERBOSE \"Captured user input: $userInput\"\n"; // Debug output to Asterisk CLI

    flush();

}

?>

while endwhile

 exten=>330,1,answer()

same=>n,Set(i=1)

same=>n,While($[${i} < 5])

;same=>n,Agi(/var/www/html/dial_agi.php,${i})

same=>n,Saydigits(${i})

same=>n,Set(i=$[${i} + 1])

same=>n,EndWhile()

;; code after  while end

same=>n,playback(demo-thanks)

same=>n,hangup()

confbridge

cmd.php?coference=989898000036&action=resume

<?php

require_once("./confbridgeinfo.php");  // get conf channel info

//Function to run the  commands
function runcmd($command){

$socket = fsockopen("127.0.0.1","7831", $errno, $errstr,60);
      if (!$socket){
        echo "$errstr ($errno)\n";
        }else{
            fputs($socket, "Action: Login\r\n");
            fputs($socket, "UserName: admin\r\n");
            fputs($socket, "Secret: 193\r\n\r\n");

            fputs($socket, "Action: Command\r\n");
            fputs($socket, "Command: $command\r\n\r\n");

            fputs($socket, "Action: Logoff\r\n\r\n");
           while (!feof($socket)){
          echo fgets($socket).'<br>';

 
           }
            fclose($socket);
            }


}       


// end  of the function section //

$coference=$_GET['coference'];

$action=$_GET['action'];

if($action=="hold"){
 $hold="channel originate Local/600@hold-context extension $coference@sidialConfBridges";


$agent_chan=get_conf_info($coference)[1];
 
$mute="confbridge mute $coference $agent_chan";
runcmd($hold);
runcmd($mute);

}

elseif($action=="resume"){

echo $hold_channel=get_conf_info($coference)[0];

 $unhold="channel request hangup $hold_channel";
 $unmute="confbridge unmute $coference all";

runcmd($unhold);
runcmd($unmute);
}
else {

///Nothing for now
}


?>

----------------------------

confbridgeinfo.php

<?php

$arr=array();


function  get_conf_info($agent){
$socket = fsockopen("127.0.0.1","7831", $errno, $errstr,60);
      if (!$socket){
        echo "$errstr ($errno)\n";
        }else{
            fputs($socket, "Action: Login\r\n");
            fputs($socket, "UserName: admin\r\n");
            fputs($socket, "Secret: 1333\r\n\r\n");

            fputs($socket, "Action: ConfbridgeList\r\n");
            fputs($socket, "Conference: $agent\r\n\r\n");

            fputs($socket, "Action: Logoff\r\n\r\n");
           while (!feof($socket)){
         // echo fgets($socket).'<br>';
          $arr[]=fgets($socket);
 
           }
            fclose($socket);
            }


foreach($arr as $key=>$value){
//echo "$key - $value<br>";


if(substr_count($value,"hold")){
  
 
 $arr['channel']=  explode(" ",$value)[1];
  
}



elseif(substr_count($value,"SIP")){
  
 
 $arr['agent']=  explode(" ",$value)[1];
  
}


} 

if (isset($arr['agent'])) {
      
return   $channels=explode(" ","$arr[channel] $arr[agent]");



} else {
    // If the channel does not exist, create an error message and encode $arr
    $arr['e'] = "No conference channel found";

}

}


//print_r(get_conf_info($argv[1]));
?>

channel originate from AMI

 <?php

$conferece=$_GET['conference'];

$action=$_GET['action'];

if($action=="hold"){

 $command="channel originate Local/600@hold-context extension $conferece@contextConfBridges";

}

elseif($action=="resume"){

}

$socket = fsockopen("127.0.0.1","7831", $errno, $errstr,60);

      if (!$socket){

        echo "$errstr ($errno)\n";

        }else{

            fputs($socket, "Action: Login\r\n");

            fputs($socket, "UserName: admin\r\n");

            fputs($socket, "Secret: 113333\r\n\r\n");

            fputs($socket, "Action: Command\r\n");

            fputs($socket, "Command: $command\r\n\r\n");

            fputs($socket, "Action: Logoff\r\n\r\n");

           while (!feof($socket)){

          echo fgets($socket).'<br>';

 

           }

            fclose($socket);

            }

 

?>