similar to: REALTIME and VIEW ENTIRE DIALPLAN

Hi All, I'm upgrading some PBX's from 1.2 to 1.4 and having a bit of trouble with converting the Realtime application to the REALTIME function. I have the method down and understand simplistically what is going on, at least enough to get my old 1.2 apps to run in 1.4 functions. I do not understand why change from the app to the func? What the benefits? To me, the app seemed so

Hello, I'm using Asterisk with Realtime extensions and ODBC CDR. And I'm have some trouble with the CDR userfield that is not changed when using the SET command in the realtime dialplan. In my dialplan (extensions.conf, the file) I'm setting the userfield like this : exten => s,n,Set(CDR(userfield)="X") Later, my dialplan switches to the realtime part and this is an

Hallo all! Know somebody, if exist Dialplan commands (specifically sql sentences) for Asterisk Realtime? For example: I have users defined in mysql database. In the dialplan, I would like to select one field of a table. select email from sip_buddies where name=200 I try to use DBget, but I have error. I think because DBget use intern Database, and can 't connect to mysql. (Sintaxis:

Hello, So much keeps changing with the dialplan and Realtime lookups. Just downloaded the latest stable 1.6.1.2. The app_realtime, which was perfectly brilliant and did exactly what I needed, is gone; replaced with func_realtime. The REALTIME function is unacceptable: ; Get the conference number from the user exten => s,n(readconfno),Read(USER_CONFNO,conf-getconfno,0,3,20) ; See if

I am trying to find where the authoritative sql definitions for Asterisk Realtime Architecture ARA are located. I have found many locations but each and everyone seems to be different. http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html/asterisk-book.html http://www.open-voip.org/index.php?title=Asterisk_Full_RealTime_example Files included with the distribution:

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

I am using the current HEAD of asterisk and for asterisk-addons. I have been trying to setup realtime mysql voicemail but no sucess. I keep getting this error below. The necessary modules are loaded, res_config_mysql.so ... Any pointers will help. Thanks mail*CLI> realtime mysql status Aug 24 00:56:50 ERROR[963]: res_config_mysql.c:596 mysql_reconnect: MySQL RealTime: Failed to connect

Excellent. I was using ast-13.1.0 with no luck. I upgraded to 13.2.0 and have made it further, but am having a little difficulty. The outbound-publish object types seems to be working in realtime now. But the asterisk-publication object is only reading from sorcery.conf. I know you said that it *should* work, with no guarantee, which I'm fine with. I just want to make sure I don't

I have a pjsip install that is not pulling it's realtime registrations from an ODBC database. When I have them directly pull from a MySQL database everything seems to work. I am having trouble finding a requirements document for the pjsip realtime registrations. Is there some kind of special config that has to be used to trigger the connection for realtime registrations over ODBC?

Hi there asterisk goes to 90% cpu usage when trying to authenticate a sip friend using realtime mysql, no other message does appear at cli and asterisk hungs; here some info: *CLI> realtime load sipfriends name 104 Jan 13 11:52:21 DEBUG[8928]: res_config_mysql.c:109 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sipfriends WHERE name = '104' Jan 13 11:52:21 DEBUG[8928]:

Hi, After seeing in "pbx/ael/ael-test/ael-test5/extensions.ael" some interesting use case of RealTime to store extension data (forwardto, dnd, ...) i started to play with it. To my surprise the two applications RealTime() / RealtimeUpdate() have been deprecated in favor of the REALTIME() function. While it's not a big deal for the write part since it's only a matter a shifting

Hi, I'm having some problem with realtime: let's say I have a dialplan like this [globals] IPPHONES=_3XX [sip] exten=>${IPPHONES},1,Answer A call from ip phone 300 comes in, and it's been answered. Then I "switch" the sip context to realtime, putting the exten in the db and using the variable name for this as in the file version. [globals] IPPHONES=_3XX [sip]

Hi, The asterisk wiki page says: "Sorcery.conf allows you to try to configure other PJSIP objects such as transport using realtime and it currently won't stop you from doing so. However, some of these object types should not be used with realtime and this can lead to errant behavior." Which objects and is this still true in 1.13.1 ? Thanks, Antonio. PS:

Hi - I'm looking into realtime and I'm having a bit of a problem with the SIP part. My review of the posts seems to indicate that I should use realtime static for the [general] part of my sip.conf including the registration commands: register=><did>:<secret>@<domain>/<did context> and use realtime realtime (funny name!) for peers and friends: [myprovider]

Hi - I'm looking into realtime and I'm having a bit of a problem with the SIP part. My review of the posts seems to indicate that I should use realtime static for the [general] part of my sip.conf including the registration commands: register=><did>:<secret>@<domain>/<did context> and use realtime realtime (funny name!) for peers and friends: [myprovider]

Hello all, I recently noticed the realTime effort and must say it is a nice idea! I would appreciate any help to get it running .. I downloaded the code & patches and succefully patched my asterisk (CVS-HEAD-11/29/04-12). - created a DB called asterisk, and a table sip using the schema supplied at http://bugs.digium.com/bug_view_page.php?bug_id=0002613. - entered an entry: insert into

Hello, I have a default installation of asterisk 1.6.1.9-2 When i create a user in users.conf via asterisk-gui, calls, voicemail etc works. But if i create a user realtime (and my realtime caching is available too) i can see the realtime user with sip show peers. But, my local dial rules does not work. I can call from realtime user to static users(the ones in users.conf) and if they are not

I am a fairly novice Asterisk 1.4 user who used to use CallWeaver, based on asterisk 1.2. I used Realtime MySQL with CallWeaver and am currently using the very same MYSQL tables (and columns) with Asterisk 1.4.11 and things are working well. The questions I have are, since new configuration variables have been added into Asterisk 1.4, can I simply add columns in my MySQL sippeers table for

On 15-10-04 09:54 AM, Bryant Zimmerman wrote: > I have a pjsip install that is not pulling it's realtime registrations > from an ODBC database. > When I have them directly pull from a MySQL database everything seems to > work. > I am having trouble finding a requirements document for the pjsip > realtime registrations. > Is there some kind of special config that has to be

Hi, Realtime SIP and Extensions are working fine but facing some problems with Voicemail. Added an entry to extconfig.conf voicemail => mysql,asterisk,voicemail_users Created the corresponding table and an entry for mailbox 201. This is also reflected in the CLI as shown below. CLI> realtime load voicemail mailbox 201 Column Name Column Value