[Pdns-users] godbc

Wed Apr 25 07:07:04 UTC 2018

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 at 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 at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20180425/fb476f40/attachment-0001.html>