CustomBuild 2.0: Update to MySQL 5.6 failing

Z

ZipperZapper

Verified User
Joined
Nov 30, 2015
Messages
142
Hello,

Installed a fresh copy of DA today (on Ubuntu 14.04 LTS) and I'm running into a problem with MySQL.

I'm using the CustomBuild 2.0 plugin and I can set MySQL version 5.1, 5.5 or 5.6. But 5.6 isn't working, because it hits a 404 on the Directadmin servers.

It is trying to update to MySQL 5.6.27, with the following link: http://files6.directadmin.com/services/all/mysql/debian/64-bit/mysql-5.6.27-linux-x86_64.tar.gz

That one is trowing a 404, because the latest version on the DA-filesserver is 5.6.12. What's going wrong here? Is something missing on the DA-servers, or is my CustomBuild misbehaving?
 
CB2 should try and download, but we've not stored those tar.gz files for quite some time.
If the file doesn't exist, it should be trying to compile it automatically, so not sure why that's not happening.
Perhaps include the full output from the ./build mysql call? (without the mysql backup parts, just from when it starts the update)

If they file doesn't exist after the download attempt, it should internally set mysql_force_compile=yes, so you can alternatively just set that manually in your options.conf to force it to do so.
So I'm not quite sure what's up, why it's not internally doing that.

Maybe also check:
Code: 
ls -la
to see if any mysql* files exists in your folder.. and if you spot any tar.gz files, what they're named, in case they might have a different build architecture (there are many).

John
 
If I turn force_compile on, it's not really doing anything at all:

Code: 
Executing /usr/local/directadmin/plugins/custombuild/admin/build mysql...
Dumping database mysql 
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
	Dumping database test 
Attempting to compile a package from source...
File already exists
MD5 Checksum on mysql-5.6.27.tar.gz passed.
Extracting mysql-5.6.27.tar.gz ...
Done!

If I switch force_compile off again, it's doing the 404 first and then nothing is happening again:

Code: 
Executing /usr/local/directadmin/plugins/custombuild/admin/build mysql...
Dumping database mysql 
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
	Dumping database test 
--2015-12-02 17:09:27--  http://files6.directadmin.com/services/all/mysql/debian/64-bit/mysql-5.6.27-linux-x86_64.tar.gz
Resolving files6.directadmin.com (files6.directadmin.com)... 2001:16e8:1:4:62:148:181:110, 62.148.181.110
Connecting to files6.directadmin.com (files6.directadmin.com)|2001:16e8:1:4:62:148:181:110|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2015-12-02 17:09:27 ERROR 404: Not Found.

Attempting to compile a package from source...
File already exists
MD5 Checksum on mysql-5.6.27.tar.gz passed.
Extracting mysql-5.6.27.tar.gz ...
Done!
 
I did a fresh install of DirectAdmin today and wanted to give MariaDB a try, but it doesn't look like that's working either? What's going wrong here then?

Code: 
Executing /usr/local/directadmin/plugins/custombuild/admin/build mysql
Cannot find /usr/bin/mysqldump
mv: 'mariadb-10.0.22-linux-glibc_214-x86_64.tar.gz' and '/usr/local/mariadb-10.0.22-linux-glibc_214-x86_64.tar.gz' are the same file
Stopping mysqld ...
Stopping mysqld:		[ FAILED ]
/usr/local/directadmin/custombuild/build: line 7108: cd: mysql: No such file or directory
chown: cannot access '/usr/local/mariadb-10.0.22-linux-glibc_214-x86_64': No such file or directory
/etc/init.d/mysqld: line 27: cd: /usr/local/mysql: No such file or directory
Giving mysqld a few seconds to start up...
Restarting MySQL.
Stopping mysqld:		[ FAILED ]
/etc/init.d/mysqld: line 27: cd: /usr/local/mysql: No such file or directory
Done!
 
ZipperZapper said:
Attempting to compile a package from source...
File already exists
MD5 Checksum on mysql-5.6.27.tar.gz passed.
Extracting mysql-5.6.27.tar.gz ...
Done![/CODE]
Click to expand...
The above looks like it did work correctly.

Regarding the conversion to mariadb, Marynas may need to confirm this for me, but I believe CB doesn't do the conversion for you, rather it only manages the type you currently have installed.
You can manually change the type, and then set the mysql_inst value as needed.

Line 7108 refers to the command "cd mysql" which is in /usr/local, after the extraction should be done, and the link from the true version folder to /usr/local/mysql is created.
Check to see what's there:
ls -la /usr/local

John
 
I don't think I understand. Let's do a bit noob:

- I install a fresh server with Ubuntu 14.04.03 LTS
- I install Directadmin with the installscript.

Is a database server installed at all now? The Custombuild 2.0 plugin is set to 'no' instead of mariadb or mysql after a fresh install.

So, I thought, no database server is installed. Let's say I want to use mariadb, so I select mariadb and hit save. The plugin prompts an update from mariadb 5.5 to 10.0 is available, and if I hit update, I get this:

Code: 
Executing /usr/local/directadmin/plugins/custombuild/admin/build mysql
Cannot find /usr/bin/mysqldump
mv: 'mariadb-10.0.22-linux-glibc_214-x86_64.tar.gz' and '/usr/local/mariadb-10.0.22-linux-glibc_214-x86_64.tar.gz' are the same file
Stopping mysqld ...
Stopping mysqld:		[ FAILED ]
/usr/local/directadmin/custombuild/build: line 7108: cd: mysql: No such file or directory
chown: cannot access '/usr/local/mariadb-10.0.22-linux-glibc_214-x86_64': No such file or directory
/etc/init.d/mysqld: line 27: cd: /usr/local/mysql: No such file or directory
Giving mysqld a few seconds to start up...
Restarting MySQL.
Stopping mysqld:		[ FAILED ]
/etc/init.d/mysqld: line 27: cd: /usr/local/mysql: No such file or directory
Done!

After that, there is no database server available and I receive 'the mysqld service is down' messages all the time.

If I then try to set Custombuild to Mysql, because mariadb does not seem to work, it's complaining mariadb is already installed and I have to remove it?!

So, to be short: I have a clean DirectAdmin server. How do I start using MariaDB?
 
Last edited:
Yes, I did remember to run the pre-install commands. The Debian 8 ones, because Ubuntu 14.04.3 is based on jessie. Only libsystemd-dev fails, that one isn't available in Ubuntu.

When I SSH into the server and do the following it's also failing:

Code: 
./build set mysql_inst mariadb
Changed mysql_inst option from mariadb to mariadb
./build mariadb
Attempting to compile a package from source...
File already exists
MD5 Checksum on mariadb-10.0.22.tar.gz passed.
Extracting mariadb-10.0.22.tar.gz ...
Inconsistency detected by ld.so: dl-version.c: 224: _dl_check_map_versions: Assertion `needed != ((void *)0)' failed!
Done. Making mariadb-10.0.22...
Trying to make mariadb-10.0.22...
make: *** No targets specified and no makefile found.  Stop.

*** The make has failed, would you like to try to make again? (y,n):
y

Trying to make mariadb-10.0.22...
make: *** No targets specified and no makefile found.  Stop.

*** The make has failed, would you like to try to make again? (y,n):

Using ./build mysql instead of using ./build mariadb gives the same output.
 
ZipperZapper, would it be possible to get root access to the box? It'd fix it there and apply changes to CustomBuild 2.0 core, that'd be free of charge of course. You can submit login credentials directly to https://tickets.directadmin.com (I'll see them).
 
I gave it another try, did a fresh install, not using the plugin, directly after installing tried to build mariadb, still no luck.

Code: 
./build set mysql_inst mariadb
Changed mysql_inst option from no to mariadb
./build mariadb
        Dumping database mysql
--2015-12-03 15:32:42--  http://files6.directadmin.com/services/all/mariadb/10.0/10.0.22/mariadb-10.0.22-linux-glibc_214-x86_64.tar.gz
Resolving files6.directadmin.com (files6.directadmin.com)... 2001:16e8:1:4:62:148:181:110, 62.148.181.110
Connecting to files6.directadmin.com (files6.directadmin.com)|2001:16e8:1:4:62:148:181:110|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 407023023 (388M) [application/x-gzip]
Saving to: 'mariadb-10.0.22-linux-glibc_214-x86_64.tar.gz'

100%[===========================================================================>] 407,023,023 55.0MB/s   in 7.5s

2015-12-03 15:32:50 (52.0 MB/s) - 'mariadb-10.0.22-linux-glibc_214-x86_64.tar.gz' saved [407023023/407023023]

mv: 'mariadb-10.0.22-linux-glibc_214-x86_64.tar.gz' and '/usr/local/mariadb-10.0.22-linux-glibc_214-x86_64.tar.gz' are the same file
Stopping mysqld ...
Stopping mysqld:                [ OK ]
./build: line 7108: cd: mysql: No such file or directory
chown: cannot access '/usr/local/mariadb-10.0.22-linux-glibc_214-x86_64': No such file or directory
/etc/init.d/mysqld: line 27: cd: /usr/local/mysql: No such file or directory
Giving mysqld a few seconds to start up...
Restarting MySQL.
Stopping mysqld:                [ FAILED ]
/etc/init.d/mysqld: line 27: cd: /usr/local/mysql: No such file or directory

I will open up a ticket, thanks.
 
Problem with installing MariaDB has been fixed through a ticket and a new revision of Custombuild. Nice work, thanks!
 
DirectAdmin Support said:
CB2 should try and download, but we've not stored those tar.gz files for quite some time.
If the file doesn't exist, it should be trying to compile it automatically, so not sure why that's not happening.
Click to expand...

I also noticed this for a while on Debian systems, is it that before there were precompiled packages or something? Upgrading/building MySQL takes much longer this way I think.
 
You must log in or register to reply here.
Back
Top