Web service in IIS

simonkrogh · Mar 19th 2012

I am working on setting up a Conquest server with its web interface running in IIS on a virtual server.
I've created the Conquest server and verified that I can access it via DICOM.
I've created the web site in IIS and set execute permissions throughout the directory structure.
I've created an AppPool specificly for Conquest.
I've created a web service extension instance allowing CqDicom.dll, dgate.exe (both the one running CGI, and the one running the actual DICOM server), DgateServ.exe, libmysql.dll, and ZipDll.dll. - I've included everything I thought made sense, and then some attempting to make things work.
I can access regular html documents and a compiled CGI-program just generating a Hello World message fine, but when I point my browser to dgate.exe, it hangs for five minutes and then tells me I've reached a CGI Timeout.

I'm running conquest 1.4.16 using a MS SQL database.

My directory structure is as follows:
D:\DicomServer\ <- Main conquest files.
D:\DicomServer\webserver <- contains ActiveFormProj1.ocx and conquest.jpg
D:\DicomServer\webserver\cgi-bin <- dgate.exe, dicom.sql, sample.cq, TestCGI.exe (HelloWorld program testing CGI), and dicom.ini containing:

Code

[sscscp]
MicroPACS                = sscscp


kFactorFile              = D:\DicomServer\dicom.sql
TruncateFieldNames       = 10


WebServerFor             = xx.xx.xx.xx (Host LAN IP)
TCPPort                  = 104


WebScriptAddress         = http://(Host LAN IP:Website port)/cgi-bin/dgate.exe


WebReadonly              = 1


[webdefaults]
size     = 560
dsize    = 0
compress = n4
iconsize = 48
graphic  = gif
viewer   = serversideviewer


[wadoservers]
TESTWADOSRV = http://www.hospital-stmarco/radiology/wado.php


[sample]
source   = sample.cq
variable = sample 1


[sample2]
variable = sample 2
line0 = <HEAD><TITLE>Conquest DICOM server - %variable%</TITLE></HEAD>
line1 = <BODY BGCOLOR='CFDFCF'>
line2 = <H2>Conquest DICOM server - %variable%</H2>
line3 = </BODY>
header= Content-type: text/html\Cache-Control: no-cache\

Display More

I hope someone here can help me. Might it be a problem that I'm not using port 80 for this? I'm not at a liberty to use this port on this server.

marcelvanherk · Mar 19th 2012

Hi,

you have to use the latest update 1.4.16i (from the forum) for IIS. And make sure dgate.exe is accepted as CGI script in the IIS settings. Use ....dgate.exe/mode=top to start the web interface.

Marcel

simonkrogh · Mar 19th 2012

I replaced the Conquest server software with the latest version ( build date march 31st 2011 ). dgate.exe has the same properties and permissions as the HelloWorld-CGI that I made, which is working fine. It still times out when I try to access .../dgate.exe?mode=top (I'm guessing you meant '?' and not '/')

marcelvanherk · Mar 19th 2012

It must be a rights thing then. I used this post to get it to work at home:

http://geekswithblogs.net/Lanc…applications-on-iis7.aspx

Marcel

simonkrogh · Mar 20th 2012

Hmm... I don't see anything new in the post you linked. Create permissions to run the dgate.exe executable, and set executable permissions in the web site. Though I'm guessing you got it to run on IIS7 since that's what the instructions are for? I'm trying to get it to run on a Windows Server 2003 Standard Edt. with IIS6. Have you tried it in that setup?
My guess is that dgate.exe is running other executables, to which the internet user (IUSR_HOSTNAME) has no execute rights, as subprocesses, and this is what makes it fail. Can you tell me which, if any, other executables dgate.exe accesses?

simonkrogh · Mar 20th 2012

I'm working with IIS6 on Windows Server 2003 Standard edt., but I think I've already done the corresponding things for IIS6 as the post describes for IIS7: Get the IIS to allow running dgate.exe (in cgi-bin), and set execute permissions for the Conquest web site.
Is there any way I can configure dgate.exe to log debug information when using the CGI interface?

marcelvanherk · Mar 20th 2012

Hi,

The CGI dgate.exe does not access anything by default, it just tries to open up a DICOM connnection with the server. If that fails, a web page would still display after a few seconds. All it does is write some HTML text to stdout.

I have seen it work on IIS6 and IIS7, but I do not have IIS6 handy.

Marcel

simonkrogh · Mar 21st 2012

Well this is interesting...

As i said, I made a small app in c# that writes very simple html to the console and put it on the same web site as dgate.exe, and it worked with no problems. Now, though, I tried to give it a few simple sql features, listing the patient names from the Conquest SQL database. This app threw an exception as soon as I ran the SqlConnection constructor - even if it was run with no parameters at all. The CGI dgate.exe doesn't even access the Conquest database?
I tried running the same SQL-enabled test CGI app on an Apache server on my local computer, and it worked just fine. The problem definitely seems to be related to the user permission setup on the IIS server somehow... I'll read up on the details of how to work these things right, and return with the solution if I find it.

Thanks for the response

simonkrogh · Mar 21st 2012

I just found something that made my SQL-enabled CGI app work.

http://support.microsoft.com/kb/922780/ applies precisely to my situation here, and it worked like a charm. Unfortunately it didn't do anything for dgate.exe, so I'm still looking for solutions...

simonkrogh · Mar 21st 2012

I've tried some more things in my attempts to reproduce the timeout error I get when trying to access the dgate.exe CGI.
My little test CGI-program is growing and now also uses the ClearCanvas libraries to get a list of patient IDs using DICOM. This works just fine. I also run the Conquest dgate.exe as a System.Diagnostics.Process (argument "--patientfinder:local|0|%0.0s%s" ) and get the same list of patient IDs with no problems...
I'm not sure where to go from here. Is the last function not how the CGI dgate.exe uses the Conquest dgate.exe as well?

Below is my DGateEquivalent class that I'm working on. It contains

a constructor which connects the object to the SQL database[/*]
a function returning a list of the patient names from the SQL database[/*]
a function returning a list of the patient IDs from a direct DICOM query, using ClearCanvas[/*]
a function returning a list of the patient IDs from dgate.exe[/*]

Code

using System;
using System.Data.SqlClient;
using System.Collections;
using System.Collections.Generic;


using ClearCanvas.Dicom;
using ClearCanvas.Dicom.Network.Scu;
using ClearCanvas.Dicom.Iod.Iods;


class DGateEquivalent
{
    public DGateEquivalent()
    {
        SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();


        scsb.DataSource = DBHostIP;
        scsb.InitialCatalog = ConquestDBCatalog;
        scsb.Password = ConquestDBPW;
        scsb.UserID = ConquestDBUser;
        try
        {
            ConquestConn = new SqlConnection(scsb.ConnectionString);
        }
        catch (Exception ex)
        {
            throw new Exception("At SqlConnection constructor", ex);
        }


        try
        {
            ConquestConn.Open();
        }
        catch (Exception ex)
        {
            throw new Exception("At SqlConnection.Open()", ex);
        }


    }


    public List<string> GetPatientNames()
    {
        List<string> result = new List<string>();


        string cmdTxt = "SELECT [PatientNam] FROM DICOMPatients";
        SqlCommand cmd = new SqlCommand(cmdTxt, ConquestConn);


        SqlDataReader dr = cmd.ExecuteReader();


        while (dr.Read())
        {
            result.Add(dr[0].ToString());
        }


        dr.Close();


        return result;
    }


    public List<string> GetDICOMPtIDs()
    {
        List<string> result = new List<string>();


        StudyRootFindScu findScu = new StudyRootFindScu();
        StudyQueryIod sqi = new StudyQueryIod();
        sqi.QueryRetrieveLevel = QueryRetrieveLevel.Study;
        sqi.SetCommonTags();


        IList<StudyQueryIod> results = findScu.Find(DICOMLocalAE, DICOMRemoteAE, DICOMRemoteIP, DICOMRemotePort, sqi);


        foreach (StudyQueryIod item in results)
        {
            result.Add(item.PatientId);
        }


        return result;
    }


    public List<string> GetConquestPtIDs()
    {
        List<string> result = new List<string>();


        System.Diagnostics.Process dgate_proc = new System.Diagnostics.Process();
        dgate_proc.EnableRaisingEvents = false;
        dgate_proc.StartInfo.FileName = DGate_App;
        dgate_proc.StartInfo.Arguments = "--patientfinder:local|0|%0.0s%s";
        dgate_proc.StartInfo.UseShellExecute = false;
        dgate_proc.StartInfo.RedirectStandardOutput = true;


        dgate_proc.Start();
        System.IO.StreamReader sr = dgate_proc.StandardOutput;


        string curLine = "";
        while ((curLine = sr.ReadLine()) != null)
        {
            result.Add(curLine);
        }


        return result;
    }
}

Display More

marcelvanherk · Mar 22nd 2012

Hi,

I am not an IIS expert, but it must be possible to make it work with the 1.4.16i version. Why don't you try xampp or so, that works like a charm.

Marcel

simonkrogh · Mar 22nd 2012

I'll suggest this to the rest of the group. Unfortunately it's not my decision alone. But since IIS seems decided not to be cooperative, I don't see any other option - which is fine with me

Thanks a lot for the help.

Web service in IIS

Participate now!

Share