similar to: Application RealTime

Thanks. In app_realtime, it is very easy to get a value of a field by only applying the realtime application. However, in func_realtime, we need to get the key-value pair according to the position of it by using function CUT. After that, we need to apply another CUT to get the value. It will cause the following problems. http://www.voip-info.org/wiki/index.php?page=Asterisk+func+realtime 1.

HI, Does asterisk will ignore the setting in files if realtime is applied, say asterisk will ignore all the setting in sip.conf if realtime table sip_buddies is applied? ango

Dear all I'm writing to the list for help as a last resort. I've exhausted all other options, so please forgive me. I've lurked here for years but never actually posted. I'm trying to get Asterisk Realtime SIP configuration working, but it refuses to do so. I have all the necessary configuration in place, Asterisk makes a connection to the database, which can be verified with

Hi all, In version 1.2, there is a realtime function and it is very easy to use with prefix. exten => s,1,RealTime(table|name|peter|user_) and we can easy get back the value as user_name, user_id, etc. However, I found the the function will be depreciated in 1.4. There is a replacement using application REALTIME. I found that it is very troublesome to use it. ---------from web site---------

Hi, I use realtime and I found that changing accountcode needed to restart asterisk to activate that code and shown in CDR. Does it has a way to update accountcode without restart asterisk? ango

Hi, The server log shows the following message. [Jan 29 04:59:02] WARNING[1896] config.c: Realtime mapping for 'sippeers' found to engine 'mysql', but the engine is not available Does it mean the server failed to file the mysql server? I have installed mysql and both asterisk and mysql are located in the same server. What do the message mean? It seems the message will cause

Hi all, I am looking for a prepaid application. I found that there are many applications in the page http://www.voip-info.org/wiki/view/Asterisk+Prepaid+Applications. Anyone recommendation among them? ango

Hi All, I'm testing some realtime extension apps with Asterisk 1.4.28 and addons 1.4.10 using res_mysql. Localhost database is 5.0.32 with Debian Etch. The apps are working fine all syntax is proper, using Set with (REALTIME) function, Set with (CUT) function, calling a Macro with s extensions, and using a few pattern matching extensions as well. I can certainly detail all database rows if

We are hosting multiple companies with Asterisk. For a high degree of control, each company has many contexts that are included from a main context. I had wanted to use realtime, but realised very soon that it didn't scale. For each context that you put a realtime switch statement in, Asterisk has to go and query the database. If you include 10 contexts, and each one of those has a realtime

I enabled the logs on the mysql database and ran : realtime load queues name cou0002-test in the mysql log I can see that the proper select statement is being executed: 2018-12-04T16:29:27.253094Z 229 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 2018-12-04T16:29:27.254384Z 229 Prepare SELECT * FROM queues WHERE name = ? 2018-12-04T16:29:27.254902Z 229

Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of "how to" of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime:

Hello Everyone! According to voip-info.org the correcy syntax for the realtime function is: REALTIME(family|fieldmatch[|value[|delim1[|delim2]]]) on read REALTIME(family|fieldmatch|value|field) on write It seems from the syntax that it is only possible to retrieve a full row according to the value of only of column. This translates in SQL language as Select * from family where fieldmath =

Hi, I'm having 2 problems: 1) MOH in realtime is not working, I have configured it but never go to look at the database, no warning or error found and I can do a query using realtime and the family from the cli. 2) I have SIP phones via realtime, if I register one of them and a call to a queue comes the call is never delivered to the phone, I have to make a call from the

Hi all, I have a TDM400 with all FXO on it. When I make an outgoing call, I can hear callee but callee claims the volume is too low so that he/she can't hear very clear. Can I adjust to increase the volume in callee side? Is it increase the value of txgain can solve the problem? ango

Hi all, Is it possible to install more than 1 asterisk in a single server? If yes, what do I need to set and take care? Rgds, ango

Trying to use realtime sip for the first time, and it's not working as expected. I have one user entry in the sip database. Everthing else is still in sip.conf. When I get an incoming call, this is the database query: SELECT * FROM ast_home_sip_realtime WHERE name = '+18003859169' The 800# is the caller id of the caller, which doesnt' make any sense to me. Is there any

I'm confused about SIP realtime updates. If I make a database change, and then do a "sip prune realtime peer <peer>", I can see Asterisk query the database, and retrieve the updated information. However, it still uses the old values. What's up with that? If I do a "reload", Asterisk queries the database and this time uses the new values. I have

Hi I am facing an issue where asterisk cannot see the queues that exist in my database through realtime. I am using res_odbc and a local mysql database. If I run: realtime load queues name myqueue I get "No rows found matching search criteria.", however if I do the same for a peer: realtime load sippeers name Then I get a result. Since my queues table is in the same database as my

Thanks Joshua, I assume by query asterisk you mean I'll need to query it via AMI? Is that information available via AMI? *Nick Olsen* Network Engineer Office: 321-408-5000 x103 Mobile: 321-794-0763 On Tue, May 26, 2020 at 2:57 PM Joshua C. Colp <jcolp at sangoma.com> wrote: > On Tue, May 26, 2020 at 10:48 AM Nick Olsen < > nick at floridavirtualsolutions.com> wrote: >

Sunny wrote: > Hello, > > > In Asterisk 11 it is possible to set extensions on DB table (sipppers) > and also in sip.conf. > > But in Asterisk 13 apparently this is not possible: as I tried to set in > ps_endpoints and also in pjsip.conf but only the realtime endpoints are > loaded. > > Is there a way to use realtime + static modes at the same time for the >