Results 1 to 3 of 3

Thread: Using Ribo

  1. #1
    Join Date
    Jan 2008
    Posts
    16

    Unanswered: Using Ribo

    Hi,

    Can any one tell me how to configure and use the Ribo.

    I have set the environment variables and have run the Ribo in command line and gui mode.

    But what i don't get is where are the files stored....

    Regards

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Its stored in capX.tds on the same folder. X being the number of times, you used ribo. You need to convert that into text readable format by running ribo capX.tds my.txt

    Here is a sample setup instruction. If you need the full document, PM me with your email id and I can send it to you.

    1. Create a BatchFile myribo.bat with following entries.

    set JAVA_HOME=C:\jdk1.1.8
    set RIBO_HOME=C:\Program Files\xxxxx\jutils-2_0\ribo
    Ribo.bat -gui -s REPLACE_with_hostname -p REPLACE_WITH_port -t X

    2. Create a SQL.ini entry
    Note, by default Ribo starts on 5005, if you are starting on some other port, have the appropriate port below.

    [MYRIBO]
    QUERY=NLWNSCK,localhost,5005
    WIN3_QUERY=WNLWNSCK,localhost,5005


    3. Start the batch file created in Step 1. and Click Start Capture.

    4. Start whatever program you want, but make sure to use MYRIBO. And run the SQL.

    In the GUI, you will see something like this.

    Listening on port 5005
    Accepting new connection from: localhost/127.0.0.1
    Sending captured traffic to: cap1.tds
    Closing dump file cap1.tds


    5. Now convert tds file to text format.

    set JAVA_HOME=C:\jdk1.1.8
    set RIBO_HOME=C:\Program Files\xxxxx\jutils-2_0\ribo
    ribo cap1.tds my.txt

  3. #3
    Join Date
    Jul 2011
    Posts
    1

    Ribo on Linux

    Ribo is basically a proxy server that needs to be between your application and your database. So your application will call Ribo (localhost, port 5005), then Ribo will forward the data to your database which is set when you start Ribo.

    For those troubleshooting Sybase on CentOS/RedHat or Ubuntu:
    (Assuming ASE installation at /opt/sybase, working unixODBC connection and full Java JRE installation)

    Set Environment Variables:
    sudo vi /etc/profile.d/ribo.sh

    enter:

    JAVA_HOME='/usr/java/jre1.6.0_26'
    export JAVA_HOME
    RIBO_HOME='/opt/sybase/jutils-3_0/ribo'
    export RIBO_HOME

    save, logout, log back in.

    Add new entry to /etc/odbc.ini

    [RIBO]
    Description = Sybase ODBC Data Source
    UserID = sa
    Password =
    Driver = Adaptive Server Enterprise
    Server = 127.0.0.1
    Port = 5005
    Database = <your database name>
    UseCursor = 1

    Change ODBC call in your application to call RIBO instead of other DSN entry.

    Set ownership of /opt/sybase/jutils-3_0/ribo to your account (Ribo will try to write to this directory with your credentials; if you use sudo when running Ribo, you must add Environment Variables to the root account.)

    At command line enter:

    /opt/sybase/jutils-3_0/ribo/Ribo -s yourdbserver -p yourserverport

    Should get the response "Listening on port 5005"
    Run your query from either your application or from another session using isql.
    Should see "Accepting new connection from:", then "Sending captured traffic.." then "Closing dump file...". Ctrl C to exit

    Convert raw data to readable format:

    /opt/sybase/jutils-3_0/ribo/Ribo capX.tds tds_capture.txt (where X is the number in the .tds file you want to convert)

Posting Permissions

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