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]
