MySQL Forums
Forum List  »  Router & Proxy

MySQL_Proxy 0.6.1 lost connection
Posted by: Tiago Cruz
Date: April 29, 2008 09:20AM

Hi!

I'm using phpBB3 directly connected on my mysql-proxy:

// phpBB 3.0.x auto-generated configuration file
$dbms = 'mysqli';
$dbhost = '10.25.0.12';
#$dbport = '3306';
$dbport = '4040';
$dbname = 'phpbb';
$dbuser = 'phpbb';
$dbpasswd = 'phpbb';
$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';

I'm starting on this way:

[root@db1 mysql-proxy-0.6.1]# LUA_PATH="lib/?.lua" src/mysql-proxy --proxy-read-only-backend-addresses=10.25.0.11:3306 --proxy-backend-addresses=10.25.0.12:3306 --proxy-lua-script=lib/rw-splitting.lua


Works as well for a while, but after stops with this error:

=============================================================================
General Error
SQL ERROR [ mysqli ]

Lost connection to MySQL server during query [2013]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

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


And really, I just can't connect on the first try, but connect at second tried:

$ mysql -h 10.25.0.12 -uphpbb -pphpbb -P4040 phpbb
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading final connect information', system error: 0


$ mysql -h 10.25.0.12 -uphpbb -pphpbb -P4040 phpbb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3325
Server version: 5.0.22-log

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

mysql> quit
Bye

What can I do to fix this?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL_Proxy 0.6.1 lost connection
7026
April 29, 2008 09:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.