Dismiss Notice
Plesk Onyx 17.5 is now available for everyone and we'd love to hear your thoughts on the new Plesk version. Visit this thread for more details.

Resolved ERROR 1102 (42000) at line 20: Incorrect database name ''

Discussion in 'Plesk 12.x for Linux' started by LarsenD, Nov 20, 2014.

  1. LarsenD

    LarsenD Regular Pleskian

    16
    35%
    Messages:
    130
    Likes Received:
    1
    Trophy Points:
    227
    This is just a bug report. No help needed as it doesn´t seem to cause problems.

    When I update servers via CLI autoinstaller, I sometimes (or on some servers) get this error message:
    Code:
    Trying to start psa...
    Stopping psa... Stopping Plesk engine pool manager: sw-engine-fpm.
    done
    ===> Installing phpMyAdmin
    Trying to create pmadb... ERROR 1102 (42000) at line 20: Incorrect database name ''
    
    Afaik, no server has this DB.
     
  2. UFHH01

    UFHH01 Platinum Pleskian Plesk Guru

    33
    30%
    Messages:
    4,436
    Likes Received:
    893
    Trophy Points:
    732
    Location:
    Hamburg / Germany
    Not all "ERROR" in your log - file might cause issues/problems... it might as well only point to some misconfigurations, or missing features from a complete basic Plesk installation.
     
  3. LarsenD

    LarsenD Regular Pleskian

    16
    35%
    Messages:
    130
    Likes Received:
    1
    Trophy Points:
    227
  4. LarsenD

    LarsenD Regular Pleskian

    16
    35%
    Messages:
    130
    Likes Received:
    1
    Trophy Points:
    227
    Found the reason and fix myself.

    Plesk uses the old phpMyAdmin config from "/opt/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php". Probably due to a bug in an old version of Plesk, this did not contain the database name, but this:
    Code:
    $cfg['Servers'][$i]['pmadb'] = $GLOBALS['db_host'] != 'localhost' ? '' : '';
    When it should contain something like this:
    Code:
    $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin__lL4vGxF8vvH';
    Check this by executing:
    Code:
    grep pmadb /opt/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php
    Solution:
    - Delete all phpMyAdmin databases
    - rm -f /opt/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php
    - Upgrade Plesk
     
Loading...