[AsteriskBrasil] Not currently connected to a MySQL server.

Sylvio Jollenbeck sylvio.jollenbeck em gmail.com
Sexta Dezembro 20 15:52:06 BRST 2013 

No exteconfig.conf, troque mysql por general.


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

> Ja esta...
> [settings]
> queues => mysql,pbxip,queues
> queue_members => mysql,pbxip,queue_members
> sippeers => mysql,pbxip,sip
> sipusers => mysql,pbxip,sip
> voicemail => mysql,pbxip,voicemail_users
>
>
>
>
> 2013/12/20 Sylvio Jollenbeck <sylvio.jollenbeck em gmail.com>
>
>> Fernando,
>>
>> O módulo MySQL esta ativo, o * conseguiu reconhece ele:   == MySQL
>> RealTime driver loaded.
>> O problema esta na sua config.:  == Dec 20 14:00:27] WARNING[7266]:
>> res_config_mysql.c:1537 load_mysql_config: MySQL realtime: no
>> requirements setting found, using 'warn' as default.
>>
>> No exteconfig.conf, troque mysql por general.
>>
>>
>> 2013/12/20 Fernando Trilha <ftrilha em gmail.com>
>>
>>> pabx*CLI> module load res_config_mysql.so
>>> Loaded res_config_mysql.so
>>>   == Parsing '/etc/asterisk/res_config_mysql.conf':   == Found
>>> [Dec 20 14:00:27] WARNING[7266]: res_config_mysql.c:1537
>>> load_mysql_config: MySQL realtime: no requirements setting found, using
>>> 'warn' as default.
>>> [Dec 20 14:00:27] NOTICE[7266]: config.c:2218
>>> ast_config_engine_register: Registered Config Engine mysql
>>>   == MySQL RealTime driver loaded.
>>>  Loaded res_config_mysql.so => (MySQL RealTime Configuration Driver)
>>>
>>>
>>> 2013/12/20 Fernando Trilha <ftrilha em gmail.com>
>>>
>>>> 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::
>>>>
>>>
>>>
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Sylvio Jollenbeck
>> www.hosannatecnologia.com.br
>>
>>
>> _______________________________________________
>> 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
>



-- 
Sylvio Jollenbeck
www.hosannatecnologia.com.br
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: http://listas.asteriskbrasil.org/pipermail/asteriskbrasil/attachments/20131220/fd81f53e/attachment.htm

Mais detalhes sobre a lista de discussão AsteriskBrasil