Personal Video Database

English => Support => Topic started by: abubin on December 14, 2013, 08:42:58 pm

Title: problem connecting to firebird server
Post by: abubin on December 14, 2013, 08:42:58 pm

ok it's me again and this time I am trying to setup a firebird server in my linux server. I am having problems getting PVD to work with this external server.

I am running firebird server 2.5.2 on ubuntu 12.04.

I have started the server and try to telnet into the server and it responded well on port 3050 (default port for firebird).

However, when I try to connect to this db from my windows using pvd_portable, it doesn't work. I get crash to desktop. PVD_portable will close without any warning. Any idea how to solve this?

Title: Re: problem connecting to firebird server
Post by: nostra on December 14, 2013, 09:24:37 pm

What is your PVD version?
How do you enter the database path?

Title: Re: problem connecting to firebird server
Post by: abubin on December 15, 2013, 09:11:57 am

latest pvd_portable  version, 1.0.2.7.

Firebird database path I key in the IP address of my server: 192.168.1.223

Title: Re: problem connecting to firebird server
Post by: nostra on December 15, 2013, 01:45:38 pm

You must enter the path like this:
192.168.1.223:/path to the database

Title: Re: problem connecting to firebird server
Post by: abubin on December 15, 2013, 04:48:51 pm

ah..ok i manage to connect to the database now. Had to use FlameRobin (firebird gui) to do some setting up of firebird server. Now I can connect to the pvd database. However, using firebird database, the "save images in database file" is checked and gray out. That means the images must be saved in the DB when using firebird server?

Title: Re: problem connecting to firebird server
Post by: nostra on December 15, 2013, 08:08:27 pm

Yes

Title: Re: problem connecting to firebird server
Post by: abubin on December 15, 2013, 08:43:44 pm

alright..after doing a lot more tests and consideration. I will now stick with using firebird server. Thanks for all the advice and help.

Title: Re: problem connecting to firebird server
Post by: abubin on July 05, 2014, 09:44:27 am

i have just reinstalled my server into ubuntu 14.04. And I tell you..I have a tough time installing firebird.

Seems like there is a bug with the firebird package in this distro. It tried tons to install and re-install and firebird-classic, firebird-super and firebird-superclassic and still unable to install from the package.

So I downloaded the latest source of firebird-super and installed it manually. Eventually the firebird server starts to work. Now I am stuck in trying to connect PVD portable to the firebird pvd database.

I can get a prompt asking me for username and password but when I key in the username and pass (pvd/pvd) it just doesn't connect. Gave me an error saying user not yet setup and need to contact db admin and yadda yadda.

But already created the user pvd and tried connecting from FlameRobin and it works.

I am out of idea...anyone can help?

Title: Re: problem connecting to firebird server
Post by: abubin on July 05, 2014, 09:54:20 am

ok..solved it LOL...

leaving the comment here so that I can refer it back myself in the future or for anyone who might have similar issue.

having installed firebird manually, the aliases.conf is actually located in different location. /opt/firebird

LOL... ::)