Problem installing SQSH


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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
ashujiAuthor Commented:

I could not find location to download Sybase Open Client, can you suggest a URL ?
Joe WoodhousePrincipal ConsultantCommented:
The Sybase clients are included as part of the ASE Developer's Edition. You can just install the client side if you want.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

ashujiAuthor Commented:
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
Joe WoodhousePrincipal ConsultantCommented:
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)

ashujiAuthor Commented:

Is it easy to do if I use PERL scripting ?
Joe WoodhousePrincipal ConsultantCommented:
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. :)
ashujiAuthor Commented:
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.
Joe WoodhousePrincipal ConsultantCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ashujiAuthor Commented:
I did not find it free, is it possible if you could provide me with link to download free sybase client ?
Joe WoodhousePrincipal ConsultantCommented:

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.
ashujiAuthor Commented:
Thanks, I'll try and let you know.
ashujiAuthor Commented:
I doubt that Sybase client available for free, since I have stopped working on this project, may not be able to test it even.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.