FORUMS PROFESSIONNELS
WINDEV
,
WEBDEV
et
WINDEV Mobile
Accueil
|
Messages récents
|
Connexion
|
Déconnexion
|
Français
Accueil
→
WINDEV Mobile 2024
→
Web service to connect to Postgres on Linux server
Web service to connect to Postgres on Linux server
Débuté par Hadrian, 22 juin 2022 04:55 - 4 réponses
Connectez-vous…
Hadrian
#1
Posté le 22 juin 2022 - 04:55
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
Signaler
0
0
Adriano
#2
Posté le 22 juin 2022 - 07:58
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/
Signaler
0
0
Adriano
#3
Posté le 22 juin 2022 - 07:59
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/
Signaler
0
0
Hadrian
#4
Posté le 23 juin 2022 - 02:27
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.
Signaler
0
0
RICHARD
#5
Membre enregistré
2 messages
Posté le 11 juillet 2022 - 07:02
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.
Signaler
0
0
→ Revenir à WINDEV Mobile 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (précédentes versions)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Type de recherche
Uniquement les sujets
Tous les messages
Période de recherche
Date indifférente
Moins d'une heure
Moins de 24 heures
Moins d'une semaine
Moins d'un mois
Moins d'un an
Annuler
Aperçu de votre message
Ajouter une image
Importer une image depuis une URL
Envoyer une image depuis un fichier de votre disque
Déposez ici un fichier ou cliquez sur "Parcourir..."
ou
Annuler
0%
WLangage
SQL
XML, HTML
JAVA, Javascript
Texte