After uploading the DirectAdmin backup to a folder on the virtualmin machine I was able to use the migrate option, that was succesfully completed. Itâs a 1,5 Gb file in which we have a wordpress website along with a woocommerce webshop and a bunch of necessarry plugins.
A white screen appeared.
I changed the DNS back to the old server to let the website up. Used the hosts file to point to the virtualmin server.
White screen. The PHP logs and a search on the internet taught me that there was a line with auto_prepend_file in the user.ini that pointed to a wordfence-waf.php file that needed commenting out.
Switched to debug mode in wordpress.
Next challenge; user denied for database connection.
The error: Warning: mysqli_real_connect(): (HY000/1045): Access denied for user âxxxxxx_wp2â@âlocalhostâ (using password: YES) in /home/xxxxxx/public_html/wp-includes/class-wpdb.php on line 1982
Access denied for user 'xxxxxxxx_wp2'@'localhost' (using password: YES)
(names have been changed by xxxxx).
When editing users. I noticed the user xxxxx_wp2 has nothing in the field âDatabase granted access toâ.
This is an stripped Excel of what the users look like:
Iâm lead to believe Iâm missing columns. I do not have the columns Disk quota, Quota used and last login. I checked other accounts (not migrated ones but made from within virtualmin, and they also lack those columns. I also do not understand why my list of database users do not show Database in the last column called Login Access, but maybe thatâs not necessarry. I changed the applicable database user (itâs in my php-config file, so I know the right one) and try to âchangeâ the password to the pw mentioned in the php-config file, still no connection. I seems to be missing more. Maybe my virtualmin install is not complete?
Ow wait, is this in the Pro version? Should I upgrade first before getting this to work? I was hoping to be able to test it before, but maybe thatâs not possible?
I got further along than this, using the GPL version. I am curious if, when you created the Virtualmin server, you did the full or the minimal installation?
In any event, as you could see from my last post in the initial thread on migration issues, the migration process may be broken and is being looked into by @Ilia and @Jamie and I am hopeful they will be able to fix it.
I donât know if itâs visible in the versions or whatever, but I have noticed that when I am using small older boxes to test things on Iâve done minimal installs (added ââminimalâ switch in the initial loading command of Virtualmin). I notice that one of the things that is not installed during that is Fail2Ban (Webmin > Networking). If you did a regular installation and just followed the directions, I think itâs safe to say you have the full installation. If thatâs the case you are probably running what I am.
In any event, I am hoping we hear from @Ilya or @Jamie on this situation, as the migration from DirectAdmin backups definitely doesnât function as expected. What we have been doing is creating the space on the Virtualmin box, adding WordPress, and using the All in One Migration by ServMask to move the WordPress site into the Virtualmin box. Unfortunately, all AWStats are lost during this process and that is important to a number of my web clients.
Thanks Charles. Iâve been thinking about that too, but that doesnât bring over my mailboxes etc. And I run the mailboxes in the same package. As a matter of fact, the limitation of the mailboxes was another reason to move away from my current provider. After weeks of messing around I finally got virtualmin to mail back and forth 10/10 points score.
Bu whether the migration works well or not, that should not explain why I have less columns on the user section than @jimr1 was showing in his example.
That said, I think managing multiple database users per domain more easily is one feature in Pro. But, if these users were in the backup and had access to the database, they probably should have been handled by the restore.
So, to narrow down the problem, am I understanding correctly that on the DirectAdmin server, you have several users with database access (to the same database in the same domain, not multiple domain accounts with separate databases) being managed by DirectAdmin as part of the domain, and all of those database users are needed for the WordPress site? That feels like Iâm misunderstanding something, as most WordPress sites just have one database configuration.
Generally speaking, users in a domain should come across with most of their privileges intact as best Virtualmin can understand them and translate them to the way Virtualmin thinks about users. But, itâs plausible Virtualmin historically didnât think about multiple database users per-domainâŠso maybe DirectAdmin migration, which doesnât get a lot of exercise, simply doesnât think about that. In the short term, you may need to grant those users the access they need. Longer term, itâs probably something we can fix in the migration.
Thank you. Actually, I was surpised to see multiple users and DBâs within that DA backup. This domain is from 1999 if Iâm correct and most have had dozens of new websites over the decades. I seriously doubt all of them are used, but I havenât had the guts to start removing them as well as their users.
If I simply look at the current wp-config file, it refers to:
That leads me to believe that wp2 is the BD and user that is currently used. Since we used an auto installer in DA all these were automatically generated.
But sine there have been/are running other sites on subdomains and folders, and plugins like woocommerce, Iâm not entirely sure if they all use the same DB, or if some of them are still in use. For the time being Iâd ignore everything but the above mentioned. Iâll clean 'em up one day.
As you said; I can not see a reason why it would not connect anymore in Virtualmin unless something changed in the rights of the user or folder, or the password is too long/complicated or otherwise. I donât know. I tried adding that long password in virtualin to that user rjXXXXX_wp2 but then it came up that the user already exists.
Failed to save user : MariaDB database login with the name rjxxxxxx_wp2 already exists
Hi Jamie, I have not submitted the backup anywhere before. You mean the entire DA 1,5 Gb backup? If you can give me an e-mail address I can upload it through WeTransfer if you like, it contains a lot of sensitive- and customer information, I trust it will be treated likewise.
I also ran into this: Errors were found in your systemâs BIND configuration : /var/lib/bind/hostservice.nl.hosts:2: no TTL specified; using SOA MINTTL instead, dns_rdata_fromtext: /var/lib/bind/hostservice.nl.hosts:16: near âINâ: syntax error, zone hostservice.nl/IN: loading from master file /var/lib/bind/hostservice.nl.hosts failed: syntax error, zone hostservice.nl/IN: not loaded due to errors., _default/hostservice.nl/IN: syntax error
Could that have to do that currently the domain is pointed at the old server? Or is this a migration issue as well.
