Page 2 sur 2 PremièrePremière 12
Affichage des résultats 11 à 17 sur 17

Discussion: Erreur asterisk impossible de si conneter avec smartphone Csipsimple

  1. #11
    Membre Senior
    Date d'inscription
    janvier 2011
    Localisation
    Villejuif 94
    Messages
    321
    Merci
    1
    Remercié 22 Fois en 22 Posts

    Downloads
    0
    Uploads
    0
    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.

  2. #12
    Membre
    Date d'inscription
    avril 2012
    Localisation
    83170 Tourves (Var)
    Messages
    46
    Merci
    0
    Remercié 0 Fois en 0 Posts

    Downloads
    0
    Uploads
    0
    re,

    La console CLi me dit toujours que sql bloc
    Code:
    [Jul 20 14:36:45] WARNING[17827]: db.c:288 db_execute_sql: Error executing SQL (COMMIT): database is locked
    Code:
    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
    Code:
    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 :
    Code:
    serveur@raspberrypi:~ $ sudo /etc/init.d/asterisk restart
    [ ok ] Restarting asterisk (via systemctl): asterisk.service.
    serveur@raspberrypi:~ $
    Merci.

  3. #13
    Membre Senior
    Date d'inscription
    janvier 2011
    Localisation
    Villejuif 94
    Messages
    321
    Merci
    1
    Remercié 22 Fois en 22 Posts

    Downloads
    0
    Uploads
    0
    à 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.

  4. #14
    Membre
    Date d'inscription
    avril 2012
    Localisation
    83170 Tourves (Var)
    Messages
    46
    Merci
    0
    Remercié 0 Fois en 0 Posts

    Downloads
    0
    Uploads
    0
    Re,

    Voici le retour

    Code:
    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
    Code:
    -rw-r----- 1 asterisk asterisk 17K juil. 20 17:07 /var/lib/asterisk/astdb.sqlite3
    et moi
    Code:
    -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.

  5. #15
    Membre Senior
    Date d'inscription
    janvier 2011
    Localisation
    Villejuif 94
    Messages
    321
    Merci
    1
    Remercié 22 Fois en 22 Posts

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

    par exemple, arrêt d'Asterisk
    Code:
    sudo systemctl stop asterisk
    renommer le fichier
    Code:
    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
    Code:
    sudo systemctl start asterisk

  6. #16
    Membre
    Date d'inscription
    avril 2012
    Localisation
    83170 Tourves (Var)
    Messages
    46
    Merci
    0
    Remercié 0 Fois en 0 Posts

    Downloads
    0
    Uploads
    0
    Bonjour,

    J'ai fait :
    Code:
    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é.
    Code:
    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.

  7. #17
    Membre Senior
    Date d'inscription
    janvier 2011
    Localisation
    Villejuif 94
    Messages
    321
    Merci
    1
    Remercié 22 Fois en 22 Posts

    Downloads
    0
    Uploads
    0
    Ok !
    bonne continuation !

Règles de messages

  • Vous ne pouvez pas créer de nouvelles discussions
  • Vous ne pouvez pas envoyer des réponses
  • Vous ne pouvez pas envoyer des pièces jointes
  • Vous ne pouvez pas modifier vos messages
  •