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.

account transfer and mysql permissions

Discussion in 'General Discussion' started by jorj1, May 12, 2005.

  1. jorj1

    jorj1 Member

    Joined:
    Nov 21, 2004
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Digging and digging for two hours now for a solution to help me transfer a bunch of accounts from Ensim to Cpanel and no solution yet. Here's the problem:

    WHM 10.1.0 cPanel 10.2.0-S83
    I am transfering one account with root password and everything is ok except two minor warnings:
    - Restoring addon domains section: "Restoring Files..../bin/cp: cannot overwrite non-directory `/home/merrick/www' with directory `/home/cpmove-merrick/homedir/www' ......... ......... Done"
    - Restore Complete section: "Removing Copied Archive... Invalid Account"

    Wonderful by now except that the user is not set correctly on the new databases. I can see the user in root's phpMyAdmin but not in user's phpMyAdmin. And if I try to create a new user for the user's databases then everything is messing up.

    Seems others have problem when comes to transfer the databases and found a solution so tricky that I'm affraid to try:
    http://forums.cpanel.net/showthread.php?t=33208&page=2&pp=15&highlight=transfer+invalid+account

    Suggestions ?

    Thanks a LOT !
     
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    Ensim is very different than CPanel in terms of system layout and structure. Every single user is inserted in a main MySQL DB. Ensim and CPanel/WHM are completely different and you'll have to do a lot of "manual" import of MySQL DB and re-create email accounts.

    Whether you are using Ensim 3.x or Pro 4.0.3, you'll find WHM/CPanel more user-friendly and robust.

    Hope this helps!
     
  3. jorj1

    jorj1 Member

    Joined:
    Nov 21, 2004
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    mysql transfer

    Thanks. I know that ensim is different and difficult and that's why I'm moving to cpanel.

    Still, the problem does not rezide in the way Ensim stores its databases I think because there is an inconsistency related to user access AFTER the database has been brought to cpanel.

    As I see it cpanel stores the DB user in some place and fails to assign it to the new tables although it is correctly set in mysql (phpmyadmin as root proves it). On the other hand, if I create the DB user by hand then is not found in phmyadmin-root view.

    Simpler question: does anyone know where these db users are stored inside cpanel ? I think it should be a db file somewhere. This would allow me to dig further.

    Thanks
     
  4. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    I think you're still treating/looking at CPanel through Ensim. CPanel access files and DBs differently than Ensim. Save your self all the time and hassle and import your DBs manually and assign them to their own users through their CPanel.

    Good luck!
     
  5. jorj1

    jorj1 Member

    Joined:
    Nov 21, 2004
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    No, I to not treat cpanel through Ensim's eyes simply because I'm relatively new in server administration and I adopted cpanel imediatelly while ensim is still a headache-type panel for me, mainly due it's own user-centric tree file system.

    Still, since transfering accounts from ensim exists as an option into Cpanel I though it should be someone who have it working at a certain moment.

    I'd really want to read a one-page guide about where cpanel put it's files (user db, config templates, etc) so a developer can add plugins or help figuring out why a certain bug appears. Or maybe its obvious but not for newmbies like me :)

    Cheers
     
Loading...

Share This Page