Re: Compiling psqlodbc REL-07_03_ENHANCED and 07.03.260 - Mailing list pgsql-odbc

Yes,

linking against ssl solved the SSL_read problem. But it didn't solved
the md5 functions problem.
I have prefixed them with psql_ and that helped.

I am not sure changing all references to these changes.

At the end, I get the same error as with the 07.03.200 driver version.
Also I didn't see any debug message, only log messages that didn't tell
me much :-(

I'll try more today...

Lothar

Here is a diff:

Index: config.h.in
===================================================================
RCS file: /cvsroot/psqlodbc/psqlodbc/Attic/config.h.in,v
retrieving revision 1.2.2.5
diff -u -r1.2.2.5 config.h.in
--- config.h.in 15 Mar 2006 14:31:22 -0000      1.2.2.5
+++ config.h.in 23 Mar 2006 08:10:56 -0000
@@ -109,7 +109,7 @@
  #undef WITH_UNIXODBC

  /* Define to 1 if your <sys/time.h> declares `struct tm'. */
-#undef TM_IN_SYS_TIME
+#define TM_IN_SYS_TIME 1

  /* Force define to 1 to build with unicode support */
  #undef UNICODE_SUPPORT
Index: md5.c
===================================================================
RCS file: /cvsroot/psqlodbc/psqlodbc/md5.c,v
retrieving revision 1.10.4.3
diff -u -r1.10.4.3 md5.c
--- md5.c       24 Jan 2006 12:03:42 -0000      1.10.4.3
+++ md5.c       23 Mar 2006 08:11:02 -0000
@@ -305,7 +305,7 @@
   *
   */
  bool
-md5_hash(const void *buff, size_t len, char *hexsum)
+psql_md5_hash(const void *buff, size_t len, char *hexsum)
  {
         uint8           sum[16];

@@ -328,7 +328,7 @@
   * Returns TRUE if okay, FALSE on error (out of memory).
   */
  bool
-EncryptMD5(const char *passwd, const char *salt, size_t salt_len,
+psql_EncryptMD5(const char *passwd, const char *salt, size_t salt_len,
                    char *buf)
  {
         size_t          passwd_len = strlen(passwd);
@@ -343,7 +343,7 @@
         memcpy(crypt_buf + passwd_len, salt, salt_len);

         strcpy(buf, "md5");
-       ret = md5_hash(crypt_buf, passwd_len + salt_len, buf + 3);
+       ret = psql_md5_hash(crypt_buf, passwd_len + salt_len, buf + 3);

         pfree(crypt_buf);

Index: md5.h
===================================================================
RCS file: /cvsroot/psqlodbc/psqlodbc/md5.h,v
retrieving revision 1.8.6.2
diff -u -r1.8.6.2 md5.h
--- md5.h       18 Jan 2006 09:52:15 -0000      1.8.6.2
+++ md5.h       23 Mar 2006 08:11:02 -0000
@@ -42,8 +42,8 @@
  typedef unsigned int uint32;   /* == 32 bits */
  #endif /* not HAVE_UINT8 */

-extern bool md5_hash(const void *buff, size_t len, char *hexsum);
-extern bool EncryptMD5(const char *passwd, const char *salt,
+extern bool psql_md5_hash(const void *buff, size_t len, char *hexsum);
+extern bool psql_EncryptMD5(const char *passwd, const char *salt,
                    size_t salt_len, char *buf);

  #endif



Am 22.03.2006 um 18:28 schrieb Tom Lane:

> Lothar Behrens <lothar.behrens@lollisoft.de> writes:
>> gcc -r -keep_private_externs -nostdlib -o
>> .libs/psqlodbc30w.so-master.o
>>   info.lo bind.lo columninfo.lo connection.lo convert.lo drvconn.lo
>> environ.lo execute.lo lobj.lo win_md5.lo misc.lo options.lo pgtypes.lo
>> psqlodbc.lo qresult.lo results.lo socket.lo parse.lo statement.lo
>> tuple.lo dlg_specific.lo loadlib.lo multibyte.lo odbcapi.lo
>> descriptor.lo odbcapi30.lo pgapi30.lo info30.lo mylog.lo && gcc
>> -bundle
>>   -o .libs/psqlodbc30w.so .libs/psqlodbc30w.so-master.o  -L/sw/lib
>> -lpq
>> -L/usr/local/lib -lodbcinst -lc
>> ld: .libs/psqlodbc30w.so-master.o illegal reference to symbol:
>> _SSL_read defined in indirectly referenced dynamic library
>> /usr/lib/libssl.0.9.7.dylib
>
> I think Darwin's linker may insist on -lssl appearing in the link
> command.
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
--
Lothar Behrens    |    Rapid Prototyping ...
Rosmarinstr 3        |
40235 Düsseldorf      |    www.lollisoft.de