[team33] Re: Fwd: RE: TDDB62: Group 3.3: Help with database access
- From: Alexei Kounine <aleko379@xxxxxxxxxxxxxx>
- To: team33@xxxxxxxxxxxxx
- Date: Wed, 17 Nov 2004 20:44:29 +0100
OK we had a leader meeting, and we decided that a second integration
milestone will take place on monday at 17.15, with tha algorithm group,
as well.
We'll have to come with a ready .jar (every first level requirement
completed) file to give to the DUI group.
We'll need to finish everything before that, meaning that the database
itself will be running on the pumi9 account.
Now my question is: can the others access this database from the
internet? or only localhost can access the DB.
Markus if needed, we'll have to do a "grant privilege" and create a new
user, but i agree with you that activation is possible with ssh, and
shouldn't be a problem by now, but as you said, we'll have to find a
better solution after. Can you just send an email to Andreas and ask him
for the email of the responsibles of ida, so that we ask someone
directly, is it ok? Fredrik, maybe you can check if it's possible.
Markus, check how things are going with Rama and Fredrik. It would be
nice to see some progression in the coding.
You guys need to do it as fast as possible (installing the database and
finish the coding) so that we can do the testing as soon as possible,
and if problems arise, have time to solve them.
If you have questions don't hesitate to ask me.
Alex
On Wed, 2004-11-17 at 20:35, Markus Nilsson wrote:
> I think his major point was:
> Why would we want to give the others access to the very same database
> before we are ready to integrate the components?
> My answer is: We don´t, cause the others shouldn't use any database
> before the integration.
>
> So right now we could actually have it on the pum account and start it
> with ssh if we're coding at home. I think this would work ok for now.
> But when it's time for integration we have to have a better solution,
> so that the others can access it as well, at any time.
> At that stage they can use the pum account/ssh approach as well, with
> a copy of the database.
> The problem is that this requires that they change the server address
> in PumpkinDB. Another bigger problem is that we have to send them a
> copy of the database if we change the design a tiny bit.
>
> So I think we have to get a better solution, but until we find one, we
> can use the pum account.
>
> The strange thing is that I asked him if any other group had had this
> problem. Apparently not, as far as he knows...
>
> Can you send him a new mail, or shall I try again? Or even better, do
> you know anyone in another databasegroup, whom you can ask how they
> solved it?
>
> By the way, how did the meeting with Nils in the algo group?
>
> //Markus
>
>
>
>
>
> -------------------
> > What does he mean?
> > The database has to be stored somewhere on a server, and the others
> will
> > have instances of our PumpkinDB object...
> > I don't understand what he means.
> > Do you?
> > Did he understand what we want?
> >
> > Alex
> >
> > On Wed, 2004-11-17 at 15:26, Markus Nilsson wrote:
> > > Hi, I just got an answer from Andreas.
> > >
> > > A summary in Enligh would be:
> > >
> > > "Do you have to run the database on a specific machine? Why don´t
> you
> > > let the other groups create own instances of the database instead?
> > > Isn´t that even better, since it prevents mixup of testdata from
> > > different groups?"
> > >
> > > Opinions?
> > >
> > > //Markus
> > >
> > > ------ Forwarded message -------
> > >
> > >
> > > From: "Andreas Borg" <andbo@xxxxxxxxxx>
> > > Reply-to: <andbo@xxxxxxxxxx>To: "'Markus Nilsson'"
> > > <i99marni@xxxxxxxxxxxxx>
> > > Date: Wed, 17 Nov 2004 15:03:18 +0100
> > >
> > > Hej!
> > >
> > > Måste ni köra databasen på en specifik maskin? Vore det inte
> trevligt
> > > om ni
> > > kan låta övriga komponenter skapa instanser av databasen som de
> vill,
> > > till
> > > exempel genom att ni tillhandahåller installationsskript? Med den
> > > lösningen
> > > skulle ni ju i så fall också slippa problem med ihopblandade data
> > > under
> > > testningen. Jag tror att det borde funka rent tekniskt. Fundera
> gärna
> > > på det
> > > och återkom om det är några problem.
> > >
> > > /Andreas
> > >
> > > > -----Original Message-----
> > > > From: Markus Nilsson [mailto:i99marni@xxxxxxxxxxxxx]
> > > > Sent: Tuesday, November 16, 2004 5:39 PM
> > > > To: andbo@xxxxxxxxxx
> > > > Subject: TDDB62: Grupp 3.3: Hjälp med databasåtkomst
> > > >
> > > > Hej Andreas!
> > > >
> > > > Vi har en liten fråga angående databasen vi ska sätta upp:
> > > >
> > > > Helst ska ju alla 3 grupperna kunna komma åt den dygnet runt,
> > > oavsett
> > > > var de jobbar. Om vi lägger den på vårt projektkonto, måste vi
> ju
> > > vara
> > > > inloggade och ha mysql-databasen igång dygnet runt. Hur lyckas
> vi
> > > med
> > > > detta?
> > > >
> > > > Vi ser bara två alternativ till detta:
> > > >
> > > > 1) Vi har den på en personlig dator. (osäkert)
> > > >
> > > > 2) Vi har den på pumi9-kontot på ida, och startar den via ssh
> innan
> > > > den ska användas. Problemet är ju att vi helst inte vill dela ut
> > > > lösenordet till kontot till de andra grupperna. Och de vill ju
> > > > förmodligen använda databasen även när vi inte är med. Dessutom
> blir
> > > > det ju inte så smidigt att behöva använda ssh varje gång.
> > > >
> > > > Vet du hur vi ska lösa detta problem på ett smidigt sätt? Antar
> att
> > > > det är fler av databasgrupperna som ställer samma fråga till
> er...
> > > > Eller vet du vem vi ska fråga?
> > > >
> > > > Med vänliga hälsningar,
> > > >
> > > > Markus Nilsson, grupp 3.3
> > --
> > --------
> > Alexei Kounine
> > Email:
> > <alexei.kounine@xxxxxxx>
> > <aleko379@xxxxxxxxxxxxxx>
> > Site:
> > http://anciensdeferney.free.fr/intouch
> >
> >
--
--------
Alexei Kounine
Email:
<alexei.kounine@xxxxxxx>
<aleko379@xxxxxxxxxxxxxx>
Site:
http://anciensdeferney.free.fr/intouch
Other related posts: