Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 898
  • Last Modified:

Problem installing SQSH

HI

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:
        libcomn.so is needed by sqsh-12.5-2.1-1.i386
        libcs.so is needed by sqsh-12.5-2.1-1.i386
        libct.so is needed by sqsh-12.5-2.1-1.i386
        libintl.so is needed by sqsh-12.5-2.1-1.i386
        libreadline.so.4.1 is needed by sqsh-12.5-2.1-1.i386
        libsybtcl.so is needed by sqsh-12.5-2.1-1.i386

Please help here.
0
ashuji
Asked:
ashuji
  • 7
  • 5
1 Solution
 
alpmoonCommented:
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.
0
 
ashujiAuthor Commented:
Thanks,

I could not find location to download Sybase Open Client, can you suggest a URL ?
0
 
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.
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
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
    -D<name>=<value>
            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
            Repair Installation
    -uninstall
            Uninstall

notes:
    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 'installer.properties' 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
       settings.
0
 
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

instead.

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)

0
 
ashujiAuthor Commented:
Hi

Is it easy to do if I use PERL scripting ?
0
 
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. :)
0
 
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.
0
 
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.
0
 
ashujiAuthor Commented:
I did not find it free, is it possible if you could provide me with link to download free sybase client ?
0
 
Joe WoodhousePrincipal ConsultantCommented:
http://www.sybase.com/ase_1500devel

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.
0
 
ashujiAuthor Commented:
Thanks, I'll try and let you know.
0
 
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.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now