Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved mysql connect in terminal not working on an old LAMP app (1.4.0)

    Support
    mysql lamp console
    3
    6
    342
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      msbt App Dev last edited by

      I have this ancient LAMP app with a shop in it that is finally going to be upgraded (I know I know, but it wouldn't work on >PHP7.2). After cloning the production image to test imports and exports, I wanted to jump on the mysql console to change the urls of the shop. But when I tried to connect, this is what happened:

      mysql --user=${MYSQL_USERNAME} --password=${MYSQL_PASSWORD} --host=${MYSQL_HOST} ${MYSQL_DATABASE} 
      ERROR 2026 (HY000): SSL connection error: unknown error number
      

      I reckon this is because of the new MYSQL version you installed, do you know of a trick to connect either way? Couldn't find a real solution...

      girish 1 Reply Last reply Reply Quote 0
      • girish
        girish Staff @msbt last edited by

        @msbt Right, the old one mysql CLI is not able to connect with new mysql 8. Best way is to upgrade to PHP 7.4 app.

        If that's not an option:

        • Grab the env vars from env | grep MYSQL
        • Then use the web terminal of some other app that uses mysql (or just install lamp 7.4). Then in that web terminal, use the MYSQL vaules from above.
        M 1 Reply Last reply Reply Quote 1
        • M
          msbt App Dev @girish last edited by

          @girish perfect, worked like a charm! Just to be on the safe side: Will the old LAMP continue working or are there any breaking changes coming up soon?

          scooke girish 2 Replies Last reply Reply Quote 0
          • scooke
            scooke @msbt last edited by

            @msbt Can you tell us what worked like a charm? Upgrading to PHP 7.4, or gradding the env vars?

            A life lived in fear is a life half-lived

            M 1 Reply Last reply Reply Quote 0
            • M
              msbt App Dev @scooke last edited by

              @scooke using the terminal of a different app to connect to the LAMP 1.4.0 database

              1 Reply Last reply Reply Quote 1
              • girish
                girish Staff @msbt last edited by

                @msbt the old LAMP app will be left as-is. So, no change to that in the foreseeable future.

                1 Reply Last reply Reply Quote 1
                • First post
                  Last post
                Powered by NodeBB