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 <[email protected]> > Nao mesma coisa. > > > 2013/12/20 Isac Borgert <[email protected]> > >> Deu certo? Funcionou agora? >> >> >> 2013/12/20 Fernando Trilha <[email protected]> >> >>> 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 <[email protected]> >>> >>>> > module show like >>>> >>>> >>>> 2013/12/20 Isac Borgert <[email protected]> >>>> >>>>> Na compilação tem que marcar o módulo mysql pra instalar tambeḿ... >>>>> >>>>> >>>>> 2013/12/20 Isac Borgert <[email protected]> >>>>> >>>>>> 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 <[email protected]> >>>>>> >>>>>>> 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 [email protected] >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>>> _______________________________________________ >>>> 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 [email protected] >>>> >>> >>> >>> >>> -- >>> Atte. >>> Fernando Trilha >>> Analista de Suporte >>> 8414 - 6008 >>> [email protected] >>> ::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 >>> [email protected] >>> >> >> >> _______________________________________________ >> 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 >> [email protected] >> > > > > -- > Atte. > Fernando Trilha > Analista de Suporte > 8414 - 6008 > [email protected] > ::Soluções em informatica e redes corporativas:: > -- Atte. Fernando Trilha Analista de Suporte 8414 - 6008 [email protected] ::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 [email protected]
