[Monetdb-developers] Re : Re : ODBC, no database selected

That will do fine and i can scrap the perl tool all together if this can do the job - I will try that . any idea for the ODBC issue ? is it maintained by you guys (cwi ) ? Thanks ----- Message d'origine ---- De : Stefan Manegold À : sylver_b Cc : monetdb-developers@lists.sourceforge.net Envoyé le : Mercredi, 10 Septembre 2008, 9h06mn 57s Objet : Re : [Monetdb-developers] ODBC, no database selected On Wed, Sep 10, 2008 at 12:21:46AM -0700, sylver_b wrote:

Hi Stefan,

I've started the DB with the following commands : 1. merovingian 2. monetdb create demo 3. monetdb start demo 3. mclient -lsql --time -d demo

I get the prompt straight away, but i have to specify the db - mclient -lsql , says: !please specify a database - i don't have any other DB at the moment, just evaluating monetdb to migrate a call detail records application ; for that purpose i've developed a simple ETL tool in perl that extract specific fields from a CSV file and insert them in the DB. Maybe there is a better way to do that ?

In case you need the perl part only for extracting and loading, a simple work around to get a quick start, in case you/we do not manage to get the perl interface working for you quickly, would be to either load all fields from your CSV file using sql "COPY ... INTO .. FROM ..." command (cf., http://monetdb.cwi.nl/SQL/Documentation/Data-Manipulation.html), or extract the desired fileds into a separate CSV file, first, and then load using "COPY ... INTO .. FROM ..." (e.g., via mclient) ... Stefan

by the way , ps faux gives me : root 11224 0.0 0.0 63160 1816 pts/2 Sl 00:17 0:00 merovingian root 11229 0.0 1.7 107680 69816 ? Ssl 00:17 0:00 \_ /root/MonetDB/bin/mserver5 --config=/root/MonetD B/etc/monetdb5.conf --dbname=demo --dbinit=include sql; --set monet_daemon yes --set mapi_open true --set mapi_port 0 --set monet_vault_key /root/MonetDB/var/MonetDB5/dbfarm/demo/.vaultkey

Please advise, Thanks SB

----- Message d'origine ---- De : Stefan Manegold À : sylver_b Cc : monetdb-developers@lists.sf.net Envoyé le : Mercredi, 10 Septembre 2008, 6h19mn 03s Objet : Re: [Monetdb-developers] ODBC, no database selected

Hi "sylver_b",

just a simple & quick saniy check:

How did you start your MonetDB server?

Can you connect with `mclient -lsql`?

Stefan

On Tue, Sep 09, 2008 at 04:56:47PM -0700, sylver_b wrote:

...

Hi Eveyone,

I'm trying to connect to monetdb with this time, ODBC - but still no luck.

Here is the output of my script :

./monetdb2.pl DBI connect('DSN_MonetDB','monetdb',...) failed: [unixODBC][MonetDB][ODBC Driver 1.0]Client unable to establish connection (SQL-08001)(DBD: db_login/SQLConnect err=-1) at ./monetdb2.pl line 6 [unixODBC][MonetDB][ODBC Driver 1.0]Client unable to establish connection (SQL-08001)(DBD: db_login/SQLConnect err=-1)

cat monetdb2.pl #!/usr/bin/perl

use DBI();

my $dbh = DBI-> connect('dbi:ODBC:DSN_MonetDB', 'monetdb', 'monetdb', {database => demo}) or die ($DBI::errstr . "\n");

if (!$dbh) { print "$DBI::err\n$DBI::errstr\n$DBI::state"; } else { $dbh->disconnect if ($dbh); }

my $sth = $dbh->prepare('SELECT * FROM env() env'); $sth->execute; $sth->dump_results;

This the merovingian output : tail -f /root/MonetDB/var/log/merovingian.log MSG demo[11229]: # MonetDB server v5.6.0, based on kernel v1.24.0 MSG demo[11229]: # Serving database 'demo' MSG demo[11229]: # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked MSG demo[11229]: # Copyright (c) 1993-2008 CWI, all rights reserved MSG demo[11229]: # Visit http://monetdb.cwi.nl/ for further information MSG demo[11229]: # Listening for connection requests on mapi:monetdb://ulys:50001/ ERR merovingian[11224]: client error: no database specified MSG merovingian[11224]: database 'demo' already running since 2008-09-10 00:17:32, up min/avg/max: 30/2181/7036, crash average: 0.00 0.00 0.00 (6-5=0) MSG merovingian[11224]: proxying client 127.0.0.1:59244 for database 'demo' to mapi:monetdb://ulys:50001/ MSG merovingian[11224]: client has 127.0.0.1:59244 disconnected from proxy

ERR merovingian[11224]: client error: no database specified

This is the content of my odbc.ini & odbcinst.ini :

[DSN_MonetDB] Description = ODBC Driver for MonetDB SQL Server Driver = /root/MonetDB/lib/libMonetODBC.so Port = 50000 Host = localhost Database = demo User = monetdb Password = monetdb Debug = 1 Trace = 1 DebugFile = /var/log/odbc-debugfile.log TraceFile = /var/log/odbc-tracefile.log

odbcinst.ini [DSN_MonetDB] Description = ODBC Driver for MonetDB SQL Server Driver = /root/MonetDB/lib/libMonetODBC.so Setup = /root/MonetDB/lib/libMonetODBCs.so FileUsage = 1 CommLog = 1 Debug = 1

I also tried with PHP odbc, same result - how to specify the DB right from the script ?

------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers

-- | 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 |

-- | 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 |