Ir al contenido principal.
Enlaces relacionados:  Press Room  Company  Clients  Contact us
Solsoft

Forum

malete server and multiple databases


Author Message
Written on: 23. 05. 2005 [19:30]
fgomez@criba.edu.ar
=?Windows-1252?Q?Fernando_J._G=F3mez?
Topic creator
registered since: 31.12.1969
Posts: 0
I've learnt that

malete server -S db1 [options1] db2 [options2]

allows me to interact with databases db1 and db2. Now I need to access
also db3, what am I supposed to do?

a) restart the malete server:

malete server -S db1 [options1] db2 [options2] db3 [options3]

b) start another instance of the malete server, using a different port:

malete server -Snnnn db3 [options3]

c) something else...?


Perhaps I should mention that my only experience working with databases
has been the "Isis family", mainly using Bireme tools, and so this
concept of a db server is completely new to me.

Saludos!


--
Fernando


----------------------------------------
Fernando J Gómez
----------------------------------------
Biblioteca Dr. Antonio Monteiro
Instituto de Matemática de Bahía Blanca
Conicet / Universidad Nacional del Sur
Av. Alem 1253
B8000CPB Bahía Blanca - Argentina
Tel. (54 291) 459 5116
----------------------------------------

------------------------------------------
Posted to Phorum via PhorumMail
Written on: 24. 05. 2005 [09:18]
paul@malete.org
Klaus Ripke
registered since: 31.12.1969
Posts: 0
On Mon, May 23, 2005 at 08:30:05PM -0300, Fernando Gomez wrote:
> I've learnt that
>
> malete server -S db1 [options1] db2 [options2]
>
> allows me to interact with databases db1 and db2. Now I need to access
> also db3, what am I supposed to do?
>
> a) restart the malete server:
nah!

> b) start another instance of the malete server, using a different port:
there could be reasons to do so,
e.g. to allow a different set of hosts to connect
(using some network packet filter like iptables).

> c) something else...?
There's no need to do anything.

Only reason why you would want to specify databases at all
is to pass options like a special path.

Just tell the server to access db foo, and it will happily
open it, existing or not (if it has the system access rights
to create files in the current directory).
$ telnet localhost 2042
foo.T

# 0

(server saying:
malete server -S -vd
...
oStruct 'foo.T'
facMain 'foo'
could not open 'foo.m0d' 0005
test ex perm lock on 'foo.mrd'
...
)


cheers

------------------------------------------
Posted to Phorum via PhorumMail
Written on: 24. 05. 2005 [20:10]
fgomez@criba.edu.ar
=?Windows-1252?Q?Fernando_J._G=F3mez?
Topic creator
registered since: 31.12.1969
Posts: 0
Klaus Ripke wrote:

> Only reason why you would want to specify databases at all
> is to pass options like a special path.
>
> Just tell the server to access db foo, and it will happily
> open it, existing or not (if it has the system access rights
> to create files in the current directory).

So, unless a db+path is specified when starting the malete server, all
databases are opened/created in the current directory --that is, the
directory where the command was issued.

OTOH, it seems reasonable that you would want to have your databases
living in different directories.

Using MicroIsis/WinIsis, you could use the _dbn_.par files; all these
.par files lived on the same dir, and they contained the paths to
wherever you wanted to store the actual databases.

Something vaguely similar to a set of .par files for n databases would
be a script like this:

#!/bin/bash
malete server -S \
db_1 -fpath_1/ \
db_2 -fpath_2/ \
db_3 -fpath_3/ \
...
db_n -fpath_n/

But then, once the server is already running, you realize you need to
work with db_(n+1) on path_(n+1). No way to tell malete where this db lives?

(Maybe this won't have real practical importance; anyway I'm just trying
to get some idea of how things are supposed to work...)

Gracias!


--
Fernando


----------------------------------------
Fernando J Gómez
----------------------------------------
Biblioteca Dr. Antonio Monteiro
Instituto de Matemática de Bahía Blanca
Conicet / Universidad Nacional del Sur
Av. Alem 1253
B8000CPB Bahía Blanca - Argentina
Tel. (54 291) 459 5116
----------------------------------------

------------------------------------------
Posted to Phorum via PhorumMail
Written on: 25. 05. 2005 [01:47]
paul@malete.org
Klaus Ripke
registered since: 31.12.1969
Posts: 0
On Tue, May 24, 2005 at 09:10:43PM -0300, Fernando Gomez wrote:
> Using MicroIsis/WinIsis, you could use the _dbn_.par files; all these
> .par files lived on the same dir, and they contained the paths to
...
> #!/bin/bash
> malete server -S \
> db_1 -fpath_1/ \
...
> db_n -fpath_n/
> But then, once the server is already running, you realize you need to
> work with db_(n+1) on path_(n+1). No way to tell malete where this db lives?

on a reasonable operating system one would use symbolic links.
ln -s /where/db/lives/bla.m* /where/server/sits

------------------------------------------
Posted to Phorum via PhorumMail



User login

Enter your username and password here in order to log in on the website:
Login

Forgot your password?


Copyright © 2003-2009, Solsoft de Costa Rica S.A.
Declaración de privacidad