Re: How to setup STORE depository visible to the internet?

Hi,

On Thu, 14 Sep 2006 19:50:43 -0700, askoh wrote:

I got Store to connect. Thanks.
I want to make a video that is helpful, so I would like to clarify a
few points.

I'll do all I can with a video as a reward :-)

'service password' is the password to start the psql service. How come
I am never asked for it?

This is a Microsoft Windows question more than a PostgreSQL or Smalltalk
one. I think this is because your normal account is able to start and
stop services (e.g. you are have an admin account). The password is used
*by the service* when it starts. When you set up the service at install
time, you specified the password that was to be used and (I understand)
this was stored with the service definition somehow.

Perhaps someone could confirm this guess?

'postgres user' is the default superuser create with psql installation.
It owns the 'postgres database'. What is the database used for?

I don't know about that one.

What are the 'template01' and 'template02' databases?

These are the databases that are copied when you create a new database -
hence the name template. I think the idea was that you didn't muck with
the templates, but people did and broke things ... which is why there are
two of them. If you break one of the templates, you can use the other
instead.

Frankly, I've never really cared what they are so the above may not be
100% right.

I need to create a 'storeadmin' user in psql. It needs to own 'storedb'
database.

Well, I use my own account as the store admin account.

Now I run StoreForPostgreSQLTest test02 Environment has to be
'localhost_storedb'. What is the username it is asking for? Is it
something new like 'guest' or 'kermit' that I setup for each user
who wants to use the depository I have?

Immediately after "StoreForPostgreSQLTest test02" is evaluated you get a
login dialog. Use this to login to the database into which you want the
Store schema to be installed. You need to login as a user with permission
to create the tables.

What I do on a clean PostgreSQL install is to create a PostgreSQL account
for me (e.g. bruce) and give that account permission to create databases
and other user accounts. Then I log in using this new account and create
the soon-to-be Store database. Then I run >>test02 specifying my account
and password and pointing the environment at the new database.

Table owner has to be 'storeadmin'.

"Table Owner" has no meaning wrt Store on PostgreSQL.

What is the unique name (say 'storedepo') for the Store depository? Does
it mean 'storedb' can have many depositories?

The unique name of a Store repository is attached to pundle versions
published to that repository. When pundle versions are replicated from
one repository to another the repository name goes along too. So, it's
quite important the name is unique. I tend to use a name I "own" and a
data and an increment, e.g. OpenSkills20060915a.

You can have as many Store repositories as you like - just make sure each
has a unique name. I'm not sure why you'd want more than one Store
database on a given machine, but if there is a need it is possible.

What is the image administrator that it asks for?

This is to do with administering who can do what within Store - e.g. who
can bless what to what level. I tend to just make my account name the
initial admin account. Have a read of the Store manual to understand this
stuff. When you work it out, perhaps you could make another video! :-)

What happens when I run test02 more than once and enter different
values?

You should only install the schema once in a given PostgreSQL database.
If you want to run the schema install again either:

* Manually delete the tw* tables from the database (ugh - too hard)
* Drop and re-create the database
* Create a new database and ignore the old one

I hope to get it all right so that more people will be able to user
Store.

Me too :-)

All the best,
Bruce
.

Relevant Pages

  • Re: Restoring Database Using Recovery Storage Group
    ... Adding the server account resolved my issue. ... I believe its the account from an old store that was removed ... when I attempt to mount new logs are created. ... I'm having a hell of a time getting a restored database to mount. ...
    (microsoft.public.exchange.admin)
  • Re: postgresql and binary data
    ... I have some postgresql database that stores binary data (windows/linux ... File in database, say, 4MB and user can download only first 175 kbyte ... is the best place to store data such as binaries. ...
    (comp.lang.php)
  • Re: PostgreSQL Connection
    ... >> I am trying to connect to a PostgreSQL database using asp. ... > I am not familiar with PostgreSQL, but i do have a couple comments. ... The connection stringworks fine in a UDL file but it doesn't ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Best bit fields implementation under postgres
    ... I'm working on a database (postgresql) structure and some of the ... must store bit fields. ... Later on it must handle queries like "give me ...
    (comp.databases)
  • Re: PerlModule Apache::AuthDBI
    ... this tells you that they are using a postgreSql database. ... if you dont have a local account, postgresql might help you to get one. ... This list is provided by the SecurityFocus Security Intelligence Alert ...
    (Pen-Test)