Issue with Realtime PJSIP ps_contacts

Asterisk Asterisk SIP
1

Hi !

I’ve got a strange problem, I’m trying to configure Realtime PJSIP to populate ps_contacts table according the main Wiki of Asterisk. But when Sorcery is configure to use SQL database :
contact=realtime,ps_contacts
It doesn’t works :

[May 12 11:13:50] ERROR[139903]: res_pjsip_registrar.c:861 register_aor_core: Unable to bind contact 'sip:101@***MASKEDIPADDRESS***:28682;rinstance=3bd24a3444458404' to AOR '101'

My table schema seems to be good, and setting debug to full doesn’t help me.

ODBC looks good :

asterisk -rx 'odbc show'

ODBC DSN Settings
-----------------

  Name:   asterisk
  DSN:    asterisk
    Number of active connections: 1 (out of 20)
    Logging: Disabled

Full 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

Full 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_outbound_publishes => odbc,asterisk
ps_inbound_publications = odbc,asterisk
ps_asterisk_publications = odbc,asterisk
ps_contacts => odbc, asterisk

Any idea ?

2

What database is in use? And provide the schema. You just saying “My table schema seems to be good” relies on your analysis.

3

I mean, according forum / Wiki :


CREATE TABLE `ps_contacts` (
  `id` varchar(255) DEFAULT NULL,
  `uri` varchar(255) DEFAULT NULL,
  `expiration_time` bigint(20) DEFAULT NULL,
  `qualify_frequency` int(11) DEFAULT NULL,
  `outbound_proxy` varchar(40) DEFAULT NULL,
  `path` text DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `qualify_timeout` float DEFAULT NULL,
  `reg_server` varchar(20) DEFAULT NULL,
  `authenticate_qualify` enum('yes','no') DEFAULT NULL,
  `via_addr` varchar(40) DEFAULT NULL,
  `via_port` int(11) DEFAULT NULL,
  `call_id` varchar(255) DEFAULT NULL,
  `endpoint` varchar(40) DEFAULT NULL,
  `prune_on_boot` enum('yes','no') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `ps_contacts`
--
ALTER TABLE `ps_contacts`
  ADD UNIQUE KEY `id` (`id`),
  ADD UNIQUE KEY `ps_contacts_uq` (`id`,`reg_server`),
  ADD KEY `ps_contacts_id` (`id`),
  ADD KEY `ps_contacts_qualifyfreq_exp` (`qualify_frequency`,`expiration_time`);
COMMIT;

Trying elsewhere to create database with Alambic with exactly the same result.