<div dir="ltr"><div>erro conexao dados mysql asterisk</div><div><br></div><div><br></div><div>pabx*CLI> cdr mysql status</div><div>Not currently connected to a MySQL server.</div><div>pabx*CLI></div><div><br></div><div>
<br></div><div><br></div><div>porem consigo me conectar na base pelo mysql</div><div><br></div><div>root@pabx:~# mysql -u astrealtime -pMYPASS</div><div>Welcome to the MySQL monitor. Commands end with ; or \g.</div><div>
Your MySQL connection id is 108</div><div>Server version: 5.5.33-0+wheezy1 (Debian)</div><div><br></div><div>Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.</div><div><br></div><div>Oracle is a registered trademark of Oracle Corporation and/or its</div>
<div>affiliates. Other names may be trademarks of their respective</div><div>owners.</div><div><br></div><div>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</div><div>
<br></div><div>mysql> use pbxip</div><div>Reading table information for completion of table and column names</div><div>You can turn off this feature to get a quicker startup with -A</div><div><br></div><div>Database changed</div>
<div>mysql> show tables;</div><div>+--------------------+</div><div>| Tables_in_pbxip |</div><div>+--------------------+</div><div>| cdr |</div><div>| queue_members |</div><div>| queues |</div>
<div>| sip |</div><div>| voicemail_messages |</div><div>| voicemail_users |</div><div>+--------------------+</div><div>6 rows in set (0.00 sec)</div><div><br></div><div>mysql></div><div><br></div><div>
<br></div><div>Os confs no asterisk:</div><div><br></div><div>/etc/asterisk/cdr_mysql.conf</div><div><br></div><div>[global]</div><div>hostname=localhost</div><div>dbname=pbxip</div><div>table=cdr</div><div>password=MYPASS</div>
<div>user=astrealtime</div><div>port=3306</div><div>sock=/var/lib/mysql/mysql.sock</div><div>userfield=1</div><div><br></div><div><br></div><div>/etc/asterisk/res_config_mysql.conf</div><div><br></div><div>[general]</div>
<div>dbhost = localhost</div><div>dbname = pbxip</div><div>dbuser = astrealtime</div><div>dbpass = MYPASS</div><div>dbport = 3306</div><div>dbsock = /var/lib/mysql/mysql.sock</div><div><br></div><div>/etc/asterisk/extconfig.conf</div>
<div><br></div><div>[settings]</div><div>queues => mysql,pbxip,queues</div><div>queue_members => mysql,pbxip,queue_members</div><div>sippeers => mysql,pbxip,sip</div><div>sipusers => mysql,pbxip,sip</div><div>
voicemail => mysql,pbxip,voicemail_users</div><div><br></div><div><br></div><div><br></div><div>Na cli:</div><div><br></div><div>pabx*CLI> cdr mysql status</div><div>Not currently connected to a MySQL server.</div><div>
pabx*CLI></div><div><br></div><div>Obrigado a todos pela ajuda.</div><div><br></div><div><br></div>-- <br><div dir="ltr">Atte.<br>Fernando Trilha<br><br></div>
</div>