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
_______________________________________________ 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]
