[AsteriskBrasil] Not currently connected to a MySQL server.

[Isac Borgert]

> module show like


2013/12/20 Isac Borgert <isacborgert em gmail.com>

> Na compilação tem que marcar o módulo mysql pra instalar tambeḿ...
>
>
> 2013/12/20 Isac Borgert <isacborgert em gmail.com>
>
>> 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/fbc8f720/attachment-0001.htm