search for: res_config_pgsql

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 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime Password: [Nov 28 20:12:02]...

...e 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]: res_config_pgsql.c:207 realtime_pgsql: Postgresql RealTime: Could not find any rows in table extensions_conf. [Feb 17 12:32:50] WARNING[604]: res_config_pgsql.c:207 realtime_pgsql: Postgresql RealTime: Could not find any rows in table sip_conf. [Feb 17 12:32:50] WARNING[604]: res_config_pgsql.c:207 realtime_pgsql:...

...3 13:29:14] WARNING[7477]: res_smdi.c:1335 load_module: No SMDI interfaces are available to listen on, not starting SMDI listener. .[May 3 13:29:14] NOTICE[7477]: config.c:1274 ast_config_engine_register: Registered Config Engine odbc . Loading [Sub]Agent Module .[May 3 13:29:14] WARNING[7477]: res_config_pgsql.c:683 parse_config: Postgresql RealTime: No database user found, using 'asterisk' as default. [May 3 13:29:14] WARNING[7477]: res_config_pgsql.c:691 parse_config: Postgresql RealTime: No database password found, using 'asterisk' as default. [May 3 13:29:14] WARNING[7477]: res_conf...

...AST-2007-025 +------------------------------------------------------------------------+ | Product | Asterisk | |----------------------+-------------------------------------------------| | Summary | SQL Injection issue in res_config_pgsql | |----------------------+-------------------------------------------------| | Nature of Advisory | SQL Injection | |----------------------+-------------------------------------------------| | Susceptibility | Remote Unauthenticated Sess...

...AST-2007-025 +------------------------------------------------------------------------+ | Product | Asterisk | |----------------------+-------------------------------------------------| | Summary | SQL Injection issue in res_config_pgsql | |----------------------+-------------------------------------------------| | Nature of Advisory | SQL Injection | |----------------------+-------------------------------------------------| | Susceptibility | Remote Unauthenticated Sess...

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

Hi, I am a beginner who began to use Asterisk in this July. Last week, I made two addons for PostgreSQL (cdr_addon_postgresql.c and res_config_postgresql.c), because I use not usual MySQL but PostgreSQL. # Of course, not scratch build but modified version 1.4.8. But I don't know how to change configure script, menuselect-xxx, ... etc, and how to merge my sources to addons tar-balls. Anyone

...: Cannot load LDAP RealTime driver. [Jan 14 17:47:00] NOTICE[16133] config.c: Registered Config Engine odbc [Jan 14 17:47:00] WARNING[16133] res_config_curl.c: [globals] not found in res_curl.conf [Jan 14 17:47:00] NOTICE[16133] config.c: Registered Config Engine curl [Jan 14 17:47:00] ERROR[16133] res_config_pgsql.c: PostgreSQL RealTime: Failed to connect database asterisk on 127.0.0.1: [Jan 14 17:47:00] WARNING[16133] res_config_pgsql.c: PostgreSQL RealTime: Couldn't establish connection. Check debug. [Jan 14 17:47:00] NOTICE[16133] config.c: Registered Config Engine pgsql [Jan 14 17:47:01] WARNING[161...

...5ae4fe] ======= Memory map: ======== 00111000-00118000 r-xp 00000000 03:01 5330798 /usr/lib/asterisk/modules/res_musiconhold.so 00118000-00119000 rwxp 00007000 03:01 5330798 /usr/lib/asterisk/modules/res_musiconhold.so 00119000-0011f000 r-xp 00000000 03:01 5330792 /usr/lib/asterisk/modules/res_config_pgsql.so 0011f000-00120000 rwxp 00005000 03:01 5330792 /usr/lib/asterisk/modules/res_config_pgsql.so 00120000-00218000 r-xp 00000000 03:01 196501 /opt/lumenvox/engine_6.5/lib/libcrypto.so.0.9.7f 00218000-0022a000 rwxp 000f8000 03:01 196501 /opt/lumenvox/engine_6.5/lib/libcrypto.so.0.9.7f 0022a...

Dear The Expert, I am very new with this, I have installed AsteriskNow, X-Lite as my SoftPhone, I am using SPA-3102. I have 3 extensions, me at 250, 998 is my Linksys SPA-3102 and 999 for PSTN Line (see below) My problem is, I am unable to call 998, I thought this is registration problem, (because the Linksys screen info said Registration Failed) Could any body please help? Many thanks in

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

...BUILD_NATIVE --enable DEBUG_THREADS --enable DONT_OPTIMIZE --disable CORE-SOUNDS-EN-GSM --disable-category MENUSELECT_EXTRA_SOUNDS --disable MOH-OPSOUND-WAV --enable-category MENUSELECT_ADDONS --disable format_mp3 --disable cdr_tds --disable cel_tds --disable cdr_pgsql --disable cel_pgsql --disable res_config_pgsql menuselect.makeopts under kernel 2.6.32-504.el6.x86_64, and linked against the following library versions: /usr/lib64/libssl.so.10: symbolic link to `libssl.so.1.0.1e' /usr/lib64/libcrypto.so.10: symbolic link to `libcrypto.so.1.0.1e' /lib64/libc.so.6: symbolic link to `libc-...

...ou have only priorities 1, 2, ; and 4, then 4 will be ignored, because there is no 3). > ; > ; "odbc" is shown in the examples below, but is not the only valid realtime ; engine. There is: > ; odbc ... res_config_odbc > ; sqlite ... res_config_sqlite > ; pgsql ... res_config_pgsql > ; curl ... res_config_curl > ; ldap ... res_config_ldap > ; > ;iaxusers => odbc,asterisk > ;iaxpeers => odbc,asterisk > ;sipusers => odbc,asterisk > ;sipusers => mysql,asterisk,sip_devices > ;sippeers => mysql,asterisk,sip_devices > ;sipusers =>...

The Asterisk.org development team has released Asterisk versions 1.4.15 and 1.2.25. These releases contain two fixes for security issues. http://downloads.digium.com/pub/asa/AST-2007-025.pdf * This is a SQL injection vulnerability in the res_config_pgsql module. Default installations of Asterisk are not affected. However, any system using the Postgres Realtime Engine may be remotely exploitable. This issue only affects Asterisk 1.4, as this module was not in Asterisk 1.2. http://downloads.digium.com/pub/asa/AST-2007-026.pdf * This is another SQ...

The Asterisk.org development team has released Asterisk versions 1.4.15 and 1.2.25. These releases contain two fixes for security issues. http://downloads.digium.com/pub/asa/AST-2007-025.pdf * This is a SQL injection vulnerability in the res_config_pgsql module. Default installations of Asterisk are not affected. However, any system using the Postgres Realtime Engine may be remotely exploitable. This issue only affects Asterisk 1.4, as this module was not in Asterisk 1.2. http://downloads.digium.com/pub/asa/AST-2007-026.pdf * This is another SQ...

Hello. I'm testing the new Asterisk 1.6 beta 5. I'm using realtime to store extensions and sip users. When a user logs on, everything works fine - calls are also fine. But I keep getting these in the console: [Mar 9 16:31:58] WARNING[10284]: res_config_pgsql.c:195 realtime_pgsql: PostgreSQL RealTime: Could not find any rows in table sip_users. Full log: http://rafb.net/p/LO7DEM95.html I think this part is a bit wierd: Query: SELECT * FROM sip_users WHERE name = '' Is this a bug or a known problem? I don't know where to even begin looking...

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

...s (Reported by George Joseph) * ASTERISK-7803 - [patch] Update the maximum packetization values in frame.c (Reported by dea) * ASTERISK-25461 - Nested dialplan #includes don't work as expected. (Reported by Richard Mudgett) * ASTERISK-25455 - Deadlock of PJSIP realtime over res_config_pgsql (Reported by mdu113) * ASTERISK-25135 - [patch]RTP Timeout hangup cause code missing (Reported by Olle Johansson) * ASTERISK-25400 - Hints broken when "CustomPresence" doesn't exist in AstDB (Reported by Andrew Nagy) * ASTERISK-25443 - [patch]IPv6 - Potential issue in...

...TICE[17727] config.c: Registered Config Engine odbc [May 11 09:02:57] NOTICE[17727] cdr.c: CDR simple logging enabled. *Loader.c again!*May 11 09:02:57] NOTICE[17727*] loader.c: 154 modules will be loaded.* *I have my realtime peers with MySQL not Postgresql, but...* May 11 09:02:57] ERROR[17727] res_config_pgsql.c: Postgresql RealTime: Failed to connect database server asterisk on . Check debug for more info. [May 11 09:02:57] NOTICE[17727] config.c: Registered Config Engine pgsql [May 11 09:02:58] NOTICE[17727] config.c: Registered Config Engine mysql [May 11 09:02:58] NOTICE[17727] app_queue.c: Queue mem...

Hello I'm using a standard Asterisk install with default settings, and when I run "reload", I see that Asterisk fetches configuration information from a lot more sources than just my extensions.conf and sip.conf. For instance: -- Registered indication country 've' -- Registered indication country 'za' -- Setting default indication country to