Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Mexico
    Posts
    1

    Unanswered: Installing Informix IDS 7.31-UD1 under Linux Red Hat 7.3

    Hi to all.
    I need help with this problem...

    I need help to access a database server from other server. Both servers have Linux Red Hat 7.3, ncurses for library compatibility and the IDS 7.31 RPM. The Database can be accessed by local console, but not from other server.

    I think that all the configuration is ready, but when I want to connect from other machine, the dbaccess crash and send the next message later of 20 seconds:

    908: Attemp to connect to database server (albatros) failed.
    ISAM error: record is locked

    This is the configuration...

    Enviroment variables on the dolphin server

    PWD=/opt/informix/etc
    HOSTNAME=dolphin.cycsa.com.mx
    LD_LIBRARY_PATH=/opt/informix/lib/tools
    QTDIR=/usr/lib/qt3-gcc2.96
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    USER=informix
    LS_COLORS=no=00:fi=00:di=01;34:ln=01;36i=40;33:so=01;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32: *.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*. sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj =01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01; 31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.t z=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif =01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=0 1;35:*.tif=01;35:
    MAIL=/var/spool/mail/root
    INPUTRC=/etc/inputrc
    BASH_ENV=/root/.bashrc
    LANG=en_US.iso885915
    INFORMIXDIR=/opt/informix
    SSH_CLIENT=10.174.65.230 4440 22
    INFORMIXSERVER=dolphin
    LOGNAME=informix
    SHLVL=2
    ONCONFIG=onconfig
    SHELL=/bin/bash
    USERNAME=root
    HISTSIZE=1000
    HOME=/home/informix
    TERM=xterm
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/opt/informix/bin:/root/bin
    SSH_TTY=/dev/pts/1
    DBDATE=DMY4
    _=/usr/bin/env


    Enviroment variables on the albatros server

    PWD=/opt/informix/etc
    HOSTNAME=albatros.cycsa.com.mx
    LD_LIBRARY_PATH=/opt/informix/lib/tools
    QTDIR=/usr/lib/qt3-gcc2.96
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    USER=informix
    LS_COLORS=no=00:fi=00:di=01;34:ln=01;36i=40;33:so=01;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32: *.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*. sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj =01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01; 31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.t z=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif =01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=0 1;35:*.tif=01;35:
    MAIL=/var/spool/mail/root
    INPUTRC=/etc/inputrc
    BASH_ENV=/root/.bashrc
    LANG=en_US.iso885915
    INFORMIXDIR=/opt/informix
    SSH_CLIENT=10.174.65.230 4469 22
    INFORMIXSERVER=albatros
    LOGNAME=informix
    SHLVL=2
    ONCONFIG=onconfig
    SHELL=/bin/bash
    USERNAME=root
    HISTSIZE=1000
    HOME=/opt/informix
    TERM=xterm
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/opt/informix/bin:/root/bin
    SSH_TTY=/dev/pts/0
    DBDATE=DMY4
    _=/usr/bin/env


    The sqlhost file on the dolphin server

    demo_on onipcshm on_hostname on_servername
    demo_se seipcpip se_hostname sqlexec
    dolphin onipcshm dolphin dolphintcp
    shmdolphin onsoctcp dolphin sqlexec
    dolphin ontlitcp dolphin dolphintcp
    albatros ontlitcp albatros dolphintcp
    seawolf ontlitcp seawolf dolphintcp
    blackhawk ontlitcp blackhawk dolphintcp


    The sqlhost file on the albatros server

    demo_on onipcshm on_hostname on_servername
    demo_se seipcpip se_hostname sqlexec
    albatros onipcshm albatros albatrostcp
    shmalbatros onsoctcp albatros sqlexec
    dolphin ontlitcp dolphin albatrostcp
    albatros ontlitcp albatros albatrostcp
    seawolf ontlitcp seawolf albatrostcp
    blackhawk ontlitcp blackhawk albatrostcp


    The file onconfig on dophin server

    # System Configuration

    SERVERNUM 9 # Unique id corresponding to a Dynamic Server instance
    DBSERVERNAME dolphin # Name of default database server
    DBSERVERALIASES # List of alternate dbservernames
    NETTYPE ipcshm,1,20,CPU # Configure poll thread(s) for nettype
    NETTYPE soctcp,1,20,NET # Configure poll thread(s) for nettype
    NETTYPE tlitcp,1,20,NET # Configure poll thread(s) for nettype


    The file onconfig on albatros server

    # System Configuration

    SERVERNUM 9 # Unique id corresponding to a Dynamic Server instance
    DBSERVERNAME albatros # Name of default database server
    DBSERVERALIASES # List of alternate dbservernames
    NETTYPE ipcshm,1,20,CPU # Configure poll thread(s) for nettype
    NETTYPE soctcp,1,20,NET # Configure poll thread(s) for nettype
    NETTYPE tlitcp,1,20,NET # Configure poll thread(s) for nettype


    The file services on albatros server

    sqlexec 1524/tcp
    albatrostcp 1523/tcp

    The file services on dolphin server

    sqlexec 1524/tcp
    dolphintcp 1523/tcp


    Anyone can help me?
    Regards

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Installing Informix IDS 7.31-UD1 under Linux Red Hat 7.3

    Originally posted by fyu
    Hi to all.
    I need help with this problem...

    I need help to access a database server from other server. Both servers have Linux Red Hat 7.3, ncurses for library compatibility and the IDS 7.31 RPM. The Database can be accessed by local console, but not from other server.

    I think that all the configuration is ready, but when I want to connect from other machine, the dbaccess crash and send the next message later of 20 seconds:

    908: Attemp to connect to database server (albatros) failed.
    ISAM error: record is locked

    This is the configuration...

    Enviroment variables on the dolphin server

    PWD=/opt/informix/etc
    HOSTNAME=dolphin.cycsa.com.mx
    LD_LIBRARY_PATH=/opt/informix/lib/tools
    QTDIR=/usr/lib/qt3-gcc2.96
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    USER=informix
    LS_COLORS=no=00:fi=00:di=01;34:ln=01;36i=40;33:so=01;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32: *.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*. sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj =01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01; 31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.t z=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif =01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=0 1;35:*.tif=01;35:
    MAIL=/var/spool/mail/root
    INPUTRC=/etc/inputrc
    BASH_ENV=/root/.bashrc
    LANG=en_US.iso885915
    INFORMIXDIR=/opt/informix
    SSH_CLIENT=10.174.65.230 4440 22
    INFORMIXSERVER=dolphin
    LOGNAME=informix
    SHLVL=2
    ONCONFIG=onconfig
    SHELL=/bin/bash
    USERNAME=root
    HISTSIZE=1000
    HOME=/home/informix
    TERM=xterm
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/opt/informix/bin:/root/bin
    SSH_TTY=/dev/pts/1
    DBDATE=DMY4
    _=/usr/bin/env


    Enviroment variables on the albatros server

    PWD=/opt/informix/etc
    HOSTNAME=albatros.cycsa.com.mx
    LD_LIBRARY_PATH=/opt/informix/lib/tools
    QTDIR=/usr/lib/qt3-gcc2.96
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    USER=informix
    LS_COLORS=no=00:fi=00:di=01;34:ln=01;36i=40;33:so=01;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32: *.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*. sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj =01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01; 31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.t z=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif =01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=0 1;35:*.tif=01;35:
    MAIL=/var/spool/mail/root
    INPUTRC=/etc/inputrc
    BASH_ENV=/root/.bashrc
    LANG=en_US.iso885915
    INFORMIXDIR=/opt/informix
    SSH_CLIENT=10.174.65.230 4469 22
    INFORMIXSERVER=albatros
    LOGNAME=informix
    SHLVL=2
    ONCONFIG=onconfig
    SHELL=/bin/bash
    USERNAME=root
    HISTSIZE=1000
    HOME=/opt/informix
    TERM=xterm
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/opt/informix/bin:/root/bin
    SSH_TTY=/dev/pts/0
    DBDATE=DMY4
    _=/usr/bin/env


    The sqlhost file on the dolphin server

    demo_on onipcshm on_hostname on_servername
    demo_se seipcpip se_hostname sqlexec
    dolphin onipcshm dolphin dolphintcp
    shmdolphin onsoctcp dolphin sqlexec
    dolphin ontlitcp dolphin dolphintcp
    albatros ontlitcp albatros dolphintcp
    seawolf ontlitcp seawolf dolphintcp
    blackhawk ontlitcp blackhawk dolphintcp


    The sqlhost file on the albatros server

    demo_on onipcshm on_hostname on_servername
    demo_se seipcpip se_hostname sqlexec
    albatros onipcshm albatros albatrostcp
    shmalbatros onsoctcp albatros sqlexec
    dolphin ontlitcp dolphin albatrostcp
    albatros ontlitcp albatros albatrostcp
    seawolf ontlitcp seawolf albatrostcp
    blackhawk ontlitcp blackhawk albatrostcp


    The file onconfig on dophin server

    # System Configuration

    SERVERNUM 9 # Unique id corresponding to a Dynamic Server instance
    DBSERVERNAME dolphin # Name of default database server
    DBSERVERALIASES # List of alternate dbservernames
    NETTYPE ipcshm,1,20,CPU # Configure poll thread(s) for nettype
    NETTYPE soctcp,1,20,NET # Configure poll thread(s) for nettype
    NETTYPE tlitcp,1,20,NET # Configure poll thread(s) for nettype


    The file onconfig on albatros server

    # System Configuration

    SERVERNUM 9 # Unique id corresponding to a Dynamic Server instance
    DBSERVERNAME albatros # Name of default database server
    DBSERVERALIASES # List of alternate dbservernames
    NETTYPE ipcshm,1,20,CPU # Configure poll thread(s) for nettype
    NETTYPE soctcp,1,20,NET # Configure poll thread(s) for nettype
    NETTYPE tlitcp,1,20,NET # Configure poll thread(s) for nettype


    The file services on albatros server

    sqlexec 1524/tcp
    albatrostcp 1523/tcp

    The file services on dolphin server

    sqlexec 1524/tcp
    dolphintcp 1523/tcp


    Anyone can help me?
    Regards
    HI,

    I think that you would to review sqlhosts file, since the name of the
    service must be unique for all the instances.
    The parameter DBSERVERALIAS must be defined. By this the connection is made.
    Por example "albatros ontlitcp albatros albatrostcp"
    DBSERVERALIAS=albatros and the service file, albatrostcp nnnn/tcp
    And both servers must see themselves.
    For example: Server1 rsh "server2 ls -l", if this run ok, then continue.

    Gustavo.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •