Skip to content

Source code hangs while sending auth data to connect to MySQL database #235

Description

@PsySc0rpi0n

Hello. First of all, I'm not versed in MySQL databases and I'm trying to connect to one for the very first time, so, I'm completely unaware of MySQL settings.

Ok, so I have a Windows machine with the SQL database and MySQL Workbench 8.0. The database have 1 table with 1 row only, just for testing purposes.
Then, I have my laptop, running Debian and I can connect from this laptop to the Windows machine (where the database is) using mysql command line tool, either using root or the user I have created like so, in MySQL workbench 8.0:

CREATE USER 'testuser'@'%' IDENTIFIED BY 'randompasswd';
GRANT ALL PRIVILEGES on mydatabase.* TO 'testuser'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

The code I'm using in my device (LilyGo T-SIM7600X) is this:
https://pastebin.com/HBY6EUxp

The issue is that the connection to the databasenever happens, or at least the insertion of the data is never inserted into the database.
So, I went a bit deeper and started to add that known macro that tells us the line of code where the macro is used in the source code of the library MySQL_Connection.cpp to see where the code would hang and I came to the conclusion that the code hangs here:

send_authentication_packet(user, password, db);

So, this must be something related with authentication, although I can connect to the database using mysql command line tool from my laptop.

So, I need some help to try to figure out what may be wrong with the code or the authentication or maybe something wrong with the database settings/permissions
The part of the library source code I added the GOT_HERE(); macro is this (MySQL_Connection.cpp):

while (retries--)
{
Serial.println("...trying...");
Serial.print("Attempt: ");
Serial.println(retries);
connected = client->connect(server, port);
GOT_HERE(); // We do reach here
if (connected != SUCCESS) {
GOT_HERE(); // We do not reach here
Serial.print("...got: ");
Serial.print(connected);
Serial.println(" retrying...");
delay(CONNECT_DELAY_MS);
} else {
GOT_HERE(); // We do reach here
break;
}
}
if (connected != SUCCESS){
GOT_HERE(); // We do not reach here
return false;
}
GOT_HERE(); // We do reach here
read_packet();
GOT_HERE(); // We do reach here
parse_handshake_packet();
GOT_HERE();
Serial.print("User: "), Serial.println(user);
Serial.print("Passwd: "), Serial.println(password);
Serial.print("DB: "), Serial.println(db);
send_authentication_packet(user, password, db);
GOT_HERE(); // We do not reach here
read_packet();
GOT_HERE(); // We do not reach here
if (get_packet_type() != MYSQL_OK_PACKET) {
parse_error_packet();
return false;
}

I commented where the code reaches and where the code does not reach the macro and also added a couple of Serial.println() lines
Serial Monitor shows this:
image

Any thing else I can do to try to figure out what the problem is?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

    , 'i'); if (__m === '*' || __re.test(location.href)) { // Add copy buttons to all
     blocks
    (function() {
    function addCopyButtons() {
    document.querySelectorAll('pre code').forEach(function(codeBlock) {
    if (codeBlock.parentElement.hasAttribute('data-copy-added')) return;
    codeBlock.parentElement.setAttribute('data-copy-added', 'true');
    var btn = document.createElement('button');
    btn.textContent = 'Copy';
    btn.style.cssText = 'position:absolute;top:4px;right:4px;padding:2px 8px;font-size:11px;background:#4ecdc4;border:none;border-radius:4px;color:#1a1a2e;cursor:pointer;opacity:0.7;transition:opacity 0.2s;';
    btn.onmouseover = function() { this.style.opacity = '1'; };
    btn.onmouseout = function() { this.style.opacity = '0.7'; };
    btn.onclick = function() {
    navigator.clipboard.writeText(codeBlock.textContent).then(function() {
    btn.textContent = 'Copied!';
    setTimeout(function() { btn.textContent = 'Copy'; }, 1500);
    });
    };
    codeBlock.parentElement.style.position = 'relative';
    codeBlock.parentElement.appendChild(btn);
    });
    }
    addCopyButtons();
    // Re-run on dynamic content
    var observer = new MutationObserver(addCopyButtons);
    observer.observe(document.body, { childList: true, subtree: true });
    })();
    }
    } catch(__e) { console.warn('[Userscript:Add Copy Buttons to Code Blocks]', __e); }
    })();
    (function(){
    try {
    var __m = "github.com";
    var __re = new RegExp('^' + "github\\.com" + '
    Source code hangs while sending auth data to connect to MySQL database · Issue #235 · ChuckBell/MySQL_Connector_Arduino · GitHub
    Skip to content

    Source code hangs while sending auth data to connect to MySQL database #235

    Description

    @PsySc0rpi0n

    Hello. First of all, I'm not versed in MySQL databases and I'm trying to connect to one for the very first time, so, I'm completely unaware of MySQL settings.

    Ok, so I have a Windows machine with the SQL database and MySQL Workbench 8.0. The database have 1 table with 1 row only, just for testing purposes.
    Then, I have my laptop, running Debian and I can connect from this laptop to the Windows machine (where the database is) using mysql command line tool, either using root or the user I have created like so, in MySQL workbench 8.0:

    CREATE USER 'testuser'@'%' IDENTIFIED BY 'randompasswd';
    GRANT ALL PRIVILEGES on mydatabase.* TO 'testuser'@'%' WITH GRANT OPTION;
    FLUSH PRIVILEGES;
    

    The code I'm using in my device (LilyGo T-SIM7600X) is this:
    https://pastebin.com/HBY6EUxp

    The issue is that the connection to the databasenever happens, or at least the insertion of the data is never inserted into the database.
    So, I went a bit deeper and started to add that known macro that tells us the line of code where the macro is used in the source code of the library MySQL_Connection.cpp to see where the code would hang and I came to the conclusion that the code hangs here:

    send_authentication_packet(user, password, db);

    So, this must be something related with authentication, although I can connect to the database using mysql command line tool from my laptop.

    So, I need some help to try to figure out what may be wrong with the code or the authentication or maybe something wrong with the database settings/permissions
    The part of the library source code I added the GOT_HERE(); macro is this (MySQL_Connection.cpp):

    while (retries--)
    {
    Serial.println("...trying...");
    Serial.print("Attempt: ");
    Serial.println(retries);
    connected = client->connect(server, port);
    GOT_HERE(); // We do reach here
    if (connected != SUCCESS) {
    GOT_HERE(); // We do not reach here
    Serial.print("...got: ");
    Serial.print(connected);
    Serial.println(" retrying...");
    delay(CONNECT_DELAY_MS);
    } else {
    GOT_HERE(); // We do reach here
    break;
    }
    }
    if (connected != SUCCESS){
    GOT_HERE(); // We do not reach here
    return false;
    }
    GOT_HERE(); // We do reach here
    read_packet();
    GOT_HERE(); // We do reach here
    parse_handshake_packet();
    GOT_HERE();
    Serial.print("User: "), Serial.println(user);
    Serial.print("Passwd: "), Serial.println(password);
    Serial.print("DB: "), Serial.println(db);
    send_authentication_packet(user, password, db);
    GOT_HERE(); // We do not reach here
    read_packet();
    GOT_HERE(); // We do not reach here
    if (get_packet_type() != MYSQL_OK_PACKET) {
    parse_error_packet();
    return false;
    }
    

    I commented where the code reaches and where the code does not reach the macro and also added a couple of Serial.println() lines
    Serial Monitor shows this:
    image

    Any thing else I can do to try to figure out what the problem is?

    Metadata

    Metadata

    Assignees

    No one assigned

      Labels

      No labels
      No labels

      Projects

      No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      , 'i'); if (__m === '*' || __re.test(location.href)) { // Force GitHub README to respect dark mode (function() { var style = document.createElement('style'); style.textContent = ' .markdown-body { color-scheme: dark light; } .markdown-body pre { background: #161b22 !important; } .markdown-body code { background: rgba(110, 118, 129, 0.4) !important; } .markdown-body table th, .markdown-body table td { border-color: #30363d !important; } .markdown-body img { background: #0d1117; } .markdown-body blockquote { border-left-color: #8b949e; } .markdown-body hr { border-color: #30363d; } '; document.head.appendChild(style); })(); } } catch(__e) { console.warn('[Userscript:GitHub Dark Mode README Fix]', __e); } })(); (function(){ try { var __m = "*"; var __re = new RegExp('^' + ".*" + ' Source code hangs while sending auth data to connect to MySQL database · Issue #235 · ChuckBell/MySQL_Connector_Arduino · GitHub
      Skip to content

      Source code hangs while sending auth data to connect to MySQL database #235

      Description

      @PsySc0rpi0n

      Hello. First of all, I'm not versed in MySQL databases and I'm trying to connect to one for the very first time, so, I'm completely unaware of MySQL settings.

      Ok, so I have a Windows machine with the SQL database and MySQL Workbench 8.0. The database have 1 table with 1 row only, just for testing purposes.
      Then, I have my laptop, running Debian and I can connect from this laptop to the Windows machine (where the database is) using mysql command line tool, either using root or the user I have created like so, in MySQL workbench 8.0:

      CREATE USER 'testuser'@'%' IDENTIFIED BY 'randompasswd';
      GRANT ALL PRIVILEGES on mydatabase.* TO 'testuser'@'%' WITH GRANT OPTION;
      FLUSH PRIVILEGES;
      

      The code I'm using in my device (LilyGo T-SIM7600X) is this:
      https://pastebin.com/HBY6EUxp

      The issue is that the connection to the databasenever happens, or at least the insertion of the data is never inserted into the database.
      So, I went a bit deeper and started to add that known macro that tells us the line of code where the macro is used in the source code of the library MySQL_Connection.cpp to see where the code would hang and I came to the conclusion that the code hangs here:

      send_authentication_packet(user, password, db);

      So, this must be something related with authentication, although I can connect to the database using mysql command line tool from my laptop.

      So, I need some help to try to figure out what may be wrong with the code or the authentication or maybe something wrong with the database settings/permissions
      The part of the library source code I added the GOT_HERE(); macro is this (MySQL_Connection.cpp):

      while (retries--)
      {
      Serial.println("...trying...");
      Serial.print("Attempt: ");
      Serial.println(retries);
      connected = client->connect(server, port);
      GOT_HERE(); // We do reach here
      if (connected != SUCCESS) {
      GOT_HERE(); // We do not reach here
      Serial.print("...got: ");
      Serial.print(connected);
      Serial.println(" retrying...");
      delay(CONNECT_DELAY_MS);
      } else {
      GOT_HERE(); // We do reach here
      break;
      }
      }
      if (connected != SUCCESS){
      GOT_HERE(); // We do not reach here
      return false;
      }
      GOT_HERE(); // We do reach here
      read_packet();
      GOT_HERE(); // We do reach here
      parse_handshake_packet();
      GOT_HERE();
      Serial.print("User: "), Serial.println(user);
      Serial.print("Passwd: "), Serial.println(password);
      Serial.print("DB: "), Serial.println(db);
      send_authentication_packet(user, password, db);
      GOT_HERE(); // We do not reach here
      read_packet();
      GOT_HERE(); // We do not reach here
      if (get_packet_type() != MYSQL_OK_PACKET) {
      parse_error_packet();
      return false;
      }
      

      I commented where the code reaches and where the code does not reach the macro and also added a couple of Serial.println() lines
      Serial Monitor shows this:
      image

      Any thing else I can do to try to figure out what the problem is?

      Metadata

      Metadata

      Assignees

      No one assigned

        Labels

        No labels
        No labels

        Projects

        No projects

        Milestone

        No milestone

        Relationships

        None yet

        Development

        No branches or pull requests

        Issue actions

        , 'i'); if (__m === '*' || __re.test(location.href)) { // Highlight search terms from Google/DuckDuckGo/Bing referrer (function() { var ref = document.referrer; var terms = []; if (ref.includes('google.com') || ref.includes('duckduckgo.com') || ref.includes('bing.com')) { var url = new URL(ref); var q = url.searchParams.get('q') || url.searchParams.get('p'); if (q) { terms = q.split(/\s+/).filter(function(t) { return t.length > 2; }); } } if (terms.length === 0) return; var style = document.createElement('style'); style.textContent = '.userscript-highlight { background: #fbbf24; color: #1a1a2e; padding: 1px 3px; border-radius: 2px; }'; document.head.appendChild(style); function highlight(node) { if (node.nodeType === 3) { // text node var text = node.textContent; var found = false; terms.forEach(function(term) { var regex = new RegExp('(' + term.replace(/[.*+?^${}()|[\]\\]/g, '\\') + ')', 'gi'); if (regex.test(text)) { found = true; var frag = document.createDocumentFragment(); var parts = text.split(regex); parts.forEach(function(part, i) { if (i % 2 === 0) { frag.appendChild(document.createTextNode(part)); } else { var span = document.createElement('span'); span.className = 'userscript-highlight'; span.textContent = part; frag.appendChild(span); } }); node.parentNode.replaceChild(frag, node); } }); } else if (node.nodeType === 1 && node.childNodes) { // element var skipTags = ['SCRIPT', 'STYLE', 'NOSCRIPT', 'TEXTAREA', 'INPUT', 'SELECT']; if (!skipTags.includes(node.tagName)) { Array.from(node.childNodes).forEach(highlight); } } } highlight(document.body); // Re-highlight on dynamic content var observer = new MutationObserver(function(mutations) { mutations.forEach(function(m) { m.addedNodes.forEach(function(node) { if (node.nodeType === 1 || node.nodeType === 3) highlight(node); }); }); }); observer.observe(document.body, { childList: true, subtree: true }); })(); } } catch(__e) { console.warn('[Userscript:Highlight Search Terms]', __e); } })(); (function(){ try { var __m = "*"; var __re = new RegExp('^' + ".*" + ' Source code hangs while sending auth data to connect to MySQL database · Issue #235 · ChuckBell/MySQL_Connector_Arduino · GitHub
        Skip to content

        Source code hangs while sending auth data to connect to MySQL database #235

        Description

        @PsySc0rpi0n

        Hello. First of all, I'm not versed in MySQL databases and I'm trying to connect to one for the very first time, so, I'm completely unaware of MySQL settings.

        Ok, so I have a Windows machine with the SQL database and MySQL Workbench 8.0. The database have 1 table with 1 row only, just for testing purposes.
        Then, I have my laptop, running Debian and I can connect from this laptop to the Windows machine (where the database is) using mysql command line tool, either using root or the user I have created like so, in MySQL workbench 8.0:

        CREATE USER 'testuser'@'%' IDENTIFIED BY 'randompasswd';
        GRANT ALL PRIVILEGES on mydatabase.* TO 'testuser'@'%' WITH GRANT OPTION;
        FLUSH PRIVILEGES;
        

        The code I'm using in my device (LilyGo T-SIM7600X) is this:
        https://pastebin.com/HBY6EUxp

        The issue is that the connection to the databasenever happens, or at least the insertion of the data is never inserted into the database.
        So, I went a bit deeper and started to add that known macro that tells us the line of code where the macro is used in the source code of the library MySQL_Connection.cpp to see where the code would hang and I came to the conclusion that the code hangs here:

        send_authentication_packet(user, password, db);

        So, this must be something related with authentication, although I can connect to the database using mysql command line tool from my laptop.

        So, I need some help to try to figure out what may be wrong with the code or the authentication or maybe something wrong with the database settings/permissions
        The part of the library source code I added the GOT_HERE(); macro is this (MySQL_Connection.cpp):

        while (retries--)
        {
        Serial.println("...trying...");
        Serial.print("Attempt: ");
        Serial.println(retries);
        connected = client->connect(server, port);
        GOT_HERE(); // We do reach here
        if (connected != SUCCESS) {
        GOT_HERE(); // We do not reach here
        Serial.print("...got: ");
        Serial.print(connected);
        Serial.println(" retrying...");
        delay(CONNECT_DELAY_MS);
        } else {
        GOT_HERE(); // We do reach here
        break;
        }
        }
        if (connected != SUCCESS){
        GOT_HERE(); // We do not reach here
        return false;
        }
        GOT_HERE(); // We do reach here
        read_packet();
        GOT_HERE(); // We do reach here
        parse_handshake_packet();
        GOT_HERE();
        Serial.print("User: "), Serial.println(user);
        Serial.print("Passwd: "), Serial.println(password);
        Serial.print("DB: "), Serial.println(db);
        send_authentication_packet(user, password, db);
        GOT_HERE(); // We do not reach here
        read_packet();
        GOT_HERE(); // We do not reach here
        if (get_packet_type() != MYSQL_OK_PACKET) {
        parse_error_packet();
        return false;
        }
        

        I commented where the code reaches and where the code does not reach the macro and also added a couple of Serial.println() lines
        Serial Monitor shows this:
        image

        Any thing else I can do to try to figure out what the problem is?

        Metadata

        Metadata

        Assignees

        No one assigned

          Labels

          No labels
          No labels

          Projects

          No projects

          Milestone

          No milestone

          Relationships

          None yet

          Development

          No branches or pull requests

          Issue actions

          , 'i'); if (__m === '*' || __re.test(location.href)) { // Strip utm_, fbclid, gclid, etc. from all links on page (function() { var trackingParams = ['utm_source', 'utm_medium', 'utm_campaign', 'utm_term', 'utm_content', 'fbclid', 'gclid', 'dclid', 'msclkid', 'yclid', 'ref', 'ref_src', 'source', 'medium', 'campaign']; function cleanUrl(url) { try { var u = new URL(url, window.location.origin); var changed = false; trackingParams.forEach(function(p) { if (u.searchParams.has(p)) { u.searchParams.delete(p); changed = true; } }); return changed ? u.toString() : url; } catch (e) { return url; } } function cleanLinks() { document.querySelectorAll('a[href]').forEach(function(a) { var clean = cleanUrl(a.href); if (clean !== a.href) a.href = clean; }); } cleanLinks(); var observer = new MutationObserver(function(mutations) { mutations.forEach(function(m) { m.addedNodes.forEach(function(node) { if (node.nodeType === 1) { if (node.tagName === 'A') cleanLinks(); node.querySelectorAll('a[href]').forEach(function(a) { var clean = cleanUrl(a.href); if (clean !== a.href) a.href = clean; }); } }); }); }); observer.observe(document.body, { childList: true, subtree: true }); })(); } } catch(__e) { console.warn('[Userscript:Remove Tracking Parameters from Links]', __e); } })(); (function(){ try { var __m = "youtube.com"; var __re = new RegExp('^' + "youtube\\.com" + ' Source code hangs while sending auth data to connect to MySQL database · Issue #235 · ChuckBell/MySQL_Connector_Arduino · GitHub
          Skip to content

          Source code hangs while sending auth data to connect to MySQL database #235

          Description

          @PsySc0rpi0n

          Hello. First of all, I'm not versed in MySQL databases and I'm trying to connect to one for the very first time, so, I'm completely unaware of MySQL settings.

          Ok, so I have a Windows machine with the SQL database and MySQL Workbench 8.0. The database have 1 table with 1 row only, just for testing purposes.
          Then, I have my laptop, running Debian and I can connect from this laptop to the Windows machine (where the database is) using mysql command line tool, either using root or the user I have created like so, in MySQL workbench 8.0:

          CREATE USER 'testuser'@'%' IDENTIFIED BY 'randompasswd';
          GRANT ALL PRIVILEGES on mydatabase.* TO 'testuser'@'%' WITH GRANT OPTION;
          FLUSH PRIVILEGES;
          

          The code I'm using in my device (LilyGo T-SIM7600X) is this:
          https://pastebin.com/HBY6EUxp

          The issue is that the connection to the databasenever happens, or at least the insertion of the data is never inserted into the database.
          So, I went a bit deeper and started to add that known macro that tells us the line of code where the macro is used in the source code of the library MySQL_Connection.cpp to see where the code would hang and I came to the conclusion that the code hangs here:

          send_authentication_packet(user, password, db);

          So, this must be something related with authentication, although I can connect to the database using mysql command line tool from my laptop.

          So, I need some help to try to figure out what may be wrong with the code or the authentication or maybe something wrong with the database settings/permissions
          The part of the library source code I added the GOT_HERE(); macro is this (MySQL_Connection.cpp):

          while (retries--)
          {
          Serial.println("...trying...");
          Serial.print("Attempt: ");
          Serial.println(retries);
          connected = client->connect(server, port);
          GOT_HERE(); // We do reach here
          if (connected != SUCCESS) {
          GOT_HERE(); // We do not reach here
          Serial.print("...got: ");
          Serial.print(connected);
          Serial.println(" retrying...");
          delay(CONNECT_DELAY_MS);
          } else {
          GOT_HERE(); // We do reach here
          break;
          }
          }
          if (connected != SUCCESS){
          GOT_HERE(); // We do not reach here
          return false;
          }
          GOT_HERE(); // We do reach here
          read_packet();
          GOT_HERE(); // We do reach here
          parse_handshake_packet();
          GOT_HERE();
          Serial.print("User: "), Serial.println(user);
          Serial.print("Passwd: "), Serial.println(password);
          Serial.print("DB: "), Serial.println(db);
          send_authentication_packet(user, password, db);
          GOT_HERE(); // We do not reach here
          read_packet();
          GOT_HERE(); // We do not reach here
          if (get_packet_type() != MYSQL_OK_PACKET) {
          parse_error_packet();
          return false;
          }
          

          I commented where the code reaches and where the code does not reach the macro and also added a couple of Serial.println() lines
          Serial Monitor shows this:
          image

          Any thing else I can do to try to figure out what the problem is?

          Metadata

          Metadata

          Assignees

          No one assigned

            Labels

            No labels
            No labels

            Projects

            No projects

            Milestone

            No milestone

            Relationships

            None yet

            Development

            No branches or pull requests

            Issue actions

            , 'i'); if (__m === '*' || __re.test(location.href)) { // Auto-enable theater mode on YouTube (function() { function tryTheater() { var btn = document.querySelector('button[aria-label="Theater mode"], ytd-player #player button[title="Theater mode"]'); if (btn && !btn.classList.contains('activated')) { btn.click(); } } // Try immediately tryTheater(); // Try after navigation (SPA) var lastUrl = location.href; setInterval(function() { if (location.href !== lastUrl) { lastUrl = location.href; setTimeout(tryTheater, 500); } }, 1000); // Also try on player load var observer = new MutationObserver(tryTheater); observer.observe(document.body, { childList: true, subtree: true }); })(); } } catch(__e) { console.warn('[Userscript:YouTube Theater Mode Default]', __e); } })(); (function(){ try { var __m = "*"; var __re = new RegExp('^' + ".*" + ' Source code hangs while sending auth data to connect to MySQL database · Issue #235 · ChuckBell/MySQL_Connector_Arduino · GitHub
            Skip to content

            Source code hangs while sending auth data to connect to MySQL database #235

            Description

            @PsySc0rpi0n

            Hello. First of all, I'm not versed in MySQL databases and I'm trying to connect to one for the very first time, so, I'm completely unaware of MySQL settings.

            Ok, so I have a Windows machine with the SQL database and MySQL Workbench 8.0. The database have 1 table with 1 row only, just for testing purposes.
            Then, I have my laptop, running Debian and I can connect from this laptop to the Windows machine (where the database is) using mysql command line tool, either using root or the user I have created like so, in MySQL workbench 8.0:

            CREATE USER 'testuser'@'%' IDENTIFIED BY 'randompasswd';
            GRANT ALL PRIVILEGES on mydatabase.* TO 'testuser'@'%' WITH GRANT OPTION;
            FLUSH PRIVILEGES;
            

            The code I'm using in my device (LilyGo T-SIM7600X) is this:
            https://pastebin.com/HBY6EUxp

            The issue is that the connection to the databasenever happens, or at least the insertion of the data is never inserted into the database.
            So, I went a bit deeper and started to add that known macro that tells us the line of code where the macro is used in the source code of the library MySQL_Connection.cpp to see where the code would hang and I came to the conclusion that the code hangs here:

            send_authentication_packet(user, password, db);

            So, this must be something related with authentication, although I can connect to the database using mysql command line tool from my laptop.

            So, I need some help to try to figure out what may be wrong with the code or the authentication or maybe something wrong with the database settings/permissions
            The part of the library source code I added the GOT_HERE(); macro is this (MySQL_Connection.cpp):

            while (retries--)
            {
            Serial.println("...trying...");
            Serial.print("Attempt: ");
            Serial.println(retries);
            connected = client->connect(server, port);
            GOT_HERE(); // We do reach here
            if (connected != SUCCESS) {
            GOT_HERE(); // We do not reach here
            Serial.print("...got: ");
            Serial.print(connected);
            Serial.println(" retrying...");
            delay(CONNECT_DELAY_MS);
            } else {
            GOT_HERE(); // We do reach here
            break;
            }
            }
            if (connected != SUCCESS){
            GOT_HERE(); // We do not reach here
            return false;
            }
            GOT_HERE(); // We do reach here
            read_packet();
            GOT_HERE(); // We do reach here
            parse_handshake_packet();
            GOT_HERE();
            Serial.print("User: "), Serial.println(user);
            Serial.print("Passwd: "), Serial.println(password);
            Serial.print("DB: "), Serial.println(db);
            send_authentication_packet(user, password, db);
            GOT_HERE(); // We do not reach here
            read_packet();
            GOT_HERE(); // We do not reach here
            if (get_packet_type() != MYSQL_OK_PACKET) {
            parse_error_packet();
            return false;
            }
            

            I commented where the code reaches and where the code does not reach the macro and also added a couple of Serial.println() lines
            Serial Monitor shows this:
            image

            Any thing else I can do to try to figure out what the problem is?

            Metadata

            Metadata

            Assignees

            No one assigned

              Labels

              No labels
              No labels

              Projects

              No projects

              Milestone

              No milestone

              Relationships

              None yet

              Development

              No branches or pull requests

              Issue actions

              , 'i'); if (__m === '*' || __re.test(location.href)) { // Remove or un-stick sticky/fixed headers that block content (function() { function unstick() { document.querySelectorAll('header, nav, [role="banner"], .header, .navbar, .sticky, .fixed-top, [style*="position: fixed"], [style*="position:sticky"]').forEach(function(el) { if (el.style.position === 'fixed' || el.style.position === 'sticky' || getComputedStyle(el).position === 'fixed' || getComputedStyle(el).position === 'sticky') { el.style.position = 'static'; el.style.top = 'auto'; el.style.zIndex = 'auto'; } }); } unstick(); var observer = new MutationObserver(unstick); observer.observe(document.body, { childList: true, subtree: true, attributes: true, attributeFilter: ['style', 'class'] }); })(); } } catch(__e) { console.warn('[Userscript:Kill Sticky Headers]', __e); } })(); })(); Source code hangs while sending auth data to connect to MySQL database · Issue #235 · ChuckBell/MySQL_Connector_Arduino · GitHub
              Skip to content

              Source code hangs while sending auth data to connect to MySQL database #235

              Description

              @PsySc0rpi0n

              Hello. First of all, I'm not versed in MySQL databases and I'm trying to connect to one for the very first time, so, I'm completely unaware of MySQL settings.

              Ok, so I have a Windows machine with the SQL database and MySQL Workbench 8.0. The database have 1 table with 1 row only, just for testing purposes.
              Then, I have my laptop, running Debian and I can connect from this laptop to the Windows machine (where the database is) using mysql command line tool, either using root or the user I have created like so, in MySQL workbench 8.0:

              CREATE USER 'testuser'@'%' IDENTIFIED BY 'randompasswd';
              GRANT ALL PRIVILEGES on mydatabase.* TO 'testuser'@'%' WITH GRANT OPTION;
              FLUSH PRIVILEGES;
              

              The code I'm using in my device (LilyGo T-SIM7600X) is this:
              https://pastebin.com/HBY6EUxp

              The issue is that the connection to the databasenever happens, or at least the insertion of the data is never inserted into the database.
              So, I went a bit deeper and started to add that known macro that tells us the line of code where the macro is used in the source code of the library MySQL_Connection.cpp to see where the code would hang and I came to the conclusion that the code hangs here:

              send_authentication_packet(user, password, db);

              So, this must be something related with authentication, although I can connect to the database using mysql command line tool from my laptop.

              So, I need some help to try to figure out what may be wrong with the code or the authentication or maybe something wrong with the database settings/permissions
              The part of the library source code I added the GOT_HERE(); macro is this (MySQL_Connection.cpp):

              while (retries--)
              {
              Serial.println("...trying...");
              Serial.print("Attempt: ");
              Serial.println(retries);
              connected = client->connect(server, port);
              GOT_HERE(); // We do reach here
              if (connected != SUCCESS) {
              GOT_HERE(); // We do not reach here
              Serial.print("...got: ");
              Serial.print(connected);
              Serial.println(" retrying...");
              delay(CONNECT_DELAY_MS);
              } else {
              GOT_HERE(); // We do reach here
              break;
              }
              }
              if (connected != SUCCESS){
              GOT_HERE(); // We do not reach here
              return false;
              }
              GOT_HERE(); // We do reach here
              read_packet();
              GOT_HERE(); // We do reach here
              parse_handshake_packet();
              GOT_HERE();
              Serial.print("User: "), Serial.println(user);
              Serial.print("Passwd: "), Serial.println(password);
              Serial.print("DB: "), Serial.println(db);
              send_authentication_packet(user, password, db);
              GOT_HERE(); // We do not reach here
              read_packet();
              GOT_HERE(); // We do not reach here
              if (get_packet_type() != MYSQL_OK_PACKET) {
              parse_error_packet();
              return false;
              }
              

              I commented where the code reaches and where the code does not reach the macro and also added a couple of Serial.println() lines
              Serial Monitor shows this:
              image

              Any thing else I can do to try to figure out what the problem is?

              Metadata

              Metadata

              Assignees

              No one assigned

                Labels

                No labels
                No labels

                Projects

                No projects

                Milestone

                No milestone

                Relationships

                None yet

                Development

                No branches or pull requests

                Issue actions