Can´t backup / restore virtual servers (Centos 7 / MySQL 5.7.12)

Submitted by rogeriobrito on Fri, 04/15/2016 - 06:28

I have a server (Centos 7) that was running with the default MySQL installation.

I´ve removed MySQL and installed it again (5.7.12) using the Centos Repository. It all went well, but after that I can´t backup or restore virtual servers. I get the errors:

Backup: Saving mail and FTP users .. SQL select user.user,user.password from user,db where db.user = user.user and (db.db = 'plugpecgame' or db.db = 'plugpecgame') failed : Unknown column 'user.password' in 'field list' at ../web-lib-funcs.pl line 1427, line 1.

Restore: Restoring allowed MySQL hosts .. Restore failed : SQL insert into user (host, user, password, ssl_type, ssl_cipher, x509_issuer, x509_subject) values ('%', '*****', password('*******'), '', '', '', '') failed : Unknown column 'password' in 'field list'

Please help Thanks

Status: 
Active

Comments

Submitted by JamieCameron on Fri, 04/15/2016 - 19:41

Which Virtualmin version do you have there? The latest release should have fixed this.

Submitted by andreychek on Wed, 04/27/2016 - 10:17

Howdy -- did you see Jamie's comment above? If that doesn't help, let us know!

Submitted by rogeriobrito on Tue, 05/03/2016 - 22:19

Hello, I'm sorry, I didn't see Jamie's comment, and I didn't get any notification about new comments on the forum. It's an AWS instance, with the following configuration.

System hostname ip-172-30-1-110.ec2.internal (172.30.1.110)
Operating system CentOS Linux 7.2.1511
Webmin version 1.791
Theme version Authentic Theme 17.72
Time on system Wednesday, May 4, 2016 12:12:10
Kernel and CPU Linux 3.10.0-327.13.1.el7.x86_64 on x86_64
Processor information Intel(R) Xeon(R) CPU E5-2666 v3 @ 2.90GHz, 2 cores

I believe it's the latest version, I run yum update weekly. Thanks

Submitted by andreychek on Tue, 05/03/2016 - 22:24

Hmm, none of those actually list your Virtualmin version though. Do you know what Virtualmin version you're running?

If not, you can determine that by running this command:

rpm -qa | grep virtual-server

It sounds like you're updating frequently, but we'd just like to be super-sure about that since Jamie attempted to correct that issue for the latest version.

Submitted by rogeriobrito on Wed, 05/04/2016 - 08:13

Hi Erik,

Here are the versions:

ust-virtual-server-theme-6.9-1.noarch
wbt-virtual-server-mobile-2.5-1.noarch
wbt-virtual-server-theme-9.0-2.noarch
wbm-virtual-server-4.17.gpl-1.noarch

"yum update" should update virtualmin, no?
Thanks

Submitted by andreychek on Wed, 05/04/2016 - 10:34

Yeah it looks like you're using an older version of Virtualmin there. Jamie did address that very issue in the current releases. Version 4.17 came out a little over a year ago.

I suspect you may have a problem with your repository setup if you aren't seeing new updates.

It looks like you're using Virtualmin GPL there though. If you're experiencing problems updating, and you'd like to use free support to look into that, you'd actually want to start a new Forum thread regarding that issue. We monitor the Forums, along with lots of wonderful folks in the community!

Alternatively, you could also purchase a support incident in the "Buy" link above, if you're interested in using the Premium Support area here to address that problem. We'd be happy to help, and in that case could log into your server to determine why the upgrade isn't working.

Submitted by rogeriobrito on Thu, 05/05/2016 - 16:44

Hi Erik,

The virtualmin repo was not setup correctly. On the /etc/yum.repos.d/ I had only centos repos and the file virtualmin.repo.rpmsave . I copied it to virtualmin.repo and the updates were installed successfully.
The file contents is:

[virtualmin]
name=RHEL/CentOS/Scientific $releasever - $basearch - Virtualmin
baseurl=http://GPL:GPL@software.virtualmin.com/gpl/rhel/$releasever/$basearch/
enabled=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-virtualmin
gpgcheck=1

[virtualmin-universal]
name=Virtualmin Distribution Neutral Packages
baseurl=http://GPL:GPL@software.virtualmin.com/gpl/universal/
enabled=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-virtualmin
gpgcheck=1

Backup worked, and it seems everything is ok!

Thank you very much for your help!

-- Rogerio

Submitted by andreychek on Thu, 05/05/2016 - 16:50

It looks like it was renamed by RPM for some reason... what you did is exactly right, renaming the rpmsave file to just "virtualmin.repo".

I'm glad to hear the backup is working as expected now, thanks for letting us know!

Submitted by stheoret on Tue, 11/15/2016 - 11:20

Hi !

Can you explain steps by steps how to remove/install MySQL 5.5.50 to 5.7 ( Latest if possible or the highest ). I am running CENTOS 7.2.1511, Virtualmin 5.04 GPL. PHP 7 is already installed ( this was easy ) now only missing MySQL. I had no success by using tutorials found on Google, the MySQL server was not starting or experiencing a problem with the password... and i had to do a clean install ...

Thanks for sharing

Submitted by andreychek on Tue, 11/15/2016 - 11:41

We don't have an officially supported way of upgrading the MySQL version on a given distro.

Some users have gotten it to work, but there isn't an "official" way of doing that.

If you have additional questions though, the area here is for folks using Virtualmin Pro. For those using Virtualmin GPL, we'd encourage you to use the Forums for support. We monitor the Forums, along with lots of wonderful folks in the community. Thanks!