| 00:35.30 | blitzrage | jsmith: Ameritech Resporg -- 800.337.4194 |
| 00:35.42 | blitzrage | jsmith: please help me narrow the DTMF issues down! Sometimes it works fine -- sometimes not |
| 00:35.52 | blitzrage | file: can MuffinMan hang out in here too? |
| 00:36.06 | file | ummm yes |
| 00:36.20 | blitzrage | yay! MuffinMan can come out and play! |
| 00:37.02 | *** join/#asterisk-doc MuffinMan (n=muffins@neutrino.joshua-colp.com) |
| 00:37.10 | file | M4569 |
| 00:37.12 | MuffinMan | No information available. |
| 00:37.14 | file | voila |
| 00:37.21 | file | M5060 |
| 00:37.21 | MuffinMan | [closed] [Core Asterisk] General 0005060: Call initiated with call file always redials reported by linuxfreak - reporter http://bugs.digium.com/view.php?id=5060 |
| 00:41.50 | blitzrage | M9959 |
| 00:41.50 | MuffinMan | [new] [SIP] General 0009959: Issues with DTMF not coming in on time reported by ctooley - reporter http://bugs.digium.com/view.php?id=9959 |
| 00:41.56 | blitzrage | jsmith: part of my DTMF issue |
| 00:42.46 | blitzrage | calling from either PSTN or Polycom gives different results inputting a pin into a conference -- Asterisk seems to SEE the DTMF (I can see it on the console output), but it seems to not pass it to the conference all the time |
| 00:53.18 | jsmith | Well, students calling through their MIX account to their voicemail systems are complaining |
| 00:53.35 | blitzrage | jsmith: ya -- I've noticed this behaviour as well (not in voicemail though, but into a conference) |
| 00:53.42 | blitzrage | see that bug -- it shows the DTMF I'm seeing |
| 00:53.51 | blitzrage | notice Asterisk log file sees the DTMF -- sometimes it works, sometimes it doesn't |
| 00:53.56 | jsmith | It seems to be an echo cancellation issue |
| 00:54.07 | jsmith | Calling to a PRI number works fine... but calling to an analog interface doesn't. |
| 00:54.09 | blitzrage | not sure what echo cancellation I could have turned on though.... |
| 00:54.36 | blitzrage | unless 1.4 has some sort of echo can I'm not aware of on SIP calls... |
| 00:54.49 | jsmith | Well, echo can on whatever connects to the analog side... probably an upstream provider |
| 00:57.29 | blitzrage | you are talking about on voicemail though... |
| 00:57.49 | blitzrage | that is just class phone --> class asterisk --> mix asterisk |
| 01:03.35 | jsmith | Not even that... |
| 01:03.52 | jsmith | Well, it's like this: |
| 01:04.45 | jsmith | student phone -> student pc -> mix asterisk -> upstream -> analog interface -> voicemail interface on somebody else's PBX |
| 01:09.17 | blitzrage | ok ... but that's actually too many things to narrow down -- I'm getting DTMF issues calling into the VM on the Asterisk box -- which means that Asterisk itself could be screwing up the DTMF -- and not the upstream provider |
| 01:09.39 | blitzrage | s/into the VM on the Asterisk box/into the Vm on the Asterisk box with my Polycom/g |
| 01:26.38 | jsmith | Do you have a number I can call to test DTMF on the MIX Asterisk box? |
| 01:30.21 | blitzrage | jsmith: look up |
| 01:31.05 | blitzrage | jsmith: Ameritech Resporg -- 800.337.4194 |
| 01:31.16 | jsmith | Ah, cool. |
| 01:38.37 | blitzrage | let me know how it goes -- I wanna track this bug down... |
| 01:57.23 | jsmith | OK... using the MIX setup, it gave us garbled results on the Ameritech number |
| 01:58.07 | jsmith | Using the IAX connection to the office, then going through the office's MIX account works great |
| 02:00.20 | jsmith | I'll call you with the setup details, as I'm walking out the door. |
| 02:00.24 | jsmith | (or bother you tomorrow) |
| 02:00.28 | jsmith | It's late there |
| 02:00.34 | jsmith | Don't worry about it until morning |
| 02:00.36 | blitzrage | jsmith: I'm doing a system upgrade right now anyways |
| 02:00.42 | jsmith | Ah... |
| 02:00.50 | blitzrage | Wednesday night upgrade, yay! |
| 02:01.05 | jsmith | So does that mean I should call, or that you're busy doing other things, and that I should wait 'til morning |
| 02:02.37 | jsmith | Oh well, I'll catch you tomorrow |
| 05:38.43 | *** join/#asterisk-doc jbot (n=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 05:38.43 | *** topic/#asterisk-doc is Welcome to the Asterisk Documentation Project / Idle Chat, a subsidiary of telcomjoshleifvoxmartenterprisesinc --=-- Help write the next O'Reilly book! -- The Asterisk Cookbook: http://www.asteriskcookbook.com--==-- Asterisk: The Future of Telephony: ISBN13: 9780596514051 --==-- Free Downloads vs. Sales (of TFoT): http://radar.oreilly.com/archives/2007/06/free_downloads.html |
| 08:35.01 | *** join/#asterisk-doc matsk (n=mk@194.68.102.174) |
| 09:57.54 | *** join/#asterisk-doc jbot_ (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 09:57.54 | *** topic/#asterisk-doc is Welcome to the Asterisk Documentation Project / Idle Chat, a subsidiary of telcomjoshleifvoxmartenterprisesinc --=-- Help write the next O'Reilly book! -- The Asterisk Cookbook: http://www.asteriskcookbook.com--==-- Asterisk: The Future of Telephony: ISBN13: 9780596514051 --==-- Free Downloads vs. Sales (of TFoT): http://radar.oreilly.com/archives/2007/06/free_downloads.html |
| 13:26.44 | *** join/#asterisk-doc ctooley (n=ctooley@209.33.108.198) |
| 13:26.48 | ctooley | mornin |
| 14:15.56 | *** join/#asterisk-doc blitzrage (n=blitzrag@asterisk/documenteur-extraordinaire/blitzrage) |
| 14:15.56 | *** mode/#asterisk-doc [+o blitzrage] by ChanServ |
| 14:18.13 | file | blitzrage: NOT YOU |
| 14:18.32 | blitzrage | believe it or not |
| 15:42.53 | *** join/#asterisk-doc Doogle (n=Doogle@dyn-62-56-95-161.dslaccess.co.uk) |
| 15:43.42 | ctooley | Exciting bunch today |
| 15:53.04 | blitzrage | totally |
| 15:54.22 | ctooley | like totally rad and stuff |
| 15:56.22 | blitzrage | you just totally did |
| 16:07.25 | *** part/#asterisk-doc Doogle (n=Doogle@dyn-62-56-95-161.dslaccess.co.uk) |
| 16:07.32 | *** join/#asterisk-doc matsk (i=matsk@h110n2fls32o882.telia.com) |
| 16:08.44 | *** join/#asterisk-doc matsk (i=matsk@h110n2fls32o882.telia.com) |
| 16:31.20 | blitzrage | [Jun 14 12:30:35] WARNING[9142]: app.c:614 __ast_play_and_record: No audio available on SIP/ss1tampa.mixnetworks.com-b7d36c58?? |
| 16:31.22 | blitzrage | well that sucks... |
| 16:46.08 | *** join/#asterisk-doc jsmith (n=jsmith@66.195.187.177) |
| 16:46.08 | *** mode/#asterisk-doc [+o jsmith] by ChanServ |
| 17:17.55 | *** join/#asterisk-doc jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 17:17.55 | *** topic/#asterisk-doc is Welcome to the Asterisk Documentation Project / Idle Chat, a subsidiary of telcomjoshleifvoxmartenterprisesinc --=-- Help write the next O'Reilly book! -- The Asterisk Cookbook: http://www.asteriskcookbook.com--==-- Asterisk: The Future of Telephony: ISBN13: 9780596514051 --==-- Free Downloads vs. Sales (of TFoT): http://radar.oreilly.com/archives/2007/06/free_downloads.html |
| 17:35.18 | *** join/#asterisk-doc jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 17:35.18 | *** topic/#asterisk-doc is Welcome to the Asterisk Documentation Project / Idle Chat, a subsidiary of telcomjoshleifvoxmartenterprisesinc --=-- Help write the next O'Reilly book! -- The Asterisk Cookbook: http://www.asteriskcookbook.com--==-- Asterisk: The Future of Telephony: ISBN13: 9780596514051 --==-- Free Downloads vs. Sales (of TFoT): http://radar.oreilly.com/archives/2007/06/free_downloads.html |
| 17:35.52 | blitzrage | true true |
| 17:36.09 | blitzrage | kinda wondering why I would end up with the trunk/ dir inside the tag/0.3.0 dir... annoying |
| 17:36.16 | blitzrage | will see what Paul does |
| 17:36.17 | file | did the dir already exist? |
| 17:36.40 | blitzrage | yah.... must be my problem? |
| 17:36.55 | file | probably why |
| 17:37.07 | file | SVN probably assumed you wanted to copy it INTO that directory |
| 17:38.18 | blitzrage | aha -- yep, that was it |
| 17:38.57 | blitzrage | thx for humouring my nubness :) |
| 17:39.20 | file | your nubosity never ceases to nub |
| 17:39.27 | file | <3 |
| 17:39.43 | blitzrage | lol |
| 17:39.45 | blitzrage | <3 |
| 17:40.01 | blitzrage | I'm exhausted... I need to make some tea |
| 17:40.12 | jsmith | ~wake blitzrage |
| 17:40.13 | jbot | ACTION throws a barrel-full of ice water on blitzrage and shouts "GOOD MORNING!!!!" |
| 17:40.23 | jsmith | ~tea blitzrage |
| 17:40.23 | jbot | ACTION realizes it's time for high tea and gets busy in the kitchen. He brings out tea, crumpets, scones and an assortment of delectable goodies and serves them properly to blitzrage and others |
| 17:40.36 | jsmith | That one is a little better |
| 17:44.20 | blitzrage | ~teabag jsmith |
| 17:44.20 | jbot | ACTION squats |
| 17:44.25 | blitzrage | lol |
| 17:44.51 | file | O.o |
| 17:45.09 | blitzrage | jbot never ceases to amaze me |
| 18:33.57 | jsmith | file: Help! |
| 18:34.08 | file | jsmith: with? |
| 18:34.21 | jsmith | file: LumenVox changed a bunch of things with their 7.5 engine |
| 18:34.32 | jsmith | file: And turning it into an RPM made things worse |
| 18:34.49 | jsmith | file: They don't register their lv_speechport.so file in ld.so.conf |
| 18:35.18 | file | this is like the 6.6 engine days when they failed to do that |
| 18:35.24 | jsmith | file: And on about half the machines (once we get the libraries loaded with LD_LIBRARY_PATH), we get a SPEECH_TEXT of [Undefined] |
| 18:35.38 | file | the contents are [Undefined] ? |
| 18:35.41 | jsmith | file: Haven't been able to track that one down yet |
| 18:35.45 | file | erm, is |
| 18:35.48 | jsmith | file: Yes... exactly that, including the brackets |
| 18:35.56 | file | wow... that's definitely from their engine |
| 18:36.10 | file | all environment variables set? |
| 18:37.40 | jsmith | Yes, I think so |
| 18:37.47 | jsmith | Otherwise, the module won't even load |
| 18:37.54 | file | not entirely true |
| 18:38.00 | file | all variables aren't required for it to load, just most |
| 18:38.29 | blitzrage | jsmith: ping |
| 18:38.30 | file | LVBIN, LVLIB, LVINCLUDE, LVRESPONSE, LVLANG |
| 18:39.01 | jsmith | blitzrage: pong |
| 18:39.08 | jsmith | file: Yes, plus LD_LIBRARY_PATH |
| 18:39.20 | file | very very interwesting |
| 18:40.43 | blitzrage | jsmith: if I have two tables (ast_user, and ast_pbx), and both of those tables have the "ast_moh" column. I want to pull back the value from ast_user.ast_moh, but if it is null, I want to pull back ast_pbx.ast_moh WHERE ast_user.pbx = ast_pbx.name |
| 18:40.48 | blitzrage | jsmith: that is prime for a JOIN right? |
| 18:42.42 | jsmith | blitzrage: Nope |
| 18:43.00 | jsmith | blitzrage: COALESCE |
| 18:43.03 | blitzrage | OH YA! |
| 18:43.08 | blitzrage | been a while since I used that one |
| 18:52.01 | blitzrage | jsmith: do you have a minute to give me an example? (if not, I'll keep googling) |
| 18:53.37 | blitzrage | I guess my problem is trying to rmeember how to use it against 2 tables |
| 18:55.45 | Juggie | you are trying to put the inteligence for the null in sql i guess? |
| 18:55.58 | Juggie | so sql returns one field either the user or thee pbx setting |
| 18:56.06 | Juggie | depending on if user is null or not? |
| 18:57.25 | Juggie | blitzrage, my sql 8 ball says |
| 18:57.58 | blitzrage | true |
| 18:58.09 | blitzrage | if ast_user.moh is NULL< return the value in ast_pbx.moh |
| 18:58.47 | Juggie | select COALESCE(ast_user.ast_moh,ast_pbx.ast_moh) as ast_moh, any other fields from ast_user,ast_pbx where ast_user=user |
| 18:58.56 | Juggie | something like that |
| 19:00.08 | Juggie | you dont need a JOIN |
| 19:00.12 | Juggie | i never ever use joins |
| 19:00.22 | Juggie | maybe i suck at sql writing, but i never seem to need them |
| 19:00.36 | blitzrage | ya... I used them a few times for E911 stuff |
| 19:00.45 | blitzrage | but I haven't done many crazy things since then |
| 19:00.51 | blitzrage | so I've lost some of the mad skills :) |
| 19:01.15 | Juggie | anyways that query i said should work |
| 19:04.02 | Juggie | and? |
| 19:05.08 | blitzrage | hrmmm... getting multiple rows... time to see what I'm doing wrong |
| 19:05.23 | blitzrage | I had one that would have worked if I just made the column names correct :) |
| 19:06.15 | Juggie | blitzrage, your pbx table must have multiple servers defined in it then? |
| 19:06.23 | Juggie | add a condition to specify the server you want |
| 19:07.28 | blitzrage | well, I'm specifying the user ID... I might need something else. Gotta get more columns to figure out what I'm getting back |
| 19:08.01 | Juggie | blitzrage, that covers off pbx_user, but does ast_pbx have multiple rows? |
| 19:08.28 | Juggie | if it does you have to set a condition on that or your going to get multiple rows |
| 19:08.31 | Juggie | no way to avoid it |
| 19:11.15 | blitzrage | ya... I keep getting distracted by things... so it's taking longer than it should :) |
| 19:29.07 | blitzrage | SELECT COALESCE(p.ast_musiconhold_category, u.ast_musiconhold_category) AS moh, u.user_name, u.pbx FROM ast_pbx AS p, ast_user AS u WHERE u.id = '42' |
| 19:29.14 | blitzrage | I still don't get why that would return multiple rows |
| 19:29.19 | blitzrage | (all the rows are the same values...) |
| 19:29.50 | blitzrage | and ast_user.ast_musiconhold_category is populated (so not coming back from ast_pbx) |
| 19:31.39 | jsmith | Because you're not using a WHERE clause to limit your join |
| 19:32.02 | jsmith | Don't you want something like WHERE u.pbx_id = p.pbx_id |
| 19:32.20 | jsmith | blitzrage: Oh, btw, it looks like one your your RAID drives may have just gone out on the server |
| 19:32.44 | blitzrage | jsmith: look again... there is a WHERE u.id = '42' |
| 19:33.28 | blitzrage | jsmith: ugh.... RAID drive died? that sucks.... |
| 19:34.20 | jsmith | blitzrage: Which box are these tables on? I'd like to look at the table structures |
| 19:34.29 | blitzrage | tampa4 |
| 19:37.51 | blitzrage | it returns 17 rows.... and the id field does not match the number 42.... |
| 19:37.56 | blitzrage | so I don't get what is wrong.... |
| 19:38.02 | blitzrage | ok........ |
| 19:38.10 | blitzrage | ok... so now I changed it to this |
| 19:38.15 | blitzrage | SELECT COALESCE(u.ast_musiconhold_category, p.ast_musiconhold_category) AS moh, * |
| 19:38.15 | blitzrage | FROM ast_user AS u, ast_pbx AS p |
| 19:38.15 | blitzrage | WHERE u.id = 42 |
| 19:38.17 | blitzrage | <PROTECTED> |
| 19:38.23 | blitzrage | and now I get 17 rows of the same user.... |
| 19:42.13 | jsmith | OK, logging into tampa4 now |
| 19:42.21 | blitzrage | Paul says I need a LEFT JOIN |
| 19:44.31 | blitzrage | <PROTECTED> |
| 19:44.33 | blitzrage | SELECT COALESCE(u.ast_musiconhold_category, p.ast_musiconhold_category) |
| 19:44.33 | blitzrage | AS moh |
| 19:44.33 | blitzrage | FROM ast_user AS u |
| 19:44.33 | blitzrage | LEFT JOIN ast_pbx AS p ON u.pbx = p.name |
| 19:44.33 | blitzrage | WHERE u.id = 42 |
| 19:44.35 | blitzrage | <PROTECTED> |
| 19:44.36 | blitzrage | works |
| 19:44.43 | jsmith | <PROTECTED> |
| 19:45.15 | blitzrage | ok, that seems to work too |
| 19:45.23 | jsmith | You have to do something to make sure the record from the user table matches up with the record from the pbx table |
| 19:46.01 | jsmith | Otherwise, any user matches any pbx, and you get *lots* of records |
| 19:46.32 | blitzrage | aha... that makes sense |
| 19:46.43 | blitzrage | now I'm just trying to figure out which one has a higher cost :) |
| 19:46.50 | blitzrage | good ol' EXPLAIN() |
| 19:49.18 | blitzrage | thx for the help guys! |
| 19:49.24 | jsmith | No problem |
| 19:49.33 | jsmith | Glad to help, when I can |
| 19:49.38 | file | that'll be $19.95 |
| 19:50.08 | file | Subway card might appear tomorrow |
| 20:01.14 | blitzrage | I hate how there is no sub club program anymore |
| 20:01.17 | blitzrage | such a rip off |