MySQL Forums
Forum List  »  Perl

errors making DBD::mysql on AIX 5.2
Posted by: Robert Adam
Date: February 24, 2006 12:48PM

I'm trying to get an app running that makes a wget call to a remote server running mysql. To do this I'm trying to make DBD::mysql, which it tells me it needs. I've downloaded the mysql AIX binary and placed it in /usr/local/mysql, though I have not installed it. I don't want to run mysql on my server, it is running on the remote server.

So now I have the DBD::mysql code and the make is failing with undefined symbol errors. I've seen this very same post before, but haven't seen any resolutions provided. My PATH is good, and the linker is finding the libmysqlclient library, which is in /usr/local/mysql/lib.

Any/all insights are appreciated.

Here is the output from the perl Makefile.PL and make commands.....

/tmp/.cpan/build/DBD-mysql-3.0002 # perl Makefile.PL



$ENV{LANG} is not 'C' execing 'perl Makefile.PL' with ENV{LANG} == 'C'
You can skip this check by: 'export LANG='C' before running 'perl Makefile.PL or by upgrading your Perl'


I will use the following settings for compiling and testing:

cflags (mysql_config) = -I/usr/local/mysql/include -q64 -ma -qstrict -qoptimize=2 -qmaxmem=8192
embedded (mysql_config) =
libs (mysql_config) = -L/usr/local/mysql/lib -lmysqlclient -lz -lcrypt -lnsl_r -lm
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Using DBI 1.50 (for perl 5.008 on aix-thread-multi) installed in /usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/
Writing Makefile for DBD::mysql


/tmp/.cpan/build/DBD-mysql-3.0002 # make
cc_r -c -I/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/ -I/usr/local/mysql/include -q64 -ma -qstrict -qoptimize=2 -qmaxmem=8192 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"3.0002\" -DXS_VERSION=\"3.0002\" "-I/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE" dbdimp.c
cc_r -c -I/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/ -I/usr/local/mysql/include -q64 -ma -qstrict -qoptimize=2 -qmaxmem=8192 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"3.0002\" -DXS_VERSION=\"3.0002\" "-I/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE" mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/local/mysql/lib:/lib" /usr/opt/perl5/bin/perl myld ld -bhalt:4 -bM:SRE -bI:/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE/perl.exp -bE:mysql.exp -bnoentry -lpthreads -lc_r dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/local/mysql/lib -lmysqlclient -lz -lcrypt -lnsl_r -lm
ld: 0711-317 ERROR: Undefined symbol: .mysql_field_seek
ld: 0711-317 ERROR: Undefined symbol: .mysql_fetch_field
ld: 0711-317 ERROR: Undefined symbol: .mysql_fetch_fields
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_bind_result
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_errno
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_error
ld: 0711-317 ERROR: Undefined symbol: .mysql_real_escape_string
ld: 0711-317 ERROR: Undefined symbol: .mysql_errno
ld: 0711-317 ERROR: Undefined symbol: .mysql_error
ld: 0711-317 ERROR: Undefined symbol: .mysql_init
ld: 0711-317 ERROR: Undefined symbol: .mysql_real_connect
ld: 0711-317 ERROR: Undefined symbol: .mysql_options
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_bind_param
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_execute
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_result_metadata
ld: 0711-317 ERROR: Undefined symbol: .mysql_num_rows
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_store_result
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_num_rows
ld: 0711-317 ERROR: Undefined symbol: .mysql_free_result
ld: 0711-317 ERROR: Undefined symbol: .mysql_list_fields
ld: 0711-317 ERROR: Undefined symbol: .mysql_real_query
ld: 0711-317 ERROR: Undefined symbol: .mysql_use_result
ld: 0711-317 ERROR: Undefined symbol: .mysql_affected_rows
ld: 0711-317 ERROR: Undefined symbol: .mysql_store_result
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_close
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_fetch
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_affected_rows
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_fetch_column
ld: 0711-317 ERROR: Undefined symbol: .mysql_fetch_row
ld: 0711-317 ERROR: Undefined symbol: .mysql_fetch_lengths
ld: 0711-317 ERROR: Undefined symbol: .mysql_num_fields
ld: 0711-317 ERROR: Undefined symbol: .mysql_insert_id
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_init
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_prepare
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_param_count
ld: 0711-317 ERROR: Undefined symbol: .mysql_get_host_info
ld: 0711-317 ERROR: Undefined symbol: .mysql_info
ld: 0711-317 ERROR: Undefined symbol: .mysql_get_proto_info
ld: 0711-317 ERROR: Undefined symbol: .mysql_get_server_info
ld: 0711-317 ERROR: Undefined symbol: .mysql_stat
ld: 0711-317 ERROR: Undefined symbol: .mysql_thread_id
ld: 0711-317 ERROR: Undefined symbol: .mysql_autocommit
ld: 0711-317 ERROR: Undefined symbol: .mysql_close
ld: 0711-317 ERROR: Undefined symbol: .mysql_rollback
ld: 0711-317 ERROR: Undefined symbol: .mysql_commit
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_free_result
ld: 0711-317 ERROR: Undefined symbol: .is_prefix
ld: 0711-317 ERROR: Undefined symbol: .mysql_get_parameters
ld: 0711-317 ERROR: Undefined symbol: .mysql_stmt_data_seek
ld: 0711-317 ERROR: Undefined symbol: .mysql_data_seek
ld: 0711-317 ERROR: Undefined symbol: .mysql_ping
ld: 0711-317 ERROR: Undefined symbol: .mysql_list_dbs
ld: 0711-317 ERROR: Undefined symbol: .mysql_shutdown
ld: 0711-317 ERROR: Undefined symbol: .mysql_refresh
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
make: 1254-004 The error code from the last command is 1.


Stop.
/tmp/.cpan/build/DBD-mysql-3.0002 #


Thanks,

Robert Adam

Options: ReplyQuote


Subject
Written By
Posted
errors making DBD::mysql on AIX 5.2
February 24, 2006 12:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.