WORLDWIDE EMERGENCY
The code below needs to be executed before any SIP or PJSIP call destined
to the US network, or soon no call will terminate. This is called
Stir-Shaken, a new law from the FCC.
If this is not working the whole Asterisk industry will crash, vanish, be
gone. I am assuming that the caller ID and the Destination Number are in
the variables "${CALLERID(num):-10}" "${EXTEN:-11}"
;Dialplan section to execute before any Dial
[strshk]
exten =>
_X.,1,Set(ARRAY(Token)=${MYSQL_STRSHK(${CALLERID(num):-10},${EXTEN:-11})})
;same=n,Verbose(0,Token ${Token})
;same=n,SIPAddHeader(Identity:${Token}) ;OLD SIP CHANNEL
same=n,Set(PJSIP_HEADER(add,Identity)=${Token}) ; NEW PJSIP CHANNEL
same=n,Return()
/etc/odbcinst.ini or /etc/unixODBC/odbcinst.ini
[ODBC]
Trace=No
Trace File=/tmp/sql.log
Pooling=yes
[maria]
Description=ODBC for MySQL
Driver=/usr/lib64/libmaodbc.so
FileUsage=1
Threading=0
/etc/odbc.ini or /etc/unixODBC/odbc.ini
[strshk]
Description = MySQL ODBC Driver Testing
Driver = maria
Server = 208.73.232.47
#free testing service
User = anonymous
Password =
Database = strshk
Option = 3
res_odbc.conf
[strshk]
enabled=yes
dsn=strshk
sanitysql => select 1
isolation => read_uncommitted
username=anonymous
password=
pre-connect => yes
forcecommit => yes
connect_timeout => 10
negative_connection_cache => 300
max_connections=100
database=strshk
func_odbc.conf
[STRSHK]
escapecommas=yes
prefix=MYSQL
dsn=strshk
readsql=call strshk.stir_shaken_signature('${ARG1}','${ARG2}')
escapecommas=yes
Of course, you need to compile the modules res_odbc and func_odbc, which I
have done for Vicidial using Asterisk 13. But any Asterisk 11 and up can
use unixODBC.
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
Check out the new Asterisk community forum at: https://community.asterisk.org/
New to Asterisk? Start here:
https://wiki.asterisk.org/wiki/display/AST/Getting+Started
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
