Hello. Please help to configure asterisk PJSIP realtime.
res_odbc.conf
[ics-postgresql]
enabled=>yes
dsn=>PostgreSQL-icsdb
pre-connect=>yes
username=>username
password=>password
database=>ics
logging=>yes
/etc/asterisk/res_config_odbc.conf
[ics-postgresql]
enabled=>yes
dsn=>PostgreSQL-icsdb
pre-connect=>yes
username=>ics
password=>icsdemo1!
;database=>ics
logging=>no
I’ve checked realtime works. For examle cdr inserting to db.
but when I’m trying to configure sorcery.conf
[res_pjsip]
endpoint=realtime,ps_endpoints
auth=realtime,ps_auths
aor=realtime,ps_aors
domain_alias=realtime,ps_domain_aliases
contact=realtime,ps_contacts
extconfig.conf
ps_auths => odbc,ics-postgresql
ps_aors => odbc,ics-postgresql
ps_domain_aliases => odbc,ics-postgresql
ps_endpoint_id_ips => odbc,ics-postgresql
ps_registrations => odbc,ics-postgresql
asterisk tried to connect to asterisk db using role asterisk. And PJSiP entities failed.
it’s postgresql db log:
EEST,"asterisk","asterisk",35037,"127.0.0.1:38460",60ae0c9f.88dd,1,"startup",2021-05-26 11:53:51 EEST,4/882,0,FATAL,28000,"role ""asterisk"" does not exist",,,,,,,,,""
FATAL,3D000,"database ""asterisk"" does not exist",,,,,,,,,""
my database name is ics. and save to odbc config.
How to say asterisk sorcery use odbc with correct database name and login?