{"id":2255,"date":"2020-12-24T13:18:12","date_gmt":"2020-12-24T12:18:12","guid":{"rendered":"https:\/\/digitalia.culturanuova.net\/blog\/?p=2255"},"modified":"2020-12-25T08:43:30","modified_gmt":"2020-12-25T07:43:30","slug":"native-mysql-connector-not-working","status":"publish","type":"post","link":"https:\/\/digitalia.culturanuova.net\/blog\/?p=2255","title":{"rendered":"LibreBase problems with native mysql connector"},"content":{"rendered":"\n<h4>1. mysql connector not working<\/h4>\n\n\n\n<p>From LO 6.4 native mysql connector didn&#8217;t work any more. But a possible solution is to comment  the line&nbsp;<code>skip-networking<\/code>&nbsp;in my.conf.<\/p>\n\n\n\n<p>I mean <strong>now<\/strong> the line is&nbsp;<code>#skip-networking<\/code>, <strong>before<\/strong> it was&nbsp;<code>skip-networking<\/code>.<\/p>\n\n\n\n<h4>2. subforms not working<\/h4>\n\n\n\n<p>In new releases, to avoid this issue, you have to cut a small portion of code in content.xml, as in the following instructions:<\/p>\n\n\n\n<p>have a look at the content.xml in the *.odb-file (could be opened by a zip-program)<\/p>\n\n\n\n<p><strong>Not working<\/strong>&nbsp;code:<br>&lt;db:driver-settings db:system-driver-settings=&#8221;&#8221; db:base-dn=&#8221;&#8221; db:parameter-name-substitution=&#8221;false&#8221;\/&gt;<\/p>\n\n\n\n<p><strong>Working<\/strong>&nbsp;code<br>&lt;db:driver-settings db:system-driver-settings=&#8221;&#8221; db:base-dn=&#8221;&#8221;\/&gt; \u00bb <\/p>\n\n\n\n<p>It works!<\/p>\n\n\n\n<h4>3. tables or queries not working<\/h4>\n\n\n\n<p>You should check the table\/query structure and avoid fields (which should have a length) with <strong>no length<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. mysql connector not working From LO 6.4 native mysql connector didn&#8217;t work any more. But a possible solution is to comment the line&nbsp;skip-networking&nbsp;in my.conf. I mean now the line is&nbsp;#skip-networking, before it was&nbsp;skip-networking. 2. subforms not working In new releases, to avoid this issue, you have to cut a small portion of code in &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/digitalia.culturanuova.net\/blog\/?p=2255\" class=\"more-link\">Leggi tutto<span class=\"screen-reader-text\"> &#8220;LibreBase problems with native mysql connector&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[579],"tags":[125,11,54],"class_list":["post-2255","post","type-post","status-publish","format-standard","hentry","category-database","tag-librebase","tag-mysql","tag-mysqlconnector"],"_links":{"self":[{"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2255"}],"version-history":[{"count":10,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2255\/revisions"}],"predecessor-version":[{"id":2266,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2255\/revisions\/2266"}],"wp:attachment":[{"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}