Characters get chopped of the database name

Follow

Comments

4 comments

  • Avatar
    Paul Smiechowicz
    1. Login to SSH and get admin password cat /etc/psa/.psa.shadow 
    2. Login to mysql: mysql -uadmin -p psa
    3. USE psa;
    4. ALTER TABLE DatabaseServers MODIFY host VARCHAR(255);
    0
    Comment actions Permalink
  • Avatar
    Konstantin Annikov

    @Paul Smiechowicz

    Thank you for the comment.
    1. It is not recommended to share your MySQL password in public. So, we have edited your comment.
    2. The bug will be fixed in next major update of Plesk and during the fix, similar change will be done. Update may fail in case database description has been manually edited previously. So, I strongly do not recommend you to apply that workaround.

    0
    Comment actions Permalink
  • Avatar
    Paul Smiechowicz

    If you do not recommend applying this workaround what is my solution? I can't use an IP address. I need to use an external AWS database with a 87 character endpoint, the IP address can/will change. I know I can hard coded the database in the script but the clients wants the connection in Plesk so they can manage database/users PHP admin.

    That was the whole point of getting Plesk in the first place.

    P.S the mysql password in the post was fake.

     

    0
    Comment actions Permalink
  • Avatar
    Konstantin Annikov

    @Paul Smiechowicz

    Alternatively, you can create an CNAME/ALIAS DNS record with shorter name, so you can add that DB server to Plesk. 


    However, if it is not acceptable for you, the mentioned workaround (modifying database table) could be used. And please be careful while upgrading Plesk after that. There is a probability that update could not be completed once the bug is fixed. 

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request