Fernando, Post o seu /etc/asterisk/res_config_mysql.conf
Em 20 de dezembro de 2013 15:59, Fernando Trilha <[email protected]>escreveu: > Coloquei e reiniciei o asterisk, mas continua o erro > > pabx*CLI> module load res_config_mysql.so > Loaded res_config_mysql.so > == Parsing '/etc/asterisk/res_config_mysql.conf': == Found > [Dec 20 15:58:09] WARNING[7535]: res_config_mysql.c:1537 > load_mysql_config: MySQL realtime: no requirements setting found, using > 'warn' as default. > [Dec 20 15:58:09] NOTICE[7535]: config.c:2218 ast_config_engine_register: > Registered Config Engine mysql > == MySQL RealTime driver loaded. > Loaded res_config_mysql.so => (MySQL RealTime Configuration Driver) > pabx*CLI> cdr mysql status > Not currently connected to a MySQL server. > > > > Em 20 de dezembro de 2013 15:53, Sylvio Jollenbeck < > [email protected]> escreveu: > > Fernando >> >> Segue o seu extconfig.conf corrigido, >> >> [settings] >> queues => mysql,general,queues >> queue_members => mysql,general,queue_members >> sippeers => mysql,general,sip >> sipusers => mysql,general,sip >> voicemail => mysql,general,voicemail_users >> >> >> 2013/12/20 Sylvio Jollenbeck <[email protected]> >> >>> No exteconfig.conf, troque mysql por general. >>> >>> >>> 2013/12/20 Fernando Trilha <[email protected]> >>> >>>> Ja esta... >>>> [settings] >>>> queues => mysql,pbxip,queues >>>> queue_members => mysql,pbxip,queue_members >>>> sippeers => mysql,pbxip,sip >>>> sipusers => mysql,pbxip,sip >>>> voicemail => mysql,pbxip,voicemail_users >>>> >>>> >>>> >>>> >>>> 2013/12/20 Sylvio Jollenbeck <[email protected]> >>>> >>>>> Fernando, >>>>> >>>>> O módulo MySQL esta ativo, o * conseguiu reconhece ele: == MySQL >>>>> RealTime driver loaded. >>>>> O problema esta na sua config.: == 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. >>>>> >>>>> No exteconfig.conf, troque mysql por general. >>>>> >>>>> >>>>> 2013/12/20 Fernando Trilha <[email protected]> >>>>> >>>>>> 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] >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Sylvio Jollenbeck >>>>> www.hosannatecnologia.com.br >>>>> >>>>> >>>>> _______________________________________________ >>>>> 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] >>>> >>> >>> >>> >>> -- >>> Sylvio Jollenbeck >>> www.hosannatecnologia.com.br >>> >>> >> >> >> -- >> Sylvio Jollenbeck >> www.hosannatecnologia.com.br >> >> >> _______________________________________________ >> 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] > -- Sylvio Jollenbeck www.hosannatecnologia.com.br
_______________________________________________ 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]
