Custombuild MySQL upgrade fails

dan

Verified User
Joined
Jan 2, 2007
Messages
99
Location
North Wales, UK
I've got an issue whereby MySQL fails to update within the custombuild script. This happens nightly on the cron update, but also manually by hand. It's messed the URLs up somewhere within the script, and no matter whether I update the script or its data, it still fails with the same error...

Code:
--2018-05-06 04:00:34--  http://all/mysql/5.6/5.6.38/64-bit/5.6.38/MySQL-client-5.6.38-1.el6.x86_64.rpm
Resolving all... failed: Name or service not known.
wget: unable to resolve host address `all'
--2018-05-06 04:00:34--  http://all/mysql/5.6/5.6.38/64-bit/5.6.38/MySQL-devel-5.6.38-1.el6.x86_64.rpm
Resolving all... failed: Name or service not known.
wget: unable to resolve host address `all'
--2018-05-06 04:00:34--  http://all/mysql/5.6/5.6.38/64-bit/5.6.38/MySQL-server-5.6.38-1.el6.x86_64.rpm
Resolving all... failed: Name or service not known.
wget: unable to resolve host address `all'
--2018-05-06 04:00:34--  http://all/mysql/5.6/5.6.38/64-bit/5.6.38/MySQL-shared-5.6.38-1.el6.x86_64.rpm
Resolving all... failed: Name or service not known.
wget: unable to resolve host address `all'
*** Cannot find /usr/local/directadmin/custombuild/mysql/MySQL-client-5.6.38-1.el6.x86_64.rpm. Aborting ***

Does anyone have any idea what's going on here and how I can go about fixing it? I can see it's actually downloaded the rpm file already, it's sitting in /usr/local/directadmin/custombuild/mysql, so I'm not even sure why it's trying to go out to the internet for it.

Help appreciated!

Dan
 
Hello Dan,

Issues with DNS resolvers?

Code:
cat /etc/resolv.conf

Wrong values in options.conf for downloadserver?

Code:
grep downloadserver= /usr/local/directadmin/custombuild/options.conf

Try
Code:
./build set_fastest
?
 
Hello Dan,
Issues with DNS resolvers?

Nope. If you look at the URL it's trying to request, http://all/...? Definitely invalid.

Wrong values in options.conf for downloadserver?

downloadserver=files2.directadmin.com

Try
Code:
./build set_fastest
?

Ran that. It changed downloadserver from files2.directadmin.com to files2.directadmin.com.

Essentially it's being told to request the RPM from an invalid URL. Though I can't find any reference to that URL, or prefix, anywhere. Nor would I know what to change it to if I could find it.
 
Tried all this, doesn't work either. Same result.

The weird thing is it *has* the files already on the server, in /usr/local/directadmin/custombuild/mysql/, so I don't know why it's trying to download them again (unless perhaps the file hashes that is has in reference are incorrect).

Code:
# ls /usr/local/directadmin/custombuild/mysql/
MySQL-client-5.6.38-1.el6.x86_64.rpm             MySQL-devel-5.6.38-1.el6.x86_64.rpm             MySQL-server-5.6.38-1.el6.x86_64.rpm             MySQL-shared-5.6.38-1.el6.x86_64.rpm

And in fact, that URL you posted gives me a clue as to what it's missing.

The URL it's trying to request is http://all/mysql/5.6/5.6.38/64-bit/5.6.38/MySQL-client-5.6.38-1.el6.x86_64.rpm which is obviously incorrect, the correct URL being http://files.directadmin.com/servic...8/64-bit/MySQL-client-5.6.38-1.el6.x86_64.rpm. It's missing the "filesX.directadmin.com/services" prefix, and there's a "64-bit" part missing as well towards the end.

If I download the files manually, am I supposed to put them in that mysql directory, or in the custombuild directory where all the other files seem to be (though they're all gzipped tarballs by the looks of it, whereas this is an rpm..not sure if there's a difference with how custombuild treats these)?
 
I feel stupid now.

I went to delete the existing rpm files to replace them with fresh ones from the files repo. rm told me all I needed to know...

Code:
# rm *.el6.x86_64.rpm
rm: remove regular empty file `MySQL-client-5.6.38-1.el6.x86_64.rpm'? y
rm: remove regular empty file `MySQL-devel-5.6.38-1.el6.x86_64.rpm'? y
rm: remove regular empty file `MySQL-server-5.6.38-1.el6.x86_64.rpm'? y
rm: remove regular empty file `MySQL-shared-5.6.38-1.el6.x86_64.rpm'? y

I should have just checked the md5sums myself. Or ls -l.

Thanks :)
 
To upload MySQL version first you need to delete the old version.

Remember to make a backup before anything or if you have a vps snapshot.
 
Back
Top