Technical Problem connecting with database
Hi,
i have a problem:
i installed *monetdb 11.9.7 *from source code and created the database farm and the database with commands *monetdbd *and *monetdb, *respectively.
The problem is when i try connect to the database (*mclient*) and dont work, see the log file but i dont how to solve.
Please, anyone can help me to solve?
This is the message in log file:
*2013-08-26 21:48:41 MSG merovingian[7622]: starting database 'Berlin10MDB', up min/avg/max: 0s/0s/0s, crash average: 0.00 0.00 0.00 (0-0=0)* * * *2013-08-26 21:48:41 MSG Berlin10MDB[7668]: arguments: /usr/local/bin/mserver5 --set gdk_dbfarm=/home/gdesimone/monet_data --dbname=Berlin10MDB --set merovingian_uri=mapi:monetdb://Athena:50000/Berlin10MDB --set mapi_open=false --set mapi_port=0 --set mapi_usock=/home/gdesimone/monet_data/Berlin10MDB/.mapi.sock --set monet_vault_key=/home/gdesimone/monet_data/Berlin10MDB/.vaultkey --set gdk_nr_threads=4 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes* * * *2013-08-26 21:48:41 MSG merovingian[7622]: database 'Berlin10MDB' (7668) has exited with exit status 127* * * *2013-08-26 21:48:41 ERR merovingian[7622]: client error: database 'Berlin10MDB' appears to shut itself down after starting, check monetdbd's logfile for possible hints* * * Many thanks!
Regards, Hancel.
Hi Hancel,
can you execute by hand the exact command line to start mserver5 as reported in the log and check/report what happens?
Stefan
Hancel Gonzalez hancelgonzalez@gmail.com wrote:
Hi,
i have a problem:
i installed *monetdb 11.9.7 *from source code and created the database farm and the database with commands *monetdbd *and *monetdb, *respectively.
The problem is when i try connect to the database (*mclient*) and dont work, see the log file but i dont how to solve.
Please, anyone can help me to solve?
This is the message in log file:
*2013-08-26 21:48:41 MSG merovingian[7622]: starting database 'Berlin10MDB', up min/avg/max: 0s/0s/0s, crash average: 0.00 0.00 0.00 (0-0=0)*
*2013-08-26 21:48:41 MSG Berlin10MDB[7668]: arguments: /usr/local/bin/mserver5 --set gdk_dbfarm=/home/gdesimone/monet_data --dbname=Berlin10MDB --set merovingian_uri=mapi:monetdb://Athena:50000/Berlin10MDB --set mapi_open=false --set mapi_port=0 --set mapi_usock=/home/gdesimone/monet_data/Berlin10MDB/.mapi.sock --set monet_vault_key=/home/gdesimone/monet_data/Berlin10MDB/.vaultkey --set gdk_nr_threads=4 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes*
*2013-08-26 21:48:41 MSG merovingian[7622]: database 'Berlin10MDB' (7668) has exited with exit status 127*
*2013-08-26 21:48:41 ERR merovingian[7622]: client error: database 'Berlin10MDB' appears to shut itself down after starting, check monetdbd's logfile for possible hints*
Many thanks!
Regards, Hancel.
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
I get the next error
*/usr/local/bin/mserver5: error while loading shared libraries: libmonetdb5.so.11: cannot open shared object file: No such file or directory * * * By the way, i use Debian Squeeze.
Thanks for to answer Stefan.
2013/8/27 Stefan Manegold Stefan.Manegold@cwi.nl
Hi Hancel,
can you execute by hand the exact command line to start mserver5 as reported in the log and check/report what happens?
Stefan
Hancel Gonzalez hancelgonzalez@gmail.com wrote:
Hi,
i have a problem:
i installed *monetdb 11.9.7 *from source code and created the database farm and the database with commands *monetdbd *and *monetdb, * respectively.
The problem is when i try connect to the database (*mclient*) and dont work, see the log file but i dont how to solve.
Please, anyone can help me to solve?
This is the message in log file:
*2013-08-26 21:48:41 MSG merovingian[7622]: starting database 'Berlin10MDB', up min/avg/max: 0s/0s/0s, crash average: 0.00 0.00 0.00 (0-0=0)*
*2013-08-26 21:48:41 MSG Berlin10MDB[7668]: arguments: /usr/local/bin/mserver5 --set gdk_dbfarm=/home/gdesimone/monet_data --dbname=Berlin10MDB --set merovingian_uri=mapi:monetdb://Athena:50000/Berlin10MDB --set mapi_open=false --set mapi_port=0 --set mapi_usock=/home/gdesimone/monet_data/Berlin10MDB/.mapi.sock --set monet_vault_key=/home/gdesimone/monet_data/Berlin10MDB/.vaultkey --set gdk_nr_threads=4 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes*
*2013-08-26 21:48:41 MSG merovingian[7622]: database 'Berlin10MDB' (7668) has exited with exit status 127*
*2013-08-26 21:48:41 ERR merovingian[7622]: client error: database 'Berlin10MDB' appears to shut itself down after starting, check monetdbd's logfile for possible hints*
Many thanks!
Regards, Hancel.
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | Database Architectures (DA) | | www.CWI.nl/~manegold | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
Hi, You are missing path to the monet libraries. There are two ways to solve the problem: 1. add the path where are the libraries to your ld.conf in /etc and run ldconfig -v. 2. set shell variable LD_LIBRARY_PATH to the path where are the libraries. After that you can try command: ldd /usr/local/bin/mserver5 . In my case it shows something like this: rbiciste@rbiciste-suse:~> ldd /usr/local/bin/mserver5 linux-vdso.so.1 (0x00007fff32061000) libmonetdb5.so.13 => /usr/local/lib64/libmonetdb5.so.13 (0x00007f4d66c5a000) libbat.so.8 => /usr/local/lib64/libbat.so.8 (0x00007f4d66633000) libmapi.so.6 => /usr/local/lib64/libmapi.so.6 (0x00007f4d6641e000) libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f4d661e2000) libreadline.so.6 => /lib64/libreadline.so.6 (0x00007f4d65f9a000) libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007f4d65c33000) liblzma.so.5 => /usr/lib64/liblzma.so.5 (0x00007f4d65a0d000) libstream.so.3 => /usr/local/lib64/libstream.so.3 (0x00007f4d65804000) libm.so.6 => /lib64/libm.so.6 (0x00007f4d65506000) libz.so.1 => /lib64/libz.so.1 (0x00007f4d652f0000) libpcre.so.1 => /usr/lib64/libpcre.so.1 (0x00007f4d65093000) libssl.so.1.0.0 => /lib64/libssl.so.1.0.0 (0x00007f4d64e29000)
libcrypto.so.1.0.0 => /lib64/libcrypto.so.1.0.0 (0x00007f4d64a56000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f4d64852000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f4d64636000)
libc.so.6 => /lib64/libc.so.6 (0x00007f4d64289000)
libtinfo.so.5 => /lib64/libtinfo.so.5 (0x00007f4d64056000)
/lib64/ld-linux-x86-64.so.2 (0x00007f4d6751d000)
Radovan
On 08/27/2013 07:57 AM, Hancel Gonzalez wrote:
I get the next error
*/usr/local/bin/mserver5: error while loading shared libraries: libmonetdb5.so.11: cannot open shared object file: No such file or directory*
By the way, i use Debian Squeeze.
Thanks for to answer Stefan.
2013/8/27 Stefan Manegold <Stefan.Manegold@cwi.nl mailto:Stefan.Manegold@cwi.nl>
Hi Hancel, can you execute by hand the exact command line to start mserver5 as reported in the log and check/report what happens? Stefan Hancel Gonzalez <hancelgonzalez@gmail.com <mailto:hancelgonzalez@gmail.com>> wrote: Hi, i have a problem: i installed *monetdb 11.9.7 *from source code and created the database farm and the database with commands */monetdbd /*and /*monetdb, */respectively. The problem is when i try connect to the database (*/mclient/*) and dont work, see the log file but i dont how to solve. Please, anyone can help me to solve? This is the message in log file: *2013-08-26 21:48:41 MSG merovingian[7622]: starting database 'Berlin10MDB', up min/avg/max: 0s/0s/0s, crash average: 0.00 0.00 0.00 (0-0=0)* * * *2013-08-26 21:48:41 MSG Berlin10MDB[7668]: arguments: /usr/local/bin/mserver5 --set gdk_dbfarm=/home/gdesimone/monet_data --dbname=Berlin10MDB --set merovingian_uri=mapi:monetdb://Athena:50000/Berlin10MDB --set mapi_open=false --set mapi_port=0 --set mapi_usock=/home/gdesimone/monet_data/Berlin10MDB/.mapi.sock --set monet_vault_key=/home/gdesimone/monet_data/Berlin10MDB/.vaultkey --set gdk_nr_threads=4 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes* * * *2013-08-26 21:48:41 MSG merovingian[7622]: database 'Berlin10MDB' (7668) has exited with exit status 127* * * *2013-08-26 21:48:41 ERR merovingian[7622]: client error: database 'Berlin10MDB' appears to shut itself down after starting, check monetdbd's logfile for possible hints* * * Many thanks! Regards, Hancel. ------------------------------------------------------------------------ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> http://mail.monetdb.org/mailman/listinfo/users-list -- | Stefan.Manegold@CWI.nl | Database Architectures (DA) | | www.CWI.nl/~manegold <http://www.CWI.nl/~manegold> | Science Park 123 (L321) | | +31 (0)20 592-4212 <tel:%2B31%20%280%2920%20592-4212> | 1098 XG Amsterdam (NL) |
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Many thanks.
I'll try and i'll tell you.
2013/8/27 Radovan Bičiště radovan.biciste@ceosdata.com
Hi, You are missing path to the monet libraries. There are two ways to solve the problem:
- add the path where are the libraries to your ld.conf in /etc and run
ldconfig -v. 2. set shell variable LD_LIBRARY_PATH to the path where are the libraries. After that you can try command: ldd /usr/local/bin/mserver5 . In my case it shows something like this: rbiciste@rbiciste-suse:~> ldd /usr/local/bin/mserver5 linux-vdso.so.1 (0x00007fff32061000) libmonetdb5.so.13 => /usr/local/lib64/libmonetdb5.**so.13 (0x00007f4d66c5a000) libbat.so.8 => /usr/local/lib64/libbat.so.8 (0x00007f4d66633000) libmapi.so.6 => /usr/local/lib64/libmapi.so.6 (0x00007f4d6641e000) libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f4d661e2000) libreadline.so.6 => /lib64/libreadline.so.6 (0x00007f4d65f9a000) libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007f4d65c33000) liblzma.so.5 => /usr/lib64/liblzma.so.5 (0x00007f4d65a0d000) libstream.so.3 => /usr/local/lib64/libstream.so.**3 (0x00007f4d65804000) libm.so.6 => /lib64/libm.so.6 (0x00007f4d65506000) libz.so.1 => /lib64/libz.so.1 (0x00007f4d652f0000) libpcre.so.1 => /usr/lib64/libpcre.so.1 (0x00007f4d65093000) libssl.so.1.0.0 => /lib64/libssl.so.1.0.0 (0x00007f4d64e29000)
libcrypto.so.1.0.0 => /lib64/libcrypto.so.1.0.0(0x00007f4d64a56000) libdl.so.2 => /lib64/libdl.so.2 (0x00007f4d64852000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f4d64636000) libc.so.6 => /lib64/libc.so.6 (0x00007f4d64289000) libtinfo.so.5 => /lib64/libtinfo.so.5 (0x00007f4d64056000) /lib64/ld-linux-x86-64.so.2 (0x00007f4d6751d000)Radovan
On 08/27/2013 07:57 AM, Hancel Gonzalez wrote:
I get the next error
*/usr/local/bin/mserver5: error while loading shared libraries:
libmonetdb5.so.11: cannot open shared object file: No such file or directory*
By the way, i use Debian Squeeze.
Thanks for to answer Stefan.
2013/8/27 Stefan Manegold <Stefan.Manegold@cwi.nl mailto:Stefan.Manegold@cwi.nl**>
Hi Hancel, can you execute by hand the exact command line to start mserver5 as reported in the log and check/report what happens? Stefan Hancel Gonzalez <hancelgonzalez@gmail.com <mailto:hancelgonzalez@gmail.**com <hancelgonzalez@gmail.com>>>wrote:
Hi, i have a problem: i installed *monetdb 11.9.7 *from source code and created the database farm and the database with commands */monetdbd /*and /*monetdb, */respectively. The problem is when i try connect to the database (*/mclient/*) and dont work, see the log file but i dont how to solve. Please, anyone can help me to solve? This is the message in log file: *2013-08-26 21:48:41 MSG merovingian[7622]: starting database 'Berlin10MDB', up min/avg/max: 0s/0s/0s, crash average: 0.00 0.00 0.00 (0-0=0)* * * *2013-08-26 21:48:41 MSG Berlin10MDB[7668]: arguments: /usr/local/bin/mserver5 --set gdk_dbfarm=/home/gdesimone/**monet_data --dbname=Berlin10MDB--set merovingian_uri=mapi:monetdb:/**/Athena:50000/Berlin10MDB --set mapi_open=false --set mapi_port=0 --set mapi_usock=/home/gdesimone/**monet_data/Berlin10MDB/.mapi.**sock --set monet_vault_key=/home/**gdesimone/monet_data/** Berlin10MDB/.vaultkey --set gdk_nr_threads=4 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes* * * *2013-08-26 21:48:41 MSG merovingian[7622]: database 'Berlin10MDB' (7668) has exited with exit status 127* * * *2013-08-26 21:48:41 ERR merovingian[7622]: client error:
database 'Berlin10MDB' appears to shut itself down after starting, check monetdbd's logfile for possible hints* * * Many thanks! Regards, Hancel. ------------------------------**------------------------------**
users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org**> http://mail.monetdb.org/**mailman/listinfo/users-list<http://mail.monetdb.org/mailman/listinfo/users-list> -- | Stefan.Manegold@CWI.nl | Database Architectures (DA) | | www.CWI.nl/~manegold <http://www.CWI.nl/~manegold> | Science Park 123 (L321) | | +31 (0)20 592-4212 <tel:%2B31%20%280%2920%20592-**4212> | 1098 XG Amsterdam (NL) |______________________________**_________________
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/**mailman/listinfo/users-listhttp://mail.monetdb.org/mailman/listinfo/users-list
-- __________________________
Radovan Bičiště ceos data s.r.o. třída SNP 402/48 500 03 Hradec Králové Czech Republic
mobil CZ: +420 601 563 014 skype: rbiciste ______________________________**_________________
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/**mailman/listinfo/users-listhttp://mail.monetdb.org/mailman/listinfo/users-list
Many Thanks!
I solved the problem. Again, thank you so much.
Regards, Hancel.
2013/8/27 Radovan Bičiště radovan.biciste@ceosdata.com
Hi, You are missing path to the monet libraries. There are two ways to solve the problem:
- add the path where are the libraries to your ld.conf in /etc and run
ldconfig -v. 2. set shell variable LD_LIBRARY_PATH to the path where are the libraries. After that you can try command: ldd /usr/local/bin/mserver5 . In my case it shows something like this: rbiciste@rbiciste-suse:~> ldd /usr/local/bin/mserver5 linux-vdso.so.1 (0x00007fff32061000) libmonetdb5.so.13 => /usr/local/lib64/libmonetdb5.**so.13 (0x00007f4d66c5a000) libbat.so.8 => /usr/local/lib64/libbat.so.8 (0x00007f4d66633000) libmapi.so.6 => /usr/local/lib64/libmapi.so.6 (0x00007f4d6641e000) libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f4d661e2000) libreadline.so.6 => /lib64/libreadline.so.6 (0x00007f4d65f9a000) libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007f4d65c33000) liblzma.so.5 => /usr/lib64/liblzma.so.5 (0x00007f4d65a0d000) libstream.so.3 => /usr/local/lib64/libstream.so.**3 (0x00007f4d65804000) libm.so.6 => /lib64/libm.so.6 (0x00007f4d65506000) libz.so.1 => /lib64/libz.so.1 (0x00007f4d652f0000) libpcre.so.1 => /usr/lib64/libpcre.so.1 (0x00007f4d65093000) libssl.so.1.0.0 => /lib64/libssl.so.1.0.0 (0x00007f4d64e29000)
libcrypto.so.1.0.0 => /lib64/libcrypto.so.1.0.0(0x00007f4d64a56000) libdl.so.2 => /lib64/libdl.so.2 (0x00007f4d64852000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f4d64636000) libc.so.6 => /lib64/libc.so.6 (0x00007f4d64289000) libtinfo.so.5 => /lib64/libtinfo.so.5 (0x00007f4d64056000) /lib64/ld-linux-x86-64.so.2 (0x00007f4d6751d000)Radovan
On 08/27/2013 07:57 AM, Hancel Gonzalez wrote:
I get the next error
*/usr/local/bin/mserver5: error while loading shared libraries:
libmonetdb5.so.11: cannot open shared object file: No such file or directory*
By the way, i use Debian Squeeze.
Thanks for to answer Stefan.
2013/8/27 Stefan Manegold <Stefan.Manegold@cwi.nl mailto:Stefan.Manegold@cwi.nl**>
Hi Hancel, can you execute by hand the exact command line to start mserver5 as reported in the log and check/report what happens? Stefan Hancel Gonzalez <hancelgonzalez@gmail.com <mailto:hancelgonzalez@gmail.**com <hancelgonzalez@gmail.com>>>wrote:
Hi, i have a problem: i installed *monetdb 11.9.7 *from source code and created the database farm and the database with commands */monetdbd /*and /*monetdb, */respectively. The problem is when i try connect to the database (*/mclient/*) and dont work, see the log file but i dont how to solve. Please, anyone can help me to solve? This is the message in log file: *2013-08-26 21:48:41 MSG merovingian[7622]: starting database 'Berlin10MDB', up min/avg/max: 0s/0s/0s, crash average: 0.00 0.00 0.00 (0-0=0)* * * *2013-08-26 21:48:41 MSG Berlin10MDB[7668]: arguments: /usr/local/bin/mserver5 --set gdk_dbfarm=/home/gdesimone/**monet_data --dbname=Berlin10MDB--set merovingian_uri=mapi:monetdb:/**/Athena:50000/Berlin10MDB --set mapi_open=false --set mapi_port=0 --set mapi_usock=/home/gdesimone/**monet_data/Berlin10MDB/.mapi.**sock --set monet_vault_key=/home/**gdesimone/monet_data/** Berlin10MDB/.vaultkey --set gdk_nr_threads=4 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes* * * *2013-08-26 21:48:41 MSG merovingian[7622]: database 'Berlin10MDB' (7668) has exited with exit status 127* * * *2013-08-26 21:48:41 ERR merovingian[7622]: client error:
database 'Berlin10MDB' appears to shut itself down after starting, check monetdbd's logfile for possible hints* * * Many thanks! Regards, Hancel. ------------------------------**------------------------------**
users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org**> http://mail.monetdb.org/**mailman/listinfo/users-list<http://mail.monetdb.org/mailman/listinfo/users-list> -- | Stefan.Manegold@CWI.nl | Database Architectures (DA) | | www.CWI.nl/~manegold <http://www.CWI.nl/~manegold> | Science Park 123 (L321) | | +31 (0)20 592-4212 <tel:%2B31%20%280%2920%20592-**4212> | 1098 XG Amsterdam (NL) |______________________________**_________________
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/**mailman/listinfo/users-listhttp://mail.monetdb.org/mailman/listinfo/users-list
-- __________________________
Radovan Bičiště ceos data s.r.o. třída SNP 402/48 500 03 Hradec Králové Czech Republic
mobil CZ: +420 601 563 014 skype: rbiciste ______________________________**_________________
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/**mailman/listinfo/users-listhttp://mail.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Hancel Gonzalez -
Radovan Bičiště -
Stefan Manegold