perl - Can not install DBD-mysql in Win8.1 -



perl - Can not install DBD-mysql in Win8.1 -

i install dbd-mysql in win8 environment, shows error follows.

i utilize activeperl 5.10, mysql 5.5. can help me?

in fact, don't want install source. not easy find ppm package.

if scheme path not added, easy handle. error showed windows library needed, don't know how set , set this, because means should alter source code of dbd-mysql? each time utilize ' perl -mcpan -e "install dbd::mysql" ' command install, downloads new dbd-mysql package, modified code locally, of no use.

creating library blib\arch\auto\dbd\mysql\mysql.lib , object blib\arch\auto \dbd\mysql\mysql.exp mysqlclient.lib(handshake_client.obj) : error lnk2019: unresolved external symbo l __imp__initializesecuritycontextw@48 referenced in function "public: virtual c lass blob __thiscall handshake_client::process_data(class blob const &)" (?proce ss_data@handshake_client@@uae?avblob@@abv2@@z) mysqlclient.lib(handshake.obj) : error lnk2019: unresolved external symbol _comp leteauthtoken@8 referenced in function "protected: bool __thiscall handshake::pr ocess_result(int)" (?process_result@handshake@@iae_nh@z) mysqlclient.lib(handshake.obj) : error lnk2019: unresolved external symbol _free contextbuffer@4 referenced in function "public: void __thiscall security_buffer: :free(void)" (?free@security_buffer@@qaexxz) mysqlclient.lib(handshake.obj) : error lnk2019: unresolved external symbol _acqu irecredentialshandlea@36 referenced in function "public: __thiscall handshake::h andshake(char const *,enum handshake::side_t)" (??0handshake@@qae@pbdw4side_t@0@ @z) mysqlclient.lib(handshake.obj) : error lnk2019: unresolved external symbol __imp __deletesecuritycontext@4 referenced in function "public: virtual __thiscall han dshake::~handshake(void)" (??1handshake@@uae@xz) mysqlclient.lib(handshake.obj) : error lnk2019: unresolved external symbol __imp __freecredentialshandle@4 referenced in function "public: virtual __thiscall han dshake::~handshake(void)" (??1handshake@@uae@xz) mysqlclient.lib(common.obj) : error lnk2019: unresolved external symbol _getuser nameexw@12 referenced in function "public: __thiscall upn::upn(void)" (??0upn@@q ae@xz) blib\arch\auto\dbd\mysql\mysql.dll : fatal error lnk1120: 7 unresolved externals nmake : fatal error u1077: 'c:\perl\bin\perl.exe' : homecoming code '0x1' stop. capttofu/dbd-mysql-4.028.tar.gz nmake -- not ok

at last, solve it. environment must first noted: win8.1 + activeperl 5.16 + mysql 5.5.

1) open windows command line, run:

set path=%path%;d:\program files (x86)\mysql\mysql server 5.5\bin

2) config mysql database, add together new user username='odbc', , password setted null.

3) cd into:

d:\program files (x86)\mysql\mysql server 5.5\lib

and create subdir “opt”;

4) install strawberry perl, re-create libmysql.a , libmysql_.dll to

d:\program files (x86)\mysql\mysql server 5.5\lib\opt;

5) uninstall strawberry;

6) set path=%path%;d:\program files (x86)\mysql\mysql server 5.5\lib\opt

7) run command in same command line console:

perl -mcpan -e "install dbd::mysql"

everything ok now.

mysql perl perl-module dbd

Comments

Post a Comment

Popular posts from this blog

javascript - THREE.js reposition vertices for RingGeometry -

javascript - THREE.js reposition vertices for RingGeometry - codepen available here: http://codepen.io/pehrlich/pen/cogjg i want render ring geometry in scene, , dynamically alter it's arclength (thetalength). start with, i'm calling it's constructor, , recalling code positions vertices. however, causes unusual results. here's method phone call - copied constructor , given new name of setthetalength: three.ringgeometry.prototype.setthetalength = function(thetalength){ // this.thetalength = thetalength; var i, o, uvs = [], radius = this.innerradius, radiusstep = ( ( this.outerradius - this.innerradius ) / this.phisegments ); ( = 0; < this.phisegments + 1; ++ ) { // concentric circles within ring ( o = 0; o < this.thetasegments + 1; o ++ ) { // number of segments per circle var vertex = this.vertices[i + o]; // maybe need query vertex indices here. var segment = this.thetastart + o / this.thetasegments *...
Read more

javascript - I need to update the text of a paragraph by inline edit -

javascript - I need to update the text of a paragraph by inline edit - i've tried this html <div> <h1>some text here</h1> <p>text area text here</p> </div> jquery $(function(){ $('p').on('click', function(e){ e.preventdefault(); var txt = $(this).text(); $(this).parent().append('<textarea>' + txt + '</textarea>'); $(this).remove(); }); }); i need update text of paragraph inline editing. need paragraph new text typed there , remove textarea when click outside of textarea. thanks here update fiddle http://jsfiddle.net/99pxz8et/2/ what need hear on alter event new text area , update it $area.one('focusout', function() { $p.show(); $p.text($area.val()); $area.remove() }); edit: changed .on() .one() javascript jquery
Read more

assembly - What is the addressing mode for ld, add, and rjmp instructions? -

assembly - What is the addressing mode for ld, add, and rjmp instructions? - hey guys know ldi (load immediate) addressing mode set immediate , st instruction addressing mode set index. however, have no thought others curious are! thanks :) the addressing modes explained in instruction set, in first few pages. in table of instructions see operands instruction determine addressing mode. mode indicated arguments assembly instruction. for example, ld had several different ways of operating, depending on arguments. 1 of them ld rd,x d number of register, such ld r3,x . ld r3,-z else (although both indirect addressing). rjmp k relative addressing, jumping pc + k + 1. add rr,rd direct register addressing. result contained in rd. assembly avr instructions
Read more