[Deskaheh-sysadmin] Deskaheh is not letting me in via FTP

[finn c.]

Hi,

On Mon, Jan 31, 2005 at 09:03:45AM -0600, Treesong wrote:
> Hello all,
> 
> Deskaheh isn't letting me in through FTP. I wasn't too concerned about 
> this before, because it was clearly a performance issue, in that I 
> couldn't even connect to Deskaheh at all via FTP. But now, I'm a bit 
> concerned, because I received the following error message:

Occam and I were having similar problems with his account [occam]. I
could 'login' to his account fine, so it seems that ssh/pam is having
problems. It would just give us:

Permission denied (publickey,keyboard-interactive)

There's nothing enlightening in the logs either.

He could login fine to his 'de' account using ssh, so it shouldn't be
his end. The occam acc is using one time passwords, but it doesn't look
like your account is [your using the bigmuddy or jwilliam acc, yes?]. Not
that one time passwords should interfere with a standard login anyway ..

> Does this mean that I'm locked out of Deskaheh until somebody with 
> access lets me back in?

Hmm, I'm afraid so - anyone got ideas what is causing this? I'm guessing
that this happened after ski upgraded the ports when we came back
online?

> On a related note, we at Big Muddy IMC have been discussing setting up 
> our own local server with the help of one or two people we know. We 
> haven't decided on that as a group yet, and won't until at least this 
> coming Sunday when we have our next general meeting. But in the 
> meantime, how would we transfer all of our content from the MySQL 
> database on Deskaheh to a new database on another new server?

This is really easy with mysql:

1. dump the file into a text file
$ mysqldump -u username -p database > dumpfile.sql

2. gzip it up
$ gzip dumpfile.sql

3. transfer to new server and ungzip

4. create new database and database user

5. add database structure and data to the new db
$ mysql -u username -p database < dumpfile.sql

6. adjust some info in the 'prefs' table to reflect the new environment,
ie. path, database settings etc

I've done a bit of work with dada, feel free to ask me any questions if
you run into problems.

seeya,
finn

--
pgp encrypted mail welcome - 
keyid: CD564868      keyserver: pgp.mit.edu
E9E6 E3A3 4891 48D8 A95E  3F78 90D7 CA42 CD56 4868
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.indymedia.org/pipermail/deskaheh-sysadmin/attachments/20050201/df927727/attachment.pgp