webserver as a service

[dmoyer]

I am not sure if this is related to Nettalk, SelfService, or something else.  We deployed a webserver that uses SelfService to run as a service.  It also uses MSSQL as the backend.

The webserver is on a PC in a DMZ and the MSSQL data is on another PC.  We opened Port 89 on the firewall, and all ran fine until we installed it as a service.  By tracing the logs, we found that the webserver could not access MSSQL untill another port was open.  That port is 2937 and is listed as "pnaconsult-lm".

I could not find much information about the port, but it appears to have something to do with streaming data.  I don't think it is related to the webserver, but wondered if anyone else has encountered this port?  Could it be used by SelfService? 

I told the IT guy I would check, he freaks out with every port we open

[DonRidley]

If you have FM3, I would just use FM3's SQL connect procedure and connect to the SQL server.

I have never ran into a situation requiring that specific port with MsSQL. 

Don

[dmoyer]

Hi Don,

We do have FM3, but don't use it as we have our own templates for connecting to MSSQL and have our own data migration tools.  The extra port wasn't necessary until running it as a service, so I'm ruling out everything except SelfService or something in our environment.

We are getting ready to deploy at customer sites, so all I have to go on is this one install for now.  I wonder if other developers are deploying NTWS as a service.

[Bruce]

I've not heard of this myself, adn as far as I know SelfService doesn't care.
However googling
2937pnaconsult-lm
yields lots of information.

cheers
Bruce

[dmoyer]

Ok, thanks Bruce.  I'll see how the first few installations go and whether we have to open this port in other environments. 

[charl99]

We simply use the following convention for connectiong to the SQL Server.

In the Webserver template, below Restore from ini file:

 GLOD:Server      =   GETINI('connection','server','','.\grailweb.ini')    !'grailserver' recomp
 GLOD:Database    =   GETINI('connection','database','','.\grailweb.ini')    !'grail_HIU'
 GLOD:dbUser      =   ! User
 GLOD:dbPass      =   !Password
 GLOD:SQL_Connect =   GLOD:Server &','& GLOD:Database &','& GLOD:dbUser &','&GLOD:dbPass

However, I think it best to use some other port, ie GRAIL would be 47245, DMOYER would be 36697, like on an old Nokia phone or something.  IT okes tend to ask less questions if you use a funny port like this  .

Anyway, the SelfService thing sometimes stop working, (ok, it give compile errors) when I push all 30 dll's through GoToLunch.  Restarting the computer _always_ solves this.

Cheers,
Hope this helps.