[AsteriskBrasil] Not currently connected to a MySQL server.

Fernando Trilha ftrilha em gmail.com
Sexta Dezembro 20 13:11:07 BRST 2013


Fiz isso Isac:

# sh contrib/scripts/install_prereq install
# sh contrib/scripts/install_prereq install-unpackaged
# sh configure
# make menuselect , habilitar os add do mysql
# make; make install; make samples; make config.




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/18e7b3ce/attachment.htm 


Mais detalhes sobre a lista de discussão AsteriskBrasil