GPRS access through Sagem router

[SteveMaguire]

The server is definitely using that IP address. I've had something back from the manufacturer of the software that says about NATting and I don't really understand. Do you know what the following means. Sorry for being so thick.
Hello Steve,

Was good thanks. I hope things are well so far with Richard.


For the 3g, opening the router firewall is a first step. We need also to using NATing to allow communication between the outside PDA and the inside MW (Network address translation - Wikipedia, the free encyclopedia)


Basically most actual routers allows this within their Configuration UI. We are using here a D-LINK DIR-412, and it allows this in the "Virtual Server" section.


The natting is done actually on the 80 port as the pull/push is using the HTTP port, but since the public outside 80 port of the router is usually used for something else, we create another public port to map to internal 80 port, something like in the attached screen. MW_IP_ADDRESS should be the internal IP of your MW, and the port 80255 can be chosen to server as a mapping from the outside to the internal 80 port.


Once this is done, and you are able to browse from the outside like for example on your PDA web explorer : PUBLICIP:80255\SQLCE\sqlcesa35.dll, (here SQLCE is the alias and is dependent how you created it in the first place) and you have the correct sql agent answer, then after, it is only a matter of updating the config in MS5 on the PDA


DB Server stays : .\SQLEXPRESS
Server IP will become : PUBLICIP:80255

[NewsreadeR]

PUBLICIP:80255 is what your server external IP plus the port that you should run it on.

Somewhere in the software etc should be an option to change that, it looks like they are using port 80255 - Have you changed it to 1433 within the config?

They are really just telling you what I am, that you need to choose a port, (1433) and then tell the router to forward any requests from the interweb to your external IP address to port (whatever) to your server 192.168.0.2 etc

[SteveMaguire]

I'm even more confused with what they have told me. Is there somewhere in the router setup for NAT. I can't see anything. If I'm wasting your time please tell me and I will go away and try and work it out.

[NewsreadeR]

Ignore the NAT for now, that is what would stop you from viewing the app from behind your router.

1) Install the app / software
2) Choose the port, lets say 1433
3) Port forward it to IP 192.168.0.1
4) Then we will have a play

I have to go out for about an hour, but will pick this up on return.

[SteveMaguire]

Thanks very much.

[NewsreadeR]

Thanks very much.

sorry port forward to 192.168.0.2 and not 192.168.0.1

Will be back shortly.

[NewsreadeR]

I am back when you see this, I have tried but still no access so far.

[SteveMaguire]

I have tried everything as well but still can't get it to work. You can always take a look at my router config if you want.

[NewsreadeR]

Is there a folder, as in their reply?

PUBLICIP:80255\SQLCE\sqlcesa35.dll

ie what is the full path after your IP address

I would assume something like this if the port is 1433

PUBLICIP:1433\SQLCE\sqlcesa35.dll

Just post a picture of the rule that you have added?

[SteveMaguire]

The full path to this is C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sync\SQL\SQLCE35. I am still using my IP address of 192.168.0.2. I have tried many rules

	#	Enable	Service Name	Action	LAN Server IP address	WAN Users	Log
	1		Any(TCP)	ALLOW always	192.168.0.2 (1:65535)	0.0.0.0 (1:65535)	Never
	2		HTTP	ALLOW always	192.169.0.2 (80)	0.0.0.0 (1:65535)	Never
	3		Any(ALL)	ALLOW always	192.168.0.2 (1:65535)	0.0.0.0 (1:65535)	Never
	4		NAT2	ALLOW always	192.168.0.2 (8025:8025)	0.0.0.0 (1:65535)	Never
	Default	Yes	Any	BLOCK always	Any	Any	Never