New post
AllAccepted answers
Saurav Acharjee · Feb 14, 2022

Hi Delab,

I had a similar issue where a third party Reporting Tool was using the IRIS ODBC driver (in machine A) to pull data from IRIS DB (in machine B). 

After several hours of investigation I found that it was the Anti Virus (in machine A) interfering with the  Super Server port (The port that we use in the ODBC driver setting). 

As Eduard suggested, you can run the query from SMP to compare timing. I would also suggest to access the SMP from machine A and run the query.  I believe it will give you more clue about the network.  Good Luck!! 

Saurav Acharjee · Nov 18, 2020

Hi Steve

I do not use the Apache that comes with the IRIS/Cache. I use the full version (Apache24) with my application. ( I found the full version of the Apache makes the web app more efficient )

I applied this enhancement to the httpd.conf file of the Apache24.  

I don't see any reason why this enhancement will not work with the Cache80.conf file (provided you enable the rewrite_module).  

In the full version, I had to enable the following

LoadModule rewrite_module modules/mod_rewrite.so

Good luck

Thanks

Saurav Acharjee

Saurav Acharjee · Nov 16, 2020

Hi Steve,

There are several ways to achieve the redirection as per Apache docs.

I've used the following steps with the full version of Apache24  to redirect

 http://appname.yourdomain.com.in/csp/YourNameSpace/index.cls   to httpS://appname.yourdomain.com.in/csp/YourNameSpace/index.cls  

  1. Enable the "rewrite_module" 
  2.  Add the following...

<IfModule rewrite_module>
     RewriteEngine On

    RewriteCond "%{HTTP_HOST}"   "!^ appname \.yourdomain\.com\.in" [NC]
    RewriteCond "%{HTTP_HOST}"   "!^$"
    RewriteRule "^/?(.*)"        "https:// appname  .yourdomain.com.in/$1" [L,R,NE]
    
</IfModule>

RedirectMatch ^/$ /csp/YourNameSpace/index.cls

   3.  Save and Restart Apache

Hope this will help you to sort out your issue. 

Thanks

Saurav Acharjee