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]
