Re: [asterisk-users] Realtime Mysql
On 27/09/13 17:47, Phibee Network Operation Center wrote: Hello, I am looking to know if it is possible to modify the SQL query that is on Realtime sip accounts. I want multiple servers use the same sql table, so getting an extra server field to indicate that the data is valid on the X server is this possible? thank you in advance jerome I dont know but you should be able to at least create multiple mysql views with each one being referenced by the appropiate server. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] realtime mysql for 1.8
On Wednesday 06 April 2011 14:53:00 Hans Witvliet wrote: I'm going to have a go with realtime mysql. Just wondering, most examples i came across while googling, was with 1.6 systems. So any drastic changes with 1.8.3, table-layout? other pitfalls? This isn't a pitfall that comes with the upgrade, but you should set wait_timeout internal to the MySQL server to 864000 or higher. This will prevent a number of mysterious crashes that are otherwise possible (and difficult to diagnose) with the threaded MySQL client driver. This is the case, whether you use the native res_config_mysql or the abstract res_config_odbc driver. The usual symptom of this problem is that Asterisk crashes on the first call of the day on Monday morning and then is fine (either for the rest of the week, or until the next morning, depending upon how active calls are on your system). -- Tilghman -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] realtime mysql for 1.8
On 11-04-06 03:53 PM, Hans Witvliet wrote: I'm going to have a go with realtime mysql. Just wondering, most examples i came across while googling, was with 1.6 systems. So any drastic changes with 1.8.3, table-layout? other pitfalls? I suggest using res_odbc, it has better support. Aside from that, I've been testing it with 1.8 for a while; under light load (less then 5 channels). I have not had a problem. -- Paul Belanger Digium, Inc. | Software Developer twitter: pabelanger | IRC: pabelanger (Freenode) Check us out at: http://digium.com http://asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] realtime mysql for 1.8
On 11-04-06 03:53 PM, Hans Witvliet wrote: I'm going to have a go with realtime mysql. Just wondering, most examples i came across while googling, was with 1.6 systems. So any drastic changes with 1.8.3, table-layout? other pitfalls? The tables migrate just fine, but you can update them to the newer terms (like directmedia instead of canreinvite). Not all of the configuration options are found in the contributed SQL table definitions, and columns that aren't recognized are ignored (nice for a comment, etc). As far as pitfalls, there have been a few deadlock issues for SIP with Realtime. Most that I have run into have been resolved, but check out issue 18818 if you use any local channels (there is a patch, but the issue hasn't been assigned yet). I don't think realtime has as wide as an audience, so the issues are a little slower to get resolved in SVN / releases. Those that use it are pretty active in helping confirm issues and testing patches though. On Wed, Apr 6, 2011 at 1:32 PM, Paul Belanger pabelan...@digium.com wrote: I suggest using res_odbc, it has better support. Aside from that, I've been testing it with 1.8 for a while; under light load (less then 5 channels). I have not had a problem. +1 for res_odbc -Jonathan -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] realtime mysql for 1.8
On Wed, 2011-04-06 at 13:57 -0700, Jonathan Thurman wrote: On 11-04-06 03:53 PM, Hans Witvliet wrote: I'm going to have a go with realtime mysql. Just wondering, most examples i came across while googling, was with 1.6 systems. So any drastic changes with 1.8.3, table-layout? other pitfalls? The tables migrate just fine, but you can update them to the newer terms (like directmedia instead of canreinvite). Not all of the configuration options are found in the contributed SQL table definitions, and columns that aren't recognized are ignored (nice for a comment, etc). As far as pitfalls, there have been a few deadlock issues for SIP with Realtime. Most that I have run into have been resolved, but check out issue 18818 if you use any local channels (there is a patch, but the issue hasn't been assigned yet). I don't think realtime has as wide as an audience, so the issues are a little slower to get resolved in SVN / releases. Those that use it are pretty active in helping confirm issues and testing patches though. On Wed, Apr 6, 2011 at 1:32 PM, Paul Belanger pabelan...@digium.com wrote: I suggest using res_odbc, it has better support. Aside from that, I've been testing it with 1.8 for a while; under light load (less then 5 channels). I have not had a problem. +1 for res_odbc -Jonathan -- _ Ok, tnx for the feedback. I think i have to stick with mysql, as info is coming from other applications, but perhaps some of the other code can be tweaked. mysql is nice (lots of tiny programs writen for it), but i'm not religious attached to it ;-) The amount of concurent calls will be small, but the amount of pre-defined users is fair (75K) So perhaps i should consider a mix of ldap and a DB. Hans -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] realtime mysql for 1.8
On Wed, Apr 6, 2011 at 2:59 PM, Hans Witvliet h...@a-domani.nl wrote: [snip] I think i have to stick with mysql, as info is coming from other applications, but perhaps some of the other code can be tweaked. mysql is nice (lots of tiny programs writen for it), but i'm not religious attached to it ;-) I should have been more clear. res_odbc has better support in Asterisk. We use MySQL as our back-end database. One benefit of using ODBC connectors is that you don't have to be religiously attached to the back-end. The SQL code in Asterisk is generic, and you could swap out for PostgreSQL or anything else that there is a ODBC connector for. The amount of concurent calls will be small, but the amount of pre-defined users is fair (75K) So perhaps i should consider a mix of ldap and a DB. While we don't have that many users defined on any one system, I would test both independently. Both together sounds complex to troubleshoot when something breaks... -Jonathan -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime MySQL - Asterisk 1.8.2
On Thu, 2011-02-17 at 11:28 -0200, Rodrigo Lang wrote: Hi to all. I make some tests with Asterisk 1.8.2 in Realtime. But i have one problem, the asterisk don't connect in the base and show this message: [Feb 17 11:18:01] WARNING[19061]: res_config_mysql.c:441 realtime_multi_mysql: MySQL RealTime: Invalid database specified: 'asterisk_teste' (check res_mysql.conf) I checked the asterisk config file (res_mysql.conf) and the configuration is ok. My configuration of table and extconfig.conf is the same of the version 1.6.0. The cdr use the same base, same user/pass, and his save the registers ok. This is happening to the queues, queues_members, muscionhold and queue_log in Realtime (That's is all the modules i use in Realtime). I tested the base and the MySQL and is working ok. I appreciate in advance any help, -- Rodrigo Lang Opening your mind - Just another Open Source site The res_mysql.conf format changed from 1.6 to 1.8 The config now goes in in the following format [db-name] dbhost = x.x.x.x dbname = db-name dbuser = db-user dbpass = db-pass dbport = 3306 Is this how yours is set up? -- Ishfaq Malik Software Developer PackNet Ltd Office: 0161 660 3062 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime MySQL - Asterisk 1.8.2
2011/2/17 Ishfaq Malik i...@pack-net.co.uk On Thu, 2011-02-17 at 11:28 -0200, Rodrigo Lang wrote: Hi to all. I make some tests with Asterisk 1.8.2 in Realtime. But i have one problem, the asterisk don't connect in the base and show this message: [Feb 17 11:18:01] WARNING[19061]: res_config_mysql.c:441 realtime_multi_mysql: MySQL RealTime: Invalid database specified: 'asterisk_teste' (check res_mysql.conf) I checked the asterisk config file (res_mysql.conf) and the configuration is ok. My configuration of table and extconfig.conf is the same of the version 1.6.0. The cdr use the same base, same user/pass, and his save the registers ok. This is happening to the queues, queues_members, muscionhold and queue_log in Realtime (That's is all the modules i use in Realtime). I tested the base and the MySQL and is working ok. I appreciate in advance any help, -- Rodrigo Lang Opening your mind - Just another Open Source site The res_mysql.conf format changed from 1.6 to 1.8 The config now goes in in the following format [db-name] dbhost = x.x.x.x dbname = db-name dbuser = db-user dbpass = db-pass dbport = 3306 Is this how yours is set up? Thanks a lot, i solved the problem. First, the WARNING about 'res_mysql.conf', but the file now is 'res_config_mysql.conf'. Second, i changed the '[generals]' to the name of my database. Worked ok! Thanks again! -- Rodrigo Lang Opening your mind - Just another Open Source sitehttp://openingyourmind.wordpress.com/ -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime mysql extensions mutiple queries for each priority?
JR Richardson wrote: On Monday 28 December 2009 23:49:13 Tilghman Lesher wrote: On Monday 28 December 2009 18:09:15 JR Richardson wrote: I turned on console debug to see the actual mysql queries and to my surprise and concern, I see every query for an extension priority repeated 3 or more times prior to dialplan execution. For instance my first dialplan activity is all extracted from the database: context exten pri app appdata dpdefault14 _991X 1 NoOpINBOUND CALL FROM SIPP dpdefault14 _991X 2 NoOpTRUNK-${EXTEN:0:2} DID-${EXTEN:2} dpdefault14 _991X 3 Set CALLERID(number)=600 dpdefault14 _991X 4 Answer dpdefault14 _991X 5 Goto${EXTEN:2}|1 Each priority is queried several times before executing. Here is a sample of the first 2 priorities on a pastebin: http://pastebin.com/m54c9c41e I would not think this is normal activity as I can query the database directly once and get a valid response. I don't have any realtime mysql connections issues that I can see, no errors in the logs and console status is: No, that's normal. The order of queries done is 1) check if the extension exists, 2) on spawn, retrieve the extension to populate information about the application into the channel structure, and 3) actually execute the application. There are 3 queries done for each extension actually executed in order of priorities and a few more when the extension changes (or originates). It's not optimal, but it's the way that it works. At some point, a slight optimization could certainly be done to narrow this down to a single query from the database, followed by a fairly short caching period (1 second would be plenty), but that optimization has never been done. https://issues.asterisk.org/view.php?id=16521 Needs testing. -- Tilghman Lesher Tilghman, Saying I’m a bit excited right now is an understatement. First of all, the patch seems to work fine applied to 1.4.28 stable release. The performance of this patch is extraordinary. Before migrating my static dialplan to the database I could push 380 calls at 15 to 20 CPS. After migrating to the database, I could only push a little more than 100 calls and no more than 6 to 9 CPS. With this patch applied, I am pushing reliably 300 calls at 15 CPS. 7500+ calls without a hiccup. Not quite as good as a static dialplan, but that is expected. MySQLd has also decreased utilization, as expected, from 6 to 12, now 1 to 6. This has got to be an overall performance increase by 50% or more. I will be patching on my new 1.4 systems going forward. The sooner this patch gets applied to Asterisk, the better. Thanks. JR Looks like I'll be giving it a go in week or so then! I'll let you know how I get on too. -- Ishfaq Malik Software Developer PackNet Ltd Office: 0161 660 3062 ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime mysql extensions mutiple queries for each priority?
On Monday 28 December 2009 23:49:13 Tilghman Lesher wrote: On Monday 28 December 2009 18:09:15 JR Richardson wrote: I turned on console debug to see the actual mysql queries and to my surprise and concern, I see every query for an extension priority repeated 3 or more times prior to dialplan execution. For instance my first dialplan activity is all extracted from the database: context exten pri app appdata dpdefault14 _991X 1 NoOp INBOUND CALL FROM SIPP dpdefault14 _991X 2 NoOp TRUNK-${EXTEN:0:2} DID-${EXTEN:2} dpdefault14 _991X 3 Set CALLERID(number)=600 dpdefault14 _991X 4 Answer dpdefault14 _991X 5 Goto ${EXTEN:2}|1 Each priority is queried several times before executing. Here is a sample of the first 2 priorities on a pastebin: http://pastebin.com/m54c9c41e I would not think this is normal activity as I can query the database directly once and get a valid response. I don't have any realtime mysql connections issues that I can see, no errors in the logs and console status is: No, that's normal. The order of queries done is 1) check if the extension exists, 2) on spawn, retrieve the extension to populate information about the application into the channel structure, and 3) actually execute the application. There are 3 queries done for each extension actually executed in order of priorities and a few more when the extension changes (or originates). It's not optimal, but it's the way that it works. At some point, a slight optimization could certainly be done to narrow this down to a single query from the database, followed by a fairly short caching period (1 second would be plenty), but that optimization has never been done. https://issues.asterisk.org/view.php?id=16521 Needs testing. -- Tilghman Lesher Tilghman, Saying I’m a bit excited right now is an understatement. First of all, the patch seems to work fine applied to 1.4.28 stable release. The performance of this patch is extraordinary. Before migrating my static dialplan to the database I could push 380 calls at 15 to 20 CPS. After migrating to the database, I could only push a little more than 100 calls and no more than 6 to 9 CPS. With this patch applied, I am pushing reliably 300 calls at 15 CPS. 7500+ calls without a hiccup. Not quite as good as a static dialplan, but that is expected. MySQLd has also decreased utilization, as expected, from 6 to 12, now 1 to 6. This has got to be an overall performance increase by 50% or more. I will be patching on my new 1.4 systems going forward. The sooner this patch gets applied to Asterisk, the better. Thanks. JR -- JR Richardson Engineering for the Masses ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime mysql extensions mutiple queries for each priority?
On Monday 28 December 2009 18:09:15 JR Richardson wrote: I turned on console debug to see the actual mysql queries and to my surprise and concern, I see every query for an extension priority repeated 3 or more times prior to dialplan execution. For instance my first dialplan activity is all extracted from the database: context exten pri app appdata dpdefault14 _991X 1 NoOpINBOUND CALL FROM SIPP dpdefault14 _991X 2 NoOpTRUNK-${EXTEN:0:2} DID-${EXTEN:2} dpdefault14 _991X 3 Set CALLERID(number)=600 dpdefault14 _991X 4 Answer dpdefault14 _991X 5 Goto${EXTEN:2}|1 Each priority is queried several times before executing. Here is a sample of the first 2 priorities on a pastebin: http://pastebin.com/m54c9c41e I would not think this is normal activity as I can query the database directly once and get a valid response. I don't have any realtime mysql connections issues that I can see, no errors in the logs and console status is: No, that's normal. The order of queries done is 1) check if the extension exists, 2) on spawn, retrieve the extension to populate information about the application into the channel structure, and 3) actually execute the application. There are 3 queries done for each extension actually executed in order of priorities and a few more when the extension changes (or originates). It's not optimal, but it's the way that it works. At some point, a slight optimization could certainly be done to narrow this down to a single query from the database, followed by a fairly short caching period (1 second would be plenty), but that optimization has never been done. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime mysql extensions mutiple queries for each priority?
On Monday 28 December 2009 23:49:13 Tilghman Lesher wrote: On Monday 28 December 2009 18:09:15 JR Richardson wrote: I turned on console debug to see the actual mysql queries and to my surprise and concern, I see every query for an extension priority repeated 3 or more times prior to dialplan execution. For instance my first dialplan activity is all extracted from the database: context exten pri app appdata dpdefault14 _991X 1 NoOpINBOUND CALL FROM SIPP dpdefault14 _991X 2 NoOpTRUNK-${EXTEN:0:2} DID-${EXTEN:2} dpdefault14 _991X 3 Set CALLERID(number)=600 dpdefault14 _991X 4 Answer dpdefault14 _991X 5 Goto${EXTEN:2}|1 Each priority is queried several times before executing. Here is a sample of the first 2 priorities on a pastebin: http://pastebin.com/m54c9c41e I would not think this is normal activity as I can query the database directly once and get a valid response. I don't have any realtime mysql connections issues that I can see, no errors in the logs and console status is: No, that's normal. The order of queries done is 1) check if the extension exists, 2) on spawn, retrieve the extension to populate information about the application into the channel structure, and 3) actually execute the application. There are 3 queries done for each extension actually executed in order of priorities and a few more when the extension changes (or originates). It's not optimal, but it's the way that it works. At some point, a slight optimization could certainly be done to narrow this down to a single query from the database, followed by a fairly short caching period (1 second would be plenty), but that optimization has never been done. https://issues.asterisk.org/view.php?id=16521 Needs testing. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime - mysql query gives wrong results??
Two things: 1. Set the context 2. Set the port 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 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 host = '192.168.0.74' AND port = '5060' [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 ipaddr = '192.168.0.74' AND port = '5060' [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:258 realtime_multi_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE host = '192.168.0.74' ORDER BY host [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:258 realtime_multi_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE ipaddr = '192.168.0.74' ORDER BY ipaddr Found no matching peer or user for '192.168.0.74:5060' as seen above there is no result for this select although I have such record in the database: mysql SELECT * FROM sip_conf WHERE host = '192.168.0.74' ORDER BY host; ++---+-+--+--- ++-+-+---+--+--- ---++-+--+--+--- ---+-+---+-+--++--+- +--+-+-+++-- --+--+--+--+-+-- ---+++--+++ | id | name | accountcode | amaflags | callgroup | callerid | canreinvite | context | defaultip | dtmfmode | fromuser | fromdomain | fullcontact | host | insecure | language | mailbox | md5secret | nat | deny | permit | mask | pickupgroup | port | qualify | restrictcid | rtptimeout | rtpholdtimeout | secret | type | username | disallow | allow | musiconhold | regseconds | ipaddr | regexten | cancallforward | setvar | ++---+ -+--+---++-+-+-- -+--+--++-+- -+--+--+-+---+-+--+ +--+-+--+-+-++-- --++--+--+--+--- --+-+++--+-- --++ | 3 | outbound-voip.touk.pl | NULL| NULL | NULL | TouK S.K.A | no | NULL| NULL | NULL | NULL | NULL | NULL| 192.168.0.74 | NULL | NULL | NULL | NULL | no | NULL | NULL | NULL | NULL| | NULL | NULL| NULL | NULL | NULL | peer | | all | g729;ilbc;gsm;ulaw;alaw | NULL| 0 | | | yes|| ++--- +-+--+---++-+--- --+---+--+--++- +--+--+--+-+---+-+-- ++--+-+--+-+-+-- --+++--+--+--+-- ---+-+++ --+++ Why does realtime select give no results?? Cheers tomasz ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime Mysql error
Hi: Iam using Fedora core 5 . Thanks in advance; Date: Mon, 29 Oct 2007 10:23:28 +0530 From: [EMAIL PROTECTED] To: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] Realtime Mysql error On 10/27/07, wassim darwish wrote: Hi: Iam using an asterisk server with astcc ,iam facing a problem with astcc that when the call is hangup sometimes astcc doesnt calculate the call cost and the call time and without writing the call status on cdrs table . I tried to run this command realtime mysql status on the asterisk console and that what i've got: [Oct 27 01:05:32] ERROR[2607]: res_config_mysql.c:637 mysql_reconnect: MySQL RealTime: Ping failed (2006). Trying an explicit reconnect. Connected to [EMAIL PROTECTED], port 3306 with username root for 9 hours, 43 minutes, 39 seconds. Can any body help with this; Hi what is the version of asterisk and mysql what distro you are using ram _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime Mysql error
On 10/27/07, wassim darwish [EMAIL PROTECTED] wrote: Hi: Iam using an asterisk server with astcc ,iam facing a problem with astcc that when the call is hangup sometimes astcc doesnt calculate the call cost and the call time and without writing the call status on cdrs table . I tried to run this command realtime mysql status on the asterisk console and that what i've got: [Oct 27 01:05:32] ERROR[2607]: res_config_mysql.c:637 mysql_reconnect: MySQL RealTime: Ping failed (2006). Trying an explicit reconnect. Connected to [EMAIL PROTECTED], port 3306 with username root for 9 hours, 43 minutes, 39 seconds. Can any body help with this; Hi what is the version of asterisk and mysql what distro you are using ram ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime Mysql error
search , firewall, and confiration the software. the configuration the user is bad ??? use asterisk2billing it is good On 10/28/07, ram [EMAIL PROTECTED] wrote: On 10/27/07, wassim darwish [EMAIL PROTECTED] wrote: Hi: Iam using an asterisk server with astcc ,iam facing a problem with astcc that when the call is hangup sometimes astcc doesnt calculate the call cost and the call time and without writing the call status on cdrs table . I tried to run this command realtime mysql status on the asterisk console and that what i've got: [Oct 27 01:05:32] ERROR[2607]: res_config_mysql.c:637 mysql_reconnect: MySQL RealTime: Ping failed (2006). Trying an explicit reconnect. Connected to [EMAIL PROTECTED], port 3306 with username root for 9 hours, 43 minutes, 39 seconds. Can any body help with this; Hi what is the version of asterisk and mysql what distro you are using ram ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime +Mysql +Failover
On 12/13/06, Rob Schall [EMAIL PROTECTED] wrote: Hoping someone out there has run into this or has some ideas for us. We currently have asterisk set up with Realtime (using mysql) for its extensions,sip and voicemail files. The problem we are trying to solve, is one of a failover mechanism. What if our mysql server went down. Can Realtime be set up with a secondary mysql server to get its data from. We can set up mysql to sync with its fellow server, and maybe when it goes down, it couldn't make any changes (write), but either way, you could still get the extension info, etc, so your phones would still survive a mysql outage. Any ideas? Thanks, Rob I don't think Realtime can be setup with a secondary server (someone please correct me if I'm wrong). Two possibilities come to mind... 1. You can run MySQL in an HA arangement with on box as the hot standby. 2. If you can allow for ocassional asterisk reloads, you could use Realtime Static Regards, David ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime +Mysql +Failover
You can have a MySQL Cluster. - Original Message - From: David Thomas [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Sent: Wednesday, December 13, 2006 8:36 PM Subject: Re: [asterisk-users] Realtime +Mysql +Failover On 12/13/06, Rob Schall [EMAIL PROTECTED] wrote: Hoping someone out there has run into this or has some ideas for us. We currently have asterisk set up with Realtime (using mysql) for its extensions,sip and voicemail files. The problem we are trying to solve, is one of a failover mechanism. What if our mysql server went down. Can Realtime be set up with a secondary mysql server to get its data from. We can set up mysql to sync with its fellow server, and maybe when it goes down, it couldn't make any changes (write), but either way, you could still get the extension info, etc, so your phones would still survive a mysql outage. Any ideas? Thanks, Rob I don't think Realtime can be setup with a secondary server (someone please correct me if I'm wrong). Two possibilities come to mind... 1. You can run MySQL in an HA arangement with on box as the hot standby. 2. If you can allow for ocassional asterisk reloads, you could use Realtime Static Regards, David ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] realtime+mysql
If i am not mistaken, you need to have another IAX user tables to store all the iax users. HEre is some example http://www.voip-info.org/wiki/view/Asterisk+RealTime+IAX good luck!On 8/9/06, Shaun [EMAIL PROTECTED] wrote: I'm attempting to setup asterisk running real-time with mysql.Right now Ican get asterisk to start and run but a show dialplan shows basicallynothing other than parking extensions.I'm watching the full log also for debug messages and I can see that asterisk is connecting to mysql with out aissue but for some reason it does not seam to read the extensions table.Below is a few of my configs..#My slimmed down modules.conf [EMAIL PROTECTED] asterisk]# cat /etc/asterisk/modules.conf[modules]autoload=noload = res_config_mysql.soload = res_crypto.soload = res_features.soload = chan_features.soload = chan_iax2.so load = pbx_realtime.soload = app_realtime.so#My extconfig.conf[EMAIL PROTECTED] asterisk]# cat /etc/asterisk/extconfig.conf[settings]extensions = mysql,asterisk,extensions#mysqldump of my asterisk database DROP TABLE IF EXISTS `extensions`;CREATE TABLE `extensions` (`context` varchar(20) NOT NULL default 'default',`extension` varchar(20) NOT NULL default '',`priority` int(2) NOT NULL default '1', `application` varchar(20) NOT NULL default '',`args` varchar(50) default NULL,`descr` text,`flags` int(1) NOT NULL default '0',PRIMARY KEY(`context`,`extension`,`priority`)) ENGINE=MyISAM DEFAULT CHARSET=latin1; Dumping data for table `extensions`--INSERT INTO `extensions` VALUES('sortcalls','1949265snip',1,'Wait','10','Wait(10)',0)INSERT INTO `extensions` VALUES('sortcalls','_1949265snip',1,'Wait','10','Wait(10)',0); My iax.conf is setup to forward calls to sortcalls context... this is what iget when a call comes in..Aug8 22:47:58 NOTICE[10074]: chan_iax2.c:7303 socket_read: Rejectedconnect attempt from 64.61.93.87, request '1949265snip@sortcalls' does notexistAug8 22:47:58 NOTICE[10074]: chan_iax2.c:7303 socket_read: Rejectedconnect attempt from 64.61.93.90, request '1949265snip@sortcalls' does not existAnybody know whats going wrong here?--~Shaun___--Bandwidth and Colocation provided by Easynews.com --asterisk-users mailing listTo UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime + MYSQL
On Thu, Aug 11, 2005 at 09:20:36AM -0400, Nathan Alberti wrote: 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 similar in MySQL (shown below) and included the following in extconfig; voicemail.conf = mysql,asterisk,voicemail_users No, this way is used to store NOT voicemail users info, but ANY configuration file. To create such a table from the existing config filr use ast2sql.pl script. Link is given here: http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime+Static But you're probably want to create just the voicemail users config table: MySQL Table CREATE TABLE voicemail_users ( id int NOT NULL auto_increment, customer_id varchar(255) NOT NULL default '0', context varchar(255) NOT NULL default '', mailbox varchar(255) NOT NULL default '', password varchar(4) NOT NULL default '0', fullname varchar(50) NOT NULL default '', email varchar(50) NOT NULL default '', pager varchar(50) NOT NULL default '', stamp datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (`id`) ); ### So the correct line in extconfig.conf must be voicemail = mysql,asterisk,voicemail_users not voicemail.conf = mysql,asterisk,voicemail_users -- Best regards, Timur. ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime + MYSQL
Damon, You may be querying the wrong table, because the following fields in your Select statement do not exit in the table, voicemail_users, that you created: category, var_name, var_val, cat_metric, filename, commented Every item mentioned in a Select query must exist in the table that is being queried. Rollin Weeks On 8/10/05, Damon Estep [EMAIL PROTECTED] wrote: 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 similar in MySQL (shown below) and included the following in extconfig; voicemail.conf = mysql,asterisk,voicemail_users The result is that app_voicemail fails to load and it appears from the debug that it is not happy with the table structure... however the names it has for the fields seem strange (to me that is :)) If anyone has gone through the process of creating the correct tablesin MySQL and doesn't mind sharing I would be most appreciative. Regards, Nathan. MySQL Table CREATE TABLE voicemail_users ( id int NOT NULL auto_increment, customer_id varchar(255) NOT NULL default '0', context varchar(255) NOT NULL default '', mailbox varchar(255) NOT NULL default '', password varchar(4) NOT NULL default '0', fullname varchar(50) NOT NULL default '', email varchar(50) NOT NULL default '', pager varchar(50) NOT NULL default '', stamp datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY(`id`) ); ### res_mysql.conf [general] dbhost = localhost dbname = asterisk dbuser = asterisk dbpass = dbport = 3306 dbsock = /var/run/mysqld/mysqld.sock Debug Log Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Static SQL: SELECT category, var_name, var_val, cat_metric FROMvoicemail_users WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Everything is fine. Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Query: SELECT category, var_name, var_val, cat_metric FROM voicemail_users WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Query Failed because: Unknown column 'category' in 'field list' ___ This works for voicemail in CVS-HEADCREATE TABLE `voicemail` (`uniqueid` int(11) NOT NULL auto_increment,`customer_id` int(11) NOT NULL default '0',`context` varchar(50) NOT NULL default '',`mailbox` varchar(10) NOT NULL default '0', `password` varchar(4) NOT NULL default '0',`fullname` varchar(50) NOT NULL default '',`email` varchar(50) NOT NULL default '',`pager` varchar(50) NOT NULL default '',`stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,PRIMARY KEY(`uniqueid`),KEY `mailbox_context` (`mailbox`,`context`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;___Asterisk-Users mailing list Asterisk-Users@lists.digium.comhttp://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime + MYSQL
Timur V. Elzhov wrote: So the correct line in extconfig.conf must be voicemail = mysql,asterisk,voicemail_users Yes, Timur is correct. By stating that you want to bind voicemail.conf you mean you want to store the config file itself. This is not what you are looking for. Change the line above to what Timur says and it should work fine. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime + MYSQL
Rollin, My real-time works fine, Nathan was the original poster o this message. I simply added the table structure for real-time voicemail J Damon, You may be querying the wrong table, because the following fields in your Select statement do not exit in the table, voicemail_users, that you created: category, var_name, var_val, cat_metric, filename, commented Every item mentioned in a Select query must exist in the table that is being queried. Rollin Weeks On 8/10/05, Damon Estep [EMAIL PROTECTED] wrote: 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 similar in MySQL (shown below) and included the following in extconfig; voicemail.conf = mysql,asterisk,voicemail_users The result is that app_voicemail fails to load and it appears from the debug that it is not happy with the table structure... however the names it has for the fields seem strange (to me that is :)) If anyone has gone through the process of creating the correct tables in MySQL and doesn't mind sharing I would be most appreciative. Regards, Nathan. MySQL Table CREATE TABLE voicemail_users ( id int NOT NULL auto_increment, customer_id varchar(255) NOT NULL default '0', context varchar(255) NOT NULL default '', mailbox varchar(255) NOT NULL default '', password varchar(4) NOT NULL default '0', fullname varchar(50) NOT NULL default '', email varchar(50) NOT NULL default '', pager varchar(50) NOT NULL default '', stamp datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY(`id`) ); ### res_mysql.conf [general] dbhost = localhost dbname = asterisk dbuser = asterisk dbpass = dbport = 3306 dbsock = /var/run/mysqld/mysqld.sock Debug Log Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Static SQL: SELECT category, var_name, var_val, cat_metric FROM voicemail_users WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Everything is fine. Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Query: SELECT category, var_name, var_val, cat_metric FROM voicemail_users WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Query Failed because: Unknown column 'category' in 'field list' ___ This works for voicemail in CVS-HEAD CREATE TABLE `voicemail` ( `uniqueid` int(11) NOT NULL auto_increment, `customer_id` int(11) NOT NULL default '0', `context` varchar(50) NOT NULL default '', `mailbox` varchar(10) NOT NULL default '0', `password` varchar(4) NOT NULL default '0', `fullname` varchar(50) NOT NULL default '', `email` varchar(50) NOT NULL default '', `pager` varchar(50) NOT NULL default '', `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY(`uniqueid`), KEY `mailbox_context` (`mailbox`,`context`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime + MYSQL
Timur, Thank you for your response, I realize my mistake. I didn't understand that the table structures were different for the static component of real time as apposed to the actual real time part. Thank you again for your assistance. Nathan. Timur V. Elzhov wrote: On Thu, Aug 11, 2005 at 09:20:36AM -0400, Nathan Alberti wrote: 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 similar in MySQL (shown below) and included the following in extconfig; voicemail.conf = mysql,asterisk,voicemail_users No, this way is used to store NOT voicemail users info, but ANY configuration file. To create such a table from the existing config filr use ast2sql.pl script. Link is given here: http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime+Static But you're probably want to create just the voicemail users config table: MySQL Table CREATE TABLE voicemail_users ( id int NOT NULL auto_increment, customer_id varchar(255) NOT NULL default '0', context varchar(255) NOT NULL default '', mailbox varchar(255) NOT NULL default '', password varchar(4) NOT NULL default '0', fullname varchar(50) NOT NULL default '', email varchar(50) NOT NULL default '', pager varchar(50) NOT NULL default '', stamp datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (`id`) ); ### So the correct line in extconfig.conf must be voicemail = mysql,asterisk,voicemail_users not voicemail.conf = mysql,asterisk,voicemail_users -- Best regards, Timur. ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime + MYSQL
Hi, Nathan; Can I know what the contents of you voicemail.conf now? I get Asterisk Realtime Sip and extension working. I am trying to make Asterisk Realtime voicemail works, but not luck. Do I miss some steps? Previously I was using voicemail.conf. It works well. # cat voicemail.conf [general] format=wav [local] 2000 = 4321, Wei Kun, [EMAIL PROTECTED] 2001 = 8383, Wei Kun, [EMAIL PROTECTED] So I moved all the data into DB, and comment out items in voicemail.conf mysql select * from voicemail_users; +--+-+-+-+--+--+ ---+--+ | uniqueid | customer_id | context | mailbox | password | fullname | email | page | +--+-+-+-+--+--+ ---+--+ |1 |2000 | local |2000 | 4321 | Wei Kun | [EMAIL PROTECTED] | | |2 |2001 | local |2001 | 8765 | Wei Kun | [EMAIL PROTECTED] | | +--+-+-+-+--+--+ ---+--+ 2 rows in set (0.03 sec) The extension table looks like mysql select * from extensions_table; ++--+---+--+---++ | id | context | exten | priority | app | appdata| ++--+---+--+---++ | 1 | from-sip | 2000 |1 | Dial | SIP/2000|20| | 2 | from-sip | 2000 |2 | Voicemail | u2000 | | 3 | from-sip | 2000 | 102 | Voicemail | b2000 | | 4 | from-sip | 2000 | 103 | Hangup|| | 5 | from-sip | 2001 |1 | Dial | SIP/2001|20| | 6 | from-sip | 2001 |2 | Voicemail | u2001 | | 7 | from-sip | 2001 | 102 | Voicemail | b2001 | | 8 | from-sip | 2001 | 103 | Hangup|| | 9 | from-sip | 2999 |1 | VoicemailMain | ${CALLERIDNUM} | ++--+---+--+---++ 9 rows in set (0.01 sec) If I call 2001 from 2000, it take priority 1 and ring, and go to priority 2, now it get warning Aug 11 15:04:08 WARNING[9316] app_voicemail.c: No entry in voicemail config file for '2001' no debug regarding this part. It looks like asterisk still looking for the config file? The extconfig looks like voicemail = mysql,asterisk,voicemail_users Kun -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Nathan Alberti Sent: Friday, August 12, 2005 9:46 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime + MYSQL Timur, Thank you for your response, I realize my mistake. I didn't understand that the table structures were different for the static component of real time as apposed to the actual real time part. Thank you again for your assistance. Nathan. Timur V. Elzhov wrote: On Thu, Aug 11, 2005 at 09:20:36AM -0400, Nathan Alberti wrote: 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 similar in MySQL (shown below) and included the following in extconfig; voicemail.conf = mysql,asterisk,voicemail_users No, this way is used to store NOT voicemail users info, but ANY configuration file. To create such a table from the existing config filr use ast2sql.pl script. Link is given here: http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime+Static But you're probably want to create just the voicemail users config table: MySQL Table CREATE TABLE voicemail_users ( id int NOT NULL auto_increment, customer_id varchar(255) NOT NULL default '0', context varchar(255) NOT NULL default '', mailbox varchar(255) NOT NULL default '', password varchar(4) NOT NULL default '0', fullname varchar(50) NOT NULL default '', email varchar(50) NOT NULL default '', pager varchar(50) NOT NULL default '', stamp datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (`id`) ); ### So the correct line in extconfig.conf must be voicemail = mysql,asterisk,voicemail_users not voicemail.conf = mysql,asterisk,voicemail_users -- Best regards, Timur. ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE
RE: [Asterisk-Users] Realtime + MYSQL
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 similar in MySQL (shown below) and included the following in extconfig; voicemail.conf = mysql,asterisk,voicemail_users The result is that app_voicemail fails to load and it appears from the debug that it is not happy with the table structure... however the names it has for the fields seem strange (to me that is :)) If anyone has gone through the process of creating the correct tables in MySQL and doesn't mind sharing I would be most appreciative. Regards, Nathan. MySQL Table CREATE TABLE voicemail_users ( id int NOT NULL auto_increment, customer_id varchar(255) NOT NULL default '0', context varchar(255) NOT NULL default '', mailbox varchar(255) NOT NULL default '', password varchar(4) NOT NULL default '0', fullname varchar(50) NOT NULL default '', email varchar(50) NOT NULL default '', pager varchar(50) NOT NULL default '', stamp datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (`id`) ); ### res_mysql.conf [general] dbhost = localhost dbname = asterisk dbuser = asterisk dbpass = dbport = 3306 dbsock = /var/run/mysqld/mysqld.sock Debug Log Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Static SQL: SELECT category, var_name, var_val, cat_metric FROM voicemail_users WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Everything is fine. Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Query: SELECT category, var_name, var_val, cat_metric FROM voicemail_users WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Query Failed because: Unknown column 'category' in 'field list' ___ This works for voicemail in CVS-HEAD CREATE TABLE `voicemail` ( `uniqueid` int(11) NOT NULL auto_increment, `customer_id` int(11) NOT NULL default '0', `context` varchar(50) NOT NULL default '', `mailbox` varchar(10) NOT NULL default '0', `password` varchar(4) NOT NULL default '0', `fullname` varchar(50) NOT NULL default '', `email` varchar(50) NOT NULL default '', `pager` varchar(50) NOT NULL default '', `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`uniqueid`), KEY `mailbox_context` (`mailbox`,`context`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime mysql problem?
Ok, rtcachefriends=yes seemed to have fixed my problem(s). With both SIP and IAX2, now the question is why isn't this enabled by default? There must be a downside to using this feature, even though it pulls from mysql regardless if it's cached or not. thoughts? Thanks for your help though, this has seemed to address the issue :-) Matt -Original Message- From: Matthew Boehm [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 10:59 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote: Now, this has been answered many, many, many times...in fact..I believe Olle answered this in his Welcome to Asterisk post he sent out over the weekend. AAHH my bad, I should have asked *when* it will go stable.. ;-) When it will go stable is anybodys guess, including the developers. Again like Olle said, the developers will soon create a 1.1 code freeze which will be tested out the a$$ and only bug fixes will be introduced into the 1.1.* branch. Then after (hopefully*) a month of extremely regirous testing of the 1.1.* branch, 1.2 will be released. -Matthew *I say 'hopefully' because I've played many MMORPGS where large updates were introduced and had the update remained on the test server for another month, many of the bugs that were discovered could have been fixed before releasing bugy updates to the general public. ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime mysql problem?
Ok, thanks again. Just to wrap up (for the list), rtcachefriends must be enabled for all your backup ast servers if you want to reach them from realtime.. Can't wait for this mod to hit the next major stable, we'll be all over it! :-) Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 1:26 PM To: Matt Schulte Subject: RE: [Asterisk-Users] Realtime mysql problem? Quoting Matt Schulte [EMAIL PROTECTED]: Ok, rtcachefriends=yes seemed to have fixed my problem(s). With both SIP and IAX2, now the question is why isn't this enabled by default? There must be a downside to using this feature, even though it pulls from mysql regardless if it's cached or not. thoughts? Thanks for your help though, this has seemed to address the issue :-) The downside is that when using the cache you use some memory. When using non-cache everything is read from database all the time. When using cache, the first time a SIP UA registers, its info gets saved into the same linkd-list that static sip.conf users are in. I guess that really isn't a downside cause then future lookups would be faster..hmm..don't think there really is a downside. The reason it isn't on by default is because it is a new feature that needs to be more tested. -Matthew This message was sent using IMP, the Internet Messaging Program. ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime mysql problem?
Sorry for the delay, do you have any clue when realtime will get added to stable? I never did get this working but before I go too much further I'd like to run production on a stable version.. I'll try out SIP today and let you know, the reason I'm using IAX is because everything SIP we do is through SER. Not to mention since realtime doesn't support qualify= and NAT mode must be manually set, it's kind of pointless to use Asterisk for SIP. :-) Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Original Message- From: Matthew Boehm [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 9:03 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote: How do you toggle the realtime cache? Check in the configs/iax.conf.sample file of a recent CVS download and it should be in there. If there were too many fields in the table, could you foresee this being a problem? No, because I have lots of extra company specific fields in my sip_users table that asterisk doesn't use at all and I've had no problems. ie iax users have peercontext and auth. Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime mysql problem?
What is your problem with IAX in realtime? I have it working (finally). Wojtek - Original Message - From: Matt Schulte [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Sent: Monday, April 04, 2005 9:01 AM Subject: RE: [Asterisk-Users] Realtime mysql problem? Sorry for the delay, do you have any clue when realtime will get added to stable? I never did get this working but before I go too much further I'd like to run production on a stable version.. I'll try out SIP today and let you know, the reason I'm using IAX is because everything SIP we do is through SER. Not to mention since realtime doesn't support qualify= and NAT mode must be manually set, it's kind of pointless to use Asterisk for SIP. :-) Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Original Message- From: Matthew Boehm [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 9:03 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote: How do you toggle the realtime cache? Check in the configs/iax.conf.sample file of a recent CVS download and it should be in there. If there were too many fields in the table, could you foresee this being a problem? No, because I have lots of extra company specific fields in my sip_users table that asterisk doesn't use at all and I've had no problems. ie iax users have peercontext and auth. Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime mysql problem?
Well, I made several posts. Basically realtime works fine on the system you register to, if you try to contact that peer from another Ast server (running realtime), it does a SELECT query and all finds the peer and continues to say Unable to contact peer as if the user doesn't exist. I even went as far as packet sniffing and noticed it doesn't ever go out on port 4569 or anything. Again, I've made several posts about this before for full details. :-) Thanks, Matt -Original Message- From: Wojciech Tryc [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 8:26 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? What is your problem with IAX in realtime? I have it working (finally). Wojtek - Original Message - From: Matt Schulte [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Sent: Monday, April 04, 2005 9:01 AM Subject: RE: [Asterisk-Users] Realtime mysql problem? Sorry for the delay, do you have any clue when realtime will get added to stable? I never did get this working but before I go too much further I'd like to run production on a stable version.. I'll try out SIP today and let you know, the reason I'm using IAX is because everything SIP we do is through SER. Not to mention since realtime doesn't support qualify= and NAT mode must be manually set, it's kind of pointless to use Asterisk for SIP. :-) Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Original Message- From: Matthew Boehm [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 9:03 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote: How do you toggle the realtime cache? Check in the configs/iax.conf.sample file of a recent CVS download and it should be in there. If there were too many fields in the table, could you foresee this being a problem? No, because I have lots of extra company specific fields in my sip_users table that asterisk doesn't use at all and I've had no problems. ie iax users have peercontext and auth. Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime mysql problem?
do you have any clue when realtime will get added to stable? It won't. Not to mention since realtime doesn't support qualify= and NAT mode must be manually set, Have you been using RTC? (RealTime Cache) It fixes the NAT/MWI problem. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime mysql problem?
can you send me a dump from SQL for this account? I have it working both ways, W - Original Message - From: Matt Schulte [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Sent: Monday, April 04, 2005 9:34 AM Subject: RE: [Asterisk-Users] Realtime mysql problem? Well, I made several posts. Basically realtime works fine on the system you register to, if you try to contact that peer from another Ast server (running realtime), it does a SELECT query and all finds the peer and continues to say Unable to contact peer as if the user doesn't exist. I even went as far as packet sniffing and noticed it doesn't ever go out on port 4569 or anything. Again, I've made several posts about this before for full details. :-) Thanks, Matt -Original Message- From: Wojciech Tryc [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 8:26 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? What is your problem with IAX in realtime? I have it working (finally). Wojtek - Original Message - From: Matt Schulte [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Sent: Monday, April 04, 2005 9:01 AM Subject: RE: [Asterisk-Users] Realtime mysql problem? Sorry for the delay, do you have any clue when realtime will get added to stable? I never did get this working but before I go too much further I'd like to run production on a stable version.. I'll try out SIP today and let you know, the reason I'm using IAX is because everything SIP we do is through SER. Not to mention since realtime doesn't support qualify= and NAT mode must be manually set, it's kind of pointless to use Asterisk for SIP. :-) Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Original Message- From: Matthew Boehm [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 9:03 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote: How do you toggle the realtime cache? Check in the configs/iax.conf.sample file of a recent CVS download and it should be in there. If there were too many fields in the table, could you foresee this being a problem? No, because I have lots of extra company specific fields in my sip_users table that asterisk doesn't use at all and I've had no problems. ie iax users have peercontext and auth. Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime mysql problem?
do you have any clue when realtime will get added to stable? It won't. why not? Not to mention since realtime doesn't support qualify= and NAT mode must be manually set, Have you been using RTC? (RealTime Cache) It fixes the NAT/MWI problem. I haven't tried this yet because of my other issue, is RTC on by default? ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime mysql problem?
Matt Schulte wrote: do you have any clue when realtime will get added to stable? It won't. why not? Now, this has been answered many, many, many times...in fact..I believe Olle answered this in his Welcome to Asterisk post he sent out over the weekend. To summarize: The stable branch is for bug fixes only. New features will never be added to stable. If you want new AND stable wait for 1.2. I haven't tried this yet because of my other issue, is RTC on by default? No. You might want to check your configs/sip.conf.sample for the correct settings. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime mysql problem?
Now, this has been answered many, many, many times...in fact..I believe Olle answered this in his Welcome to Asterisk post he sent out over the weekend. AAHH my bad, I should have asked *when* it will go stable.. ;-) ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime mysql problem?
Matt Schulte wrote: Now, this has been answered many, many, many times...in fact..I believe Olle answered this in his Welcome to Asterisk post he sent out over the weekend. AAHH my bad, I should have asked *when* it will go stable.. ;-) When it will go stable is anybodys guess, including the developers. Again like Olle said, the developers will soon create a 1.1 code freeze which will be tested out the a$$ and only bug fixes will be introduced into the 1.1.* branch. Then after (hopefully*) a month of extremely regirous testing of the 1.1.* branch, 1.2 will be released. -Matthew *I say 'hopefully' because I've played many MMORPGS where large updates were introduced and had the update remained on the test server for another month, many of the bugs that were discovered could have been fixed before releasing bugy updates to the general public. ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime mysql problem?
Matt Schulte wrote: Now, this has been answered many, many, many times...in fact..I believe Olle answered this in his Welcome to Asterisk post he sent out over the weekend. Hmm, into my mailbox it did not come, ... ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime mysql problem?
I'm interested in your comments about SER. Do you send SIP calls to Asterisk at all e.g. for voicemail or PSTN interconnect? If so how do you handle this? Do you need your SIP users in sip.conf and registered on Asterisk, for example? How do you handle call accounting? Any tips would be appreciated as I'm in the process of setting up SER + Asterisk. Regards Cameron - Original Message - From: Matt Schulte [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Sent: Tuesday, April 05, 2005 1:01 AM Subject: RE: [Asterisk-Users] Realtime mysql problem? Sorry for the delay, do you have any clue when realtime will get added to stable? I never did get this working but before I go too much further I'd like to run production on a stable version.. I'll try out SIP today and let you know, the reason I'm using IAX is because everything SIP we do is through SER. Not to mention since realtime doesn't support qualify= and NAT mode must be manually set, it's kind of pointless to use Asterisk for SIP. :-) Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Original Message- From: Matthew Boehm [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 9:03 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote: How do you toggle the realtime cache? Check in the configs/iax.conf.sample file of a recent CVS download and it should be in there. If there were too many fields in the table, could you foresee this being a problem? No, because I have lots of extra company specific fields in my sip_users table that asterisk doesn't use at all and I've had no problems. ie iax users have peercontext and auth. Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime mysql problem?
Matt Schulte wrote: How do you toggle the realtime cache? Check in the configs/iax.conf.sample file of a recent CVS download and it should be in there. If there were too many fields in the table, could you foresee this being a problem? No, because I have lots of extra company specific fields in my sip_users table that asterisk doesn't use at all and I've had no problems. ie iax users have peercontext and auth. Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime mysql problem?
Ok, that was straight from the wiki. Still does not work, I tried it from the iax.conf, etc files and it works just fine. I even tried terminating/placing calls on the same server with realtime and it works fine. Is realtime broken? Is there anything else I can test with? Thanks, Matt -Original Message- From: Matthew Boehm [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 8:46 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote: ++---+-+--+---+--+ ++---+-+--+---+--+-- ---+---+- Here goes it's going to be messy :-) I followed the directions off the wiki. This *should* work just fine right? I built the table according to the directions, every field is varchar though, could that be a problem? The value of nat should be no or yes, not 0 (zero). Try that and reload everything. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime mysql problem?
Matt Schulte wrote: Ok, that was straight from the wiki. Still does not work, I tried it from the iax.conf, etc files and it works just fine. I even tried terminating/placing calls on the same server with realtime and it works fine. Is realtime broken? Is there anything else I can test with? Hrm. Have you tried realtime load iaxpeers 622 ? That command should confirm that the info is indeeded being read via RealTime. Do you have RealTime cache turned on/off? You might try turning it off/on (for the sake of trying something else). -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime mysql problem?
I did that and it's finding the peer correctly, here's my extconfig.conf by the way. All the sip/iax users are using the same table, per the wiki. [settings] iaxusers = mysql,asterisk,sip_users iaxpeers = mysql,asterisk,sip_users sipusers = mysql,asterisk,sip_users sippeers = mysql,asterisk,sip_users How do you toggle the realtime cache? If there were too many fields in the table, could you foresee this being a problem? ie iax users have peercontext and auth. I was going to try odbc to see if that changes the outcome but it's a pain in the a$$ (imho) to get on Fedora.. Will let you know unless you have any other ideas.. Thanks much for your help. Matt -Original Message- From: Matthew Boehm [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 29, 2005 9:50 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote: Ok, that was straight from the wiki. Still does not work, I tried it from the iax.conf, etc files and it works just fine. I even tried terminating/placing calls on the same server with realtime and it works fine. Is realtime broken? Is there anything else I can test with? Hrm. Have you tried realtime load iaxpeers 622 ? That command should confirm that the info is indeeded being read via RealTime. Do you have RealTime cache turned on/off? You might try turning it off/on (for the sake of trying something else). -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime mysql problem?
++---+-+--+---+--+-- ---+---+- Here goes it's going to be messy :-) I followed the directions off the wiki. This *should* work just fine right? I built the table according to the directions, every field is varchar though, could that be a problem? Thanks again, Matt +---+--+--++-+--+--- --+-+-++-+-+ ++---++---+--+-- --++---++ | id | name | accountcode | amaflags | callgroup | callerid | canreinvite | context | peercontext | defaultip | dtmfmode | fromuser | fromdomain | host| insecure | mailbox | nat | pickupgroup | port | qualify | restrictcid | rtptimeout | rtpholdtimeout | secret | type | username | disallow | allow | regseconds | ipaddr | cancallforward | ++---+-+--+---+--+-- ---+---+-+---+--+--+ +-+--+-+-+-+ +-+-+++---+- ---+---+--+++--- ++ | 3 | brak-test | [NULL] | [NULL] | [NULL]| [NULL] | no | outbound | incoming| [NULL]| [NULL] | [NULL] | [NULL] | dynamic | [NULL] | [NULL] | 0 | [NULL] | 4569 | [NULL] | [NULL] | [NULL] | [NULL] | blah | friend | brak-test | all | ulaw;alaw;g729 | 1112015162 | 206.80.254.254| yes | ++---+-+--+---+--+-- ---+---+-+---+--+--+ +-+--+-+-+-+ +-+-+++---+- ---+---+--+++--- ++ Matt Schulte wrote: Flatfile meaning iax.conf? Yes.. Sounds like a data problem to me. Paste your iaxpeers/iaxusers table schema and iax.conf section that is relevant to the phone. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime mysql problem?
Matt Schulte wrote: ++---+-+--+---+--+-- ---+---+- Here goes it's going to be messy :-) I followed the directions off the wiki. This *should* work just fine right? I built the table according to the directions, every field is varchar though, could that be a problem? The value of nat should be no or yes, not 0 (zero). Try that and reload everything. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime mysql problem?
Matt Schulte wrote: Mar 24 09:16:47 NOTICE[4527]: Unable to create channel of type 'IAX2' (cause 3) Doesn't seem like a RealTime issue to me. Did you add that user into the flatfile and test that way? -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime mysql problem?
Flatfile meaning iax.conf? Yes.. -Original Message- From: Matthew Boehm [mailto:[EMAIL PROTECTED] Sent: Thursday, March 24, 2005 8:49 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote: Mar 24 09:16:47 NOTICE[4527]: Unable to create channel of type 'IAX2' (cause 3) Doesn't seem like a RealTime issue to me. Did you add that user into the flatfile and test that way? -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime mysql problem?
Matt Schulte wrote: Flatfile meaning iax.conf? Yes.. Sounds like a data problem to me. Paste your iaxpeers/iaxusers table schema and iax.conf section that is relevant to the phone. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users