Subject | Remote Connections (FirebirdCS-0.9-4p1, Mandrake 7.2) |
---|---|
Author | Ian A. Newby |
Post date | 2001-03-20T13:30:35Z |
Hi all,
I have a number of installations of both Interbase 6.0.1 and
Firebird 0.9-4 on linux boxes. I have backed up a database on the
Interbase box and restored it on the Firebird box with no problems
reported.
On the firebird box I have run the CSchangeRunUser.sh to change the
user to firebird. I have also chmod firebird.firebird my database
file.
Both boxes run interclient (1.6 dialect 1) and act as web servers.
Both webservers work correctly from my windows client.
Now to the problem.
If I try and connect from any machine (windows or linux) to the web
server via isql I get the following error if I include the -user
sysdba -password ***** string:
Internal error: Unexpected isc_info_value 48
Internal error: Unexpected isc_info_value 10
Internal error: Unexpected isc_info_value 2
Segmentation fault (core dumped)
I have tried to connect via Quickdesk on my Windows box (also running
firebird). With this quickdesk returns the metadata of the database,
allows SQL scripts to be run but hangs if an sql command is entered.
All these have been tried in Interbase 6.0 and work. The only
difference is the Interbase box runs Redhat 6.2 and the Firebird runs
Mandrake 7.2.
The xinetd.d files I have created are as follows based on info from
sourceforge:
interbase file:
# default: on
# description: Interbase server
service gds_db
{
flags = REUSE
socket_type = stream
wait = no
user = firebird
log_on_success += USERID
log_on_failure += USERID
server = /opt/interbase/bin/gds_inet_server
}
interserver file:
# default: on
# description: Interbase JDBC Driver
service interserver
{
flags = REUSE
socket_type = stream
wait = no
user = root
log_on_success += USERID
log_on_failure += USERID
server = /usr/interclient/bin/interserver
}
If anyone can help I would much appreciate it!
Regards Ian Newby
I have a number of installations of both Interbase 6.0.1 and
Firebird 0.9-4 on linux boxes. I have backed up a database on the
Interbase box and restored it on the Firebird box with no problems
reported.
On the firebird box I have run the CSchangeRunUser.sh to change the
user to firebird. I have also chmod firebird.firebird my database
file.
Both boxes run interclient (1.6 dialect 1) and act as web servers.
Both webservers work correctly from my windows client.
Now to the problem.
If I try and connect from any machine (windows or linux) to the web
server via isql I get the following error if I include the -user
sysdba -password ***** string:
Internal error: Unexpected isc_info_value 48
Internal error: Unexpected isc_info_value 10
Internal error: Unexpected isc_info_value 2
Segmentation fault (core dumped)
I have tried to connect via Quickdesk on my Windows box (also running
firebird). With this quickdesk returns the metadata of the database,
allows SQL scripts to be run but hangs if an sql command is entered.
All these have been tried in Interbase 6.0 and work. The only
difference is the Interbase box runs Redhat 6.2 and the Firebird runs
Mandrake 7.2.
The xinetd.d files I have created are as follows based on info from
sourceforge:
interbase file:
# default: on
# description: Interbase server
service gds_db
{
flags = REUSE
socket_type = stream
wait = no
user = firebird
log_on_success += USERID
log_on_failure += USERID
server = /opt/interbase/bin/gds_inet_server
}
interserver file:
# default: on
# description: Interbase JDBC Driver
service interserver
{
flags = REUSE
socket_type = stream
wait = no
user = root
log_on_success += USERID
log_on_failure += USERID
server = /usr/interclient/bin/interserver
}
If anyone can help I would much appreciate it!
Regards Ian Newby