Subject Re: Problem with ODBC connection to Linux FB server solved
Author alex_skopal
--- In firebird-support@yahoogroups.com, "alex_skopal" <Skopal@d...>
wrote:
> --- In firebird-support@yahoogroups.com, Helen Borrie
<helebor@t...>
> wrote:
> > At 07:19 AM 16/09/2004 +0000, you wrote:
> > >--- In firebird-support@yahoogroups.com, Helen Borrie
> <helebor@t...>
> > >wrote:
> > > > At 05:42 AM 16/09/2004 +0000, you wrote:
> > > >
> > > > >I have installed Mandrake Linux 10 and Firebird SS 1.5. On
this
> > > > >machine I can connect to database and work with it.
> > > > >
> > > > >When I try to connect through ODBC from another machine (Win
> 98) I
> > > > >always obtain after 1 minute wait time message "Unable to
> complete
> > > > >network request to host "10.52.20.13". Failed to establish
> > > > >connection. unknown Win32 error 10060"
> > > > >
> > > > >Through the same ODBC client I can connect to another
Firebird
> > >server
> > > > >on Win XP without problems.
> > > > >
> > > > >I think the problem is somwhere on server side.
> In /etc/services
> > > > >exists gds_db 3050/tcp. First I tried to establish
connection
> with
> > > > >firewall set to allow 3050/tcp then without firewall but
> without
> > > > >success.
> > > > >
> > > > >Can anybody help me?
> > > >
> > > > Have you tried pinging the Linux server from the Win98
machine?
> > > > What does the connection string look like?
> > > > If the connection string is correct, does the firebird user
on
> the
> > >server
> > > > have permissions for the directory that the database file is
in?
> > > >
> > > > ./heLen
> > >
> > >Ping to the Linux server from Win98 machine is OK, even ftp
> > >connection from Win98 machine to Linux server goes OK. Firebird
> user
> > >and group have rights to /home/firebird directory where I placed
> the
> > >database files as well as rights to particular files are set for
> > >firebird user and group.
> > >Where can I find out the connection string? On ODBC connection
> setup
> > >window in database field is 10.52.20.13:zak in user field SYSDBA
> > >aliases.conf contains zak = /home/firebird/zak.fdb
> >
> > It all looks right to me. Have you tried connecting to the
> database from
> > the Win98 machine using isql?
> >
> > isql 10.52.20.13:zak -u SYSDBA -pas ekretsam
> >
> > Why not take it to the ODBC driver list if you don't solve it?
> > Subscribe:
> > <mailto:firebird-odbc-devel-request@l...?subject=subscribe>
> >
> > ./helen
>
> isql direct returns the same error message. Through Google search I
> found out that error message win32 10060 means connection time out
=
> host did not respond - probably blocked by firewall.
> When I entered the settings of firewall - I did not see 350/tcp in
> advanced. I put it down, went through rest of settings - Opened the
> settings once more and again nothing remained - as if some magic
> cancelled all my actions???
>
> Is there any way to set up and check this parameter in some Linux
> configuration file?
>
> Alex

Found out a way - in /etc/shorewall/rules I wrote ,3050 in line
Accept fw tcp ... restarted Linux and ODBC connected OK!!! At
last!!!

Alex