[AsteriskBrasil] Not currently connected to a MySQL server.

[Isac Borgert]

Deu certo? Funcionou agora?


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

> pabx*CLI> module show like res_config_mysql.so
> Module                         Description
>  Use Count
> res_config_mysql.so            MySQL RealTime Configuration Driver      0
>
> 1 modules loaded
>
>
>
> 2013/12/20 Isac Borgert <isacborgert em gmail.com>
>
>> > 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
>>>>>
>>>>
>>>>
>>>
>>
>> _______________________________________________
>> 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
>>
>
>
>
> --
> Atte.
> Fernando Trilha
> Analista de Suporte
> 8414 - 6008
> ftrilha em gmail.com
> ::Soluções em informatica e redes corporativas::
>
> _______________________________________________
> 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/70644295/attachment-0001.htm