- users-list - monetdb.org

Re: [MonetDB-users] help please
by Stefan Manegold 25 Aug '06

25 Aug '06

George, if everything works well, there should be daily-built MonetDB/SQL RPMs available also for 64-bit SuSE as of tomorrow (european) morning from http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… I found and (hopefully) fixed the bug that prevented them from being built. Stefan On Wed, Aug 23, 2006 at 05:46:44AM -0700, George H wrote: > Stefan: > > Thanks so much for everything. > > You've been the greatest. > > George > > > … [View More] > Stefan Manegold wrote: > > >Hi George, > > > >On Tue, Aug 22, 2006 at 05:23:52PM -0700, George H wrote: > > > > > >>Hey Stephan: > >> > >>On SuSE 10.1 (AMD64) using download from SourceForge (developed on > >>Fedora Core as you said) I got: > >> > >># rpm -ivh MonetDB-client-4.12.0-1.x86_64.rpm > >> > >>error: Failed dependencies: > >> > >>libcrypto.so.5 () (64bit) is needed > >>libssl.so.5 () (64bit) is needed > >>libtermcap.so.2 () (64bit) is needed > >> > >> > > > >libcrypto.so, libssl.so libtermcap.so are indeed required --- it appears, > >though that FC4 comes with > > libcrypto.so.5, libssl.so.5, libtermcap.so.2, > >(which are actually symlinks to > > libcrypto.so.0.9.7f, libssl.so.0.9.7f, libtermcap.so.2.0.8 > >respectively), while SuSE 9.3 (and apparently also 10.1) comes with > > libcrypto.so.0, /usr/lib64/libssl.so.0 > >(which are actually symlinks to > > libcrypto.so.0.9.7f, libssl.so.0.9.7f > >respectively). > >Hence, the FC4 RPMs do not fit SuSE 9.3 and 10.1 > > > > > > > >>I downloaded the sever and client for SuSE 9.3 as you recommended from > >>http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > >>Both seemed to install fine and the Mserver command brough me to the > >> > >> > > > >good. > > > > > > > >>MonetDB> prompt, however with the following warnings. > >> > >>!Warning: GDKlockHome: created directory /var/lib/MonetDB/defarm/demo/ > >>!Warning: GDKlockhome:ignoring empty or invalid .gdk_lock > >>!Warning: BBPdir: initializng BBP > >> > >>Are these a problem? > >> > >> > > > >nope, that normal when you start Mserver for the firt time. > >It just creates and initializes the location for its databases. > > > > > > > >>Finally, I tryed rpm -ivh MonetDB-SQL-server-2.12.0-1.x86_64.rpm. The > >>result > >> > >>error: Failed dependencies: > >> > >>libcrypto.so.5 () (64bit) is needed > >>libssl.so.5 () (64bit) is needed > >> > >> > > > >that's the FC4 RPM, right? > >Hence, same problem as mentioned above. > > > > > > > >>Is there an SQL-server frontend for SuSe 9.3 or some other solution that > >>would allow meto have an SQL frontend to use with the install success I > >>had with the MonetDB for SuSe9.3? Or am I forced to use FedoraCore if I > >>need the SQL? I sure hope not. > >> > >> > > > >There is supposed to be an SQL frontend RPM also for SuSE 9.3 at > >http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > > > >However, the compilation of that seem to have failed recently (at least > >last > >night) --- I cannot yet see/understand why (in fact, compilation worked, > >but > >creating the RPMs failed) --- We'll (try to) look into this ... > >... sorry for the inconvenience... > > > >Hence, you'll either have to wait until we manage to fix the RPM build for > >MonetDB/SQL on SuSE 9.3 (64-bit; it works on/for 32-bit: > >http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > >), or you could get the source code (source-RPM or tar ball) for > >MonetDB/SQL, i.e., > > MonetDB-SQL-2.12.0-1.src.rpm or MonetDB-SQL-2.12.0.tar.gz from > > http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=1141… > > or > > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceR… > > or > > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceT… > > > >and compile them yourself (next to the MonetDB-server & MonetDB-client > >RPMs, > >also the MonetDB-devel RPM needs to be installed). > > > >Let us know, in case you have more problems/questions. > > > >Stefan > > > > > >ps: Could you please also cc the Monetdb-users(a)lists.sourceforge.net > >mailing > > list in your replies? > > Other might be interested in this topic as well... > > Thanks in advance! > > > > > > > > > >>Thanks Stephen. > >> > >>Best to you....George > >> > >> > >> > >>Stefan Manegold wrote: > >> > >> > >> > >>>Dear George, > >>> > >>>to install the MonetDB-server-4.12.0-1.*.rpm, you also need to install > >>>the respective > >>>MonetDB-client-4.12.0-1.*.rpm, as mentioned in the release notes at > >>> http://sourceforge.net/project/shownotes.php?release_id=427002&group_id=569…: > >>>"[...] the MonetDB-server-4.12.0-1.*.rpm requires the corresponding > >>>MonetDB-client-4.12.0-1.*.rpm to be installed as well." > >>> > >>>You get the MonetDB-client-4.12.0-1.*.rpm from the same SF download page > >>>as > >>>MonetDB-server-4.12.0-1.*.rpm: > >>> http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=5234… > >>> > >>> > >>>What are the missing dependencies for MonetDB-client-4.12.0-1.x86_64.rpm? > >>>Could you please send/post the list? > >>>(Most probably, they are indeed required....) > >>> > >>> > >>>Note though, that the RPM available from SF have been built on (and for) > >>>a > >>>Fedora Core 4 system, hence, there *might* be problem with installing > >>>them > >>>on a SuSE 10.1 system. > >>> > >>>We don't have (access to) a (64-bit) SuSE 10.1 system, yet, hence, we > >>>cannot > >>>provide any SuSE 10.1 specific RPMs, yet. > >>> > >>>All we can currently offer (in case you don't manage to install the > >>>Fedora > >>>Core 4 RPMs), are SuSE 9.3 RPMs form our MonetDB web site at > >>> http://monetdb.cwi.nl/GetGoing/Download/index.html > >>>(scroll down to 'Daily Builds') and click on 'CVS release branch > >>>("Stable")', or directly go to > >>> http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > >>> > >>>(There have been only minor bug fixes on the release branch, hence there > >>>should be no major differences between the 4.12.0 release from SF and the > >>>4.12.1 daily builds...) > >>> > >>> > >>>Kind Regards, > >>> > >>>Stefan > >>> > >>> > >>>On Tue, Aug 22, 2006 at 12:11:52PM -0700, George H wrote: > >>> > >>> > >>> > >>> > >>>>Hello: > >>>> > >>>>I am new to MonetDB and I'm no linux wizard either, so please excuse, > >>>>but can you help. > >>>> > >>>>I'm trying to install MonetDB-server-4.12.0-x86_64.rpm on SuSE 10.1 > >>>>(amd64) using the rpm -ivh command and I have "error: Failed > >>>>dependencies." > >>>> > >>>>It says libMapi.so.0 () (64bit), libcrypto.so.5 () (64bit), > >>>>libmutils.so.0 () (64bit), libssl.so.5 () (64bit), libstream.so.0 () > >>>>(64bit) are needed. > >>>> > >>>>Where do I get these? I've been searching, but all I can find is their > >>>>presence in other rpm packages. For example, I see that some of these > >>>>are in the MonetDB-client-4.12.0-1.x86_64.rpm, but it has it's own > >>>>lengthy list of missing dependencies for installation. > >>>> > >>>>Can you give me a hint. I feel like I'm in dependency hell, but I > >>>>realizie I'm more likely in naive dumblandia. > >>>> > >>>>Help please........Thanks, George > >>>> > >>>>------------------------------------------------------------------------- > >>>>Using Tomcat but need to do more? Need to support web services, > >>>>security? > >>>>Get stuff done quickly with pre-integrated technology to make your job > >>>>easier > >>>>Download IBM WebSphere Application Server v.1.0.1 based on Apache > >>>>Geronimo > >>>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > >>>>_______________________________________________ > >>>>MonetDB-users mailing list > >>>>MonetDB-users(a)lists.sourceforge.net > >>>>https://lists.sourceforge.net/lists/listinfo/monetdb-users > >>>> > >>>> > >>>> > >>>> > >>>> > >>> > >>> > >>> > > > > > > > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 | [View Less]

2 2

Re: [MonetDB-users] help please
by Stefan Manegold 23 Aug '06

23 Aug '06

Hi George, On Tue, Aug 22, 2006 at 05:23:52PM -0700, George H wrote: > Hey Stephan: > > On SuSE 10.1 (AMD64) using download from SourceForge (developed on > Fedora Core as you said) I got: > > # rpm -ivh MonetDB-client-4.12.0-1.x86_64.rpm > > error: Failed dependencies: > > libcrypto.so.5 () (64bit) is needed > libssl.so.5 () (64bit) is needed > libtermcap.so.2 () (64bit) is needed libcrypto.so, libssl.so libtermcap.so are indeed required --- it … [View More]appears, though that FC4 comes with libcrypto.so.5, libssl.so.5, libtermcap.so.2, (which are actually symlinks to libcrypto.so.0.9.7f, libssl.so.0.9.7f, libtermcap.so.2.0.8 respectively), while SuSE 9.3 (and apparently also 10.1) comes with libcrypto.so.0, /usr/lib64/libssl.so.0 (which are actually symlinks to libcrypto.so.0.9.7f, libssl.so.0.9.7f respectively). Hence, the FC4 RPMs do not fit SuSE 9.3 and 10.1 > I downloaded the sever and client for SuSE 9.3 as you recommended from > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > Both seemed to install fine and the Mserver command brough me to the good. > MonetDB> prompt, however with the following warnings. > > !Warning: GDKlockHome: created directory /var/lib/MonetDB/defarm/demo/ > !Warning: GDKlockhome:ignoring empty or invalid .gdk_lock > !Warning: BBPdir: initializng BBP > > Are these a problem? nope, that normal when you start Mserver for the firt time. It just creates and initializes the location for its databases. > Finally, I tryed rpm -ivh MonetDB-SQL-server-2.12.0-1.x86_64.rpm. The > result > > error: Failed dependencies: > > libcrypto.so.5 () (64bit) is needed > libssl.so.5 () (64bit) is needed that's the FC4 RPM, right? Hence, same problem as mentioned above. > Is there an SQL-server frontend for SuSe 9.3 or some other solution that > would allow meto have an SQL frontend to use with the install success I > had with the MonetDB for SuSe9.3? Or am I forced to use FedoraCore if I > need the SQL? I sure hope not. There is supposed to be an SQL frontend RPM also for SuSE 9.3 at http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… However, the compilation of that seem to have failed recently (at least last night) --- I cannot yet see/understand why (in fact, compilation worked, but creating the RPMs failed) --- We'll (try to) look into this ... ... sorry for the inconvenience... Hence, you'll either have to wait until we manage to fix the RPM build for MonetDB/SQL on SuSE 9.3 (64-bit; it works on/for 32-bit: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… ), or you could get the source code (source-RPM or tar ball) for MonetDB/SQL, i.e., MonetDB-SQL-2.12.0-1.src.rpm or MonetDB-SQL-2.12.0.tar.gz from http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=1141… or http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceR… or http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceT… and compile them yourself (next to the MonetDB-server & MonetDB-client RPMs, also the MonetDB-devel RPM needs to be installed). Let us know, in case you have more problems/questions. Stefan ps: Could you please also cc the Monetdb-users(a)lists.sourceforge.net mailing list in your replies? Other might be interested in this topic as well... Thanks in advance! > Thanks Stephen. > > Best to you....George > > > > Stefan Manegold wrote: > > >Dear George, > > > >to install the MonetDB-server-4.12.0-1.*.rpm, you also need to install the > >respective > >MonetDB-client-4.12.0-1.*.rpm, as mentioned in the release notes at > > http://sourceforge.net/project/shownotes.php?release_id=427002&group_id=569…: > >"[...] the MonetDB-server-4.12.0-1.*.rpm requires the corresponding > >MonetDB-client-4.12.0-1.*.rpm to be installed as well." > > > >You get the MonetDB-client-4.12.0-1.*.rpm from the same SF download page as > >MonetDB-server-4.12.0-1.*.rpm: > > http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=5234… > > > > > >What are the missing dependencies for MonetDB-client-4.12.0-1.x86_64.rpm? > >Could you please send/post the list? > >(Most probably, they are indeed required....) > > > > > >Note though, that the RPM available from SF have been built on (and for) a > >Fedora Core 4 system, hence, there *might* be problem with installing them > >on a SuSE 10.1 system. > > > >We don't have (access to) a (64-bit) SuSE 10.1 system, yet, hence, we > >cannot > >provide any SuSE 10.1 specific RPMs, yet. > > > >All we can currently offer (in case you don't manage to install the Fedora > >Core 4 RPMs), are SuSE 9.3 RPMs form our MonetDB web site at > > http://monetdb.cwi.nl/GetGoing/Download/index.html > >(scroll down to 'Daily Builds') and click on 'CVS release branch > >("Stable")', or directly go to > > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > > > >(There have been only minor bug fixes on the release branch, hence there > >should be no major differences between the 4.12.0 release from SF and the > >4.12.1 daily builds...) > > > > > >Kind Regards, > > > >Stefan > > > > > >On Tue, Aug 22, 2006 at 12:11:52PM -0700, George H wrote: > > > > > >>Hello: > >> > >>I am new to MonetDB and I'm no linux wizard either, so please excuse, > >>but can you help. > >> > >>I'm trying to install MonetDB-server-4.12.0-x86_64.rpm on SuSE 10.1 > >>(amd64) using the rpm -ivh command and I have "error: Failed > >>dependencies." > >> > >>It says libMapi.so.0 () (64bit), libcrypto.so.5 () (64bit), > >>libmutils.so.0 () (64bit), libssl.so.5 () (64bit), libstream.so.0 () > >>(64bit) are needed. > >> > >>Where do I get these? I've been searching, but all I can find is their > >>presence in other rpm packages. For example, I see that some of these > >>are in the MonetDB-client-4.12.0-1.x86_64.rpm, but it has it's own > >>lengthy list of missing dependencies for installation. > >> > >>Can you give me a hint. I feel like I'm in dependency hell, but I > >>realizie I'm more likely in naive dumblandia. > >> > >>Help please........Thanks, George > >> > >>------------------------------------------------------------------------- > >>Using Tomcat but need to do more? Need to support web services, security? > >>Get stuff done quickly with pre-integrated technology to make your job > >>easier > >>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > >>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > >>_______________________________________________ > >>MonetDB-users mailing list > >>MonetDB-users(a)lists.sourceforge.net > >>https://lists.sourceforge.net/lists/listinfo/monetdb-users > >> > >> > >> > > > > > > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 | [View Less]

1 0

[MonetDB-users] help please
by George H 22 Aug '06

22 Aug '06

Hello: I am new to MonetDB and I'm no linux wizard either, so please excuse, but can you help. I'm trying to install MonetDB-server-4.12.0-x86_64.rpm on SuSE 10.1 (amd64) using the rpm -ivh command and I have "error: Failed dependencies." It says libMapi.so.0 () (64bit), libcrypto.so.5 () (64bit), libmutils.so.0 () (64bit), libssl.so.5 () (64bit), libstream.so.0 () (64bit) are needed. Where do I get these? I've been searching, but all I can find is their presence in other rpm packages.… [View More]

2 1

Re: [MonetDB-users] return type of 'count' in mil
by Stefan Manegold 14 Aug '06

14 Aug '06

Jenny, the return type of count is "legacy". You're right, in case of BATs with more than 2^31 BUNs (possible only on 64-bit systems), the default count(BAT[any,any]):int will fail (or at least return a wrong result. We hanven't changed it to count(BAT[any,any]):lng, yet, maily due to backward-compatibility and due to the fact that a grouped-count ({count}(BAT[any::1,any::2]):BAT[any::1,int/lng]) would than in all cases return a BAT[any,lng], possibly "wasting" space compared to a BAT[any,int].… [View More] Eventually, count should return a vraiable integer type that is 32-bit on 32-bit systems and 64-bit on 64-bit systems --- I've been planning to add this "word" type (together with a "proper" 1-byte integer "byte") for quite some time, but it never made it to the very top op my priority-ordered todo list... for now, in case you indeed need th count of >2^31 BUN BATs, you can use count(int):lng, where you provide the BAT's id (i.e., int(BAT)) iso. the BAT itself as argument: ======== MonetDB>help("count"); COMMAND: count(BAT[any,any], bit) : int MODULE: algebra COMPILED: by adm on Mon Aug 7 18:07:14 2006 Returns the number of elements currently in a BAT; ignores BUNs with nil-tail iff ignore_nils==TRUE. COMMAND: count(BAT[any,any]) : int MODULE: algebra COMPILED: by adm on Mon Aug 7 18:07:14 2006 Returns the number of elements currently in a BAT. COMMAND: count(BAT[void,void], lng) : lng MODULE: bat COMPILED: by adm on Mon Aug 7 18:07:14 2006 Sets the size (in number of elements) of a BAT. COMMAND: count(int) : lng MODULE: bat COMPILED: by adm on Mon Aug 7 18:07:14 2006 Returns the current size (in number of elements) of a BAT. MonetDB> ======== Stefan On Wed, Aug 09, 2006 at 04:29:33PM +0200, Ying Zhang wrote: > hi stefan, > > I'm wondering if the return type 'int' of the mil command 'count' is > correct. According to help("count"): > > ... > COMMAND: count(BAT[any,any]) : int > MODULE: algebra > COMPILED: by adm on Mon Aug 7 15:11:12 2006 > Returns the number of elements currently in a BAT. > ... > > what if I want to count a BAT[oid,oid] which contains a max. nr. of BUNs > that a BAT with 64bits oid can have. would this be a problem, since > 'oid' is of 64bits on 64bits machines, while 'int' is of 32bits? or is > a mil 'int' different than a C 'int', namely the size of a mil 'int' > also varias in different machines? > > Thanks > > Jennie -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 | [View Less]

1 0

[MonetDB-users] MonetDB-XQuery and C#
by Arthur van Bunningen 11 Aug '06

11 Aug '06

Dear all, As we are writing a windows application which will store and query structured documents in a database and we want to use MonetDB/XQuery as database backend, we wondered what the easiest method is to access MonetDB/XQuery from C#. For what it's worth: parsing the XML results is of course no problem, and ODBC is supported. Hopefully some of you can point us to a workable solution. Thanks in advance, Arthur

4 3

[MonetDB-users] xquery over large amount of small documents
by Martijn Faassen 02 Aug '06

02 Aug '06

Hi there, I asked something like this question last year and I'm basically checking up on the progress since then. I hope this mail is not interpreted as demanding anything; I can see you guys are doing impressive work, I'm just trying to give feedback from the perspective of an application developer drooling over the potential of XML databases.. I can see on your website that collections() support is not there yet (marked as "will", though). I also looked at this page: http://monetdb.… [View More]

2 2

[MonetDB-users] Question about MonetDB ODBC driver configuration
by china-davy 27 Jul '06

27 Jul '06

Hi: I have installed MonetDB (Operationg system is windows xp) and the ODBC driver.I want to connet the MonetDB server through ODBC driver,so I must do some configuration work,for example the "databasename,username,and so on".But the configuration work is forbidded(When I click the "MonetDB" in the windows ODBC Manager,nothing happned to let me do configure work,and,not error message )?could you tell me why,and,how to confiigure the ODBC? -- View this message in context: http://www.nabble.… [View More]

2 1

[MonetDB-users] 回复: help! where i get manual
by Fabian 17 Jul '06

17 Jul '06

Hi Peter Chen, I'm not very familiar with ODBC. I'm sending your question to the monetdb-users mailing list. I expect someone there to be able to better answer your question. Regards On 12-07-2006 09:08:59 +0800, liudawei wrote: > Hi Groffen: > > I have install the MonetDB to my computer (Operationg system is windows) and the ODBC driver.I want to connet the MonetDB server through ODBC driver,so I must do some configuration work.But the configuration work is forbidded，… [View More]

3 3

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Michael Schmidt 12 Jul '06

12 Jul '06

Hi all, > I read the discussion, and I might have experienced the same kind of problem > before. I think there is some problem with the naming (when a document is > previously shredded with the same name as a 'cached' document). At the time > I experienced the problem I couldn't figure out what the exact problem was, > but removing the dbfarm worked for me: > > So perhaps you could try to: > - stop Mserver > - completely remove the dbfarm-folder (defaultpath is … [View More]

3 2

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Michael Schmidt 11 Jul '06

11 Jul '06

Hello Stefan, thank you very much for your engagement! > In the meantime, I have some more questions for you: > > Which version of SuSE Linux and which version of gcc do you use? I am running SuSe Linux 10.0 and gcc (GCC) 4.0.2 20050901 (prerelease) (SUSE Linux). > Which exact version of the MonetDB source do you use? > - The released tar-balls from SourceForge > (MonetDB-4.12.0.tar.gz & MonetDB-XQuery-0.12.0.tar.gz)? Yes, I used the tar balls. During … [View More]

2 1