| 01:51.50 | *** join/#asterisk infobot (ibot@208.53.50.136) |
| 01:51.50 | *** topic/#asterisk is #asterisk The Open Source PBX and Telephony Platform (asterisk.org) -=- LTS: 13.22.0 (2018/07/12), Standard: 15.5.0 (2018/07/12); DAHDI: DAHDI-linux 2.11.1 (2016/03/01), DAHDI-tools 2.11.1 (2016/03/01); libpri 1.6.0 (2017/01/27) -=- Wiki: wiki.asterisk.org -=- Code of Conduct: bit.ly/1hH6P22 -=- Logs: bit.ly/1s4AKKu |
| 03:15.59 | *** join/#asterisk hfb (~hfb@cpe-108-185-247-93.socal.res.rr.com) |
| 04:01.04 | *** join/#asterisk k-man (~jason@unaffiliated/k-man) |
| 04:08.24 | *** join/#asterisk gruetzkopf (gruetzkopf@bnc.dont-follow.us) |
| 04:28.36 | *** join/#asterisk jkroon (~jkroon@165.16.204.174) |
| 04:41.36 | *** join/#asterisk alocer (~Thunderbi@84.241.47.157) |
| 04:42.24 | alocer | Hi Guys. what can i find asterisk table information? Wiki is so empty. |
| 04:43.42 | *** join/#asterisk troyt (~troyt@c-73-65-211-70.hsd1.ut.comcast.net) |
| 04:45.03 | *** join/#asterisk gerhard7 (~gerhard7@ip5657ee30.direct-adsl.nl) |
| 04:46.33 | *** join/#asterisk k-man (~jason@unaffiliated/k-man) |
| 04:52.13 | *** join/#asterisk csavinovich (sid296765@gateway/web/irccloud.com/x-iwrzjikbszaowkry) |
| 04:52.14 | *** mode/#asterisk [+o csavinovich] by ChanServ |
| 04:53.17 | *** join/#asterisk troyt (~troyt@2601:681:4100:8981:44dd:acff:fe85:9c8e) |
| 04:57.17 | *** join/#asterisk k-man (~jason@unaffiliated/k-man) |
| 05:02.59 | alocer | Found it. just connect to mysql on your asterisk server ;-) |
| 05:21.17 | *** join/#asterisk k-man (~jason@unaffiliated/k-man) |
| 05:48.45 | *** join/#asterisk tomaluca95 (~quassel@kde/developer/tomaluca) |
| 06:04.28 | *** join/#asterisk Sepultura (~Sepultura@unaffiliated/sepultura) |
| 06:14.35 | *** join/#asterisk allizom (~Thunderbi@95.235.166.188) |
| 06:18.11 | *** join/#asterisk tomaluca95_ (~quassel@kde/developer/tomaluca) |
| 06:50.35 | *** join/#asterisk sinaowolabi (~Sina@169.159.87.250) |
| 06:53.02 | *** join/#asterisk sinaowolabi (~Sina@169.159.87.250) |
| 07:00.23 | *** join/#asterisk NightMonkey (~NightMonk@pdpc/supporter/professional/nightmonkey) |
| 07:28.22 | *** join/#asterisk Chainsaw (~chainsaw@gentoo/developer/chainsaw) |
| 08:18.06 | *** join/#asterisk hehol (~hehol@gatekeeper.loca.net) |
| 08:20.11 | *** join/#asterisk hehol (~hehol@gatekeeper.loca.net) |
| 08:28.47 | *** join/#asterisk sekil (~sekil@nat-73.net011.net) |
| 09:05.59 | *** join/#asterisk sibyakin (~sibyakin@83.234.69.145) |
| 09:58.14 | *** join/#asterisk Oatmeal (~Suzeanne@185.245.87.165) |
| 09:59.16 | *** join/#asterisk sinaowolabi (~Sina@169.159.87.250) |
| 10:00.16 | *** join/#asterisk sinaowolabi (~Sina@169.159.87.250) |
| 10:01.16 | *** join/#asterisk sinaowolabi (~Sina@169.159.87.250) |
| 10:02.41 | *** join/#asterisk sinaowolabi (~Sina@169.159.87.250) |
| 10:04.06 | *** join/#asterisk sinaowolabi (~Sina@169.159.87.250) |
| 10:17.14 | *** join/#asterisk sinaowolabi (~Sina@169.159.87.250) |
| 10:38.36 | *** join/#asterisk sinaowolabi (~Sina@169.159.87.250) |
| 10:44.39 | *** join/#asterisk lankanmon (~LKNnet@CPE64777d632383-CM64777d632380.cpe.net.cable.rogers.com) |
| 11:13.30 | *** join/#asterisk allizom (~Thunderbi@95.235.166.188) |
| 11:18.50 | *** join/#asterisk Asgaroth (~Asgaroth@212.2.172.228) |
| 11:33.51 | n3t | Hey guys. Let's say I dial two channels. I'd like to start the second call after N seconds. Currently I use Wait() in my dialplan. Is there a way to _not_ wait when the first channel turns out busy/unavailable? |
| 11:35.54 | sibiria | you can skip the wait by checking the dialstatus from the previous call |
| 11:37.27 | sibiria | read the details of the GotoIf application to see how to use it |
| 11:40.14 | n3t | sibiria: I'm aware of Dialstatus and GotoIf. I'm not sure how to connect it together. My current (simplified) diaplan is like that -> https://paste.debian.net/plain/1035950 |
| 11:40.34 | n3t | And I'm not sure whether is a good dialplan or should I refactor it to make my use case possible. |
| 11:40.40 | n3t | s/is/it is/ |
| 11:41.41 | file | there is not a mechanism in dialplan to do that |
| 11:42.32 | Samot | Dialplan stops executing at Dial() until the Dial() returns a status. |
| 11:42.48 | Samot | Because at that point, it's in the Dial() app. |
| 11:43.22 | *** join/#asterisk Mr_Pleb_Mgoo (~jakeb@103.46.213.148) |
| 11:43.39 | n3t | Indeed that's how I understood it, hence my question. |
| 11:44.03 | n3t | I'll think about some workaround / redesign. Thank you guys. |
| 11:44.32 | sibiria | n3t: same => n,GotoIf($["${DIALSTATUS}" == "ANSWERED"]?nextdial) same => n,Wait(3) same => n(answered),Dial(blah) |
| 11:44.42 | sibiria | n(nextdial)* i mean |
| 11:47.16 | n3t | Hm, looks promising. Thanks sibiria. Do I understand correctly that Dial() returns when it knows its status, event if the call didn't end? |
| 11:47.35 | sibiria | i think ANSWER is the correct value actually - i don't recall the status names off the top of my head |
| 11:48.01 | sibiria | n3t: no. Dial() is blocking. it returns when the call is done, whatever the result |
| 11:48.33 | Samot | If you Dial() a destination and are on that call for 40 minutes.. |
| 11:48.43 | Samot | That call is stuck in the Dial() for 40 minutes. |
| 11:50.18 | sibiria | you can use the G option (or the autodialer) to introduce a flow for that Dial |
| 11:50.46 | sibiria | but either way Dial() won't proceed until it has something definitive to place in $DIALSTATUS |
| 11:53.26 | n3t | Okay. So in this solution I won't call two channels simultanously and wait "who answers first", right? |
| 11:53.59 | sibiria | i'm sure there's SOME clever way to achieve that... |
| 11:54.27 | sibiria | i'd just dial one after the other, depending on the outcome of the first call, as per my example flow above |
| 11:55.06 | n3t | To recap. My use case: call 2 numbers but give the 1st one N seconds of head-start (i.e. call the 2nd number after N seconds). Plot twist: I don't want to wait N seconds if I already know that the 1st number is busy or otherwise unavailable. |
| 11:55.53 | sibiria | and what i wrote above will do just that - if the first call isn't answered there will be no wait before calling the next number |
| 11:56.41 | sibiria | if you really want to connect a call to several recipients simultaneously you're looking for something else |
| 11:56.55 | n3t | If after N seconds noone answers, do both numbers ring? I'd like to. |
| 11:56.58 | n3t | mhm. |
| 11:57.06 | sibiria | afaik there's no immediate way for Dial() to "hang up all other destinations as soon as someone picks up" |
| 11:57.49 | sibiria | you can surely achieve it by callbacks and tracking but it seems like a rather complicated setup |
| 12:00.34 | sibiria | actually, scratch everything i said - i just took a look at what Dial() offers today and it seems it can do exactly what you want |
| 12:01.27 | sibiria | check out the Q option for Dial(), and the b option |
| 12:02.05 | sibiria | combining these should be able to give you a way of delaying one channel, while letting the other call instantly |
| 12:05.25 | n3t | I'll take a close look at these options. Thanks. |
| 12:05.49 | *** join/#asterisk Asgaroth (~Asgaroth@212.2.172.228) |
| 12:08.27 | *** join/#asterisk sekil (~sekil@nat-73.net011.net) |
| 12:09.32 | sibiria | apologies for misleading you on what Dial() can and cannot do. it's simply been many years, around version 1.8, since i was up-to-date with dial plan functionality |
| 12:09.54 | n3t | No worries :) |
| 12:39.03 | *** join/#asterisk [TK]D-Fender (~joe@216.191.106.165) |
| 12:41.00 | *** join/#asterisk Typhon (~Typhon@dslb-092-078-202-141.092.078.pools.vodafone-ip.de) |
| 13:13.01 | *** join/#asterisk ashka (~postmaste@pdpc/supporter/active/ashka) |
| 13:48.36 | *** join/#asterisk brad_mssw (~brad@66.129.88.50) |
| 14:07.22 | *** join/#asterisk allizom (~Thunderbi@95.235.166.188) |
| 14:09.05 | *** join/#asterisk kharwell (kharwell@nat/digium/x-izpkfsujbvjxjkud) |
| 14:09.05 | *** mode/#asterisk [+o kharwell] by ChanServ |
| 14:27.39 | *** join/#asterisk evilman_work (~evilman@87.244.6.228) |
| 14:39.49 | *** join/#asterisk cresl1n (uid299068@asterisk/libpri-and-libss7-expert/Cresl1n) |
| 14:39.49 | *** mode/#asterisk [+o cresl1n] by ChanServ |
| 14:40.27 | *** join/#asterisk jkroon (~jkroon@165.16.204.173) |
| 14:44.39 | *** join/#asterisk bford (uid283514@gateway/web/irccloud.com/x-lxmdytqjajntwvxt) |
| 14:44.39 | *** mode/#asterisk [+o bford] by ChanServ |
| 15:18.54 | *** join/#asterisk rmudgett (rmudgett@nat/digium/x-mxdnmunmnihzgsvf) |
| 15:18.54 | *** mode/#asterisk [+o rmudgett] by ChanServ |
| 15:32.02 | *** join/#asterisk jeffspeff (~jeffspeff@209.141.208.197) |
| 16:36.47 | igcewieling | a voicemail password validator in case it is helpful to anyone: https://pastebin.com/f2Aq2t3x |
| 17:02.27 | *** join/#asterisk salviadud (~ralfalfa@187-167-69-132.static.axtel.net) |
| 17:19.13 | *** join/#asterisk sinaowolabi (~Sina@41.58.78.194) |
| 17:30.31 | *** join/#asterisk somepoortech (~somepoort@72.12.70.165) |
| 17:32.19 | *** join/#asterisk nighty- (~nighty@s229123.ppp.asahi-net.or.jp) |
| 17:36.56 | *** join/#asterisk digilink (~sbrown@unaffiliated/digilink) |
| 18:01.07 | *** join/#asterisk gerhard7 (~gerhard7@ip5657ee30.direct-adsl.nl) |
| 18:21.18 | *** join/#asterisk allizom (~Thunderbi@95.235.166.188) |
| 18:30.13 | *** join/#asterisk Jesterboxboy (~Thunderbi@84-115-150-8.cable.dynamic.surfer.at) |
| 18:30.39 | *** join/#asterisk scgm11_ (~scgm11@r186-50-42-229.dialup.adsl.anteldata.net.uy) |
| 18:30.56 | scgm11_ | anyone know the dependencies packages and version of alpine to build asterisk? |
| 18:44.37 | *** join/#asterisk gerhard7 (~gerhard7@ip5657ee30.direct-adsl.nl) |
| 19:16.14 | *** join/#asterisk allizom (~Thunderbi@95.235.166.188) |
| 19:21.04 | *** join/#asterisk qxork (~qxork@unaffiliated/qxork) |
| 19:29.43 | *** join/#asterisk ChkDigit (~u388mw@74.3.144.66) |
| 19:58.35 | *** join/#asterisk miralin (~Thunderbi@194.8.128.63) |
| 20:31.18 | *** join/#asterisk Maxxed (~Maxxed@ec2-107-20-252-119.compute-1.amazonaws.com) |
| 20:53.49 | *** join/#asterisk yokel (~yokel@unaffiliated/contempt) |
| 20:55.09 | Maxxed | so, google killed the xmpp side of google voice, gvsip is the new way forward |
| 20:55.24 | Maxxed | is there a gvsip module for asterisk? |
| 20:58.11 | Maxxed | ..welp..TO THE GOOGLE MACHINE!! :p |
| 21:02.13 | degenerate | I am upgrading in a bit of a huge leap, from Asterisk 11.21.2 to Asterisk 13.22.0. There are some fairly significant changes to the asteriskcdrdb table. is there some sort of migration tool i could use? |
| 21:03.33 | Maxxed | https://issues.asterisk.org/jira/browse/ASTERISK-27971 |
| 21:06.36 | drmessano | Maxxed: We're all painfully aware |
| 21:06.44 | drmessano | This gets asked once a day, maybe more |
| 21:08.02 | degenerate | drmessano does asterisk have a built in CDR database upgrade utility? |
| 21:08.07 | degenerate | or is there some tool i can use |
| 21:08.17 | degenerate | it seems there are some significant schema changes between versions |
| 21:08.27 | degenerate | im not sure how to import my old cdr table |
| 21:09.12 | drmessano | What happens when you try to import it? |
| 21:10.05 | degenerate | well i could i was just being careful, because i see a lot of differences, like for example in asterisk 11.21.2 i have userfiled and eventextra fields in asteriskcdrdb.cel but not in asterisk 13.22 |
| 21:10.09 | degenerate | there are other differences as well |
| 21:10.52 | degenerate | 13.22 has an `extra` field in asteriskcdrdb.cel that doesn't exist in the old table. so if i import, doesn't `eventextra` need to get mapped to `extra` ? |
| 21:12.07 | drmessano | I've never used asteriskcdrdb.cel |
| 21:12.15 | drmessano | But if you don't need the field, what's the issue? |
| 21:13.03 | degenerate | ok well even asteriskcdrdb.cdr has differences. the new version has `linkedid` `peeraccount` and `sequence` these don't exist in the old version. if I mysql dump and mysql import those will get wiped. presumably this would break something no? |
| 21:13.44 | drmessano | So create them after? |
| 21:13.51 | zaf | just add the columns |
| 21:14.01 | drmessano | ^ |
| 21:14.03 | degenerate | ok. and its fine that they're empty for the older records? |
| 21:14.11 | degenerate | i don't need to populate them for my old records? |
| 21:14.16 | drmessano | You can't fake the data for the old records |
| 21:14.19 | drmessano | So just import them |
| 21:14.22 | degenerate | ok |
| 21:14.26 | zaf | null values are fine |
| 21:14.32 | zaf | unless you set the columns otherwise |
| 21:14.34 | zaf | which you shouldn't |
| 21:15.18 | degenerate | is there somewhere i can find out if asteriskcdrdb.cel.eventextra was simply renamed to asteriskcdrdb.cel.extra ? |
| 21:15.58 | drmessano | You can look at the file |
| 21:20.31 | Maxxed | it looks like there is a fork with gvsip built in, but it has not been merged into the main branch yet |
| 21:20.58 | Maxxed | my use case is simple enough, i think im going to go ahead and compile it, see how things go |
| 21:25.18 | file | it won't be merged as-is, and it will take awhile to get there |
| 21:25.25 | Samot | ^^^^ |
| 21:26.00 | Maxxed | and for all the right reasons :) |
| 21:41.06 | drmessano | It's so much easier just to not be cheap |
| 21:42.05 | degenerate | oh man i was so wrong, there are so many more than just 3 changes between these two cdr tables |
| 21:42.17 | degenerate | lots of fields used to be varchar 80 and are now varchar 40 |
| 21:42.30 | degenerate | if i change them to varchar 40 now, potentially i lose data? |
| 21:42.43 | degenerate | this all feels so clumbsy, i'm shocked there isn't a better migration system |
| 21:44.23 | drmessano | Why not just leave the fields alone |
| 21:49.52 | degenerate | how to import then? |
| 21:50.54 | sibiria | it doesn't really matter that they are varchar(80) if you're gonna stuff them with data coming from varchar(40) |
| 21:53.05 | drmessano | ^ that |
| 21:53.07 | drmessano | Just import them |
| 21:53.15 | drmessano | Add the missing fields |
| 21:53.15 | drmessano | Done |
| 21:53.33 | degenerate | missing indexes too |
| 21:54.21 | degenerate | just writing a script to fix it all, i did `describe cdr` for both versions and am just writing some SQL to fix it. |
| 21:54.32 | degenerate | it just feels so clumbsy this isn't accounted for |
| 21:56.27 | drmessano | Accounted for how? |
| 21:56.32 | file | alembic was done afterwards to keep things in line going forward, but anything else is not a project anyone has done and nothing that has been contributed |
| 21:58.00 | degenerate | drmessano well the devs would know what changes they made, so an upgrade script could be run when it detects an out of date database schema, and correct it. |
| 21:58.12 | degenerate | this is common practice in almost every piece of modern software i have worked with |
| 21:58.38 | file | that's what Alembic is for, but 11 predates it |
| 21:59.23 | degenerate | i see |
| 22:07.31 | *** join/#asterisk tomaluca95 (~quassel@kde/developer/tomaluca) |
| 22:14.45 | *** join/#asterisk Samael28 (~Samael28@176.104.56.91) |
| 22:35.27 | *** join/#asterisk [TK]D-Fender (~joe@64.235.216.2) |
| 23:26.37 | *** part/#asterisk kharwell (kharwell@nat/digium/x-izpkfsujbvjxjkud) |