From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by finch.gentoo.org (Postfix) with ESMTPS id DB79B1382C5 for ; Wed, 23 Dec 2020 19:49:39 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 87D5D2BC046; Wed, 23 Dec 2020 19:49:35 +0000 (UTC) Received: from mail145c7.megamailservers.com (mail775.megamailservers.com [69.49.98.85]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id 098C5E0C22 for ; Wed, 23 Dec 2020 19:49:35 +0000 (UTC) X-Authenticated-User: admin@sys-concept.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=megamailservers.com; s=mailtor; t=1608752974; bh=PigteMEnljKWWveGr8uM4Awc3+aEi98ObOJilgkIImo=; h=Subject:From:To:References:Date:In-Reply-To:From; b=CU50fLztlbXJwc4bl1VrX1JVTysNpTFDbrrGrodRysVZjeH7lGgRCIVhGN3t6KF6p VyvUsTqnm7g4gJhhGYKSKsOKPrKawu2ppuisZVLDwSXrI0RJ7IAdpoARCx6jfHhiPx iEwhoutnYbcQWIF+1w1fgYQNcsB1lAzl+SJ7HJrg= Feedback-ID:thelma@sys-conc X-VIP: 69.49.109.100 Received: from [10.0.0.103] 184.69.242.18":"14014 ([184.69.242.18]) (authenticated bits=0) by mail145c7.megamailservers.com (8.14.9/8.13.1) with ESMTP id 0BNJnWto004665 for ; Wed, 23 Dec 2020 14:49:34 -0500 Subject: Re: [gentoo-user] Asterisk 13.36 - ast_db_put: Couldn't execute statement: attempt to write a readonly database From: thelma@sys-concept.com To: Gentoo mailing list References: <65eaf969-7e6d-d95f-cb3b-ee294ec46f0e@sys-concept.com> Openpgp: preference=signencrypt Autocrypt: addr=thelma@sys-concept.com; prefer-encrypt=mutual; keydata= xsFNBErG0rkBEADBziWBlZRgPWA3MO6hrJNm3Qb1zS8B3bSIKEPMVRYvc0DaHl0enSVM10Tv da4LraSH81xLeDgOptWRNAjyUhdbJegqgNeS5SYLZpWkYdtovQTCwFOAZYS9nKPU6OSDMGFZ goda3bsK38tvw7fkvzWUNHrKX2nRFnjJm1ixCyAjUHoWaUgF4GLDqD5nq1WUfYaw58jUHoco bRMn0KOuoAF+t/xlIF285UewQQaNUlza6lZ+otdJveOCfOV0thElYJGkyQ5sFibvFuDuwS8M 0usojinj5mrHHnl+8EObosFnrDw7PH0xASRkYUB6BmCDYLyYoujvZdhUo8ghIUBmEC4ePgJU rx6Hm10yRMTJdbX18W/6PjdI0bCaDOVuD8kV1b9gF55KUrV1AP8O4aix6CzNHmvsUyUk4c6E os6Jf3N9NOYAO/VdnyGeaTWcdVJbjJh/0M3fK9CAcLGOeK3qdBpiJZMxaHRlZnctHfP49BZV Pm1hlZtDt/fgt1V1+P8Mo03uMNM3K938zUDpHkt21jWCZzV2JrNF6MTiURiEIE0IZxJmNGfX Ub29OwRMTDiBvs2Tunr0ftih7HezKgjRt8kq3M0mHTqTJ9oaep52sFtkeDwmsP0bN2sIvWMj w9g2mWZzKP+v4uFhbJ12upDvyenqd/rOYbhg1Xyd20Z63BRqIQARAQABzTtTeXMuQ29uY2Vw dCBJbmMuICh3d3cuc3lzY29uY2VwdC5jYSkgPGluZm9Ac3lzLWNvbmNlcHQuY29tPsLBegQT AQIAJAIbAwIeAQIXgAULCQgHAwUVCgkICwUWAgMBAAUCSsbe2AIZAQAKCRD7p+62e0p4wibP D/4j8iPAp5wt274sd6Ew/iS09MIbl48b5kWAERhZkPYv+BfESoFT193+ErxyiwxfZcQkEpQR SoLkFlxes6Ov1FTs8wpXdJe9/7HT8C0duWwrQR1iudhncLTy/mk0hBYilpQ0pIwSnAbvwqCq EhATp8vkyJYdHxuWMxO31UHyDVtIhlrjJ9Ls6FZlxDaYgAYSIP2hGrsQwtPWuL0W+Kx43x11 9ZO6V7BNyw7K7nR6oCVli9g8eYsjz8HSyJJUrUeZGPp9AquHmNYixgDmyL/d0+ERdHiAmmeO AcOV8ytxZgZPrt7LUSfO4jIUJfzM6Uimf81r4abNrZVXQE1CQicpmxe6fcM8pornww4/oasH dOeBHHJh7pE6MGFtQPOwyJ69nKFzWopiuI+NdUH0GET5x8qGuYorCsWimSU3oqjkbDIIVkTy XKKByY2Pj4wqpRYo8y69KhD3bvyCljXVAS4+IlDaRE9tifWXCmED4sp7xlJc7BioVhqKe49j ERa/CckeUQA1pOj5VkbgJS+LQ/wGtlJLysuKVsD+oeDHbKxU543ToX3uCPiLgQ2/gQyU5Vif 219IyZrlj76iHYsXlX1fxFmp/W5HdxInJmPg53QwUm5EaecpQVQWwKhkjIRZ6zw+cf/i48pg yVrasNS6tCKh8EscdPa3mI95TxbaV/JG4QQnls7BTQRKxtXtARAA7GPiFOf9+6nry0TPUGNi Kll9G7OeSX1MtK5aba9LmUFUym+YpebOIhI7ndCyyWVTTlyrJNXbn0qhXDLbaR/X94Y+c1S4 y+a/w4jMFFm9SuNr1J76vSJN3WqjhGaLLG+UU6wvqSUnIcCws4nx4IY7va29+2oeEUut7o3A I6IK40xLs/TrktfeTKj01HhD2VLMslCyaeTCwezVWaWXWAGARS43jRDA4P9sEE9Il4/4+9ph zfD4AoWfl9bPaCPzuvLIvlpDHlu7zyErw6aZg7Zs8sYvI7MvZL3uf8exWzPTJwzcwNMwmeCc dLC1PiNGYXd2wldV2oYDl+mbPNmsC92zejb9n6dJnKv7FECecfMHEJVwV04R9tLLwH0FH9dI 6zsCQwI6uU9PXP8/Pb0ei7zoAewKIQv/PCqcxywzmMALUpANbqfXNPPS9Yf6niq2ti5se/+S IAdgbMekGBnlMFpddwPLOlMvjxOrFEX7xIWnNbTKPy29W8h6hBlVaofmA0Vu8rcCywrEkx4M 3/C1CHoFJ6gXFhm8+KJC7w3YOdWyz4NcRnaMtqrvklRgCUtN/qHdSBUy6tDzLMwPhgTuPG75 pGfRrZ8MjfBMmL5v+V3Ev+6hQAJ6AZaBsq1uksSQ+MZOBxeWt/bYCyH92OqnJU2K473dNrOj sqJRTyohB1JdmxMAEQEAAcLBXwQYAQIACQUCSsbV7QIbDAAKCRD7p+62e0p4wthPD/wO5y8u pCH4IgkZjL0NuQenwvKoTqg3M/PHJEQzaMdK5dblA5nKZ6LnLmRtHd3NOvFfYvlrl+xnLQtj 8CNPiNKH2/mHEWHPJqeI27kcbhcABFdmbia+rLsf3VV9+/sqoa1dkxoM6lTrgZ57DLzuHuWk R9cEjmK2PxLyVgy/cmnDqJ/FK/4vGdrukKWeTjL/SsGZWZ7JwB0Okdrmnlq7T86csT3+1UiV ZQsm9a3WwoVzmhZomQwpi1Qw687MLtnetqEXr2cPNHTuDMnTVLVib3GhlTj3/Ylfpx8pS0vc 51KZ342RdeUHrGyQ1okxrwVAFzE2/FEO3mJtHMt0rJYLgnICuf0cBX70uxFTDnOuGrwtNVR8 0IMR8+vIhD/Cwc0hScQr9fCzm3VhFGSXyOChmRIg5fmftmgy19aSdysOMQAv6wap2azMvZQ7 CAZ9EvO5PioYA4YytfR2l9+CYWxzgaqjsYLiVwt4Y0lhehVQsgfygIaJA4mMf8ec9f/humVj t1EjwCS8KWeoLH8ZRv8SfHUfCirdP/leAVMkbrw4iOcNUIsrE4lpxX6lK3iNgfmpqRJzbqyK ihpcmiI2qVKtoLwiU1aOddEK09hzR5uqTDydir5EIgd3leb2wpxpjve0HEaXY4EATvq2GgkI /lur6FDTs6srRT3Ys6HAyQgyp4atUQ== Message-ID: Date: Wed, 23 Dec 2020 12:49:47 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0 Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org X-Auto-Response-Suppress: DR, RN, NRN, OOF, AutoReply MIME-Version: 1.0 In-Reply-To: <65eaf969-7e6d-d95f-cb3b-ee294ec46f0e@sys-concept.com> Content-Type: text/plain; charset=utf-8 Content-Language: en-CA Content-Transfer-Encoding: 7bit X-CTCH-RefID: str=0001.0A742F15.5FE39F4E.0045:SCFSTAT54230205,ss=1,re=-4.000,recu=0.000,reip=0.000,cl=1,cld=1,fgs=0 X-CTCH-VOD: Unknown X-CTCH-Spam: Unknown X-CTCH-Score: -4.000 X-CTCH-Rules: X-CTCH-Flags: 0 X-CTCH-ScoreCust: 0.000 X-CSC: 0 X-CHA: v=2.3 cv=ap/M9hRV c=1 sm=1 tr=0 a=u3gW5Uk2xAGXuEgp5FffjQ==:117 a=u3gW5Uk2xAGXuEgp5FffjQ==:17 a=IkcTkHD0fZMA:10 a=046jbqsEAAAA:8 a=SIpmopTwAAAA:8 a=LYE8e4OgxRgb-l1QgTUA:9 a=QEXdDO2ut3YA:10 a=bGzDz6Hpkc7_N_b525It:22 a=8g6pKF-7mFRWXTnqlU1C:22 X-VADE-SPAMSTATE: clean X-VADE-SPAMSCORE: 0 X-VADE-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrgedujedrvddtjedgudeftdcutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfjqffuvffqrffktedpqfgfvfenuceurghilhhouhhtmecufedttdenucenucfjughrpefuhffvfhfkffgfgggjtgfgsehtjeertddtfeejnecuhfhrohhmpehthhgvlhhmrgesshihshdqtghonhgtvghpthdrtghomhenucggtffrrghtthgvrhhnpedtgfejhedukeefffevgedvgeetveehudeiveegleefheehteeihfevfeffkeffgeenucffohhmrghinheprghsthgvrhhishhkrdhorhhgnecukfhppedukeegrdeiledrvdegvddrudeknecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehinhgvthepudekgedrieelrddvgedvrddukedphhgvlhhopegluddtrddtrddtrddutdefngdpmhgrihhlfhhrohhmpehthhgvlhhmrgesshihshdqtghonhgtvghpthdrtghomhdprhgtphhtthhopehgvghnthhoohdquhhsvghrsehlihhsthhsrdhgvghnthhoohdrohhrgh X-Origin-Country: CA X-Archives-Salt: 38d93857-ac9a-4828-ae7a-ad70fdbc2826 X-Archives-Hash: 2dc07a6ebf8d6f18d5fa3a22dd2bb06c On 12/23/2020 12:47 PM, thelma@sys-concept.com wrote: > When I try to register provision/register equipment to asterisk I get an error message: > > [Dec 23 12:32:51] WARNING[21685]: db.c:350 ast_db_put: Couldn't execute statement: SQL logic error > -- Registered SIP 'pstn-5665' at 10.0.0.110:5060 > > Saved useragent "Audiocodes-Sip-Gateway-/v.5.80A.032.003" for peer pstn-5665 > [Dec 23 12:32:51] WARNING[21685]: db.c:350 ast_db_put: Couldn't execute statement: SQL logic error > -- Registered SIP 'pstn-1270' at 10.0.0.110:5060 > > Saved useragent "Audiocodes-Sip-Gateway-/v.5.80A.032.003" for peer pstn-1270 > [Dec 23 12:32:51] NOTICE[21685]: chan_sip.c:24776 handle_response_peerpoke: Peer 'pstn-5665' is now Reachable. (61ms / 2000ms) > [Dec 23 12:32:51] WARNING[21685]: db.c:350 ast_db_put: Couldn't execute statement: attempt to write a readonly database > -- Registered SIP '369' at 10.0.0.110:5060 > > /var/lib/asterisk > -rw-r--r-- 1 root root 16384 Dec 23 12:10 astdb.sqlite3 > > In my old asterisk-11.25 this file has owner "asterisk:astersik" but changing the ownership of that file doesn't solve the problem, still getting the same error: > > ast_db_put: Couldn't execute statement: attempt to write a readonly database To solve it, I tried to follow the steps from: https://community.asterisk.org/t/asterisk-warning/78443 But it didn't help.