Hi Stefan,
I've built Mar2011, Apr2011 and Apr2011-SP1. That allowed me to upgrade from first to last with just rpm -Uvh ...
About OpenSSL hmmm... :) what I did is to lower the requirement :) To be honest I haven't went through the source to understand why 0.9.8f is required but I tried 0.9.8e and it worked. I have to admit this is not a very strict approach but it seems that it works. :) I've pasted the files diff bellow.
About what I had to install from rpmforge, I don't actually recall what came from where. From a quick review of my logs the following packages came from rpmforge to be able to meet the dependencies.
geos
geos-devel

and these came from epel
uuid-devel
uuid
rubygems

Regards,
Jerónimo

[jborque@blackbox MonetDB-11.3.3]$ diff -ru ../ori/MonetDB-11.3.3 .
diff -ru ../ori/MonetDB-11.3.3/configure ./configure
--- ../ori/MonetDB-11.3.3/configure     2011-05-17 11:46:02.000000000 -0300
+++ ./configure 2011-05-31 12:33:49.000000000 -0300
@@ -17987,12 +17987,12 @@
     pkg_cv_openssl_CFLAGS="$openssl_CFLAGS"
  elif test -n "$PKG_CONFIG"; then
     if test -n "$PKG_CONFIG" && \
-    { { $as_echo "$as_me:${as_lineno-$LINENO}: \$PKG_CONFIG --exists --print-errors \"openssl >= 0.9.8f\""; } >&5
-  ($PKG_CONFIG --exists --print-errors "openssl >= 0.9.8f") 2>&5
+    { { $as_echo "$as_me:${as_lineno-$LINENO}: \$PKG_CONFIG --exists --print-errors \"openssl >= 0.9.8e\""; } >&5
+  ($PKG_CONFIG --exists --print-errors "openssl >= 0.9.8e") 2>&5
   ac_status=$?
   $as_echo "$as_me:${as_lineno-$LINENO}: \$? = $ac_status" >&5
   test $ac_status = 0; }; then
-  pkg_cv_openssl_CFLAGS=`$PKG_CONFIG --cflags "openssl >= 0.9.8f" 2>/dev/null`
+  pkg_cv_openssl_CFLAGS=`$PKG_CONFIG --cflags "openssl >= 0.9.8e" 2>/dev/null`
 else
   pkg_failed=yes
 fi
@@ -18003,12 +18003,12 @@
     pkg_cv_openssl_LIBS="$openssl_LIBS"
  elif test -n "$PKG_CONFIG"; then
     if test -n "$PKG_CONFIG" && \
-    { { $as_echo "$as_me:${as_lineno-$LINENO}: \$PKG_CONFIG --exists --print-errors \"openssl >= 0.9.8f\""; } >&5
-  ($PKG_CONFIG --exists --print-errors "openssl >= 0.9.8f") 2>&5
+    { { $as_echo "$as_me:${as_lineno-$LINENO}: \$PKG_CONFIG --exists --print-errors \"openssl >= 0.9.8e\""; } >&5
+  ($PKG_CONFIG --exists --print-errors "openssl >= 0.9.8e") 2>&5
   ac_status=$?
   $as_echo "$as_me:${as_lineno-$LINENO}: \$? = $ac_status" >&5
   test $ac_status = 0; }; then
-  pkg_cv_openssl_LIBS=`$PKG_CONFIG --libs "openssl >= 0.9.8f" 2>/dev/null`
+  pkg_cv_openssl_LIBS=`$PKG_CONFIG --libs "openssl >= 0.9.8e" 2>/dev/null`
 else
   pkg_failed=yes
 fi
@@ -18028,9 +18028,9 @@
         _pkg_short_errors_supported=no
 fi
         if test $_pkg_short_errors_supported = yes; then
-               openssl_PKG_ERRORS=`$PKG_CONFIG --short-errors --print-errors "openssl >= 0.9.8f" 2>&1`
+               openssl_PKG_ERRORS=`$PKG_CONFIG --short-errors --print-errors "openssl >= 0.9.8e" 2>&1`
         else
-               openssl_PKG_ERRORS=`$PKG_CONFIG --print-errors "openssl >= 0.9.8f" 2>&1`
+               openssl_PKG_ERRORS=`$PKG_CONFIG --print-errors "openssl >= 0.9.8e" 2>&1`
         fi
        # Put the nasty error message in config.log where it belongs
        echo "$openssl_PKG_ERRORS" >&5
diff -ru ../ori/MonetDB-11.3.3/configure.ac ./configure.ac
--- ../ori/MonetDB-11.3.3/configure.ac  2011-05-17 11:45:48.000000000 -0300
+++ ./configure.ac      2011-05-31 12:34:36.000000000 -0300
@@ -2125,7 +2125,7 @@

 dnl OpenSSL library
 dnl required for MonetDB5 (and SQL), optional otherwise
-PKG_CHECK_MODULES([openssl], [openssl >= 0.9.8f],
+PKG_CHECK_MODULES([openssl], [openssl >= 0.9.8e],
        [have_openssl=yes; AC_DEFINE(HAVE_OPENSSL, 1, [Define if you have the OpenSSL library])],
        [have_openssl=no])
 case "$enable_monetdb5-$have_openssl" in
diff -ru ../ori/MonetDB-11.3.3/configure.ag ./configure.ag
--- ../ori/MonetDB-11.3.3/configure.ag  2011-05-17 11:45:38.000000000 -0300
+++ ./configure.ag      2011-05-31 12:34:51.000000000 -0300
@@ -2125,7 +2125,7 @@

 dnl OpenSSL library
 dnl required for MonetDB5 (and SQL), optional otherwise
-PKG_CHECK_MODULES([openssl], [openssl >= 0.9.8f],
+PKG_CHECK_MODULES([openssl], [openssl >= 0.9.8e],
        [have_openssl=yes; AC_DEFINE(HAVE_OPENSSL, 1, [Define if you have the OpenSSL library])],
        [have_openssl=no])
 case "$enable_monetdb5-$have_openssl" in
Only in .: MonetDB.MIO.spec
diff -ru ../ori/MonetDB-11.3.3/MonetDB.spec ./MonetDB.spec
--- ../ori/MonetDB-11.3.3/MonetDB.spec  2011-05-17 11:45:39.000000000 -0300
+++ ./MonetDB.spec      2011-05-31 15:45:29.000000000 -0300
@@ -28,19 +28,21 @@
 License: MPL - http://monetdb.cwi.nl/Legal/MonetDBLicense-1.1.html
 URL: http://monetdb.cwi.nl/
 Source: http://dev.monetdb.org/downloads/sources/Apr2011-SP1/%{name}-%{version}.tar.bz2
+BuildRoot: %(mktemp -ud %{_tmppath}/%{name}-%{version}-%{release}-XXXXXX)
+

 BuildRequires: bison
 BuildRequires: bzip2-devel
 # BuildRequires: cfitsio-devel
 BuildRequires: flex
 BuildRequires: geos-devel >= 2.2.0
-BuildRequires: libcurl-devel
-BuildRequires: libuuid-devel
+BuildRequires: curl-devel
+BuildRequires: uuid-devel
 BuildRequires: libxml2-devel
-BuildRequires: openssl-devel >= 0.9.8f
+BuildRequires: openssl-devel >= 0.9.8e
 BuildRequires: pcre-devel >= 4.5
 BuildRequires: perl
-BuildRequires: perl-devel
+#BuildRequires: perl-devel
 BuildRequires: python
 # BuildRequires: raptor-devel >= 1.4.16
 BuildRequires: readline-devel
@@ -95,7 +97,7 @@
 Group: Applications/Databases
 Requires: %{name}-stream = %{version}-%{release}
 Requires: bzip2-devel
-Requires: libcurl-devel
+Requires: curl-devel
 Requires: zlib-devel

 %description stream-devel
@@ -145,7 +147,7 @@
 Group: Applications/Databases
 Requires: %{name}-client = %{version}-%{release}
 Requires: %{name}-stream-devel = %{version}-%{release}
-Requires: openssl-devel >= 0.9.8f
+Requires: openssl-devel >= 0.9.8e

 %description client-devel
 MonetDB is a database management system that is developed from a
@@ -204,7 +206,8 @@
 Summary: MonetDB php interface
 Group: Applications/Databases
 Requires: php
-BuildArch: noarch
+BuildArch: x86_64
+#BuildArch: noarch

 %description client-php
 MonetDB is a database management system that is developed from a
@@ -466,7 +469,7 @@
 %defattr(-,root,root)
 %dir %{python_sitelib}/monetdb
 %{python_sitelib}/monetdb/*
-%{python_sitelib}/python_monetdb-*.egg-info
+#%{python_sitelib}/python_monetdb-*.egg-info
 %doc clients/python/README.rst

 %package testing
@@ -512,8 +515,8 @@
 %files testing-python
 %defattr(-,root,root)
 # at least F12 doesn't produce these
-# %exclude %{_bindir}/*.pyc
-# %exclude %{_bindir}/*.pyo
+%exclude %{_bindir}/*.pyc
+%exclude %{_bindir}/*.pyo
 %{_bindir}/Mapprove.py
 %{_bindir}/Mfilter.py
 %{_bindir}/Mtest.py
[jborque@blackbox MonetDB-11.3.3]$





2011/6/7 Stefan Manegold <Stefan.Manegold@cwi.nl>
Hello Jerónimo,

thank you very much for your effort and for sharing this information!

Am I right that you built the CentOS RPMs from the Mar2011 release
(monetdb_11.1.1-20110324.tar.gz) of MonetDB?

If so --- just out of curiosity --- could you please share with us why you
chose this version over the lastest Apr2011-SP1 release
(MonetDB-11.3.3.tar.{xz,bz2} from
http://dev.monetdb.org/downloads/sources/Apr2011-SP1/)?

Also, we'd be curios to learn the details of your modifications to the
configure and rpm spec requirements. Would you mind sharing, say, the "diff"
with us?
Likewise, which RPMs did you (have to) update/install from rpmforge to make
your CentOS 5.6 "ready" for (building) MonetDB; in particular, could you
find a suitable OpenSSL (>=0.9.8f) for CentOS 5.6, or did you build it
yourself from sources?

We are not providing any CentOS RPMs (yet?), mainly because (1) we do not
have any CentOS machine running ourselves, (2) we are not aware of a readily
available "mock" configuration for CentOS on Fedora (our main development
platform), and (3) the standar available version of OpenSSL on CentOS is
still too old for our requirements (<=0.9.8e rather than >=0.9.8f).

Thanks!

Stefan

On Mon, Jun 06, 2011 at 09:36:44PM -0300, Jerónimo Borque wrote:
> Hello all, I have built CentOS 5.6 compatible RPMs and I can share them with
> anyone interested.
> To do that I've modified the configure and rpm spec requirements to match
> the packages currently available in CentOS and rpmforge.
> I haven't done an intensive testing of the built binaries, but basic
> functionality works.
>
>
> 2011/6/6 Fabian Groffen <Fabian.Groffen@cwi.nl>
>
> > On 06-06-2011 18:47:54 +0000, julio Puebla wrote:
> > > Hi, I'm trying to install monetdb_11.1.1-20110324.tar.gz in a Centos 5.6,
> > > but I get the following message:
> > > configure: 22214: $ PKG_CONFIG - exists - print-errors "openssl> =
> > 0.9.8f"
> > > Requested 'openssl> = 0.9.8f'but version of OpenSSL is 0.9.8e-RHEL5
> > > Centos 5.6 but no version 0.9.8f.
> >
> > You need a newer OpenSSL.  If CentOS 5.6 doesn't provide it for you,
> > you'll have to compile and install it manually yourself.
> > My systems use openssl-1.0.0d successfully.
> >
> >
> > ------------------------------------------------------------------------------
> > Simplify data backup and recovery for your virtual environment with
> > vRanger.
> > Installation's a snap, and flexible recovery options mean your data is
> > safe,
> > secure and there when you need it. Discover what all the cheering's about.
> > Get your free trial download today.
> > http://p.sf.net/sfu/quest-dev2dev2
> > _______________________________________________
> > MonetDB-users mailing list
> > MonetDB-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/monetdb-users
> >

> ------------------------------------------------------------------------------
> EditLive Enterprise is the world's most technically advanced content
> authoring tool. Experience the power of Track Changes, Inline Image
> Editing and ensure content is compliant with Accessibility Checking.
> http://p.sf.net/sfu/ephox-dev2dev

> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users


--
| Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
| http://CWI.nl/~manegold/ | Science Park 123 (L321) |
| Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam  (NL) |

------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users