From owner-freebsd-database Thu Jan 27 4:34:45 2000 Delivered-To: freebsd-database@freebsd.org Received: from jps-sun.cyberlab.de (jps-sun.cyberlab.de [193.26.97.184]) by hub.freebsd.org (Postfix) with ESMTP id 7762714F33 for ; Thu, 27 Jan 2000 04:34:38 -0800 (PST) (envelope-from jekat@jps-sun.cyberlab.de) Received: (from jekat@localhost) by jps-sun.cyberlab.de (8.9.2/8.9.2/cyberlab-2.0) id NAA10975; Thu, 27 Jan 2000 13:32:34 +0100 (MET) Date: Thu, 27 Jan 2000 13:32:34 +0100 From: Astrid Jekat To: freebsd-database@freebsd.org Cc: Astrid Jekat Subject: Sybase(Linux) under FreeBSD 3.4 Message-ID: <20000127133233.A9603@jps-sun.cyberlab.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.5i Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Hello there! I am presently trying to install Sybase 11.9.2 (RedHat rpms) on FreeBSD 3.4. I found some good advice in the archives of this ML (thank you, Doug Poland and Vladimir N.Silyaev ;-) => I've fixed the initial shared memory problem by recompiling the kernel with SHMMAX and SHMMAXPGS options: options "SHMMAX=(SHMMAXPGS*PAGE_SIZE+1)" options SHMMAXPGS=8192 That helped. Various mail here mention the sybinit command, but I do not see that in this version of Sybase - imho that only exists in the older version 11.0.3. (We have used both versions, under RedHat and Suse). I ran /opt/sybase-11.9.2/bin/srvbuild , which starts a GUI with instructions to build a server. Our Sybase guy here told me what to enter to make a simple database server and backup server (specify file names for master device etc.). The build gets pretty far, but fails in the end - the error log is attached, please forgive this long mail. The security problem mentioned in the logs below also can be found under RedHat, does not prevent Sybase from running under Linux. /opt is large enough and belongs to user sybase, group sybase. Did I miss something? We really want to get away from Linux here because of numerous problems - I need to show that Sybase will run on FreeBSD, too, then life will be easier :-) (And we would be happy to buy licenses). Cheers, -- Astrid Jekat System Administration Cyberlab Interactive Productions ******************************************** The consequences of Y2K: http://www.userfriendly.org/cartoons/archives/00jan/20000102.html ########################## ########################## /opt/sybase-11.9.2/install/tescht.log : 00:00000:00000:2000/01/27 12:30:21.15 kernel Using config area from primary master device. 00:00000:00000:2000/01/27 12:30:21.19 kernel Configuration Error: Configuration file, '/opt/sybase-11.9.2/tescht.cfg', does not ex ist. 00:00000:00000:2000/01/27 12:30:21.20 kernel Warning: A configuration file was not specified and the default file '/opt/sybase-11. 9.2/tescht.cfg' does not exist. SQL Server creates the default file with the default configuration. 00:00000:00000:2000/01/27 12:30:21.28 kernel Using 256 file descriptors. 00:00000:00000:2000/01/27 12:30:21.28 kernel Adaptive Server Enterprise/11.9.2/1075/P/Linux Intel/Linux 2.2.5 i586/OPT/Mon Jul 12 09:51:46 1999 00:00000:00000:2000/01/27 12:30:21.28 kernel Confidential property of Sybase, Inc. 00:00000:00000:2000/01/27 12:30:21.28 kernel Copyright 1987, 1999 00:00000:00000:2000/01/27 12:30:21.28 kernel Sybase, Inc. All rights reserved. 00:00000:00000:2000/01/27 12:30:21.28 kernel Unpublished rights reserved under U.S. copyright laws. 00:00000:00000:2000/01/27 12:30:21.28 kernel 00:00000:00000:2000/01/27 12:30:21.28 kernel This software contains confidential and trade secret information of Sybase, 00:00000:00000:2000/01/27 12:30:21.28 kernel Inc. Use, duplication or disclosure of the software and documentation by 00:00000:00000:2000/01/27 12:30:21.28 kernel the U.S. Government is subject to restrictions set forth in a license 00:00000:00000:2000/01/27 12:30:21.28 kernel agreement between the Government and Sybase, Inc. or other written 00:00000:00000:2000/01/27 12:30:21.28 kernel agreement specifying the Government's rights to use the software and any 00:00000:00000:2000/01/27 12:30:21.28 kernel applicable FAR provisions, for example, FAR 52.227-19. 00:00000:00000:2000/01/27 12:30:21.28 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA 00:00000:00000:2000/01/27 12:30:21.28 kernel Using '/opt/sybase-11.9.2/tescht.cfg' for configuration information. 00:00000:00000:2000/01/27 12:30:21.28 kernel Logging SQL Server messages in file '/opt/sybase-11.9.2/install/tescht.log'. 00:00000:00000:2000/01/27 12:30:21.48 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver 00:00000:00000:2000/01/27 12:30:21.48 kernel Network and device connection limit is 246. 00:00000:00000:2000/01/27 12:30:21.53 server Number of proc buffers allocated: 1087. 00:00000:00000:2000/01/27 12:30:21.64 server Proc header memory allocated 543 pages for each per engine cache 00:00000:00000:2000/01/27 12:30:21.64 server Number of blocks left for proc headers: 1134. 00:00000:00000:2000/01/27 12:30:21.64 server Memory allocated for the default data cache cache: 8162 Kb 00:00000:00000:2000/01/27 12:30:21.66 server Size of the 2K memory pool: 8162 Kb 00:00000:00000:2000/01/27 12:30:21.66 kernel Initializing virtual device 0, '/opt/sybase-11.9.2/tescht_master.dat' 00:00000:00000:2000/01/27 12:30:21.66 kernel Virtual device 0 started using standard unix i/o. 00:00000:00000:2000/01/27 12:30:21.66 kernel Worker Thread Manager is not enabled for use in SQL Server. 00:00000:00000:2000/01/27 12:30:21.66 kernel Either the config parameter 'use security services' is set to 0, or ASE does not supp ort use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported. 00:00000:00000:2000/01/27 12:30:21.66 kernel engine 0, os pid 765 online 00:00000:00000:2000/01/27 12:30:21.66 server No active traceflags 00:00000:00001:2000/01/27 12:30:21.79 server Opening Master Database ... 00:00000:00001:2000/01/27 12:30:21.90 server Loading SQL Server's default sort order and character set 00:00000:00002:2000/01/27 12:30:21.92 kernel network name mail, type ether, port 4100 00:00000:00002:2000/01/27 12:30:21.92 kernel ninit: bind, Cannot assign requested address 00:00000:00002:2000/01/27 12:30:21.92 kernel ninit: All master network listeners have failed. Shutting down. 00:00000:00002:2000/01/27 12:30:21.92 kernel ueshutdown: exiting ########################## ########################## /opt/sybase-11.9.2/install/tescht_back.log : Jan 27 12:42:15 2000: Backup Server/11.9.2/1068/P/Linux Intel/Linux 2.2.5 i586/OPT/Mon Jun 7 18:07:40 1999 Jan 27 12:42:15 2000: Confidential property of Sybase, Inc. Copyright 1987, 1999 Sybase, Inc. All rights reserved. Unpublished rights reserved under U.S. copyright laws. This software contains confidential and trade secret information of Sybase, Inc. Use, duplication or disclosure of the software and documentation by the U.S. Government is subject to restrictions set forth in a license agreement between the Government and Sybase, Inc. or other written agreement specifying the Government's rights to use the software and any applicable FAR provisions, for example, FAR 52.227-19. Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA Logging Backup Server messages in file '/opt/sybase-11.9.2/install/tescht_back.log' Jan 27 12:42:16 2000: Open Server Error: 16240.10.0: Net-Library routine net_listen() failed in srv__start_net Network error: status = 23 - Net-Lib protocol driver call to register a listener failed . Jan 27 12:42:16 2000: Open Server Server Fatal Error: 16029.20.0: Failed to start any network listeners ########################## ########################## /opt/sybase-11.9.2/init/logs/srvbuild0127.001-tescht.rs : srvbuild.release_directory: /opt/sybase-11.9.2 srvbuild.product: sqlsrv srvbuild.server_name: tescht srvbuild.new_config: yes srvbuild.do_add_server: yes srvbuild.do_upgrade: no srvbuild.network_protocol_list: tcp srvbuild.network_hostname_list: mail srvbuild.network_port_list: 4100 srvbuild.master_device_physical_name: /opt/sybase-11.9.2/tescht_master.dat srvbuild.master_device_size: 30 srvbuild.master_database_size: 5 srvbuild.errorlog: /opt/sybase-11.9.2/install/tescht.log srvbuild.sybsystemprocs_device_physical_name: /opt/sybase-11.9.2/tescht_sysprocs.dat srvbuild.sybsystemprocs_device_size: 60 srvbuild.sybsystemprocs_database_size: 60 srvbuild.sybsystemdb_device_physical_name: USE_DEFAULT srvbuild.sybsystemdb_device_size: 5 srvbuild.sybsystemdb_database_size: 5 srvbuild.default_backup_server: tescht_back ########################## ########################## To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Jan 27 6:30:53 2000 Delivered-To: freebsd-database@freebsd.org Received: from jps-sun.cyberlab.de (jps-sun.cyberlab.de [193.26.97.184]) by hub.freebsd.org (Postfix) with ESMTP id A3513155F7 for ; Thu, 27 Jan 2000 06:30:45 -0800 (PST) (envelope-from jekat@jps-sun.cyberlab.de) Received: (from jekat@localhost) by jps-sun.cyberlab.de (8.9.2/8.9.2/cyberlab-2.0) id PAA14186; Thu, 27 Jan 2000 15:28:21 +0100 (MET) Date: Thu, 27 Jan 2000 15:28:20 +0100 From: Astrid Jekat To: Alan Ruedlinger Cc: freebsd-database@FreeBSD.ORG, Astrid Jekat Subject: Re: Sybase(Linux) under FreeBSD 3.4 Message-ID: <20000127152820.B9603@jps-sun.cyberlab.de> References: <20000127133233.A9603@jps-sun.cyberlab.de> <389051B7.79ABD2AE@tig.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.5i In-Reply-To: <389051B7.79ABD2AE@tig.com.au>; from Alan Ruedlinger on Fri, Jan 28, 2000 at 01:09:59AM +1100 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Hello again! On Fri, Jan 28, 2000 at 01:09:59AM +1100, Alan Ruedlinger wrote: > If it's any consolation, I had this version of Sybase running under both FreeBSD3.2 and FreeBSD3.3 (see my notes at > http://crash.tig.com.au/~alanr/sybase.html). What you've done in terms of kernel changes and user/group creation sounds right. > > It's failing at the network listener stage which is odd, since I would have expected to fail a lot sooner if your initial config > files/setting were incorrect. Happily, the problem is fixed - the machine's hostname was not set correctly. *boo* After fixing it the database and backup server built properly, and I contacted the db with isql and have a prompt :-) To put it in a nutshell: I installed FreeBSD 3.4, recompiled the kernel with the shared mem options mentioned below (are not in the default kernel), got Sybase 11.9.2 (RedHat rpms), installed those with rpm --hiv --nodeps --ignoreos , made sure ownership and group were correct (sybase sybase), started srvbuild, voila. Very nice - now the Sybase guy has to play with it. put stuff in the db, and I will run some benchmarks on it. And contact it remotely... > > Astrid Jekat wrote: > > > Hello there! > > > > I am presently trying to install Sybase 11.9.2 (RedHat rpms) on FreeBSD 3.4. > > > > I ran /opt/sybase-11.9.2/bin/srvbuild , which starts a GUI with > > instructions to build a server. Our Sybase guy here told me what to enter > > to make a simple database server and backup server (specify file names > > for master device etc.). > > The build gets pretty far, but fails in the end - the error log is > > attached, please forgive this long mail. > -- Astrid Jekat System Administration Cyberlab Interactive Productions ******************************************** The consequences of Y2K: http://www.userfriendly.org/cartoons/archives/00jan/20000102.html To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Jan 28 7:34:39 2000 Delivered-To: freebsd-database@freebsd.org Received: from mailgw00.execpc.com (mailgw00.execpc.com [169.207.1.78]) by hub.freebsd.org (Postfix) with ESMTP id 1106214D6F for ; Fri, 28 Jan 2000 07:34:32 -0800 (PST) (envelope-from dpoland@execpc.com) Received: from judah (najiba-1-36.mdm.fox.execpc.com [169.207.126.36]) by mailgw00.execpc.com (8.9.1) id JAA08297 for ; Fri, 28 Jan 2000 09:34:20 -0600 From: "Doug Poland" To: Subject: RE: Sybase(Linux) under FreeBSD 3.4 Date: Fri, 28 Jan 2000 09:34:19 -0600 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <20000127152820.B9603@jps-sun.cyberlab.de> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Importance: Normal Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Astrid, Have you configured Sybase to start using the rc scripts, or some other mechanism, when the server boots? If so, could you let me know what you did. I haven't had time to play with it for a while and still need to solve that problem. Many TIA! -----Original Message----- From: owner-freebsd-database@FreeBSD.ORG [mailto:owner-freebsd-database@FreeBSD.ORG]On Behalf Of Astrid Jekat Sent: Thursday, January 27, 2000 08:28 To: Alan Ruedlinger Cc: freebsd-database@FreeBSD.ORG; Astrid Jekat Subject: Re: Sybase(Linux) under FreeBSD 3.4 Hello again! On Fri, Jan 28, 2000 at 01:09:59AM +1100, Alan Ruedlinger wrote: > If it's any consolation, I had this version of Sybase running under both FreeBSD3.2 and FreeBSD3.3 (see my notes at > http://crash.tig.com.au/~alanr/sybase.html). What you've done in terms of kernel changes and user/group creation sounds right. > > It's failing at the network listener stage which is odd, since I would have expected to fail a lot sooner if your initial config > files/setting were incorrect. Happily, the problem is fixed - the machine's hostname was not set correctly. *boo* After fixing it the database and backup server built properly, and I contacted the db with isql and have a prompt :-) To put it in a nutshell: I installed FreeBSD 3.4, recompiled the kernel with the shared mem options mentioned below (are not in the default kernel), got Sybase 11.9.2 (RedHat rpms), installed those with rpm --hiv --nodeps --ignoreos , made sure ownership and group were correct (sybase sybase), started srvbuild, voila. Very nice - now the Sybase guy has to play with it. put stuff in the db, and I will run some benchmarks on it. And contact it remotely... > > Astrid Jekat wrote: > > > Hello there! > > > > I am presently trying to install Sybase 11.9.2 (RedHat rpms) on FreeBSD 3.4. > > > > I ran /opt/sybase-11.9.2/bin/srvbuild , which starts a GUI with > > instructions to build a server. Our Sybase guy here told me what to enter > > to make a simple database server and backup server (specify file names > > for master device etc.). > > The build gets pretty far, but fails in the end - the error log is > > attached, please forgive this long mail. > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message