<div dir="ltr"><div><div><div><div><div>What is the best commande for put the debug ? because with core set debug, i don't have a return.<br><br><br>voip-2*CLI> realtime mysql status<br>Vop configured for <a href="mailto:MyDB@MyHost.MyDomain.net" target="_blank">MyDB@MyHost.MyDomain.net</a>, port 3306 with username Asterisk.<br>
[Jun 4 06:48:25] ERROR[27879]: res_config_mysql.c:1577 mysql_reconnect:
MySQL RealTime: Failed to connect database server Vop on <a href="http://vop.phibee-telecom.net/" target="_blank">vop.phibee-telecom.net</a> (err 2003). Check debug for more info.<br>
<br></div>He read correctly the config because it's the good DB, Server and username<br><br><br></div>in /var/log/asterisk/message i have:<br><br>[Jun 4 06:46:21] Asterisk 11.4.0 built by mockbuild @ <a href="http://buildvm-12.phx2.fedoraproject.org/" target="_blank">buildvm-12.phx2.fedoraproject.org</a> on a x86_64 running Linux on 2013-05-20 15:47:05 UTC<br>
[Jun 4 06:46:21] NOTICE[27825] loader.c: 1 modules will be loaded.<br>[Jun 4 06:46:21] NOTICE[27825] config.c: Registered Config Engine mysql<br>[Jun 4 06:46:21] NOTICE[27825] cdr.c: CDR simple logging enabled.<br>[Jun 4 06:46:21] NOTICE[27825] loader.c: 192 modules will be loaded.<br>
[Jun 4 06:46:21] NOTICE[27825] res_smdi.c: No SMDI interfaces are available to listen on, not starting SMDI listener.<br>[Jun 4 06:46:21] WARNING[27825] res_musiconhold.c: No music on hold classes configured, disabling music on hold.<br>
[Jun 4 06:46:21] ERROR[27825] res_config_mysql.c: MySQL RealTime: Failed to connect database server MyDB on <a href="http://myhost.mydomain.net/" target="_blank">MyHost.MyDomain.net</a> (err 2003). Check debug for more info.<br>
[Jun
4 06:46:21] WARNING[27825] res_config_mysql.c: Table Comptes_IAX not
found in database. This table should exist if you're using realtime.<br>
[Jun 4 06:46:21] ERROR[27825] res_config_mysql.c: MySQL RealTime: Failed to connect database server MyDB on <a href="http://myhost.mydomain.net/" target="_blank">MyHost.MyDomain.net</a> (err 2003). Check debug for more info.<br>
[Jun 4 06:46:21] ERROR[27825] res_config_mysql.c: MySQL RealTime: Failed to connect database server MyDB on <a href="http://myhost.mydomain.net/" target="_blank">MyHost.MyDomain.net</a> (err 2003). Check debug for more info.<br>
[Jun 4 06:46:21] WARNING[27825] res_config_mysql.c: Table Comptes_SIP
not found in database. This table should exist if you're using
realtime.<br>[Jun 4 06:46:21] NOTICE[27825] confbridge/conf_config_parser.c: Adding default_user profile to app_confbridge<br>
[Jun 4 06:46:21] NOTICE[27825] pbx_ael.c: Starting AEL load process.<br>[Jun 4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: parsed config file name '/etc/asterisk/extensions.ael'.<br>[Jun 4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: checked config file name '/etc/asterisk/extensions.ael'.<br>
[Jun 4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: compiled config file name '/etc/asterisk/extensions.ael'.<br>[Jun 4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: merged config file name '/etc/asterisk/extensions.ael'.<br>
[Jun 4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: verified config file name '/etc/asterisk/extensions.ael'.<br>[Jun 4 06:46:22] ERROR[27825] cdr_mysql.c: Failed to connect to mysql database MyDB on <a href="http://myhost.mydomain.net/" target="_blank">MyHost.MyDomain.net</a>.<br>
[Jun 4 06:47:51] ERROR[27879] res_config_mysql.c: MySQL RealTime: Failed to connect database server MyDB on <a href="http://myhost.mydomain.net/" target="_blank">MyHost.MyDomain.net</a> (err 2003). Check debug for more info.<br>
[Jun 4 06:48:25] ERROR[27879] res_config_mysql.c: MySQL RealTime: Failed to connect database server MyDB on <a href="http://myhost.mydomain.net/" target="_blank">MyHost.MyDomain.net</a> (err 2003). Check debug for more info.<br>
<br></div>Asterisk have the good information, but i don't understand why he can't connect to the DB, if i use:<br></div>mysql -h <a href="http://myhost.mydomain.net/" target="_blank">MyHost.MyDomain.net</a> -u Aserisk -p MyDB<br>
</div>
i have a full access to my MySQL server.<br><br><div><div><div style="display:inline-block"><div><span></span></div></div></div></div>
<span lang="en"><span>may</span> <span>be</span> <span>missing</span> <span>in</span> <span>a</span> <span>Fedora</span> <span>package ?</span></span></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/6/4 Ron Wheeler <span dir="ltr"><<a href="mailto:rwheeler@artifact-software.com" target="_blank">rwheeler@artifact-software.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>Well, at least you are making progress.<br>
What is the error in the debug log?<span class="HOEnZb"><font color="#888888"><br>
<br>
Ron</font></span><div><div class="h5"><br>
<br>
<br>
On 03/06/2013 8:03 PM, Olivier CALVANO wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div dir="ltr">
<div>grrr no in asterisk -d i have no error, but when i start
normaly asterisk i have :<br>
<br>
[Jun 4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL
RealTime: Failed to connect database server xxx on <a href="http://xxx.xxx.net" target="_blank">xxx.xxx.net</a>
(err 2003). Check debug for more info.<br>
[Jun 4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL
RealTime: Failed to connect database server xxx on <a href="http://xxx.xxx.net" target="_blank">xxx.xxx.net</a>
(err 2003). Check debug for more info.<br>
<br>
<br>
</div>
what is the command in asterisk for i see the SQL query ?<br>
<br>
<br>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/6/4 Olivier CALVANO <span dir="ltr"><<a href="mailto:o.calvano@gmail.com" target="_blank">o.calvano@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div>
<div>oh ron thanks for your help :<br>
<br>
</div>
We have deleted all commented line, only put the
configuration and now that's work !<br>
<br>
</div>
<br>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">
2013/6/3 Ron Wheeler <span dir="ltr"><<a href="mailto:rwheeler@artifact-software.com" target="_blank">rwheeler@artifact-software.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div>
<div text="#000000" bgcolor="#FFFFFF">
<div>Do you have this problem in your conf file?<br>
<br>
<a href="http://forums.digium.com/viewtopic.php?p=63736" target="_blank">http://forums.digium.com/viewtopic.php?p=63736</a><br>
<br>
"The parser won't accept an <span style="font-weight:bold">;</span>
(semicolon) for remarks! So he found at the
first the old remarks and tried to access my
database with the false data."<span><font color="#888888"><br>
<br>
<br>
<br>
<br>
Ron</font></span>
<div><br>
<br>
On 03/06/2013 3:18 PM, Olivier CALVANO
wrote:<br>
</div>
</div>
<div>
<blockquote type="cite">
<div dir="ltr">
<div>on this server we don't have
mysql.socket because he don't have mysql
server<br>
<br>
</div>
we want access to a mysql based on a other
server<br>
<br>
<br>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote"> 2013/6/3 Bakko <span dir="ltr"><<a href="mailto:asannucci@gmail.com" target="_blank">asannucci@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
Hello,<br>
<br>
are you sure MySQL socket is in /tmp
directory?<br>
<br>
dbsock = /tmp/mysql.sock<br>
<br>
Regards<br>
<br>
<div>El 03/06/2013 12:16, Olivier
CALVANO escribió:<br>
</div>
<div>
<div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>Thanks for your
help Ron,<br>
<br>
Do you know where is
the confirguration ?<br>
<br>
</div>
Because i have put into
res_config_mysql.conf:<br>
<br>
[general]<br>
dbhost = <a href="http://myhost.mydomain.net" target="_blank">myhost.mydomain.net</a><br>
dbname = MyDB<br>
dbuser = MyUser<br>
dbpass = MyPassword<br>
dbport = 3306<br>
dbsock = /tmp/mysql.sock<br>
dbcharset = latin1<br>
requirements = warn<br>
</div>
</div>
</div>
<br>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
<br>
</div>
<div>
<pre cols="72">--
Ron Wheeler
President
Artifact Software Inc
email: <a href="mailto:rwheeler@artifact-software.com" target="_blank">rwheeler@artifact-software.com</a>
skype: ronaldmwheeler
phone: <a href="tel:866-970-2435%2C%20ext%20102" value="+18669702435" target="_blank">866-970-2435, ext 102</a></pre>
</div>
</div>
<br>
</div>
</div>
<div>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a>
--<br>
New to Asterisk? Join us for a live introductory
webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<br>
<pre cols="72">--
Ron Wheeler
President
Artifact Software Inc
email: <a href="mailto:rwheeler@artifact-software.com" target="_blank">rwheeler@artifact-software.com</a>
skype: ronaldmwheeler
phone: <a href="tel:866-970-2435%2C%20ext%20102" value="+18669702435" target="_blank">866-970-2435, ext 102</a></pre>
</div></div></div>
</blockquote></div><br></div>