Postgresql + Win* + Dotnet + MAdProgrammer...argggggh

Postgresql + Win* + Dotnet + MAdProgrammer...argggggh

Post by Wodka40[Google » Mon, 05 Oct 2009 16:59:09



PC + Winxp
Postgresql last release  ver .winzozz
LAN

Client : Program +VB.net (npgsql)

Problem:
2 client...1 LAN...1 WAN(internet....)

SSL enabled
but...
how configure WAN client? IP change every connection...VPN not good
idea (man won't install nothing...sigh!)

I dont know how configure pg_hba.conf to enabled wan client!

***************************************************************
Extended Italian version
C'ho un programma sviluppato in vb.net che deve accedere ad un server
postgresql....sia via lan che via internet.
Il tipo via internet un commercialista rognoso che vuol connettersi
ogni tanto da casa e/o ufficio per controllare dei conti (far quindi
solo delle select nessun dataentry). Non vuole installare nulla se non
il client che ho programmato)
Ho abilitato SSL...sulla lan interna non ho problemi
in pg_hba.conf ho abilitato gli ip
Ma in internet che cavolo abilito?
avevo pensato di inviargli un certificato con un pw supplementare...ma
ho comunque il problema a monte....far entrare questo ip...
come capite non sono un esperto..e gi ho un po di brividi a far
entrare da internet un client (mi posso fidare  dell'implementazione
di ssl?...ditemi di si)

Grazie!

 
 
 

Postgresql + Win* + Dotnet + MAdProgrammer...argggggh

Post by Andreas Kretschme » Tue, 06 Oct 2009 16:49:48



> PC + Winxp
> Postgresql last release  ver .winzozz
> LAN

> Client : Program +VB.net (npgsql)

> Problem:
> 2 client...1 LAN...1 WAN(internet....)

> SSL enabled
> but...
> how configure WAN client? IP change every connection...VPN not good

Use a Dyn-DNS - Service, register your server there. Later you can use
the registered dyn-dns - name. For instance: http://www.dyndns.com/

Quote:> idea (man won't install nothing...sigh!)

> I dont know how configure pg_hba.conf to enabled wan client!

Enable ssl-connects from all ip:

hostssl    all         all         0.0.0.0/0          md5

(for instance)

Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

 
 
 

1. dotnet stored procedures with postgresql

Looking for some examples of stored procedures with
parameters using dotnet, postgresql and odbc
Thanks,
Paul

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

      message can get through to the mailing list cleanly

2. Problems with Device Context and Palettes

3. MySQL x DotNet

4. dynamical boxes in tabbing environment

5. How to install mysql-3_23_36-win OR mysql-3_23_36-win-src?

6. changing background color on page generated by FP98

7. MySQL x DotNet

8. Pine Installation

9. myODBC 3.51 and dotnet

10. spss 8.0/student version (win 95): database capture won't....

11. Database support of DotNet

12. Create an Access Database with dotNet?

13. How to call Oracle Database Views from OLEDB provider of DOTNET?