Results 1 to 9 of 9
  1. #1
    Join Date
    Dec 2002
    Posts
    5

    Unanswered: Problems running sybase ASE under linux

    Hi everyone,
    I've got problems installing the sybase ASE server on my linux.When the server try to start my db,it fails.I really don't know why.I already try to change the tcp port number(i'm sure it's unassigned) and it still doesn't work.My interfaces file seems ok, and it create the config file by himself.

    Here's my log file (the name of the db is tmp_db).


    Using config area from primary master device.
    Configuration Error: Configuration file, '/opt/sybase-11.9.2/tmp_db.cfg', does not exist.
    Warning: A configuration file was not specified and the default file '/opt/sybase-11.9.2/tmp_db.cfg' does not exist. SQL Server creates the default file with the default configuration.
    Using 1024 file descriptors.
    Adaptive Server Enterprise/11.9.2.3/1159/P/SWR 9223 ESD 3/Linux Intel/Linux 2.2.5-15 i586/OPT/Tue Sep 5 06:37:26 2000
    Confidential property of Sybase, Inc.
    Copyright 1987, 2000
    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
    Using '/opt/sybase-11.9.2/tmp_db.cfg' for configuration information.
    Logging SQL Server messages in file '/opt/sybase-11.9.2/install/tmp_db.log'.
    kdcl_init: connectivity library supports master/query syntax
    Directory Control Layer (DCL) using directory driver: InterfacesDriver
    Network and device connection limit is 1014.
    Number of proc buffers allocated: 1229.
    Proc header memory allocated 614 pages for each per engine cache
    Number of blocks left for proc headers: 1277.
    Memory allocated for the default data cache cache: 9242 Kb
    Size of the 2K memory pool: 9242 Kb
    Initializing virtual device 0, '/opt/sybase-11.9.2/tmp_db.dat'
    Virtual device 0 started using standard unix i/o.
    Worker Thread Manager is not enabled for use in SQL Server.
    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.
    engine 0, os pid 3114 online
    No active traceflags
    Opening Master Database ...
    Loading SQL Server's default sort order and character set
    network name H_base, type ether, port 4100
    ninit: bind, (null)
    ninit: All master network listeners have failed.
    Shutting down. <-- HERE
    ueshutdown: exiting

    Should i bind something (my ip address) ?

    And here's the interface file.

    tmp_db
    master tcp ether H_base 4100
    query tcp ether H_base 4100


    As you probably understood ,i'm a new sybase software user.
    Any help on getting past this would be much appreciated.

    Thanx.
    Nicolas

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    I assume 'H_base' is DNS-ed somewhere? Try putting the IP of the box in there. Also please paste the contents of /etc/hosts
    Thanks,

    Matt

  3. #3
    Join Date
    Dec 2002
    Posts
    5
    Thanx for your answer ,i change my host file,recreate my db and now it seems to work just fine.

    But i've got another question, as i already told you i'm a complete newbie in database management and i just want to connect to the sybase server,create tables,make some query (using sql)... on the same computer that runs the ASE server.Which program should i use ??

    I try to run isql but i've got this error message


    CT-LIBRARY error:
    ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.

    Should i use embedded sql or another program to use my db correctly ? Is isql the appropriate software ?

    Thanx again

    Nicolas.

  4. #4
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    How are you running isql? What is the contents of your new interfaces file?
    Thanks,

    Matt

  5. #5
    Join Date
    Dec 2002
    Posts
    5
    I just checked on the internet and found how to fix the problem.

    the command i use is isql -U sa -S localhost -P (...)
    With the localhost nameserver i wouldn't be able to access the db from outside but i don't have any other computers and therefore shouldn't be a problem.

    Are there any gui interface to access the server on the same computer ?

    Thanx
    Nicolas

  6. #6
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159
    Originally posted by nicolas12
    the command i use is isql -U sa -S localhost -P (...)
    With the localhost nameserver i wouldn't be able to access the db from outside but i don't have any other computers and therefore shouldn't be a problem.

    Nicolas
    The interfaces file maps a database server (software) on to an IP address and a port number (hardware). It is possible - indeed fairly common - to have multiple Sybase database servers running on a single host. It identify the different servers, each server is given a different name and it's this name you specify as the -S parameter.

    Consider the following example: Your host is called gandalf and has a Sybase database server called CUSTOMER.

    The interfaces file might contain the following...

    CUSTOMER
    master tcp ether gandalf 4100
    query tcp ether gandalf 4100

    To connect to this database server using isql you would type the following

    isql -Usa -SCUSTOMER

    if for example you had a second Sybase database (PRODUCT) server on gandalf it might have an entry in the interfaces file as follows...

    PRODUCT
    master tcp ether gandalf 5100
    query tcp ether gandalf 5100

    These two database servers could run along side each other and never know each other exists, even though they are on the same host, gandalf.

    The hostname gandalf would need to be resolved into an IP address somewhere (hosts, dns). Alternatively you can directly enter the IP address into the interfaces file.

  7. #7
    Join Date
    Dec 2002
    Posts
    5
    Thanx for all your help and explanation guys, now my ASE server work just fine and i can connect to it using isql.cool

    Are there a any graphical user interface (client) that i should use to connect to my sybase server which is on the same computer(linux) ?

  8. #8
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159
    Sybase Central Java edition (comes with ASE 12.0 and 12.5) works, but I tend to use isql and vi. If there's no X terminal that's pretty much all you're going to have and yes I have been in that situation.

    PC wise there is SQL Advantage - comes on PC Client disks, DB Artisian, Rapid SQL and SQL Programmer.

    There is something called "Like Sybase Central" by Ginola Pascal. It can be found here...

    http://perso.wanadoo.fr/laserquest/linux/

    I must admin I have been toying with writing something for Linux, but I just don't seem to get around to it.

    Richard.

  9. #9
    Join Date
    Dec 2002
    Posts
    5
    Thanx for your advices and explanations richard , i appreciate.

Posting Permissions

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