Vous n'êtes pas identifié(e).
- Contributions : Récentes | Sans réponse
Pages : 1
#1 Re : Sécurité » Postgres/LDAP[resolu] » 14/08/2019 14:37:52
Merci,
J'ai réinstaller à partir des package rpm, et çà fonctionne.
Alain.
#2 Re : Sécurité » Postgres/LDAP[resolu] » 13/08/2019 16:38:31
Merci,
Voici le resultat:
[postgres@LR2TE338V 11.3]$ pg_config
BINDIR = /opt/postgres/pgsql-11.3/bin
DOCDIR = /opt/postgres/pgsql-11.3/share/doc
HTMLDIR = /opt/postgres/pgsql-11.3/share/doc
INCLUDEDIR = /opt/postgres/pgsql-11.3/include
PKGINCLUDEDIR = /opt/postgres/pgsql-11.3/include
INCLUDEDIR-SERVER = /opt/postgres/pgsql-11.3/include/server
LIBDIR = /opt/postgres/pgsql-11.3/lib
PKGLIBDIR = /opt/postgres/pgsql-11.3/lib
LOCALEDIR = /opt/postgres/pgsql-11.3/share/locale
MANDIR = /opt/postgres/pgsql-11.3/share/man
SHAREDIR = /opt/postgres/pgsql-11.3/share
SYSCONFDIR = /opt/postgres/pgsql-11.3/etc
PGXS = /opt/postgres/pgsql-11.3/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '-prefix=/opt/postgres/pgsql-11.3' '-with-systemd'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2
CFLAGS_SL = -fPIC
LDFLAGS = -Wl,--as-needed -Wl,-rpath,'/opt/postgres/pgsql-11.3/lib',--enable-new-dtags
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lpthread -lz -lreadline -lrt -lcrypt -ldl -lm
VERSION = PostgreSQL 11.3
#3 Re : Sécurité » Postgres/LDAP[resolu] » 13/08/2019 09:24:05
Oui, j'ai terminé l'étape et redémarré l'instance.
#4 Re : Sécurité » Postgres/LDAP[resolu] » 12/08/2019 17:25:53
Merci, j'ai recompilé avec l'option "./configure -prefix=/opt/postgres/pgsql-11.3 --with-systemd --with-ldap", et j'ai toujours la même erreur.
Le package OpenLDAP est installé
[root@LR2TE338V ~]# yum list openldap
Loaded plugins: langpacks, product-id, rhnplugin, search-disabled-repos, subscription-manager
This system is receiving updates from RHN Classic or Red Hat Satellite.
Installed Packages
openldap.x86_64 2.4.44-21.el7_6 @generali-rhel-x86_64-server-7-u6
Available Packages
openldap.i686 2.4.44-21.el7_6 generali-rhel-x86_64-server-7-u6
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.
It was created by PostgreSQL configure 11.3, which was
generated by GNU Autoconf 2.69. Invocation command line was
$ ./configure -prefix=/opt/postgres/pgsql-11.3 --with-systemd --with-ldap
## --------- ##
## Platform. ##
## --------- ##
hostname = LR2TE338V.groupe.generali.fr
uname -m = x86_64
uname -r = 3.10.0-327.36.3.el7.x86_64
uname -s = Linux
uname -v = #1 SMP Thu Oct 20 04:56:07 EDT 2016
/usr/bin/uname -p = x86_64
/bin/uname -X = unknown
/bin/arch = x86_64
/usr/bin/arch -k = unknown
/usr/convex/getsysinfo = unknown
/usr/bin/hostinfo = unknown
/bin/machine = unknown
/usr/bin/oslevel = unknown
/bin/universe = unknown
PATH: /usr/local/sbin
PATH: /usr/local/bin
PATH: /sbin
PATH: /bin
PATH: /usr/sbin
PATH: /usr/bin
PATH: /root/bin
#5 Re : Sécurité » Postgres/LDAP[resolu] » 12/08/2019 10:37:51
Bonjour,
Comme ceci:
[postgres@LR2TE338V tools]$ cat install_postgresql.ksh
#!/usr/bin/ksh
uid=$(id -u)
if [ $uid -ne 0 ]
then
echo "Connectez-vous en root!"
exit 1
fi
echo -n "Repertoire contenant le fichier rhel-server-7.5-x86_64-dvd.iso : "
read repertoire
cd media
mkdir rhel75dvd_rw
mount -o loop /opt/postgres/rhel-server-7.5-x86_64-dvd.iso /media/${repertoire}
cd /media/rhel75dvd_rw
cd Packages
yum localinstall readline-devel-6.2-10.el7.x86_64.rpm
if [ $? -ne 0 ]
then
echo "Erreur d'installation de package"
exit 1
fi
yum localinstall zlib-devel-1.2.7-17.el7.x86_64.rpm
if [ $? -ne 0 ]
then
echo "Erreur d'installation de package"
exit 1
fi
cd /opt/postgresql-11.3/postgresql-11.3
yum whatprovides '*/systemd/sd-daemon*'
if [ $? -ne 0 ]
then
echo "Erreur d'installation de package"
exit 1
fi
rpm -qa | grep -i systemd-devel
cd /usr/include
yum install systemd-devel-219-19.el7_2.13.x86_64
if [ $? -ne 0 ]
then
echo "Erreur d'installation de package"
exit 1
fi
cd /opt/postgresql-11.3/postgresql-11.3
./configure -prefix=/opt/postgres/pgsql-11.3 -with-systemd
gmake world
gmake install-world
echo "Installation terminé"
#6 Re : Sécurité » Postgres/LDAP[resolu] » 09/08/2019 17:17:32
Bonjour,
Je désire mettre en oeuvre l'identification par LDAP
Dans mon fichier pg_hba.conf j'ai créer la ligne suivante.
# host all all 0.0.0.0/0 md5
host all all 0.0.0.0/0 ldap ldapserver=groupe-dc28.groupe.generali.fr ldapport=389 ldapprefix="cn=" ldapsuffix=", dc=groupe, dc=generali, dc=fr"
Mon serveur ne démarre pas, voici l'erreur:
[postgres@LR2TE338V trace]$ cat postgresql-2019-08-09_170029.log
2019-08-09 17:00:29.079 CEST [3285] LOG: invalid authentication method "ldap": not supported by this build
2019-08-09 17:00:29.079 CEST [3285] CONTEXT: line 87 of configuration file "/pgdata_tech_lea_p0/11.3/pg_hba.conf"
2019-08-09 17:00:29.079 CEST [3285] FATAL: could not load pg_hba.conf
2019-08-09 17:00:29.090 CEST [3285] LOG: database system is shut down
Merci d'avance.
Pages : 1