The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

problem in renaming account username

Discussion in 'General Discussion' started by dzamanakos, Nov 18, 2014.

  1. dzamanakos

    dzamanakos Active Member

    Joined:
    Feb 15, 2014
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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,
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,667
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please let us know the version of cPanel installed on your system:

    Code:
    cat /usr/local/cpanel/version
    Also, does this issue persist on additional accounts?

    Thank you.
     
  3. dzamanakos

    dzamanakos Active Member

    Joined:
    Feb 15, 2014
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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.
     
  4. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    569
    Likes Received:
    15
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
  5. dzamanakos

    dzamanakos Active Member

    Joined:
    Feb 15, 2014
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator

    Ticket : 5776845

    Thank you for your help.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,667
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  7. jblairjoly

    jblairjoly Member

    Joined:
    Jan 17, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    I have the same issue on a brand new server. Can you help me fix this issue?

    Thanks.
     
  8. jblairjoly

    jblairjoly Member

    Joined:
    Jan 17, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Fix the issue by upgrading cpanel.
     
  9. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,667
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page