00:30.50 | *** join/#asterisk matrix1233 (~matrix123@2a04:cec0:104a:f28a:68c3:ab48:87ea:28b1) |
01:26.19 | *** join/#asterisk verzo (~verzo@gateway/tor-sasl/verzo) |
01:26.28 | froy | Hrm, neither does ContactStatusDetail. Maybe ObjectName is worthless. |
01:30.50 | froy | Sure would be nice if things were named the same. Sometimes it's "URL"; sometimes it's "Url". Sometimes it's "ExpirationTime"; sometimes it's "regExpire". Sometimes it's "EndpointName"; sometimes it's "Endpoint". Sometimes it's "ViaAddr"; Sometimes it's "ViaAddress" ... I could go on. |
01:36.43 | Samot | ViaAddr and ViaAddress do not return the same information overall |
01:37.04 | Samot | ViaAddr returns only the address. ViaAddress returns address:port |
01:37.41 | froy | I noticed that too. So in some instances of Contact events, I have to parse it out. In others, they come separate. |
01:38.42 | *** join/#asterisk overyander (~overyande@209.141.208.197) |
02:12.37 | *** join/#asterisk nickvsnetworking (~nickvsnet@103.31.113.82) |
02:35.09 | wonderworld | Kobaz: better webrtc support made me switch to pjsip. otherwise i would have been too lazy, i guess |
02:51.54 | *** join/#asterisk hfb (~hfb@cpe-172-117-13-65.socal.res.rr.com) |
03:44.10 | *** join/#asterisk nickvsnetworking (~nickvsnet@103.31.113.82) |
03:51.33 | *** join/#asterisk nickvsnetworking (~nickvsnet@103.31.113.82) |
04:00.02 | *** join/#asterisk verzo (~verzo@gateway/tor-sasl/verzo) |
04:22.00 | *** join/#asterisk ih8wndz (jwpierce3@mail.000.srv.trnkmstr.com) |
05:09.53 | *** join/#asterisk jkroon (~jkroon@165.16.203.102) |
05:21.38 | *** join/#asterisk gerhard7 (~gerhard7@ip5657ee30.direct-adsl.nl) |
05:40.42 | *** join/#asterisk tomaluca95 (~quassel@kde/developer/tomaluca) |
06:06.25 | *** join/#asterisk miralin (~Thunderbi@host-46-63-142-29.stavropol.ru) |
06:08.16 | *** join/#asterisk miralin1 (~Thunderbi@195.209.246.194) |
06:29.54 | *** join/#asterisk verzo (~verzo@gateway/tor-sasl/verzo) |
06:53.04 | *** join/#asterisk lankanmon (~LKNnet@CPEb4fbe4e331bd-CM64777d632380.cpe.net.cable.rogers.com) |
07:20.59 | *** join/#asterisk sa02irc (~mbax@155-079-043-212.ip-addr.inexio.net) |
07:44.16 | *** join/#asterisk pchero_work (~pchero@2a02:a210:2241:6480:a41a:e78f:705d:71c9) |
08:11.43 | *** join/#asterisk sekil (~sekil@nat-73.net011.net) |
08:20.07 | wonderworld | the docs say that speex must be installed for the "denoise" function in confbridge to work. would that mean, that participants must use the speex codec while connecting to the conference or would denoise work with other codecs too, when speex is installed? |
08:26.26 | *** join/#asterisk puzzola (~puzzola@unaffiliated/puzzola) |
08:35.43 | *** join/#asterisk matteo (~matteo@redhat/matteo) |
08:45.09 | *** join/#asterisk matteo| (~matteo@redhat/matteo) |
08:48.12 | *** join/#asterisk matteo| (~matteo@redhat/matteo) |
08:55.18 | *** join/#asterisk tsal (~tsal@i59F4AB5C.versanet.de) |
09:08.02 | *** join/#asterisk matteo| (~matteo@redhat/matteo) |
09:14.33 | *** join/#asterisk matteo| (~matteo@redhat/matteo) |
09:24.40 | *** join/#asterisk matteo| (~matteo@redhat/matteo) |
09:41.11 | *** join/#asterisk Psyb3rN4ut (~psybernau@185.32.178.53) |
09:49.00 | *** join/#asterisk Gugge (gugge@guggemand.dk) |
10:20.01 | *** join/#asterisk id4rk (~id4rk@reactos/tester/id4rk) |
11:00.50 | *** join/#asterisk Ner0Zer0 (~Ner0Zer0@87.253.63.54) |
11:22.11 | *** join/#asterisk sa02irc (~mbax@155-079-043-212.ip-addr.inexio.net) |
11:25.35 | *** join/#asterisk tomaluca95 (~quassel@kde/developer/tomaluca) |
11:29.18 | *** join/#asterisk miralin (~Thunderbi@195.209.246.194) |
11:33.26 | *** join/#asterisk verzo_ (~verzo@gateway/tor-sasl/verzo) |
11:51.45 | *** join/#asterisk thansen9 (~thansen@192.74.130.86) |
11:55.21 | *** join/#asterisk m4rcu5 (nobody@84-106-248-133.cable.dynamic.v4.ziggo.nl) |
11:59.37 | *** join/#asterisk thansen6 (~thansen@192.74.130.86) |
12:06.23 | Zombie | "no remote address on RTP instance" |
12:06.42 | Zombie | Could someone help me debug this on Asterisk 17.4? |
12:24.25 | *** join/#asterisk m4rcu5 (nobody@84-106-248-133.cable.dynamic.v4.ziggo.nl) |
12:39.55 | *** join/#asterisk m4rcu5 (nobody@84-106-248-133.cable.dynamic.v4.ziggo.nl) |
12:40.16 | *** join/#asterisk sa02irc (~mbax@155-079-043-212.ip-addr.inexio.net) |
13:06.47 | *** join/#asterisk beardy (~beardy@unaffiliated/beardy) |
13:11.40 | *** join/#asterisk brad_mssw (~brad@66.129.88.50) |
13:21.44 | *** join/#asterisk waldo323_ (~waldo323@12.239.4.120) |
13:24.10 | *** join/#asterisk rmudgett (~rmudgett@170.249.191.178) |
13:24.10 | *** mode/#asterisk [+o rmudgett] by ChanServ |
13:47.35 | *** join/#asterisk fstd_ (~fstd@unaffiliated/fisted) |
13:56.56 | *** join/#asterisk kharwell (uid358942@gateway/web/irccloud.com/x-olewvgjvoreuhfxq) |
13:56.56 | *** mode/#asterisk [+o kharwell] by ChanServ |
14:07.36 | *** join/#asterisk bford (uid283514@gateway/web/irccloud.com/x-upbordxouuiriphe) |
14:07.37 | *** mode/#asterisk [+o bford] by ChanServ |
14:15.33 | *** join/#asterisk pchero_work (~pchero@2a02:a210:2241:6480:a41a:e78f:705d:71c9) |
14:17.41 | *** join/#asterisk CatCow97 (~mine9@c-73-96-109-206.hsd1.or.comcast.net) |
14:20.48 | *** join/#asterisk verzo (~verzo@gateway/tor-sasl/verzo) |
14:27.08 | *** join/#asterisk dacod (~dacod@138.97.32.134) |
14:51.11 | *** join/#asterisk pchero_work (~pchero@2a02:a210:2241:6480:a41a:e78f:705d:71c9) |
15:04.40 | *** join/#asterisk id4rk (~id4rk@reactos/tester/id4rk) |
15:05.59 | *** join/#asterisk spatel (~spatel@pool-96-237-230-175.bstnma.fios.verizon.net) |
15:14.39 | Kobaz | wonderworld: ah |
15:14.55 | Kobaz | Zombie: show sip pcap captures |
15:19.27 | *** join/#asterisk ghoti (~paul@dhcp-108-168-13-54.cable.user.start.ca) |
15:28.19 | froy | Is there a specific version of libmysqlclient that Asterisk requires? |
15:28.52 | froy | My Asterisk-16.8-cert2 build keeps crashing with this: unknown: debugger aborting because missing DBUG_RETURN or DBUG_VOID_RETURN macro in function "?func" -- that error comes from the libmysqlclient.so, I think. |
15:29.02 | froy | Thread dump: https://pastebin.com/raw/QksKxGdW |
15:29.23 | file | there's no specific version that we require, but the underlying stability of the MySQL ODBC connector varies across different versions of it |
15:29.28 | file | and people have had the best luck with the MariaDB connector |
15:30.14 | froy | I actually did try the mariadb connector first... Maybe it was still linking to the mysql one. I guess I'll give it another shot. |
15:30.40 | Kobaz | make distclean... re ./configure |
15:31.00 | Kobaz | make sure it's a blank slate so you're not re-using any object files from the wrong libs |
15:31.06 | froy | As far as I can tell in that thread dump, it wasn't ODBC. It was the MySQL connection to the CDR log. |
15:31.32 | froy | Yessir, I actually have a gentoo ebuild that starts from scratch every single time. |
15:32.17 | Kobaz | what version of mysql are you building/linking against? |
15:33.38 | Kobaz | failure deep inside mysql_reconnect sounds like maybe an abi mismatch? |
15:33.54 | Kobaz | so, gentoo, so did you build mysql from source as well? |
15:35.36 | froy | I have tried MySQL 8, MySQL 6, and MariaDB 10.4, though it may not have linked to MariaDB 10.4 properly because Gentoo requires libmysqlclient has to be there some reason. |
15:36.07 | froy | Yes, everything is from source, but it is predictable and reliable because of the portage tree scripting. |
15:36.31 | froy | This isn't a hodgepodge manual build with manual downloads and manual ./configure |
15:37.08 | *** join/#asterisk MarkSX (~MarkSX@unaffiliated/marksx) |
15:37.35 | froy | I'll try nuking all mysql stuff and do mariadb and see if I can make sure the ebuild to links to the mariadb-connector-c instead. |
15:37.48 | Kobaz | i would rebuild mysql with full debug symbols |
15:38.14 | froy | Hrm, good idea. Maybe I should do that first just to see what the stacktrace looks like. |
15:38.25 | Kobaz | yeah, you don't have full info there |
15:39.14 | sibiria | for CDRs, unless i need to query them from different locations remotely, i'd just use sqlite |
15:39.14 | Kobaz | and then, once you have that stack trace, then the next step is probably #mysql |
15:39.19 | froy | Yeah, I only turned on debug symbols in asterisk... It didn't occur to me that this is the other library until you mentioned it. |
15:39.37 | sibiria | a full-featured dbms for this purpose is kinda overkill unless something really calls for it |
15:39.56 | froy | True, true, sibiria, but yeah, I have lots of reporting systems that read it. |
15:41.32 | froy | Luckily, with gentoo, it's as easy as setting up a new debug build environment for a package, and bam, compiled with debug symbols! Love it! |
15:42.50 | Kobaz | wham blam thank you ma'am ? |
15:43.40 | drmessano | froy: Are you trying to use the cdr_mysql or the ODBC module? |
15:44.50 | Kobaz | looks like cdr_mysql from the stack trace |
15:44.54 | froy | I actually use both. I have ODBC set up for dialplan logic because the MYSQL() command plugin is deprecated. |
15:44.57 | Kobaz | #6 0x00007fd0f8e76f7f in mysql_ping () at /usr/lib64/libmysqlclient.so.18 #7 0x00007fd0f922ab50 in mysql_log (cdr=0x7fd0a40054d0) at cdr_mysql.c:220 |
15:45.19 | drmessano | I would ditch the cdr_mysql completely |
15:45.23 | froy | It is mysql-connector-c-6.1.11 |
15:45.40 | froy | Is there a better way to log CDR to mysql? |
15:45.49 | drmessano | I haven't had real success with it in years. Switched to ODBC and life got much better |
15:46.09 | drmessano | Yeah, odbc |
15:46.18 | froy | Oh, I did not know you could do that. :D |
15:46.41 | drmessano | the cdr_mysql module is deprecated for a reason |
15:47.15 | froy | It is deprecated? I thought that just the func_mysql was deprecated. |
15:47.22 | drmessano | No |
15:47.29 | drmessano | It's deprecated |
15:49.39 | froy | Well no wonders then. Ha! |
15:49.58 | drmessano | app_mysql and cdr_mysql have been listed as deprecated under the Addons menu in menuselect for god knows how long. |
15:50.19 | file | will they finally get removed? STAY TUNED! |
15:51.18 | drmessano | They should be moved from deprecated to deficated |
15:53.04 | Samot | Oh I think there will be things not in 18 |
15:53.36 | drmessano | chants "chan_sip! chan_sip!" |
15:53.56 | drmessano | chants "users.conf! users.conf!" |
15:54.08 | Samot | Well |
15:54.23 | Samot | I compiled Asterisk 16 and didn't do anything with app_macro |
15:54.26 | Samot | It's not there |
15:54.36 | Samot | Chan_sip is noload now in 17 |
15:55.18 | drmessano | app_macro is in 16 |
15:55.25 | Samot | Yes, it is. |
15:55.28 | Samot | When you make it so. |
15:55.42 | drmessano | You need it for FreePBX |
15:55.52 | Samot | Correct. So they make it so |
15:56.06 | Samot | Just like Asterisk 17 having Chan_SIP installed/loaded |
15:56.12 | Samot | In FreePBX. |
15:56.45 | drmessano | I guess I completely missed your point then |
15:57.55 | froy | app_macro is only turned off by default in 16. You can turn it back on in the menuselect. |
15:58.25 | Samot | Things are on the removal list. |
15:58.35 | froy | (I know because I have to turn it back on until I migrate at least 10 macros to gosubs) |
15:58.38 | Samot | First they just aren't loaded/installed as part of the default. |
15:58.45 | Samot | Then, they get removed. |
15:59.03 | froy | Yeah, 17 is probably going to be the chopping block for a lot of cruft! |
15:59.19 | drmessano | Well |
15:59.44 | Samot | 17 has been out since Oct. |
15:59.58 | Samot | 18 is the next release and LTS version. |
16:00.20 | Samot | So let's see. |
16:00.31 | seanbright | 18 might not be LTS |
16:00.32 | Samot | I know Chan_SIP is safe for the next couple years. |
16:00.35 | Samot | Oh... |
16:00.40 | Samot | Interesting. |
16:00.46 | seanbright | if history is any indication |
16:00.49 | froy | Yeah, I haven't messed with 17 because I try to only deal with certified versions because I'm trying to run a business here. :D |
16:00.51 | drmessano | "Just look at chan_sip and app_macro" is sort of a false equivalence when you consider how long other modules have been on the deprecated list, like cdr_mysql. If you have other info, great. but being recently moved to deprecated, like app_macro, is meaningless. |
16:02.40 | drmessano | Oh and cdr_mysql can be completely replaced with ODBC, and it STILL survives. So until an actual decision is made, I don't think something being recently marked as deprecated puts any sort of execution date on it. |
16:03.16 | Samot | app_macro kicks out warnings that it will be removed in future versions. |
16:03.17 | froy | Wait, is CDR itself deprecated too? |
16:03.24 | seanbright | no |
16:03.55 | drmessano | 11:49:58 <drmessano> app_mysql and cdr_mysql have been listed as deprecated under the Addons menu in menuselect for god knows how long. |
16:04.12 | drmessano | Who said "CDR" is deprecated? wat |
16:05.32 | froy | Oh, I misunderstood your "it STILL survives" thing. Sorry. |
16:06.52 | drmessano | I have not used a *_mysql module for idk, 8-10 years. The ODBC in Asterisk is fantastic and much more stable. |
16:07.09 | Samot | ^^^^ totally that |
16:07.47 | drmessano | cdr_mysql was never a first-class module anyway. It was part of -addons and then when -addons went away, it was still listed as an Add-On in Menuselect, like the mp3 module |
16:07.53 | drmessano | Because ODBC is better |
16:09.45 | drmessano | Not sure what I am saying is misunderstood. You have a choice between a few add-on mysql specific modules that have been problematic for some, and have been deprecated for years, or ODBC which is solid, stable, and fully supported. |
16:10.05 | *** join/#asterisk theGoat (~textual@payphone.landofhaze.net) |
16:21.07 | froy | So is mysql deprecated for realtime too? res_config_mysql? Just turn off all mysql? |
16:22.23 | igcewieling | anything you could use mysql module for can be done using the odbc module. |
16:22.56 | drmessano | facepalms |
16:23.03 | froy | Ha. Well. That just added a few more yaks to shave on my way to migrate from 13 to 16. |
16:23.21 | igcewieling | most of that info can be found in the UPGRADE.txt files. |
16:23.39 | igcewieling | ISn't that the first thing you read when downloading a new asterisk? |
16:23.56 | froy | Sorry drmessano, I admit I'm clueless. Just takin' it one day at a time here. |
16:24.22 | drmessano | I don't know what there is to misunderstand |
16:24.34 | drmessano | If the module has _mysql in the name, don't use it |
16:24.40 | drmessano | use _odbc |
16:24.51 | froy | Okay, I hear ya loud and clear. Sorry. |
16:25.27 | igcewieling | he things "mysql" means "database" |
16:25.38 | froy | I don't really go to the download page to manually download. It automatically downloads as part of an ebuild. |
16:25.41 | drmessano | MySQL is not being deprecated, CDR is not being deprecated, Asterisk is not being deprecated. Use ODBC |
16:25.49 | igcewieling | froy: no wonder you have problems. |
16:26.03 | drmessano | Asterisk <> ODBC <> All Sorta of Databases |
16:26.03 | Samot | Wait, you're saying Asterisk is deprecated? |
16:26.09 | Samot | WAY TO GO SANGOMA! |
16:26.29 | froy | Hey now, now you're putting words in my mouth. I never said that stuff. I don't think "mysql" means "database." |
16:26.44 | drmessano | We don't know what you think, to be honest |
16:26.46 | igcewieling | Samot: *nod* Sangoma has switched to FreeSwitch, complete with the angry Romanian who wrote it. |
16:27.11 | Samot | Huh, I figured it would be Jitsi. |
16:27.23 | drmessano | I tried stating 3 different ways that the modules that targeted MYSQL directly were deprecated and, in my experience, less reliable.. and to use the fully-supported ODBC |
16:27.35 | froy | Please calm down, man. I was just asking sincere questions. If I'm going to be ridiculed for stupid questions here, I dunno what the point of this channel is. |
16:27.44 | drmessano | and you still asked if MySQL was being discontinued by Oracle, so IDK dude |
16:27.58 | seanbright | "If I'm going to be ridiculed for stupid questions here, I dunno what the point of this channel is." |
16:28.07 | seanbright | honestly - that could be the /topic of this channel |
16:28.47 | froy | No I didn't ask if MySQL was being discontinued by Oracle. Who mentioned Oracle? What the crap. |
16:29.33 | drmessano | I'm not ridiculing you for asking stupid questions. I'm questioning the need to answer it 3 different ways, and then needing to reiterate it. I actually expanded greatly on your question and attempted to educate you as to a better, proper way of accessing MySQL, via ODBC, and I don't know if you didn't read it, or if I just wasted my time. |
16:30.00 | *** join/#asterisk irrgit (~ch33se@192.241.175.183) |
16:30.11 | drmessano | Sorry if I offended you by overly-answering your question and then being sarcastic when it was clear that what I typed was being ignored |
16:30.32 | drmessano | With that, I will make a temporary exit and go do something productive |
16:30.40 | froy | We were talking about CDR at first. Realtime isn't CDR. It has a completely separate configuration. That's why I asked. |
16:31.03 | *** join/#asterisk pchero_work (~pchero@2a02:a210:2241:6480:a41a:e78f:705d:71c9) |
16:34.39 | Samot | How did realtime get involved in this? |
16:34.51 | Samot | The Asterisk CDRs can be stored numerous ways |
16:35.03 | Samot | With numerous styles of DB based backends. |
16:35.26 | Samot | the _odbc modules allow you to use a single module to connect to those backends |
16:35.35 | Samot | vs having different modules for each backend |
16:35.51 | froy | Realtime got involved by an innocent question about it by me above -- which then blew up in my face. |
16:36.03 | Samot | CDR != database |
16:36.06 | seanbright | ... |
16:36.08 | seanbright | HE KNOWS |
16:36.11 | Samot | Numerous people use .csv |
16:36.11 | seanbright | can we move on? |
16:36.23 | froy | THank you seanbright! Whew. |
16:42.50 | *** join/#asterisk miralin (~Thunderbi@195.209.246.194) |
16:54.53 | *** join/#asterisk bank (~bank@acrossthemoat.com) |
17:36.59 | *** join/#asterisk sa02irc (~mbax@155-079-043-212.ip-addr.inexio.net) |
17:45.21 | *** join/#asterisk netman (~netman@185.94.249.222) |
17:51.55 | *** join/#asterisk chandoo (~chandoo@pool-100-1-166-161.nwrknj.fios.verizon.net) |
17:59.23 | *** join/#asterisk defsdoor (~Andrew@cpc120600-sutt6-2-0-cust232.19-1.cable.virginm.net) |
18:15.07 | *** join/#asterisk led_belly (led_belly@gateway/vpn/protonvpn/ledbelly/x-06903193) |
18:40.06 | *** join/#asterisk tomaluca95 (~quassel@kde/developer/tomaluca) |
19:16.38 | *** join/#asterisk pchero_work (~pchero@2a02:a210:2241:6480:a41a:e78f:705d:71c9) |
19:18.12 | *** join/#asterisk matrix1233 (~matrix123@80.215.98.224) |
19:21.08 | *** join/#asterisk tomaluca95 (~quassel@kde/developer/tomaluca) |
19:30.00 | *** join/#asterisk verzo (~verzo@gateway/tor-sasl/verzo) |
19:33.08 | *** join/#asterisk tomaluca95 (~quassel@kde/developer/tomaluca) |
20:01.35 | *** join/#asterisk pchero_work (~pchero@2a02:a210:2241:6480:a41a:e78f:705d:71c9) |
20:02.15 | *** join/#asterisk pchero_work (~pchero@2a02:a210:2241:6480:a41a:e78f:705d:71c9) |
20:17.37 | *** join/#asterisk matrix1233 (~matrix123@2a04:cec0:10dd:9e67:f1db:6319:2f77:c405) |
20:46.11 | *** join/#asterisk pchero_work (~pchero@2a02:a210:2241:6480:a41a:e78f:705d:71c9) |
21:11.52 | *** join/#asterisk Psyb3rN4ut (~psybernau@185.32.178.53) |
21:17.19 | *** join/#asterisk hfb (~hfb@47.139.18.84) |
21:40.56 | *** join/#asterisk pchero_work (~pchero@2a02:a210:2241:6480:a41a:e78f:705d:71c9) |
21:46.43 | *** join/#asterisk miralin (~Thunderbi@5.138.77.48) |
22:05.43 | *** join/#asterisk waldo323__ (~waldo323@d149-67-45-83.clv.wideopenwest.com) |
22:10.17 | *** join/#asterisk matrix1233 (~matrix123@2a04:cec0:10dd:9e67:f1db:6319:2f77:c405) |
22:14.25 | *** join/#asterisk verzo (~verzo@gateway/tor-sasl/verzo) |
22:18.43 | wonderworld | the docs say that speex must be installed for the "denoise" function in confbridge to work. would that mean, that participants must use the speex codec while connecting to the conference or would denoise work with other codecs too, when speex is installed? |
22:19.30 | file | denoise works for other codecs, speex provides a DSP library that can be used outside of the codec itself |
22:19.44 | wonderworld | thank you |
22:38.12 | *** join/#asterisk yokel (~yokel@unaffiliated/contempt) |
22:38.51 | *** join/#asterisk miralin1 (~Thunderbi@195.209.246.194) |
22:42.55 | *** join/#asterisk nickvsnetworking (~nickvsnet@103.31.113.82) |
23:32.25 | *** join/#asterisk Heart_And_Chops (~Heart_And@S0106cc2de0099182.no.shawcable.net) |
23:53.28 | *** join/#asterisk spatel (~spatel@pool-96-237-230-175.bstnma.fios.verizon.net) |