Skip to main content

problem in renaming account username

dzamanakos
Hi, i'm trying (for the first time) to rename an account username from user1 to user2. I've changed the username in modify user page, pressed save and got an error abour postgress not running and missing pg_hba.conf. I dont use postgress, but in order to continue, i 've enabled postgress, created the conf and users. Next i got an error about user portal_local that couldnt connect (cant remember exactly the error), read some articles and changed some permissions on the pg_hba.conf file. Now when i save i get a: API failure: You do not control a MySQL user named "user1". There isnt any db user with that name, users for my dbs are user1_db1, user1_db2 etc. Is there anything i can do (i have many renames to do), instead of uncheck the "Rename prefixed databases and database users." and then manually change the database names? Thank you in advance,

Comments

8 comments

Date Votes
  • cPanelMichael
    Hello :) Please let us know the version of cPanel installed on your system:
    cat /usr/local/cpanel/version
    Also, does this issue persist on additional accounts? Thank you.
    0
  • dzamanakos
    Hi, tried to rename another account (username elenascr) and first i got this message : PI failure: Although the system"s database map includes a PostgreSQL user named "elenascr", the PostgreSQL server reported that no user with this name exists. Contact your system administrator. I went to users cpanel and clicked the Synchronize Grants in postress button. Then i tried to rename again the account and i get a : API failure: You do not control a MySQL user named "elenascr". my database is elenascr_db (elenascr is the username) The version is : cat /usr/local/cpanel/version 11.46.0.17 Thank you.
    0
  • cPanelPeter cPanel Staff
    Hello, Please open a support ticket using the link in my signature. One of our analysts will investigate this issue for you. Please post the ticket number here so we can update this thread accordingly.
    0
  • dzamanakos
    ]Hello, Please open a support ticket using the link in my signature. One of our analysts will investigate this issue for you. Please post the ticket number here so we can update this thread accordingly.

    Ticket : 5776845 Thank you for your help.
    0
  • cPanelMichael
    To update, this was resolved after moving the root postgres user entry to the top of the /root/.pgpass file. Internal case number 143773 has been opened to prevent this from happening in the future. Thank you.
    0
  • jblairjoly
    Hi, I have the same issue on a brand new server. Can you help me fix this issue? Thanks.
    0
  • jblairjoly
    Fix the issue by upgrading cpanel.
    0
  • cPanelMichael
    Hello :) Yes, the issue was addressed in cPanel version 11.48. I am happy to see updating cPanel on your system resolved the issue. Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post