[AsteriskBrasil] Not currently connected to a MySQL server.

Fernando Trilha ftrilha em gmail.com
Sexta Dezembro 20 14:00:53 BRST 2013 

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

Mais detalhes sobre a lista de discussão AsteriskBrasil