similar to: realtime excessive database queries

>From the viewpoint of being reliable and scaleable, I'm wondering what using realtime would really get me. Given the number of additional things that can go wrong using realtime, I'm thinking about just using the standard text config files and pushing them to the asterisk servers via scp from a configuration server. I've also thought about keeping the configs in a database but

I''m currently trying to optimize a linux machine which acts as a Layer 3 router of RTP H.263 video. Occassionally I''ll get delays related to layer 2 wireless retries, thus rendering the video on the recieving end stale/useless. Is there way to optimize a linux machine to route realtime video? In my case, losing a few frames of H.263 is better than having the video delayed

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

All, I get this whenever trying to dial to a peer when the peer registered to another server. I'm basically trying to use realtime to check for the peer and dial it. Mar 24 09:16:47 VERBOSE[4527]: -- Executing Dial("SIP/brak-f69f", "IAX2/brak-test/107") in new stack Mar 24 09:16:47 DEBUG[4527]: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_users WHERE name =

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 list, yesterday I converted my voicemail.conf to realtime voicemail and also configured to store the voicemessages in a database using odbc as described here <http://www.voip-info.org/wiki/view/Asterisk+RealTime+Voicemail> and here <http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage>. I am using asterisk 1.4.2 with mysql. I also installed the proper odbc driver for

Is there any official structure for the tables for doing realtime sip and extensions ? I see there's a big (big in lot's of fields) on http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime+Sip and I've seen other partial tables in other places. Thanks. -- Jos? Pablo Ezequiel Fern?ndez

Hiya, Today I note there are 38 imap-logins that seem to be stale on our staff imap server, they do not seem to die off, new imap-logins are created with new logins and exit accordingly. Now, these are from our monitoring software that runs on another server on our LAN. Our corporate link was taken down for 2 hours for urgent relocation of fibre (demolishing old adjoining building, and just in

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

Hello, I was wondering if there is a tool that can create the realtime database structure for latest Asterisk version or a web resource/file containing the sql scripts. Hope I haven't missed obvious things, I had no luck searching on the web, in the wiki I found few pages with bits of sql or table structures, like:

On the wiki it say's that if you use the Goto commands you need to replace ',' with '|' in the app data field. But in the examples it uses '|' in place of ',' in the Dial command also in a couple of places. Is it safe to replace ',' with '|' everywhere in the app data field when using realtime? Or should I still to substituting ','

Hi, Please take a look at the following extensions.conf:- exten => _11XXXX,1,NoCDR() exten => _11XXXX,2,Dial(SIP/${EXTEN},10) exten => _11XXXX,3,VoiceMail() I'm already using realtime for some extensions/users/voicemail. Is there any way to do the following at point 3?:- Lookup the realtime users db and read the MailBox column for that buddy. If the mailbox column is empty, play

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

Does anyone know if realtime extensions allows extensions in the format callerid/extension yet? ie the extensions.conf file allows you to do: 5551212/1000 => exten ... and it matches against extension 1000 when the caller id is 5551212. Last time I checked, realtime didn't support this yet. That's a show stopper for us. -------------- next part -------------- An HTML

Ok I'm a little confused about realtime static. The wiki has the database schema but no explanation of what fields are for what. I would appreciate if someone can confirm or deny how I think the schema works. cat_metric = sort order for category var_metric = sort order for vars filename = equivalent .conf file in /etc/asterisk category = anything that would be enclosed in braces ([])

Hi, I don't explain very well what my problem, but i can't make calls. i analise my log full and i found two errors Jul 3 19:02:08 ERROR[4670] res_config_mysql.c: MySQL RealTime: Failed to connect database server on (err 2002). Check debug for more info. Jul 3 19:02:08 VERBOSE[4670] logger.c: -- Added extension 'exit-FAILED' priority 1 to macro-vm Jul 3 19:02:08

Hi If we have a shared RealTime database for sip registration of multiple Asterisk servers, is there a way to realize which Asterisk server registered sip phones ? RegardsM.Shirazi? -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20150817/62c5cd3c/attachment.html>

Hello everybody, I'd like to hear some success stories about the use of Asterisk Realtime in medium-large contexts, like > 50 extensions. Don't you think that in those contexts the system could be overloaded from the excessive number of queries to the DB? So.. is anybody using ARA in those kind of deployments? Thanks in advance, -- Andrea Spadaccini Multimedia Technologies

Hello, Right now there is not a table build script at: http://www.voip-info.org/wiki-Asterisk+RealTime+IAX Therefore I have taken the SIP build script and added a few fields that I use from my iax.conf (could be more out there, please see the complete build script below): `dbsecret` varchar(100) default '', `notransfer` varchar(100) default '', `inkeys` varchar(100)

Hi all, Is there any native way to save endpoint statuses to database? I use asterisk 13 with pjsip and realtime, and didn't found proper way. I read that there is config parameter in sip.conf: rtupdate=yes. But how can I do that with pjsip? Or I should use sip.conf with pjsip simultaneously. Or is there any kind of hooks, which allows make custom action on endpoint status change. Thanks.