[AsteriskBrasil] Not currently connected to a MySQL server.
Sylvio Jollenbeck
sylvio.jollenbeck em gmail.com
Sexta Dezembro 20 15:53:32 BRST 2013
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
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: http://listas.asteriskbrasil.org/pipermail/asteriskbrasil/attachments/20131220/9b16def6/attachment-0001.htm
Mais detalhes sobre a lista de discussão AsteriskBrasil