problem connecting to firebird server

[abubin]

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?

[nostra]

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

[abubin]

latest pvd_portable  version, 1.0.2.7.

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

[nostra]

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

[abubin]

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?

[nostra]

Yes

[abubin]

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

[abubin]

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?

[abubin]

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...