[Monetdb-developers] embedded mserver...
I start the mserver with the following command: ./mserver5 --set embedded=yes --dbinit="include sql;" & mclient connection is refused. The I decided to set the mapi_port: --set mapi_port=50000 & Mclient connection is again refused for port 50000: [goncalve@amelia bin]$ mclient -lsql !ERROR mapi_reconnect: connect: Connection refused Setup connection failed [goncalve@amelia bin]$ and for port 33177 isn't: [goncalve@amelia bin]$ mclient -lsql -P33177 User (goncalve): [goncalve@amelia bin]$ As you can see the above example the user used for the connection is goncalve and not monetdb. Why the default user is not monetdb? And why this port? This example (the first command to start mserver) was taken from our web-site... http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Embedded-Server.htm... Regards, Romulo
Romulo Goncalves wrote:
I start the mserver with the following command: ./mserver5 --set embedded=yes --dbinit="include sql;" &
mclient connection is refused.
The I decided to set the mapi_port: --set mapi_port=50000 &
Mclient connection is again refused for port 50000: [goncalve@amelia bin]$ mclient -lsql !ERROR mapi_reconnect: connect: Connection refused Setup connection failed [goncalve@amelia bin]$
and for port 33177 isn't: [goncalve@amelia bin]$ mclient -lsql -P33177 User (goncalve): [goncalve@amelia bin]$
As you can see the above example the user used for the connection is goncalve and not monetdb. Why the default user is not monetdb? And why this port?
This example (the first command to start mserver) was taken from our web-site... http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Embedded-Server.htm... Just to report another problem:
All the links in this page are broken: * A Simple Example * Configuration Parameters * Embedded Limitations
Regards, Romulo
------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
Romulo Goncalves wrote:
Romulo Goncalves wrote:
I start the mserver with the following command: ./mserver5 --set embedded=yes --dbinit="include sql;" &
mclient connection is refused.
The I decided to set the mapi_port: --set mapi_port=50000 &
Mclient connection is again refused for port 50000: [goncalve@amelia bin]$ mclient -lsql !ERROR mapi_reconnect: connect: Connection refused Setup connection failed [goncalve@amelia bin]$
and for port 33177 isn't: [goncalve@amelia bin]$ mclient -lsql -P33177 User (goncalve): [goncalve@amelia bin]$
As you can see the above example the user used for the connection is goncalve and not monetdb. Why the default user is not monetdb? And why this port?
This example (the first command to start mserver) was taken from our web-site... http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Embedded-Server.htm... Just to report another problem:
All the links in this page are broken: * A Simple Example * Configuration Parameters * Embedded Limitations The web-site was being re-build by Niels that's why this links were down
Romulo
Regards, Romulo
------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
On 08-04-2008 13:43:54 +0200, Romulo Goncalves wrote:
and for port 33177 isn't: [goncalve@amelia bin]$ mclient -lsql -P33177 User (goncalve): [goncalve@amelia bin]$
As you can see the above example the user used for the connection is goncalve and not monetdb. Why the default user is not monetdb? And why this port?
-P passwd | --passwd=passwd password So it thinks you want to authorise yourself, and defaulting to "monetdb" there, doesn't make sense. Instead it falls back to your unix user name.
Fabian Groffen wrote:
On 08-04-2008 13:43:54 +0200, Romulo Goncalves wrote:
and for port 33177 isn't: [goncalve@amelia bin]$ mclient -lsql -P33177 User (goncalve): [goncalve@amelia bin]$
As you can see the above example the user used for the connection is goncalve and not monetdb. Why the default user is not monetdb? And why this port?
-P passwd | --passwd=passwd password
So it thinks you want to authorise yourself, and defaulting to "monetdb" there, doesn't make sense. Instead it falls back to your unix user name. Yes you are right. It was asking for all the login information for user goncalve. If I use -p I get connection refused because I was trying to connect to skype (this is the udp port of skype)... Maybe a new feature for mclient...
Mserver is not started properly for the embedded mode. Romulo
------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
On 08-04-2008 13:43:54 +0200, Romulo Goncalves wrote:
I start the mserver with the following command: ./mserver5 --set embedded=yes --dbinit="include sql;" &
mclient connection is refused.
The I decided to set the mapi_port: --set mapi_port=50000 &
Is mapi_port in your monetdb5.conf set to 50000?
Mclient connection is again refused for port 50000: [goncalve@amelia bin]$ mclient -lsql !ERROR mapi_reconnect: connect: Connection refused Setup connection failed
Does netstat list 50000 being in LISTENING state?
Fabian Groffen wrote:
On 08-04-2008 13:43:54 +0200, Romulo Goncalves wrote:
I start the mserver with the following command: ./mserver5 --set embedded=yes --dbinit="include sql;" &
mclient connection is refused.
The I decided to set the mapi_port: --set mapi_port=50000 & Yes it is set to that port...
Is mapi_port in your monetdb5.conf set to 50000?
Mclient connection is again refused for port 50000: [goncalve@amelia bin]$ mclient -lsql !ERROR mapi_reconnect: connect: Connection refused Setup connection failed
Does netstat list 50000 being in LISTENING state?
No there is nothing on port 50000. When I start the mserver in this mode (using the gdb) I do a break and I only see one thread, it seems the startup of mserver is not done correctly. The embedded flag is removing too many things... It seems the following statement from the web-site was taken too serious: "It is of particular interest if you need database functionality within a limited application setting" Romulo
------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
participants (2)
-
Fabian Groffen -
Romulo Goncalves