Erreur asterisk impossible de si conneter avec smartphone Csipsimple

[xunil2003]

Bonjour,

J'ai installer sur mon raspberry Pi 3 asterisk.

sudo apt install update
sudo apt install asterisk
sudo apt-get install asterisk-core-sounds-fr
sudo apt-get install asterisk-core-sounds-fr-wav

Après avoir configurer sip.conf et extensions.conf, j'ai un message d'erreur dans la console CLI d'Asterisk.

Ma config

Fichier sip.conf

[general]
defaultexpirey=1800
dtmfmode=auto
qualify=yes

[salon]
type=friend
username=poste11
qualify=no
secret=11
host=dynamic
context=maison
language=fr

[bureau]
type=friend
username=poste21
qualify=no
secret=21
host=dynamic
context=maison
language=fr

Fichier extensions.conf

[maison]
exten => 11,1,Dial(SIP/salon)
exten => 12,1,Dial(SIP/bureau)

Le message d'erreur de la console de asterisk

Asterisk 13.14.1~dfsg-2+deb9u3, Copyright (C) 1999 - 2014, Digium, Inc. and others.
Created by Mark Spencer <markster@digium.com>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
================================================== =======================
Connected to Asterisk 13.14.1~dfsg-2+deb9u3 currently running on raspberrypi (pid = 7232)
[Jul 19 18:35:36] NOTICE[7291]: chan_sip.c:28499 handle_request_register: Registration from '<sip:poste21@192.168.1.32>' failed for '192.168.1.26:5060' - Wrong password
raspberrypi*CLI>
Disconnected from Asterisk server
Asterisk cleanly ending (0).
Executing last minute cleanups

Il me dit que mon mot de passe et faut ?
pourtant j'ai bien indiqué à mon smartphone (application android CsipSimple) :

Nom du compte : Asterisk
Utilisateur : poste21
Serveur : 192.168.1.32
Mot de passe : 21

Les ports

serveur@raspberrypi:~ $ sudo netstat -paunt | grep 5060
udp 0 0 0.0.0.0:5060 0.0.0.0:* 7232/asterisk
serveur@raspberrypi:~ $
serveur@raspberrypi:~ $ sudo netstat -paunt | grep asterisk
tcp 0 0 127.0.0.1:5038 0.0.0.0:* LISTEN 7232/asterisk
tcp 0 0 0.0.0.0:2000 0.0.0.0:* LISTEN 7232/asterisk
udp 0 0 0.0.0.0:5000 0.0.0.0:* 7232/asterisk
udp 0 0 0.0.0.0:4520 0.0.0.0:* 7232/asterisk
udp 0 0 0.0.0.0:5060 0.0.0.0:* 7232/asterisk
udp 0 0 0.0.0.0:4569 0.0.0.0:* 7232/asterisk
udp 0 0 0.0.0.0:58504 0.0.0.0:* 7232/asterisk
udp 0 0 0.0.0.0:2727 0.0.0.0:* 7232/asterisk
udp6 0 0 :::57238 :::* 7232/asterisk
serveur@raspberrypi:~ $
-

Pouvez-vous m'aider ?

Merci.

[olppp]

Bonjour,



Fichier sip.conf

[general]
defaultexpirey=1800
dtmfmode=auto
qualify=yes

[salon]
type=friend
username=11
qualify=no
secret=11
host=dynamic
context=maison
language=fr

[bureau]
type=friend
username=poste21
qualify=no
secret=21
host=dynamic
context=maison
language=fr



le nom du compte = bureau

[xunil2003]

Bonjour,

Ok donc le non du compte est l'identifiant de connexion qui est bureau et non pas poste21.
J'ai des erreurs dans la console CLI



serveur@raspberrypi:~ $ sudo asterisk -rvvv
Asterisk 13.14.1~dfsg-2+deb9u3, Copyright (C) 1999 - 2014, Digium, Inc. and others.
Created by Mark Spencer <markster@digium.com>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
================================================== =======================
Connected to Asterisk 13.14.1~dfsg-2+deb9u3 currently running on raspberrypi (pid = 12232)
-- Registered SIP 'bureau' at 192.168.1.26:5060
[Jul 20 04:10:30] WARNING[12233]: db.c:288 db_execute_sql: Error executing SQL (COMMIT): database is locked
[Jul 20 04:10:30] NOTICE[12290]: chan_sip.c:28276 handle_request_subscribe: Received SIP subscribe for peer without mailbox: bureau
[Jul 20 04:11:17] WARNING[12435][C-00000000]: app_dial.c:2525 dial_exec_full: Unable to create channel of type 'SIP' (cause 20 - Subscriber absent)
== Everyone is busy/congested at this time (1:0/0/1)
-- Auto fallthrough, channel 'SIP/bureau-00000000' status is 'CHANUNAVAIL'
[Jul 20 04:11:30] NOTICE[12290]: chan_sip.c:28276 handle_request_subscribe: Received SIP subscribe for peer without mailbox: bureau
[Jul 20 04:16:31] NOTICE[12290]: chan_sip.c:28276 handle_request_subscribe: Received SIP subscribe for peer without mailbox: bureau
[Jul 20 04:21:32] NOTICE[12290]: chan_sip.c:28276 handle_request_subscribe: Received SIP subscribe for peer without mailbox: bureau
== Using SIP RTP CoS mark 5
-- Executing [11@maison:1] Dial("SIP/bureau-00000004", "SIP/salon") in new stack
[Jul 20 04:34:55] WARNING[12522][C-0000000b]: app_dial.c:2525 dial_exec_full: Unable to create channel of type 'SIP' (cause 20 - Subscriber absent)
== Everyone is busy/congested at this time (1:0/0/1)
-- Auto fallthrough, channel 'SIP/bureau-00000004' status is 'CHANUNAVAIL'
== Using SIP RTP CoS mark 5
-- Executing [11@maison:1] Dial("SIP/bureau-00000005", "SIP/salon") in new stack
[Jul 20 04:35:17] WARNING[12526][C-0000000c]: app_dial.c:2525 dial_exec_full: Unable to create channel of type 'SIP' (cause 20 - Subscriber absent)
== Everyone is busy/congested at this time (1:0/0/1)
-- Auto fallthrough, channel 'SIP/bureau-00000005' status is 'CHANUNAVAIL'
[Jul 20 04:36:36] NOTICE[12290]: chan_sip.c:28276 handle_request_subscribe: Received SIP subscribe for peer without mailbox: bureau
-- Unregistered SIP 'bureau'
[Jul 20 04:36:57] WARNING[12233]: db.c:288 db_execute_sql: Error executing SQL (COMMIT): database is locked
[Jul 20 04:37:00] WARNING[12233]: db.c:288 db_execute_sql: Error executing SQL (COMMIT): database is locked
-- Registered SIP 'bureau' at 192.168.1.26:5060
[Jul 20 04:37:00] NOTICE[12290]: chan_sip.c:28276 handle_request_subscribe: Received SIP subscribe for peer without mailbox: bureau
raspberrypi*CLI>

Merci.

[olppp]

[Jul 20 04:10:30] WARNING[12233]: db.c:288 db_execute_sql: Error executing SQL (COMMIT): database is locked

sûrement un problème de droit d'accès à la base de donnée.



[Jul 20 04:10:30] NOTICE[12290]: chan_sip.c:28276 handle_request_subscribe: Received SIP subscribe for peer without mailbox: bureau

pas de boîte vocale pour le compte bureau et le poste correspondant cherche à obtenir l'état de la messagerie (mwi on)
ajoutes une boîte vocale aux comptes, à créer dans voicemail.conf !



[Jul 20 04:11:17] WARNING[12435][C-00000000]: app_dial.c:2525 dial_exec_full: Unable to create channel of type 'SIP' (cause 20 - Subscriber absent)
== Everyone is busy/congested at this time (1:0/0/1)
-- Auto fallthrough, channel 'SIP/bureau-00000000' status is 'CHANUNAVAIL'

le poste du bureau est mal enregistré ou en mode DND.
regarde le retours de la commande


sip show peer bureau

dans la console
si le poste est correctement enregistré tu dois voir son adresse IP.



Addr->IP : 192.168.96.55:5060
Defaddr->IP : 192.168.96.55:5060
Status : Unmonitored
Useragent : Aastra 6735i/3.3.1.8215
Reg. Contact : sip:xxxxxxxxxxxx@192.168.96.55:5060;transport=udp

[xunil2003]

Bonjour,

Tout d'abord je tiens à vous remercie de votre aide.

Ok je vais me documenté sur le net pour créer la boite vocale.
Voici le retour de la commande

Avec le minimum d'informations


serveur@raspberrypi:~ $ sudo asterisk -rx 'sip show peer bureau' | grep 'Addr->IP'
Addr->IP : 192.168.1.26:5060
serveur@raspberrypi:~ $
serveur@raspberrypi:~ $ sudo asterisk -rx 'sip show peer bureau' | grep 'Defaddr->IP'
Defaddr->IP : (null)
serveur@raspberrypi:~ $
serveur@raspberrypi:~ $ sudo asterisk -rx 'sip show peer bureau' | grep 'Status'
Status : Unmonitored
serveur@raspberrypi:~ $
serveur@raspberrypi:~ $ sudo asterisk -rx 'sip show peer bureau' | grep 'Useragent'
Useragent : CSipSimple_trelte-23/r2457
serveur@raspberrypi:~ $
serveur@raspberrypi:~ $ sudo asterisk -rx 'sip show peer bureau' | grep 'Reg. Contact'
Reg. Contact : sip:bureau@192.168.1.26:5060;ob
serveur@raspberrypi:~ $


Avec plus de détails

serveur@raspberrypi:~ $ sudo asterisk -rvvv
Asterisk 13.14.1~dfsg-2+deb9u3, Copyright (C) 1999 - 2014, Digium, Inc. and others.
Created by Mark Spencer <markster@digium.com>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
================================================== =======================
Connected to Asterisk 13.14.1~dfsg-2+deb9u3 currently running on raspberrypi (pid = 12232)
raspberrypi*CLI> sip show peer bureau


* Name : bureau
Description :
Secret : <Set>
MD5Secret : <Not set>
Remote Secret: <Not set>
Context : maison
Record On feature : automon
Record Off feature : automon
Subscr.Cont. : <Not set>
Language : fr
Tonezone : <Not set>
AMA flags : Unknown
Transfer mode: open
CallingPres : Presentation Allowed, Not Screened
Callgroup :
Pickupgroup :
Named Callgr :
Nam. Pickupgr:
MOH Suggest :
Mailbox :
VM Extension : asterisk
LastMsgsSent : 32767/65535
Call limit : 0
Max forwards : 0
Dynamic : Yes
Callerid : "" <>
MaxCallBR : 384 kbps
Expire : 522
Insecure : no
Force rport : Auto (No)
Symmetric RTP: No
ACL : No
DirectMedACL : No
T.38 support : No
T.38 EC mode : Unknown
T.38 MaxDtgrm: 4294967295
DirectMedia : Yes
PromiscRedir : No
User=Phone : No
Video Support: No
Text Support : No
Ign SDP ver : No
Trust RPID : No
Send RPID : No
Path support : No
Path : N/A
TrustIDOutbnd: Legacy
Subscriptions: Yes
Overlap dial : Yes
DTMFmode : auto
Timer T1 : 500
Timer B : 32000
ToHost :
Addr->IP : 192.168.1.26:5060
Defaddr->IP : (null)
Prim.Transp. : UDP
Allowed.Trsp : UDP
Def. Username: poste21
SIP Options : (none)
Codecs : (ulaw|alaw|gsm|h263)
Auto-Framing : No
Status : Unmonitored
Useragent : CSipSimple_trelte-23/r2457
Reg. Contact : sip:bureau@192.168.1.26:5060;ob
Qualify Freq : 60000 ms
Keepalive : 0 ms
Sess-Timers : Accept
Sess-Refresh : uas
Sess-Expires : 1800 secs
Min-Sess : 90 secs
RTP Engine : asterisk
Parkinglot :
Use Reason : No
Encryption : No

raspberrypi*CLI>


Concernant le problème de droit d'accès à la base de donnée, comment je doit procéder pour résoudre le problème ?

[Jul 20 04:10:30] WARNING[12233]: db.c:288 db_execute_sql: Error executing SQL (COMMIT): database is locked

Merci.

[olppp]

pour l'appel vers bureau certainement un réglage de csipsimple :
- il y a une option à activer pour toujours recevoir les appels (attention à la batterie) et si le compte est actif seulement pour une connexion par wifi ou aussi sur la data 3g/4g


- le smartphone coupe peut-être le wifi en mode veille.

pour la base de données monte le niveau de détails dans la console pour récupérer plus d'infos.



core set verbose 5

[xunil2003]

Re,

Voici le retour de la commande


serveur@raspberrypi:~ $ sudo asterisk -rvvv
Asterisk 13.14.1~dfsg-2+deb9u3, Copyright (C) 1999 - 2014, Digium, Inc. and others.
Created by Mark Spencer <markster@digium.com>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
================================================== =======================
Connected to Asterisk 13.14.1~dfsg-2+deb9u3 currently running on raspberrypi (pid = 12232)
[Jul 20 12:15:20] NOTICE[12290]: chan_sip.c:28276 handle_request_subscribe: Received SIP subscribe for peer without mailbox: salon
[Jul 20 12:16:39] NOTICE[12290]: chan_sip.c:28276 handle_request_subscribe: Received SIP subscribe for peer without mailbox: bureau
[Jul 20 12:21:49] WARNING[12233]: db.c:288 db_execute_sql: Error executing SQL (COMMIT): database is locked
raspberrypi*CLI> core set verbose 5
Console verbose was 3 and is now 5.
raspberrypi*CLI>

Merci.

[olppp]

tu as installer une base de donnée sur le raspberry ? postgresql ou mysql ?

résultats de la commande


cdr show status

et


odbc show all

[xunil2003]

re,

voici le retour


raspberrypi*CLI> cdr show status

Call Detail Record (CDR) settings
----------------------------------
Logging: Enabled
Mode: Simple
Log unanswered calls: No
Log congestion: No

* Registered Backends
-------------------
csv
cdr_manager (suspended)
Adaptive ODBC
cdr-custom
res_config_sqlite

raspberrypi*CLI>

raspberrypi*CLI> odbc show all

ODBC DSN Settings
-----------------

raspberrypi*CLI>
j'ai installé dans l'ordre :

1 : APACHE
2 : PHP
3 : SQL
4 : PHPMYADMIN
Pour realiser un serveur multi-fonction avec le raspberry (domotique, serveur web, serveur ftp, serveur dlna, etc...)

Merci.

[olppp]

Dans le fichier /etc/asterisk/modules.conf
ajoutes ou vérifies l'existence de ces lignes et relance Asterisk !
suivi des com en fichier csv uniquement



noload => cdr_odbc.so
noload => cdr_radius.so
noload => cdr_adaptive_odbc.so
noload => cdr_sqlite3_custom.so
noload => cdr_custom.so
noload => cdr_tds.so
noload => cdr_syslog.so
noload => cdr_mysql.so
; cdr.db without a way to rotate it.
noload => cdr_sqlite.so


si tu veux le suivi des communications en base de données (mysql) il faut un paquet supplémentaire asterisk-mysql et créer la/les tables qui vont bien

[olppp]

pareil pour le voicemail tu peux choisir entre 3 paquets :
asterisk-voicemail = stockage en fichiers "plats"
asterisk-voicemail-imapstorage = stockage sur serveur imap
asterisk-voicemail-odbcstorage = stockage sur serveur base de données SQL

contrairement au CDR tu ne peux avoir qu'un seul backend.

[xunil2003]

re,

La console CLi me dit toujours que sql bloc

[Jul 20 14:36:45] WARNING[17827]: db.c:288 db_execute_sql: Error executing SQL (COMMIT): database is locked


serveur@raspberrypi:~ $ sudo asterisk -rvvv
Asterisk 13.14.1~dfsg-2+deb9u3, Copyright (C) 1999 - 2014, Digium, Inc. and others.
Created by Mark Spencer <markster@digium.com>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
================================================== =======================
Connected to Asterisk 13.14.1~dfsg-2+deb9u3 currently running on raspberrypi (pid = 17824)
[Jul 20 14:35:32] NOTICE[17872]: chan_sip.c:28276 handle_request_subscribe: Received SIP subscribe for peer without mailbox: salon
[Jul 20 14:36:45] NOTICE[17872]: chan_sip.c:28276 handle_request_subscribe: Received SIP subscribe for peer without mailbox: bureau
-- Registered SIP 'bureau' at 192.168.1.26:5060
[Jul 20 14:36:45] WARNING[17827]: db.c:288 db_execute_sql: Error executing SQL (COMMIT): database is locked
[Jul 20 14:36:45] NOTICE[17872]: chan_sip.c:28276 handle_request_subscribe: Received SIP subscribe for peer without mailbox: bureau
raspberrypi*CLI>

fichier : /etc/asterisk/modules.conf

serveur@raspberrypi:~ $ sudo cat /etc/asterisk/modules.conf
;
; Asterisk configuration file
;
; Module Loader configuration file
;

[modules]
autoload=yes
;
; Any modules that need to be loaded before the Asterisk core has been
; initialized (just after the logger has been initialized) can be loaded
; using 'preload'. This will frequently be needed if you wish to map all
; module configuration files into Realtime storage, since the Realtime
; driver will need to be loaded before the modules using those configuration
; files are initialized.
;
; An example of loading ODBC support would be:
;preload => res_odbc.so
;preload => res_config_odbc.so
;
; If you want, load the GTK console right away.
; Don't load the KDE console since
; it's not as sophisticated right now.
;
noload => pbx_gtkconsole.so
;load => pbx_gtkconsole.so
noload => pbx_kdeconsole.so
;
; Intercom application is obsoleted by
; chan_oss. Don't load it.
;
noload => app_intercom.so
;
; The 'modem' channel driver and its subdrivers are
; obsolete, don't load them.
;
noload => chan_modem.so
noload => chan_modem_aopen.so
noload => chan_modem_bestdata.so
noload => chan_modem_i4l.so
;
; Comment this out (after installing CAPI middleware and hardware
; drivers) if you have CAPI-able hardware and wish to use it in
; Asterisk.
;
noload => chan_capi.so
;
load => res_musiconhold.so
;
; Load either OSS or ALSA, not both
; By default, load OSS only (automatically) and do not load ALSA
;
noload => chan_alsa.so
;noload => chan_oss.so
;
; Disable CDR logging to SQLite by default since it writes unconditionally to
; cdr.db without a way to rotate it.
;
noload => cdr_sqlite.so
;
; These conflict with app_directory.so and each other.
noload => app_directory_odbc.so
;
; Enable these if you want to configure Asterisk in a database
;
noload => res_config_odbc.so
noload => res_config_pgsql.so
;
; Module names listed in "global" section will have symbols globally
; exported to modules loaded after them.
;
[global]
noload => cdr_odbc.so
noload => cdr_radius.so
noload => cdr_adaptive_odbc.so
noload => cdr_sqlite3_custom.so
noload => cdr_custom.so
noload => cdr_tds.so
noload => cdr_syslog.so
noload => cdr_mysql.so
; cdr.db without a way to rotate it.
noload => cdr_sqlite.so
serveur@raspberrypi:~ $

suivi de :

serveur@raspberrypi:~ $ sudo /etc/init.d/asterisk restart
[ ok ] Restarting asterisk (via systemctl): asterisk.service.
serveur@raspberrypi:~ $

Merci.

[olppp]

à essayer :
1 vérifier que le fichier /var/lib/asterisk/astdb.sqlite3 appartient à asterisk:asterisk avec droit en écriture



ls -l /var/lib/asterisk/astdb.sqlite3 /etc/asterisk
-rw-r----- 1 asterisk asterisk 17K juil. 20 17:07 /var/lib/asterisk/astdb.sqlite3

si non régler les problèmes d'accès

si oui
arrêter Asterisk
déplacer/renommer le fichier /var/lib/asterisk/astdb.sqlite3
relancer Asterisk qui doit le recréer, c'est un fichier "interne" à l'appli.

[xunil2003]

Re,

Voici le retour


serveur@raspberrypi:~ $ ls -l /var/lib/asterisk/astdb.sqlite3 /etc/asterisk
-rw-r--r-- 1 asterisk asterisk 12288 juil. 19 22:45 /var/lib/asterisk/astdb.sqlite3

/etc/asterisk:
total 1024
-rw-r----- 1 asterisk asterisk 2816 d�c. 29 2017 acl.conf
-rw-r----- 1 asterisk asterisk 140 d�c. 29 2017 adsi.conf
-rw-r----- 1 asterisk asterisk 2097 d�c. 29 2017 agents.conf
-rw-r----- 1 asterisk asterisk 2328 d�c. 29 2017 alarmreceiver.conf
-rw-r----- 1 asterisk asterisk 3498 d�c. 29 2017 alsa.conf
-rw-r----- 1 asterisk asterisk 1454 d�c. 29 2017 amd.conf
-rw-r----- 1 asterisk asterisk 1044 d�c. 29 2017 app_mysql.conf
-rw-r----- 1 asterisk asterisk 338 d�c. 29 2017 app_skel.conf
-rw-r----- 1 asterisk asterisk 1315 d�c. 29 2017 ari.conf
-rw-r----- 1 asterisk asterisk 2024 d�c. 29 2017 ast_debug_tools.conf
-rw-r----- 1 asterisk asterisk 3254 d�c. 29 2017 asterisk.adsi
-rw-r----- 1 asterisk asterisk 4958 d�c. 29 2017 asterisk.conf
-rw-r----- 1 asterisk asterisk 5171 d�c. 29 2017 calendar.conf
-rw-r----- 1 asterisk asterisk 8827 d�c. 29 2017 ccss.conf
-rw-r----- 1 asterisk asterisk 2580 d�c. 29 2017 cdr_adaptive_odbc.conf
-rw-r----- 1 asterisk asterisk 8231 d�c. 29 2017 cdr.conf
-rw-r----- 1 asterisk asterisk 1617 d�c. 29 2017 cdr_custom.conf
-rw-r----- 1 asterisk asterisk 418 d�c. 29 2017 cdr_manager.conf
-rw-r----- 1 asterisk asterisk 2401 d�c. 29 2017 cdr_mysql.conf
-rw-r----- 1 asterisk asterisk 357 d�c. 29 2017 cdr_odbc.conf
-rw-r----- 1 asterisk asterisk 597 d�c. 29 2017 cdr_pgsql.conf
-rw-r----- 1 asterisk asterisk 949 d�c. 29 2017 cdr_sqlite3_custom.conf
-rw-r----- 1 asterisk asterisk 3301 d�c. 29 2017 cdr_syslog.conf
-rw-r----- 1 asterisk asterisk 2068 d�c. 29 2017 cdr_tds.conf
-rw-r----- 1 asterisk asterisk 3806 d�c. 29 2017 cel.conf
-rw-r----- 1 asterisk asterisk 2035 d�c. 29 2017 cel_custom.conf
-rw-r----- 1 asterisk asterisk 3155 d�c. 29 2017 cel_odbc.conf
-rw-r----- 1 asterisk asterisk 1352 d�c. 29 2017 cel_pgsql.conf
-rw-r----- 1 asterisk asterisk 1526 d�c. 29 2017 cel_sqlite3_custom.conf
-rw-r----- 1 asterisk asterisk 1883 d�c. 29 2017 cel_tds.conf
-rw-r----- 1 asterisk asterisk 68448 d�c. 29 2017 chan_dahdi.conf
-rw-r----- 1 asterisk asterisk 2228 d�c. 29 2017 chan_mobile.conf
-rw-r----- 1 asterisk asterisk 7226 d�c. 29 2017 cli_aliases.conf
-rw-r----- 1 asterisk asterisk 264 d�c. 29 2017 cli.conf
-rw-r----- 1 asterisk asterisk 2452 d�c. 29 2017 cli_permissions.conf
-rw-r----- 1 asterisk asterisk 7694 d�c. 29 2017 codecs.conf
-rw-r----- 1 asterisk asterisk 24772 d�c. 29 2017 confbridge.conf
-rw-r----- 1 asterisk asterisk 695 d�c. 29 2017 config_test.conf
-rw-r----- 1 asterisk asterisk 4456 d�c. 29 2017 console.conf
-rw-r----- 1 asterisk asterisk 1164 d�c. 29 2017 dbsep.conf
-rw-r----- 1 asterisk asterisk 190 d�c. 29 2017 dnsmgr.conf
-rw-r----- 1 asterisk asterisk 1733 d�c. 29 2017 dsp.conf
-rw-r----- 1 asterisk asterisk 9034 d�c. 29 2017 dundi.conf
-rw-r----- 1 asterisk asterisk 592 d�c. 29 2017 enum.conf
-rw-r----- 1 asterisk asterisk 4033 d�c. 29 2017 extconfig.conf
-rw-r----- 1 asterisk asterisk 12776 d�c. 29 2017 extensions.ael
-rw-r----- 1 asterisk asterisk 2033 juil. 20 14:13 extensions.conf
-rw-r----- 1 root root 31644 juil. 19 00:32 extensions.conf.old
-rw-r----- 1 root root 33591 juil. 20 04:04 extensions.conf.plugcomputer
-rw-r----- 1 asterisk asterisk 7023 d�c. 29 2017 extensions.lua
-rw-r----- 1 asterisk asterisk 7471 d�c. 29 2017 extensions_minivm.conf
-rw-r----- 1 asterisk asterisk 8129 d�c. 29 2017 features.conf
-rw-r----- 1 asterisk asterisk 923 d�c. 29 2017 festival.conf
-rw-r----- 1 asterisk asterisk 3881 d�c. 29 2017 followme.conf
-rw-r----- 1 asterisk asterisk 5881 d�c. 29 2017 func_odbc.conf
-rw-r----- 1 asterisk asterisk 1099 d�c. 29 2017 hep.conf
-rw-r----- 1 asterisk asterisk 5387 d�c. 29 2017 http.conf
-rw-r----- 1 asterisk asterisk 26377 d�c. 29 2017 iax.conf
-rw-r----- 1 asterisk asterisk 2402 d�c. 29 2017 iaxprov.conf
-rw-r----- 1 asterisk asterisk 25367 d�c. 29 2017 indications.conf
-rw-r----- 1 asterisk asterisk 5098 d�c. 29 2017 logger.conf
-rw-r----- 1 asterisk asterisk 363 d�c. 29 2017 manager.conf
drwxr-xr-x 2 root root 4096 juil. 18 21:50 manager.d
-rw-r----- 1 asterisk asterisk 1518 d�c. 29 2017 meetme.conf
-rw-r----- 1 asterisk asterisk 5852 d�c. 29 2017 mgcp.conf
-rw-r----- 1 asterisk asterisk 9925 d�c. 29 2017 minivm.conf
-rw-r----- 1 asterisk asterisk 14752 d�c. 29 2017 misdn.conf
-rw-r----- 1 asterisk asterisk 2192 juil. 20 14:31 modules.conf
-rw-r----- 1 asterisk asterisk 4668 d�c. 29 2017 motif.conf
-rw-r----- 1 asterisk asterisk 3075 d�c. 29 2017 musiconhold.conf
-rw-r----- 1 asterisk asterisk 1285 d�c. 29 2017 muted.conf
-rw-r----- 1 asterisk asterisk 5916 d�c. 29 2017 ooh323.conf
-rw-r----- 1 asterisk asterisk 3900 d�c. 29 2017 osp.conf
-rw-r----- 1 asterisk asterisk 7461 d�c. 29 2017 oss.conf
-rw-r----- 1 asterisk asterisk 1577 d�c. 29 2017 phone.conf
-rw-r----- 1 asterisk asterisk 7840 d�c. 29 2017 phoneprov.conf
-rw-r----- 1 asterisk asterisk 2255 d�c. 29 2017 pjproject.conf
-rw-r----- 1 asterisk asterisk 51419 d�c. 29 2017 pjsip.conf
-rw-r----- 1 asterisk asterisk 790 d�c. 29 2017 pjsip_notify.conf
-rw-r----- 1 asterisk asterisk 6089 d�c. 29 2017 pjsip_wizard.conf
-rw-r----- 1 asterisk asterisk 1780 d�c. 29 2017 queuerules.conf
-rw-r----- 1 asterisk asterisk 25082 d�c. 29 2017 queues.conf
-rw-r----- 1 asterisk asterisk 2061 d�c. 29 2017 res_config_mysql.conf
-rw-r----- 1 asterisk asterisk 1332 d�c. 29 2017 res_config_sqlite3.conf
-rw-r----- 1 asterisk asterisk 378 d�c. 29 2017 res_config_sqlite.conf
-rw-r----- 1 asterisk asterisk 876 d�c. 29 2017 res_corosync.conf
-rw-r----- 1 asterisk asterisk 160 d�c. 29 2017 res_curl.conf
-rw-r----- 1 asterisk asterisk 1072 d�c. 29 2017 res_fax.conf
-rw-r----- 1 asterisk asterisk 7111 d�c. 29 2017 res_ldap.conf
-rw-r----- 1 asterisk asterisk 4265 d�c. 29 2017 res_odbc.conf
-rw-r----- 1 asterisk asterisk 11040 d�c. 29 2017 res_parking.conf
-rw-r----- 1 asterisk asterisk 1090 d�c. 29 2017 res_pgsql.conf
-rw-r----- 1 asterisk asterisk 713 d�c. 29 2017 res_pktccops.conf
-rw-r----- 1 asterisk asterisk 834 d�c. 29 2017 res_snmp.conf
-rw-r----- 1 asterisk asterisk 1350 d�c. 29 2017 res_stun_monitor.conf
-rw-r----- 1 asterisk asterisk 3473 d�c. 29 2017 rtp.conf
-rw-r----- 1 asterisk asterisk 17057 d�c. 29 2017 say.conf
-rw-r----- 1 asterisk asterisk 284 juil. 20 12:51 sip.conf
-rw-r----- 1 root root 92991 juil. 19 00:33 sip.conf.old
-rw-r----- 1 root root 3998 juil. 20 04:04 sip.conf.plugcomputer
-rw-r----- 1 asterisk asterisk 790 d�c. 29 2017 sip_notify.conf
-rw-r----- 1 asterisk asterisk 10065 d�c. 29 2017 skinny.conf
-rw-r----- 1 asterisk asterisk 7092 d�c. 29 2017 sla.conf
-rw-r----- 1 asterisk asterisk 2669 d�c. 29 2017 smdi.conf
-rw-r----- 1 asterisk asterisk 2222 d�c. 29 2017 sorcery.conf
-rw-r----- 1 asterisk asterisk 1503 d�c. 29 2017 ss7.timers
-rw-r----- 1 asterisk asterisk 4969 d�c. 29 2017 stasis.conf
-rw-r----- 1 asterisk asterisk 370 d�c. 29 2017 statsd.conf
-rw-r----- 1 asterisk asterisk 1384 d�c. 29 2017 telcordia-1.adsi
-rw-r----- 1 asterisk asterisk 152 d�c. 29 2017 test_sorcery.conf
-rw-r----- 1 asterisk asterisk 656 d�c. 29 2017 udptl.conf
-rw-r----- 1 asterisk asterisk 5850 d�c. 29 2017 unistim.conf
-rw-r----- 1 asterisk asterisk 2571 d�c. 29 2017 users.conf
-rw-r----- 1 asterisk asterisk 25413 d�c. 29 2017 voicemail.conf
-rw-r----- 1 asterisk asterisk 5938 d�c. 29 2017 vpb.conf
-rw-r----- 1 asterisk asterisk 2217 d�c. 29 2017 xmpp.conf
serveur@raspberrypi:~ $

vous vous avez

-rw-r----- 1 asterisk asterisk 17K juil. 20 17:07 /var/lib/asterisk/astdb.sqlite3
et moi

-rw-r--r-- 1 asterisk asterisk 12288 juil. 19 22:45 /var/lib/asterisk/astdb.sqlite3
est-ce normal ?

Si oui j'ai pas bien compris comment déplacer/renommer le fichier /var/lib/asterisk/astdb.sqlite3
Ou le déplacer ?
et le renomer en quoi ?

Merci.

[olppp]

-rw-r--r-- 1 asterisk asterisk 12288 juil. 19 22:45 /var/lib/asterisk/astdb.sqlite3

par exemple, arrêt d'Asterisk


sudo systemctl stop asterisk

renommer le fichier


sudo mv /var/lib/asterisk/astdb.sqlite3 /var/lib/asterisk/astdb.sqlite3.old

relancer Asterisk qui devrait recréer un nouveau fichier /var/lib/asterisk/astdb.sqlite3


sudo systemctl start asterisk

[xunil2003]

Bonjour,

J'ai fait :

sudo systemctl stop asterisk
sudo mv /var/lib/asterisk/astdb.sqlite3 /var/lib/asterisk/astdb.sqlite3.old
sudo systemctl start asterisk
la console de asterisk CLi, n'a plus de message d'erreur comme précédemment indiqué.

serveur@raspberrypi:~ $ sudo asterisk -rvvv
Asterisk 13.14.1~dfsg-2+deb9u3, Copyright (C) 1999 - 2014, Digium, Inc. and others.
Created by Mark Spencer <markster@digium.com>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
================================================== =======================
Connected to Asterisk 13.14.1~dfsg-2+deb9u3 currently running on raspberrypi (pid = 26168)
raspberrypi*CLI>

Merci pour votre aide, je considère à prédent la conversation résolu.
Merci.

[olppp]

Ok !
bonne continuation !