Re: Distributed Database
From: Brett (rbretto@pacbell.net)Date: 05/22/02
- Next message: Xavier: "Re: Edit file with OpenSsh on windows NT"
- Previous message: Nico Kadel-Garcia: "Re: How to apply chroot patch"
- In reply to: Stephen Brewster: "Distributed Database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Brett" <rbretto@pacbell.net> Date: Wed, 22 May 2002 04:12:22 GMT
OpenSSH
generate an rsa keypair (> ssh-keygen -t rsa)
(When prompted do not enter a "passphrase" just enter twice)
copy the id_rsa.pub file to the server:~/.ssh/id_rsa.pub
create the file ~/.ssh/authorized_keys2 file by:
> cat id_rsa.pub >> authorized_keys2
The Important file here is the "private key"
client:~/.ssh/id_rsa
you need to protect this file.
Any one with this file can "impersonate" client: user
ssh2
generate a dsa keypair (> ssh-keygen2)
(When promped do not enter a "passphrase" just enter twice)
copy the id_dsa_1024_a.pub to the server:~/.ssh2/
edit server:~/.ssh2/authorization (create it if required)
add a line : id_dsa_1024_a.pub
edit the client~/.ssh2/identification
add a line : id_dsa_1024_a
The Important file here is the "private key"
client:~/.ssh2/id_dsa_1024_a
you need to protect this file.
Any one with this file can "impersonate" client: user
that's it sftp & ssh will no longer ask for a password
"Stephen Brewster" <steve@cite.co.uk> wrote in message
news:ud2k3k2taaltaf@corp.supernews.com...
> Somebody please help me on this one.
>
> We have a postgres have a postgres database running on a web server and
> another one running in the office. The database on the server is a
massively
> cut down version which only stores product information and current orders.
> What we are trying to do is periodically (through a cron job or some other
> means of scheduling) download and then remove all the recent order
> information from the web site and also upload any product changes from the
> the office. This will mean that a out staff simply have to changes the
local
> database and after a given time period these chages will be uploaded to
the
> web site. No user is allowed to edit information of the web site.
> Security is of paramount importance on this project as we will be dealing
> with oreder information (though no credit card numbers will be stored
> anywhere).
> It has been suggested within the company that we do a dump of changed
> information, upload it with SFTP and merge it into the remote system using
> SSH. These sounds all well and good but I cannot get SSH or SFTP to
connect
> without asking for a password (and I dont blame it either).
>
> ------------------------------------------------------
> Stephen Brewster
> Email: steve@cite.co.uk
> Tel: 0116 2335545
> Mobile: 07776 475849
> ICQ: 383095
> ------------------------------------------------------
>
> UNIX SEX
> unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep
>
>
> ------------------------------------------------------
> Stephen Brewster
> Email: steve@cite.co.uk
> Tel: 0116 2335545
> Mobile: 07776 475849
> ICQ: 383095
> ------------------------------------------------------
>
> UNIX SEX
> unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep
>
>
>
>
- Next message: Xavier: "Re: Edit file with OpenSsh on windows NT"
- Previous message: Nico Kadel-Garcia: "Re: How to apply chroot patch"
- In reply to: Stephen Brewster: "Distributed Database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
