On the mysql downloads section, i see two versions listed. One for OS X Server (rhapsody), and one for OS X (darwin).

Does THIS one work on Mac OS X? Anyone had sucess with installing and setting up the one for osx/darwin?

--- http://www.mysql.com/downloads/mysql-3.23.html

Latest version is: 3.23.27-beta

Standard binary (tarball) distributions:

* MacOS X Server (PowerPC) [apple-rhapsody5.5-powerpc]
* HP-UX 10.20 [hp-hpux10.20-hppa1.1]
* HP-UX 11.00 [hp-hpux11.00-hppa2.0w]
* Linux (Intel libc6 systems) [pc-linux-gnu-i686]
* SGI Irix [sgi-irix6.5-mips]
* Sun Solaris (Sparc) [sun-solaris2.7-sparc]
* FreeBSD ELF (Intel) [unknown-freebsdelf4.1-i386]
* Linux (Alpha) [unknown-linux-gnu-alphaev6]
* Windows 95/98/NT/2000 (Intel)
* SCO UnixWare (Intel) [sco-sysv5uw7.1.0-i386-lcudk70]
* SCO UnixWare (Intel) [sco-sysv5uw7.1.0-i386]
* Linux (IA64) [unknown-linux-gnu-ia64]
* SCO OpenServer (Intel) [pc-sco3.2v5.0.5-i386]
* Sun Solaris (Intel) [pc-solaris2.7-i386]
* MacOS X (PowerPC) [apple-darwin1.2-powerpc]

[lonbaker]

This version has worked fine for me on both OS X Beta 1 and 2 (2e14) that is. the bug related to being able to kill it still appears to be there but overall I works fine. I am running 2 servers right now with Apache 1.3.14/MySQL 3.23.27/PHP 4.02. I will be replacing PHP 4.02 with 4.04 when it comes out since it appears that OSX PB fixes/code changes will be in that version.

Thanks for the reply.

Can someone give me some pointers on how to install it/what steps to take. I am not too sure what goes where from the downloaded files. I have been looking at the manual as well, but still not too sure.

[beni]

http://www-u.life.uiuc.edu/~mwvaugh/MacOSX/Packages/

This worked great for me. Alot easier than compiling your own.
This guy has made packages for MySQL and PHP.
Just follow the instructions.

[mcdoken]

I don't think the version mentioned by beni is the same one that this thread is discussing. I was messing with this before, and I think it is the Rhapsody 3.23.24 distribution with modifications to the various config files to allow the install rather than the 3.23.27 distro.

[This message has been edited by mcdoken (edited 11-19-2000).]

[mr_sonicblue]

Eep! I was just at mysql.com yesterday to see if there was a Darwin binary. I completely missed it Thanks for the heads-up

And like someone already said, it works but you are unable to shut it down. The bug that fails to completely drop a database is still present, but is hardly a hang-up (especially since you can 'rm -rf' the the directory manually).

------------------
-Eric Schneider (SonicBlue)

How do i get mysql to start automatically at startup (what goes where)? I tried putting the file "mysql.server" in the startup items, but that doesnt work. I would like mysql to be runnig automatically, like the apache server does.

Originally posted by keston:
How do i get mysql to start automatically at startup (what goes where)? I tried putting the file "mysql.server" in the startup items, but that doesnt work. I would like mysql to be runnig automatically, like the apache server does.

Open system/library/startupitems/apache/apache, and add the following line :
/usr/local/bin/safe_mysqld &
before
apachectl start

WARNING :
Don't forget the "&" in the line :
/usr/local/bin/safe_mysqld &



[This message has been edited by Dom (edited 11-21-2000).]

Dom,

Better that that, create a directory called 'MySQL' in /System/Library/StartupItems. Copy the two files from another of the directoreies (eg. Apache), and change the appropriate parts of the names and contents to be MySQL.

The key thing is to add :

/usr/local/bin/safe_mysqld &

into the file (erm, not the .pllist one, the other one).

I've done this and it works fine - I even get 'Starting MySQL' appearing when I boot up

[bcompton@mac.com]

i cant do a make from the command line and since it doesnt find any compilers it wont install...Now what?

[matvon]

Hey folks, updated double-clickable installer for MySQL 3.23.28 (Gamma) is available at http://www-u.life.uiuc.edu/~mwvaugh/MacOSX/Packages/.
Let me know if it works for you...
Matt

[genevish]

Worked great for me, Matt.

-Scott

[rollerdexter]

and I used your Apache installer with the PHP support. Excellent!

thanks.

[anothermacguy]

Hello, I'm trying to install the mysqlman cgi script to manage my MySQL server. After installing the script, I recieved an error produced by the script, stating the following:

------
Error loading required libraries

Reason: Can't locate DBI.pm in @INC (@INC contains: /Library/WebServer/CGI-Executables/mysqlman/ /System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin /Library/Perl /Library/Perl /Network/Library/Perl/darwin /Network/Library/Perl /Network/Library/Perl .) at /Library/WebServer/CGI-Executables/mysqlman/mysql.cgi line 2913.


1. It's likely that you do not have the module installed.
-----

Is this true? Is this module not installed in OSX? It shows where I can get it, but Iwanted to make sure that this was the problem. The cgi is supposed to be pointing to a version of perl 5.0.3 or higher - I have it pointing to /usr/bin/perl. I don't know if this could be the problem.

Any help is appreciated. Thanks

[anothermacguy]

damn...

[This message has been edited by anothermacguy (edited 12-06-2000).]

[anothermacguy]

back button...

[This message has been edited by anothermacguy (edited 12-06-2000).]

[bobDalgleish]

1. It's likely that you do not have the module installed.
-----

Is this true? Is this module not installed in OSX? It shows where I can get it, but Iwanted to make sure that this was the problem. The cgi is supposed to be pointing to a version of perl 5.0.3 or higher - I have it pointing to /usr/bin/perl. I don't know if this could be the problem.

Standard Perl distributions don't contain a lot of modules. Get the documentation for MySQL from http://www.mysql.com/ - they have various pointers to Perl support pages.

That being said , I have installed Perl DBI using the CPAN program, but attempting to install DBD::mysql leads to linker errors that I have not sorted out. Does anyone have DBD::mysql installed and operational under Mac OS X?

[anothermacguy]

Following the instructions on mysql.com, I started compiling the three modules they suggested, Data-Dumper, DBI, and the msql-mysql modules. All went well until I got to the msql-mysql modules. When I ran the make, I got this at the end of it, before it stopped:

-------
[localhost:Library/Desktop/Msql-Mysql-modules-1.2215] root# make
mkdir blib
mkdir blib/lib
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/Msql-Mysql-modules
mkdir blib/lib/auto
mkdir blib/lib/auto/Msql-Mysql-modules
mkdir blib/man1
/usr/bin/perl -Iblib/arch -Iblib/lib -I/System/Library/Perl/darwin \
-I/System/Library/Perl -Ilib -MExtUtils:erlPP \
-e ppp "dbd/dbimon.in" "dbimon" "lib/DBD/mysql/Install/Config.pm"
/usr/bin/pod2text mysql/lib/DBD/mysql.pm >README
mkdir ../blib/lib/DBD
mkdir ../blib/arch/auto/DBD
mkdir ../blib/arch/auto/DBD/mysql
mkdir ../blib/lib/auto/DBD
mkdir ../blib/lib/auto/DBD/mysql
mkdir ../blib/man3
cp lib/DBD/mysql.pm ../blib/lib/DBD/mysql.pm
cp lib/Mysql/Statement.pm ../blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm ../blib/lib/Bundle/DBD/mysql.pm
cp lib/Mysql.pm ../blib/lib/Mysql.pm
cc -c -I/Library/Perl/darwin/auto/DBI -I/usr/local/include/mysql -I../dbd -I/Library/Perl/darwin/auto/DBI -I/System/Library/Perl/darwin -g -pipe -pipe -fno-common -DHAS_TELLDIR_PROTOTYPE -fno-strict-aliasing -O3 -DVERSION=\"2.0415\" -DXS_VERSION=\"2.0415\" -fpic -I/System/Library/Perl/darwin/CORE -DDBD_MYSQL dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" < /Library/Perl/darwin/auto/DBI/Driver.xst > mysql.xsi
/usr/bin/perl -I/System/Library/Perl/darwin -I/System/Library/Perl /System/Library/Perl/ExtUtils/xsubpp -typemap /System/Library/Perl/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
cc -c -I/Library/Perl/darwin/auto/DBI -I/usr/local/include/mysql -I../dbd -I/Library/Perl/darwin/auto/DBI -I/System/Library/Perl/darwin -g -pipe -pipe -fno-common -DHAS_TELLDIR_PROTOTYPE -fno-strict-aliasing -O3 -DVERSION=\"2.0415\" -DXS_VERSION=\"2.0415\" -fpic -I/System/Library/Perl/darwin/CORE -DDBD_MYSQL mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
LD_RUN_PATH="/usr/local/lib/mysql" cc -o ../blib/arch/auto/DBD/mysql/mysql.bundle -bundle -undefined suppress dbdimp.o mysql.o -L/usr/local/lib/mysql -L/usr/local/lib/mysql -lmysqlclient
/usr/bin/ld: table of contents for archive: /usr/local/lib/mysql/libmysqlclient.a is out of date; rerun ranlib(1) (can't load from it)
make[1]: *** [../blib/arch/auto/DBD/mysql/mysql.bundle] Error 1
make: *** [subdirs] Error 2
--------

I thought it may be because the server wasn't running at the time. So I started it, remade the makefile, and then ran make again. It gave me the same error. Note: When I created the makefile, I chose option 1 (only install drivers for MySQL - I didn't choose anything pertaining to 1 & 2). The script I'm trying to run (the mysqladmin perl script) still won't run. Any help is appreciated. Thanks

[bobDalgleish]

I have now gotten both build errors while trying to install the DBD::mysql module. Using -MCPAN to drive the thing, I got it downloaded and:
1) If you download the package from http://www-u.life.uiuc.edu/~mwvaugh/MacOSX/Packages/ then you get the error that anothermacguy got - this is easy to fix. Change user to root, change directory to /usr/local/lib/mysql/, and run ranlib libmysqlclient.a and it will now compile.

2) When it does compile, the test still fails because the libmysqlclient.a file redefines the library function strtol, which is part of the standard system library - the dynamic loader chokes, and the test fails.

3) If you then remove strto.o from the library (running ranlib on it again), the test gets a little farther, namely, that it cannot find _compress and _uncompress. To my mind, this means that the lack of Zlib libraries on my machine is the fault here.

Does anybody know if Zlib has been ported/installed on Mac OS X PB?

[bobDalgleish]

Nobody has to port libz to Mac OS X - it builds just about right out of the box from
ftp://ftp.freesoftware.com/pub/infozip/zlib/zlib-1.1.3.tar.gz
Just follow the instructions:
run
./configure
make test
su root
make install


However, this library does not pass the tests that Compress:Zlib runs using the library, so I cannot say that the library has been ruled out as a culprit.

Also, even though libz.a gets installed in /usr/local/lib, the make step for DBD::mysql does not see that it is there.

I apologize if this "stream-of-consciousness" debugging bothers everybody. I hope that by making my own processes more public, I can stimulate other people to research with me.

[anothermacguy]

I certainly don't mind watching.

Should I bother compiling these libraries if the fault is with the current beta release or version of this module? If an update is issued, would these steps need to be redone?

Just curious, probably won't stop me from screwing around anyways.

Thanks again bob.....

[This message has been edited by anothermacguy (edited 12-08-2000).]

[bobDalgleish]

I got DBD::mysql to build, test and install. Here is the full sequence (please correct mistakes):

• Presuming you have downloaded and installed Mysql, you may need to run ranlib:
  su
  cd /usr/local/mysql
  ranlib libmysqlclient.a
  # ignore the empty file messages
  
• Download and install the GPL compression library from
  ftp://ftp.freesoftware.com/pub/infozip/zlib/zlib-1.1.3.tar.gz
  Just follow the instructions:
  ./configure
  make test
  su root
  make install
• Move to your directory for Msql-Mysql-modules-1.2215. Do
  perl Makefile.PL. Then run make.
• Fix up the bundle file so that it loads the compression library statically. Enter:
  cd mysql
  env LD_RUN_PATH="" cc -o ../blib/arch/auto/DBD/mysql/mysql.bundle -bundle -undefined suppress dbdimp.o mysql.o -L/usr/local/mysql/lib -lmysqlclient -L/usr/local/lib -lz
  cd ..
  
• Do the testing: make test
• Install the package: make install

Voila

[QUOTE]Originally posted by bobDalgleish:

3) If you then remove strto.o from the library (running ranlib on it again), the test gets a little farther, namely, that it cannot find _compress and _uncompress. To my mind, this means that the lack of Zlib libraries on my machine is the fault here.

How do you remove the strto.o library?

Kevin

[bobDalgleish]

How do you remove the strto.o library?

As root, do the following:
cd /usr/local/lib
ar xv libmysqlclient.a strto.o
ar dv libmysqlclient.a strto.o
ranlib libmysqlclient.a

This will leave the strto.o file lying around, just in case you need to put it back in.

Originally posted by bobDalgleish:
I got DBD::mysql to build, test and install. Here is the full sequence (please correct mistakes):

• Presuming you have downloaded and installed Mysql, you may need to run ranlib:
  su
  cd /usr/local/mysql
  ranlib libmysqlclient.a
  # ignore the empty file messages
  
• Download and install the GPL compression library from
  ftp://ftp.freesoftware.com/pub/infozip/zlib/zlib-1.1.3.tar.gz
  Just follow the instructions:
  ./configure
  make test
  su root
  make install
• Move to your directory for Msql-Mysql-modules-1.2215. Do
  perl Makefile.PL. Then run make.
• Fix up the bundle file so that it loads the compression library statically. Enter:
  cd mysql
  env LD_RUN_PATH="" cc -o ../blib/arch/auto/DBD/mysql/mysql.bundle -bundle -undefined suppress dbdimp.o mysql.o -L/usr/local/mysql/lib -lmysqlclient -L/usr/local/lib -lz
  cd ..
  
• Do the testing: make test
• Install the package: make install

Voila

After compiling w/ errors (I can't paste in the errors because I can't get as far as I did yesterday -- "perl Makefile.PL" no longer works) I get the following when trying to use DBI;


dyld: perl multiple definitions of symbol _strtol
/System/Library/Frameworks/System.framework/Versions/B/System(strtol.o) definition of _strtol
/Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of _strtol


Which is the same thing I get when I try to:
[localhost:local/src/Msql-Mysql-modules-1.2215] root# perl Makefile.PL

The only differences in my steps than those you posted were the dir in which mysql's lib files live and the dir in which mysql (and related programs) lives.

libs: /usr/local/lib/mysql
mysql: /usr/local/bin

Thanks for all your help Bob!

I have difficulties to install MySQL on Apache and PHP on MAC OS X
Would you help me

Sergio

[iloveOSX]

start with this serg:

updated double-clickable installer for MySQL 3.23.28 (Gamma) is available at http://www-u.life.uiuc.edu/~mwvaugh/MacOSX/Packages/.

[bobDalgleish]

I can't get as far as I did yesterday -- "perl Makefile.PL" no longer works

You likely have to start again:
make realclean
perl Makefile.PL
make
cd mysql
env LD_RUN_PATH="" cc -o ../blib/arch/auto/DBD/mysql/mysql.bundle -bundle -undefined suppress dbdimp.o mysql.o -L/usr/local/mysql/lib -lmysqlclient -L/usr/local/lib -lz
cd ..
make test
make install


Just remember that the terminal window has a HUGE scrollback, so it is pretty easy to work with - you can also log the terminal output to a file.

[anothermacguy]

Sorry Bob, I'm lost. Could you briefly outline what I should do after I install the package installer from Lightyear?

[bobDalgleish]

To recap:

• Download and install the mysql package.
• Fix the mysqlclient library problem -
  remove strto.a
  do the ranlib mysqlclient step
• Get mysql operational, per manual.html
• Download and install the compression library libz.a
• Download the DBD::mysql Perl package
• Run perl Makefile.PL
• Run make
• Fix the mysql.bundle file with the additional load step
• Then run make test
  make install

[anothermacguy]

Thanks Bob.

[bobDalgleish]

I have put up a detail page of the steps I went through (sans mistakes) to get mySQL and DBD::mysql operational on my Mac OS X installation.
http://invictus.usask.ca/macosx/

As always, feedback is welcome.

[genevish]

Also, anothermacguy's initial question said he wanted to administer his MySQL server. I'm not familiar with the cgi script mentioned, but phpMyAdmin works quite well.

-Scott

[anothermacguy]

Genevish, which should I download, the one with php3 extensions, or the one with just php extentions? Also, do I need to do all this DBD::MySQL stuff to get it working? Or will it work right after the Lightyear package install?

[anothermacguy]

Well, I hope its not the php3 one, because after installing that, all I got was a bunch of php code in my web browser. It didn't give any error, it just looked like it was printing the code. Wierd, any ideas? I'll post my experience with the php version (not php3) in a few minutes...

[anothermacguy]

Ok, the one with just the php extensions worked. And what a great script!!! Thank you so much, this is a thousand times better than the one I was trying to get going.

So what does this DBD::mysql module do? Should I get it going anyways. The only reason I was messing with it, was to get that other script going. Thanks a million!

[bobDalgleish]

The DBD::mysql module for Perl is necessary for running the benchmarks in sql-bench, plus there are a number of scripts in the mysql installation that use Perl, including some of the administrative packages.

I use DBD::mysql to experiment with database design for web pages. My current project is to take the 200+ messages a day that come to postmaster, and categorize them, and allow postmaster (me these days), to inspect such a large raft of stuff.

[anothermacguy]

Thanks Bob, I'm interested in web integration as well. I have worked with other sql databases, and have designed a few sites. I'm new to this mysql, php business though. Do you have any recommended readings on DBD::Mysql in particular? Is this something I can tackle now, or should I wait until I'm more familiar with php and mysql? Can I do any database integration without DBD::Mysql?

Thanks again.

[anothermacguy]

genevesh, do you have to enter the root username and pass into phpMyAdmin? What are the advantages/disadvantages?

[bobDalgleish]

I'm new to this mysql, php business though. Do you have any recommended readings on DBD::Mysql in particular? Is this something I can tackle now, or should I wait until I'm more familiar with php and mysql? Can I do any database integration without DBD::Mysql?

I have been using Perl DBI from O'Reilly&Associates, and MySQL by Paul DuBois (New Riders Publishing). I have been programming in Perl since the late 80's, and MacPerl since the early 90's - I maintained the MacPerl FAQ for a couple of years.
I have not used PHP so cannot really comment on it, except to say that it is a one-trick pony that is growing up to be a horse, while Perl is a mature camel capable of learning lots of new tricks (to hash my metaphors). Hence, I have little real interest in PHP.
My experience with DBMS is fairly prosaic. Other than designing an RDBMS for a real-time embedded system in the '80s, my main DB experience is Filemaker Pro.
Surely you can do database integration with just PHP; there are several other technologies that support SQL as well.
However, in my current project, I have Perl code that reads the mail (using the Mail:OP3Client and Mail::Header modules), extracts some info from the headers, stores the message in a database via DBI, along with the first cut, automatic analysis. Then, I will have a web interface to the database for the OLAP processing, again using Perl and DBI. Let's see you do that with PHP!?!

[This message has been edited by bobDalgleish (edited 12-13-2000).]

[This message has been edited by bobDalgleish (edited 12-14-2000).]

Thanks for your help Bob! It's all running great now. Now I can get to work!

I know that this stuff is a little outta my league but I succesfully installed the DBD::mysql bundle.

I had followed the instructions that I found here. 1 problem though. If you download the binary for mysql from one of the links on this page or if you install without specifying for the install to be done all in /usr/local/mysql, then you must change the following from the instructions here:

env LD_RUN_PATH="" cc -o ../blib/arch/auto/DBD/mysql/mysql.bundle -bundle -undefined suppress dbdimp.o mysql.o -L/usr/local/mysql/lib -lmysqlclient -L/usr/local/lib -lz

to

env LD_RUN_PATH="" cc -o ../blib/arch/auto/DBD/mysql/mysql.bundle -bundle -undefined suppress dbdimp.o mysql.o -L/usr/local/lib/mysql -lmysqlclient -L/usr/local/lib -lz

If you do not do this then it will just appear as though you did not properly install the zlib libraries. Which is a real hassle to track down.

My terminology may be a little off so I hope that you get the idea.

Without this board, I would never have gotten it installed, thanks.

[mlapera]

Originally posted by keston:
On the mysql downloads section, i see two versions listed. One for OS X Server (rhapsody), and one for OS X (darwin).

Does THIS one work on Mac OS X? Anyone had sucess with installing and setting up the one for osx/darwin?

--- http://www.mysql.com/downloads/mysql-3.23.html

Latest version is: 3.23.27-beta

Standard binary (tarball) distributions:

* MacOS X Server (PowerPC) [apple-rhapsody5.5-powerpc]
* HP-UX 10.20 [hp-hpux10.20-hppa1.1]
* HP-UX 11.00 [hp-hpux11.00-hppa2.0w]
* Linux (Intel libc6 systems) [pc-linux-gnu-i686]
* SGI Irix [sgi-irix6.5-mips]
* Sun Solaris (Sparc) [sun-solaris2.7-sparc]
* FreeBSD ELF (Intel) [unknown-freebsdelf4.1-i386]
* Linux (Alpha) [unknown-linux-gnu-alphaev6]
* Windows 95/98/NT/2000 (Intel)
* SCO UnixWare (Intel) [sco-sysv5uw7.1.0-i386-lcudk70]
* SCO UnixWare (Intel) [sco-sysv5uw7.1.0-i386]
* Linux (IA64) [unknown-linux-gnu-ia64]
* SCO OpenServer (Intel) [pc-sco3.2v5.0.5-i386]
* Sun Solaris (Intel) [pc-solaris2.7-i386]
* MacOS X (PowerPC) [apple-darwin1.2-powerpc]

[anothermacguy]

thanks for the quote

[Gee4orce]

I'm just floating this thread back to the top as it answers a question I recently posted. Will try Bob's instructions tonite to get this running.

TIA Bob !

[torifile]

I tried using the CPAN.pm to install the DBI and DBD modules. One of them failed (I can't remember which). Will that mess anything up for me in the future, if I endeavor to do this again? Also, what packages do I need to install to get Perl working with mysql? TIA.

[spcalia]

I tried what I the previous post says will work. Below is the result of make test. Is it just telling me that it can't open my test db?

[localhost:download/Msql-Mysql-modules-1.2215/mysql] root# env LD_RUN_PATH="" cc -o ../blib/arch/auto/DBD/mysql/mysql.bundle -bundle -undefined suppress dbdimp.o mysql.o -L/usr/local/lib -mysql -L/usr/local/lib -lz
[localhost:download/Msql-Mysql-modules-1.2215/mysql] root# cd ..
[localhost:spcalia/download/Msql-Mysql-modules-1.2215] root# make test
cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs
Manifying ../blib/man3/DBD::mysql.3
Manifying ../blib/man3/Bundle: BD::mysql.3
Manifying ../blib/man3/Mysql.3
mkdir blib/script
cp dbimon blib/script/dbimon
/usr/bin/perl -I/System/Library/Perl/darwin -I/System/Library/Perl -MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbimon
PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/System/Library/Perl/darwin -I/System/Library/Perl -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/00base............dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/00base............dubious
Test returned status 67 (wstat 17152, 0x4300)
t/10dsnlist.........dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/10dsnlist.........dubious
Test returned status 67 (wstat 17152, 0x4300)
t/20createdrop......dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/20createdrop......dubious
Test returned status 67 (wstat 17152, 0x4300)
t/30insertfetch.....dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/30insertfetch.....dubious
Test returned status 67 (wstat 17152, 0x4300)
t/40bindparam.......dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/40bindparam.......dubious
Test returned status 67 (wstat 17152, 0x4300)
t/40blobs...........dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/40blobs...........dubious
Test returned status 67 (wstat 17152, 0x4300)
t/40listfields......dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/40listfields......dubious
Test returned status 67 (wstat 17152, 0x4300)
t/40nulls...........dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/40nulls...........dubious
Test returned status 67 (wstat 17152, 0x4300)
t/40numrows.........dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/40numrows.........dubious
Test returned status 67 (wstat 17152, 0x4300)
t/50chopblanks......dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/50chopblanks......dubious
Test returned status 67 (wstat 17152, 0x4300)
t/50commit..........dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/50commit..........dubious
Test returned status 67 (wstat 17152, 0x4300)
t/60leaks...........skipped test on this platform
t/ak-dbd............dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/ak-dbd............dubious
Test returned status 67 (wstat 17152, 0x4300)
DIED. FAILED tests 1-90
Failed 90/90 tests, 0.00% okay
t/dbdadmin..........dyld: /usr/bin/perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
_mysql_drop_db
_mysql_eof
_mysql_errno
_mysql_error
_mysql_fetch_field
_mysql_fetch_lengths
_mysql_fetch_row
_mysql_field_seek
_mysql_free_result
_mysql_get_host_info
_mysql_get_proto_info
_mysql_get_server_info
_mysql_info
_mysql_init
_mysql_insert_id
_mysql_list_dbs
_mysql_list_fields
_mysql_list_tables
_mysql_num_fields
_mysql_num_rows
_mysql_options
_mysql_ping
_mysql_real_connect
_mysql_real_query
_mysql_refresh
_mysql_shutdown
_mysql_stat
_mysql_store_result
_mysql_thread_id
_mysql_use_result
t/dbdadmin..........dubious
Test returned status 67 (wstat 17152, 0x4300)
DIED. FAILED tests 1-20
Failed 20/20 tests, 0.00% okay
Failed Test Status Wstat Total Fail Failed List of failed
-------------------------------------------------------------------------------
t/00base.t 67 17152 ?? ?? % ??
t/10dsnlist.t 67 17152 ?? ?? % ??
t/20createdrop. 67 17152 ?? ?? % ??
t/30insertfetch 67 17152 ?? ?? % ??
t/40bindparam.t 67 17152 ?? ?? % ??
t/40blobs.t 67 17152 ?? ?? % ??
t/40listfields. 67 17152 ?? ?? % ??
t/40nulls.t 67 17152 ?? ?? % ??
t/40numrows.t 67 17152 ?? ?? % ??
t/50chopblanks. 67 17152 ?? ?? % ??
t/50commit.t 67 17152 ?? ?? % ??
t/ak-dbd.t 67 17152 90 90 100.00% 1-90
t/dbdadmin.t 67 17152 20 20 100.00% 1-20
1 test skipped.
Failed 13/14 test scripts, 7.14% okay. 110/110 subtests failed, 0.00% okay.
make[1]: *** [test_dynamic] Error 2
make: *** [test] Error 2

Thank you for your help!

[slur]

Wow, that's a long post.

[This message has been edited by slur (edited 04-18-2001).]

[bobDalgleish]

Originally posted by spcalia:
I tried what I the previous post says will work. Below is the result of make test. Is it just telling me that it can't open my test db?

...
Failed Test Status Wstat Total Fail Failed List of failed

Basically, you are not linked with the MySQL client library.

Follow my instructions at http://duke.usask.ca/~dalglb/macosx/

[6116]

I've been trying to get into cpan, but it keeps telling me there are too many users, or permission denied. I've tried perl -mcpan, command line ftp, and Fetch. The kicker is, though, when I telnet into any other machine, it works fine. What could the problem be?