MySQL 5.5

meto · Dec 16, 2010

Is it now good time to add it to custom build?

http://www.oracle.com/us/corporate/press/195726

scsi · Dec 16, 2010

I think it was just added.

meto · Dec 16, 2010

That would be great news. Which verison of custombuild?

truenegative · Dec 22, 2010

I can't seem to get it to install using custombuild... has anyone tried yet?

nmb · Dec 22, 2010

Just check "build" script 1.2.14 but there is no option in there about 5.5. Only 5.0 and 5.1. So, I guess, it's not in CustomBuild yet.

echo "#Possible values - 5.0, 5.1" >> ${OPTIONS_CONF}

But then, I saw some reference to 5.5 though.

elif [ "${MYSQL_OPT}" = "5.5" ]; then
MYSQL_VER=`getVer mysql5.5`

if [ "${MYSQL_OPT}" = "5.1" ] || [ "${MYSQL_OPT}" = "5.5" ]; then

________
Zx14 vs hayabusa

nmb · Dec 24, 2010

Just tried it on CentOS 64-bit with Custombuild 1.2.14. (Changed to 5.5 in option.conf) Didn't work. Had to change it back to 5.1.
________
DIGITAL VAPORIZERS

truenegative · Dec 25, 2010

Yeah I tried that before as well. I did get it to work with the manual install in another thread, but I don't want to upgrade to 5.5 until updates are managed by custombuild.

truenegative · Dec 27, 2010

Looks like it's in custombuild, but the problem is that it's looking for the wrong files for my system I guess....

Code:

[root@mercury custombuild]# ./build mysql 
--2010-12-27 15:27:54--  http://files.directadmin.com/services/all/mysql/64-bit/MySQL-client-5.5.8-1.glibc23.x86_64.rpm
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2010-12-27 15:27:55 ERROR 404: Not Found.

--2010-12-27 15:27:55--  http://files.directadmin.com/services/all/mysql/64-bit/MySQL-devel-5.5.8-1.glibc23.x86_64.rpm
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2010-12-27 15:27:55 ERROR 404: Not Found.

--2010-12-27 15:27:55--  http://files.directadmin.com/services/all/mysql/64-bit/MySQL-server-5.5.8-1.glibc23.x86_64.rpm
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2010-12-27 15:27:56 ERROR 404: Not Found.

--2010-12-27 15:27:56--  http://files.directadmin.com/services/all/mysql/64-bit/MySQL-shared-5.5.8-1.glibc23.x86_64.rpm
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2010-12-27 15:27:57 ERROR 404: Not Found.

meto · Dec 27, 2010

Files are in folder go to http://files.directadmin.com/services/all/mysql/64-bit and check for yourself. Is it safe to install them from CLI?

nmb · Dec 27, 2010

truenegative said:
Looks like it's in custombuild, but the problem is that it's looking for the wrong files for my system I guess....

Custombuild look for "glibc23" in all MySQL but the fact is, in MySQL 5.5, the actual text for that part is "linux2.6".

I also tried to download those MySQL files from Oracle, changed the script to match the text I said above but that didn't work either. I'm not sure why. Will find sometime to try that again. Hopefully, Custombuild that is really support MySQL 5.5 will come out soon.
________
Iolite Vaporizer Heating Element

truenegative · Dec 27, 2010

I got it to work today! I put together a mini howto. I'll post it up shortly

milosz · Dec 29, 2010

I have issue with mysql 5.5 install on FreeBSD:

Code:

2010-12-29 21:39:00 (268 KB/s) - `mysql-5.5.8.tar.gz' saved [24258297/24258297]

Extracting mysql-5.5.8.tar.gz ... 
./build: ./configure: not found
Done. Making mysql-5.5.8...
Trying to make mysql-5.5.8...
make: no target to make.

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

In mysql-5.5.8 dir is only configure.cmake

scsi · Dec 29, 2010

It looks like they changed the procedure to install it.

shell> tar zxvf mysql-VERSION.tar.gz
shell> cd mysql-VERSION
shell> cmake .
shell> make
shell> make install

Custombuild will have to be updated to support this install method.

cmake also isnt standard on freebsd and needs to be installed from /usr/ports/devel/cmake

Frej · Dec 30, 2010

so when will it be added on custombuild

smtalk · Jan 10, 2011

It's already added to CustomBuild 1.2 and should be added to 1.1 soon.

nmb · Jan 10, 2011

smtalk said:
It's already added to CustomBuild 1.2 and should be added to 1.1 soon.

Just tried it but then, I got error when trying to start MySQL as below :

Code:

Starting MySQL.. ERROR! The server quit without updating PID file (/var/lib/mysql/xxxxx.xxxxx.com.pid).
Giving mysqld a few seconds to start up...
Looking for 'mysql' as: /usr/bin/mysql
Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' 
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
cp: `/usr/lib/libmysqlclient.so' and `/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
 ERROR! MySQL server PID file could not be found!
Starting MySQL.. ERROR! The server quit without updating PID file (/var/lib/mysql/xxxxx.xxxxx.com.pid).
It is recommended to do "./build php n" after MySQL update.
/usr/local/php5/bin/php: /usr/lib64/libmysqlclient.so.16: no version information available (required by /usr/local/php5/bin/php)

My server is using CentOS 5.5 64 bits. Below is the error I got in log file :

Code:

110110 19:24:36  InnoDB: Using Linux native AIO
110110 19:24:36  InnoDB: Initializing buffer pool, size = 256.0M
110110 19:24:36  InnoDB: Completed initialization of buffer pool
110110 19:24:36  InnoDB: highest supported file format is Barracuda.
110110 19:24:36  InnoDB: 1.1.4 started; log sequence number 8607838993
110110 19:24:36 [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking'
110110 19:24:36 [ERROR] Aborting

110110 19:24:36  InnoDB: Starting shutdown...
110110 19:24:37  InnoDB: Shutdown completed; log sequence number 8607838993
110110 19:24:37 [Note] /usr/sbin/mysqld: Shutdown complete

It shows up many times until I revert back to MySQL 5.1.
________
Fisting amateur

nmb · Jan 10, 2011

According to this manual -> http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html

This --skip-locking is removed in MySQL 5.5

The --enable-locking and --skip-locking server options (use --external-locking and --skip-external-locking).

So, I just edit my my.cnf file. Change from "skip-locking" to "skip-external-locking". Now it works

________
**** Stream

IT_Architect · Jan 12, 2011

smtalk said:
It's already added to CustomBuild 1.2 and should be added to 1.1 soon.

Perfect! I'll be building some new FreeBSD 64 machines soon.

milosz · Jan 12, 2011

Custom 1.2 on FreeBSD 64 still not working

[root@alpha /usr/local/directadmin/custombuild]# ./build mysql
Extracting mysql-5.5.8.tar.gz ...
./build: ./configure: not found
Done. Making mysql-5.5.8...
Trying to make mysql-5.5.8...
make: no target to make.

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

nmb · Jan 12, 2011

milosz said:
Custom 1.2 on FreeBSD 64 still not working

Check to make sure Custombuild downloaded correct files. I got it working on one computer that I already downloaded MySQL files directly and put it in /usr/local/directadmin/custombuild/mysql. (Those files were downloaded when I tested it before Custombuild works)

Then, when I tried on the second machine, it failed. Turn out that the files Custombuild downloaded from were not correct. (Wrong path something.) So, I have to download those files directly from Oracle and then, run Custombuild script.
________
Herbal Vaporizers

MySQL 5.5

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Administrator

Verified User

Verified User

Verified User

Verified User

Verified User