| 00:20.55 | scv | hdon: no, i suggest locking the db, copying the file, then unlocking it |
| 00:26.31 | *** join/#asterisk raspberrypifan (~raspberry@cblmdm170-253-181-126.maxxsouthbb.net) |
| 00:26.49 | raspberrypifan | why is the astericon so expensive |
| 00:26.51 | raspberrypifan | im a poor man |
| 00:33.23 | hdon | scv, well, that would work |
| 00:33.49 | hdon | [2016-08-05 17:33:15] WARNING[5017]: db.c:332 ast_db_put: Couldn't execute statment: SQL logic error or missing database |
| 00:34.10 | hdon | i have a lto of this message, but asterisk has open the database accoridng to lsof: |
| 00:34.11 | hdon | asterisk 4951 asterisk 8r REG 0,340 425984 713153 /var/lib/asterisk/astdb.sqlite3 |
| 00:34.34 | hdon | oh it might have wrong perms |
| 00:34.41 | hdon | yep |
| 00:36.41 | *** join/#asterisk u0m3__ (~u0m3@188.27.75.240) |
| 00:46.29 | *** join/#asterisk acidfu_ (~acidfoo@198-48-218-90.cpe.pppoe.ca) |
| 00:46.43 | scv | i've had some issues with cdrs getting dropped on sqlite |
| 00:46.46 | scv | i need to actually look into that |
| 00:51.14 | *** join/#asterisk u0m3 (~u0m3@188.27.75.240) |
| 01:50.13 | wyoung | scv: I recommend postgresql |
| 01:51.06 | scv | i'm not deploying postgres on an embedded device |
| 01:52.56 | scv | anyway, there shouldn't be multiple writers anyway, it should be queued and handled in a single thread |
| 01:53.02 | scv | anyway anyway anyway |
| 01:53.23 | wyoung | scv: oh, an embedded device |
| 01:53.44 | wyoung | I missed that bit of info |
| 01:53.50 | scv | my use case is a prebuilt image, vm or embedded |
| 01:54.14 | scv | i haven't really dug into the issue yet, seems to only happen under memory pressure |
| 02:11.29 | wyoung | why would you keep a CDR on emdedded devices? VMs you can just spin up postgres |
| 02:16.44 | scv | same reason i'd keep cdr anywhere |
| 02:16.52 | scv | i don't need any of the features of postgres |
| 02:17.02 | scv | sqlite is *fine*, asterisk is just exhibiting buggy behavior |
| 02:17.05 | wyoung | like persistence? |
| 02:20.06 | scv | it's stored in sqlite purely to paginate requests to review the cdrs |
| 02:23.11 | scv | there'd be no issue with using pgsql in the vm environment excluding that it's unnecessary |
| 02:23.46 | scv | easier to just keep a consistent image across all deployments |
| 03:00.20 | *** join/#asterisk TriJetScud (~TriJetScu@van-app-svr.ad.v10networks.ca) |
| 03:00.20 | *** join/#asterisk nanoha-sama (~nanoha-sa@van-app-svr.ad.v10networks.ca) |
| 03:04.13 | *** join/#asterisk shootbird (~quassel@beepbeep.serverpit.com) |
| 03:05.42 | *** join/#asterisk TriJetScud (~TriJetScu@van-app-svr.ad.v10networks.ca) |
| 03:05.43 | *** join/#asterisk nanoha-sama (~nanoha-sa@van-app-svr.ad.v10networks.ca) |
| 03:26.46 | *** join/#asterisk fstd_ (~fstd@unaffiliated/fisted) |
| 03:32.26 | *** join/#asterisk puzzola (~puzzola@unaffiliated/puzzola) |
| 03:43.32 | *** join/#asterisk friedrich (~friedrich@aextron.de) |
| 03:55.13 | *** join/#asterisk klow (~textual@c-67-161-106-89.hsd1.wa.comcast.net) |
| 04:08.11 | *** join/#asterisk shootbird (~quassel@beepbeep.serverpit.com) |
| 04:14.34 | *** join/#asterisk piling (~piling@unaffiliated/piling) |
| 04:19.32 | *** join/#asterisk raspberrypifan (~raspberry@cblmdm170-253-181-126.maxxsouthbb.net) |
| 05:37.43 | *** join/#asterisk clopez (~tau@neutrino.es) |
| 06:14.48 | *** join/#asterisk babak (uid19622@gateway/web/irccloud.com/x-pbydtqlionrrnrul) |
| 06:39.51 | *** join/#asterisk raspberrypifan (~raspberry@cblmdm170-253-181-126.maxxsouthbb.net) |
| 06:58.08 | *** join/#asterisk raspberrypifan (~raspberry@cblmdm170-253-181-126.maxxsouthbb.net) |
| 08:06.05 | *** join/#asterisk evil_gordita (robert@ip70-188-41-127.rn.hr.cox.net) |
| 08:50.42 | *** join/#asterisk camerin (hoax@elite.bshellz.net) |
| 09:00.38 | *** join/#asterisk camerin (~camerin@elite.bshellz.net) |
| 09:07.02 | *** join/#asterisk camerin (~camerin@elite.bshellz.net) |
| 10:25.19 | *** join/#asterisk bof22 (~Thunderbi@ARennes-650-1-12-136.w90-32.abo.wanadoo.fr) |
| 10:49.56 | *** join/#asterisk pa (~pa@unaffiliated/pa) |
| 11:45.03 | *** join/#asterisk mirela666 (~mirkob@52D9ADEB.cm-11-1c.dynamic.ziggo.nl) |
| 11:47.14 | *** join/#asterisk nix8n82 (~AndChat56@67.130.74.235) |
| 12:01.57 | *** join/#asterisk mirela666 (~mirkob@52D9ADEB.cm-11-1c.dynamic.ziggo.nl) |
| 12:08.26 | *** join/#asterisk jr220 (~jamesruss@184-89-242-81.res.bhn.net) |
| 12:30.43 | *** join/#asterisk mirela666 (~mirkob@52D9ADEB.cm-11-1c.dynamic.ziggo.nl) |
| 12:44.57 | *** join/#asterisk acidfu_ (~acidfoo@198-48-218-90.cpe.pppoe.ca) |
| 13:24.35 | *** join/#asterisk MaliutaLap (nikolai@unaffiliated/maliuta) |
| 13:53.38 | *** join/#asterisk babak (uid19622@gateway/web/irccloud.com/x-qoxlfxaiizgdtwsl) |
| 13:54.46 | *** join/#asterisk SunGod (~SunGod@92.55.116.125) |
| 14:09.45 | *** join/#asterisk herrkin (~herrkin@200.8.119.139) |
| 14:10.38 | herrkin | hello, I have a weird issue with ARI, it says ' Error determining real directory for rest-api' when I try to connect |
| 14:10.48 | herrkin | can anybody tell me how to solve it? |
| 14:16.09 | *** join/#asterisk acidfu_ (~acidfoo@198-48-218-90.cpe.pppoe.ca) |
| 14:37.16 | *** join/#asterisk luckman212 (~luckman21@unaffiliated/luckman212) |
| 15:28.37 | *** join/#asterisk acidfu_ (~acidfoo@198-48-218-90.cpe.pppoe.ca) |
| 15:32.09 | *** join/#asterisk [TK]D-Fender (~joe@64.235.216.2) |
| 16:08.03 | *** join/#asterisk Kyosh (~whoa@pool-108-46-231-151.nycmny.fios.verizon.net) |
| 16:10.52 | *** join/#asterisk tzafrir (~tzafrir@bzq-179-40-172.cust.bezeqint.net) |
| 16:32.30 | *** join/#asterisk acidfu_ (~acidfoo@198-48-218-90.cpe.pppoe.ca) |
| 17:24.50 | *** join/#asterisk babak (uid19622@gateway/web/irccloud.com/x-kgwkjrehnkwvmyew) |
| 17:51.37 | *** join/#asterisk slav3_sergal (~frankthet@unaffiliated/slav3-kitten/x-0866809) |
| 18:20.29 | *** join/#asterisk luckman212 (~luckman21@unaffiliated/luckman212) |
| 18:26.19 | *** join/#asterisk shootbird (~quassel@beepbeep.serverpit.com) |
| 18:57.06 | *** join/#asterisk infobot (ibot@rikers.org) |
| 18:57.06 | *** topic/#asterisk is #asterisk The Open Source PBX and Telephony Platform (asterisk.org) -=- LTS: 13.10.0 (2016/07/21), 11.23.0 (2016/07/21), Standard: 14.0.0-beta1 (2016/07/27); DAHDI: DAHDI-linux 2.11.1 (2016/03/01), DAHDI-tools 2.11.1 (2016/03/01); libpri 1.5.0 (2016/03/28) -=- Wiki: wiki.asterisk.org -=- Code of Conduct: bit.ly/1hH6P22 -=- Logs: bit.ly/1s4AKKu |
| 19:03.43 | *** join/#asterisk Jesterboxboy (~Thunderbi@chello080109194026.3.graz.surfer.at) |
| 19:21.45 | *** join/#asterisk luckman212 (~luckman21@unaffiliated/luckman212) |
| 19:39.49 | *** join/#asterisk Samot_ (sid133316@gateway/web/irccloud.com/x-lmgyyotykhxepmbt) |
| 19:47.11 | SpaceInvaders | is there a xor? & docs say it should act as an or if expr1=1 and expr2=0 but I can't make that work in test. |
| 19:47.23 | SpaceInvaders | er... |
| 19:47.31 | SpaceInvaders | is there a xor? & docs say it should act as xor if expr1=1 and expr2=0 but I can't make that work in test. |
| 19:47.50 | *** join/#asterisk monsterco (~monsterco@TOROON474AW-LP140-01-1279749185.dsl.bell.ca) |
| 19:51.42 | SpaceInvaders | weird. & and | seem to yield the exact same results |
| 19:52.17 | SpaceInvaders | 1100 but there's no 1001 |
| 21:11.01 | *** join/#asterisk infobot (ibot@rikers.org) |
| 21:11.01 | *** topic/#asterisk is #asterisk The Open Source PBX and Telephony Platform (asterisk.org) -=- LTS: 13.10.0 (2016/07/21), 11.23.0 (2016/07/21), Standard: 14.0.0-beta1 (2016/07/27); DAHDI: DAHDI-linux 2.11.1 (2016/03/01), DAHDI-tools 2.11.1 (2016/03/01); libpri 1.5.0 (2016/03/28) -=- Wiki: wiki.asterisk.org -=- Code of Conduct: bit.ly/1hH6P22 -=- Logs: bit.ly/1s4AKKu |
| 21:30.29 | file | wobbles |
| 21:38.07 | *** join/#asterisk jr220 (~jamesruss@184-89-242-81.res.bhn.net) |
| 22:12.07 | *** join/#asterisk gringo (~gringo@unaffiliated/gringo) |
| 22:28.52 | *** join/#asterisk eofster (~eofster@ip5b406133.dynamic.kabel-deutschland.de) |
| 23:09.15 | *** join/#asterisk jab416171 (~jab416171@c-76-27-96-12.hsd1.ut.comcast.net) |
| 23:33.16 | *** join/#asterisk jr220 (~jamesruss@184-89-242-81.res.bhn.net) |
| 23:34.41 | *** join/#asterisk shootbird (~quassel@beepbeep.serverpit.com) |
| 23:47.22 | *** join/#asterisk dan_j (sid21651@gateway/web/irccloud.com/x-czqxwtwjgvesohyn) |