| 01:17.54 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:8d17:8559:706:ce63) |
| 01:17.58 | *** join/#asterisk sarlalian (~sarlalian@107.170.239.102) |
| 01:35.01 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:8d17:8559:706:ce63) |
| 01:54.19 | *** join/#asterisk robink (~quassel@unaffilated/robink) |
| 01:59.20 | *** join/#asterisk youtmon (~yout@c-98-242-250-233.hsd1.fl.comcast.net) |
| 02:05.07 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:c5d2:3e5d:4360:714c) |
| 02:23.52 | *** join/#asterisk MrTAP (~MrT@unaffiliated/mrtap) |
| 02:30.19 | *** join/#asterisk startledmarmot (~startledm@cpe-75-82-221-87.socal.res.rr.com) |
| 02:51.00 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:c5d2:3e5d:4360:714c) |
| 03:14.53 | *** join/#asterisk tehgooch (~tehgooch@unaffiliated/tehgooch) |
| 03:14.59 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:eca0:644a:81a3:8f7e) |
| 04:13.55 | *** join/#asterisk evil_gordita (robert@ip70-188-41-127.rn.hr.cox.net) |
| 04:27.04 | *** join/#asterisk setham (~setham@unaffiliated/setham) |
| 04:27.54 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:c59c:3ff9:253c:e370) |
| 04:28.09 | *** join/#asterisk juvenal (juvenal@gateway/shell/elitebnc/x-ytwsmwzesykkargk) |
| 04:30.20 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:c59c:3ff9:253c:e370) |
| 04:37.08 | *** join/#asterisk luckman212 (~luckman21@unaffiliated/luckman212) |
| 04:49.42 | *** join/#asterisk Cory (~Cory@unaffiliated/cory) |
| 05:04.16 | *** join/#asterisk cemotyz09 (~cemotyz09@cpe-70-121-157-202.satx.res.rr.com) |
| 05:05.18 | *** join/#asterisk evilman_work (~evilman@87.244.6.228) |
| 05:49.05 | *** join/#asterisk shootbird (~quassel@beepbeep.serverpit.com) |
| 05:49.08 | *** join/#asterisk miralin (~Thunderbi@91.237.94.13) |
| 06:15.47 | *** join/#asterisk gerhard7__ (~gerhard7@ip5657ee30.direct-adsl.nl) |
| 07:13.19 | *** join/#asterisk [[thufir]] (~thufir@192.157.119.2) |
| 07:35.22 | *** join/#asterisk jamesaxl (~James_Axl@109.172.62.242) |
| 07:48.20 | *** join/#asterisk cemotyz09 (~cemotyz09@cpe-70-121-157-202.satx.res.rr.com) |
| 08:15.44 | *** join/#asterisk jkroon_ (~jkroon@165.16.204.163) |
| 09:24.37 | *** join/#asterisk markusl (~markus@hodor.lindenberg.io) |
| 09:29.34 | *** join/#asterisk Worldexe (~Worldexe@95-107-33-134.dsl.orel.ru) |
| 09:38.44 | *** join/#asterisk sekil (~sekil@cable-89-216-195-152.dynamic.sbb.rs) |
| 09:43.57 | *** join/#asterisk evilman_work (~evilman@87.244.6.228) |
| 09:45.23 | *** join/#asterisk jamesaxl (~James_Axl@109.172.62.242) |
| 09:46.17 | *** join/#asterisk detha (~detha@unaffiliated/detha) |
| 10:14.05 | *** join/#asterisk evilman_work (~evilman@87.244.6.228) |
| 10:33.55 | *** join/#asterisk pchero (~pchero@109.70.54.56) |
| 11:30.56 | *** join/#asterisk lankanmon (~LKNnet@CPE64777dd7e053-CM64777dd7e050.cpe.net.cable.rogers.com) |
| 12:01.53 | *** join/#asterisk youtmon (~yout@c-98-242-250-233.hsd1.fl.comcast.net) |
| 12:02.15 | *** join/#asterisk jrabe (irc@janikrabe.com) |
| 12:35.12 | *** join/#asterisk youtmon (~yout@c-98-242-250-233.hsd1.fl.comcast.net) |
| 13:13.14 | *** join/#asterisk defsdoor (~andy@cpc120600-sutt6-2-0-cust177.19-1.cable.virginm.net) |
| 13:18.26 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:e5c9:f0b3:e04a:2a75) |
| 13:33.31 | *** join/#asterisk Jesterboxboy (~Thunderbi@80-109-194-26.cable.dynamic.surfer.at) |
| 13:44.45 | thiagoc | hi all... I have a sip trunk using pjsip, when I start asterisk and make a cli originate it works without problems, but if I try again it shows this message: |
| 13:44.46 | thiagoc | [Nov 18 11:43:17] WARNING[1780]: res_pjsip_outbound_authenticator_digest.c:144 digest_create_request_with_auth_from_old: Unable to create request with auth.No auth credentials for any realms in challenge. |
| 13:45.29 | thiagoc | any clues? |
| 14:22.35 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:f065:21e:2efe:d8ab) |
| 14:31.46 | *** join/#asterisk mutin-s (~s-mutin@85.234.114.134) |
| 14:33.56 | *** join/#asterisk gerhard7__ (~gerhard7@ip5657ee30.direct-adsl.nl) |
| 14:54.21 | *** join/#asterisk Iamnacho (~Iamnacho@ip72-213-25-54.om.om.cox.net) |
| 14:55.28 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:d422:621f:4443:249) |
| 14:58.06 | *** join/#asterisk jamesaxl (~James_Axl@109.172.62.242) |
| 14:58.23 | *** join/#asterisk Worldexe (~Worldexe@95-107-33-134.dsl.orel.ru) |
| 15:04.11 | *** join/#asterisk [TK]D-Fender (~joe@64.235.216.2) |
| 15:20.57 | *** join/#asterisk spr0k3t (~root@206.229.46.55) |
| 15:23.29 | *** join/#asterisk evilman_work (~evilman@87.244.6.228) |
| 16:06.49 | lvlinux | If I'm using func_odbc to get a number of variables from a database, does it make more sense to do one db query and get multiple values and parse them in dialplan, or do several simple queries for individual values? |
| 16:09.08 | Samot | 6 on one, half dozen on the other... |
| 16:09.24 | Samot | Do you want to make multiple queries? |
| 16:13.18 | *** join/#asterisk andresmujica (~andresmmu@ubuntu/member/andresmujica) |
| 16:13.36 | *** part/#asterisk andresmujica (~andresmmu@ubuntu/member/andresmujica) |
| 16:13.44 | lvlinux | If it doesn't matter then I'll just do multiple queries. I just wasn't sure if there was a rule of thumb to follow. |
| 16:14.13 | Samot | More queries = more resources |
| 16:14.24 | lvlinux | more than parsing in dialplan? |
| 16:14.32 | Samot | well.. |
| 16:14.45 | Samot | You are making a database querie.. |
| 16:14.53 | Samot | So you have to connect, query, return |
| 16:14.56 | Samot | close |
| 16:14.59 | Samot | Each time |
| 16:15.24 | Samot | Depending on how big the database is.. |
| 16:15.31 | lvlinux | Eh yeah. |
| 16:15.37 | Samot | How complex the query |
| 16:15.46 | lvlinux | DB isn't very big, but could grow of course. Queries are very simple. |
| 16:16.01 | Samot | Well if one query gets you all the data in 0.0005 |
| 16:16.13 | Samot | And one at a time it's 0.000006 |
| 16:16.26 | Samot | Sure you're saving but you're doing it how many times? |
| 16:16.44 | Samot | could end up being more than the original single query |
| 16:17.09 | lvlinux | k |
| 16:18.00 | lvlinux | I think I'll go with a single query then. May never make a real difference but if this gets scaled up quite a bit and the db grows it could. |
| 16:18.03 | lvlinux | thx |
| 16:58.43 | *** join/#asterisk shootbird (~quassel@205.185.122.214) |
| 17:04.47 | sibiria | lvlinux: get them all in one query. even if you have a persistent connection and some caching is involved on the DBMS end, you still have some latency in the overhead of a query that you cannot escape |
| 17:05.37 | sibiria | also, don't worry about this until you've determined that it's an actual bottleneck for something :p |
| 17:12.51 | *** join/#asterisk youtmon (~yout@c-98-242-250-233.hsd1.fl.comcast.net) |
| 17:30.40 | lvlinux | sibiria: thanks---yes I did it in one query. I didn't know about ARRAY() before, and it makes parsing trivial. |
| 17:31.03 | lvlinux | By the way, in case everyone else hasn't noticed--- func_odbc ROCKS!!! :-D |
| 17:31.45 | *** join/#asterisk jamesaxl (~James_Axl@109.172.62.242) |
| 17:31.55 | *** join/#asterisk Jesterboxboy (~Thunderbi@80-109-194-26.cable.dynamic.surfer.at) |
| 17:32.59 | *** join/#asterisk setham (~setham@unaffiliated/setham) |
| 17:35.06 | vo1pbx | ODBC works on windows 3.11 |
| 17:36.50 | vo1pbx | i think i did that in 1996 |
| 17:42.42 | thiagoc | hi all... I have a sip trunk using pjsip, when I start asterisk and make a cli originate it works without problems, but if I try again it shows this message: |
| 17:42.49 | thiagoc | [Nov 18 11:43:17] WARNING[1780]: res_pjsip_outbound_authenticator_digest.c:144 digest_create_request_with_auth_from_old: Unable to create request with auth.No auth credentials for any realms in challenge. |
| 17:43.16 | thiagoc | debug from a success call: https://pastebin.com/raw/nnnxJYXS |
| 17:43.28 | thiagoc | a fail one: https://pastebin.com/raw/eEJieQY0 |
| 17:48.24 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:a5da:56e1:25fb:af8f) |
| 17:51.09 | Kobaz | yeah odbc is been around |
| 17:51.48 | Kobaz | speaking of latency, i've been pondering about using reddis for realtime state instead of postgres, for scaling |
| 17:51.58 | Kobaz | we use a lot of unlogged tables for realtime asterisk tracking in postgres |
| 17:52.16 | Kobaz | it's pretty speedy, but i do see the db being the bottleneck during high concurrency |
| 18:04.29 | Worldexe | how much queries per second you have? |
| 18:05.27 | Worldexe | i also use db for some realtime stats, but im using ms sql server with ordinal tables; the db is on ssd tho |
| 18:07.11 | *** join/#asterisk TandyUK2 (~admin@TandyUK/staff/James) |
| 18:12.30 | sibiria | Kobaz: we solved that by rendering the dialplan from database then reloading it |
| 18:13.54 | thiagoc | it seems that my problem was the identify section on pjsip.conf, just delete this section and it works |
| 18:16.14 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:d0f0:53e2:e8ca:617a) |
| 18:16.47 | *** join/#asterisk cemotyz09 (~cemotyz09@cpe-70-121-157-202.satx.res.rr.com) |
| 18:25.31 | thiagoc | it's normal to get this message on cli? |
| 18:25.33 | thiagoc | [Nov 18 16:25:20] NOTICE[4259]: res_pjsip/pjsip_distributor.c:631 log_failed_request: Request 'NOTIFY' from '<sip:keepalive@179.124.44.234>' failed for '179.124.44.234:5060' (callid: 35a981bf-4e1356de-3e093@179.124.44.234) - No matching endpoint found |
| 18:34.24 | *** join/#asterisk pppingme (~pppingme@unaffiliated/pppingme) |
| 18:45.17 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:e01e:6a46:3514:2265) |
| 19:20.05 | *** join/#asterisk almostworking (~almostwor@unaffiliated/almostworking) |
| 19:29.44 | *** join/#asterisk clarjon1 (~clarjon1@unaffiliated/clarjon1) |
| 19:32.29 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:e01e:6a46:3514:2265) |
| 19:35.00 | *** join/#asterisk setham (~setham@unaffiliated/setham) |
| 20:07.44 | *** join/#asterisk BR-Saldanha (~BR-Saldan@45.6.130.46) |
| 20:10.07 | *** join/#asterisk cemotyz09 (~cemotyz09@cpe-70-121-157-202.satx.res.rr.com) |
| 20:10.52 | BR-Saldanha | Hello everyone. I am looking for a consultant to assist in the installation of an Asterisk with Realtime, CDR in database, Fail2Ban, VPN PPTP Client, FOP 2 (www.fop2.com) and some report of accesses to queues and calls. |
| 20:10.52 | BR-Saldanha | Anyone interested in the service? |
| 20:29.07 | *** join/#asterisk jamesaxl (~James_Axl@109.172.62.242) |
| 20:55.03 | *** join/#asterisk almostworking (~almostwor@unaffiliated/almostworking) |
| 21:01.49 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:b98b:d3d5:24f2:8b22) |
| 22:21.19 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:351c:b093:f98d:a287) |
| 22:55.08 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:351c:b093:f98d:a287) |
| 23:02.08 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:351c:b093:f98d:a287) |
| 23:12.53 | *** join/#asterisk shootbird (~quassel@beepbeep.serverpit.com) |
| 23:56.23 | *** join/#asterisk Yiota (~textual@2607:fea8:56df:fa6d:85b2:62ad:4b87:4d33) |