Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id:
83664
Status:
rejected
Priority:
Low/Low
Queue:

People
Owner:
MICHIELB [...] cpan.org
Requestors:
bhargava.x.tadi [...] ericsson.com
Cc:
AdminCc:

BugTracker
Severity:
(no value)
Broken in:
(no value)
Fixed in:
(no value)



Subject: Reg: Unable to install DBD::mysql perl module on solaris 10
Date: Wed, 27 Feb 2013 13:45:51 +0000
To: "bug-DBD-mysql@rt.cpan.org" <bug-DBD-mysql@rt.cpan.org>
From: Bhargava Tadi X <bhargava.x.tadi@ericsson.com>

Dear Team,

 

I am trying to install DBD::mysql perl module in solaris 10 machine but I am getting below problems when I tried to run make file.

 

I am using following settings with Makefile.pl

 

>perl Makefile.PL

 

 

PLEASE NOTE:

 

For 'make test' to run properly, you must ensure that the database user 'xbhatad' can connect to your MySQL server and has the proper privileges that these tests require such as 'drop table', 'create table', 'drop procedure', 'create procedure'

as well as others.

 

mysql> grant all privileges on test.* to 'xbhatad'@'localhost'

mysql> identified by 's3kr1t';

 

You can also optionally set the user to run 'make test' with:

 

perl Makefile.PL --testuser=username

 

I will use the following settings for compiling and testing:

 

  cflags        (mysql_config) = -I/usr/sfw/include/mysql -xstrconst -mt

  embedded      (mysql_config) =

  ldflags       (mysql_config) = -R/usr/sfw/lib -R/usr/sfw/lib/mysql

  libs          (mysql_config) = -L/usr/sfw/lib -L/usr/sfw/lib/mysql -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -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      (guessed     ) = xbhatad

 

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

 

Using DBI 1.56 (for perl 5.008008 on sun4-solaris-thread-multi) installed in /vobs/cello/cade_struct/tools/perl/SunOS/sparc/lib/site_perl/5.8.8/sun4-solaris-thread-multi/auto/DBI/

Writing Makefile for DBD::mysql

>make

Skip blib/lib/DBD/mysql.pm (unchanged)

Skip blib/lib/DBD/mysql/GetInfo.pm (unchanged) Skip blib/lib/DBD/mysql/INSTALL.pod (unchanged) Skip blib/lib/Bundle/DBD/mysql.pm (unchanged)

gcc -c  -I/vobs/cello/cade_struct/tools/perl/SunOS/sparc/lib/site_perl/5.8.8/sun4-solaris-thread-multi/auto/DBI -I/usr/sfw/include/mysql -xstrconst -mt -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -D_REENTRANT -fno-strict-aliasing -pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O   -DVERSION=\"4.022\" -DXS_VERSION=\"4.022\" -fPIC "-I/vobs/cello/cade_struct/tools/perl/SunOS/sparc/lib/5.8.8/sun4-solaris-thread-multi/CORE"   dbdimp.c

gcc: language strconst not recognized

gcc: language strconst not recognized

gcc: dbdimp.c: linker input file unused because linking not done

gcc -c  -I/vobs/cello/cade_struct/tools/perl/SunOS/sparc/lib/site_perl/5.8.8/sun4-solaris-thread-multi/auto/DBI -I/usr/sfw/include/mysql -xstrconst -mt -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -D_REENTRANT -fno-strict-aliasing -pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O   -DVERSION=\"4.022\" -DXS_VERSION=\"4.022\" -fPIC "-I/vobs/cello/cade_struct/tools/perl/SunOS/sparc/lib/5.8.8/sun4-solaris-thread-multi/CORE"   mysql.c

gcc: language strconst not recognized

gcc: language strconst not recognized

gcc: mysql.c: linker input file unused because linking not done Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH="/usr/sfw/lib:/usr/lib" /vobs/cello/cade_struct/SunOS/sparc/bin/perl myld gcc  -G -L/usr/local/lib -L/opt/local/lib dbdimp.o mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so  \

   -L/usr/sfw/lib -L/usr/sfw/lib/mysql -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm      \

 

gcc: dbdimp.o: No such file or directory

gcc: mysql.o: No such file or directory

make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1

 

 

>perl -V

Summary of my perl5 (revision 5 version 8 subversion 8) configuration:

  Platform:

    osname=solaris, osvers=2.8, archname=sun4-solaris-thread-multi

    uname='sunos ws11772 5.8 generic_117350-39 sun4u sparc sunw,sun-blade-1500 '

    config_args='-Dcc=gcc -Dprefix=/vobs/cello/cade_struct/tools/perl/SunOS/sparc -Dusethreads'

    hint=recommended, useposix=true, d_sigaction=define

    usethreads=define use5005threads=undef useithreads=define usemultiplicity=define

    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef

    use64bitint=undef use64bitall=undef uselongdouble=undef

    usemymalloc=n, bincompat5005=undef

  Compiler:

    cc='gcc', ccflags ='-D_REENTRANT -fno-strict-aliasing -pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',

    optimize='-O',

    cppflags='-D_REENTRANT -fno-strict-aliasing -pipe -Wdeclaration-after-statement'

    ccversion='', gccversion='3.4.2', gccosandvers='solaris2.8'

    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321

   d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16

    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8

    alignbytes=8, prototype=define

  Linker and Libraries:

    ld='gcc', ldflags =' -L/usr/local/lib -L/opt/local/lib '

    libpth=/usr/local/lib /opt/local/lib /usr/lib /usr/ccs/lib

    libs=-lsocket -lnsl -ldl -lm -lpthread -lc

    perllibs=-lsocket -lnsl -ldl -lm -lpthread -lc

    libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a

    gnulibc_version=''

  Dynamic Linking:

    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '

    cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib -L/opt/local/lib'

 

>My distribution name is

DBD-mysql-4.018

 

>My sql version is

/usr/sfw/bin/mysql -V

/usr/sfw/bin/mysql  Ver 12.22 Distrib 4.0.31, for sun-solaris2.10 (sparc)

 

>uname -a

SunOS esekits3505 5.10 Generic_142909-17 sun4u sparc SUNW,SPARC-Enterprise

 

Please let me know if the problem exists with sql version. I found one article from mysql bugs site, as problem exists with mysql  4.0 version. (http://bugs.mysql.com/bug.php?id=27945) .

 

Best Regards,

Bhargava Tadi

 

Sorry for the late reply, but if you want to build DBD::mysql you'll need to have the libmysqlcient header files on your system. In your case, you don't seem to have these:
Show quoted text
> gcc: dbdimp.o: No such file or directory > > gcc: mysql.o: No such file or directory
I hope this helps, somewhat :D -- Michiel On Wed Feb 27 08:46:08 2013, bhargava.x.tadi@ericsson.com wrote:
Show quoted text
> Dear Team, > > > > I am trying to install DBD::mysql perl module in solaris 10 machine > but I am getting below problems when I tried to run make file. > > > > I am using following settings with Makefile.pl > > >
> > perl Makefile.PL
> > > > > > PLEASE NOTE: > > > > For 'make test' to run properly, you must ensure that the database > user 'xbhatad' can connect to your MySQL server and has the proper > privileges that these tests require such as 'drop table', 'create > table', 'drop procedure', 'create procedure' > > as well as others. > > >
> mysql> grant all privileges on test.* to 'xbhatad'@'localhost'
>
> mysql> identified by 's3kr1t';
> > > > You can also optionally set the user to run 'make test' with: > > > > perl Makefile.PL --testuser=username > > > > I will use the following settings for compiling and testing: > > > > cflags (mysql_config) = -I/usr/sfw/include/mysql -xstrconst -mt > > embedded (mysql_config) = > > ldflags (mysql_config) = -R/usr/sfw/lib -R/usr/sfw/lib/mysql > > libs (mysql_config) = -L/usr/sfw/lib -L/usr/sfw/lib/mysql > -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -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 (guessed ) = xbhatad > > > > To change these settings, see 'perl Makefile.PL --help' and 'perldoc > INSTALL'. > > > > Using DBI 1.56 (for perl 5.008008 on sun4-solaris-thread-multi) > installed in > /vobs/cello/cade_struct/tools/perl/SunOS/sparc/lib/site_perl/5.8.8/sun4- > solaris-thread-multi/auto/DBI/ > > Writing Makefile for DBD::mysql >
> > make
> > Skip blib/lib/DBD/mysql.pm (unchanged) > > Skip blib/lib/DBD/mysql/GetInfo.pm (unchanged) Skip > blib/lib/DBD/mysql/INSTALL.pod (unchanged) Skip > blib/lib/Bundle/DBD/mysql.pm (unchanged) > > gcc -c > -I/vobs/cello/cade_struct/tools/perl/SunOS/sparc/lib/site_perl/5.8.8/sun4- > solaris-thread-multi/auto/DBI -I/usr/sfw/include/mysql -xstrconst -mt > -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -fno-strict-aliasing > -pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE > -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"4.022\" -DXS_VERSION=\"4.022\" > -fPIC "- > I/vobs/cello/cade_struct/tools/perl/SunOS/sparc/lib/5.8.8/sun4- > solaris-thread-multi/CORE" dbdimp.c > > gcc: language strconst not recognized > > gcc: language strconst not recognized > > gcc: dbdimp.c: linker input file unused because linking not done > > gcc -c > -I/vobs/cello/cade_struct/tools/perl/SunOS/sparc/lib/site_perl/5.8.8/sun4- > solaris-thread-multi/auto/DBI -I/usr/sfw/include/mysql -xstrconst -mt > -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -fno-strict-aliasing > -pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE > -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"4.022\" -DXS_VERSION=\"4.022\" > -fPIC "- > I/vobs/cello/cade_struct/tools/perl/SunOS/sparc/lib/5.8.8/sun4- > solaris-thread-multi/CORE" mysql.c > > gcc: language strconst not recognized > > gcc: language strconst not recognized > > gcc: mysql.c: linker input file unused because linking not done > Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f > blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH="/usr/sfw/lib:/usr/lib" > /vobs/cello/cade_struct/SunOS/sparc/bin/perl myld gcc -G > -L/usr/local/lib -L/opt/local/lib dbdimp.o mysql.o -o > blib/arch/auto/DBD/mysql/mysql.so \ > > -L/usr/sfw/lib -L/usr/sfw/lib/mysql -lmysqlclient -lz -lposix4 -lcrypt > -lgen -lsocket -lnsl -lm \ > > > > gcc: dbdimp.o: No such file or directory > > gcc: mysql.o: No such file or directory > > make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1 > > > > >
> > perl -V
> > Summary of my perl5 (revision 5 version 8 subversion 8) configuration: > > Platform: > > osname=solaris, osvers=2.8, archname=sun4-solaris-thread-multi > > uname='sunos ws11772 5.8 generic_117350-39 sun4u sparc sunw,sun-blade- > 1500 ' > > config_args='-Dcc=gcc > -Dprefix=/vobs/cello/cade_struct/tools/perl/SunOS/sparc -Dusethreads' > > hint=recommended, useposix=true, d_sigaction=define > > usethreads=define use5005threads=undef useithreads=define > usemultiplicity=define > > useperlio=define d_sfio=undef uselargefiles=define usesocks=undef > > use64bitint=undef use64bitall=undef uselongdouble=undef > > usemymalloc=n, bincompat5005=undef > > Compiler: > > cc='gcc', ccflags ='-D_REENTRANT -fno-strict-aliasing -pipe > -Wdeclaration-after-statement -D_LARGEFILE_SOURCE > -D_FILE_OFFSET_BITS=64', > > optimize='-O', > > cppflags='-D_REENTRANT -fno-strict-aliasing -pipe -Wdeclaration-after- > statement' > > ccversion='', gccversion='3.4.2', gccosandvers='solaris2.8' > > intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321 > > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 > > ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', > lseeksize=8 > > alignbytes=8, prototype=define > > Linker and Libraries: > > ld='gcc', ldflags =' -L/usr/local/lib -L/opt/local/lib ' > > libpth=/usr/local/lib /opt/local/lib /usr/lib /usr/ccs/lib > > libs=-lsocket -lnsl -ldl -lm -lpthread -lc > > perllibs=-lsocket -lnsl -ldl -lm -lpthread -lc > > libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a > > gnulibc_version='' > > Dynamic Linking: > > dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' ' > > cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib -L/opt/local/lib' > > >
> > My distribution name is
> > DBD-mysql-4.018 > > >
> > My sql version is
> > /usr/sfw/bin/mysql -V > > /usr/sfw/bin/mysql Ver 12.22 Distrib 4.0.31, for sun-solaris2.10 > (sparc) > > >
> > uname -a
> > SunOS esekits3505 5.10 Generic_142909-17 sun4u sparc SUNW,SPARC- > Enterprise > > > > Please let me know if the problem exists with sql version. I found one > article from mysql bugs site, as problem exists with mysql 4.0 > version. (http://bugs.mysql.com/bug.php?id=27945) . > > Best Regards, > Bhargava Tadi


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.