PJSIP and realtime

Hi to all,

i have a problem ( :frowning: ) I’ve configured realtime, odbc connection and all works properly. But when i do “pjsip show endpoints”, the output message is “No objects found.”. Endpoints are present into db.

Can anyone help me?

Cheers

What is the configuration for everything?

sorcery.conf is

[res_pjsip] ; Realtime PJSIP configuration wizard
;endpoint=config,pjsip.conf,criteria=type=endpoint
endpoint=realtime,ps_endpoints
;auth=config,pjsip.conf,criteria=type=auth
auth=realtime,ps_auths
;aor=config,pjsip.conf,criteria=type=aor
aor=realtime,ps_aors
domain_alias=realtime,ps_domain_aliases
contact=realtime,ps_contacts

[res_pjsip_endpoint_identifier_ip]
;identify=config,pjsip.conf,criteria=type=identify
identify=realtime,ps_endpoint_id_ips

extconfig.conf is

[settings]
ps_endpoints => odbc,asterisk
ps_auths => odbc,asterisk
ps_aors => odbc,asterisk
ps_domain_aliases => odbc,asterisk
ps_contacts => odbc,asterisk
ps_endpoint_id_ips => odbc,asterisk

pjsip.conf is

[transport-ws]
type=transport
protocol=ws
bind=0.0.0.0

[transport-udp]
type=transport
protocol=udp
bind=0.0.0.0

[transport-tls]
type=transport
protocol=tls
bind=0.0.0.0:5061
cert_file=/etc/asterisk/keys/asterisk.crt
priv_key_file=/etc/asterisk/keys/asterisk.key
method=tlsv1

res_odbc.conf is

[asterisk]
enabled => yes
dsn => asterisk
username => CMT_OWN
password => CMT_OWN
pre-connect => yes

DNS is configured properly, if i type “isql -v asterisk” i can connect successfully to it.

Cheers,

Did you use Alembic or the generated schemas to create the tables? What database is in use?

I’ve generated schema manually. My db is oracle 12

Oracle is not currently supported. There is an issue[1] for it.

[1] https://issues.asterisk.org/jira/browse/ASTERISK-26106

Oh this is a good news :frowning:

I can only wait for the fix for this problem, or can I do about it?

You can either try to fix it yourself (without breaking other databases) or wait for it to be fixed by someone else.

Thank you, I think to wait the resolution by someone else :stuck_out_tongue:

Regards,

jcolp, do you know if is possible to set a realtime with chan_sip using protocol wss ?

If yes, what is the table structure?

Thank you

I have not used realtime with chan_sip in years and have not used it with wss.

Ok thank you.

Regards,