PMA can't launch -- lc_messages error

Nate Policar's Avatar

Nate Policar

10 Jul, 2018 12:48 AM

Launched a new instance using the scalr AMI for mysql on centos. Setup PMA access.
Ran yum update to make sure running latest instance of mysql, kernel, etc.
When attempting to access PMA, getting the following error(s):

http://phpmyadmin.scalr.net/index.php?server=1

SET lc_messages = 'en_US';
MySQL said: Documentation
#1193 - Unknown system variable 'lc_messages'

Warning in ./libraries/dbi/DBIMysqli.php#556
mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given

Backtrace

./libraries/dbi/DBIMysqli.php#556: mysqli_real_escape_string(
boolean false,
string '_',
)
./libraries/DatabaseInterface.php#2735: PMA\libraries\dbi\DBIMysqli->escapeString(
boolean false,
string '_',
)
./libraries/navigation/nodes/Node.php#437: PMA\libraries\DatabaseInterface->escapeString(string '_')
./libraries/navigation/NavigationTree.php#289: PMA\libraries\navigation\nodes\Node->getData(
string 'databases',
integer 0,
string '',
)
./libraries/navigation/NavigationTree.php#847: PMA\libraries\navigation\NavigationTree->_buildPath()
./libraries/navigation/Navigation.php#45: PMA\libraries\navigation\NavigationTree->renderState()
./libraries/Header.php#425: PMA\libraries\navigation\Navigation->getDisplay()
./libraries/Response.php#260: PMA\libraries\Header->getDisplay()
./libraries/Response.php#273: PMA\libraries\Response->_getDisplay()
./libraries/Response.php#432: PMA\libraries\Response->_htmlResponse()
PMA\libraries\Response->response()
Warning in ./libraries/dbi/DBIMysqli.php#556
mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given

Backtrace

./libraries/dbi/DBIMysqli.php#556: mysqli_real_escape_string(
boolean false,
string '_',
)
./libraries/DatabaseInterface.php#2735: PMA\libraries\dbi\DBIMysqli->escapeString(
boolean false,
string '_',
)
./libraries/navigation/nodes/Node.php#447: PMA\libraries\DatabaseInterface->escapeString(string '_')
./libraries/navigation/NavigationTree.php#289: PMA\libraries\navigation\nodes\Node->getData(
string 'databases',
integer 0,
string '',
)
./libraries/navigation/NavigationTree.php#847: PMA\libraries\navigation\NavigationTree->_buildPath()
./libraries/navigation/Navigation.php#45: PMA\libraries\navigation\NavigationTree->renderState()
./libraries/Header.php#425: PMA\libraries\navigation\Navigation->getDisplay()
./libraries/Response.php#260: PMA\libraries\Header->getDisplay()
./libraries/Response.php#273: PMA\libraries\Response->_getDisplay()
./libraries/Response.php#432: PMA\libraries\Response->_htmlResponse()
PMA\libraries\Response->response()
Warning in ./libraries/dbi/DBIMysqli.php#556
mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given

Backtrace

./libraries/dbi/DBIMysqli.php#556: mysqli_real_escape_string(
boolean false,
string '_',
)
./libraries/DatabaseInterface.php#2735: PMA\libraries\dbi\DBIMysqli->escapeString(
boolean false,
string '_',
)
./libraries/navigation/nodes/Node.php#449: PMA\libraries\DatabaseInterface->escapeString(string '_')
./libraries/navigation/NavigationTree.php#289: PMA\libraries\navigation\nodes\Node->getData(
string 'databases',
integer 0,
string '',
)
./libraries/navigation/NavigationTree.php#847: PMA\libraries\navigation\NavigationTree->_buildPath()
./libraries/navigation/Navigation.php#45: PMA\libraries\navigation\NavigationTree->renderState()
./libraries/Header.php#425: PMA\libraries\navigation\Navigation->getDisplay()
./libraries/Response.php#260: PMA\libraries\Header->getDisplay()
./libraries/Response.php#273: PMA\libraries\Response->_getDisplay()
./libraries/Response.php#432: PMA\libraries\Response->_htmlResponse()
PMA\libraries\Response->response()

  1. Support Staff 1 Posted by Igor Savchenko on 10 Jul, 2018 10:28 PM

    Igor Savchenko's Avatar

    Hi Nate,

    Can you please try again and if it won't work, let me know FarmID on which you're trying to use it.

    Regards,
    Igor

  2. 2 Posted by Nate Policar on 10 Jul, 2018 11:59 PM

    Nate Policar's Avatar

    Still having the same issue ('lc_messages'). Farm ID #25460

    Also are you guys aware of any issues with the mysql scalr AMIs and the
    latest generation of AWS instances? I can get it to run fine on m3 and
    m4 instances, but as soon as I move to the latest generation m5 the
    server fails to initialize (works fine for non-mysql automated roles
    like the apache and nginx roles).

  3. Support Staff 3 Posted by Igor Savchenko on 11 Jul, 2018 06:15 PM

    Igor Savchenko's Avatar
    1. phpmyadmin: The issue is that you're using old version of MySQL: 5.1 which is no longer supported by phpmyadmin. I would recommend you to upgrade or migrate to a newer version of mysql 5.5 or 5.6

    2. Re: m5 instance types, this instance family requires HVM AMIs. What AMI/Role you're trying to use?

    Regards,
    Igor

  4. 4 Posted by Nate Policar on 11 Jul, 2018 06:26 PM

    Nate Policar's Avatar

    I chose role id #96498 the quickstart mysql image labeled
    'mysql55-centos6' that says it has mysql5.5 and HVM enabled. Very
    frustrating to hear that it does not indeed have mysql 5.5 installed,
    when this is a Scalr role/image and it says that it does. I don't know
    if I can trust if the role is HVM either even though Scalr says it is
    when I add it to the farm.

    I'd like to be able to use mysql on a Centos7 HVM ami, but I don't see
    any Scalr-scope images that support that, and I think if I build my own
    image, I won't be able to take advantage of Scalr's mysql automation
    (pma, replication, etc.) Is that correct, and if so, are there plans for
    an updated mysql image?

  5. Support Staff 5 Posted by Igor Savchenko on 11 Jul, 2018 06:32 PM

    Igor Savchenko's Avatar

    Hm, mysql55-centos6 should have MySQL 5.5. Let me double check this with our shared images team.

    I'll get back to you ASAP on CentOS 7 image as well.

    Regards,
    Igor

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac