{"id":942,"date":"2012-01-01T11:31:58","date_gmt":"2012-01-01T10:31:58","guid":{"rendered":"http:\/\/kudzia.eu\/b\/?p=942"},"modified":"2016-09-07T10:00:31","modified_gmt":"2016-09-07T09:00:31","slug":"new-sphinx-new-connectorj-headaches","status":"publish","type":"post","link":"https:\/\/kudzia.eu\/b\/2012\/01\/new-sphinx-new-connectorj-headaches\/","title":{"rendered":"new sphinx, new connector\/j headaches"},"content":{"rendered":"<p>sphinx 2.0.3 is out; and as new drama of getting mysql&#8217;s connector\/j begins. i did not figure out [yet] any way of making both work using the latest 5.1.18 connector, but at least i&#8217;ve managed to convince one that i use now [ 5.1.15 ] to work with sphinx.<\/p>\n<p>what works:<br \/>\nmysql-connector-java-5.1.13-bin.jar<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n\"jdbc:mysql:\/\/host:9306\/test1?socketTimeout=2000&connectTimeout=200&characterEncoding=utf8&maxAllowedPacket=512000\"\r\n\/\/ this also comes handy: enablePacketDebug=true&traceProtocol=true&logger=com.mysql.jdbc.log.StandardLogger\r\n<\/pre>\n<p>but.. only if you modify src\/searchd.cpp and change sHandshake2[]<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n..\r\n\"\\x08\\x82\" \/\/ server capabilities; CLIENT_PROTOCOL_41 | CLIENT_CONNECT_WITH_DB | SECURE_CONNECTION\r\n..\r\n<\/pre>\n<p>into<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n..\r\n\"\\x08\\x02\" \/\/ server capabilities; CLIENT_PROTOCOL_41 | CLIENT_CONNECT_WITH_DB | SECURE_CONNECTION\r\n..\r\n<\/pre>\n<p>to sum-up: kill me down. <\/p>\n<p>bug report in the sphinx issue tracking system: <a href=\"http:\/\/sphinxsearch.com\/bugs\/view.php?id=959\">#959<\/a>.<\/p>\n<p><b>edit:<\/b> it seems that adding <i>mysql_version_string = 5.0.37<\/i> in the sphinx.conf <a href=\"http:\/\/sphinxsearch.com\/bugs\/view.php?id=959#c2534\">should sort things out<\/a>. i&#8217;ll have a chance to test it in a few weeks of time. <b>edit<\/b>. no &#8211; that does not work; at least not with connector\/j 5.1.5.<\/p>\n<p><b>2012-03-09 final edit[?]<\/b> it seems that <a href=\"http:\/\/code.google.com\/p\/sphinxsearch\/source\/detail?r=3047&#038;path=\/trunk\/src\/searchd.cpp\">this<\/a> commit fixes the problem with connector\/j 5.1.18 ; sphinx from trunk &#8211; r3119 with &#8220;mysql_version_string = 5.0.37&#8221; in the sphinx.conf works fine with latest connector\/j, requires &#8220;jdbc:mysql:\/\/host:9306\/data?characterEncoding=utf8&#038;maxAllowedPacket=512000&#8221; connection string; unfortunately this fix was not included in 2.0.4 although &#8216;fresh&#8217; ; trunk version r3143 &#8211; seems to work fine.<\/p>\n<p><b>2012-08-04 yet another final edit[?]<\/b> it <a href=\"http:\/\/sphinxsearch.com\/forum\/view.html?id=9885\">seems<\/a> that 2.0.x branch will have broken handling for new connector\/js. only option is to grab trunk version for the future 2.1.x branches and use it. i&#8217;m running it now on the test environment and probably will put it on the production after a while.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>sphinx 2.0.3 is out; and as new drama of getting mysql&#8217;s connector\/j begins. i did not figure out [yet] any way of making both work using the latest 5.1.18 connector, but at least i&#8217;ve managed to convince one that i use now [ 5.1.15 ] to work with sphinx. what works: mysql-connector-java-5.1.13-bin.jar &#8220;jdbc:mysql:\/\/host:9306\/test1?socketTimeout=2000&#038;connectTimeout=200&#038;characterEncoding=utf8&#038;maxAllowedPacket=512000&#8221; \/\/ this [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,51],"tags":[44],"class_list":["post-942","post","type-post","status-publish","format-standard","hentry","category-tech","category-unimportant","tag-sphinx-search"],"_links":{"self":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts\/942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/comments?post=942"}],"version-history":[{"count":16,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts\/942\/revisions"}],"predecessor-version":[{"id":2675,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts\/942\/revisions\/2675"}],"wp:attachment":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/media?parent=942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/categories?post=942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/tags?post=942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}