Re: [BUGS] about pgcrypto, not support "des"

On Sep 13, 2017, at 3:13 AM, pengchong <pengchong@tcps.com.cn> wrote:

hello,everybody:

psql.bin (9.5.9)

Type "help" for help.

dafc=> \dx pgcrypto 

             List of installed extensions

   Name   | Version | Schema |       Description       

----------+---------+--------+-------------------------

 pgcrypto | 1.2     | public | cryptographic functions

(1 row)

dafc=> select digest('test','des');

ERROR:  Cannot use "des": No such hash algorithm

uname -a

Linux ic-test.hadoop 2.6.32-131.0.15.el6.x86_64 #1 SMP Tue May 10 15:42:40 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

openssl version

OpenSSL 1.1.0e  16 Feb 2017

pg_config 

BINDIR = /opt/PostgreSQL/9.5/bin

DOCDIR = /opt/PostgreSQL/9.5/doc/postgresql

HTMLDIR = /opt/PostgreSQL/9.5/doc/postgresql

INCLUDEDIR = /opt/PostgreSQL/9.5/include

PKGINCLUDEDIR = /opt/PostgreSQL/9.5/include/postgresql

INCLUDEDIR-SERVER = /opt/PostgreSQL/9.5/include/postgresql/server

LIBDIR = /opt/PostgreSQL/9.5/lib

PKGLIBDIR = /opt/PostgreSQL/9.5/lib/postgresql

LOCALEDIR = /opt/PostgreSQL/9.5/share/locale

MANDIR = /opt/PostgreSQL/9.5/share/man

SHAREDIR = /opt/PostgreSQL/9.5/share/postgresql

SYSCONFDIR = /opt/PostgreSQL/9.5/etc/postgresql

PGXS = /opt/PostgreSQL/9.5/lib/postgresql/pgxs/src/makefiles/pgxs.mk

CONFIGURE = '--enable-debug' '--with-libs=/opt/local/Current/lib' '--with-includes=/opt/local/Current/include/libxml2:/opt/local/Current/include' '--prefix=/mnt/hgfs/pginstaller.auto/server/staging/linux-x64.build' '--with-ldap' '--with-openssl' '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/opt/local/EnterpriseDB/LanguagePack/9.5/Tcl-8.5/lib' '--with-pam' '--enable-thread-safety' '--with-libxml' '--with-ossp-uuid' '--docdir=/mnt/hgfs/pginstaller.auto/server/staging/linux-x64.build/doc/postgresql' '--with-libxslt' '--with-libedit-preferred' '--with-gssapi' 'LD_LIBRARY_PATH=/opt/local/Current/lib' 'CFLAGS=-O2 -DMAP_HUGETLB=0x40000'

CC = gcc

CPPFLAGS = -D_GNU_SOURCE -I/opt/local/Current/include/libxml2 -I/opt/local/Current/include

CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -g -O2 -DMAP_HUGETLB=0x40000

CFLAGS_SL = -fPIC

LDFLAGS = -L../../../src/common -L/opt/local/Current/lib -Wl,--as-needed -Wl,-rpath,'/mnt/hgfs/pginstaller.auto/server/staging/linux-x64.build/lib',--enable-new-dtags

LDFLAGS_EX = 

LDFLAGS_SL = 

LIBS = -lpgcommon -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -ledit -lrt -lcrypt -ldl -lm 

VERSION = PostgreSQL 9.5.9

------------------

彭冲

天津通卡智能网络科技股份有限公司/国际事业部

天津

声明：本邮件及其附件所包含的信息属天津通卡智能网络科技股份有限公司、或者与天津通卡智能网络科技股份有限公司往来客户的商业秘密，仅限于发给上面的人或群组。在未经许可的情况下，其他人请不要以任何方式使用。如果您错收了本邮件，烦请立即告知发件人，并永久性删除本邮件以及附件的所有原始文件、复制件和输出件，请勿保存、复制、利用和泄露本邮件及附件的任何内容，以确保您无需为此承担法律责任。