[AsteriskBrasil] Not currently connected to a MySQL server.

[Fernando Trilha]

Nao mesma coisa.


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

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