Error while Installing DBD::Mysql Perl Module
Hello All, I am facing problem in installing DBD::Mysql Perl module, I am installing in MAC OS X, the error message details are as follow: First i ran the Makefile.pl command, i got the below message sudo perl Makefile.pl PLEASE NOTE: For 'make test' to run properly, you must ensure that the database user 'root' 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 'root'@'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/usr/include -fno-omit-frame-pointer -pipe -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT embedded (mysql_config) = libs (mysql_config) = -pipe -L/usr/lib -lmysqlclient -lz -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 ) = root To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Unrecognized argument in LIBS ignored: '-pipe' Note (probably harmless): No library found for -lmysqlclient Multiple copies of Driver.xst found in: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI/ /System/Library/Perl/Extras/5.10.0/darwin-thread-multi-2level/auto/DBI/ at Makefile.pl line 907 Using DBI 1.613 (for perl 5.010000 on darwin-thread-multi-2level) installed in /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI/ Writing Makefile for DBD::mysql 2. After that i ran the command to build the DBD::Mysql perl module, the error message is as below
sudo 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-4.2 -c -I/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI -I/usr/include -fno-omit-frame-pointer -pipe -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -arch x86_64 -arch i386 -arch ppc -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -I/usr/local/include -Os -DVERSION=\"4.017\" -DXS_VERSION=\"4.017\" "-I/System/Library/Perl/5.10.0/darwin-thread-multi-2level/CORE" dbdimp.c In file included from dbdimp.c:20: dbdimp.c:4696: warning: passing argument 3 of '__inline_memcpy_chk' makes integer from pointer without a cast dbdimp.c:4697: error: 'imp_dbh_t' has no member named 'stats' dbdimp.c:4697: error: request for member 'auto_reconnects_failed' in something not a structure or union dbdimp.c:4697: error: lvalue required as increment operand dbdimp.c:4697: error: lvalue required as increment operand dbdimp.c:4706: error: 'imp_dbh_t' has no member named 'stats' dbdimp.c:4706: error: request for member 'auto_reconnects_ok' in something not a structure or union dbdimp.c:4706: error: lvalue required as increment operand dbdimp.c:4706: error: lvalue required as increment operand dbdimp.c: In function 'mysql_db_quote': dbdimp.c:4866: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c: In function 'mysql_db_last_insert_id': dbdimp.c:4889: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:4889: warning: passing argument 2 of 'Perl_sv_2mortal' makes pointer from integer without a cast lipo: can't open input file: /var/tmp//ccgfQ9H6.out (No such file or directory) make: *** [dbdimp.o] Error 1 Please suggest for the above error, i am installing koha version 3.06, i am unable to install because of these module dependency. Regards Rohit Singh -- View this message in context: http://old.nabble.com/Error-while-Installing-DBD%3A%3AMysql-Perl-Module-tp29... Sent from the Koha - Discuss mailing list archive at Nabble.com.
rohitsingh wrote:
I am facing problem in installing DBD::Mysql Perl module, I am installing in MAC OS X, the error message details are as follow: [...] Unrecognized argument in LIBS ignored: '-pipe' Note (probably harmless): No library found for -lmysqlclient
I think you do not have the basic MySQL client library installed in a way suitable for development. The easiest fix would be to install a package called something like "MySQL Development Libraries" or mysql-dev from your MacOS X provider. This is not a problem with Koha. If you encounter further problems installing MySQL, I'd suggest trying to find and ask a mailing list for the DBD::Mysql Perl Module, your MacOS X support provider or maybe a Local User Group. The Koha list would become overwhelmed if problems with any system component are posted here in such detail. We didn't have much fun installing Koha on MacOS X and eventually upgraded to debian. The debugging tools were strange and uninformative. I never could track down some problems with the fink-based installation, including seemingly-random crashes of zebrasrv, occasional failures to start mysql on boot and sometimes ignoring connections from staff machine. Of course, they might have been something to do with network configuration or base system configuration (both of which were not under our control). I simply don't know. Maybe you will fare better, though. If I were doing it again, I'd try MacPorts, which used to be described a bit at http://www.tinybox.net/category/logiciels/koha/ but isn't any more... Regards, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. Webmaster, Debian Developer, Past Koha RM, statistician, former lecturer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire for Koha work http://www.software.coop/products/koha
participants (2)
-
MJ Ray -
rohitsingh