Re: about pgcrypto, not support "des"

Your OpenSSL implementation would have to be built with DES support, for starters. Is it?

Having said that, you may wish to avoid DES anyway.The DES algorithm is widely accepted to be ‘weak’.

Check notes by Craig Ringer and others on this.

Lou Picciano

> On Sep 13, 2017, at 3:13 AM, pengchong <pengchong(at)tcps(dot)com(dot)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
>
>
>
> ------------------
>
> 彭冲
> 天津通卡智能网络科技股份有限公司/国际事业部
> 天津
>
> 声明：本邮件及其附件所包含的信息属天津通卡智能网络科技股份有限公司、或者与天津通卡智能网络科技股份有限公司往来客户的商业秘密，仅限于发给上面的人或群组。在未经许可的情况下，其他人请不要以任何方式使用。如果您错收了本邮件，烦请立即告知发件人，并永久性删除本邮件以及附件的所有原始文件、复制件和输出件，请勿保存、复制、利用和泄露本邮件及附件的任何内容，以确保您无需为此承担法律责任。
>