tu as installer une base de donnée sur le raspberry ? postgresql ou mysql ?
résultats de la commande
etCode:cdr show status
Code:odbc show all
tu as installer une base de donnée sur le raspberry ? postgresql ou mysql ?
résultats de la commande
etCode:cdr show status
Code:odbc show all
re,
voici le retour
Code: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>j'ai installé dans l'ordre :Code:raspberrypi*CLI> odbc show all ODBC DSN Settings ----------------- raspberrypi*CLI>
Pour realiser un serveur multi-fonction avec le raspberry (domotique, serveur web, serveur ftp, serveur dlna, etc...)Code:1 : APACHE 2 : PHP 3 : SQL 4 : PHPMYADMIN
Merci.
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
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 bienCode: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
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.
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 lockedfichier : /etc/asterisk/modules.confCode: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>
suivi de :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:~ $
Merci.Code:serveur@raspberrypi:~ $ sudo /etc/init.d/asterisk restart [ ok ] Restarting asterisk (via systemctl): asterisk.service. serveur@raspberrypi:~ $
à essayer :
1 vérifier que le fichier /var/lib/asterisk/astdb.sqlite3 appartient à asterisk:asterisk avec droit en écriture
si non régler les problèmes d'accèsls -l /var/lib/asterisk/astdb.sqlite3 /etc/asterisk
-rw-r----- 1 asterisk asterisk 17K juil. 20 17:07 /var/lib/asterisk/astdb.sqlite3
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.
Re,
Voici le retour
vous vous avezCode: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:~ $
et moiCode:-rw-r----- 1 asterisk asterisk 17K juil. 20 17:07 /var/lib/asterisk/astdb.sqlite3
est-ce normal ?Code:-rw-r--r-- 1 asterisk asterisk 12288 juil. 19 22:45 /var/lib/asterisk/astdb.sqlite3
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.
-rw-r--r-- 1 asterisk asterisk 12288 juil. 19 22:45 /var/lib/asterisk/astdb.sqlite3
par exemple, arrêt d'Asterisk
renommer le fichierCode:sudo systemctl stop asterisk
relancer Asterisk qui devrait recréer un nouveau fichier /var/lib/asterisk/astdb.sqlite3Code:sudo mv /var/lib/asterisk/astdb.sqlite3 /var/lib/asterisk/astdb.sqlite3.old
Code:sudo systemctl start asterisk