Sybase ASE 15 on gentoo

Message

f_eriksen · Post by **f_eriksen** » Mon May 22, 2006 9:02 pm

Ok, my first post and question here, so be gentle

I've searched the net, the forums, usenet, the works, trying to find some info on how to get this database up and running, to no avail.

I did find a lot on version 12.5.x, which it appears would be possible to get up and running. but not v 15 (which is the latest).

I would really, really like to make sybase work on gentoo, I'd hate to have to install a 2nd distro just for this...

I am running a fairly recent kernel and system is pretty much up to date.

Code: Select all

zeus f_eriksen # uname -r
2.6.15-gentoo-r1

now the installer, textbased or gui, run just fine, but when it wants to build the devices, it fails (segmentation faults). if i try using srvbuild etc, the same thing. i suspect it has something to do with my glibc, based on some other posts i found related to 12.5.x, in particular the nptl use flag, but am not sure though.

Did anyone get sybase ASE 15 (dev or express) to install?

thanks for any help/input on this matter,

FGE

Kurt Steiner · Post by **Kurt Steiner** » Mon May 22, 2006 9:40 pm

Did you search the documentation on http://www.sybase.com/linuxpromo?

m_spidey · Post by **m_spidey** » Tue May 01, 2007 4:34 am

I have exactly the same issue. At the end of the install, when the dataserver is getting fired up the first time, It gets to a point and it just seg faults...T.T

I thought it might have been a library issue. I've emerged lib-compat didn't help.

Did anyone get past this issue?

Code: Select all

dataserver: master device size for this server: 30.0 Mb
dataserver: master database size for this server: 13.0 Mb
dataserver: model database size for this server: 3.0 Mb
00:00000:00000:2007/05/02 00:18:29.60 kernel  Warning: Environment variable SYBASE_ASE is not set.
00:00000:00000:2007/05/02 00:18:29.60 kernel  SySAM: Using licenses from: /opt/sybase//SYSAM-2_0/licenses
00:00000:00000:2007/05/02 00:18:40.15 kernel  SySAM: Checked out license for 1 ASE_CORE (2007.1231/permanent/0B6B F920 021D C9DF).
00:00000:00000:2007/05/02 00:18:40.15 kernel  This product is licensed to: ASE Express Edition Free Deployment License
00:00000:00000:2007/05/02 00:18:40.15 kernel  Checked out license ASE_CORE
00:00000:00000:2007/05/02 00:18:40.15 kernel  Adaptive Server Enterprise Express Edition. (Limits: 1 Engine, 2GB Memory, 5GB Disk space).
00:00000:00000:2007/05/02 00:18:40.16 kernel  Initializing device /opt/sybase/data/master.dat from offset 0 with zeros.
00:00000:00000:2007/05/02 00:18:40.21 kernel  Finished initialization.
00:00000:00000:2007/05/02 00:18:40.22 kernel  Using config area from primary master device.
00:00000:00000:2007/05/02 00:18:40.22 kernel  Warning: Using default file '/opt/sybase//IMAGE.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2007/05/02 00:18:40.22 kernel  os_create_keyfile: Removed old segment /opt/sybase//IMAGE.krg
00:00000:00000:2007/05/02 00:18:40.22 kernel  Internal run-time model set for Linux  - Native
00:00000:00000:2007/05/02 00:18:40.23 kernel  Using 1024 file descriptors.
00:00000:00000:2007/05/02 00:18:40.23 kernel  Adaptive Server Enterprise/15.0/EBF 13194 EC ESD/P/Linux Intel/Linux 2.4.21-20.ELsmp i686/ase150/2179/32-bit/FBO/Mon Feb  6 04:14:19 2006
00:00000:00000:2007/05/02 00:18:40.23 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2007/05/02 00:18:40.23 kernel  Copyright 1987, 2006
00:00000:00000:2007/05/02 00:18:40.23 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2007/05/02 00:18:40.23 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2007/05/02 00:18:40.23 kernel  
00:00000:00000:2007/05/02 00:18:40.23 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2007/05/02 00:18:40.23 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2007/05/02 00:18:40.23 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2007/05/02 00:18:40.23 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2007/05/02 00:18:40.23 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2007/05/02 00:18:40.23 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2007/05/02 00:18:40.23 kernel  Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2007/05/02 00:18:40.23 kernel  ASE booted on Linux release 2.6.18-gentoo-r6 version #15 Fri Feb 9 09:24:10 EST 2007. 
00:00000:00000:2007/05/02 00:18:40.23 kernel  Using '/opt/sybase//IMAGE.cfg' for configuration information.
00:00000:00000:2007/05/02 00:18:40.23 kernel  Logging ASE messages in file '/opt/sybase/ASE-15_0/install/IMAGE.log'.
00:00000:00000:2007/05/02 00:18:40.24 kernel  Platform TCP network is forced to IPv4-only.
00:00000:00000:2007/05/02 00:18:40.24 kernel  ASE booted with TCP_NODELAY enabled.
00:00000:00000:2007/05/02 00:18:40.25 kernel  SSL Plus v5.0.4 security modules loaded successfully.
00:00000:00000:2007/05/02 00:18:40.25 kernel  Network and device connection limit is 1014.
00:00000:00000:2007/05/02 00:18:40.46 server  Number of blocks left for proc headers: 6960.
00:00000:00000:2007/05/02 00:18:40.47 server  Proc header memory allocated 1392 pages for each per engine cache
00:00000:00000:2007/05/02 00:18:40.52 server  Size of the 2K memory pool: 8192 Kb
00:00000:00000:2007/05/02 00:18:40.52 server  Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2007/05/02 00:18:40.53 kernel  Enabling Linux Kernel asynchronous disk I/O strategy.
00:00000:00000:2007/05/02 00:18:40.53 kernel  Extended cache size '0' is invalid. Provide the appropriate size value.
00:00000:00000:2007/05/02 00:18:40.53 kernel  Initializing virtual device 0, '/opt/sybase/data/master.dat' with dsync 'off'.
00:00000:00000:2007/05/02 00:18:40.53 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2007/05/02 00:18:40.53 server  Loaded default Unilib conversion handle.
00:00000:00000:2007/05/02 00:18:40.54 kernel  Worker Thread Manager is not enabled for use in ASE.
00:00000:00000:2007/05/02 00:18:40.55 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support 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:2007/05/02 00:18:40.55 kernel  Unix interval timer enabled for sysclk interrupts.
00:00000:00000:2007/05/02 00:18:40.55 kernel  Unable to load LDAP dynamic libraries without SYBASE and SYBASE_OCS environment variables defined. SYBASE_OCS is NULL.
00:00000:00000:2007/05/02 00:18:40.55 kernel  engine 0, os pid 9787  online
Segmentation fault

m_spidey · Post by **m_spidey** » Tue May 01, 2007 4:42 am

Did you search the documentation on http://www.sybase.com/linuxpromo?

In typical Sybase fashion they'll spew the same old line about x, y and z are supported. Don't waste your time there.

lancerus · Post by **lancerus** » Mon May 14, 2007 11:46 am

Its a glibc compatibility problem. ASE15 isnt supported on anything past glibc-2.3.x. I've also been trying to get this to work (err - install). I've tried gentoo (my 2006.1 and 2007.0 builds), ubuntu-7, opensuse-10.2, and nada for all. I still had lying around a VM of ubuntu-6.04, and it installs and works perfectly there. I then went to my 2005.1 build of gentoo (a server that is stuck back in time), and it also installs fine there.

There have been some workarounds posted, something about setting:

export LD_POINTER_GUARD = 0

(and its also been posted that the value might need to be a 1 instead of 0).

I get further with my installation on gentoo 2006.1 using the above var set to 0, but I still cannot complete an installation using the sybase installer. Like for example if I take the command shown that failed, run it by hand in another window with the above var sets, it'll run to completion without lblowing up. So its as if the sybase installer is wiping the env clean during parts of what its doing. There have been reports that running the install via the command window instead of the gui will work, but nothing said on how to kick off the installer that way. Looking at the sybase docs I found this:

setup -is:javaconsole -console

However I still get the same problem as if I'm running within the gui. Parts of the install get further if I set the LD_POINTER_GUARD var, but I still cannot complete it.

So - what are the choices here - I guess -
-) wait for sybase to create a glibc-2.4 based version of ASE
-) go backwards by doing emerge glibc-2.3.x (or can we do this in a chroot jail maybe?)
-) run on an older version of (your choice of distro) linux

Another idea might be doing the install on one machine, and just copying the whole darn thing over to a newer box to run it (with the env var above set of course). I'll try that one later this week.

m_spidey · Post by **m_spidey** » Mon May 14, 2007 1:11 pm

Thanks for that. I got it all the way to the part of install where it fires up....then it just decides to keel over...

=D

lancerus · Post by **lancerus** » Mon May 14, 2007 2:38 pm

[quote="m_spidey"]Thanks for that. I got it all the way to the part of install where it fires up....then it just decides to keel over...

=D[/quote]

Hey no prob. Another idea I had was to do the install, but do *not* let it do any of the server configurations during the install. Then after the gui installer is finished, set the LD_POINTER_GUARD and run srvbuild by hand. If I have to go off and build glibc-2.3.x for a chroot jail, I will, but only as a last resort. I figure if we wait for sybase it'll be 2008 at least. My motivation is I have a MS based web/database infrastructure (holding almost a terrabyte of data) that I want to get off of MS, at least for the operating system and web server part. While realistically I dont see my goals happening anytime soon - I at least want to have alternatives that we can develop/test against. Why sybase (instead of say postgres or mysql) - well the db has alot of stored procedures and currently interacts with many instances of sqlanywhere - so I dont want to redo *everything* if I can avoid it.

lancerus · Post by **lancerus** » Tue May 15, 2007 11:52 am

So the culprit is the sybase installer. On my Gentoo 2007.0 build - I did an install but did *not* build any of the servers. After I was done, I loaded SYBASE.env, set LD_POINTER_GUARD=0, then ran srvbuild. I was able to successfully build Adaptive server, Backup server, Monitor server, and XP server and get them all running. Woohoo!

tranquilcool · Post by **tranquilcool** » Thu May 17, 2007 9:14 am

could you please write a step by step howto?

thanks.

cderivan · Post by **cderivan** » Thu Aug 14, 2008 2:36 pm

tranquilcool, I managed to install ASE 15.0.2 on my gentoo 2008.0 box, using the chroot option.

- emerge app-misc/jail
- create a chrooted enviroment under the directory /var/chroot.
- go to chroot envitorment ( # chroot /var/chroot /bin/bash )
- unpak stage 3 tarball from release 2006.0 under /var/chroot directory.
- unpak portage tarball from release 2006.0 under /var/chroot directory.
- change make.conf:

CFLAGS="-O2 -march=i686 -pipe"
CHOST="i686-pc-linux-gnu"
CXXFLAGS="-O2 -march=i686 -pipe"

- emerged sys-libs/glibc with follow USE flags

[ebuild R ] sys-libs/glibc-2.3.5-r2 -build -erandom +glibc-compat20 -glibc-omitfp -hardened +linuxthreads-tls (-multilib) +nls +nptl +nptlonly +pic -profile (-selinux) +userlocales 0 kB

- emerged dev-libs/libaio-0.3.106
- emerged sys-libs/lib-compat

now just install ASE on this chroot enviroment.

cheers,
Clebson Derivan