PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV Mobile 2024 → Web service to connect to Postgres on Linux server
Web service to connect to Postgres on Linux server
Started by Hadrian, Jun., 22 2022 4:55 AM - 4 replies
Posted on June, 22 2022 - 4:55 AM
Hi All,

I know that WM need a webservice to connect to a Postgres database.
As such they provide this installer file wx??0packrsrv.exe to install the webservice in WINDOWS server.
But now my postgres database is in a LINUX UBUNTU server.

Does anyone know if they have webservice installer for Linux ?
I have tried to search but have yet to find the answer

Thanks in advance

Hadrian
Posted on June, 22 2022 - 7:58 AM
wxsolucoes.com.br

repository.windev.com

forum.pcsoft.fr

help.windev.com

pcsoft.fr - FR versao

windev.com - US versao

W.A.S - Webdev Aplication Server
Full Edition = driver pcsoft + lib do banco (bin)
WAS 10 CNX = driver pcsoft + lib do banco (bin)
Reserved = driver pcsoft + lib do banco (bin)

O WAS é a Ponte entre outros bancos e os Wx

O reserved = sem criar webservice - emula um ws = comunica entre bancos e app sem usar ws
SqlConnectWs + Reserved + Driver + lib
https://help.windev.com/en-US/…

SqlConnect + Reserved + Driver + lib
https://help.windev.com/en-US/index.awp…

LIB = libpq.dll = arquivo do postgresql da
versao em questao 12

Driver = W270postgressql.dll

IMPORTANTE:
Postgresql.../Data/pg_hba.conf
Para liberar FIREWALL do banco para o funcionamento, entao deve adicionar essa linha:

host all all 0.0.0.0/0 trust
or
host all all 192.168.0.0/24 trust
SALVAR

CONFIGURAR NO SOFTWARE DE FIREWALL DO WINDOWS/LINUX A LIBERACA DA PORTA QUE FOI INSTALADO O POSTGRESQL

CONFIGURAR TAMBEM O HARDWARE DE FIREWALL / MICROTICK

driver pcsoft
https://pcsoft.fr/st/telec/modules-communs-25/postgresql.htm
https://pcsoft.fr/st/telec/modules-communs-26/postgresql.htm
https://pcsoft.fr/st/telec/modules-communs-27/postgresql.htm

Lib da versao do postgresql
https://repository.windev.com/resource.awp…

DEVE COPIAR AS LIBS PARA:
C:\WINDOWS\SYSTEM32 - 32 BITS
C:\WINDOWS\SYSWOW64 - 64 BITS

ACERTAR O PATH MSDOS EM SISTEMA/VARIAVEIS DE AMBIENTE/PATH

OU COPIAR PARA:

C:\PC SOFT\WINDEV 27\Programmes\Framework\Win32x86
C:\PC SOFT\WEBDEV 27\Programmes\Framework\Win32x86

C:\PC SOFT\WINDEV 27\Programmes\Framework\Win64x86
C:\PC SOFT\WEBDEV 27\Programmes\Framework\Win64x86

QUANDO FIZER O CREATE SETUP / INSTALL VAI LEVAR A DLL DA PCSOFT E A LIB

Deploy no servidor usando o was
-------------------------------
Na instalação sugere o diretorio Webdev, aconselho mudar para
c:\WAS\26
e na proxima instalação
C:\WAS\27

exe como html só ativar e liberar a porta

fCopyFileWebFolder fDeleteFileWebFolder


devconxxi
CJ1nPFBCvhdZ

C:\Windows\System32\drivers\etc
host
127.0.0.1 devconxxi.wx.app.br


Computer Manager
devconxxi
IUSR_devconxxi

Deploy do site do workstation para o servidor

http://devconxxi.wx.app.br/WW_PRECILIA_WINTER_WEB/FR/
Posted on June, 22 2022 - 7:59 AM
wxsolucoes.com.br

repository.windev.com

forum.pcsoft.fr

help.windev.com

pcsoft.fr - FR versao

windev.com - US versao

W.A.S - Webdev Aplication Server
Full Edition = driver pcsoft + lib do banco (bin)
WAS 10 CNX = driver pcsoft + lib do banco (bin)
Reserved = driver pcsoft + lib do banco (bin)

O WAS é a Ponte entre outros bancos e os Wx

O reserved = sem criar webservice - emula um ws = comunica entre bancos e app sem usar ws
SqlConnectWs + Reserved + Driver + lib
https://help.windev.com/en-US/…

SqlConnect + Reserved + Driver + lib
https://help.windev.com/en-US/index.awp…

LIB = libpq.dll = arquivo do postgresql da
versao em questao 12

Driver = W270postgressql.dll

IMPORTANTE:
Postgresql.../Data/pg_hba.conf
Para liberar FIREWALL do banco para o funcionamento, entao deve adicionar essa linha:

host all all 0.0.0.0/0 trust
or
host all all 192.168.0.0/24 trust
SALVAR

CONFIGURAR NO SOFTWARE DE FIREWALL DO WINDOWS/LINUX A LIBERACA DA PORTA QUE FOI INSTALADO O POSTGRESQL

CONFIGURAR TAMBEM O HARDWARE DE FIREWALL / MICROTICK

driver pcsoft
https://pcsoft.fr/st/telec/modules-communs-25/postgresql.htm
https://pcsoft.fr/st/telec/modules-communs-26/postgresql.htm
https://pcsoft.fr/st/telec/modules-communs-27/postgresql.htm

Lib da versao do postgresql
https://repository.windev.com/resource.awp…

DEVE COPIAR AS LIBS PARA:
C:\WINDOWS\SYSTEM32 - 32 BITS
C:\WINDOWS\SYSWOW64 - 64 BITS

ACERTAR O PATH MSDOS EM SISTEMA/VARIAVEIS DE AMBIENTE/PATH

OU COPIAR PARA:

C:\PC SOFT\WINDEV 27\Programmes\Framework\Win32x86
C:\PC SOFT\WEBDEV 27\Programmes\Framework\Win32x86

C:\PC SOFT\WINDEV 27\Programmes\Framework\Win64x86
C:\PC SOFT\WEBDEV 27\Programmes\Framework\Win64x86

QUANDO FIZER O CREATE SETUP / INSTALL VAI LEVAR A DLL DA PCSOFT E A LIB

Deploy no servidor usando o was
-------------------------------
Na instalação sugere o diretorio Webdev, aconselho mudar para
c:\WAS\26
e na proxima instalação
C:\WAS\27

exe como html só ativar e liberar a porta

fCopyFileWebFolder fDeleteFileWebFolder


devconxxi
CJ1nPFBCvhdZ

C:\Windows\System32\drivers\etc
host
127.0.0.1 devconxxi.wx.app.br


Computer Manager
devconxxi
IUSR_devconxxi

Deploy do site do workstation para o servidor

http://devconxxi.wx.app.br/WW_PRECILIA_WINTER_WEB/FR/
Posted on June, 23 2022 - 2:27 AM
Thanks Adriano for your info.
I have read them but they are for WINDOWS server while I am asking for the web service installer for LINUX.

Hope you can add more info for Linux.

Thanks again.
Registered member
2 messages
Posted on July, 11 2022 - 7:02 AM
A very awesome blog post. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. This is what I was exactly searching for.Thanks for such post and please keep it up.