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