{"id":3160,"date":"2021-01-16T09:57:02","date_gmt":"2021-01-16T08:57:02","guid":{"rendered":"https:\/\/kudzia.eu\/b\/?p=3160"},"modified":"2021-01-16T10:00:51","modified_gmt":"2021-01-16T09:00:51","slug":"letting-dbeaver-talk-with-manticoresearch","status":"publish","type":"post","link":"https:\/\/kudzia.eu\/b\/2021\/01\/letting-dbeaver-talk-with-manticoresearch\/","title":{"rendered":"letting dbeaver talk with manticoresearch"},"content":{"rendered":"<p>here&#8217;s what i did to get dbeaver 7.3.2 + oracle&#8217;s JDBC mysql-connector-java-8.0.17.jar work with manticoresearch 3.5.4:<\/p>\n<ul>\n<li>\/etc\/manticoresearch\/manticore.conf, under searchd:\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nlisten = 127.0.0.1:9306:mysql\r\nmysql_version_string = 5.1.0\r\n<\/pre>\n<\/li>\n<li>\nin dbeaver &#8211; new connection using oracle&#8217;s JDBC driver as above, under data editor &#8211; set ResultFetchSize to 0 to prevent errors like this:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nSQL Error &#x5B;1064] &#x5B;42000]: sphinxql: only 0 and 1 could be used as boolean values near '200'\r\n<\/pre>\n<\/li>\n<\/ul>\n<p>when i initially tried to get it working with JDBC driver from MariaDB snooping on the payload of the binary communication was helpful:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\ntcpdump -n -i lo -w - port 9306 | tcpflow -C -r -\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>here&#8217;s what i did to get dbeaver 7.3.2 + oracle&#8217;s JDBC mysql-connector-java-8.0.17.jar work with manticoresearch 3.5.4: \/etc\/manticoresearch\/manticore.conf, under searchd: listen = 127.0.0.1:9306:mysql mysql_version_string = 5.1.0 in dbeaver &#8211; new connection using oracle&#8217;s JDBC driver as above, under data editor &#8211; set ResultFetchSize to 0 to prevent errors like this: SQL Error &#x5B;1064] &#x5B;42000]: sphinxql: only [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,51],"tags":[],"class_list":["post-3160","post","type-post","status-publish","format-standard","hentry","category-uncategorized","category-unimportant"],"_links":{"self":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts\/3160","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=3160"}],"version-history":[{"count":4,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts\/3160\/revisions"}],"predecessor-version":[{"id":3164,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts\/3160\/revisions\/3164"}],"wp:attachment":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/media?parent=3160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/categories?post=3160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/tags?post=3160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}