Hi, I have pdns installed on ubuntu 16.04 (4.0.5-1pdns.xenial), initially with MariaDB with replication, all good. I want to use HFSQL as a backend, so have installed HFSQL. I have installed pdns-backend-odbc however HFSQL uses iodbc. On pdns start I get connection errors on iodbc test all ok (schema is MariaDB): root@localhost:/etc/powerdns# iodbctest "DSN=test;UID=admin;PWD=removed" iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0812.0326 Driver: 22.00.0800 (wd220hfo64.so) SQL>select * from domains id |name |master |last_check|TYPE |notified_serial|account -----+---------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ----------------------------------+----------------------------------------- ---------------------------------------------------------------------------- ------------+----------+-------+---------------+---------------------------- -- 2 |removed.uk |*************************************************************************** ******************************************************|**********|NATIVE |***************|****************************** 3 |removed.co.uk | |**********|NATIVE |2018042100 |****************************** result set 1 returned 2 rows. SQL> On pdns start I get: Apr 25 13:56:00 localhost systemd[1]: Starting PowerDNS Authoritative Server... Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Reading random entropy from '/dev/urandom' Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Loading '/usr/lib/x86_64-linux-gnu/pdns/libgodbcbackend.so' Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 This is module godbcbackend reporting Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Loading '/usr/lib/x86_64-linux-gnu/pdns/libbindbackend.so' Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 This is a standalone pdns Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Listening on controlsocket in '/var/run/pdns.controlsocket' Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 UDP server bound to 0.0.0.0:5301 Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 UDPv6 server bound to [::]:5301 Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 TCP server bound to 0.0.0.0:5301 Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 TCPv6 server bound to [::]:5301 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 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. 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. 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 Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Creating backend connection for TCP 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/ 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/ Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Cleaning up 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/ Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 About to create 3 backend threads for UDP Apr 25 13:56:00 localhost systemd[1]: Started PowerDNS Authoritative Server. 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/ 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/ Apr 25 13:56:00 localhost pdns_server[4185]: Apr 25 13:56:00 Cleaning up 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/ Apr 25 13:56:00 localhost systemd[1]: pdns.service: Main process exited, code=exited, status=1/FAILURE Apr 25 13:56:00 localhost systemd[1]: pdns.service: Unit entered failed state. Apr 25 13:56:00 localhost systemd[1]: pdns.service: Failed with result 'exit-code'. ^C pdns.conf launch=godbc godbc-datasource=test godbc-username=admin godbc-password=removed /etc/odbc.ini [ODBC] Debug = 1 Trace = 1 DebugFile = /home/tim/temp/odbc-debugfile.log TraceFile = /home/tim/temp/odbc-tracefile.log TraceAutoStop = 1 [ODBC Data Sources] test = HFSQL [test] Driver =HFSQL Server Name =removed Server Port =4900 Database =test UID =admin PWD =removed Trace = yes /etc/odbcinst.ini [ODBC Drivers] HFSQL = Installed [HFSQL] Description = HFSQL ODBC Driver Driver = /usr/local/hfsqlodbc/wd220hfo64.so I have been using HFSQL for over 10 years hence why I want to use that DB. Does pdns work with iodbc? Any suggestions ? Thanks Tony CONFIDENTIAL - This email and its attachments may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of NodeMax Limited. 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. please inform the sender on 0333-990-9000 and then delete the e-mail from your system 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 NodeMax Limited - Company No:- 06127089 - Registered in England - Registered Address:- 75 SPRINGFIELD ROAD, CHELMSFORD,ESSEX, CM2 6JB. UNITED KINGDOM
_______________________________________________ Pdns-users mailing list [email protected] https://mailman.powerdns.com/mailman/listinfo/pdns-users
