Yii2-sphinx: Lost connection to MySQL server

Yii 2.0 General Discussions
1

Hi !

I have installed Sphinx 2.2.11 at my VPS on CentOS 7. Also I have installed php extension

–

sphinx support enabled

Version 1.3.3

–

When I try to connect then I get error message like


Caused by: PDOException

SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 0

in web.php I am using standard settings




'sphinx' => [

            'class' => 'yii\sphinx\Connection',

            'dsn' => 'mysql:host=127.0.0.1;port=9312;',

            'username' => '',

            'password' => '',

        ],

also I can get sphinx result via console command like


indextool --dumphitlist sphinx_index_topic "yii2" | more

But I get error from yii2 application. To my mind everything was installed in order to work correct but unfortunately It doesnt (:

What I should do ?

Thanks in advance

2

http://sphinxsearch.com/forum/view.html?id=11663