Here is my endpoint create query:
insert into ps_auths (auth_type, md5_cred, nonce_lifetime, password, realm, username, id)
values (‘userpass’, null, null, ‘123456’, null, ‘7012’, ‘7012’)
insert into ps_aors (id,max_contacts,remove_existing,authenticate_qualify, contact, default_expiration, mailboxes, maximum_expiration, minimum_expiration, outbound_proxy, qualify_frequency, qualify_timeout, support_path, voicemail_extension)
values (‘7012’,1,‘yes’,null, null, null, null, null, null, null, null, null, null, null)
insert into ps_endpoints (id,transport,disallow,allow, allow_transfer, aors, auth, context, direct_media, dtmf_mode, force_rport, inband_progress )
values (‘7012’, ‘transport-udp’,‘all’,‘alaw,ulaw,gsm’, ‘yes’, ‘7012’, ‘7012’, ‘agent_dialplan’, ‘no’, ‘auto’, null, ‘no’)
After registering endpoint
pjsip list endpints
Endpoint: <Endpoint/CID…> <State…> <Channels.>
==========================================================================================
Endpoint: 7012 Unavailable 0 of inf
pjsip list contacts
Contact: <Aor/ContactUri…> <Hash…> <RTT(ms)…>
==========================================================================================
Contact: 7012/sip:7012@172.16.16.1:51782;transport=UDP; 8960de11db NonQual nan
Queue member add query:
insert into queue_member (interface, membername, paused, penalty, queue_name, id) values(“PJSIP/7012”, “7012”, null, null, “agent_queue”, 731)