similar to: Real Time, sip.conf, [general]

Hi there It's possible configure realtime mysql in Asterisk with a non standard sippeers table? I need using a sippeers table from other system (non Asterisk). This table has a minimal configuration. Thank's Att, *Rafael dos Santos Saraiva* <http://br.linkedin.com/pub/rafael-saraiva/52/aab/230> -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hello, Asterisk Real time database worked on astersik 1.6.2.0 but now i am working on Asterisk to latest version which is 1.6.2.2 ,there is a a warning [Feb 24 16:26:14] WARNING[4053]: config.c:2025 find_engine: Realtime mapping for 'sippeers' found to engine 'mysql', but the engine is not available [Feb 24 16:26:14] NOTICE[4053]: chan_sip.c:21500 handle_request_register:

Hi all, I know I'm probably stirring up a hornet's nest with this question/comment but I've spent the last few days working on a PHP-based class for the manager interface as we're preparing for a pretty big upgrade at our call center and I'm revamping all of the management apps I've written. I can connect to the manager interface and send query strings back and forth all

Hi Andrew, OK, (the simple fact that those machines are not connected to internet makes that i have to go to those machines and copy them on a usb-stick, so it causes some delay each time...) -------- Forwarded Message -------- Sorry - I meant extconfig.conf - not cdr_mysql.conf (my mistake). I use (and done for a long time) mySQL for realtime storage - and it's never let me down (touch

I've been going in circles for a few weeks now with Realtime SIP. My extconfig.conf has: sipusers => mysql,dbname,ast_sip_users sippeers => mysql,dbname,ast_sip_users When I do a 'sip show peers' I see all my phones. When I do a 'sip show users' I only see a few of them. I can't work out why this is the case. They are also coming up with NAT as

Still a couple of questions...... I did configure extconfig.conf ... ;iaxusers => odbc,asterisk ;iaxpeers => odbc,asterisk ;sipusers => odbc,asterisk sipusers => mysql,asterisk,sip_devices sippeers => mysql,asterisk,sip_devices ;sippeers => odbc,asterisk ;sipregs => odbc,asterisk ;voicemail => odbc,asterisk ;extensions => odbc,asterisk ;meetme => mysql,general

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

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

Ok, i tried the suggestion: Instead of: sippuser => resource, database_name, table_name sippeer => resource, database_name, table_name I put in: sippuser => resource, context, table_name sippeer => resource, context, table_name Unfortunately, with the same results. btw i tried both "general" as "default" Besids the commands i tried below, isn't there any

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:

I'm getting the following message in my full log at startup and my realtime sip peers aren't being found. My realtime extensions have no errors. The table sippeers exists in the database. Is this a known problem? res_config_mysql.c: Table sippeers not found in database. This table should exist if you're using realtime.

Hi, I have 2 databases DBNAME1 and DBNAME2. In each database I have a table called sipusers (so DBNAME1.sipusers and DBNAME2.sipusers). Can I use both sipusers tables in Asterisk RealTime? Something like this: /etc/asterisk/extconfig.conf: [settings] sipusers => odbc,DBNAME1,sipusers sippeers => odbc,DBNAME1,sipusers sipusers => odbc,DBNAME2,sipusers sippeers =>

Hi, is cdr logging using odbc buggy? I'im only getting an error "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.". Connecting with isql to the datasource given in cdr_odbc.conf works just fine, and using the database for sippeers also works. The documentation[1] is confusing because it says freeTDS is required and that you must not use multiple

Hi all, I?m currently in the process of familiarizing myself with Asterisk, and am trying to move certain configuration objects (such as SIP peers) into a MySQL database, accessed by Asterisk using the ODBC connector. Now, I?ve imported the sippeers MySQL table from the contrib directory of the Asterisk source, and I could add SIP users in here. However, I currently don?t understand whether this

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

Hello all, I've been testing a Kamailio Asterisk Realtime integration, and found a strange situation. My problem is that when using the integration, everything seems ok but Asterisk does not see the clients as registered. Kamailio and the clients report registered clients. Also calls fail. In Asterisk cli sip show peers shows nothing but for example realtime load sipusers name 660 shows the

After updating to the latest CVS Feb 17 15:20:03 WARNING[15317]: config.c:819 read_config_maps: The 'sipfriends' table is obsolete, update your config to use sipusers and sippeers, though they can point to the same table. == Binding sipusers to mysql/asterisk/sip == Binding sippeers to mysql/asterisk/sip Feb 17 15:20:03 WARNING[15317]: config.c:823 read_config_maps: The

Hi, I would have expected that peers of type friend ( for example an SIP-phone) registring at Asterisk will be searched in sipusers. But the peers will be searched in sippeers. May be sombody can explain the difference? Asterisk 1.4 thanks Thomas

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

Is the template capability in sip.conf compatible with realtime sip.conf entries such as users in a database? I notice that contrib/realtime/mysql/sippeers.sql and the wiki page don't mention a template column: https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime%2C+MySQL+table+structure while some third-party examples do suggest that a column named "template" is permitted: