[MonetDB-users] Create Database - Load Data
Hi,
how can I create a new Database under Windows and how can I load data in a table form a external file?
Thanks
Hello Lowterm,
Thanks for using MonetDB and sorry for the delayed reply. Many members of the group are on traveling, including our only Windows expert.
To create a new database, you can use the option of mserver5.exe: --dbname="<name of the database you want to create>" On Windows, I don't know a better way than editing the M5server.bat script. On a Win XP, this script can be found in "C:\Program Files\MonetDB\MonetDB5". So for instance, I have edited my M5server.bat as the following:
"%MONETDB%\bin\mserver5.exe" --set "prefix=%MONETDB%" --set "exec_prefix=%MONETDB%" %MONETDBFARM% %* --dbname="test"
i.e., '--dbname="test"' has been added. Then you can just use the shortcuts in the start menu to start the MonetDB SQL server and client.
In the MonetDB SQL client, you can use the command "?" to get a list of commands available, among others, the command "<" allows you to read input from file.
I hope this helps a bit.
With kind regards,
Jennie
On May 19, 2011, at 10:14 , Lowterm wrote:
Hi,
how can I create a new Database under Windows and how can I load data in a table form a external file?
Thanks
View this message in context: http://old.nabble.com/Create-Database---Load-Data-tp31653813p31653813.html Sent from the monetdb-users mailing list archive at Nabble.com.
vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi Jennie,
thanks für your reply. It works, but I have demo-Database no more. Instead I have now a database called "test". Is it so correctly? I need two databses.
Thanks
Hi Lowterm,
You still have the demo database. It's just not loaded/used. If you need to use two databases at the same time, you will have to start 2 mserver5.exe, since each mserver5 instance only works with one database. To start multiple mserver5, you must let each mserver5 to listen to a different port, using the option "--set mapi_port=<an unused port>".
Regards,
Jennie
On May 25, 2011, at 13:15 , Lowterm wrote:
Hi Jennie,
thanks für your reply. It works, but I have demo-Database no more. Instead I have now a database called "test". Is it so correctly? I need two databses.
Thanks
-- View this message in context: http://old.nabble.com/Create-Database---Load-Data-tp31653813p31697937.html Sent from the monetdb-users mailing list archive at Nabble.com.
vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi Jennie,
oh, I see. Thanks. Can you say me please, where can I find the Commands for windows. How can I show for example all of databases or tables? I have two users under test-dabase, "sys" and "tmp". The created tables are created automatically under sys-user. I create now a new user for example "testuser". How can I now create a table under "testuser"-user and how can I use this table?
Thanks for your help
Hi Lowterm,
oh, I see. Thanks. Can you say me please, where can I find the Commands for windows. How can I show for example all of databases or tables?
Please read the output of '?' in your monetdb sql client.
I have two users under test-dabase, "sys" and "tmp". The created tables are created automatically under sys-user. I create now a new user for example "testuser". How can I now create a table under "testuser"-user and how can I use this table?
Please have a look at this page:
http://monetdb.cwi.nl/SQL/QuickTour/VOC/index.html
Regards,
Jennie
Thanks for your help
-- View this message in context: http://old.nabble.com/Create-Database---Load-Data-tp31653813p31698144.html Sent from the monetdb-users mailing list archive at Nabble.com.
vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
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.
thanks in advance
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.
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
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
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/%%7Bname%7D-%%7Bversion... +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
On 07-06-2011 12:21:44 -0300, Jerónimo Borque wrote:
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
This works because CentOS heavily patched their anchient openssl, such that it includes the >SHA-256 hashes that MonetDB requires. Officially, they are only available since 0.9.8f though.
Thank you Fabian, That explains it. Then CentOS can "easily" get supported, right? If you are interested I can try to investigate how to change the configure and spec to make them work for both Fedora and CentOS. Although CentOS development runs at the very cautious speed of Redhat (or actually slower than Redhat) for some of us that we don't like to make upgrades to production servers often CentOS is a fair alternative. Anyway the openssl problem will soon be solved when Centos 6 goes public since it would include 1.0.0.
Regards, Jerónimo
2011/6/7 Fabian Groffen Fabian.Groffen@cwi.nl
On 07-06-2011 12:21:44 -0300, Jerónimo Borque wrote:
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
This works because CentOS heavily patched their anchient openssl, such that it includes the >SHA-256 hashes that MonetDB requires. Officially, they are only available since 0.9.8f though.
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
Jerónimo,
On Sun, Jun 12, 2011 at 10:25:27PM -0300, Jerónimo Borque wrote:
Thank you Fabian, That explains it. Then CentOS can "easily" get supported, right? If you are interested I can try to investigate how to change the configure and spec to make them work for both Fedora and CentOS.
If you plan to invest time into this, please start with the plain sources from the MonetDB HG repository (cf., http://dev.monetdb.org/hg/MonetDB/), rather than the pre-packaged source tarball; i.e., check out the sources via
hg clone http://dev.monetdb.org/hg/MonetDB/
and then send us the diff.
However, with CentOS 6 on the horizon as you point out, I'm not sure whether there is need to patch our setup also for CentOS 5(.5); I'd rather suggest to wait for CentOS 6, aliminating the need for pacthes for OpenSSL (and maybe also for the spec files?) ...
Stefan
Although CentOS development runs at the very cautious speed of Redhat (or actually slower than Redhat) for some of us that we don't like to make upgrades to production servers often CentOS is a fair alternative. Anyway the openssl problem will soon be solved when Centos 6 goes public since it would include 1.0.0.
Regards, Jerónimo
2011/6/7 Fabian Groffen Fabian.Groffen@cwi.nl
On 07-06-2011 12:21:44 -0300, Jerónimo Borque wrote:
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
This works because CentOS heavily patched their anchient openssl, such that it includes the >SHA-256 hashes that MonetDB requires. Officially, they are only available since 0.9.8f though.
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
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
On 13-06-2011 08:45:13 +0200, Stefan Manegold wrote:
On Sun, Jun 12, 2011 at 10:25:27PM -0300, Jerónimo Borque wrote:
Thank you Fabian, That explains it. Then CentOS can "easily" get supported, right? If you are interested I can try to investigate how to change the configure and spec to make them work for both Fedora and CentOS.
If you plan to invest time into this, please start with the plain sources from the MonetDB HG repository (cf., http://dev.monetdb.org/hg/MonetDB/), rather than the pre-packaged source tarball; i.e., check out the sources via
hg clone http://dev.monetdb.org/hg/MonetDB/
and then send us the diff.
However, with CentOS 6 on the horizon as you point out, I'm not sure whether there is need to patch our setup also for CentOS 5(.5); I'd rather suggest to wait for CentOS 6, aliminating the need for pacthes for OpenSSL (and maybe also for the spec files?) ...
We would need special spec files for CentOS to get the dependency matching for openssl there (given the knowledge we have about their patching state). It would also mean we have to hack configure to do something special for openssl on CentOS. Or, we should skip the version check, and instead look for the SHA hash-funcs we need and see if they are available somehow. The latter approach would be acceptable, but doesn't quite solve the spec dependency problem, IMO.
On 2011-06-13 10:28, Fabian Groffen wrote:
On 13-06-2011 08:45:13 +0200, Stefan Manegold wrote:
On Sun, Jun 12, 2011 at 10:25:27PM -0300, Jerónimo Borque wrote:
Thank you Fabian, That explains it. Then CentOS can "easily" get supported, right? If you are interested I can try to investigate how to change the configure and spec to make them work for both Fedora and CentOS.
If you plan to invest time into this, please start with the plain sources from the MonetDB HG repository (cf., http://dev.monetdb.org/hg/MonetDB/), rather than the pre-packaged source tarball; i.e., check out the sources via
hg clone http://dev.monetdb.org/hg/MonetDB/
and then send us the diff.
However, with CentOS 6 on the horizon as you point out, I'm not sure whether there is need to patch our setup also for CentOS 5(.5); I'd rather suggest to wait for CentOS 6, aliminating the need for pacthes for OpenSSL (and maybe also for the spec files?) ...
We would need special spec files for CentOS to get the dependency matching for openssl there (given the knowledge we have about their patching state). It would also mean we have to hack configure to do something special for openssl on CentOS. Or, we should skip the version check, and instead look for the SHA hash-funcs we need and see if they are available somehow. The latter approach would be acceptable, but doesn't quite solve the spec dependency problem, IMO.
The spec dependency can probably be solved with a conditional in the spec file that distinguishes CentOS from the rest of the world. I'm assuming there is a variable available that we can use for that.
I installed monetdb_11.1.1-20110324 in my development enviroment and everything works great under ubuntu desktop 10.10, when I installed the same version of monetdb in the production enviroment on ubuntu server 10.10 the connections and querys are very slow, It doesn't happen in my development enviroment, I already use the package installation and the source code. Same result. Do you have any idea why? Need to configure something different?
Thanks in advance.
On 14-06-2011 00:12:43 +0000, julio Puebla wrote:
I installed monetdb_11.1.1-20110324 in my development enviroment and everything works great under ubuntu desktop 10.10, when I installed the same version of monetdb in the production enviroment on ubuntu server 10.10 the connections and querys are very slow, It doesn't happen in my development enviroment, I already use the package installation and the source code. Same result. Do you have any idea why?
What exactly do you mean with "slow"? Is the query execution slow? Is making connections slow? Debian/Ubuntu has a known odd behaviour of having a very slow startup time of monetdbd.
When I run
COPY 5000 RECORDS INTO myTests FROM '/home/loadFile88.csv' USING DELIMITERS ',';
In my development enviroment makes it very fast, but in my ubuntu server 10.10 makes it very very slow took 2 minutes to complete this task.
Date: Tue, 14 Jun 2011 09:48:31 +0200 From: Fabian.Groffen@cwi.nl To: monetdb-users@lists.sourceforge.net Subject: Re: [MonetDB-users] problem with ubuntu server 10.10
On 14-06-2011 00:12:43 +0000, julio Puebla wrote:
I installed monetdb_11.1.1-20110324 in my development enviroment and everything works great under ubuntu desktop 10.10, when I installed the same version of monetdb in the production enviroment on ubuntu server 10.10 the connections and querys are very slow, It doesn't happen in my development enviroment, I already use the package installation and the source code. Same result. Do you have any idea why?
What exactly do you mean with "slow"? Is the query execution slow? Is making connections slow? Debian/Ubuntu has a known odd behaviour of having a very slow startup time of monetdbd.
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
On 6/15/11 12:14 AM, julio Puebla wrote:
When I run
COPY 5000 RECORDS INTO myTests FROM '/home/loadFile88.csv' USING DELIMITERS ',';
In my development enviroment makes it very fast, but in my ubuntu server 10.10 makes it very very slow took 2 minutes to complete this task.
There are many issues involved that can cause this to happen. Most likely it is related to what is running on your server, (check top to see how much other stuff is running), and how it attaches to the disk drive (see iotop), the file system type and location (see /etc/mount). Not to mention just basic hardware differences.
Overall, the information provided does not provide us enough contextual information to be of much help here.
regards, Martin
Date: Tue, 14 Jun 2011 09:48:31 +0200 From: Fabian.Groffen@cwi.nl To: monetdb-users@lists.sourceforge.net Subject: Re: [MonetDB-users] problem with ubuntu server 10.10
On 14-06-2011 00:12:43 +0000, julio Puebla wrote:
I installed monetdb_11.1.1-20110324 in my development enviroment and everything works great under ubuntu desktop 10.10, when I installed the same version of monetdb in the production enviroment on ubuntu server 10.10 the connections and querys are very slow, It doesn't happen in my development enviroment, I already use the package installation and the source code. Same result. Do you have any idea why?
What exactly do you mean with "slow"? Is the query execution slow? Is making connections slow? Debian/Ubuntu has a known odd behaviour of having a very slow startup time of monetdbd.
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
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
Hi Jennie,
could you say me please, how can I import tables in a database with a file. I have a .sql-File and the content is for example like this:
data.sql
DROP TABLE IF EXISTS `actor`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `actor` ( `actor_id` int(8) NOT NULL, `first_name` varchar(50) DEFAULT NULL, `last_name` varchar(50) NOT NULL, `initials` varchar(10) DEFAULT NULL, PRIMARY KEY (`actor_id`) )
LOCK TABLES `actor` WRITE; /*!40000 ALTER TABLE `actor` DISABLE KEYS */; INSERT INTO `actor` VALUES (1,'Mack','10',NULL),(2,'Highway','101',NULL), ... INSERT INTO `actor` VALUES (33350,'Nicholas','Pasco',NULL),(33351,'Richard', ... INSERT INTO `actor` VALUES (66434,'Joseph','Roman',NULL),(66435,'Garry', ...
This file contains nearly by 20 tables with data sets.
Thanks
You might inspect:
http://www.monetdb.org/Documentation/SQLreference
for general advice. The manual contains a short description for the specific challenge:. http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto
regards, Martin
On 6/1/11 9:03 PM, Lowterm wrote:
Hi Jennie,
could you say me please, how can I import tables in a database with a file. I have a .sql-File and the content is for example like this:
data.sql
DROP TABLE IF EXISTS `actor`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `actor` ( `actor_id` int(8) NOT NULL, `first_name` varchar(50) DEFAULT NULL, `last_name` varchar(50) NOT NULL, `initials` varchar(10) DEFAULT NULL, PRIMARY KEY (`actor_id`) )
LOCK TABLES `actor` WRITE; /*!40000 ALTER TABLE `actor` DISABLE KEYS */; INSERT INTO `actor` VALUES (1,'Mack','10',NULL),(2,'Highway','101',NULL), ... INSERT INTO `actor` VALUES (33350,'Nicholas','Pasco',NULL),(33351,'Richard', ... INSERT INTO `actor` VALUES (66434,'Joseph','Roman',NULL),(66435,'Garry', ...
This file contains nearly by 20 tables with data sets.
Thanks
Hi Martin,
thanks for your reply but it can't help me. I could not find any example and solution for my problem. I would like to import SQL-Tabels with contents to MonetDB and not from MonetDB to a File to import in SQL. My SQL-File should be invoked from MonetDB and the Tables with contents should be created automatically in my database within MonetDB. Is that possible? I need a example please.
Thanks
You probably intend to use the redirect offered by the mclient tool?
shell> mclient Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.4.0, 'mTests_benchmarks_wisconsin' Type \q to quit, ? for a list of available commands auto commit mode: on sql>? ? - show this message <file - read input from file >file - save response in file, or stdout if no file is given |cmd - pipe result to process, or stop when no command is given \h - show the readline history \t - toggle timer \D table- dumps the table, or the complete database if none given. \d[Stvsfn]+ [obj] - list database objects, or describe if obj given \A - enable auto commit \a - disable auto commit \e - echo the query in sql formatting mode \f - format using a built-in renderer {csv,tab,raw,sql,xml} \w# - set maximal page width (-1=unlimited, 0=terminal width, >0=limit to num) \r# - set maximum rows per page (-1=raw) \L file - save client/server interaction \X - trace mclient code \q - terminate session
On 6/2/11 8:18 AM, Lowterm wrote:
Hi Martin,
thanks for your reply but it can't help me. I could not find any example and solution for my problem. I would like to import SQL-Tabels with contents to MonetDB and not from MonetDB to a File to import in SQL. My SQL-File should be invoked from MonetDB and the Tables with contents should be created automatically in my database within MonetDB. Is that possible? I need a example please.
Thanks
On 6/2/11 8:27 AM, Martin Kersten wrote:
You probably intend to use the redirect offered by the mclient tool?
You might have a look at http://www.monetdb.org/Downloads/Tutorial which describes its use.
shell> mclient Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.4.0, 'mTests_benchmarks_wisconsin' Type \q to quit, ? for a list of available commands auto commit mode: on sql>? ? - show this message <file - read input from file >file - save response in file, or stdout if no file is given |cmd - pipe result to process, or stop when no command is given \h - show the readline history \t - toggle timer \D table- dumps the table, or the complete database if none given. \d[Stvsfn]+ [obj] - list database objects, or describe if obj given \A - enable auto commit \a - disable auto commit \e - echo the query in sql formatting mode \f - format using a built-in renderer {csv,tab,raw,sql,xml} \w# - set maximal page width (-1=unlimited, 0=terminal width,>0=limit to num) \r# - set maximum rows per page (-1=raw) \L file - save client/server interaction \X - trace mclient code \q - terminate session
On 6/2/11 8:18 AM, Lowterm wrote:
Hi Martin,
thanks for your reply but it can't help me. I could not find any example and solution for my problem. I would like to import SQL-Tabels with contents to MonetDB and not from MonetDB to a File to import in SQL. My SQL-File should be invoked from MonetDB and the Tables with contents should be created automatically in my database within MonetDB. Is that possible? I need a example please.
Thanks
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. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (8)
-
Fabian Groffen -
Jerónimo Borque -
julio Puebla -
Lowterm -
Martin Kersten -
Sjoerd Mullender -
Stefan Manegold -
Ying Zhang