[AsteriskBrasil] Not currently connected to a MySQL server.
Fernando Trilha
ftrilha em gmail.com
Sexta Dezembro 20 15:59:10 BRST 2013
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::
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: http://listas.asteriskbrasil.org/pipermail/asteriskbrasil/attachments/20131220/0ba427dc/attachment-0001.htm
Mais detalhes sobre a lista de discussão AsteriskBrasil