URI format for firebird database on windows

[rz...@bodnargroup.com]

Linux works fine when the uri is formatted as such:

db:firebird://sysdba:masterkey@myhost.com://path/to/database.fdb

But what if my database is located on a windows server? I tried using this format:

db:firebird://sysdba:mast...@myhost.com/c:/path/to/database.fdb

Which yields this error:

Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
-Unable to complete network request to host "sysdba".
-Failed to locate host machine.

It doesn't seem like the uri is being parsed correctly. Is this a bug or am I just not formatting my uri correctly?

[David E. Wheeler]

On Sep 5, 2015, at 7:51 PM, rz...@bodnargroup.com wrote:

> db:firebird://sysdba:mast...@myhost.com/c:/path/to/database.fdb
>
> Which yields this error:
>
> Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
> -Unable to complete network request to host "sysdba".
> -Failed to locate host machine.

I don’t know Firebird well, but that error suggests that it can’t connect to the Firebird server. Are you able to connect using isql?

> It doesn't seem like the uri is being parsed correctly. Is this a bug or am I just not formatting my uri correctly?

I would think you would need another slash, or backslashes. Try messing with the URI in this one-liner until it starts to look right:

> perl -MURI -E 'say URI->new(shift)->dbname' db:firebird://sysdba:mast...@myhost.com/c:/path/to/database.fdb
c://path/to/database.fdb

Maybe use backslashes?

HTH,

David

[rz...@bodnargroup.com]

I am able to connect to the database using isql. However, the URI format that isql uses differs from the one that sqitch uses. Based on that error message, it seems that the username is being parsed as the host.

I'm going to use your one-liner to try a couple of different combinations. Thanks for the info.

[rz...@bodnargroup.com]

I found the cause of my issue. I've created a github issue for URI::db: https://github.com/theory/uri-db/issues/7.