similar to: troubles with res_pgsql

Hi I am having problems with Asterisk 1.4.18 and realtime architecture. I use Postgresql-8.3 as the database. Everything works OK; all sip phones (their configs are in the database) are able to register to the server and I can make calls (dialplan is in the database), but each time Asterisk reads the information from the database it shows me this on the console: [Feb 17 12:32:50] WARNING[620]:

We are using PostgreSQL real-time connector (res_config_pgsql) with Asterisk 1.6.2.15. From time to time, we need to reset our PostgreSQL server, causing all active DB connections to close. While other packages in our system re-connect gracefully when this happens, Asterisk appears to not bother trying. It instead goes into an endless loop complaining that the connection has closed. Question --

Hello, How do I use multiple postgresql databases using res_config_pgsql? I tried creating multiple contexts in res_pgsql.conf, but asterisk is only using the 'general' context. My res_pgsq.conf is [general] ;; Connect to mydb on localhost dbport=5432 dbname=mydb dbuser=pgdbuser requirements=warn [pgwritedb] ;; Connect to mydb2 on another host dbhost=<IP

When I try and start asterisk I get the following, however I have commented out the data the connections in res_mysql.conf and res_pgsql.conf. I am not sure therefore why I am getting these errors. Do I have to change something else to turn this off? Thanks Asterisk 1.4.21.2~dfsg-3, Copyright (C) 1999 - 2008 Digium, Inc. and others. Created by Mark Spencer <markster at digium.com> Asterisk

Hello, I am using asterisk realtime with a postgresql database on the same server. In res_pgsql.conf I have specified [general] dbhost=localhost dbport=5432 dbname=asteriskdb dbuser=psql dbsock=/tmp/.s.PGSQL.5432 Since both asterisk and db are on same server, I would like asterisk to connect to db using the local unix socket. However asterisk is not using the local unix socket to connect to

Hi Andrew, OK, (the simple fact that those machines are not connected to internet makes that i have to go to those machines and copy them on a usb-stick, so it causes some delay each time...) -------- Forwarded Message -------- Sorry - I meant extconfig.conf - not cdr_mysql.conf (my mistake). I use (and done for a long time) mySQL for realtime storage - and it's never let me down (touch

Hi, I am using Realtime for sip configuration. When there is an INVITE which arrives at asterisk asterisk makes the following selects: Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE name = 'tzl' [Nov

Hi to all the ML. I'm new here. I start to use asterisk with realtime configuration, with pgsql backend connected via odbc. The connection between asterisk and pgsql works fine. I create a table sip_conf with 2 user (for testing purpose), 1401 and 1501. Those are the records: asterisk=> SELECT name,host,type,context,secret,defaultuser from sip_conf; name | host | type | context |

Hi to all the ML. I'm new here. I start to use asterisk with realtime configuration, with pgsql backend connected via odbc. The connection between asterisk and pgsql works fine. I create a table sip_conf with 2 user (for testing purpose), 1401 and 1501. Those are the records: asterisk=> SELECT name,host,type,context,secret,defaultuser from sip_conf; name | host | type | context | secret |

Hi to all the ML. I'm new here. I start to use asterisk with realtime configuration, with pgsql backend connected via odbc. The connection between asterisk and pgsql works fine. I create a table sip_conf with 2 user (for testing purpose), 1401 and 1501. Those are the records: asterisk=> SELECT name,host,type,context,secret,defaultuser from sip_conf; name | host | type | context |

Hi. I can't figure this one out. Hope someone can help me. root@pbx:# cat /etc/odbc.ini [Asterisk] Description=PostgreSQL asterisk Driver=PostgreSQL Trace=No TraceFile=/tmp/odbc.log Database=asterisk ServerName=localhost UserName=XXXX Password=XXXX Port=5432 Protocol=7.4 ReadOnly=No RowVersioning=No ShowSystemTables=Yes ShowOidColumn=Yes FakeOidIndex=Yes ConnSettings=

I want to let Asterisk read its configuration from a mysql database. I configured everything according to the wiki page: http://www.voip-info.org/tiki-index.php?page=Asterisk+res_config. However it doesn't work. I am using 1.0.8 asterisk version and here are my config files: Extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf =>

Nope, I got the stable 1.08 release from cvs. Frank From: "Wei Kun" <wei-kun@mediaring.com> Subject: RE: [Asterisk-Users] Asterisk configuration from database withres_config To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" <asterisk-users@lists.digium.com> Message-ID: <00a301c5a3c5$93384370$6f01010a@corp.mediaring.com> Content-Type:

I was trying the following setup with IPIP tunnels, one that used to work through another ISP, but no longer... Internal network | Linux box 1 (kernel 2.2.24) iif=10.0.0.1, extf=a.b.c.d, tunf=172.16.0.1 | |local metropolitan network | Another Linux box 2 (kernel 2.2.17, or 2.4.19, same result) iif=irrelevant, extf=x.y.z.v,

Hi, I have the following setup. Two linux systems with two [test] external interfaces encrypted with ipsec [transport]. Two gre tunnels that pass 10.200.0.0/24 and 10.200.1.0/24 network traffic. Testing the balanced tunnels I would setup iptraf on one and ping from the other. The results would be as expected; traffic would be split between the two interfaces. Testing with an ftp transfer of

Starting with Asterisk 1.2 I have always used realtime static to load my extensions.conf into Asterisk. It worked perfectly up to version 1.6.0.X but starting from 1.6.1.X and upwards it simply does nothing. I can see that the extensions.conf file is mapped to the database: == Parsing '/etc/asterisk/asterisk.conf': == Found == Parsing '/etc/asterisk/extconfig.conf': ==

Hello, To make my dialplan more robust, I thought I wouldn't include any meetme-specific rules and I would exlusively rely on meetme.conf data. For each dialed number, I would check if this number is used as a conference room number in meetme.conf. When I'm trying to implement this, I can see that : 1. AST_CONFIG is not convenient to parse lines like "conf=>1234", as

Hi, I have the following setup. Two linux systems with two [test] external interfaces encrypted with ipsec [transport]. Two gre tunnels that pass 10.200.0.0/24 and 10.200.1.0/24 network traffic. Testing the balanced tunnels I would setup iptraf on one and ping from the other. The results would be as expected; traffic would be split between the two interfaces. Testing with an ftp transfer of

Hi, I have the following setup. Two linux systems with two [test] external interfaces encrypted with ipsec [transport]. Two gre tunnels that pass 10.200.0.0/24 and 10.200.1.0/24 network traffic. Testing the balanced tunnels I would setup iptraf on one and ping from the other. The results would be as expected; traffic would be split between the two interfaces. Testing with an ftp transfer of

Hello, With setvar statements in chan_dahdi.conf, we have a convenient way to store DAHDI channels specific values. Unfortunately, we don't have a function to access this data from the dialplan as easily as SIPPEER ou IAXPEER would for SIP or IAX trunks. Using AST_CONFIG, you can access DAHDI setvar value but: 1. only one setvar value (see bellow) 2. AST_CONFIG reads values from current