Re^2: DBD::Mysql not working properly in mac OS X

[romy_mathew]

Below is the report i get on perl -V

perl -V
Summary of my perl5 (revision 5 version 12 subversion 4) configuration
+:
   
  Platform:
    osname=darwin, osvers=12.0, archname=darwin-thread-multi-2level
    uname='darwin b1026.apple.com 12.0 darwin kernel version 12.0.0: t
+ue may 15 23:31:29 pdt 2012; root:xnu-2050.6.70~1release_x86_64 x86_6
+4 '
    config_args='-ds -e -Dprefix=/usr -Dccflags=-g  -pipe  -Dldflags= 
+-Dman3ext=3pm -Duseithreads -Duseshrplib -Dinc_version_list=none -Dcc
+=clang'
    hint=recommended, useposix=true, d_sigaction=define
    useithreads=define, usemultiplicity=define
    useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=und
+ef
    use64bitint=define, use64bitall=define, uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='clang', ccflags ='-arch i386 -arch x86_64 -g -pipe -fno-common
+ -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -I/usr/local/in
+clude',
    optimize='-Os',
    cppflags='-g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing 
+-fstack-protector -I/usr/local/include'
    ccversion='', gccversion='4.2.1 Compatible Apple Clang 4.0 (tags/A
+pple/clang-418.0.60)', gccosandvers=''
    intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=1
+6
    ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
+ lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='clang -mmacosx-version-min=10.8', ldflags ='-arch i386 -arch x
+86_64 -fstack-protector -L/usr/local/lib'
    libpth=/usr/local/lib /usr/lib
    libs=-ldbm -ldl -lm -lutil -lc
    perllibs=-ldl -lm -lutil -lc
    libc=, so=dylib, useshrplib=true, libperl=libperl.dylib
    gnulibc_version=''
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=bundle, d_dlsymun=undef, ccdlflags=' '
    cccdlflags=' ', lddlflags='-arch i386 -arch x86_64 -bundle -undefi
+ned dynamic_lookup -L/usr/local/lib -fstack-protector'


Characteristics of this binary (from libperl): 
  Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
                        PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP USE_64_
+BIT_ALL
                        USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES
                        USE_PERLIO USE_PERL_ATOF USE_REENTRANT_API
  Locally applied patches:
    /Library/Perl/Updates/<version> comes before system perl directori
+es
    installprivlib and installarchlib points to the Updates directory
  Built under darwin
  Compiled at Jun 20 2012 13:55:28
  @INC:
    /Library/Perl/5.12/darwin-thread-multi-2level
    /Library/Perl/5.12
    /Network/Library/Perl/5.12/darwin-thread-multi-2level
    /Network/Library/Perl/5.12
    /Library/Perl/Updates/5.12.4/darwin-thread-multi-2level
    /Library/Perl/Updates/5.12.4
    /System/Library/Perl/5.12/darwin-thread-multi-2level
    /System/Library/Perl/5.12
    /System/Library/Perl/Extras/5.12/darwin-thread-multi-2level
    /System/Library/Perl/Extras/5.12

[romy_mathew]

in location /System/Library/perl
i see 2 version, 5.10 and 5.12.

[tangent]

I am assuming that your script does work when called from the terminal, but you get an error when you call it from the browser.

If that is the case then try changing the first line of your script to:

#!/usr/bin/perl5.12.4

Also, to see any errors, add these lines directly after the first line:

use CGI::Carp('fatalsToBrowser');
print "Content-type:text/html\n\n";

[romy_mathew]

below is the error when i used use::Carp

install_driver(mysql) failed: Can't load '/Library/Perl/5.12/darwin-th
+read-multi-2level/auto/DBD/mysql/mysql.bundle' for module DBD::mysql:
+ dlopen(/Library/Perl/5.12/darwin-thread-multi-2level/auto/DBD/mysql/
+mysql.bundle, 1): Library not loaded: libmysqlclient.18.dylib
  Referenced from: /Library/Perl/5.12/darwin-thread-multi-2level/auto/
+DBD/mysql/mysql.bundle
  Reason: image not found at /System/Library/Perl/5.12/darwin-thread-m
+ulti-2level/DynaLoader.pm line 204.
 at (eval 10) line 3
Compilation failed in require at (eval 10) line 3.
Perhaps a required shared library or dll isn't installed where expecte
+d
 at /Library/WebServer/CGI-Executables/hello.pl line 22

I tried #!/usr/bin/perl5.12.4 failed with html error 500

[romy_mathew]

I come across a blog http://probably.co.uk/problems-installing-dbdmysql-on-os-x-snow-leopard.html
where it hoghlight the error as the library libmysqlclient.18.dylib not able to find the path and i copied the file libmysqlclient.18.dylib from /usr/local/mysql-5.6.14-osx10.7-x86_64/lib/ to /usr/lib and it just worked.
Thanks everyone for the support and the suggestion.

[Anonymous Monk]

Funny :) Re^3: DBD::mysql fail install check