vim /etc/asterisk/res_config_mysql.conf [general] dbhost = localhost dbname = pbxip dbuser = astrealtime dbpass = MYPASS dbport = 3306 dbsock = /var/lib/mysql/mysql.sock vim /etc/asterisk/res_config_mysql.conf
Em 20 de dezembro de 2013 16:01, Sylvio Jollenbeck < [email protected]> escreveu: > 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] > -- 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]
