[AsteriskBrasil] Not currently connected to a MySQL server.

[Isac Borgert]

Se vc compilou o asterisk pode estar faltando alguma dependência, acesse a
paste dele (que vc extraiu) e já em /contrib/scripts/, dai executa
o./install_prereq install


2013/12/20 Fernando Trilha <ftrilha em gmail.com>

> 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 em 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
> asteriskbrasil-unsubscribe em listas.asteriskbrasil.org
>
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: http://listas.asteriskbrasil.org/pipermail/asteriskbrasil/attachments/20131220/e35d8781/attachment.htm