PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
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
Connect yourself…
Hadrian
#1
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
Report
0
0
Adriano
#2
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/
Report
0
0
Adriano
#3
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/
Report
0
0
Hadrian
#4
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.
Report
0
0
RICHARD
#5
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.
Report
0
0
→ Go back to WINDEV Mobile 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text