Installing mysql module - wrong architecture

[Tim Johnson]

I've installed the mysql module, but it is the wrong architecture:
here is a dump of the installation (no debug file was built)
************************************************************
bash-3.2# npm install db-mysql
npm http GET https://registry.npmjs.org/db-mysql
npm http 304 https://registry.npmjs.org/db-mysql

> db-m...@0.7.6 install /Users/tim/node_modules/db-mysql
> node-waf configure build

Checking for program g++ or c++ : /usr/bin/g++
Checking for program cpp : /usr/bin/cpp
Checking for program ar : /opt/local/bin/ar
Checking for program ranlib : /opt/local/bin/ranlib
Checking for g++ : ok
Checking for node path : not found
Checking for node prefix : ok /usr/local
Checking for program mysql_config : /opt/local/lib/mysql5/bin/mysql_config
Checking for library mysqlclient_r : Missing libmysqlclient_r
'configure' finished successfully (1.911s)
Waf: Entering directory `/Users/tim/node_modules/db-mysql/build'
[ 1/12] cxx: lib/node-db/binding.cc -> build/Release/lib/node-db/binding_1.o
[ 2/12] cxx: lib/node-db/connection.cc -> build/Release/lib/node-db/connection_1.o
[ 3/12] cxx: lib/node-db/events.cc -> build/Release/lib/node-db/events_1.o
[ 4/12] cxx: lib/node-db/exception.cc -> build/Release/lib/node-db/exception_1.o
[ 5/12] cxx: lib/node-db/query.cc -> build/Release/lib/node-db/query_1.o
[ 6/12] cxx: lib/node-db/result.cc -> build/Release/lib/node-db/result_1.o
[ 7/12] cxx: src/connection.cc -> build/Release/src/connection_1.o
[ 8/12] cxx: src/mysql.cc -> build/Release/src/mysql_1.o
[ 9/12] cxx: src/query.cc -> build/Release/src/query_1.o
[10/12] cxx: src/result.cc -> build/Release/src/result_1.o
[11/12] cxx: src/mysql_bindings.cc -> build/Release/src/mysql_bindings_1.o
[12/12] cxx_link: build/Release/lib/node-db/binding_1.o build/Release/lib/node-db/connection_1.o build/Release/lib/node-db/events_1.o build/Release/lib/node-db/exception_1.o build/Release/lib/node-db/query_1.o build/Release/lib/node-db/result_1.o build/Release/src/connection_1.o build/Release/src/mysql_1.o build/Release/src/query_1.o build/Release/src/result_1.o build/Release/src/mysql_bindings_1.o -> build/Release/mysql_bindings.node
ld: warning: ignoring file /opt/local/lib/mysql5/mysql/libmysqlclient_r.dylib, file was built for unsupported file format which is not the architecture being linked (i386)
ld: warning: ignoring file /opt/local/lib/libz.dylib, file was built for unsupported file format which is not the architecture being linked (i386)
ld: warning: ignoring file /opt/local/lib/libssl.dylib, file was built for unsupported file format which is not the architecture being linked (i386)
ld: warning: ignoring file /opt/local/lib/libcrypto.dylib, file was built for unsupported file format which is not the architecture being linked (i386)
Waf: Leaving directory `/Users/tim/node_modules/db-mysql/build'
'build' finished successfully (2.716s)
db-m...@0.7.6 node_modules/db-mysql
************************************************************
This installation is on mac OSX ver 10.7 (darwin)

Please advise
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com

[Ben Noordhuis]

Maybe related to https://github.com/joyent/node/issues/3633 ?

[Tim Johnson]

* Ben Noordhuis <in...@bnoordhuis.nl> [120704 17:11]:
<...> > 'build' finished successfully (2.716s)

> > db-m...@0.7.6 node_modules/db-mysql
> > ************************************************************
> > This installation is on mac OSX ver 10.7 (darwin)
>
> Maybe related to https://github.com/joyent/node/issues/3633 ?

Thank you Ben. I will read that tomorrow and report back on
the results.
cheers

[mscdex]

On Jul 4, 10:21 pm, Tim Johnson <t...@akwebsoft.com> wrote:
>   Thank you Ben. I will read that tomorrow and report back on
>   the results.

You might also be interested in a pure JavaScript async mysql module:
https://github.com/felixge/node-mysql

[Tim Johnson]

* Ben Noordhuis <in...@bnoordhuis.nl> [120704 17:11]:

> > ************************************************************
> > This installation is on mac OSX ver 10.7 (darwin)
>
> Maybe related to https://github.com/joyent/node/issues/3633 ?

Yup. As per the instructions I commented out the lines refered to.
As time permits, and I gain some knowledge of the system, I should
be able to revise the python code to handle other 32-bit installs,
for now I have mysql working and I appreciate the tip.