similar to: Tr : how to user SIP realtime option

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:

Hi I have some question about mysql realtime. 1) Anyone know exactly if there is a specific order to declare sip table column for realtime ? In which file can I find that order ? 2) In my extconfig.conf, [settings] are : sipusers => mysql,general,siptable sippeers => mysql,general,siptable so means that I use realtime dynamic exactly ? Is it normal if some parameters from sip.conf still

Works for me.... Thanks, Hristo Benev -----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Alexandru Oniciuc Sent: Monday, May 17, 2010 6:29 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] R: new way of asterisk and kamailio(openser) realtime integration

Hello, I put together a new tutorial about asterisk realtime integration with kamailio (openser). This time the database used is the one of asterisk, also call routing logic is controlled by asterisk, here is the link: http://kb.asipto.com/asterisk:realtime:kamailio-3.0.x-asterisk-1.6.2-astdb Practically is an easier way to scale starting from existing asterisk installations. The other

Starting with Asterisk 1.2 I have always used realtime static to load my extensions.conf into Asterisk. It worked perfectly up to version 1.6.0.X but starting from 1.6.1.X and upwards it simply does nothing. I can see that the extensions.conf file is mapped to the database: == Parsing '/etc/asterisk/asterisk.conf': == Found == Parsing '/etc/asterisk/extconfig.conf': ==

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

I am currently in the process of testing out realtime support for sip.conf. I have followed all of the directions that are listed in the Wiki, but for some reason this does not work. When utilizing a flat file, I am able to register endpoints without any problems, and calls can proceed. One interesting side effect that I have noticed is that when I am using realtime for sip, I am unable to see

I have installed the CVS Head as of 12/12/04, as well as the asterisk-addons to ensure that /usr/lib/asterisk/modules/res_config_mysql.so exists. I have configured the following (after building a new DB with the appropriate SQL examples, with mods to drop the invalid keys, on the Wiki): - /etc/asterisk/res_mysql.conf [general] dbhost = 127.0.0.1 dbname = my_db dbuser = my_uname dbpass =

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?

Hello, I am currently trying to set up pjsip realtime and would like to have outbound-publish, inbound-publication, and asterisk-publication sorcery object types in ODBC realtime. Is that currently supported? I know that some object types are known working and others are not. I was curious what the status of those objects are. Thanks! Matt Hoskins | NPG Corp | Systems Architect

Is there some reason the sipbuddies table structure was designed with sip config values as column names? Doesn't look very flexible It really should take the form of ast_config so when a new sip feature is implemented, you don't have to re-write the entire data structure too. Regards Greg Cirino

Hi, I think ive found a bug but need someone to double check. Whenever I issue a "reload" in Asterisk, any realtime extensions stop receiving calls. I have to reboot the sip phones in order to get them to re-register. Can anyone see if they have a similar problem? Asterisk 1.4.32 Mysql realtime. Thanks Dan -------------- next part -------------- An HTML attachment was scrubbed...

Could someone provide some steps for troubleshooting Realtime? I can't see any signs that it's working. I followed and double-checked a few different guides around the net, but haven't been able to figure it out. -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi i am not a expert on Asterisk and search a lot of small information : I use Asterisk 1.6.1.4 with MySQL. That's work and in my extension.conf, i have: [as5300-incoming] switch => Realtime and in extconfig.conf extensions => mysql,general,VOIP_Extensions A lot of Extension are into the table VOIP_Extensions. I am search to know if i can add a :

Hi, I think I already know the answer to this question, but is there any way to do the following using realtime? Or do I have to create a full dialplan for each client without using includes? [client1_phones] include => client1_internal include => client1_outgoing_calls include => test_calls include => parkedcalls [client2_phones] include => client2_internal include =>

I'm having a few issues with the MySQL realtime configuration in CVS-HEAD. I tested it initially with realtime extensions (realtime_ext => mysql,asterisk,extensions) and a realtime switch in extensions.conf and that works fine, So I though I'd go back and test a static configuration mapping. I used the table structure from the asterisk guru postgres howto to create something

Having problems getting realtime working, I'm trying to use odbc for all of this. I've got Fedora 3 and have been fighting with odbc for a day now. I think I got it working correctly, however I can't seem to get the realtime portion working. In asterisk 'odbc show' shows it connected, I see it on my (odbc) mysql server connected and all, it connects and just idles. So, without

I have followed the instructions on voip-info.org for Realtime SIP peers, but I get this notice : [Feb 22 20:05:32] NOTICE[15298]: chan_sip.c:15889 handle_request_register: Registration from '<sip:testsip at 192.168.1.150;transport=UDP>' failed for '192.168.1.105' - No matching peer found The CLI shows : [Feb 22 19:58:23] == Parsing

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

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: