[solved]Sip-clients cannot register

Asterisk Asterisk SIP
1

Hi, since my Ubuntu-upgrade killed my asterisk installation too, I think it was 1.6, I decided to set up Asterisk 18 on the new system (Ubuntu 20.04). I wanted to switch to pjsip too.

Now none of my phones can register. I get messages like:

[Nov 28 17:45:20] WARNING[4982]: db.c:348 ast_db_put: Couldn't execute statement: SQL logic error

[Nov 28 17:45:20] ERROR[4982]: res_pjsip_registrar.c:776 register_aor_core: Unable to bind contact 'sip:25@192.168.129.163:2048' to AOR '25'

Ich denke meine pjsip.conf ist OK

[transport-udp]
type=transport
protocol=udp
bind=0.0.0.0

;;;;;;;;;;;;;;;; SN4112 ;;;;;;;;;;;;;;;;;;;;;;;;
[sn4112]
type=endpoint
context=amt-in
disallow=all
allow=alaw
allow=ulaw
auth=sn4112
aors=sn4112

[sn4112]
type=auth
auth_type=userpass
password=2114
username=sn4112

auth_type=userpass
password=1234         ; not really :-)
username=sn4112
[sn4112]
type=aor
max_contacts=1

[11]
type=endpoint
context=z
disallow=all
allow=alaw
auth=11
aors=11

[11]
type=auth
auth_type=md5
md5_cred=4f6d6890e6
username=11

[11]
type=aor
max_contacts=1

[16]
type=endpoint
context=p
disallow=all
allow=alaw
auth=16
aors=16

[16]
type=auth
auth_type=userpass              
password=5678
username=16

[16]
type=aor
max_contacts=1

Habt ihr eine Idee?
Danke im Voraus, Karl

2

where is the endpoint configuration for 25 ?

3

Hi, it is in pjsip.conf too. I did not recognize, that the file was not copied completely. Sorry!

[25]
type=endpoint
context=z
disallow=all
allow=alaw
auth=25
aors=25

[25]
type=auth
auth_type=md5
md5_cred=1619f6ca9247fb5728adf4206512c437
username=25

[25]
type=aor
max_contacts=1

4

Hi,
after googling again I found the hint to look after access rights for /var /lib/asterisk/astdb.sqlite3
After I set user and group to asterisk.asterisk (the user I am running asterisk) it now works and

pjsip show aors

shows all clients with contacts.
So thank you to everybody who tried to figure out my problem.
Best, Karl