On Wed, 24 Oct 2001, Scott Powell wrote:
> Hello all,
> I'm the poor guy trying to get Perl talking to a MySQL database on SCO
> OpenServer 5.0.5. I've managed to get the binary distributions of MySQL
> 3.23.43 working, as well as DBI-1.20 installed. However, I cannot get
> the MySQL driver working. It compiles, but the 'make test' returns the
> following:
I have found the best solution is to compile your own perl using gcc
and then edit the files as described below as I posted to...
>From [EMAIL PROTECTED] Wed Oct 24 10:42:49 2001
Date: Tue, 9 Oct 2001 15:53:35 -0600 (MDT)
From: Boyd Lynn Gerber <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Msql-Mysql-modules-1.2216 missing symbols problem solved...
__deregister_frame_info
I finally tracked down what was missing trying to get this to compile with
SCO OpenServer 5.0.X with mysql and gcc.
t/00base............install_driver(mysql) failed: Can't load
'../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: dynamic linker:
/usr/bin/perl:
relocation error: symbol not found: __deregister_frame_info at
/usr/lib/perl5/5.6.0/i486-pc-sco3.2v5.0/DynaLoader.pm line 200.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/00base.t line 38
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
This symbol is in the -lgthreads library so after you have done a
perl Makefile.PL
You need to cd to the mysql and edit the Makefile add -lgthreads to these
two below.
EXTRALIBS = -L/usr/local/mysql/lib/mysql -lgthreads -lmysqlclient -lm -lz
-L/usr/local/gcc-2.95.3/lib/gcc-lib/i386-pc-sco3.2v5.0.6/2.95.3 -lgcc
LDLOADLIBS = -L/usr/local/mysql/lib/mysql -lgthreads -lmysqlclient -lm -lz
-L/usr/local/gcc-2.95.3/lib/gcc-lib/i386-pc-sco3.2v5.0.6/2.95.3 -lgcc
This may also be needed.
Perl 5.005_03 builds cleanly with OSR 5.0.5 cc. Make sure you have
installed rs505a, oss497a, and oss499a. I have found you need
ftp://ftp.zenez.com/pub/zenez/perl5/h2ph.PL. This file needs to be placed
in the utils directory instead of the one there. Then do a perl h2ph.PL
and copy the file to /usr/local/bin.
I have found that this patch to Config.pm in
/usr/local/lib/perl5/5.00503/i386-sco/Config.pm
will allow a person to build perl with SCO cc and then use gcc to build
all the other modules. This is needed for MySQL. The SCO cc will not work
with MySQL. The patch is at
ftp://ftp.zenez.com/pub/zenez/perl5/Config.pm.patch .
Good Luck,
--
Boyd Gerber <[EMAIL PROTECTED]>
ZENEZ 3748 Valley Forge Road, Magna Utah 84044
Office 801-250-0795 FAX 801-250-7975
--
Boyd Gerber <[EMAIL PROTECTED]>
ZENEZ 3748 Valley Forge Road, Magna Utah 84044
Office 801-250-0795 FAX 801-250-7975
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
