[AsteriskBrasil] Not currently connected to a MySQL server.

Fernando Trilha ftrilha em gmail.com
Sexta Dezembro 20 13:12:45 BRST 2013


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


Mais detalhes sobre a lista de discussão AsteriskBrasil