PJSIP: pjsip.conf with templates and realtime pgsql

[benjoco]

Dear community,

I’m working with Astersik 20.7.0 and I would like to know if it’s possible to “combine” a pjsip.conf with endpoints, auths, aors and registrations as template (!) with a realtime configuration (in my case postgresql) ?

What’s working ?
A “full” pjsip.conf with templates and users infos (register ok + call ok)
A pjsip.conf with templates and all auth informations (for test purposes, I tried to configure only the “auth” setting) in the database. (register ok + call ok)

What am I trying to do?
A pjsip.conf with templates and “partial” auth informations in the database i.e :
sample of pjsip.conf

...
[auth_base](!)
type=auth
realm=lab.fr
auth_type=md5
...

database “asterisk”, table “ps_auths”

         id         | auth_type | nonce_lifetime |             md5_cred             | password | realm |   username    | refresh_token | oauth_clientid | oauth_secret
--------------------+-----------+----------------+----------------------------------+----------+-------+---------------+---------------+----------------+--------------
 Raph-auth          |           |                | 688410038ae1bjio3a6002ce4dd5937  |          |       | Raph          |               |                |
 Jess-auth          |           |                | c2db69b1b851b430a9f7bbrft5b734f6 |          |       | Jess          |               |                |

With pjsip.conf the “id” is more like “[Raph-auth] (auth_base)” but I don’t know how to configure when I use template + realtime as I do with a “full” config in pjsip.conf

I don’t know if it’s really clear (english is not my native language) sometimes it’s hard to explain “something in your head” so I remain available for further information.

Regards,

Benjoco

[jcolp]

No. You can’t use realtime like that with templates.

[benjoco]

Hi jcolp,

thank you for your answer, I think it’s clear but, to your knowledge, is there any way of avoiding redundant information?

benjoco

[jcolp]

There is nothing on the Asterisk side in regards to realtime for that. There may be something from a database perspective, such as a view.