hi,
I am a beginner and recently I installed asterisk and I started to configure it to use the same integrated with mysql, to be more exact phpmyadmin, but regardless of the settings and examples that I find on the net, I always have to return the same error, what to do?
I’ll make the settings and error available!
ERROR LOG: NOTICE[6780]: res_pjsip/pjsip_distributor.c:631 log_failed_request: Request ‘REGISTER’ from ‘<sip:6006@192.168.0.83;user=phone>’ failed for ‘192.168.0.66:5060’ (callid: 6994167190547346602-1524148126-502485748) - No matching endpoint found
CONFIG ->>> ( Asterisk 15.7.1 )
<< res_config_mysql >>
[asterisk-mysql]
dbhost = localhost
dbname = asterisk
dbuser = asterisk
dbpass = q1w2e3r4
dbport = 3306
dbsock = /var/run/mysqld/mysqld.sock
dbcharset = latin1
<< extconfig.conf >>
sippeers => mysql,asterisk-mysql,sip
sipusers => mysql,asterisk-mysql,sip
<< sip.conf >>
uncomment -> rtcachefriends=yes
<< Table phpmyadmin >>
CREATE TABLE IF NOT EXISTS sip (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(10) NOT NULL,
ipaddr varchar(45) DEFAULT NULL,
port int(5) DEFAULT NULL,
regseconds int(11) DEFAULT NULL,
defaultuser varchar(10) DEFAULT NULL,
fullcontact varchar(80) DEFAULT NULL,
regserver varchar(20) DEFAULT NULL,
useragent varchar(20) DEFAULT NULL,
lastms int(11) DEFAULT NULL,
host varchar(40) DEFAULT NULL,
type enum(‘friend’,‘user’,‘peer’) DEFAULT NULL,
context varchar(40) DEFAULT NULL,
permit varchar(95) DEFAULT NULL,
deny varchar(95) DEFAULT NULL,
secret varchar(40) DEFAULT NULL,
md5secret varchar(40) DEFAULT NULL,
remotesecret varchar(40) DEFAULT NULL,
transport enum(‘udp’,‘tcp’,‘udp,tcp’,‘tcp,udp’) DEFAULT NULL,
dtmfmode enum(‘rfc2833’,‘info’,‘shortinfo’,‘inband’,‘auto’) DEFAULT NULL,
directmedia enum(‘yes’,‘no’,‘nonat’,‘update’) DEFAULT NULL,
nat varchar(29) DEFAULT NULL,
callgroup varchar(40) DEFAULT NULL,
pickupgroup varchar(40) DEFAULT NULL,
language varchar(40) DEFAULT NULL,
disallow varchar(40) DEFAULT NULL,
allow varchar(40) DEFAULT NULL,
insecure varchar(40) DEFAULT NULL,
trustrpid enum(‘yes’,‘no’) DEFAULT NULL,
progressinband enum(‘yes’,‘no’,‘never’) DEFAULT NULL,
promiscredir enum(‘yes’,‘no’) DEFAULT NULL,
useclientcode enum(‘yes’,‘no’) DEFAULT NULL,
accountcode varchar(40) DEFAULT NULL,
setvar varchar(40) DEFAULT NULL,
callerid varchar(40) DEFAULT NULL,
amaflags varchar(40) DEFAULT NULL,
callcounter enum(‘yes’,‘no’) DEFAULT NULL,
busylevel int(11) DEFAULT NULL,
allowoverlap enum(‘yes’,‘no’) DEFAULT NULL,
allowsubscribe enum(‘yes’,‘no’) DEFAULT NULL,
videosupport enum(‘yes’,‘no’) DEFAULT NULL,
maxcallbitrate int(11) DEFAULT NULL,
rfc2833compensate enum(‘yes’,‘no’) DEFAULT NULL,
mailbox varchar(40) DEFAULT NULL,
session-timers enum(‘accept’,‘refuse’,‘originate’) DEFAULT NULL,
session-expires int(11) DEFAULT NULL,
session-minse int(11) DEFAULT NULL,
session-refresher enum(‘uac’,‘uas’) DEFAULT NULL,
t38pt_usertpsource varchar(40) DEFAULT NULL,
regexten varchar(40) DEFAULT NULL,
fromdomain varchar(40) DEFAULT NULL,
fromuser varchar(40) DEFAULT NULL,
qualify varchar(40) DEFAULT NULL,
defaultip varchar(45) DEFAULT NULL,
rtptimeout int(11) DEFAULT NULL,
rtpholdtimeout int(11) DEFAULT NULL,
sendrpid enum(‘yes’,‘no’) DEFAULT NULL,
outboundproxy varchar(40) DEFAULT NULL,
callbackextension varchar(40) DEFAULT NULL,
timert1 int(11) DEFAULT NULL,
timerb int(11) DEFAULT NULL,
qualifyfreq int(11) DEFAULT NULL,
constantssrc enum(‘yes’,‘no’) DEFAULT NULL,
contactpermit varchar(95) DEFAULT NULL,
contactdeny varchar(95) DEFAULT NULL,
usereqphone enum(‘yes’,‘no’) DEFAULT NULL,
textsupport enum(‘yes’,‘no’) DEFAULT NULL,
faxdetect enum(‘yes’,‘no’) DEFAULT NULL,
buggymwi enum(‘yes’,‘no’) DEFAULT NULL,
auth varchar(40) DEFAULT NULL,
fullname varchar(40) DEFAULT NULL,
trunkname varchar(40) DEFAULT NULL,
cid_number varchar(40) DEFAULT NULL,
callingpres enum(‘allowed_not_screened’,‘allowed_passed_screen’,‘allowed_failed_screen’,‘allowed’,‘prohib_not_screened’,‘prohib_passed_screen’,‘prohib_failed_screen’,‘prohib’) DEFAULT NULL,
mohinterpret varchar(40) DEFAULT NULL,
mohsuggest varchar(40) DEFAULT NULL,
parkinglot varchar(40) DEFAULT NULL,
hasvoicemail enum(‘yes’,‘no’) DEFAULT NULL,
subscribemwi enum(‘yes’,‘no’) DEFAULT NULL,
vmexten varchar(40) DEFAULT NULL,
autoframing enum(‘yes’,‘no’) DEFAULT NULL,
rtpkeepalive int(11) DEFAULT NULL,
call-limit int(11) DEFAULT NULL,
g726nonstandard enum(‘yes’,‘no’) DEFAULT NULL,
ignoresdpversion enum(‘yes’,‘no’) DEFAULT NULL,
allowtransfer enum(‘yes’,‘no’) DEFAULT NULL,
dynamic enum(‘yes’,‘no’) DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY name (name),
KEY ipaddr (ipaddr,port),
KEY host (host,port)
) ENGINE=MyISAM