Author Topic: Passing user credentials to Firebird server  (Read 6968 times)

0 Members and 1 Guest are viewing this topic.

Offline Chris64

  • Member
  • *
  • Posts: 21
    • View Profile
Passing user credentials to Firebird server
« on: November 10, 2013, 08:43:28 pm »

Hi Nostra,

as far as I can see, PVD does not make any use of the "ISC_USER/ISC_PASSWORD" environment variables, which
would allow seamless connection from PVD to a FB server.

Is such feature planned?

TIA Chris

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Passing user credentials to Firebird server
« Reply #1 on: November 11, 2013, 09:16:50 pm »
Actually, it seems like Firebird should pick those values by itself. I will check if it is smth easy I can do to make it do so,
Gentlemen, you can’t fight in here! This is the War Room!

Offline Chris64

  • Member
  • *
  • Posts: 21
    • View Profile
Re: Passing user credentials to Firebird server
« Reply #2 on: November 12, 2013, 12:33:17 am »
Actually, it seems like Firebird should pick those values by itself. I will check if it is smth easy I can do to make it do so,

I read about this too that fbclient should get it.
But it looks like it doesn't ... I already tried this to no avail. :-(

Code: [Select]
@echo off
SET PATH=C:\Program Files\PVD;%PATH%
SET ISC_USER=xxxxxxxx
SET ISC_PASSWORD=yyyyyyyy
start viddb.exe
# OR (alternatively)
viddb.exe

will not give me the expected behaviour from a batch.

Even setting the variables system wide would allow the cmd line tools
of Firebird (i.e. gbak) to work from a cmd line (without user/pass), while
PVD presents me a login prompt for the user/pass credentials on each
new start.

So thx for looking into it!

EDIT:
Forgot to mention that even "Process Hacker" shows the variables
in the process' environment of viddb.exe when started from the batch.

« Last Edit: November 12, 2013, 12:40:36 am by Chris64 »