On 12-11-2007 13:17:49 +0100, marco.antonelli82@fastwebnet.it wrote:

Hello everyone, I successfully managed to install MonetDB components(MonetDB-common, MonetDB clients, MonetDB5-server, MonetDB_SQL) on Linux, but I have some problems in running it. These are the steps that I followed from the online documentation: I started merovingian with:

sudo merovingian

then I created the "demo" database and started it with:

sudo monetdb create demo sudo monetdb start demo

I checked the status:

sudo monetdb status demo name state uptime crashes demo running 29m 6s 0

(if I run this command without 'sudo' i get:

monetdb status demo warning: MonetDB Database Server is not running name state uptime crashes demo stopped 1 2007-11-12 12:33:41

Is that normal?)

That is a bug that I observed last week too. I have to spend some time on it to get that right.

So everything seems fine, but when I run mclient (both as root and normal user) I got an error:

mclient -lsql --database=demo !ERROR mapi_reconnect: connect: No route to host Setup connection failed

I even tried to add a kernel route with:

sudo route add -host localhost lo

but it did not help.

Does somebody know what is the problem and how to solve it?

Can you check the merovingian.log file to see if it actually sees a client connecting, or maybe give another hint why things go wrong? A possible explanation may be when your hostname could not be resolved to a (local) ip address.