Hello,
I tried to install and add users and session info via asterisk realtime module on postgresql
First i tried to create the example db schemas from various webpages under a database named “hsta”
Anyway, first i created the cdr_pgsql.conf file
with the following information
[global]
hostname=127.0.0.1
port=5598
dbname=hsta
password=secret
user=postgres
table=cdr
I confirmed that it is logging on db server fine…
Second step was to make sip_peers work on sql service.
extconfig.conf
[settings]
sipusers => pgsql,general,sip_conf
sippeers => pgsql,general,sip_conf
Then res_pgsql.conf
[general]
dbhost=127.0.0.1
dbport=5598
dbname=hsta
dbuser=postgres
dbpass=secret
requirements=warn
On sip.conf i have only general context… I couldn find out how to add a realtime switch to this part.
Any help will be great…
When i check my sql, i see no select to load users from db, nor i cant see any users on sip show peers too.
ps: also sip.conf
[general]
context=from-sip
and extensions.conf:
[from-sip]
switch =>Realtime