Gentoo Archives: gentoo-user

From: thelma@×××××××××××.com
To: Gentoo mailing list <gentoo-user@l.g.o>
Subject: Re: [gentoo-user] Asterisk 13.36 - ast_db_put: Couldn't execute statement: attempt to write a readonly database
Date: Wed, 23 Dec 2020 19:49:39
Message-Id: d5c91819-3a24-2fb4-4105-9886ff401792@sys-concept.com
In Reply to: [gentoo-user] Asterisk 13.36 - ast_db_put: Couldn't execute statement: attempt to write a readonly database by thelma@sys-concept.com
1 On 12/23/2020 12:47 PM, thelma@×××××××××××.com wrote:
2 > When I try to register provision/register equipment to asterisk I get an error message:
3 >
4 > [Dec 23 12:32:51] WARNING[21685]: db.c:350 ast_db_put: Couldn't execute statement: SQL logic error
5 > -- Registered SIP 'pstn-5665' at 10.0.0.110:5060
6 > > Saved useragent "Audiocodes-Sip-Gateway-/v.5.80A.032.003" for peer pstn-5665
7 > [Dec 23 12:32:51] WARNING[21685]: db.c:350 ast_db_put: Couldn't execute statement: SQL logic error
8 > -- Registered SIP 'pstn-1270' at 10.0.0.110:5060
9 > > Saved useragent "Audiocodes-Sip-Gateway-/v.5.80A.032.003" for peer pstn-1270
10 > [Dec 23 12:32:51] NOTICE[21685]: chan_sip.c:24776 handle_response_peerpoke: Peer 'pstn-5665' is now Reachable. (61ms / 2000ms)
11 > [Dec 23 12:32:51] WARNING[21685]: db.c:350 ast_db_put: Couldn't execute statement: attempt to write a readonly database
12 > -- Registered SIP '369' at 10.0.0.110:5060
13 >
14 > /var/lib/asterisk
15 > -rw-r--r-- 1 root root 16384 Dec 23 12:10 astdb.sqlite3
16 >
17 > 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:
18 >
19 > ast_db_put: Couldn't execute statement: attempt to write a readonly database
20
21 To solve it, I tried to follow the steps from:
22 https://community.asterisk.org/t/asterisk-warning/78443
23
24 But it didn't help.