Forum Discussion

Nick_67024's avatar
Nick_67024
Icon for Nimbostratus rankNimbostratus
Jan 15, 2013

About MySQL-Proxy

Hello

 

I follow document for mysql-proxy to setup.

 

But, It's not work.

 

error message is "ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0"

 

Can everyone have any suggestion?

 

 

Thanks

 

6 Replies

  • Hello

     

    Document url is https://devcentral.f5.com/blogs/us/a-read-write-mysql-proxy-for-big-ip and https://devcentral.f5.com/wiki/irules.MySQL-Proxy.ashx

     

    iRule or iAPP both test.

     

    ALL not OK.

     

    I saw log with /var/log/ltm.

     

    I found this error message "tmm err tmm[6959]: 01220001:3: TCL error: /Common/test.app/test_irule - can't read "from_client_user": no such variable while executing "class lookup $from_client_user test_data_group""

     

    Thanks

     

    Nick

     

  • Which LTM and MySQL versions are you testing this on?

     

     

    The iRule and iApp were a proof of concept tested to work specifically with BIG-IP 11.1.0 and MySQL 5.1. There may be compatibility issues with later versions.

     

     

    Aaron
  • Hello Aaron

     

     

    My LTM Version is 11.2.0

     

    MySQL Version is 5.5.27

     

     

    Thanks

     

    Nick

     

  • Hello

     

     

    Please saw this document, http://webcache.googleusercontent.com/search?q=cache:bcKtJzRpr_kJ:dev.mysql.com/doc/refman/5.5/en/native-authentication-plugins.html+&cd=1&hl=zh-TW&ct=clnk&gl=tw.

     

    It's different Authenticate with 5.1.

     

     

    How to solve this problem??

     

    Thanks

     

    Nick