{"id":16858,"date":"2022-01-13T16:42:20","date_gmt":"2022-01-13T15:42:20","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/"},"modified":"2025-10-24T09:38:42","modified_gmt":"2025-10-24T07:38:42","slug":"installing-the-odbc-drivers-for-mariadb","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/","title":{"rendered":"Installing the ODBC drivers for MariaDB"},"content":{"rendered":"<p>This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here <em>to be completed<\/em>. Refer to <a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\">SQLite<\/a> for installing the required ODBC Driver Manager.<br \/>\nThe test system is a debian v11 (bullseye).<br \/>\nThe MariaDB ODBC drivers can be installed from the platform\u2019s default package repositories. As it is missing on this test environment, let\u2019s install the MariaDB RDBMS (v10.5.11-1 ) too, and the ODBC drivers (v3.1.9-1) as root:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,2]\">\n# apt install mariadb-server\n# apt install odbc-mariadb\n<\/pre>\n<p>A systemd service was set up and launched:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n# systemctl status mariadb\n\u25cf mariadb.service - MariaDB 10.5.11 database server\n     Loaded: loaded (\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: enabled)\n     Active: active (running) since Mon 2021-08-23 21:10:48 CEST; 5min ago\n       Docs: man:mariadbd(8)\n             https:\/\/mariadb.com\/kb\/en\/library\/systemd\/\n...\n<\/pre>\n<p>Check the ODBC driver file \/etc\/odbcinst.ini:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n# odbcinst -q -d -n \"MariaDB Unicode\" \n[MariaDB Unicode]\nDriver=libmaodbc.so\nDescription=MariaDB Connector\/ODBC(Unicode)\nThreading=0\nUsageCount=1\n<\/pre>\n<p>Grant the necessary permissions to the test user debian using the provided native administration client, mysql:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n# mysql\nMariaDB [(none)]&gt; GRANT CREATE, INSERT, SELECT, DELETE, UPDATE, DROP, ALTER ON *.* TO 'debian'@'localhost';\nMariaDB [(none)]&gt; exit;\nBye\n<\/pre>\n<p>As the user debian, create the sampledb database and its <a href=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/mysql.txt\">tables<\/a>, and <a href=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/mysql-data.txt\">populate them<\/a> using mysql again:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,2]\">\n$ mysql --user=debian --password=debian\ncreate database sampledb;\nuse sampledb;\n-- create &amp; populate the tables for mariadb by copying and pasting the statements from the above files;\n-- test the data;\nSELECT\n        c.country_name,\n        c.country_id,\n        l.country_id,\n        l.street_address,\n        l.city\nFROM\n        countries c\nLEFT JOIN locations l ON l.country_id = c.country_id\nWHERE\n        c.country_id IN ('US', 'UK', 'CN');\nOutput:\n+--------------------------+------------+------------+------------------------------------------+---------------------+\n| country_name             | country_id | country_id | street_address                           | city                |\n+--------------------------+------------+------------+------------------------------------------+---------------------+\n| China                    | CN         | NULL       | NULL                                     | NULL                |\n| United Kingdom           | UK         | UK         | 8204 Arthur St                           | London              |\n| United Kingdom           | UK         | UK         | Magdalen Centre, The Oxford Science Park | Oxford              |\n| United States of America | US         | US         | 2014 Jabberwocky Rd                      | Southlake           |\n| United States of America | US         | US         | 2011 Interiors Blvd                      | South San Francisco |\n| United States of America | US         | US         | 2004 Charade Rd                          | Seattle             |\n+--------------------------+------------+------------+------------------------------------------+---------------------+\n6 rows in set (0.001 sec)\nq\n<\/pre>\n<p>The data are OK. Configure ODBC by editing the user\u2019s DSN file:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ vi ~\/.odbc.ini\n[mysqldb]\nDescription=My mysql sample database\nDriver=MariaDB Unicode\nDatabase=sampledb\n<\/pre>\n<p>Check the DSN definition:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,6]\">\n$ odbcinst -q -s -n mysqldb\n[mysqldb]\nDescription=My mysql sample database\nDriver=MariaDB Unicode\nDatabase=sampledb\nSocket=\/var\/run\/mysqld\/mysqld.sock\n<\/pre>\n<p>See below for an explanation about the highlighted &#8220;Socket=&#8230;&#8221; line.<br \/>\nTest the DSN via isql:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,10]\">\n$ isql mysqldb -v debian debian\n+---------------------------------------+\n| Connected!                            |\n|                                       |\n| sql-statement                         |\n| help [tablename]                      |\n| quit                                  |\n|                                       |\n+---------------------------------------+\nSQL&gt; SELECT c.country_name, c.country_id, l.country_id, l.street_address, l.city FROM countries c LEFT JOIN locations l ON l.country_id = c.country_id WHERE c.country_id IN ('US', 'UK', 'CN');\n+---------------------------+-----------+-----------+-----------------------------------------+---------------------+\n| country_name              | country_id| country_id| street_address                          | city                |\n+---------------------------+-----------+-----------+-----------------------------------------+---------------------+\n| China                     | CN        |           |                                         |                     |\n| United Kingdom            | UK        | UK        | 8204 Arthur St                          | London              |\n| United Kingdom            | UK        | UK        | Magdalen Centre, The Oxford Science Park| Oxford              |\n| United States of America  | US        | US        | 2014 Jabberwocky Rd                     | Southlake           |\n| United States of America  | US        | US        | 2011 Interiors Blvd                     | South San Francisco |\n| United States of America  | US        | US        | 2004 Charade Rd                         | Seattle             |\n+---------------------------+-----------+-----------+-----------------------------------------+---------------------+\nSQLRowCount returns 6\n6 rows fetched\n<\/pre>\n<p>The ODBC connection works fine. Test the DSN from a python script using the pyodbc module:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,5]\">\n$ python3\nPython 3.9.2 (default, Feb 28 2021, 17:03:44) \n[GCC 10.2.1 20210110] on linux\nType \"help\", \"copyright\", \"credits\" or \"license\" for more information.\nimport pyodbc \ncnxn = pyodbc.connect(DSN='mysqldb;user=debian;password=debian')\ncursor = cnxn.cursor()      \ncursor.execute(\"\"\"SELECT\n...         c.country_name,\n...         c.country_id,\n...         l.country_id,\n...         l.street_address,\n...         l.city\n... FROM\n...         countries c\n... LEFT JOIN locations l ON l.country_id = c.country_id\n... WHERE\n...         c.country_id IN ('US', 'UK', 'CN')\"\"\")\n\nrow = cursor.fetchone() \n while row:\n...     print (row) \n...     row = cursor.fetchone()\n... \nOutput:\n('China', 'CN', None, None, None)\n('United Kingdom', 'UK', 'UK', '8204 Arthur St', 'London')\n('United Kingdom', 'UK', 'UK', 'Magdalen Centre, The Oxford Science Park', 'Oxford')\n('United States of America', 'US', 'US', '2014 Jabberwocky Rd', 'Southlake')\n('United States of America', 'US', 'US', '2011 Interiors Blvd', 'South San Francisco')\n('United States of America', 'US', 'US', '2004 Charade Rd', 'Seattle')\n<\/pre>\n<p>Everything is just fine.<br \/>\nNote: When the MariaDB database is restarted, an error message such as the one below from isql is displayed when connecting to a database as a non-root user:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [2]\">\n$ isql -v mysqldb debian debian\n[S1000][unixODBC][ma-3.1.7]Can't connect to local MySQL server through socket '\/tmp\/mysql.sock' (2)\n[ISQL]ERROR: Could not SQLConnect\n<\/pre>\n<p>or from pyodbc:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [2]\">\npyodbc.Error: ('HY000', \"[HY000] [ma-3.1.7]Can't connect to local MySQL server through socket '\/tmp\/mysql.sock' (2) (2002) (SQLDriverConnect)\")\n<\/pre>\n<p>If this happens, just make sure the line Socket=\/var\/run\/mysqld\/mysqld.sock is present in ~\/.odbc.ini. Alternatively, but not as good because as it is needed each time the database is restarted, create the symlink below as root:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n# ln -s \/run\/mysqld\/mysqld.sock \/tmp\/mysql.sock\n<\/pre>\n<p>MariaDB is now fully accessible from any ODBC application under the debian account.<br \/>\nInstructions for the other data sources can be accessed through the following links:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\">SQLite<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\">Firebird<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\">HSQLDB<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-postgresql\">PostgreSQL<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\">Oracle<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\">Microsoft SQLServer for Linux<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mongodb\">MongoDB<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-cdata-odbc-drivers-for-excel\/\">Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,368],"tags":[],"type_dbi":[],"class_list":["post-16858","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-development-performance"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Installing the ODBC drivers for MariaDB - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installing the ODBC drivers for MariaDB\" \/>\n<meta property=\"og:description\" content=\"This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-13T15:42:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-24T07:38:42+00:00\" \/>\n<meta name=\"author\" content=\"Middleware Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Middleware Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/\"},\"author\":{\"name\":\"Middleware Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"headline\":\"Installing the ODBC drivers for MariaDB\",\"datePublished\":\"2022-01-13T15:42:20+00:00\",\"dateModified\":\"2025-10-24T07:38:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/\"},\"wordCount\":315,\"commentCount\":0,\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Development &amp; Performance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/\",\"name\":\"Installing the ODBC drivers for MariaDB - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-01-13T15:42:20+00:00\",\"dateModified\":\"2025-10-24T07:38:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installing the ODBC drivers for MariaDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\",\"name\":\"Middleware Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"caption\":\"Middleware Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Installing the ODBC drivers for MariaDB - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/","og_locale":"en_US","og_type":"article","og_title":"Installing the ODBC drivers for MariaDB","og_description":"This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/","og_site_name":"dbi Blog","article_published_time":"2022-01-13T15:42:20+00:00","article_modified_time":"2025-10-24T07:38:42+00:00","author":"Middleware Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Middleware Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/"},"author":{"name":"Middleware Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"headline":"Installing the ODBC drivers for MariaDB","datePublished":"2022-01-13T15:42:20+00:00","dateModified":"2025-10-24T07:38:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/"},"wordCount":315,"commentCount":0,"articleSection":["Database Administration &amp; Monitoring","Development &amp; Performance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/","url":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/","name":"Installing the ODBC drivers for MariaDB - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-01-13T15:42:20+00:00","dateModified":"2025-10-24T07:38:42+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Installing the ODBC drivers for MariaDB"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1","name":"Middleware Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","caption":"Middleware Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16858","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16858"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16858\/revisions"}],"predecessor-version":[{"id":41200,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16858\/revisions\/41200"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16858"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16858"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}