Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 23 Apr 1999 21:45:29 +0300 (EEST)
From:      "Vladimir N.Silyaev" <vns@delta.odessa.ua>
To:        dpoland@execpc.com
Cc:        c@storage.delta.odessa.ua, freebsd-database@FreeBSD.ORG
Message-ID:  <199904231845.VAA81368@storage.delta.odessa.ua>

next in thread | raw e-mail | index | archive | help
Hi!

> > Add the next line in the your kernel configuration file:
> > --------
> > options         "SHMMAX=(SHMMAXPGS*PAGE_SIZE+1)"
> > options         SHMMAXPGS=4097
> > -------
> > After that you are must recompile and install the kernel.
> >
> I've done the SHMMAXPGS=4097, but not the SHMMAX line.  Is the
> SHMMAX line to be entered exactly as you have it (quotes and all)?
Yes, of course. The syntax of this options you are may check in your
LINT file. For example via typing
grep SHMMAX /sys/i386/conf/LINT

> Is PAGE_SIZE an option defined somewhere else in the kernel?
Yes, it's defined in /sys/i386/include/param.h.

> > P.S. Linux kernel and Sybase SQL have some bug in handling/use
> > fcntl/F_SETOWN  and ioctl/FIOSETOWN syscalls. And for install
> > stage you must poll the database engine with SIGIO signals, and
> > after install execute database engine from shells, whose create
> > new process group for launching program, for example the tcsh do it.
> >
> You lost me here.  Perhaps this is why the sybinit program returned
> an internal error message when trying to boot the server.  Interestingly,
> the dataserver daemon is running and consuming 4069KB of memory.
> Unfortunately, I can't seem to get at the database with isql.
>
Please follow the next instruction.
1. Create file sybaseio.sh
-----------------------
#!/bin/sh
pid=`ps -ax|awk  '/dataserver/&&!/awk/{print $1;exit;}'`
echo dataserver pid is $pid
while true; do
 kill -IO $pid || break
done
----------------------
2. At the stage of the installing Sybase SQL, when sybinit say:

Running task: update the SQL Server runserver file.
Task succeeded: update the SQL Server runserver file.
Running task: boot the SQL Server.
waiting for server 'SYBASE' to boot...

launch the sybaseio.sh script, the sybinit must print:

Task succeeded: boot the SQL Server.
Running task: create the sybsystemprocs database.

3. When sybinit finished run isql -U sa,  
enter password [empty], and after isql prompt:
sp_help
go

4. Shutdown dataserver:  kill <dataserver pid>.

5. Create sybase.pl script
---------
#!/usr/bin/perl5
use POSIX;

setsid();
exec $ARGV[0]
---------

6. Open in the editor file ${SYBASE}/install/RUN_SYBASE and
add the 'exec' word at the begin line where dataserver started,
for example:
...
#  interfaces:                    /opt/sybase
#
exec /opt/sybase/bin/dataserver \
...

7. Launch  sybase.pl install/RUN_SYBASE and repeat step 3.
   
> If you don't mind, I have copies of install/errorlog and
> init/logs/logxxxx.001.
> Would those be of assistance?
May be. In the file install/errorlog you may look line with text as:
  kernel  ninit: set process group 426, No such process

This is a symptom of the problem, which are hacked with sybaseio.sh script.

With best regards, 
		V.Silyaev.


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-database" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?199904231845.VAA81368>