do_mysql doesn't compile on Joyent OpenSolaris for "error: structure has no member named `tm_gmtoff'"

[Felix Sun]

As following:

[dev@gmg6p9ab ~/src/do/do_mysql]$ uname -a
SunOS gmg6p9ab.joyent.us 5.11 snv_67 i86pc i386 i86pc

[dev@gmg6p9ab ~/src/do/do_mysql]$ rake install
(in /home/dev/src/do/do_mysql)
Password:
Building native extensions. This could take a while...
ERROR: Error installing pkg/do_mysql-0.9.6:
ERROR: Failed to build gem native extension.

/opt/local/bin/ruby18 extconf.rb install --local pkg/do_mysql-0.9.6
--no-update-sources
checking for mysql.h... yes
checking for main() in -lmysqlclient... yes
checking for mysql_query()... yes
checking for mysql_ssl_set()... yes
creating Makefile

make
gcc -I. -I. -I/opt/local/lib/ruby/1.8/i386-solaris2 -I. -DHAVE_MYSQL_H
-DHAVE_MYSQL_QUERY -DHAVE_MYSQL_SSL_SET -D_REENTRANT -I/usr/include
-I/opt/local/include/db4 -I/opt/local/include
-I/opt/local/include/mysql -DUSE_OLD_FUNCTIONS -DHAVE_CURSES_H
-I/opt/local/include -fPIC -O -D_REENTRANT -I/usr/include
-I/opt/local/include/db4 -I/opt/local/include -fPIC -Wall -c
do_mysql_ext.c
do_mysql_ext.c: In function `parse_date_time':
do_mysql_ext.c:216: error: structure has no member named `tm_gmtoff'
do_mysql_ext.c:217: error: structure has no member named `tm_gmtoff'
do_mysql_ext.c:220: error: structure has no member named `tm_gmtoff'
do_mysql_ext.c:244: error: structure has no member named `tm_gmtoff'
*** Error code 1
make: Fatal error: Command failed for target `do_mysql_ext.o'

Gem files will remain installed in
/opt/local/lib/ruby/gems/1.8/gems/do_mysql-0.9.6 for inspection.
Results logged to
/opt/local/lib/ruby/gems/1.8/gems/do_mysql-0.9.6/ext/gem_make.out
[dev@gmg6p9ab ~/src/do/do_mysql]$

[clintjhill]

I believe this is related. There is an incompatibility in the time
implementations on the OS. There is this lighthouse ticket that also
references another.

http://wm.lighthouseapp.com/projects/4819/tickets/429-do_sqlite3-0-9-2-compile-fails-under-cygwin

[Karlin Fox]

You'll find a few solutions, including mine specifically for
OpenSolaris, here:

<a href="http://wm.lighthouseapp.com/projects/4819-datamapper/tickets/
344">http://wm.lighthouseapp.com/projects/4819-datamapper/tickets/344</
a>

[Karlin Fox]

Oops, I missed the previous post.