[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jabber-jadmin
Subject:    Re: [jadmin] little admin question: how do u change user	passwords?
From:       Mike Willbanks <mike () bluedigitalink ! com>
Date:       2004-03-30 5:30:39
Message-ID: 406905FF.7090307 () bluedigitalink ! com
[Download RAW message or body]

mysql> describe authreg;

> +----------+-------------+------+-----+---------+-------+
> | Field    | Type        | Null | Key | Default | Extra |
> +----------+-------------+------+-----+---------+-------+
> | username | tinytext    | YES  |     | NULL    |       |
> | realm    | tinytext    | YES  |     | NULL    |       |
> | password | tinytext    | YES  |     | NULL    |       |
> | token    | varchar(10) | YES  |     | NULL    |       |
> | sequence | int(11)     | YES  |     | NULL    |       |
> | hash     | varchar(40) | YES  |     | NULL    |       |
> +----------+-------------+------+-----+---------+-------+
> 6 rows in set (0.04 sec)
>
> see the "hash" field there?


Try selecting everything from the database.  The passwords seem to be 
stored as plaintext unless that is a configuration option that I 
missed.  Even with the hash field there if I just change the password 
via UPDATE authreg SET password = 'pass' WHERE username = 'user'; that 
seems to work and I can login just fine with the new configuration.

Mike
_______________________________________________
jadmin mailing list
jadmin@jabber.org
https://jabberstudio.org/mailman/listinfo/jadmin
[prev in list] [next in list] [prev in thread] [next in thread]