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

10 Sep 2008

      Ok great!! i'm looking forward to some updates when Sjoerd has a chance.

Thanks
SB

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

On Wed, Sep 10, 2008 at 01:17:49AM -0700, sylver_b wrote:
...
That will do fine and i can scrap the perl tool all together if this can do the job - I will try that .
Good. --- In fact bulk-loading via COPY INTO is by far the fasted way to
load data into MonetDB.
...
any idea for the ODBC issue ? is it maintained by you guys (cwi ) ?
ODBC is maintained at CWI by Sjoerd.
I guess, Sjoerd will have a look at it as soon as his time allows.

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

sylver_b

Sjoerd Mullender

tags

participants (2)