similar to: Connecting to multiple databases using res_config_pgsql

Hi I have an installation based on Daniel-Constantin Mierla's excellent Kamailio 3.3 / Asterisk 10 Realtime document ( http://kb.asipto.com/asterisk:realtime:kamailio-3.3.x-asterisk-10.7.0-astdb) but have come across an issue which is a potential problem. In this installation all SIP clients register with Kamailio, and the registrations are forwarded to Asterisk. This means that all

Hello, I am moving from realtime chan_sip to pjsip and one of the problem I am facing is the lack of "sipregs". With chan_sip, when an extension registers, the server where it has registered to is stored in sipregs. Is there something similar in pjsip? How can I find on which server the pjsip extension has registered to? Leandro -------------- next part -------------- An HTML

Database on a remote machine res_pgsql.conf: [general] dbhost=172.16.0.2 dbport=5432 dbname=ast_config dbuser=pbx dbpass= dbsock=5432 [Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime Host: 172.16.0.2 [Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime Port: 5432 [Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime User: pbx [Nov 28

I would like to access a Postgresql database directly from my dialplan (to lookup names based on callerid numbers for incoming calls). Based on everywhere I looked - it seems the only way to do this is with func_odbc. Considering that Asterisk seems to be able to access Postgresql databases directly using res_pgsql for the purposes of realtime functionality (without using odbc - if I

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 all I have a strange issue with 1.8.11.0 on a production Asterisk machine at our head office, and the same issue with a production machine at a branch office. Every now and then, on the head office machine, ODBC CEL and CDR logging will stop working. On examination in the CLI, Asterisk behaves as if the config files for ODBC in the /etc directory are just gone. Repeated tests have then

Hello I just settup a realtime mysql table for sip_peers. All peers (friends) is autenticateing but when i want to initiate a call between them i got the following error. Someone have some ideea? Thank you. ---<Cut Here>--- pbx*CLI>console dial 1014 == Console is full duplex -- Executing [1014@default:1] Dial("OSS/dsp", "SIP/1014|40|t") in new stack

The Asterisk Development Team has announced the release of Asterisk 1.4.37. This release is available for immediate download at http://downloads.asterisk.org/pub/telephony/asterisk/ The release of Asterisk 1.4.37 resolves several issues reported by the community and would have not been possible without your participation. Thank you! The following is a sample of the issues resolved in this

The Asterisk Development Team has announced the release of Asterisk 1.4.37. This release is available for immediate download at http://downloads.asterisk.org/pub/telephony/asterisk/ The release of Asterisk 1.4.37 resolves several issues reported by the community and would have not been possible without your participation. Thank you! The following is a sample of the issues resolved in this

Still a couple of questions...... I did configure extconfig.conf ... ;iaxusers => odbc,asterisk ;iaxpeers => odbc,asterisk ;sipusers => odbc,asterisk sipusers => mysql,asterisk,sip_devices sippeers => mysql,asterisk,sip_devices ;sippeers => odbc,asterisk ;sipregs => odbc,asterisk ;voicemail => odbc,asterisk ;extensions => odbc,asterisk ;meetme => mysql,general

The Asterisk Development Team has announced the release of Asterisk 11.23.0. This release is available for immediate download at http://downloads.asterisk.org/pub/telephony/asterisk The release of Asterisk 11.23.0 resolves several issues reported by the community and would have not been possible without your participation. Thank you! The following are the issues resolved in this release: Bugs

Hi all, A week or so down the list, i read that not many people were using realtime on an Asterisk18, so i had this afternoon a go at it... [sorry for the inconveneant line-wraps] First i did: mysql> create database asterisk; mysql> grant all on asterisk.* to 'voipadmin'@'localhost' identified by next i used the info from the wiki: CREATE TABLE `sip_devices` ( `id`

The Asterisk Development Team has announced the release of Asterisk 13.9.0. This release is available for immediate download at http://downloads.asterisk.org/pub/telephony/asterisk The release of Asterisk 13.9.0 resolves several issues reported by the community and would have not been possible without your participation. Thank you! The following are the issues resolved in this release: Bugs

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

Asterisk Project Security Advisory - AST-2007-025 +------------------------------------------------------------------------+ | Product | Asterisk | |----------------------+-------------------------------------------------| | Summary | SQL Injection issue in res_config_pgsql |

Asterisk Project Security Advisory - AST-2007-025 +------------------------------------------------------------------------+ | Product | Asterisk | |----------------------+-------------------------------------------------| | Summary | SQL Injection issue in res_config_pgsql |

Oh heck. It really looks like realtime has been seriously screwed up. When a call comes in to Asterisk, I can see asterisk executing these queries. SELECT * FROM ast_sip_peers WHERE host = '2XX.YYY.142.205' SELECT * FROM ast_sip_peers WHERE name = '2944093' SELECT * FROM ast_sip_peers WHERE name = '2944093' So, the first thing it does is check and see if there are any

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

Are these both caller id presentation related? If not, which on is currently being used. Finally, is there a "latest" sip_peers table structure to use with 1.8, without the obvious hacks, deprecations. and redundancies? Thanks in Advance, Nick.

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 --