MySQL Bugs: #44497: Wrong LUA_PATH on MySQL Proxy 0.7.0

Bug #44497	Wrong LUA_PATH on MySQL Proxy 0.7.0
Submitted:	27 Apr 2009 18:45	Modified:	17 Aug 2009 15:21
Reporter:	Diego Medina	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Proxy: Install/Config	Severity:	S2 (Serious)
Version:	0.7.0 r 648	OS:	Any
Assigned to:	Jan Kneschke	CPU Architecture:	Any

Description:
If you compile the mysql proxy from source, you end up with some lua files here

<mysql-proxy-folder>/share/doc/mysql-proxy

instead of 

<mysql-proxy-folder>/share/mysql-proxy

This breaks some lua scripts that rely on files like admin-sql.lua among others

The file 

./sbin/mysql-proxy has

LUA_PATH="$scriptdir"/share/mysql-proxy/?.lua

How to repeat:
1- Get the source from 

bzr branch lp:mysql-proxy

2- Compile it
3- go to the folder share/  and see the doc folder only

Suggested fix:
Revert to having the folder structure like

<mysql-proxy-folder>/share/mysql-proxy

or fix ./sbin/mysql-proxy  to point to the correct folder.

A fix is pushed to. Should be in 0.7.1

------------------------------------------------------------
revno: 653
committer: jan@mysql.com
branch nick: trunk
timestamp: Tue 2009-05-12 21:24:31 +0200
message:
  moved the plugings to ${libdir}/mysql-proxy/plugins/ and
  the lua extensions (.lua and .so) to ${libdir}/mysql-proxy/lua/
  
    * we need this for the future if we want to add other languages

See related bug#44858

Diego Medina writes: 
Verified fixed on 0.7 branch

A note has been added to the 0.7.0 changelog: 

MySQL Proxy would be configured with the LUA_PATH and LUA_CPATHn directory locations according to the build, not execution, host. In addition, during installation, certain Lua source files could be installed into the incorrect location