[MonetDB-users] mserver5 question
OS: CentOS 4.6 I am only able to initiate mserver5 as su. What should I do to be able to start the server in a user account? Thanks
On 2008-01-16 21:01, Claude Monet wrote:
OS: CentOS 4.6 I am only able to initiate mserver5 as su. What should I do to be able to start the server in a user account?
What version? How did you install? Assuming you're using a recent RPM, then what the RPM does is create a group called monet. Add yourself to this group, logout and log back in, then you can use mserver5 as yourself. Alternatively, you can start mserver5 with some extra options to specify where it should store the data: --dbfarm=/some/directory/you/own --set sql_logdir=/some/other/directory/you/own -- Sjoerd Mullender
Sjoerd, I used the monetdb-install.sh all-in-one script downloaded from monetdb.cwi.nl/..../Builds/index.html Note: I have to edit the script on line 331 from fetch-cvs to fetch_cvs and run it as su to get MonetDB installed. Server works fine as when I login to su. As user I get this error: !FATAL: GDKlockHome: Database lock '.gdk_lock' denied
Assuming you're using a recent RPM, then what the RPM does is create a group called monet. Add yourself to this group, logout and log back in, then you can use mserver5 as yourself.
I have no monet group: $ groups Richard root bin daemon sys adm disk lp mem kmem mail news man floppy games slocate rpcuser gopher rpc netdump rpm ntp dip gdm mailnull ftp smmsp lock pegasus haldaemon sshd pcap dbus nobody nfsnobody Should I groupadd monet? Thanks a lot for your efforts. On Wed, 2008-01-16 at 21:29 +0100, Sjoerd Mullender wrote:
On 2008-01-16 21:01, Claude Monet wrote:
OS: CentOS 4.6 I am only able to initiate mserver5 as su. What should I do to be able to start the server in a user account?
What version? How did you install?
Assuming you're using a recent RPM, then what the RPM does is create a group called monet. Add yourself to this group, logout and log back in, then you can use mserver5 as yourself.
Alternatively, you can start mserver5 with some extra options to specify where it should store the data: --dbfarm=/some/directory/you/own --set sql_logdir=/some/other/directory/you/own
Claude Monet wrote:
Sjoerd,
I used the monetdb-install.sh all-in-one script downloaded from monetdb.cwi.nl/..../Builds/index.html
Note: I have to edit the script on line 331 from fetch-cvs to fetch_cvs and run it as su to get MonetDB installed.
Server works fine as when I login to su. As user I get this error:
!FATAL: GDKlockHome: Database lock '.gdk_lock' denied
Assuming you're using a recent RPM, then what the RPM does is create a group called monet. Add yourself to this group, logout and log back in, then you can use mserver5 as yourself.
I have no monet group: $ groups Richard root bin daemon sys adm disk lp mem kmem mail news man floppy games slocate rpcuser gopher rpc netdump rpm ntp dip gdm mailnull ftp smmsp lock pegasus haldaemon sshd pcap dbus nobody nfsnobody
Should I groupadd monet?
No necessarily. The group stuff is specific to the RPMs. Since you're installing as root, you need to do something to make the database usable by non-root. You can either change the permissions or the ownership of the /usr/var/MonetDB5 directory (and descendants). If you change permissions, you can change them to world-writable (chmod -R a+w /usr/var/MonetDB5) so that everybody on the system can use the database. You can also change ownership so that only you (and root) can use it: chown -R <yourname> /usr/var/MonetDB5. The alternative of using a different directory still stands. You can use the --dbfarm and --set options I described to use a database in a location that you do have permission for.
Thanks a lot for your efforts.
On Wed, 2008-01-16 at 21:29 +0100, Sjoerd Mullender wrote:
On 2008-01-16 21:01, Claude Monet wrote:
OS: CentOS 4.6 I am only able to initiate mserver5 as su. What should I do to be able to start the server in a user account? What version? How did you install?
Assuming you're using a recent RPM, then what the RPM does is create a group called monet. Add yourself to this group, logout and log back in, then you can use mserver5 as yourself.
Alternatively, you can start mserver5 with some extra options to specify where it should store the data: --dbfarm=/some/directory/you/own --set sql_logdir=/some/other/directory/you/own
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Sjoerd Mullender
Sjoerd, That explains things perfectly. Thanks a lot. On Thu, 2008-01-17 at 09:42 +0100, Sjoerd Mullender wrote:
Claude Monet wrote:
Sjoerd,
I used the monetdb-install.sh all-in-one script downloaded from monetdb.cwi.nl/..../Builds/index.html
Note: I have to edit the script on line 331 from fetch-cvs to fetch_cvs and run it as su to get MonetDB installed.
Server works fine as when I login to su. As user I get this error:
!FATAL: GDKlockHome: Database lock '.gdk_lock' denied
Assuming you're using a recent RPM, then what the RPM does is create a group called monet. Add yourself to this group, logout and log back in, then you can use mserver5 as yourself.
I have no monet group: $ groups Richard root bin daemon sys adm disk lp mem kmem mail news man floppy games slocate rpcuser gopher rpc netdump rpm ntp dip gdm mailnull ftp smmsp lock pegasus haldaemon sshd pcap dbus nobody nfsnobody
Should I groupadd monet?
No necessarily.
The group stuff is specific to the RPMs.
Since you're installing as root, you need to do something to make the database usable by non-root.
You can either change the permissions or the ownership of the /usr/var/MonetDB5 directory (and descendants). If you change permissions, you can change them to world-writable (chmod -R a+w /usr/var/MonetDB5) so that everybody on the system can use the database. You can also change ownership so that only you (and root) can use it: chown -R <yourname> /usr/var/MonetDB5.
The alternative of using a different directory still stands. You can use the --dbfarm and --set options I described to use a database in a location that you do have permission for.
Thanks a lot for your efforts.
On Wed, 2008-01-16 at 21:29 +0100, Sjoerd Mullender wrote:
On 2008-01-16 21:01, Claude Monet wrote:
OS: CentOS 4.6 I am only able to initiate mserver5 as su. What should I do to be able to start the server in a user account? What version? How did you install?
Assuming you're using a recent RPM, then what the RPM does is create a group called monet. Add yourself to this group, logout and log back in, then you can use mserver5 as yourself.
Alternatively, you can start mserver5 with some extra options to specify where it should store the data: --dbfarm=/some/directory/you/own --set sql_logdir=/some/other/directory/you/own
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Claude Monet -
Sjoerd Mullender