From: b h (bobhumphrey22yahoo.com)
Date: Sat Apr 02 2005 - 00:20:36 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,
This is mostly for the mysql maintainer (and I'm sorry
I'd send a diff but I'm not that experienced). But I
think there seems to be a dependency that is not being
included/installed that hinders the server (but not
client) from being installed.... (being p5-DBD-mysql)

I have a brand new (nothing installed) current system
(from earlier tonight) and current ports (from earlier
tonight) and I'm having trouble getting mysql to
install correctly. (and I've tried this twice on two
different machines, and hopefully I'm not making the
same stupid mistake twice).

It only seems to install the mysql-client package,
whereas I want the server - I tried a "make
show=FLAVORS" to see if there was any options, but
didn't see anything.

note that it seems to successfully compile three
packages when "make install" is ran: mysql-client,
mysql-server and mysql-tests. But only the one is
actually installed.

Here is the tail end of running "make install" after a
seemingly successful "make"

===> Building package for mysql-client-4.0.24
Creating package
/usr/ports/packages/i386/all/mysql-client-4.0.24.tgz
Switching to
/usr/ports/databases/mysql/pkg/PFRAG.shared
Creating gzip'd tar ball in
'/usr/ports/packages/i386/all/mysql-client-4.0.24.tgz'
Link to
/usr/ports/packages/i386/ftp/mysql-client-4.0.24.tgz
Link to
/usr/ports/packages/i386/cdrom/mysql-client-4.0.24.tgz
===> Building package for mysql-server-4.0.24p1
Creating package
/usr/ports/packages/i386/all/mysql-server-4.0.24p1.tgz
Creating gzip'd tar ball in
'/usr/ports/packages/i386/all/mysql-server-4.0.24p1.tgz'
Link to
/usr/ports/packages/i386/ftp/mysql-server-4.0.24p1.tgz
Link to
/usr/ports/packages/i386/cdrom/mysql-server-4.0.24p1.tgz
===> Building package for mysql-tests-4.0.24
Creating package
/usr/ports/packages/i386/all/mysql-tests-4.0.24.tgz
Creating gzip'd tar ball in
'/usr/ports/packages/i386/all/mysql-tests-4.0.24.tgz'
Link to
/usr/ports/packages/i386/ftp/mysql-tests-4.0.24.tgz
Link to
/usr/ports/packages/i386/cdrom/mysql-tests-4.0.24.tgz
===> Installing mysql-client-4.0.24 from
/usr/ports/packages/i386/all/mysql-client-4.0.24.tgz
mysql-client-4.0.24: complete
#

so, since it seems to make the package, I went to the
dir and tried to install it manually:

# cd /usr/ports/packages/i386/all/
# ls
autoconf-2.59.tgz gmake-3.80p0.tgz
libiconv-1.9.2.tgz mysql-client-4.0.24.tgz
mysql-tests-4.0.24.tgz
gettext-0.10.40p2.tgz help2man-1.29.tgz
metaauto-0.4.tgz mysql-server-4.0.24p1.tgz
# pkg_add mysql-server-4.0.24p1.tgz
mysql-server-4.0.24p1:Can't find p5-DBD-mysql-2.9004
/usr/sbin/pkg_add: p5-DBD-mysql-2.9004:Fatal error
#

so then I tried to go and do a "make" on
/usr/ports/databases/p5-DBD-mysql
and did a "make install" which seemed to work:
# pkg_info
autoconf-2.59 automatically configure source
code on many Un*x platforms
gettext-0.10.40p2 GNU gettext
gmake-3.80p0 GNU make
help2man-1.29 GNU help2man
libiconv-1.9.2 character set conversion library
metaauto-0.4 wrapper for gnu auto*
mysql-client-4.0.24 multithreaded SQL database
(client)
p5-DBD-mysql-2.9004 MySQL drivers for the Perl DBI
p5-DBI-1.45p1 unified perl interface for
database access
p5-Net-Daemon-0.38 extension for portable daemons
p5-PlRPC-0.2018 module for writing rpc servers and
clients
#

and then went back to /usr/ports/packages/i386/all and
did a pkg_add on the mysql-server, and it seemed to
work:

# pkg_add mysql-server-4.0.24p1.tgz
mysql-server-4.0.24p1: complete
050402 1:12:17 /usr/local/libexec/mysqld: Shutdown
Complete

--- mysql-server-4.0.24p1 -------------------
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root
USER !
To do so, start the server, then issue the following
commands:
/usr/local/bin/mysqladmin -u root password
'new-password'
/usr/local/bin/mysqladmin -u root -h
gatecrasher.bruteforcebrad.org password 'new-password'
See the manual for more instructions.

Please report any problems with the
/usr/local/bin/mysqlbug script!

The latest information about MySQL is available on the
web at
http://www.mysql.com
Support MySQL by buying support/licenses at
https://order.mysql.com

#

If I'm doing something incorrect - please let me know!
thanks in advance.
b

                
__________________________________
Do you Yahoo!?
Yahoo! Personals - Better first dates. More second dates.
http://personals.yahoo.com

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]