Skip Menu |

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

Report information
The Basics
Id: 83664
Status: rejected
Priority: 0/
Queue: DBD-mysql

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

Bug Information
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 Show quoted text
>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. Show quoted text
mysql> grant all privileges on test.* to 'xbhatad'@'localhost'
Show quoted text
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 Show quoted text
>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 Show quoted text
>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' Show quoted text
>My distribution name is
DBD-mysql-4.018 Show quoted text
>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) Show quoted text
>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

Message body is not shown because it is too large.

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