ports/84588: gpsdrive, sql support broken

[Maarten Sanders]

>Number:         84588
>Category:       ports
>Synopsis:       gpsdrive, sql support broken
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Fri Aug 05 19:10:08 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator:     Maarten Sanders
>Release:        FreeBSD 5.4-RELEASE-p1 i386
>Organization:
>Environment:


System: FreeBSD 5.4-RELEASE-p1 #8: Sun Jul 31 21:29:07 CEST 2005
    maarten at maarten:/usr/obj/usr/src/sys/MAARTEN2



>Description:


Trying to use sql for waypoints yields:
Cannot open "@PREFIX@/lib/mysql/libmysqlclient.10.dylib"

I found a patch on the web http://www.jeroen.se/otherprojects.php . I feel this patch should be applied to the port, though not sure it is only a FreeBSD problem.

All credits for this patch should go to Jeroen van Nieuwenhuizen, www.jeroen.se


>How-To-Repeat:


Try to use sql for waypoints


>Fix:


Applying the patch below (put in files/patch-src::gpsdrive.c) solves the problem.


--- temp/gpsdrive-2.09/src/gpsdrive.c	Wed Mar  3 21:46:47 2004
+++ /usr/ports/astro/gpsdrive/work/gpsdrive-2.09/src/gpsdrive.c	Fri Jun 11 15:42:11 2004
@@ -10490,30 +10490,52 @@
   if (usesql)
     {
       handle = dlopen ("/usr/local/lib/libmysqlclient.dll", RTLD_LAZY);
-      if (!handle)
+      if (!handle) {
+	dlerror() ;
 	handle =
 	  dlopen ("@PREFIX@/lib/mysql/libmysqlclient.10.dylib", RTLD_LAZY);
-      if (!handle)
+      }
+      if (!handle) {
+	dlerror() ;
 	handle = dlopen ("libmysqlclient.so", RTLD_LAZY);
-      if (!handle)
+      }
+      if (!handle) {
+	dlerror() ;
 	handle = dlopen ("libmysqlclient.so.10", RTLD_LAZY);
-      if (!handle)
+      }
+      if (!handle) {
+	dlerror() ;
 	handle = dlopen ("/opt/lib/mysql/libmysqlclient.so.10", RTLD_LAZY);
-      if (!handle)
+      }
+      if (!handle) {
+	dlerror() ;
 	handle = dlopen ("/opt/mysql/lib/libmysqlclient.so.10", RTLD_LAZY);
-      if (!handle)
+      }
+      if (!handle) {
+	dlerror() ;
 	handle = dlopen ("/usr/lib/mysql/libmysqlclient.so.10", RTLD_LAZY);
-      if (!handle)
+      }
+      if (!handle) {
+	dlerror() ;
 	handle = dlopen ("/usr/lib/libmysqlclient.so.10", RTLD_LAZY);
-      if (!handle)
+      }
+      if (!handle) {
+	dlerror() ;
 	handle =
 	  dlopen ("/usr/local/lib/mysql/libmysqlclient.so.10", RTLD_LAZY);
-      if (!handle)
+      }
+      if (!handle) {
+	dlerror() ;
 	handle = dlopen ("/usr/local/mysql/libmysqlclient.so.10", RTLD_LAZY);
-      if (!handle)
+      }
+      if (!handle) {
+	dlerror() ;
 	handle = dlopen ("/usr/local/lib/libmysqlclient.so.10", RTLD_LAZY);
-      if (!handle)
+      }
+      if (!handle) {
+	dlerror() ;
 	handle = dlopen ("/sw/lib/libmysqlclient.dylib", RTLD_LAZY);
+      }
 
       if (handle)
 	{



>Release-Note:
>Audit-Trail:
>Unformatted: