need to rename an older account that is more than 8 characters

[florenceit]

Hi

the title says it all. cPanel will not allow me to change the account to something 8 chars or less. this is an old account from before cpanel forced 8 characters or less. I wonder if i can get some help on how to rename it, as doing so in cpanel fails:

Unable to fetch the cPanel user file for cummington.RYupSRIXwzhaQw3FKKsn7gkNptShWFIV

There is a database and database users too which i dont want to break. Is there some other way to change these all with one fell swoop like cpanel would if it worked?


thanks!


Matt

 

[cPanelTristan]

Hello Matt,

Please check /var/cpanel/users/cummington file and edit the USER=cummington.RYupSRIXwzhaQw3FKKsn7gkNptShWFIV line to have USER=cummington, then save the file. At that point, try to edit the user again in WHM > Account Modification area.

Thanks!

 

[florenceit]

Hi

there is no USER= line in that file. should I add it?

ie:

USER=cummington

?

 

[cPanelTristan]

Please post the contents of that file:

cat /var/cpanel/users/cummington

 

[florenceit]

Hi

I did just try doing that but still get:
Username

* Username cannot be longer than 8 characters.

when trying to rename the primary domain
Thanks
Matt

 

[cPanelTristan]

Hello Matt,

What did you just do? I asked to see the contents of the file rather to asked you to proceed with changing the file by adding the USER line.

Next, you stated you were trying to rename the username to be less than 8 characters rather than modifying the primary domain but keeping the username at 8 characters. Can you clarify a bit on what you are actually attempting to do? If you are trying to reduce the user to less than 8 characters, then you should be able to do it now probably. You won't be able to modify a user's account that is over 8 characters to have a different domain name.

Thanks!

 

[florenceit]

The last line was just added by myself, seems to have had no affect:

cat cummington
# cPanel -- If you edit this file directly you must run /usr/local/cpanel/scripts/updateuserdomains afterwards to rebuild the system caches.
# If you edit MAX_EMAIL_PER_HOUR or MAX_EMAIL_PER_HOUR-[domain] you must run /usr/local/cpanel/scripts/update_email_limits
BWLIMIT=31457280000
CONTACTEMAIL=DELETEDBYMATT
CONTACTEMAIL2=
DBOWNER=cummington
DEMO=0
DNS=cummington-ma.gov
FEATURELIST=default
HASCGI=1
IP=74.53.166.50
LANG=english
LOCALE=en
MAXADDON=0
MAXFTP=0
MAXLST=4
MAXPARK=0
MAXPOP=100
MAXSQL=4
MAXSUB=0
MTIME=1314043849
OWNER=root
PLAN=Standard Plan
RS=rvblue
STARTDATE=1123732578
USER=cummington
notify_disk_limit=1
notify_email_quota_limit=1
USER=cummington

 

[cPanelTristan]

Did you run /usr/local/cpanel/scripts/updateuserdomains as it indicates at the top of the file after modifying it?

Did you try to reduce the username to be less than 8 characters in WHM > Modify an Account area?

Again, as I stated in my prior post, you will not likely be able to change the primary domain until you've reduced the username to be less than 8 characters, which is the goal you indicated initially being what you wanted to do (reduce the username to less than 8 characters).

 

[florenceit]

Hi
I did not run the command /usr/local/cpanel/scripts/updateuserdomains after adding the user=cummington line.

So i should do this still after adding the user= line? THEN try renaming the account to 8 or less chars? It looks like our posts got mixed up.

Yes my end result is that I need to change the domain name on that account. I will need to contact the client first to ensure this wont cause any problems.

 

[florenceit]

I received the customer ok to make the change and just did so successfully, however it seems to have broken some database issues. I renamed the user to cummingt successfully, but : when visiting the site i get:


Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'cummington_user1'@'localhost' (using password: YES) in /home/cummingt/public_html/DDGAssets/Connections/dbDDGraphics.php on line 9
Access denied for user 'cummington_user1'@'localhost' (using password: YES)

So it looks like it didnt rename everything properly. can you suggest what to change to fix this issue?

Thanks

matt

 

[florenceit]

Hi

turns out that was just a file needing updating in his cms. thank you!

 

[cPanelTristan]

Hi Matt,

You'll need to change any database connection files to using the new MySQL username of cummingt_user1 rather than cummington_user1 as that user doesn't exist any longer. The file is likely /home/cummingt/public_html/DDGAssets/Connections/dbDDGraphics.php that needs the MySQL user's name changed in it.

Thanks.