Interbase 6.01 on Red Hat 7.0 : Faild Connection
Brett Hansen
I'm currently trying to get interbase to work so we may use it as our back
end with Cold Fusion, and Tomcat (jakarta project). Both for our large web
servers.
I have checked many messages and have tried many things and I don't seem to
have Interbase running all the way, but I think it is close. I have
installed the RPM of Interbase 6.01. I have created a startup script just
like the one in the PDF manual. This is the output from my script.
-----------------------------------------
[root@cybertron /root]# /etc/rc.d/init.d/ibserver.sh start
check $INTERBASE/interbase.log file for errors
can not start server
------------------------------------------
Here is my startup file:
------------------------------------------
#!/bin/sh
#ibserver.sh script - Start/stop the InterBase daemon
# Set these environment variables if and only if they are not set.
: ${INTERBASE:=/usr/interbase}
: ${ISC_USER:=SYSDBA}
: ${ISC_PASSWORD:=homey}
# WARNING: in a real-world installation, you should not put the
# SYSDBA password in a publicly-readable file. To protect it:
# chmod 700 ibserver.sh; chown root ibserver.sh
export INTERBASE
export ISC_USER
export ISC_PASSWORD
ibserver_start() {
# This example assumes the InterBase server is
# being started as UNIX user 'interbase'.
echo $INTERBASE'/bin/ibmgr -start -forever' | su - interbase
}
ibserver_stop() {
# No need to su, since $ISC_USER and $ISC_PASSWORD validate us.
$INTERBASE/bin/ibmgr -stop
}
case $1 in
'start') ibserver_start ;;
'start_msg') echo 'InterBase Server starting...\c' ;;
'stop') ibserver_stop ;;
'stop_msg') echo 'InterBase Server stopping...\c' ;;
*) echo 'Usage: $0 { start | stop }' ; exit 1 ;;
esac
exit 0
--------------------------------------------
This is the interbase.log file:
-------------------------------------------
cybertron.greytechproductions.com (Server) Wed Dec 6 22:57:55 2000
SERVER/process_packet: connection rejected for interbase
cybertron.greytechproductions.com (Server) Wed Dec 6 22:57:55 2000
SERVER/process_packet: connection rejected for interbase
cybertron.greytechproductions.com (Server) Wed Dec 6 22:57:55 2000
SERVER/process_packet: connection rejected for interbase
----------------------------------------------
Funny thing is that I see some processes running:
-----------------------------------------------
501 930 0.0 1.0 2300 844 pts/0 S 23:21 0:00
/opt/interbase/bin/ibguard -f
501 931 0.1 2.6 10256 2064 ? S 23:21 0:00
/opt/interbase/bin/ibserver
501 932 0.0 2.6 10256 2064 ? S 23:21 0:00
/opt/interbase/bin/ibserver
501 935 0.0 2.6 10256 2064 ? S 23:21 0:00
/opt/interbase/bin/ibserver
501 936 0.0 2.6 10256 2064 ? S 23:21 0:00
/opt/interbase/bin/ibserver
501 937 0.0 2.6 10256 2064 ? S 23:21 0:00
/opt/interbase/bin/ibserver
------------------------------------------------
uid 501 is user interbase in passwd file:
-----------------------------------------
interbase:x:501:10:Interbase DB:/home/interbase:/bin/bash
------------------------------------------
I try to create a datbase with the isql command:
---------------------------------------------
[root@cybertron bin]# ./isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE 'test';
Statement failed, SQLCODE = -923
connection rejected by remote interface
SQL>
----------------------------------------------
I do have localhost defined in the /etc/hosts file, as well as
cybertron.greytechproductions.com which both point to 127.0.0.1
When I try to telnet to port 3050 it at least connects, so I think the
InterbaseSS is listening. (I have this in my /etc/services:
gds_db 3050/tcp # InterBase Database Remote Protocol)
Can anyone help me?
Thank you for any support!
--
Brett Hansen
br...@annis.com
The Annis Group
248-395-0000
iv...@regionet.cz
>
....
> Statement failed, SQLCODE = -923
>
> connection rejected by remote interface
> SQL>
> ----------------------------------------------
>
> I do have localhost defined in the /etc/hosts file, as well as
> cybertron.greytechproductions.com which both point to 127.0.0.1
>
> When I try to telnet to port 3050 it at least connects, so I think the
> InterbaseSS is listening. (I have this in my /etc/services:
> gds_db 3050/tcp # InterBase Database Remote Protocol)
>
> Can anyone help me?
Check the old problem: put "+" (plus sign alone) to /etc/gds_hosts.equiv
ip
--
E-mail: Ivo.P...@regionet.cz
WWW: http://ivop.regionet.cz
Mobile: +420 602 337776
Brett Hansen
like Open Source)
But please help me out. I'm a little confused. I have worked a while with
Linux and I have never seen the file 'gds_hosts.equiv'. Nor is there a man
page on any of my systems. What does this file do? And why does a '+' in
it help InterbaseSS?
Thank You,
Brett