Compile and install MySQL Proxy Lua 0.8.1 in Linux5u3

Linux5u3Compile and installMySQL Proxy0.8.1 is the content to be introduced in this article. It mainly records ENTERPRISELINUX5u3Compile and install the source code in a versionMySQL ProxyStep 0.8.

MySQL ProxyIs an application tool that provides connection between the MySQL server and the client through the MySQL network protocol. All MySQL-compatible clients (including mysql command lines, class libraries that call mysql command lines, and applications supporting MySQL network protocol) can be directly connected without any modificationsMysql Proxy.

1. Install the dependency package

Before installing MySQL Proxy through source code compilation, the following dependency packages must be installed first:

 
 

  
  
Libevent 1.x or higher (1.3b or later is preferred)
  
  
Lua 5.1.x or higher
  
  
Glib2 2.16.0 or higher (the official document is 2.6.0 or later. during actual installation, mysql-proxy 0.8 prompts that it cannot be earlier than 2.16.0)
  
  
Pkg-config
  
  
Libtool 1.5 or higher
  
  
MySQL 5.0.x or higher developer files
 
 

1) install libevent

The libevent version that comes with RHEL5.3 is earlier than version 1.1. If it does not meet your requirements, you can directly download the libevent version for installation. The procedure is as follows:

 
 

  
  
# wget http://monkey.org/~provos/libevent-1.4.14b-stable.tar.gz  
  
  
# tar xvfz libevent-1.4.14b-stable.tar.gz   
  
  
# cd libevent-1.4.14b-stable   
  
  
# ./configure --prefix=/usr/local/libevent-1.4   
  
  
# make && make install  
 
 

2) install the lua Script Language Pack

Lua is a lightweight scripting language. MySQL Proxy expands its functions using this language.

Download the latest version 5.1.4 from the official website, decompress the package, and run the following commands:

 
 

  
  
# wget http://www.lua.org/ftp/lua-5.1.4.tar.gz  
  
  
# tar xvfz lua-5.1.4.tar.gz   
  
  
# cd lua-5.1.4   
  
  
# vi Makefile  
 
 

Modify the MakeFile file:

 
 

  
  
INSTALL_TOP= /usr/local  
 
 

To:

 
 

  
  
INSTALL_TOP= /usr/local/lua  
 
 

The purpose isLuaRelated files are stored in the same directory for easy searching and application.

LuaFor details about how to compile and INSTALL the SDK, see the INSTALL file in the directory. If you INSTALL the SDK in linux, run the following command to complete the compilation and installation:

 
 

  
  
# make linux install  
 
 

3) install glib2

The official document says that version 2.6.0 or later is required. When mysql-proxy 0.8 is installed, the system prompts that the glib2 version cannot be earlier than 2.16.0. Here, to ensure smooth execution of the subsequent installation process, first upgrade glib2 of the system, the procedure is as follows.

 
 

  
  
# wget http://ftp.gnome.org/pub/gnome/sources/glib/2.22/glib-2.22.5.tar.gz   
  
  
# tar xvfz glib-2.22.5.tar.gz   
  
  
# cd glib-2.22.5   
  
  
# ./configure --prefix=/usr/local/glib-2.2   
  
  
# make && make install  
 
 

4) install the MySQL Development Kit

Mysql_config and other applications are mainly needed. mysql Development kits can be downloaded directly from its official website:

 
 

  
  
http://dev.mysql.com/downloads/mysql/5.1.html 
 
 

The Rpm package is easy to install. Run the following command:

 
 

  
  
# rpm -ivh MySQL-devel-community-5.1.51-1.rhel5.x86_64.rpm  
 
 

2. InstallationMySQL Proxy

Next, it was the final turn of the main player. Here, we installed MySQL Proxy 0.8.1. You can also download it directly on its official website:

 
 

  
  
http://dev.mysql.com/downloads/mysql-proxy/ 
 
 

 
 

  
  
# tar xvfz mysql-proxy-0.8.1.tar.gz   
  
  
# cd mysql-proxy-0.8.1   
  
  
# ./configure LDFLAGS="-lm -ldl" LUA_CFLAGS="/usr/local/lua/bin/lua -I/usr/local/lua/include" 
  
  
 LUA_LIBS="/usr/local/lua/lib -llua" --prefix=/usr/local/mysql-proxy --with-lua   
  
  
# make   
  
  
# make install  
 
 

After the installation is successful, run the mysql-proxy command for verification:

 
 

  
  
[root@rhel5u3 mysql-proxy]# /usr/local/mysql-proxy/bin/mysql-proxy -V   
  
  
mysql-proxy 0.8.1   
  
  
chassis: mysql-proxy 0.8.1   
  
  
glib2: 2.22.5   
  
  
libevent: 1.4.14b-stable   
  
  
LUA: Lua 5.1.4   
  
  
package.path: /usr/local/mysql-proxy/lib/mysql-proxy/lua/?.lua   
  
  
package.cpath: /usr/local/mysql-proxy/lib/mysql-proxy/lua/?.so   
  
  
modules   
  
  
admin: 0.8.1   
  
  
proxy: 0.8.1  
 
 

The compilation process looks simple, just a few commands, but this installation is not smooth, and I have been thinking about it for a whole day. Maybe it is my bad luck. Of course, it should be a little bit more, during the actual compilation process, many errors were encountered. For details about the error information and solution, I hope to help the same problem:

The operating system version is as follows:

 
 

  
  
[root@rhel5u3 ~]# cat /etc/issue   
  
  
Enterprise Linux Enterprise Linux Server release 5.3 (Carthage)   
  
  
Kernel \r on an \m  
 
 

Error 1:

 
 

  
  
checking for LUA... no   
  
  
... checked for Lua via pkg-config: No package ¨lua¨ found. retrying with lua5.1  
 
 

The error message indicates that the lua package cannot be found.

Solution:
1) As shown in Step 1.2, compile and installLua;

2) Set environment variables:

 
 

  
  
export LUA_CFLAGS="-I/usr/local/lua/include"   
  
  
export LUA_LIBS="-L/usr/local/lua/lib -llua -ldl"  
 
 

Note that the path in the variable should beLuaThe actual installation path, and then re-Execute configure configuration Compilation Program.

If the above operation fails, you can copy the etc/lua. pc file in the lua installation path to the lib/pkgconfig/folder in the glib2 installation path.

Error 2:

 
 

  
  
checking for GLIB... configure: error: Package requirements (glib-2.0 >= 2.16.0) were not met:   
  
  
Requested ¨glib-2.0 >= 2.16.0¨ but version of GLib is 2.12.3  
 
 

This indicates that the glib2 version identified by default is incorrect.

Solution:

1) Compile and install the appropriate glib according to Step 1.3;

2) Set environment variables:

 
 

  
  
export GLIB_CFLAGS="-I/usr/local/glib-2.2/include/glib-2.0"   
  
  
export GLIB_LIBS="-L/usr/local/glib-2.2/lib/glib-2.0"   
  
  
export GMODULE_CFLAGS="-I/usr/local/glib-2.2/include"   
  
  
export GMODULE_LIBS="-L/usr/local/glib-2.2/lib"   
  
  
export GTHREAD_CFLAGS="-I/usr/local/glib-2.2/include"   
  
  
export GTHREAD_LIBS="-L/usr/local/glib-2.2/lib"  
 
 

Specifically, GMODULE and GTHREAD variables must be set, otherwise errors such as (gmodule-2.0> = 2.16.0) were not met or (gthread-2.0> = 2.16.0) were not met may occur.

The path in the variable value should be the actual installation path of glib2, and then re-Execute configure configuration Compilation Program.

Error 3:

 
 

  
  
checking for event_init in -levent... no   
  
  
configure: error: libevent is required  
 
 

The libevent dependency package is not found.

Solution:

1) Compile and install libevent as shown in Step 1.1.

2) Set environment variables:

 
 

  
  
export LDFLAGS="-L/usr/local/libevent-1.4/lib -lm"  
 
 

Then execute configure configuration and compile the program again.

Error 4:

 
 

  
  
/usr/local/lua/lib/liblua.a: could not read symbols: Bad value  
 
 

It seems that a lua call error occurs. The related documentation prompts that the 64bit environment may encounter this phenomenon.

Solution:

A>. Edit the src/MakeFile file of lua and modify the following parameters:

 
 

  
  
CFLAGS= -O2 -Wall $(MYCFLAGS)  
 
 

To:

 
 

  
  
CFLAGS= -O2 -Wall -fPIC $(MYCFLAGS)  
 
 

B>. Compile and install the SDK as shown in Step 1.2.Lua. If you have already compiled the configuration, run make clean to clear the compiled configuration.

Error 5:

 
 

  
  
/usr/local/glib-2.22/include/glib-2.0/glib/gtypes.h:34:24: error: glibconfig.h: No such file or directory  
 
 

Solution:

 
 

  
  
# cp /usr/local/glib-2.2/lib/glib-2.0/include/glibconfig.h /usr/local/glib-2.2/include/glib-2.0/  
 
 

Then re-execute the compilation.

Summary:Linux5u3Compile and installMySQL Proxy0.8.1 has been introduced. I hope this article will help you!