Re: [Spock Proxy Devel] Bad handshake and out of order

[Alexey K. <al...@ko...>]

Here is what I get:

[root@master-db etc]# cat texts.conf | egrep -v '^(#|$)'
PROXY_ADDRESS=:33060
ADMIN_ADDRESS=:44040
PARTITION_INFO_HOST=master-db.local
PARTITION_INFO_DB=spock_config
DB_USER=spock
DB_PASSWD=Qy05Owhm
DEFAULT_SELECT_LIMIT=1000000
LOGFILE=/opt/spock-proxy/var/texts.log
SKIP_PROFILING=1
FIX_BUG_25371=0
PID_FILE=/opt/spock-proxy/var/texts.pid
LOG_DEBUG_MSG=1
LOG_ALL_QUERIES=1
MAX_CONN_IDLE_TIME=3600
MAX_CONN_POOL_SIZE=5
LOG_RAW_DATA=1
[root@master-db etc]# mysql -u spock -pQy05Owhm -h master-db.local spock_config
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 15722181
Server version: 5.0.77-percona-b13-log MySQL Percona Edition (GPL)

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

mysql> show tables;
+--------------------------+
| Tables_in_spock_config   |
+--------------------------+
| shard_database_directory |
| shard_range_directory    |
| shard_table_directory    |
+--------------------------+
3 rows in set (0.00 sec)

mysql> select * from shard_database_directory;
+-------------+-----------------+-------------+------------------------+
| database_id | host_name       | port_number | database_name          |
+-------------+-----------------+-------------+------------------------+
|           4 | master-db.local |        3306 | collegelist_production |
+-------------+-----------------+-------------+------------------------+
1 row in set (0.10 sec)

mysql> Bye
[root@master-db etc]# mysql -u spock -pQy05Owhm -h master-db.local
collegelist_production
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 15722290
Server version: 5.0.77-percona-b13-log MySQL Percona Edition (GPL)

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

mysql>

So, the password, login, db are ok.

On Wed, Jun 3, 2009 at 12:50 PM, Frank Flynn <fr...@co...> wrote:
> Check the login, password, host and database name in your config (or from
> your command line).  Try connecting directly to the universal DB from that
> machine with the same account.
>
> And the permissions of that user account (it must be able to read the 3
> shard_*_tables)
>
> I suspect that it cannot get this far.
>
>
> On Jun 3, 2009, at 2:11 AM, Alexey Kovyrin wrote:
>
>> Hello,
>>
>> I work for scribd.com and we're trying to use spockproxy for some of
>> our projects here... I've set it up locally, developed all the changes
>> in our code that'd allow us to use the proxy, tested it and everything
>> was fine... until we decided to put this configuration on our
>> production servers.
>>
>> So, the problem is the following: when spockproxy is trying to connect
>> to our mysql servers we see the following:
>>
>> Wed Jun  3 05:00:51 2009 WARNING network-mysqld.cpp.3090: error in
>> selecting default database: Bad handshake
>>
>> Our production servers are on 5.0.77.
>>
>> I've tested the same configuration on a server with 5.1.30 and the
>> result was even more interesting:
>>
>> Wed Jun  3 03:14:17 2009 WARNING network-mysqld.cpp.3090: error in
>> selecting default database: Got packets out of order.
>>
>> Changing FIX_BUG_25371 option does not change anything.
>>
>> So, the question is: what should we do here? :-/
>>
>> --
>> Alexey Kovyrin
>
>



-- 
Alexey Kovyrin
http://kovyrin.info/