Problem installing SQSH

Posted on 2011-10-31
Last Modified: 2012-05-12

To develope a shell script to run .sql file from shell script, I wanted to install FreeTDS and SQSH. FreeTDS and FreeTDS-Devel have been installed but SQSH giving problem.

I was trying ot install sqsh-12.5-2.1-1.i386.rpm on my RHEL 5 server, but it fails to install due to unresolvable dependencies, I tried to find package to install these lib files but unable to find, can you suggest some solution for installing SQSH without installing Sybase:

error: Failed dependencies: is needed by sqsh-12.5-2.1-1.i386 is needed by sqsh-12.5-2.1-1.i386 is needed by sqsh-12.5-2.1-1.i386 is needed by sqsh-12.5-2.1-1.i386 is needed by sqsh-12.5-2.1-1.i386 is needed by sqsh-12.5-2.1-1.i386

Please help here.
Question by:ashuji
    LVL 13

    Expert Comment

    You need these libraries to connect to Sybase server. They are part of Open Client. If you don't need a whole Sybase installation, you can just install Open Client. You should be able to download a trial version from Sybase web site and install it.

    Author Comment


    I could not find location to download Sybase Open Client, can you suggest a URL ?
    LVL 24

    Expert Comment

    by:Joe Woodhouse
    The Sybase clients are included as part of the ASE Developer's Edition. You can just install the client side if you want.

    Author Comment

    When trying to install SYBASE from ASE setup, it returnign error, please refer to the logs below:

     ./setup.bin -console
    Preparing to install...
    Extracting the JRE from the installer archive...
    Unpacking the JRE...
    Extracting the installation resources from the installer archive...
    Configuring the installer for this system's environment...

    Launching installer...

    Usage: setup [-f <path_to_installer_properties_file> | -options]
                (to execute the installer)

    where options include:
                show this help text
        -i [swing | console | silent]
                specify the user interface mode for the installer
                specify installer properties
        -r <path_to_generate_response_file>
                Generates response file.
    The options field may also include the following in case of uninstaller
    if it is enabled for Maintenance Mode
        -add <feature_name_1> [<feature_name_2 ...]
                Add Specified Features
        -remove <feature_name_1> [<feature_name_2 ...]
                Remove Specified Features
                Repair Installation

        1. the path to the installer properties file may be either absolute,
           or relative to the directory in which the installer resides.
        2. if an installer properties file is specified and exists, all other
           command line options will be ignored.
        3. if a properties file named either '' or
           <NameOfInstaller>.properties resides in the same directory as the
           installer, it will automatically be used, overriding all other command
           line options, unless the '-f' option is used to point to another valid
           properties file.
        4. if an installer properties file is specified but does not exist, the
           default properties file, if present, will be used.  Otherwise, any
           supplied command line options will be used, or if no additional
           options were specified, the installer will be run using the default
    LVL 24

    Expert Comment

    by:Joe Woodhouse
    Which version of ASE Dev Edition are you installing? I think Sybase is only letting us download ASE 15.7 in the Developer Edition, which may not even be compatible with sqsh for ASE 12.5 - there were many changes in the Sybase client from 12.5.x to 15.x.

    Also, try:

       setup.bin -i console


    Lastly, ensure you have all the RHEL patches Sybase requires... These are documented in the ASE 15.7 Installation Guide for Linux. These depend on your platform, but basically you what RHEL 5.0 update 5 or above, and in particular:

       kernel-2.6.18-53.1.13.el5 (or higher)
       glibc-2.5-18 (or higher)


    Author Comment


    Is it easy to do if I use PERL scripting ?
    LVL 24

    Expert Comment

    by:Joe Woodhouse
    You'll still need the Sybase client, plus the right version of Perl, plus the SybPerl libraries.

    Note you don't actually need Perl or sqsh if all you want to do is run a sql file from a shell script. But you'll still need the Sybase client for that.

    i.e. every possible solution requires the Sybase client. :)

    Author Comment

    Is there any way I could do it without using Sybase client, becaue its not FREE to use.  I may try using PHP scripting also.
    LVL 24

    Accepted Solution

    It totally is free to use! The Developer Edition is 100% free, and includes the client.

    You cannot talk to a Sybase dataserver without some form of Sybase client.

    Author Comment

    I did not find it free, is it possible if you could provide me with link to download free sybase client ?
    LVL 24

    Expert Comment

    by:Joe Woodhouse

    This is the full ASE but it will also include all the client-side stuff you need. You can choose not to install any server-side stuff during installation.

    Author Comment

    Thanks, I'll try and let you know.

    Author Closing Comment

    I doubt that Sybase client available for free, since I have stopped working on this project, may not be able to test it even.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
    It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now