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]
