erro conexao dados mysql asterisk
pabx*CLI> cdr mysql status Not currently connected to a MySQL server. pabx*CLI> porem consigo me conectar na base pelo mysql root@pabx:~# mysql -u astrealtime -pMYPASS Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 108 Server version: 5.5.33-0+wheezy1 (Debian) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use pbxip Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +--------------------+ | Tables_in_pbxip | +--------------------+ | cdr | | queue_members | | queues | | sip | | voicemail_messages | | voicemail_users | +--------------------+ 6 rows in set (0.00 sec) mysql> Os confs no asterisk: /etc/asterisk/cdr_mysql.conf [global] hostname=localhost dbname=pbxip table=cdr password=MYPASS user=astrealtime port=3306 sock=/var/lib/mysql/mysql.sock userfield=1 /etc/asterisk/res_config_mysql.conf [general] dbhost = localhost dbname = pbxip dbuser = astrealtime dbpass = MYPASS dbport = 3306 dbsock = /var/lib/mysql/mysql.sock /etc/asterisk/extconfig.conf [settings] queues => mysql,pbxip,queues queue_members => mysql,pbxip,queue_members sippeers => mysql,pbxip,sip sipusers => mysql,pbxip,sip voicemail => mysql,pbxip,voicemail_users Na cli: pabx*CLI> cdr mysql status Not currently connected to a MySQL server. pabx*CLI> Obrigado a todos pela ajuda. -- Atte. Fernando Trilha
_______________________________________________ KHOMP: completa linha de placas externas FXO, FXS, GSM e E1 Media Gateways de 1 a 64 E1s para SIP com R2, ISDN e SS7 Intercomunicadores para acesso remoto via rede IP e telefones IP Conheça todo o portfólio em www.Khomp.com _______________________________________________ Para remover seu email desta lista, basta enviar um email em branco para [email protected]
