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 <isacborg...@gmail.com> > > module show like > > > 2013/12/20 Isac Borgert <isacborg...@gmail.com> > >> Na compilação tem que marcar o módulo mysql pra instalar tambeḿ... >> >> >> 2013/12/20 Isac Borgert <isacborg...@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 <ftri...@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@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-unsubscr...@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-unsubscr...@listas.asteriskbrasil.org > -- Atte. Fernando Trilha Analista de Suporte 8414 - 6008 ftri...@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-unsubscr...@listas.asteriskbrasil.org