Impact of changing cpanel username on gallery 2.3 installation?

Arnieg

Joined: 2009-06-13
Posts: 2
Posted: Sat, 2010-04-17 13:09

After I installed gallery (2.3), for security reasons I decided I needed to change the cpanel username where Gallery is installed. What I would like to do is to use cpanel to change the username and then modified the various places where Gallery uses the cpanel "username". I believe it can be done using the following procedure:

CPANEL

1. Using cpanel WHM, change username from "olduser" to "newuser"

thus the folder /home/olduser is changed to /home/newuser

GALLERY

1. In the initial installation, gallery was installed as follows:

Full installation path: /home/olduser/public_html
MySQL database: olduser_gllr2
MySQL user: olduser_gllr2

config.php (3 instances were olduser appears)

2. After I have changed the username to "newuser" in cpanel, I would change Gallery to the following:

Full installation path: /home/newuser/public_html

Edit the following to change the name:

MySQL database: newuser_gllr2
MySQL user: newuser_gllr2

edit config.php to replace 3 occurrences of "olduser" with "newuser"

QUESTION: Can this be done as described above? If not what have I missed?

I have set up a test installation where I can experiment to see if this works before I try it on my production site.

I know it would be simpler just to uninstall the current installation of Gallery, use cpanel to change the username and then re-install Gallery. However, the current installation takes up about 250 mb with 3 sub albums. Each sub album has between 5-10 of their own sub albums and the total number of photos is in the hundreds. Also their are many comments associated with the photos which I would hate to lose.

 
alecmyers

Joined: 2006-08-01
Posts: 4342
Posted: Sat, 2010-04-17 13:22

Most people who know anything about Gallery around here loathe and detest cpanel, fantastico, and all packaged and 'automatic' installations. They cause no end of support problems and the best advice is to have nothing to do with any of them - install Gallery2 from from the downloads on *this* website *only*.