Welcome, Guest
Username Password: Remember me
Forgot your password? Forgot your username? Create an account
Software Configuration Mangement Forum
Scripting
Perl Script

perl -MCPAN -e "install DBD::mysql"
(1 viewing) (1) Guest
Perl Script
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: perl -MCPAN -e "install DBD::mysql"

perl -MCPAN -e "install DBD::mysql" 1 year, 4 months ago #489

  • rajeshkumar
  • OFFLINE
  • Moderator
  • I love software configuration management
  • Posts: 370
  • Points: 44562
  • Karma: 4
  • Honor Medal 2009
I am getting following issues while running following command in Windows Machine...

perl -MCPAN -e "install DBD::mysql"


Error


dbdimp.h:23:45: mysqld_error.h: No such file or directory
dbdimp.h:25:49: errmsg.h: No such file or directory
In file included from dbdimp.c:20:
dbdimp.h:147: error: syntax error before "MYSQL"
dbdimp.h:147: warning: no semicolon at end of struct or union
dbdimp.h:167: error: syntax error before '}' token
dbdimp.h:239: error: syntax error before "MYSQL_RES"
dbdimp.h:239: warning: no semicolon at end of struct or union
dbdimp.h:242: error: syntax error before "row_num"
dbdimp.h:242: warning: data definition has no type or storage class
dbdimp.h:247: error: syntax error before "insertid"
dbdimp.h:247: warning: data definition has no type or storage class
dbdimp.h:251: error: conflicting types for 'use_mysql_use_result'
dbdimp.h:155: error: previous declaration of 'use_mysql_use_result' was here
dbdimp.h:254: error: syntax error before '}' token
In file included from dbdimp.c:20:
dbdimp.h:296: error: syntax error before '*' token
dbdimp.h:299: error: syntax error before "mysql_st_internal_execute"
dbdimp.h:304: error: syntax error before "MYSQL_RES"
dbdimp.h:306: warning: data definition has no type or storage class
dbdimp.h:331: error: syntax error before '*' token
dbdimp.h:331: error: syntax error before "MYSQL"
dbdimp.h:332: warning: data definition has no type or storage class
dbdimp.c:507: error: syntax error before '*' token
dbdimp.c: In function `parse_params':
dbdimp.c:520: error: `slen_ptr' undeclared (first use in this function)
dbdimp.c:520: error: (Each undeclared identifier is reported only once
dbdimp.c:520: error: for each function it appears in.)
dbdimp.c:527: error: `statement' undeclared (first use in this function)
dbdimp.c:529: error: `num_params' undeclared (first use in this function)
dbdimp.c:755: error: `sock' undeclared (first use in this function)
dbdimp.c: At top level:
dbdimp.c:809: error: `FIELD_TYPE_VAR_STRING' undeclared here (not in a function)
dbdimp.c:809: error: initializer element is not constant
dbdimp.c:809: error: (near initialization for `SQL_GET_TYPE_INFO_values[0].native_type')
dbdimp.c:813: error: initializer element is not constant
dbdimp.c:813: error: (near initialization for `SQL_GET_TYPE_INFO_values[0]')
dbdimp.c:819: error: `FIELD_TYPE_DECIMAL' undeclared here (not in a function)
dbdimp.c:819: error: initializer element is not constant
dbdimp.c:819: error: (near initialization for `SQL_GET_TYPE_INFO_values[1].native_type')
dbdimp.c:823: error: initializer element is not constant
dbdimp.c:823: error: (near initialization for `SQL_GET_TYPE_INFO_values[1]')
dbdimp.c:829: error: `FIELD_TYPE_TINY' undeclared here (not in a function)
dbdimp.c:829: error: initializer element is not constant
dbdimp.c:829: error: (near initialization for `SQL_GET_TYPE_INFO_values[2].native_type')
dbdimp.c:833: error: initializer element is not constant
dbdimp.c:833: error: (near initialization for `SQL_GET_TYPE_INFO_values[2]')
dbdimp.c:839: error: `FIELD_TYPE_SHORT' undeclared here (not in a function)
dbdimp.c:839: error: initializer element is not constant
dbdimp.c:839: error: (near initialization for `SQL_GET_TYPE_INFO_values[3].native_type')
dbdimp.c:843: error: initializer element is not constant
dbdimp.c:843: error: (near initialization for `SQL_GET_TYPE_INFO_values[3]')
dbdimp.c:849: error: `FIELD_TYPE_LONG' undeclared here (not in a function)
dbdimp.c:849: error: initializer element is not constant
dbdimp.c:849: error: (near initialization for `SQL_GET_TYPE_INFO_values[4].native_type')
dbdimp.c:853: error: initializer element is not constant
dbdimp.c:853: error: (near initialization for `SQL_GET_TYPE_INFO_values[4]')
dbdimp.c:859: error: `FIELD_TYPE_FLOAT' undeclared here (not in a function)
dbdimp.c:859: error: initializer element is not constant
dbdimp.c:859: error: (near initialization for `SQL_GET_TYPE_INFO_values[5].native_type')
dbdimp.c:863: error: initializer element is not constant
dbdimp.c:863: error: (near initialization for `SQL_GET_TYPE_INFO_values[5]')
dbdimp.c:869: error: `FIELD_TYPE_DOUBLE' undeclared here (not in a function)
dbdimp.c:869: error: initializer element is not constant
dbdimp.c:869: error: (near initialization for `SQL_GET_TYPE_INFO_values[6].native_type')
dbdimp.c:873: error: initializer element is not constant
dbdimp.c:873: error: (near initialization for `SQL_GET_TYPE_INFO_values[6]')
dbdimp.c:879: error: initializer element is not constant
dbdimp.c:879: error: (near initialization for `SQL_GET_TYPE_INFO_values[7].native_type')
dbdimp.c:883: error: initializer element is not constant
dbdimp.c:883: error: (near initialization for `SQL_GET_TYPE_INFO_values[7]')
dbdimp.c:892: error: `FIELD_TYPE_TIMESTAMP' undeclared here (not in a function)
dbdimp.c:892: error: initializer element is not constant
dbdimp.c:892: error: (near initialization for `SQL_GET_TYPE_INFO_values[8].native_type')
dbdimp.c:896: error: initializer element is not constant
dbdimp.c:896: error: (near initialization for `SQL_GET_TYPE_INFO_values[8]')
dbdimp.c:902: error: `FIELD_TYPE_LONGLONG' undeclared here (not in a function)
dbdimp.c:902: error: initializer element is not constant
dbdimp.c:902: error: (near initialization for `SQL_GET_TYPE_INFO_values[9].native_type')
dbdimp.c:906: error: initializer element is not constant
dbdimp.c:906: error: (near initialization for `SQL_GET_TYPE_INFO_values[9]')
dbdimp.c:912: error: `FIELD_TYPE_INT24' undeclared here (not in a function)
dbdimp.c:912: error: initializer element is not constant
dbdimp.c:912: error: (near initialization for `SQL_GET_TYPE_INFO_values[10].native_type')
dbdimp.c:916: error: initializer element is not constant
dbdimp.c:916: error: (near initialization for `SQL_GET_TYPE_INFO_values[10]')
dbdimp.c:922: error: `FIELD_TYPE_DATE' undeclared here (not in a function)
dbdimp.c:922: error: initializer element is not constant
dbdimp.c:922: error: (near initialization for `SQL_GET_TYPE_INFO_values[11].native_type')
dbdimp.c:926: error: initializer element is not constant
dbdimp.c:926: error: (near initialization for `SQL_GET_TYPE_INFO_values[11]')
dbdimp.c:932: error: `FIELD_TYPE_TIME' undeclared here (not in a function)
dbdimp.c:932: error: initializer element is not constant
dbdimp.c:932: error: (near initialization for `SQL_GET_TYPE_INFO_values[12].native_type')
dbdimp.c:936: error: initializer element is not constant
dbdimp.c:936: error: (near initialization for `SQL_GET_TYPE_INFO_values[12]')
dbdimp.c:942: error: `FIELD_TYPE_DATETIME' undeclared here (not in a function)
dbdimp.c:942: error: initializer element is not constant
dbdimp.c:942: error: (near initialization for `SQL_GET_TYPE_INFO_values[13].native_type')
dbdimp.c:946: error: initializer element is not constant
dbdimp.c:946: error: (near initialization for `SQL_GET_TYPE_INFO_values[13]')
dbdimp.c:952: error: `FIELD_TYPE_YEAR' undeclared here (not in a function)
dbdimp.c:952: error: initializer element is not constant
dbdimp.c:952: error: (near initialization for `SQL_GET_TYPE_INFO_values[14].native_type')
dbdimp.c:956: error: initializer element is not constant
dbdimp.c:956: error: (near initialization for `SQL_GET_TYPE_INFO_values[14]')
dbdimp.c:962: error: `FIELD_TYPE_NEWDATE' undeclared here (not in a function)
dbdimp.c:962: error: initializer element is not constant
dbdimp.c:962: error: (near initialization for `SQL_GET_TYPE_INFO_values[15].native_type')
dbdimp.c:966: error: initializer element is not constant
dbdimp.c:966: error: (near initialization for `SQL_GET_TYPE_INFO_values[15]')
dbdimp.c:972: error: `FIELD_TYPE_ENUM' undeclared here (not in a function)
dbdimp.c:972: error: initializer element is not constant
Regards,
Rajesh Kumar
Build and Release Engineer
My Blog: community.scmgalaxy.com/pg/profile/rajeshkumar
Reply Quote

Re: perl -MCPAN -e "install DBD::mysql" 1 year, 4 months ago #490

  • rajeshkumar
  • OFFLINE
  • Moderator
  • I love software configuration management
  • Posts: 370
  • Points: 44562
  • Karma: 4
  • Honor Medal 2009
Full Log File..

Going to read 'C:\Tools\Perl\cpan\Metadata'
Database was generated on Sun, 02 Jan 2011 22:37:47 GMT
Running install for module 'DBD::mysql'
Running make for C/CA/CAPTTOFU/DBD-mysql-4.018.tar.gz
Checksum for C:\Tools\Perl\cpan\sources\authors\id\C\CA\CAPTTOFU\DBD-mysql-4.018.tar.gz ok
DBD-mysql-4.018/
DBD-mysql-4.018/ChangeLog
DBD-mysql-4.018/constants.h
DBD-mysql-4.018/dbdimp.c
DBD-mysql-4.018/dbdimp.h
DBD-mysql-4.018/eg/
DBD-mysql-4.018/eg/bug14979.pl
DBD-mysql-4.018/eg/bug21028.pl
DBD-mysql-4.018/eg/bug30033.pl
DBD-mysql-4.018/eg/bug30033pg.pl
DBD-mysql-4.018/eg/decimal_test.pl
DBD-mysql-4.018/eg/issue21946.pl
DBD-mysql-4.018/eg/prepare_memory_usage.pl
DBD-mysql-4.018/eg/proc_example1.pl
DBD-mysql-4.018/eg/proc_example2.pl
DBD-mysql-4.018/eg/proc_example2a.pl
DBD-mysql-4.018/eg/proc_example2b.pl
DBD-mysql-4.018/eg/proc_example3.pl
DBD-mysql-4.018/eg/proc_example4.pl
DBD-mysql-4.018/INSTALL.html
DBD-mysql-4.018/lib/
DBD-mysql-4.018/lib/Bundle/
DBD-mysql-4.018/lib/Bundle/DBD/
DBD-mysql-4.018/lib/Bundle/DBD/mysql.pm
DBD-mysql-4.018/lib/DBD/
DBD-mysql-4.018/lib/DBD/mysql/
DBD-mysql-4.018/lib/DBD/mysql/GetInfo.pm
DBD-mysql-4.018/lib/DBD/mysql/INSTALL.pod
DBD-mysql-4.018/lib/DBD/mysql.pm
DBD-mysql-4.018/Makefile.PL
DBD-mysql-4.018/Makefile.PL.embedded
DBD-mysql-4.018/MANIFEST
DBD-mysql-4.018/MANIFEST.SKIP
DBD-mysql-4.018/META.yml
DBD-mysql-4.018/myld
DBD-mysql-4.018/mysql.xs
DBD-mysql-4.018/README
DBD-mysql-4.018/t/
DBD-mysql-4.018/t/00base.t
DBD-mysql-4.018/t/10connect.t
DBD-mysql-4.018/t/20createdrop.t
DBD-mysql-4.018/t/25lockunlock.t
DBD-mysql-4.018/t/29warnings.t
DBD-mysql-4.018/t/30insertfetch.t
DBD-mysql-4.018/t/31insertid.t
DBD-mysql-4.018/t/32insert_error.t
DBD-mysql-4.018/t/35limit.t
DBD-mysql-4.018/t/35prepare.t
DBD-mysql-4.018/t/40bindparam.t
DBD-mysql-4.018/t/40bindparam2.t
DBD-mysql-4.018/t/40blobs.t
DBD-mysql-4.018/t/40catalog.t
DBD-mysql-4.018/t/40keyinfo.t
DBD-mysql-4.018/t/40listfields.t
DBD-mysql-4.018/t/40nulls.t
DBD-mysql-4.018/t/40nulls_prepare.t
DBD-mysql-4.018/t/40numrows.t
DBD-mysql-4.018/t/40server_prepare.t
DBD-mysql-4.018/t/40server_prepare_error.t
DBD-mysql-4.018/t/40types.t
DBD-mysql-4.018/t/41bindparam.t
DBD-mysql-4.018/t/41blobs_prepare.t
DBD-mysql-4.018/t/42bindparam.t
DBD-mysql-4.018/t/50chopblanks.t
DBD-mysql-4.018/t/50commit.t
DBD-mysql-4.018/t/51bind_type_guessing.t
DBD-mysql-4.018/t/52comment.t
DBD-mysql-4.018/t/53comment.t
DBD-mysql-4.018/t/55utf8.t
DBD-mysql-4.018/t/60leaks.t
DBD-mysql-4.018/t/65types.t
DBD-mysql-4.018/t/70takeimp.t
DBD-mysql-4.018/t/71impdata.t
DBD-mysql-4.018/t/75supported_sql.t
DBD-mysql-4.018/t/76multi_statement.t
DBD-mysql-4.018/t/80procs.t
DBD-mysql-4.018/t/85init_command.t
DBD-mysql-4.018/t/86_bug_36972.t
DBD-mysql-4.018/t/lib.pl
DBD-mysql-4.018/t/mem_leak.pl
DBD-mysql-4.018/t/mysql.dbtest
DBD-mysql-4.018/t/mysql.mtest
DBD-mysql-4.018/TODO

CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-4.018.tar.gz


mysql_config.pl, and an associated bat file, has been
successfully created under
D:\wamp\bin\mysql\MYSQL5~1.36\bin



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"D:\wamp\bin\mysql\MYSQL5~1.36\include"
embedded (mysql_config) =
libs (mysql_config) = -LD:\wamp\bin\mysql\MYSQL5~1.36\lib\opt -lmysqlclient -lzlib
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.616 (for perl 5.010001 on MSWin32-x86-multi-thread) installed in C:/Tools/Perl/site/lib/auto/DBI/
Writing Makefile for DBD::mysql
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
C:/Tools/Perl/site/bin/gcc.exe -c -IC:\Tools\Perl\site\lib\auto\DBI -I"D:\wamp\bin\mysql\MYSQL5~1.36\include" -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -DPERL_MSVCRT_READFIX -DHASATTRIBUTE -fno-strict-aliasing -mms-bitfields -O2 -DVERSION=\"4.018\" -DXS_VERSION=\"4.018\" "-IC:\Tools\Perl\lib\CORE" dbdimp.c
CAPTTOFU/DBD-mysql-4.018.tar.gz
C:\Tools\Perl\site\bin\dmake.exe -- NOT OK
Running make test
Can't test without successful make
Running make install
Make had returned bad status, install seems impossible
Regards,
Rajesh Kumar
Build and Release Engineer
My Blog: community.scmgalaxy.com/pg/profile/rajeshkumar
Reply Quote

Re: perl -MCPAN -e "install DBD::mysql" 1 year, 4 months ago #491

  • rajeshkumar
  • OFFLINE
  • Moderator
  • I love software configuration management
  • Posts: 370
  • Points: 44562
  • Karma: 4
  • Honor Medal 2009
Now after doing some more R and D, i got following...

D:\wamp\bin\mysql\MYSQL5~1.36\bin\MYSQLA~1.EXE: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)'
Problem running D:\wamp\bin\mysql\MYSQL5~1.36\bin\MYSQLA~1.EXE - aborting ...
Warning: No success on command[C:\Tools\Perl\bin\perl.exe Makefile.PL INSTALLDIRS=site]
CAPTTOFU/DBD-mysql-4.018.tar.gz
C:\Tools\Perl\bin\perl.exe Makefile.PL INSTALLDIRS=site -- NOT OK
Running make test
Make had some problems, won't test
Running make install
Make had some problems, won't install
Regards,
Rajesh Kumar
Build and Release Engineer
My Blog: community.scmgalaxy.com/pg/profile/rajeshkumar
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
Software Configuration Mangement Forum
Scripting
Perl Script
Powered by Kunena
Time to create page: 0.93 seconds

     
    
Home Forum