Subject | Re: connection ! problem - centos 4.3, have tested with all versions of 1.5.3 |
---|---|
Author | michael_compuser |
Post date | 2006-10-04T13:44:26Z |
Thanks for this initial help helen.
ib_sql on the windows workstation allows me to connect to each of
the databases on the (i.p. = 192.168.2.10) server. No problems. I
can browse each database. No error messages and nothing is generated
in the firebird log file when I do this
There is repeated message in the firebird log file which I think
occurred during re-installation. This was due to an installation
issue that I corrected...(I downgraded to 1.5.1 SS which is the same
as the version I have in the office server)
asterisk1.local (Server) Wed Oct 4 21:22:10 2006
INET/INET_connect: gethostbyname failed, error code = 1
I'm not getting any firebird log messages now
Could there be a problem with security.fdb?
Rgds
Michael_compused
ib_sql on the windows workstation allows me to connect to each of
the databases on the (i.p. = 192.168.2.10) server. No problems. I
can browse each database. No error messages and nothing is generated
in the firebird log file when I do this
There is repeated message in the firebird log file which I think
occurred during re-installation. This was due to an installation
issue that I corrected...(I downgraded to 1.5.1 SS which is the same
as the version I have in the office server)
asterisk1.local (Server) Wed Oct 4 21:22:10 2006
INET/INET_connect: gethostbyname failed, error code = 1
I'm not getting any firebird log messages now
Could there be a problem with security.fdb?
Rgds
Michael_compused
> The first one to look at is the one of reading a static connectionwill
> string from an ini file and expecting it to "just work" on any
> network. The IP address 198.168.2.10 is a restricted one that
> work ONLY within a Class C LAN and then only if there is a hostthat
> broadcasting that address within that LAN.
>
> The overriding problem, from a troubleshooting point of view, is
> you are not reporting any exception messages that one could deducegenerated
> anything about. The one error message you tell us about is
> by your application, not by Firebird or InterBase. Apparentlyyour
> application code is merely "eating" all exceptions from thedatabase
> server/client interface and blatting them out as "cannotreturns
> connect". No doubt you can understand how unhelpful this is.
>
> I suggest that you try to repeat your tests using a tool that
> the actual exception messages. The command-line utility isql willdo
> that, or you could download ib_sql from www.ibobjects.com. (Tocopy
> output from the Windows command shell window, highlight the textwith
> your mouse and press Enter. You can then paste it into an emailor
> other file...)If
>
> You say there is "nothing useful" in the log. Could you post the
> "non-useful" entries that appear after your connection failures?
> you inspect the log in a console window that you opened from youryour
> Centos GUI, you will be able to copy from it.
>
> Another thing I can't work out is how you "connect locally" from
> Windows application to a database running on a Linux host. Couldyou
> explain more exactly how you do that, e.g. are you running the
> Windows app in a wine server or other Windows emulator?
>
> ./heLen
>