<br clear="all">Hi All,<br><br><br> I am trying to configure asterisk realtime. But i am unable to get the extensions listed successfully when i type "sip show peers" in the asterisk CLI . i am unable to see any failure logs when i do a reload<br>
<br> i can able to connect to the data source through "odbc show" in the CLI, Any hep in this regard is highly appreciated. Following is the configuration and specification. <br><br> <b>Server Specification:</b><br>
<br> 1) asterisk-1.6.2.6<br> 2) CentOS- 5.2 (64-bit)<br> 3) Postgresql- 8.1<br> <br> <b>Configuration:</b><br> <br> <u><b> odbc.ini</b></u><br><br> [PostgreSQL]<br>Description = Test to Postgres<br>
Driver = PostgreSQL<br>Trace = Yes<br>TraceFile = /tmp/sql.log<br>Database = bedrock<br>Servername = localhost<br>UserName =<br>Password =<br>
Port = 5432<br>Protocol = 6.4<br>ReadOnly = No<br>RowVersioning = No<br>ShowSystemTables = No<br>ShowOidColumn = No<br>FakeOidIndex = No<br>ConnSettings =<br>
<br> <u><b>odbcinst.ini</b></u><br><br>[PostgreSQL]<br>Description = ODBC for PostgreSQL<br>Driver = /usr/lib64/libodbcpsql.so<br>Setup = /usr/lib64/libodbcpsqlS.so<br>FileUsage = 1<br><br>
<u><b> res_odbc.conf</b></u><br><br>[postgres]<br>enabled => yes<br>dsn => PostgreSQL<br>username =>postgres<br>password =>postgres<br>pre-connect => yes<br><br><br> <u><b>Database table in postgres "sip" :</b></u><br>
<br> Column | Type | Modifiers<br>----------------+------------------------+--------------------------------------------------<br> id | integer | not null default nextval('sip_id_seq'::regclass)<br>
name | character varying(80) | not null<br> accountcode | character varying(20) |<br> amaflags | character varying(7) |<br> callgroup | character varying(10) |<br> callerid | character varying(80) |<br>
directmedia | character varying(3) | default 'yes'::character varying<br> context | character varying(80) | default 'default'::character varying<br> defaultip | character varying(15) |<br>
dtmfmode | character varying(7) |<br> fromuser | character varying(80) |<br> fromdomain | character varying(80) |<br> host | character varying(31) | not null default 'dynamic'::character varying<br>
insecure | character varying(4) |<br> language | character varying(2) |<br> mailbox | character varying(50) |<br> md5secret | character varying(80) |<br> nat | character varying(5) | not null default 'no'::character varying<br>
permit | character varying(95) |<br> deny | character varying(95) |<br> mask | character varying(95) |<br> pickupgroup | character varying(10) |<br> port | character varying(5) |<br>
qualify | character varying(3) |<br> restrictcid | character varying(1) |<br> rtptimeout | character varying(3) |<br> rtpholdtimeout | character varying(3) |<br> secret | character varying(80) |<br>
type | character varying | not null default 'friend'::character varying<br> username | character varying(80) |<br> disallow | character varying(100) | default 'all'::character varying<br>
allow | character varying(100) | default 'alaw,ulaw'::character varying<br> musiconhold | character varying(100) |<br> regseconds | integer | not null default 0<br> ipaddr | character varying(15) |<br>
regexten | character varying(80) |<br> cancallforward | character varying(3) | default 'yes'::character varying<br> lastms | character varying(80) |<br> useragent | character varying(100) |<br>
defaultuser | character varying(100) |<br> fullcontact | character varying(100) |<br> regserver | character varying(100) |<br>Indexes:<br> "sip_conf_pkey" PRIMARY KEY, btree (id)<br> "name" UNIQUE, btree (name)<br>
<br> <u><b>extconfig.conf</b></u><br><br>sipusers => odbc,postgres,sip<br>sippeers => odbc,postgres,sip<br><br><br>Thanks & Regards<br><br>Murali Vasu<br><br><br> <br><br><br><br><br><br>-- <br>
Smile is the only priceless gift you can give without a price.........<br>