MySQL Forums - MySQL Proxy

i want to write lua script for mysql-proxy,but how can i know the data struct of mysql-proxy? (no replies)

h ch — Tue, 24 Nov 2009 07:06:34 +0000

for instance,proxy.global.backends,i want to know what is it,where i can get the doc like this?

MySQL Proxy: Improved read-only load balancing (no replies)

Edwin DeSouza — Tue, 24 Nov 2009 04:21:51 +0000

MySQL Proxy: Improved read-only load balancing
http://blogs.sun.com/soapbox/entry/improved_read_only_load_balancing

have problem in use mysql-proxy admin (4 replies)

h ch — Tue, 24 Nov 2009 03:23:45 +0000

i installed lua ，and download mysql-proxy-0.7.2-linux-rhel5-x86-32bit.tar.gz
cp mysql-proxy to /usr/local,and i start mysql-proxy with follow command

mysql-proxy --proxy-read-only-backend-addresses=172.16.20.210:3306 --proxy-backend-addresses=172.16.1.19:3306 --admin-username=root --admin-password=12345 --admin-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/admin.lua --proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua > /var/log/mysql-proxy/mysql-proxy.log &

and /usr/local/mysql-proxy/share/doc/mysql-proxy/admin.lua is the lua script that i download from http://forge.mysql.com/tools/tool.php?id=198 and when i login in the admin port use

mysql -uroot -p -h172.16.1.19 -P4041
Enter password: 12345
and still have problem in query

Your MySQL connection id is 1
Server version: 5.0.99-agent-admin

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from backends;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: *** NONE ***

ERROR 1105 (07000): need a resultset + proxy.PROXY_SEND_RESULT

why?,seems lack something

Get asked database to switch backend (1 reply)

Basile Zack — Fri, 20 Nov 2009 16:19:55 +0000

Hi,

I have 2 mysql server on 2 different machines. My aim, is to use mysql-proxy to switch server depending on the wanted database.

For example :

Mysql-proxy is running on the first server with mysql server 1

databaseX is on mysql server 1
databaseY is on mysql server 2

If I ask databaseX (through mysql-proxy) I want to use server 1, and if I ask databaseY (through mysql-proxy) I want to use server 2.

Could this be possible with mysql-proxy ?

If this possible, do you know where I could find an example of Lua script doing that.

Thanks,

Basile.

Unable to use pre-compile mysql-proxy on Redhat 4 (1 reply)

Tower Gee — Wed, 11 Nov 2009 23:53:35 +0000

Hi,

I downloaded the pre-compiled mysql-proxy for RH4 and initialized things according to the wiki. When I tried to run mysql-proxy, it reported:

[root@ssss208-057 ~]# service mysql-proxy start
Starting mysql-proxy: 2009-11-10 16:07:58: (critical) chassis.c:981: could not raise RLIMIT_NOFILE to 8192, Invalid argument (22). Current limit still 34359739392.

How to solve this problem? I searched in Google, only find one entry, but it is not related to my problem.

Thanks,
Tower

caching via mysql proxy (no replies)

Pawel Leszczynski — Fri, 06 Nov 2009 10:42:27 +0000

Hi,

I'm thinking of a caching proxy that saves query result in the memcached. I was wondering if mysql proxy is the right place to do so. Is it possible to store state of the proxy in lua scripts between query calls. Once the query is executed I need to know I have cached it and I want to store this information in the proxy. Is it possible?

MySQL Enterprise Monitor: Agents, Hosts and Instances, Oh My! (no replies)

Edwin DeSouza — Mon, 02 Nov 2009 16:47:26 +0000

MySQL Enterprise Monitor: Agents, Hosts and Instances, Oh My!
http://blogs.sun.com/DatabaseEmporium/entry/agents_hosts_and_instances_oh

MySQL Proxy: Capturing Queries that cause an Error (no replies)

Edwin DeSouza — Wed, 28 Oct 2009 22:38:58 +0000

MySQL Proxy: Capturing Queries that cause an Error
http://www.chriscalender.com/?p=66

MySQL Proxy: Setting up as a Service on Windows (no replies)

Edwin DeSouza — Wed, 28 Oct 2009 17:45:12 +0000

MySQL Proxy: Setting up as a Service on Windows
http://www.chriscalender.com/?p=54

username and password in read_auth (3 replies)

George Lin — Sat, 31 Oct 2009 01:14:28 +0000

Since the auth packet is no longer available in read_auth, how do I get the username and password?
Thanks.
George

Mysql: Aborted connection - everytime LiveUpdate gets a new virus definition. (1 reply)

Anjali A — Sat, 31 Oct 2009 01:17:02 +0000

We are getting this issue on a Windows XP with SP2 machine. Mysql Server 4.1 is installed and noticed thru the event viewer log - everytime a new virus definition is loaded - there is this foll. event.

Event Type: Warning
Event Source: MySQL
Event Category: None
Event ID: 100
Date: 10/21/2009
Time: 8:43:37 PM
User: N/A
Computer: XX
Description:
Aborted connection 10 to db: 'abc' user: 'dba' host: `localhost' (Got an error reading communication packets)

For more information, see Help and Support Center at http://www.mysql.com.

Getting Result Set Size (2 replies)

Mike Patrick — Thu, 29 Oct 2009 17:20:02 +0000

I have been trying to calculate the size in bytes of a result set. This is based on the bandwidth calculation example. It seems to work at first and then eventually, the row values become nil. It seems to be also at a random number of rows even if I re-run it with the exact same data. Any help would be GREATLY appreciated!

BTW, I added a row count to be sure it was going through all of the rows and it is.

Below is the code I am using:

local bandwidth = 0

function read_query (packet )
bandwidth = bandwidth + string.len(packet)
proxy.queries:append(1, packet)
return proxy.PROXY_SEND_QUERY
end

function read_query_result(inj)
local rows = inj.resultset.rows
local fields = inj.resultset.fields
local rowcount = 0
local numcols = #inj.resultset.fields

if fields then
for i = 1, #fields do
bandwidth = bandwidth + (fields[i] and fields[i].name:len() or 0)
end

if rows then
for row in inj.resultset.rows do
rowcount = rowcount + 1

for i = 1, numcols do
print (row[i])
bandwidth = bandwidth + (row[i] and row[i]:len() or 0)
end
end
end
print ("Row Count: " .. rowcount)
print ("Bandwidth:" .. bandwidth)
end
end

Thanks,
Mike

Trouble on setting up mysql-proxy-0.7.2-linux-rhel5-x86-32bit (1 reply)

Cesar Ryan Mindana — Thu, 29 Oct 2009 17:33:15 +0000

can anyone help me on this?

[root@mysqlproxyserver ]# mysql -h 127.0.0.1 -P 1337 -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.99-agent-admin

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from proxy_connections;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: *** NONE ***

ERROR 1105 (07000): need a resultset + proxy.PROXY_SEND_RESULT
mysql>

===================

i started the proxy with

#!/bin/bash
MASTERDB=192.168.15.128

ROOT_DIR=/root/mysql-proxy-0.7.2-linux-rhel5-x86-32bit
$ROOT_DIR/sbin/mysql-proxy \
--daemon \
--admin-address=:1337 \
--proxy-backend-addresses=$MASTERDB:3306

MySQL IP = 192.168.15.129
DB = 192.168.15.128

Thanks
Ryan

Error running mysql-proxy from source (ibmysql-chassis.so.0) (5 replies)

Tom M — Sat, 31 Oct 2009 01:20:38 +0000

G'day,
I've been trying to get the rw-splitting.lua script to work but the read queries haven't been going to the proxy-read-only-backend-addresses even after creating lots of connections to the proxy:4040
I was using mysql-proxy-0.6.1 from Ubuntu's apt.
After reading a thread here recommending to use 0.7.2 to get query splitting working, I decided to compile & install from source (no binary for debian at this stage).
Compile goes fine but when I try to run mysql-proxy I get this error message

mysql-proxy: error while loading shared libraries: libmysql-chassis.so.0: cannot open shared object file: No such file or directory

This is bizarre because a locate shows that the files are there
~# locate libmysql-chassis.so.0
/usr/local/lib/libmysql-chassis.so.0
/usr/local/lib/libmysql-chassis.so.0.0.0

Any tips? Thanks!

Using MySQLProxy to solve the "error 2006 - server has gone away" problem (no replies)

Eduardo Baldino — Tue, 06 Oct 2009 22:42:19 +0000

Hi all.

I just discovered MySQL Proxy and thought it might be a quick solution for the dreadful "server has gone away problem" that we get with ODBC and other connectors.

Brief description of the problem: The MySQL server which we can't touch has a low connection timeout (in my case, about 7 seconds). This makes using ODBC through MS Access nearly impossible.

I thought that MySQL Proxy might be able to send the queries and data back and forth between my system and the server and that I might have a persistent connection from Access to MySQL Proxy. So I simply installed the proxy connecting to the server and changed the table definitions in Access to point to the proxy.

Alas, I still get the timeouts and the dreaded "server has gone away" messsage.

Is there an easy way to have MySQL Proxy keep that connection open? Can I make it continuously run a simple query to the server to do this, or is there some other way?

Thanks in advance.
Eduardo Baldino

Using MySQL Proxy to solve "error 2006 - server has gone away" problem (1 reply)

Eduardo Baldino — Thu, 15 Oct 2009 05:52:56 +0000

Hi all.

I just discovered MySQL Proxy and thought it might be a quick solution for the dreadful "server has gone away problem" that we get with ODBC and other connectors.

Brief description of the problem: The MySQL server which we can't touch has a low connection timeout (in my case, about 7 seconds). This makes using ODBC through MS Access nearly impossible.

I thought that MySQL Proxy might be able to send the queries and data back and forth between my system and the server and that I might have a persistent connection from Access to MySQL Proxy. So I simply installed the proxy connecting to the server and changed the table definitions in Access to point to the proxy.

Alas, I still get the timeouts and the "server has gone away" messsage.

Is there an easy way to have MySQL Proxy keep that connection open? Can I make it continuously run a simple query to the server to do this, or is there some other way?

Thanks in advance.
Eduardo Baldino

MySQL proxy query duplication Followup (1 reply)

Bill Jones — Thu, 29 Oct 2009 17:50:41 +0000

I need help as soon as possible.

Any suggestions would be greatly appreciated.

Thanks,
Bill

Used Fitness Equipment

MySQL proxy query duplication (1 reply)

Craig David — Sat, 07 Nov 2009 04:27:04 +0000

Hi there!

MySQL proxy seems to be heavily used for R/W type splitting applications. I wish to duplicate queries to two servers and only return data from one of them.

I realise that MySQL proxy handles load balancing type behaviour with the following syntax:
--proxy-backendaddresses
and if there are multiple backendaddresses then it will start to load balance between them.

How can I get proxy to do what I need? Any tips for writting the Lua script which will split the query two masters and only return the result from one?

The two masters should not be aware of each others presence - otherwise I would have used standard replication.

Thanks for any input!

How to Install MySQL Proxy on Windows XP? (2 replies)

Sid Childers — Thu, 08 Oct 2009 18:14:28 +0000

Hello,
I've downloaded the Windows version of MysQL Proxy and extracted the contents of the zip file to my hard drive. There is no setup.exe or other similar install prograam. How do I go about installing MysQL Proxy?

Thanks,
Sid

Load balancing issues on a Master/Master architecture (no replies)

banglore agent1 — Sun, 27 Sep 2009 19:14:45 +0000

A combination of a Local Area Network (LAN) and a Wireless LAN (WLAN) is a useful environment for doing parallel computing. We use this infrastructure to implement Master/Slave parallel distributed programs which exhibit strict data dependences among iterations and parallel calculation inside an iteration. In this environment it is necessary to consider the unbalance both processing power and communication bandwidth of fixed and portable computers to avoid long idle times. To solve this problem, in our previous work we developed an efficient load balancing method that considers the heterogeneity both in computing and in communication, and besides, it keeps in mind that the number of processes can vary at run time (processes spawned on portable computers). To program this method is a hard task because it implements a complex mechanism to estimate the data distribution which uses a framework based on Simple Network Management Protocol (SNMP) that has to synchronize with the parallel program to share performance information about computers. For that reason, in this paper we present a library that implements our method of load balancing to ease the programming.
--------------------------------------------------
alcohol rehabilitation
HGH

R/W splitting (no replies)

banglore agent1 — Sun, 27 Sep 2009 19:11:54 +0000

For R/W Splitting we need a connection pooling. We only switch to another backend if we already have a authenticated connection open to that backend.

The MySQL protocol first does a challenge-response handshake. When we enter the query/result stage it is too late to authenticate new connections. We have to make sure that we have enough open connections to operate nicely.
------------------------------------------------
alcohol rehabilitation
HGH

MySQL error during Insert (no replies)

banglore agent1 — Sun, 27 Sep 2009 19:09:03 +0000

statement insert rows based on explicitly specified values. The INSERT ... SELECT form inserts rows selected from another table or tables. INSERT ... SELECT is discussed further in Section 12.2.5.1, “INSERT ... SELECT Syntax”.

You can use REPLACE instead of INSERT to overwrite old rows. REPLACE is the counterpart to INSERT IGNORE in the treatment of new rows that contain unique key values that duplicate old rows: The new rows are used to replace the old rows rather than being discarded. See Section 12.2.7, “REPLACE Syntax”.

tbl_name is the table into which rows should be inserted. The columns for which the statement provides values can be specified as follows:

You can provide a comma-separated list of column names following the table name. In this case, a value for each named column must be provided by the VALUES list or the SELECT statement.

If you do not specify a list of column names for INSERT ... VALUES or INSERT ... SELECT, values for every column in the table must be provided by the VALUES list or the SELECT statement. If you do not know the order of the columns in the table, use DESCRIBE tbl_name to find out.

The SET clause indicates the column names explicitly.

Column values can be given in several ways:

If you are not running in strict SQL mode, any column not explicitly given a value is set to its default (explicit or implicit) value. For example, if you specify a column list that does not name all the columns in the table, unnamed columns are set to their default values. Default value assignment is described in Section 10.1.4, “Data Type Default Values”. See also Section 1.7.6.2, “Constraints on Invalid Data”.

If you want an INSERT statement to generate an error unless you explicitly specify values for all columns that do not have a default value, you should use strict mode. See Section 5.1.8, “Server SQL Modes”.

Use the keyword DEFAULT to set a column explicitly to its default value. This makes it easier to write INSERT statements that assign values to all but a few columns, because it enables you to avoid writing an incomplete VALUES list that does not include a value for each column in the table. Otherwise, you would have to write out the list of column names corresponding to each value in the VALUES list.

You can also use DEFAULT(col_name) as a more general form that can be used in expressions to produce a given column's default value.

If both the column list and the VALUES list are empty, INSERT creates a row with each column set to its default value:
INSERT INTO tbl_name () VALUES();

In strict mode, an error occurs if any column doesn't have a default value. Otherwise, MySQL uses the implicit default value for any column that does not have an explicitly defined default.

You can specify an expression expr to provide a column value. This might involve type conversion if the type of the expression does not match the type of the column, and conversion of a given value can result in different inserted values depending on the data type. For example, inserting the string '1999.0e-2' into an INT, FLOAT, DECIMAL(10,6), or YEAR column results in the values 1999, 19.9921, 19.992100, and 1999 being inserted, respectively. The reason the value stored in the INT and YEAR columns is 1999 is that the string-to-integer conversion looks only at as much of the initial part of the string as may be considered a valid integer or year. For the floating-point and fixed-point columns, the string-to-floating-point conversion considers the entire string a valid floating-point value.

An expression expr can refer to any column that was set earlier in a value list. For example, you can do this because the value for col2 refers to col1, which has previously been assigned:
INSERT INTO tbl_name (col1,col2) VALUES(15,col1*2);

But the following is not legal, because the value for col1 refers to col2, which is assigned after col1:
INSERT INTO tbl_name (col1,col2) VALUES(col2*2,15);

One exception involves columns that contain AUTO_INCREMENT values. Because the AUTO_INCREMENT value is generated after other value assignments, any reference to an AUTO_INCREMENT column in the assignment returns a 0.
-----------------------------------------

Mysql-proxy and phpmyadmin (no replies)

banglore agent1 — Sun, 27 Sep 2009 19:03:44 +0000

Forum profile page for MySQL Proxy on http://www.mysql.com. This report page is the aggregated overview from a single forum: MySQL Proxy, located on the Message Board at http://www.mysql.com. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "MySQL Proxy" on the Message Board at http://www.mysql.com is also shown in the following ways:

1) Latest Active Threads
2) Hot Threads for Last Week
----------------------------------------
alcohol rehabilitation
HGH

can't compile mysql-proxy 0.7.2 (1 reply)

Bond Chen — Thu, 29 Oct 2009 17:46:40 +0000

Hi, All

I got into trouble when compiling mysql-proxy 0.7.2.

The following is my enviroment:

Lua version: 5.1.4
GLIB: 2.22
libtool: 1.5.22
gcc: 4.1.2
linux: Linux zhcn 2.6.18-92.1.6.el5.centos.plus

The following error was prompted:

/bin/sh ../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.. -I/data/mysql/include/mysql -I..//data/glib-2.22.0 -I..//data/glib-2.22.0/. -I..//data/glib-2.22.0/./glib -I/usr/local/include -I..//data/glib-2.22.0/./gmodule -I..//data/glib-2.22.0 -I..//data/glib-2.22.0/. -I..//data/glib-2.22.0/./glib -g -O2 -MT libmysql_chassis_la-glib-ext.lo -MD -MP -MF .deps/libmysql_chassis_la-glib-ext.Tpo -c -o libmysql_chassis_la-glib-ext.lo `test -f 'glib-ext.c' || echo './'`glib-ext.c
../libtool: line 813: X--tag=CC: command not found
../libtool: line 846: libtool: ignoring unknown tag : command not found
../libtool: line 813: X--mode=compile: command not found
../libtool: line 979: *** Warning: inferring the mode of operation is deprecated.: command not found
../libtool: line 980: *** Future versions of Libtool will require --mode=MODE be specified.: command not found
../libtool: line 1123: Xgcc: command not found
../libtool: line 1123: X-DHAVE_CONFIG_H: command not found
../libtool: line 1123: X-I.: command not found
../libtool: line 1123: X-I..: command not found
../libtool: line 1123: X-I/data/mysql/include/mysql: No such file or directory
../libtool: line 1123: X-I..//data/glib-2.22.0: No such file or directory
../libtool: line 1123: X-I..//data/glib-2.22.0/.: No such file or directory
../libtool: line 1123: X-I..//data/glib-2.22.0/./glib: No such file or directory
../libtool: line 1123: X-I/usr/local/include: No such file or directory
../libtool: line 1123: X-I..//data/glib-2.22.0/./gmodule: No such file or directory
../libtool: line 1123: X-I..//data/glib-2.22.0: No such file or directory
../libtool: line 1123: X-I..//data/glib-2.22.0/.: No such file or directory
../libtool: line 1123: X-I..//data/glib-2.22.0/./glib: No such file or directory
../libtool: line 1123: X-g: command not found
../libtool: line 1123: X-O2: command not found
../libtool: line 1123: X-MT: command not found
../libtool: line 1123: Xlibmysql_chassis_la-glib-ext.lo: command not found
../libtool: line 1123: X-MD: command not found
../libtool: line 1123: X-MP: command not found
../libtool: line 1123: X-MF: command not found
../libtool: line 1123: X.deps/libmysql_chassis_la-glib-ext.Tpo: No such file or directory
../libtool: line 1123: X-c: command not found
../libtool: line 1175: Xlibmysql_chassis_la-glib-ext.lo: command not found
../libtool: line 1180: libtool: compile: cannot determine name of library object from `': command not found
make[3]: *** [libmysql_chassis_la-glib-ext.lo] Error 1
make[3]: Leaving directory `/data/mysql-proxy-0.7.2/src'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/data/mysql-proxy-0.7.2/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/data/mysql-proxy-0.7.2'
make: *** [all] Error 2

Master-Master full Redundant/Balanced setup (1 reply)

Romain K — Thu, 01 Oct 2009 17:07:57 +0000

Hello,

I'm looking for some advices/help with LUA scripts.

We are trying to setup a fully redundant/load-balanced setup of MySQL Proxy with two Masters in bidirectionnal replication.
For now, the development (virtual machines) look like this :

[MySQL-Proxy]
|
|
([Master1] <-- Replication --> [Master2])

I'm using latest bazaar release with last rw-splitting.lua
The goal is to have "SELECT" sent to Master2 and everything else to Master1.
If Master1 falls, all queries goes to Master2, if Master1 become available again, MySQL-Proxy goes back to normal usage (Writes -> M1, Reads -> M2).

But I can't have Master2 recognized as a "slave" in normal behavior, even if I launch MySQL-Proxy like this :

mysql-proxy --proxy-address=:3306 --proxy-backend-addresses=master1:3306 --proxy-backend-addresses=master2:3306 --proxy-read-only-backend-addresses=master2:3306 --proxy-lua-script=/root/rw-splitting.lua --log-level=debug

I set master2 to be at the same time a rw and a ro backend but no luck.

Still, if I do that, I'm not sure it's gonna work as whished.

Does someone has an idea on how to achieve this or just how to have Master2 recognized as a Master and a Slave ?

Thanks in advance for you advices and, please, forgive me for my english :)

wxlua (no replies)

brian keith — Mon, 14 Sep 2009 13:31:20 +0000

Is it possible to include wxlua in a lua script?

I tried but i get all kinds of errors

My idea was to output to a dialog box so i could monitor the queries.

Thanks

Error compiling mysql-proxy (1 reply)

HELARY Mathieu — Thu, 29 Oct 2009 17:41:44 +0000

When i try to compile mysql-proxy-0.7.2 i got this error message :

chassis.c: In function `main_cmdline':
chassis.c:595: erreur: « LUA_RELEASE » non déclaré (première utilisation dans cette fonction)
chassis.c:595: erreur: (Chaque identificateur non déclaré est rapporté une seule fois
chassis.c:595: erreur: pour chaque fonction dans laquelle il apparaît.)
chassis.c:601: erreur: « LUA_PATH » non déclaré (première utilisation dans cette fonction)
chassis.c:622: erreur: « LUA_CPATH » non déclaré (première utilisation dans cette fonction)

Any ideas ?

mysql proxy procedure/delimiter issue (1 reply)

dusan subidub — Fri, 11 Sep 2009 07:22:29 +0000

Hello,
I am trying to convert oracle procedures to mysql using proxy query rewriting ability. I came to problem with delimiter. If I type following commands to mysql client it works.

delimiter //
create procedure foo()
begin
select 2+2 from dual;
end;
//
delimiter ;;

Problem occurs when I send these commands via lua script. My send_query function looks like this:
...
query = "delimiter //\ncreate procedure foo() begin select 2+2 from dual; end;\n//\ndelimiter ;"
proxy.queries:append(1, string.char(proxy.COM_QUERY) .. query)
...

I got following error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delimiter //
create procedure foo() begin select 2+2 from dual; end;
//
delim' at line 1

Does anyone know how to set delimiter properly?

Thanks.

Dusan

MySQL Proxy 0.7.2 Windows Service (2 replies)

Steve Bond — Fri, 30 Oct 2009 11:27:14 +0000

I'm trying to run MySQL Proxy 0.7.2 as a service under windows server 2003.

If I run mysql-proxy-svc.exe as the service it starts and runs fine, the problem is I would like to also use the --defaults-file=mysql-proxy.conf option, but when I do so the service starts and stops again immediately.

I've trawled the net and not been able to find the information I need on this, is anyone else out there running a setup like this?

MySQL Proxy having problems with QT (no replies)

Frank Norman — Thu, 03 Sep 2009 12:32:51 +0000

Hy community,

im working here on a project to replicate databases, partially using MySQL Proxy.

Currently using Windows XP Prof and MySQL 5.1.

I wrote a Lua-Script to copy all Insert-, Delete- and Update-Queries to another Table for replication.

When i tried to write a program with Visual Studio ++ Express 2008 via the C++ Connector, it worked perfectly, sending a Insert-Query every second.

When i used the port 4040 for the program, the proxy caught the Insert-Queries and redirected them, everything worked fine.

But here comes the Problem:
I am forced to try QT as a C++ Compiler because the program i wrote in VS++ was not portable on machines which did not have VS++ installed (couldn't fix it with /MD mode).

QT comes with its own drivers for MySQL (though i needed to compile them, they worked at the end).
Sending out queries to my MySQL Server is no Problem, but when i hook up my Proxy in between, its not able to catch the queries!

My Lua-Script is now fully packed with prints to analyze what the packet is:

function read_query( packet )
if packet:byte() == proxy.COM_QUERY then
local tk = require("proxy.tokenizer")
local query = string.sub(packet, 2)
local tokens = tk.tokenize(query)
if tokens[1].token_name == "TK_SQL_INSERT"
or tokens[1].token_name == "TK_SQL_DELETE"
or tokens[1].token_name == "TK_SQL_UPDATE"
then
proxy.queries:append(1, packet)
proxy.queries:append(2, string.char(proxy.COM_QUERY) .. "INSERT INTO test2.storequeries (commands) VALUES ('" .. query.."');")
print ("rerouted query")
return proxy.PROXY_SEND_QUERY
else
print ("me a query")
end
elseif packet:byte() == proxy.COM_QUIT then
print ("me a quit");
elseif packet:byte() == proxy.COM_INIT_DB then
print ("me a COM_INIT_DB");
elseif packet:byte() == proxy.COM_FIELD_LIST then
print ("me a COM_FIELD_LIST");
elseif packet:byte() == proxy.COM_CREATE_DB then
print ("me a COM_CREATE_DB");
elseif packet:byte() == proxy.COM_DROP_DB then
print ("me a COM_DROP_DB");
elseif packet:byte() == proxy.COM_REFRESH then
print ("me a COM_REFRESH");
elseif packet:byte() == proxy.COM_SHUTDOWN then
print ("me a COM_SHUTDOWN");
elseif packet:byte() == proxy.COM_STATISTICS then
print ("me a COM_STATISTICS");
elseif packet:byte() == proxy.COM_PROCESS_INFO then
print ("me a COM_PROCESS_INFO");
elseif packet:byte() == proxy.COM_PROCESS_KILL then
print ("me a COM_PROCESS_KILL");
elseif packet:byte() == proxy.COM_DEBUG then
print ("me a COM_DEBUG");
elseif packet:byte() == proxy.COM_PING then
print ("me a COM_PING");
elseif packet:byte() == proxy.COM_CHANGE_USER then
print ("me a COM_CHANGE_USER");
elseif packet:byte() == proxy.COM_BINLOG_DUMP then
print ("me a COM_BINLOG_DUMP");
elseif packet:byte() == proxy.COM_TABLE_DUMP then
print ("me a COM_TABLE_DUMP");
elseif packet:byte() == proxy.COM_REGISTER_SLAVE then
print ("me a COM_REGISTER_SLAVE");
elseif packet:byte() == proxy.COM_PREPARE then
print ("me a COM_PREPARE");
elseif packet:byte() == proxy.COM_EXECUTE then
print ("me a COM_EXECUTE");
elseif packet:byte() == proxy.COM_LONG_DATA then
print ("me a COM_LONG_DATA");
elseif packet:byte() == proxy.COM_CLOSE_STMT then
print ("me a COM_CLOSE_STMT");
elseif packet:byte() == proxy.COM_RESET_STMT then
print ("me a COM_RESET_STMT");
elseif packet:byte() == proxy.COM_SET_OPTION then
print ("me a COM_SET_OPTION");
elseif packet:byte() == proxy.COM_FETCH_STMT then
print ("me a COM_FETCH_STMT");
else
print ("dont know what this one is")
end
end

(sorry for non-code-format)

As you can see, i addd every known packet indicator, but still my proxy prints out
"dont know what this one is" ...
though the query comes only every second, my proxy prints this line 4 times a second (starting with 3 as i start the program).

Is QT using a packet-format that the Proxy doesn't know?

For QT, im using the

QSqlQuery query("INSERT INTO webtest (parameter) VALUES ('testor')");

statement.