[AsteriskBrasil] Not currently connected to a MySQL server.
Sylvio Jollenbeck
sylvio.jollenbeck em gmail.com
Sexta Dezembro 20 16:01:01 BRST 2013
Fernando,
Post o seu /etc/asterisk/res_config_mysql.conf
Em 20 de dezembro de 2013 15:59, Fernando Trilha <ftrilha em gmail.com>escreveu:
> Coloquei e reiniciei o asterisk, mas continua o erro
>
> pabx*CLI> module load res_config_mysql.so
> Loaded res_config_mysql.so
> == Parsing '/etc/asterisk/res_config_mysql.conf': == Found
> [Dec 20 15:58:09] WARNING[7535]: res_config_mysql.c:1537
> load_mysql_config: MySQL realtime: no requirements setting found, using
> 'warn' as default.
> [Dec 20 15:58:09] NOTICE[7535]: config.c:2218 ast_config_engine_register:
> Registered Config Engine mysql
> == MySQL RealTime driver loaded.
> Loaded res_config_mysql.so => (MySQL RealTime Configuration Driver)
> pabx*CLI> cdr mysql status
> Not currently connected to a MySQL server.
>
>
>
> Em 20 de dezembro de 2013 15:53, Sylvio Jollenbeck <
> sylvio.jollenbeck em gmail.com> escreveu:
>
> Fernando
>>
>> Segue o seu extconfig.conf corrigido,
>>
>> [settings]
>> queues => mysql,general,queues
>> queue_members => mysql,general,queue_members
>> sippeers => mysql,general,sip
>> sipusers => mysql,general,sip
>> voicemail => mysql,general,voicemail_users
>>
>>
>> 2013/12/20 Sylvio Jollenbeck <sylvio.jollenbeck em gmail.com>
>>
>>> 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
>>>
>>>
>>
>>
>> --
>> 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/5af72bb0/attachment-0001.htm
Mais detalhes sobre a lista de discussão AsteriskBrasil