account transfer and mysql permissions

[jorj1]

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 !

 

[AndyReed]

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!

 

[jorj1]

mysql transfer

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!

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

 

[AndyReed]

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!

 

[jorj1]

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