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

Problems with phpmyadmin with the character "_" in the name of the DDBB

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by ideasmultiples, May 18, 2010.

  1. ideasmultiples

    ideasmultiples Basic Pleskian

    25
    73%
    Joined:
    May 19, 2004
    Messages:
    83
    Likes Received:
    0
    You can not manage DDBB with the character "_" in the name, when accessing phpMyAdmin from the control panel displays the error: No database.

    Databases without the character "_" in the name are working correctly.

    versión: Plesk 9.52
    phpMyAdmin - 2.11.9.6
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    I have forwarded your request to developers for the further investigation. I will keep thread updated with any received information.
     
  3. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    What is OS version you have there?
     
  4. ideasmultiples

    ideasmultiples Basic Pleskian

    25
    73%
    Joined:
    May 19, 2004
    Messages:
    83
    Likes Received:
    0
    Parallels Plesk Panel version 9.5.2
    Operating system Linux 2.6.18-028stab068.3
    CentOS Linux 5.5
    All installed packages are up to date
    CPU GenuineIntel, Intel(R) Xeon(R)CPU E5520 @ 2.27GHz
    Virtuozzo 4 (All other CT's in this node with Plesk < 5.5 work)
     
  5. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Thank you for details. I have forwarded it to developers. Let's wait their answer.
     
  6. ideasmultiples

    ideasmultiples Basic Pleskian

    25
    73%
    Joined:
    May 19, 2004
    Messages:
    83
    Likes Received:
    0
    "At home solution"

    1 Stop Plesk panel.
    2 Rename the database myphpadmin
    ddbb_client -> ddbbclient
    3 Rename also the name of the database
    psa.data_bases.database.name
    ddbb_client -> ddbbclient
    4 Start Plesk panel.
     
  7. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    I have received following from developers:

     
  8. ideasmultiples

    ideasmultiples Basic Pleskian

    25
    73%
    Joined:
    May 19, 2004
    Messages:
    83
    Likes Received:
    0
    No much more details...

    The process to this server is very simple:

    1. CT for server as created in Plesk 9.3 and working some time...
    2. After some use, whitout any troubles, all domains and clients in server are deleted.
    3. Server upgraded to 9.5
    4 Domains and client imported (migrated from panel) from another 8.6 server (domains working well in this server)
    5 Problems start with mysqladmin.

    Only one detail, this server have a second external database server, with same trouble in database names

    If need access to this server to check, please send me a private.
     
  9. danliker

    danliker Silver Pleskian Plesk Certified Professional

    33
    43%
    Joined:
    Feb 15, 2006
    Messages:
    575
    Likes Received:
    0
    Location:
    Switzerland
    i have the same problem, see ticket 929328
     
  10. ib1984

    ib1984 Basic Pleskian

    23
    70%
    Joined:
    Jun 25, 2008
    Messages:
    91
    Likes Received:
    0
    To resolve the problem, remove 'skip-show-database' from /etc/my.cnf and restart MySQL service. It should help.
     
Loading...