So I took a working configuration and went to replicate it in the database that I just connected with ODBC. I went for an exact match to the working configuration, which I will post here for comparison:
insert into ps_endpoints (id,aors,auth,context,disallow,allow,direct_media,trust_id_outbound,device_state_busy_at,dtmf_mode,callerid) values (53998,53998,53998,‘Test802’,‘all’,‘ulaw’,‘yes’,‘yes’,1,‘rfc4733’,‘Test <53998>’);
insert into ps_auths (id,auth_type,password,username) values (53998,‘userpass’,‘unsecurepassword’,53998);
insert into ps_aors (id,max_contacts,mailboxes) values (53998,5,‘53998@example’);
So, I think that this should be an exact duplicate of the information in the working PBX. However, while the REGISTER messages appear to be identical between the working and non-working PBXs, the one with ODBC configured is not allowing the phones to register correctly. I am getting this behavior in the PBX logging, and my softphones never seem to log all the way in:
[Jan 25 17:27:26] ERROR: res_pjsip_registrar.c:637 register_aor_core: Unable to bind contact ‘sip:53998@[my_ip]:55887;rinstance=e9dd546c6c16966c’ to AOR ‘53998’
Can anyone point me in the right direction as to what might be causing this? My understanding was that if the database held the same values as the configuration file, it should work the same.
Thanks for the help.