<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Calibri Light";
panose-1:2 15 3 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have pdns installed on ubuntu 16.04 (4.0.5-1pdns.xenial), initially with MariaDB with replication, all good.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I want to use HFSQL as a backend, so have installed HFSQL.<br><br>I have installed pdns-backend-odbc however HFSQL uses iodbc.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>On pdns start I get connection errors on iodbc test all ok (schema is MariaDB):<o:p></o:p></p><p class=MsoNormal><br>root@localhost:/etc/powerdns# iodbctest "DSN=test;UID=admin;PWD=removed"<o:p></o:p></p><p class=MsoNormal>iODBC Demonstration program<o:p></o:p></p><p class=MsoNormal>This program shows an interactive SQL processor<o:p></o:p></p><p class=MsoNormal>Driver Manager: 03.52.0812.0326<o:p></o:p></p><p class=MsoNormal>Driver: 22.00.0800 (wd220hfo64.so)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>SQL>select * from domains<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>id |name |master |last_check|TYPE |notified_serial|account <o:p></o:p></p><p class=MsoNormal>-----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+----------+-------+---------------+------------------------------<o:p></o:p></p><p class=MsoNormal>2 |removed.uk |*********************************************************************************************************************************|**********|NATIVE |***************|******************************<o:p></o:p></p><p class=MsoNormal>3 |removed.co.uk | |**********|NATIVE |2018042100 |******************************<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> result set 1 returned 2 rows.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>SQL><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>On pdns start I get:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost systemd[1]: Starting PowerDNS Authoritative Server...<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Reading random entropy from '/dev/urandom'<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Loading '/usr/lib/x86_64-linux-gnu/pdns/libgodbcbackend.so'<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 This is module godbcbackend reporting<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Loading '/usr/lib/x86_64-linux-gnu/pdns/libbindbackend.so'<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 This is a standalone pdns<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Listening on controlsocket in '/var/run/pdns.controlsocket'<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 UDP server bound to 0.0.0.0:5301<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 UDPv6 server bound to [::]:5301<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 TCP server bound to 0.0.0.0:5301<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 TCPv6 server bound to [::]:5301<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 PowerDNS Authoritative Server 4.0.5 (C) 2001-2017 PowerDNS.COM BV<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Using 64-bits mode. Built using gcc 5.4.0 20160609 on Nov 27 2017 11:39:57 by root@ba7ddca31948.<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Polled security status of version 4.0.5 at startup, no known issues reported: OK<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Creating backend connection for TCP<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 godbc Connection failed: Could not connect to ODBC datasource.: I10[unixODBC]I/<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Caught an exception instantiating a backend: Unable to launch godbc connection: Could not connect to ODBC datasource.: I10[unixODBC]I/<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Cleaning up<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 TCP server is unable to launch backends - will try again when questions come in: Unable to launch godbc connection: Could not connect to ODBC datasource.: I10[unixODBC]I/<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 About to create 3 backend threads for UDP<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost systemd[1]: Started PowerDNS Authoritative Server.<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 godbc Connection failed: Could not connect to ODBC datasource.: I10[unixODBC]I/<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Caught an exception instantiating a backend: Unable to launch godbc connection: Could not connect to ODBC datasource.: I10[unixODBC]I/<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Cleaning up<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Distributor caught fatal exception: Unable to launch godbc connection: Could not connect to ODBC datasource.: I10[unixODBC]I/<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost systemd[1]: pdns.service: Main process exited, code=exited, status=1/FAILURE<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost systemd[1]: pdns.service: Unit entered failed state.<o:p></o:p></p><p class=MsoNormal>Apr 25 13:56:00 localhost systemd[1]: pdns.service: Failed with result 'exit-code'.<o:p></o:p></p><p class=MsoNormal>^C<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>pdns.conf<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>launch=godbc<o:p></o:p></p><p class=MsoNormal>godbc-datasource=test<o:p></o:p></p><p class=MsoNormal>godbc-username=admin<o:p></o:p></p><p class=MsoNormal>godbc-password=removed<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>/etc/odbc.ini<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[ODBC]<o:p></o:p></p><p class=MsoNormal>Debug = 1<o:p></o:p></p><p class=MsoNormal>Trace = 1<o:p></o:p></p><p class=MsoNormal>DebugFile = /home/tim/temp/odbc-debugfile.log<o:p></o:p></p><p class=MsoNormal>TraceFile = /home/tim/temp/odbc-tracefile.log<o:p></o:p></p><p class=MsoNormal>TraceAutoStop = 1<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[ODBC Data Sources]<o:p></o:p></p><p class=MsoNormal>test = HFSQL<o:p></o:p></p><p class=MsoNormal>[test]<o:p></o:p></p><p class=MsoNormal>Driver =HFSQL<o:p></o:p></p><p class=MsoNormal>Server Name =removed<o:p></o:p></p><p class=MsoNormal>Server Port =4900<o:p></o:p></p><p class=MsoNormal>Database =test<o:p></o:p></p><p class=MsoNormal>UID =admin<o:p></o:p></p><p class=MsoNormal>PWD =removed<o:p></o:p></p><p class=MsoNormal>Trace = yes<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>/etc/odbcinst.ini<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[ODBC Drivers]<o:p></o:p></p><p class=MsoNormal>HFSQL = Installed<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[HFSQL]<o:p></o:p></p><p class=MsoNormal>Description = HFSQL ODBC Driver<o:p></o:p></p><p class=MsoNormal>Driver = /usr/local/hfsqlodbc/wd220hfo64.so<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have been using HFSQL for over 10 years hence why I want to use that DB. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Does pdns work with iodbc?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Any suggestions ?<br><br>Thanks<br><br>Tony<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB style='font-family:"Calibri Light",sans-serif;color:black'>CONFIDENTIAL - This email and its attachments may be confidential and are intended solely for the use of the individual to whom it is addressed. <o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB style='font-family:"Calibri Light",sans-serif;color:black'>Any views or opinions expressed are solely those of the author and do not necessarily represent those of NodeMax Limited.<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB style='font-family:"Calibri Light",sans-serif;color:black'>If you are not the intended recipient of this email and any attachments, you must take no action based upon them, nor must you copy or show them to anyone.<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB style='font-family:"Calibri Light",sans-serif;color:black'>please inform the sender on 0333-990-9000 and then delete the e-mail from your system <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri Light",sans-serif;color:black'>NodeMax Ltd has taken every reasonable precaution to ensure that any attachment to this email has been swept for viruses. However, NodeMax Ltd cannot accept liability for any damage sustained as a result of software viruses and would advise that you carry out your own virus checks before opening any attachment<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-family:"Calibri Light",sans-serif;color:black'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-family:"Calibri Light",sans-serif;color:black'>NodeMax Limited - Company No:- 06127089 - Registered in England - Registered Address:- 75 SPRINGFIELD ROAD, CHELMSFORD,ESSEX, CM2 6JB. UNITED KINGDOM<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri Light",sans-serif;color:black'><br><br><br><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>