Puppet users - Sep 2010 - puppet dashboard and 64-bit mysql

I was looking forward to trying this out, given the puported Solaris
support. However, in attempting to install the prereqs for dashboard,
I hit a major snag. My main server uses the blastwave MySQL install,
which is a 64-bit version of MySQL 5.

mysql  Ver 14.12 Distrib 5.0.90, for pc-solaris2.10 (x86_64)

Apparently the mysql bindings for ruby don''t like the 64-bit version.

Output of "gem install mysql"

/opt/csw/bin/ruby extconf.rb
checking for mysql_ssl_set()... no
checking for rb_str_set_len()... no
checking for rb_thread_start_timer()... no
checking for mysql.h... yes
cc: Warning: Option -msse passed to ld, if ld is invoked, ignored
otherwise
cc: Warning: Option -msse2 passed to ld, if ld is invoked, ignored
otherwise
creating Makefile

make
cc -I. -I. -I/opt/csw/lib/ruby/1.8/i386-solaris2.8 -I. -DHAVE_MYSQL_H
-I/opt/csw/include -I/opt/csw/include -I/opt/csw/mysql5/include/mysql
-m64 -msse -msse2 -DCSW_HAVE_STACKTRACE -I/opt/csw/include    -
DHAVE_RWLOCK_T -KPIC -xO3 -xarch=386 -xspace -xildoff -I/opt/csw/
include -I/opt/csw/include   -KPIC  -c mysql.c
cc: Warning: Option -msse passed to ld, if ld is invoked, ignored
otherwise
cc: Warning: Option -msse2 passed to ld, if ld is invoked, ignored
otherwise
ld -G -o mysql_api.so mysql.o -L''.''
-L''/opt/csw/lib'' -R''/opt/csw/lib'' -
L.   -L/opt/csw/lib -L/opt/csw/lib    -R /opt/csw/lib -L/opt/csw/lib -
lruby -L/opt/csw/lib/amd64 -L/opt/csw/mysql5/lib/amd64/mysql -
lmysqlclient -lz -lposix4 -lgen -lsocket -lnsl -lm -L/opt/csw/lib -
lssl -lcrypto  -lrt -lpthread -ldl -lcrypt -lm   -lc
ld: fatal: file /opt/csw/mysql5/lib/amd64/mysql/libmysqlclient.so:
wrong ELF class: ELFCLASS64
ld: fatal: File processing errors. No output written to mysql_api.so
make: *** [mysql_api.so] Error 1

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

Hi,

On 8 September 2010 21:24, Tim <tim.mori@gmail.com> wrote:
> I was looking forward to trying this out, given the puported Solaris
> support. However, in attempting to install the prereqs for dashboard,
> I hit a major snag. My main server uses the blastwave MySQL install,
> which is a 64-bit version of MySQL 5.
>
> mysql  Ver 14.12 Distrib 5.0.90, for pc-solaris2.10 (x86_64)
>
> Apparently the mysql bindings for ruby don''t like the 64-bit
version.
>

You can pass an ARCHFLAGS environment variable on the command line to tell
gem to compile against the correct architecture.  I don''t have a 64-bit
Solaris machine to test, but you could have a look at the second comment
from the bottom here:

http://peppyheppy.com/2009/6/15/fail-sudo-gem-install-mysql-fixed

J.



-- 
Julian Simpson
The Build Doctor Ltd.
http://www.build-doctor.com
julian@build-doctor.com
(+44) 207 183 0323

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

Thanks for the suggestion. I tried, oh maybe a hundred or so
variations of installing that gem, trying an earlier version and even
downloading the source and trying it that way. No dice. It simply
won''t compile against the 64-bit mysql libraries. I''m not even
sure it
was understanding the ARCHFLAGS variable. It could be that there''s
specific syntax for use on Solaris that I wasn''t using. I tried using
env ARCHFLAGS and export ARCHFLAGS, even just setting the variable
normally via the standard declaration/export.

I was able to build it against the 32-bit libraries, but then the
dashboard install fails.

Seems strange to me though. Puppet seems to be designed to manage
servers at an enterprise level, so all of my machines are 64-bit and
most of the apps they run are 64-bit, so why would I have to install a
32-bit MySQL database just to run the puppet dashboard?

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

> env ARCHFLAGS and export ARCHFLAGS, even just setting the variable
> normally via the standard declaration/export.
  Tim.
 From your original post I''m assuming your using "cc" from
sun
studio.  If that''s the case I use the following when I need to compile
something against my 64 bit mysql package ( say php for example).

CC=cc CFLAGS="-xtarget=generic -m64 -xO4" CXX="CC"
CXXFLAGS="-
xtarget=generic -m64 -xO4" LDFLAGS="-m64"

 Are you setting the "-m64" flags like in the above example?
Installing puppet dashboard on Solaris is on my list of things to do
but not in the immediate future.    So if you do get through it and
generate some special incantations i''d love to see them:)
 HTH.  Derek.
>
> I was able to build it against the 32-bit libraries, but then the
> dashboard install fails.
>
> Seems strange to me though. Puppet seems to be designed to manage
> servers at an enterprise level, so all of my machines are 64-bit and
> most of the apps they run are 64-bit, so why would I have to install a
> 32-bit MySQL database just to run the puppet dashboard?
-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.