[AsteriskBrasil] Not currently connected to a MySQL server.

Fernando Trilha ftrilha em gmail.com
Sexta Dezembro 20 15:46:26 BRST 2013


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


Mais detalhes sobre a lista de discussão AsteriskBrasil