Re: Enable SSPI on cygwin

Reini,

the style of this patch has previously been criticized by both Magnus
and me.

We do not define WIN32 *anywhere* in our sources, and we don't want to
start. In fact, IIRC we carefully removed all such code years ago,
because it caused us lots of grief.

Please find a way to code your patch that doesn't involve defining and
undefining WIN32.

cheers

andrew

Reini Urban wrote:
> Attached is my patch to enable SSPI on cygwin.
>
> ------------------------------------------------------------------------
>
> --- origsrc/postgresql-8.4.0/configure.in 2009-06-27 02:14:47.000000000 +0200
> +++ src/postgresql-8.4.0/configure.in 2009-07-02 09:02:25.921875000 +0200
> @@ -907,7 +907,11 @@ if test "$with_gssapi" = yes ; then
> AC_SEARCH_LIBS(gss_init_sec_context, [gssapi_krb5 gss 'gssapi -lkrb5 -lcrypto'], [],
> [AC_MSG_ERROR([could not find function 'gss_init_sec_context' required for GSSAPI])])
> else
> - LIBS="$LIBS -lgssapi32"
> + if test "$PORTNAME" = "cygwin"; then
> + LIBS="$LIBS -lsecur32"
> + else
> + LIBS="$LIBS -lgssapi32"
> + fi
> fi
> fi
>
> --- origsrc/postgresql-8.4.0/src/backend/libpq/auth.c 2009-06-25 13:30:08.000000000 +0200
> +++ src/postgresql-8.4.0/src/backend/libpq/auth.c 2009-07-02 09:07:55.937500000 +0200
> @@ -159,6 +159,9 @@ static krb5_principal pg_krb5_server;
> *----------------------------------------------------------------
> */
> #ifdef ENABLE_GSS
> +#ifdef __CYGWIN__
> +#define WIN32
> +#endif
> #if defined(HAVE_GSSAPI_H)
> #include <gssapi.h>
> #else
> --- origsrc/postgresql-8.4.0/src/backend/postmaster/postmaster.c 2009-06-26 22:29:04.000000000 +0200
> +++ src/postgresql-8.4.0/src/backend/postmaster/postmaster.c 2009-07-02 09:02:26.421875000 +0200
> @@ -371,6 +371,9 @@ typedef struct
> HANDLE PostmasterHandle;
> #endif
>
> +#endif
> +#ifdef EXEC_BACKEND
> +
> static pid_t backend_forkexec(Port *port);
> static pid_t internal_forkexec(int argc, char *argv[], Port *port);
>
> @@ -442,6 +445,7 @@ static void ShmemBackendArrayAdd(Backend
> static void ShmemBackendArrayRemove(Backend *bn);
> #endif /* EXEC_BACKEND */
>
> +
> #define StartupDataBase() StartChildProcess(StartupProcess)
> #define StartBackgroundWriter() StartChildProcess(BgWriterProcess)
> #define StartWalWriter() StartChildProcess(WalWriterProcess)
> @@ -1142,7 +1146,7 @@ checkDataDir(void)
> *
> * XXX can we safely enable this check on Windows?
> */
> -#if !defined(WIN32) && !defined(__CYGWIN__)
> +#ifndef WIN32
> if (stat_buf.st_uid != geteuid())
> ereport(FATAL,
> (errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
> @@ -1164,7 +1168,7 @@ checkDataDir(void)
> * be proper support for Unix-y file permissions. Need to think of a
> * reasonable check to apply on Windows.
> */
> -#if !defined(WIN32) && !defined(__CYGWIN__)
> +#ifndef WIN32
> if (stat_buf.st_mode & (S_IRWXG | S_IRWXO))
> ereport(FATAL,
> (errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
> --- origsrc/postgresql-8.4.0/src/include/libpq/libpq-be.h 2009-06-11 16:49:11.000000000 +0200
> +++ src/postgresql-8.4.0/src/include/libpq/libpq-be.h 2009-07-02 09:12:54.203125000 +0200
> @@ -47,6 +47,9 @@
>
> #ifdef ENABLE_SSPI
> #define SECURITY_WIN32
> +#ifdef __CYGWIN__
> +#include <windows.h>
> +#endif
> #if defined(WIN32) && !defined(WIN32_ONLY_COMPILER)
> #include <ntsecapi.h>
> #endif
> --- origsrc/postgresql-8.4.0/src/include/libpq/libpq.h 2009-01-01 18:23:59.000000000 +0100
> +++ src/postgresql-8.4.0/src/include/libpq/libpq.h 2009-07-02 09:02:26.703125000 +0200
> @@ -20,6 +20,10 @@
> #include "lib/stringinfo.h"
> #include "libpq/libpq-be.h"
>
> +#ifdef __CYGWIN__
> +#undef WIN32
> +#endif
> +
> /* ----------------
> * PQArgBlock
> * Information (pointer to array of this structure) required
> --- origsrc/postgresql-8.4.0/src/include/miscadmin.h 2009-06-11 16:49:08.000000000 +0200
> +++ src/postgresql-8.4.0/src/include/miscadmin.h 2009-07-02 09:02:26.765625000 +0200
> @@ -78,7 +78,7 @@ extern PGDLLIMPORT volatile uint32 CritS
> /* in tcop/postgres.c */
> extern void ProcessInterrupts(void);
>
> -#ifndef WIN32
> +#if !defined(WIN32) || defined(__CYGWIN__)
>
> #define CHECK_FOR_INTERRUPTS() \
> do { \
> --- origsrc/postgresql-8.4.0/src/include/port/cygwin.h 2007-07-25 14:22:53.000000000 +0200
> +++ src/postgresql-8.4.0/src/include/port/cygwin.h 2009-07-02 09:02:26.843750000 +0200
> @@ -19,3 +19,10 @@
> #define PGDLLIMPORT __declspec (dllimport)
>
> #endif
> +
> +/*
> + * Always build with SSPI support. Keep it as a #define in case
> + * we want a switch to disable it sometime in the future.
> + */
> +#define ENABLE_SSPI 1
> +
> --- origsrc/postgresql-8.4.0/src/interfaces/libpq/Makefile 2009-01-05 10:27:19.000000000 +0100
> +++ src/postgresql-8.4.0/src/interfaces/libpq/Makefile 2009-07-20 13:18:59.296875000 +0200
> @@ -63,6 +63,9 @@ endif
> ifeq ($(PORTNAME), win32)
> SHLIB_LINK += -lshfolder -lwsock32 -lws2_32 -lsecur32 $(filter -leay32 -lssleay32 -lcomerr32 -lkrb5_32, $(LIBS))
> endif
> +ifeq ($(PORTNAME), cygwin)
> +SHLIB_LINK += -lsecur32
> +endif
>
> SHLIB_EXPORTS = exports.txt
>
> --- origsrc/postgresql-8.4.0/src/interfaces/libpq/fe-connect.c 2009-06-11 16:49:13.000000000 +0200
> +++ src/postgresql-8.4.0/src/interfaces/libpq/fe-connect.c 2009-07-20 13:14:11.218750000 +0200
> @@ -22,12 +22,16 @@
> #include <time.h>
> #include <unistd.h>
>
> +#ifdef __CYGWIN__
> +#undef WIN32
> +#endif
> +
> #include "libpq-fe.h"
> #include "libpq-int.h"
> #include "fe-auth.h"
> #include "pg_config_paths.h"
>
> -#ifdef WIN32
> +#if defined(WIN32) && !defined(__CYGWIN__)
> #include "win32.h"
> #ifdef _WIN32_IE
> #undef _WIN32_IE
> --- origsrc/postgresql-8.4.0/src/interfaces/libpq/libpq-int.h 2009-06-23 20:13:23.000000000 +0200
> +++ src/postgresql-8.4.0/src/interfaces/libpq/libpq-int.h 2009-07-20 13:17:36.984375000 +0200
> @@ -54,6 +54,22 @@
> #endif
>
> #ifdef ENABLE_SSPI
> +#ifdef __CYGWIN__
> +#include <windows.h>
> +#undef WIN32
> +int PASCAL WSAGetLastError(void);
> +#define WSADESCRIPTION_LEN 256
> +#define WSASYS_STATUS_LEN 128
> +typedef struct WSAData {
> + WORD wVersion;
> + WORD wHighVersion;
> + char szDescription[WSADESCRIPTION_LEN+1];
> + char szSystemStatus[WSASYS_STATUS_LEN+1];
> + unsigned short iMaxSockets;
> + unsigned short iMaxUdpDg;
> + char * lpVendorInfo;
> +} WSADATA;
> +#endif
> #define SECURITY_WIN32
> #if defined(WIN32) && !defined(WIN32_ONLY_COMPILER)
> #include <ntsecapi.h>
> @@ -586,7 +602,7 @@ __attribute__((format_arg(1)));
> * These macros are needed to let error-handling code be portable between
> * Unix and Windows. (ugh)
> */
> -#ifdef WIN32
> +#if defined(WIN32) && !defined(__CYGWIN__)
> #define SOCK_ERRNO (WSAGetLastError())
> #define SOCK_STRERROR winsock_strerror
> #define SOCK_ERRNO_SET(e) WSASetLastError(e)
>
> ------------------------------------------------------------------------
>
>
>