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]
