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


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

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

Scheduled Pinned Locked Moved Solved Support
mysqllampconsole
6 Posts 3 Posters 350 Views
    • 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 Offline
    M Offline
    msbt App Dev
    wrote on last edited by
    #1

    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...

    girishG 1 Reply Last reply
    0
  • girishG Offline
    girishG Offline
    girish Staff
    replied to msbt on last edited by
    #2

    @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
    1
  • M Offline
    M Offline
    msbt App Dev
    replied to girish on last edited by
    #3

    @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?

    scookeS girishG 2 Replies Last reply
    0
  • scookeS Offline
    scookeS Offline
    scooke
    replied to msbt on last edited by
    #4

    @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
    0
  • M Offline
    M Offline
    msbt App Dev
    replied to scooke on last edited by
    #5

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

    1 Reply Last reply
    1
  • girishG Offline
    girishG Offline
    girish Staff
    replied to msbt on last edited by
    #6

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

    1 Reply Last reply
    1

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.