1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

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

    22
    23%
    Joined:
    Apr 12, 2011
    Messages:
    131
    Likes Received:
    1
    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 Plesk addicted!

    44
    64%
    Joined:
    Jun 11, 2013
    Messages:
    6,762
    Likes Received:
    1,712
    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

    22
    23%
    Joined:
    Apr 12, 2011
    Messages:
    131
    Likes Received:
    1
  4. LarsenD

    LarsenD Regular Pleskian

    22
    23%
    Joined:
    Apr 12, 2011
    Messages:
    131
    Likes Received:
    1
    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...