<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Well, at least you are making progress.<br>
      What is the error in the debug log?<br>
      <br>
      Ron<br>
      <br>
      <br>
      On 03/06/2013 8:03 PM, Olivier CALVANO wrote:<br>
    </div>
    <blockquote
cite="mid:CAJajPeeRi0x7f2a6WZiggXMZ6sjrM8Yn9_45_iHUcC0F3mLqXg@mail.gmail.com"
      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&nbsp; 4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL
          RealTime: Failed to connect database server xxx on <a
            moz-do-not-send="true" href="http://xxx.xxx.net">xxx.xxx.net</a>
          (err 2003). Check debug for more info.<br>
          [Jun&nbsp; 4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL
          RealTime: Failed to connect database server xxx on <a
            moz-do-not-send="true" href="http://xxx.xxx.net">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">&lt;<a moz-do-not-send="true"
              href="mailto:o.calvano@gmail.com" target="_blank">o.calvano@gmail.com</a>&gt;</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">&lt;<a
                    moz-do-not-send="true"
                    href="mailto:rwheeler@artifact-software.com"
                    target="_blank">rwheeler@artifact-software.com</a>&gt;</span><br>
                <blockquote class="gmail_quote" style="margin:0 0 0
                  .8ex;border-left:1px #ccc solid;padding-left:1ex">
                  <div>
                    <div class="h5">
                      <div text="#000000" bgcolor="#FFFFFF">
                        <div>Do you have this problem in your conf file?<br>
                          <br>
                          <a moz-do-not-send="true"
                            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">&lt;<a
                                    moz-do-not-send="true"
                                    href="mailto:asannucci@gmail.com"
                                    target="_blank">asannucci@gmail.com</a>&gt;</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&oacute;:<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
                                                  moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:rwheeler@artifact-software.com" target="_blank">rwheeler@artifact-software.com</a>
skype: ronaldmwheeler
phone: <a moz-do-not-send="true" 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 class="im">--<br>
_____________________________________________________________________<br>
                    -- Bandwidth and Colocation Provided by <a
                      moz-do-not-send="true"
                      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>
                    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a moz-do-not-send="true"
                      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>
                    &nbsp; &nbsp;<a moz-do-not-send="true"
                      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 class="moz-signature" cols="72">-- 
Ron Wheeler
President
Artifact Software Inc
email: <a class="moz-txt-link-abbreviated" href="mailto:rwheeler@artifact-software.com">rwheeler@artifact-software.com</a>
skype: ronaldmwheeler
phone: 866-970-2435, ext 102</pre>
  </body>
</html>