Topic
4 replies Latest Post - ‏2010-09-07T14:33:25Z by shinosuka
shinosuka
shinosuka
5 Posts
ACCEPTED ANSWER

Pinned topic install of iSeriesAccess-5.4.0-1.6.x86_64.rpm not possible on Mandriva ?

‏2010-09-03T10:31:46Z |
Hello,

I try to install iSeries ODBC on Linux and installation can't finishing.

My Configuration :
  1. cat etc/issue
Mandriva Linux release 2009.0 (Official) for x86_64
Kernel 2.6.27-desktop-0.rc8.2mnb on a 4-processor x86_64 / \l

My Istall :
  1. rpm -ivh iSeriesAccess-5.4.0-1.6.Linux.x86_64.rpm
erreur: Dépendances requises:
libstdc++.so.5()(64bit) est nécessaire pour iSeriesAccess-5.4.0-1.6.x86_64
libstdc++.so.5(CXXABI_1.2)(64bit) est nécessaire pour iSeriesAccess-5.4.0-1.6.x86_64
libstdc++.so.5(GLIBCPP_3.2.2)(64bit) est nécessaire pour iSeriesAccess-5.4.0-1.6.x86_64
libstdc++.so.5(GLIBCPP_3.2)(64bit) est nécessaire pour iSeriesAccess-5.4.0-1.6.x86_64
  1. urpmi libstdc++5
ftp://ftp.proxad.net/pub/Distributions_Linux/MandrivaLinux/official/2009.0/x86_64/media/contrib/release/libstdc++5-3.3.6-4mdv2009.0.x86_64.rpm
installation de libstdc++5-3.3.6-4mdv2009.0.x86_64.rpm depuis /var/cache/urpmi/rpms
Préparation ... #############################################
1/1: libstdc++5 #############################################
  1. rpm -ivh iSeriesAccess-5.4.0-1.6.Linux.x86_64.rpm
Préparation... ########################################### 100%
1:iSeriesAccess ########################################### 100%
post install processing for iSeriesAccess 1.6...1
/var/tmp/rpm-tmp.52444: line 16: odbcinst: command not found
/var/tmp/rpm-tmp.52444: line 27: odbcinst: command not found

The directory "/opt/ibm/iSeriesAccess" isn't created.

Any one can help me ?
Thank's.
Updated on 2010-09-07T14:33:25Z at 2010-09-07T14:33:25Z by shinosuka
  • shinosuka
    shinosuka
    5 Posts
    ACCEPTED ANSWER

    Re: install of iSeriesAccess-5.4.0-1.6.x86_64.rpm not possible on Mandriva ?

    ‏2010-09-07T08:50:17Z  in response to shinosuka
    I try again to install but before, I have modify "/etc/odbcinst.ini" with :
    ODBC
    Trace = No
    TraceFile = /tmp/sql.log
    ForceTrace = No
    Pooling = No

    iSeries
    Description = iSeries Access for linux ODBC Driver
    Driver = /opt/ibm/iSeriesAccess/lib64/libcwbodbc.so
    Setup = /opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so
    Threading = 2
    FileUsage = 1
    DontDLClose = 1

    And I have reinstalled Driver iSeries and that function !!!

    But now, the problem is that connection doesn't function.
    The more astonishing that I read for testing connection, there is command "cwbping", and when I use it, that doesn't reconize :
    1. cwbping 192.x.x.x
    -bash: cwbping: command not found

    My configuration for "/etc/odbc.ini" is (but I'm dont sure what write for System) :
    db2
    description = Connector to db2
    System = xxxxxxx #
    User_id = # (optionnel)
    Password = mot de passe # (optionnel)
    Naming = 0
    DefaultLibraries = QGPL
    Database = nom de la base # (optionnel)
    ConnectionType = 0
    CommitMode = 2
    ExtendedPkgLibrary = QGPL
    DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512
    AllowDataCompression = 1
    MaxFieldLength = 32
    BlockFetch = 0
    BlockSizeKB = 1
    ExtendedColInfo = 0
    LibraryView = 0
    AllowUnsupportedChar = 0
    ForceTranslation = 0
    Trace = 0

    Thank's for any help and mine.
    • shinosuka
      shinosuka
      5 Posts
      ACCEPTED ANSWER

      Re: install of iSeriesAccess-5.4.0-1.6.x86_64.rpm not possible on Mandriva ?

      ‏2010-09-07T09:35:08Z  in response to shinosuka
      On this site I'm found a solution for the function "cwbping" that is not found :
      /opt/ibm/iSeriesAccess/bin64/cwbping 192.168.172.11

      And the connection function :
      I - Vérification de la connexion au système 192.168.172.11...
      I - Connexion établie avec l'application serveur : Client central
      I - Connexion établie avec l'application serveur : Fichier réseau
      I - Connexion établie avec l'application serveur : Impression réseau
      I - Connexion établie avec l'application serveur : Accès aux données
      I - Connexion établie avec l'application serveur : Files d'attente de données
      I - Connexion établie avec l'application serveur : Commande à  distance
      I - Connexion établie avec l'application serveur : Sécurité
      I - Connexion établie avec l'application serveur : DDM
      I - Connexion établie avec l'application serveur : Telnet
      I - Connexion au système 192.168.172.11 vérifiée

      The problem is my configuration of odbc (.ini) or php code that is :
      I'm cherching again, but I trace the solutions that I founding for other users.
  • shinosuka
    shinosuka
    5 Posts
    ACCEPTED ANSWER

    Re: install of iSeriesAccess-5.4.0-1.6.x86_64.rpm not possible on Mandriva ?

    ‏2010-09-07T13:31:37Z  in response to shinosuka
    Well, I find a solution to my connection with AS400. In Finally, every function with good parameters. I must change php to connect for finish my configuration (launch import of datas from AS400 to files csv on Linux's server).

    For persons who are interested by my solution, I find on internet (with multimix) that :
    Version 64bits for odbcinst.ini :
    ODBC
    Trace = No
    TraceFile = /tmp/sql.log
    ForceTrace = No
    Pooling = No

    iSeries
    Description = iSeries Access for linux ODBC Driver
    Driver = /opt/ibm/iSeriesAccess/lib/libcwbodbc.so
    Driver64 = /opt/ibm/iSeriesAccess/lib64/libcwbodbc.so
    Setup = /opt/ibm/iSeriesAccess/lib/libcwbodbcs.so
    Setup64 = /opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so
    Threading = 2
    FileUsage = 1
    DontDLClose = 1

    odbc.ini :
    db2
    Description = Connector to db2
    Driver = iSeries # named in odbcinst.ini, not sure
    System = 10.x.x.x #
    User_id = # (optionnel)
    Password = mot de passe # (optionnel)
    Naming = 0
    DefaultLibraries = QGPL
    Database = nom de la base # (optionnel)
    ConnectionType = 0
    CommitMode = 2
    ExtendedPkgLibrary = QGPL
    DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512
    AllowDataCompression = 1
    MaxFieldLength = 32
    BlockFetch = 0
    BlockSizeKB = 1
    ExtendedColInfo = 0
    LibraryView = 0
    AllowUnsupportedChar = 0
    ForceTranslation = 0
    Trace = 0

    test.sql :
    select * from NAMEHOST.USERS for read only

    Command for test connection :
    /opt/ibm/iSeriesAccess/bin64/cwbrunsql /DSN:db2 /SYSTEM:10.x.x.x /USER:username /PASSWORD:pwduser /I:/home/userA/test.sql

    Subject is close.
    • shinosuka
      shinosuka
      5 Posts
      ACCEPTED ANSWER

      Re: install of iSeriesAccess-5.4.0-1.6.x86_64.rpm not possible on Mandriva ?

      ‏2010-09-07T14:33:25Z  in response to shinosuka
      Little precision for PHP else that doesn't function, for me, use this code for connection :

      $bdd = "DSN=db2;SYSTEM=10.x.x.x;DBQ=XXXX"; // DBQ where I stock results of queries AS400
      $user = "username";
      $pwd = "pwduser";
      $con = odbc_connect ($bdd, $user, $pwd ) or die("Error Connection") ;