firebird - getaddrinfo ENOTFOUND

Question

I am new to firebird database.

I have created a database "a" and a table "STUDENT".

I am trying to connect to the database using this npm package https://www.npmjs.com/package/node-firebird

Following is my code to connect to db and get data.

    var Firebird = require('node-firebird');
var options = {};
options.host = '127.0.0.1:c:\a.fdb';
options.port = 3050;
options.database = 'a';
options.user = 'SYSDBA';
options.password = 'sa123';
options.role = null; // default 
options.pageSize = 4096; // default when creating database 

app.get('/', function(request, response) {
    Firebird.attach(options, function(err, db) {
        if (err)
            console.log(err);//her i get error
        db.query('SELECT * FROM student', function(err, result) {
            console.log(result);
            db.detach();
        });

    });
});

I am using flameRobin. Following are my database properties

I get following error in node console.

{ [Error: getaddrinfo ENOTFOUND 127.0.0.1:c:a.fdb 127.0.0.1:c:a.fdb:3050]
  code: 'ENOTFOUND',
  errno: 'ENOTFOUND',
  syscall: 'getaddrinfo',
  hostname: '127.0.0.1:c:a.fdb',
  host: '127.0.0.1:c:a.fdb',
  port: 3050 }

help me.

Which Firebird version are you using. Firebird 2.5 and earlier do not support IPv6 addresses. — Mark Rotteveel, Sep 11 '16 at 07:15
The problem seems to be that your entire connection string is getting parsed as an IPv6 address, not sure how to solve it though, as I haven't used node.js nor node-firebird. — Mark Rotteveel, Sep 11 '16 at 17:24
HI @MARKANDBhatt, did you find a solution to this problem? I'm having the same problem. Thanks. — ThiagoPXP, May 30 '17 at 14:28

Val Marinov · Answer 1 · 2016-09-11T09:41:25.107

4

try :

options.host = '127.0.0.1'; or options.host = 'localhost';

instead of

options.host = '127.0.0.1:c:\a.fdb';

and

options.database = 'c:\a.fdb';

instead of

options.database = 'a';

edited Sep 11 '16 at 09:41

answered Sep 11 '16 at 07:47

Val Marinov

2,705
17
22

Nope. Didn't work. options.host = 'localhost'; options.database='d:\\a.fdb'; options.user = 'sysdba'; options.password = 'sa123'; This time i get "[Connection is Closed]" error – MARKAND Bhatt Sep 11 '16 at 10:43
`options.database='d:\\a.fdb'` ? is this tipo or ...? Do you mean `options.database='d:\a.fdb'` ? – Val Marinov Sep 11 '16 at 12:34
no its not typo. its because '\'(single \) is considered as escape sequence. – MARKAND Bhatt Sep 11 '16 at 12:59

score 2 · Answer 2 · answered Sep 11 '16 at 03:12

2

Try localhost:c:\a.fdb as your host and hostname

answered Sep 11 '16 at 03:12

sova

5,468
10
40
48

i tried following options.host = 'localhost:c:\a.fdb' but unsuccessful – MARKAND Bhatt Sep 11 '16 at 03:47
Is your base node.JS app is listening on a port successfully? – sova Sep 11 '16 at 03:55
Yes. it is listening – MARKAND Bhatt Sep 11 '16 at 04:03
have you tried just connecting the DB to localhost without the c:/a.b? – sova Sep 11 '16 at 04:33
Yes, I tried it. This i get different error. I get "connection closed" error – MARKAND Bhatt Sep 11 '16 at 05:56

firebird - getaddrinfo ENOTFOUND

2 Answers2