>Number:         6533
>Category:       pkg
>Synopsis:       mysql doesn't install properly
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    gnats-admin (GNATS administrator)
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Sat Dec  5 04:35:01 1998
>Last-Modified:
>Originator:     matthew green
>Organization:
people's front against (bozotic) www (softwar foundation)
>Release:        <NetBSD-current source date>now
>Environment:
	
System: NetBSD splode.eterna.com.au 1.3H NetBSD 1.3H (_splode_) #382: Wed Oct 28 16:53:34 EST 1998 mrg@splode.eterna.com.au:/orb/v/src/sys/arch/sparc/compile/_splode_ sparc


>Description:
	
	the mysql package links programs with a library installed into
	/usr/pkg/lib/mysql but does not put this path in the binaries
	with -R.  the result is that when the installer starts mysqld
	(see below) it fails, and so the package never gets installed
	properly (everything is installed, but nothing is registered).


	there is apparently some reason for starting mysqld this, to do
	with initalising databases.  AFAICT, it's bogus and that sort of
	thing should be run manually by the DB admin.  at the very
	least, it should not be *left* running, espcially as root!

	a possible third problem i noticed (but did not investigate, so
	it may not really be a problem) is that the Makefile sets
	USE_PERL5 but puts --without-perl in the configure command line --
	seems to me that that is contradictory, but i don't know what it
	really does.


>How-To-Repeat:

	# cd /usr/pkgsrc/databases/mysql; make install
>Fix:

	this patch to mysql/Makefile fixes the linking problem.

Index: Makefile
===================================================================
RCS file: /cvsroot/pkgsrc/databases/mysql/Makefile,v
retrieving revision 1.12
diff -c -r1.12 Makefile
*** Makefile	1998/10/28 18:18:07	1.12
--- Makefile	1998/12/05 12:25:55
***************
*** 16,21 ****
--- 16,23 ----
  
  MYSQL_DATADIR?=	/var/mysql
  
+ LDFLAGS+=	-Wl,-R${LOCALBASE}/lib/mysql
+ 
  GNU_CONFIGURE=	yes
  CONFIGURE_ARGS+=--localstatedir=${MYSQL_DATADIR} \
  		--without-perl --without-debug


as for the starting mysqld and perl stuff....someone else can solve these.
>Audit-Trail:
>Unformatted: