CGI/Perl Guide | Learning Center | Forums | Advertise | Login Site Search: in Perl Guide PerlGuru Forums Learning Ctr

	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	LOG IN

Home: General Discussions: General Questions: Error Installing mysql module

robertcr New User Aug 5, 2011, 2:02 PM Post #1 of 2 (5207 views) Error Installing mysql module Can't Post Hi I'm installing mysql perl module on my server. but i have the following error: [root@monitoreo]#uname -a SunOS monitoreo 5.10 Generic_144488-04 sun4v sparc SUNW,Sun-Fire-T1000 [root@monitoreo]# cpan[1]> i /DBD-mysql/ Going to read '/.cpan/Metadata' Database was generated on Fri, 05 Aug 2011 04:32:14 GMT Distribution CAPTTOFU/DBD-mysql-3.0008.tar.gz Distribution CAPTTOFU/DBD-mysql-4.019.tar.gz Distribution GRISHACE/DBD-mysql-AutoTypes-1.0.tar.gz Distribution LINNIN/DBD-mysql-SimpleMySQL-0.5.tar.gz Distribution OYAMA/DBD-mysqlPP-0.04.tar.gz 5 items found cpan[2]> install CAPTTOFU/DBD-mysql-4.019.tar.gz Running make for C/CA/CAPTTOFU/DBD-mysql-4.019.tar.gz CPAN: checksum security checks disabled because Digest::SHA not installed. Please consider installing the Digest::SHA module. WARNING: Many CPAN distributions were archived with GNU tar and some of them may be incompatible with Solaris tar. We respectfully suggest you configure CPAN to use a GNU tar instead ("o conf init tar") or install a recent Archive::Tar instead; CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-4.019.tar.gz PLEASE NOTE: For 'make test' to run properly, you must ensure that the database user '' 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 ''@'localhost' 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/opt/mysql/mysql/include -m64 -KPIC -g -mt embedded (mysql_config) = libs (mysql_config) = -L/opt/mysql/mysql/lib -lmysqlclient -lthread -lsocket -lnsl -lm -lrt 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 ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Using DBI 1.58 (for perl 5.008004 on sun4-solaris-64int) installed in /usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int/auto/DBI/ Writing Makefile for DBD::mysql Writing MYMETA.yml and MYMETA.json cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cc -c -I/usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int/auto/DBI -I/opt/mysql/mysql/include -m64 -KPIC -g -mt -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3 -xspace -xildoff -DVERSION=\"4.019\" -DXS_VERSION=\"4.019\" -KPIC "-I/usr/perl5/5.8.4/lib/sun4-solaris-64int/CORE" dbdimp.c /usr/ucb/cc: language optional software package not installed *** Error code 1 make: Fatal error: Command failed for target `dbdimp.o' CAPTTOFU/DBD-mysql-4.019.tar.gz /usr/ccs/bin/make -- NOT OK Running make test Can't test without successful make Running make install Make had returned bad status, install seems impossible Failed during this command: CAPTTOFU/DBD-mysql-4.019.tar.gz : make NO cpan[3]> could someone help me with this issue Thanks

robertcr New User Aug 8, 2011, 10:18 AM Post #2 of 2 (5100 views) Re: [robertcr] Error Installing mysql module [In reply to] Can't Post Greetings. Now, I have the following erro when I compiled this. ld: fatal: file dbdimp.o: wrong ELF class: ELFCLASS64 Any suggestion? Thanks This is the code: [root@monitoreo]#/usr/local/bin/perl Makefile.PL --libs="-L/opt/mysql/mysql/lib -lmysqlclient -lthread -lsocket -lnsl -lm -lrt" --cflags="-I/opt/mysql/mysql/include -m64 -g" PLEASE NOTE: For 'make test' to run properly, you must ensure that the database user '' 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 ''@'localhost' 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 (User's choice) = -I/opt/mysql/mysql/include -m64 -g embedded (mysql_config ) = libs (User's choice) = -L/opt/mysql/mysql/lib -lmysqlclient -lthread -lsocket -lnsl -lm -lrt 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 ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Using DBI 1.616 (for perl 5.008008 on sun4-solaris) installed in /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/ Writing Makefile for DBD::mysql Writing MYMETA.yml and MYMETA.json [root@monitoreo]#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/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI -I/opt/mysql/mysql/include -m64 -g -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -I/opt/gnu/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"4.019\" -DXS_VERSION=\"4.019\" -fPIC "-I/usr/local/lib/perl5/5.8.8/sun4-solaris/CORE" dbdimp.c dbdimp.c: In function `alloc_param': dbdimp.c:223: warning: comparison is always false due to limited range of data type dbdimp.c: In function `alloc_bind': dbdimp.c:241: warning: comparison is always false due to limited range of data type dbdimp.c: In function `alloc_fbind': dbdimp.c:257: warning: comparison is always false due to limited range of data type dbdimp.c: In function `alloc_fbuffer': dbdimp.c:272: warning: comparison is always false due to limited range of data type /usr/local/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/Driver.xst > mysql.xsi /usr/local/bin/perl /usr/local/lib/perl5/5.8.8/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.8/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 242 Warning: duplicate function definition 'rows' detected in mysql.xs, line 749 gcc -c -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI -I/opt/mysql/mysql/include -m64 -g -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -I/opt/gnu/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"4.019\" -DXS_VERSION=\"4.019\" -fPIC "-I/usr/local/lib/perl5/5.8.8/sun4-solaris/CORE" mysql.c mysql.xs: In function `XS_DBD__mysql__db__ListDBs': mysql.xs:221: warning: ISO C90 forbids mixed declarations and code mysql.xs: In function `XS_DBD__mysql__db_do': mysql.xs:363: warning: comparison is always false due to limited range of data type mysql.xs:364: warning: comparison is always false due to limited range of data type mysql.xs: In function `XS_DBD__mysql__db_quote': mysql.xs:610: warning: ISO C90 forbids mixed declarations and code Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH="/opt/mysql/mysql/lib:/usr/lib" /usr/local/bin/perl myld gcc -G -L/usr/local/lib -L/opt/gnu/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so \ -L/opt/mysql/mysql/lib -lmysqlclient -lthread -lsocket -lnsl -lm -lrt \ ld: fatal: file dbdimp.o: wrong ELF class: ELFCLASS64 ld: fatal: File processing errors. No output written to blib/arch/auto/DBD/mysql/mysql.so collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `blib/arch/auto/DBD/mysql/mysql.so' In Reply To

Announcements     PerlGuru Announcements Perl Programming Help     Frequently Asked Questions     Beginner     Intermediate     Advanced     Regular Expressions     mod_perl     DBI     Win32 Programming Help Fun With Perl     Perl Quizzes - Learn Perl the Fun Way     Perl Golf     Perl Poetry Need a Custom or Prewritten Perl Program?     I need a program that...     I Need a Programmer for Freelance Work     Throw Down The Gauntlet General Discussions     General Questions     Feedback     Tutorial/Article Suggestions for The Learning Cent     Internet Security Other Programming Languages     Javascript     PHP

Search this forum this category all forums for All words Any words Whole Phrase (options)

Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives