Author Topic: problem connecting to firebird server  (Read 9239 times)

0 Members and 1 Guest are viewing this topic.

Offline abubin

  • User
  • ***
  • Posts: 54
    • View Profile
problem connecting to firebird server
« 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?

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: problem connecting to firebird server
« Reply #1 on: December 14, 2013, 09:24:37 pm »
What is your PVD version?
How do you enter the database path?
Gentlemen, you can’t fight in here! This is the War Room!

Offline abubin

  • User
  • ***
  • Posts: 54
    • View Profile
Re: problem connecting to firebird server
« Reply #2 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


Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: problem connecting to firebird server
« Reply #3 on: December 15, 2013, 01:45:38 pm »
You must enter the path like this:
192.168.1.223:/path to the database
Gentlemen, you can’t fight in here! This is the War Room!

Offline abubin

  • User
  • ***
  • Posts: 54
    • View Profile
Re: problem connecting to firebird server
« Reply #4 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?
« Last Edit: December 15, 2013, 04:50:47 pm by abubin »

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: problem connecting to firebird server
« Reply #5 on: December 15, 2013, 08:08:27 pm »
Yes
Gentlemen, you can’t fight in here! This is the War Room!

Offline abubin

  • User
  • ***
  • Posts: 54
    • View Profile
Re: problem connecting to firebird server
« Reply #6 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.

Offline abubin

  • User
  • ***
  • Posts: 54
    • View Profile
Re: problem connecting to firebird server
« Reply #7 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?

Offline abubin

  • User
  • ***
  • Posts: 54
    • View Profile
Re: problem connecting to firebird server
« Reply #8 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... ::)

 

anything