Author Topic: Can't create database after CWP to CWP migration  (Read 1501 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Can't create database after CWP to CWP migration
« on: July 02, 2023, 07:23:53 AM »
There are several unsolved posts on this topic since 2017.
~
I did a migration from:
CWPpro version: 0.9.8.1160 to another CWPpro version: 0.9.8.1160
and what I observe doing tests, is that:

1.- The accounts that already have Databases are migrated correctly and later new Databases can be created without problem.

2.- The accounts that did not even have a Database and that were migrated, can no longer create new Databases from the User Panel
2.1.- The Databases that are created from the User Panel are created without the account prefix: (_database) (_usuariodb)
2.2.- For this reason the User Panel does not have them registered, although I sent the message "...created successfully"

3.- The new Databases of these accounts can only be created from the Administrator Panel (root) and they work correctly, although it is a problem for the User of the account.

Everything indicates that it is a failure in the migration SCRIPT that eliminates or changes some permissions during the restoration of the accounts that do not have Databases.

Hopefully the CWP team can work on the solution, since it is not about support service a single server and the problem has been going on for many years.

(Attached screenshots)



Accounts previous database:


Accounts NO database before migration:

Offline
*****
Re: Can't create database after CWP to CWP migration
« Reply #1 on: July 02, 2023, 01:45:11 PM »
It seems that these DBs come from our cpanel migration, please go to the following file and only leave the accounts that their username has more than 8 characters, the others remove them from this file

/usr/local/cwp/.conf/mysql_user_prefix.conf

Offline
*
Re: Can't create database after CWP to CWP migration
« Reply #2 on: April 26, 2024, 11:23:34 PM »
It seems that these DBs come from our cpanel migration, please go to the following file and only leave the accounts that their username has more than 8 characters, the others remove them from this file

/usr/local/cwp/.conf/mysql_user_prefix.conf

you can right,

Additional cases I encountered after migrating from cwp, the user accounts had ":" at the end.
Remove the ":" and you will see the db when created