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

florenceit

Member
Jan 11, 2010
16
0
51
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

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
42
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
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

Member
Jan 11, 2010
16
0
51
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

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
42
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
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

Member
Jan 11, 2010
16
0
51
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

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
42
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
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

Member
Jan 11, 2010
16
0
51
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

Member
Jan 11, 2010
16
0
51
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
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
42
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
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.