Author Topic: Firebird Authentication?  (Read 9435 times)

0 Members and 1 Guest are viewing this topic.

Offline raldo

  • Power User
  • ****
  • Posts: 140
    • View Profile
Firebird Authentication?
« on: December 11, 2009, 09:30:40 am »
Has anyone tried to run PVD as a client running on another computer than the server?

I'm getting firebird 401 errors which indicates that there is something wrong with the user authentication. Where are username and password for server mode in PVD?

My "use case" is that I've installed the server on an HTPC which runs JRiver Media Center (JRMC). PvdImport is used to connect JRMC to PVD. I'd like to run PVD from client laptops so that the metadata acquirement process is moved away from the HTPC.

Offline patch

  • Older Power User
  • *****
  • Posts: 250
    • View Profile
Re: Firebird Authentication?
« Reply #1 on: December 11, 2009, 09:53:00 am »
Has anyone tried to run PVD as a client running on another computer than the server?

Generally Firebird does not like having the database on a remote server.
Have you tried copying the database to the remote computer?

Offline raldo

  • Power User
  • ****
  • Posts: 140
    • View Profile
Re: Firebird Authentication?
« Reply #2 on: December 11, 2009, 11:30:08 am »
Have you tried copying the database to the remote computer?

I forgot to mention that the DB is located on the server. The client (implemented in PVD) shall run on another computer.

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Firebird Authentication?
« Reply #3 on: December 13, 2009, 12:49:30 am »
The "Connect to server" option is made for exactly the same cases and seems to work for a number of users. Are you using the latest PVD version? Could it be an access rights issue in windows? What is the exact error message? Which path do you enter to connect to the database?
Gentlemen, you can’t fight in here! This is the War Room!

Offline raldo

  • Power User
  • ****
  • Posts: 140
    • View Profile
Re: Firebird Authentication?
« Reply #4 on: December 14, 2009, 12:14:46 am »
The "Connect to server" option is made for exactly the same cases and seems to work for a number of users. Are you using the latest PVD version? Could it be an access rights issue in windows? What is the exact error message? Which path do you enter to connect to the database?
o Using .14
o Access rights: Possibly, but I have no idea. The connection was attempted between two vista machines.
o I did this at my sisters home and I don't have the exact error message. The message number was 401 from firebird which is related to authentication
o Path: <computername>:<local computer path>

Maybe a logon to the computer itself is somehow needed?

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Firebird Authentication?
« Reply #5 on: December 14, 2009, 01:59:19 am »
Hmm, does it work if you install PVD on this machine and try to connect to the server?
Gentlemen, you can’t fight in here! This is the War Room!

Offline patch

  • Older Power User
  • *****
  • Posts: 250
    • View Profile
Re: Firebird Authentication?
« Reply #6 on: December 14, 2009, 08:56:55 am »
I forgot to mention that the DB is located on the server. The client (implemented in PVD) shall run on another computer.
I think You need to have the database file on the same computer that is running firebird (ie not accessed across a network). Options are

1) Stand alone PVD (with internal firebird) & Database file on same machine.
2) Firebird server running on a PC accessing database on same computer. Other local or remote users connect to firebird server.

Note in both cases database File is on same computer as firebird is running on.

Offline raldo

  • Power User
  • ****
  • Posts: 140
    • View Profile
Re: Firebird Authentication?
« Reply #7 on: December 14, 2009, 12:32:31 pm »
I think You need to have the database file on the same computer that is running firebird (ie not accessed across a network). Options are

The database file IS located on the same computer as the Firebird server.

Offline patch

  • Older Power User
  • *****
  • Posts: 250
    • View Profile
Re: Firebird Authentication?
« Reply #8 on: December 14, 2009, 12:47:21 pm »
Are you running firebird as a service (administrator) or program?
If running as a program, is it running with administrator rights or as a normal user.

I have had problems using a database after it has been opened by another user / administrator.
See http://www.videodb.info/forum_en/index.php?topic=1391.msg6171#msg6171
« Last Edit: December 14, 2009, 01:01:39 pm by patch »

Offline raldo

  • Power User
  • ****
  • Posts: 140
    • View Profile
Re: Firebird Authentication?
« Reply #9 on: December 14, 2009, 01:18:10 pm »
Are you running firebird as a service (administrator) or program?

Service.

The link you provided seems like a good hint as to how I can proceed. I'll take a look at the thread...