The mailing list for listmasters using Sympa

[Casey Workman <address@concealed>]

I should be good to go on changing the password in the user_table,
that's not a big deal.  Other than I need to know how to hash it so
it's correctly formatted.

And, yeah I have checked through the email to make sure it wasn't a
formatting problem or it was "hidden".  I have it open in Gmail and
viewed the original message so it was showing the raw message headers
and everything.  I even went so far as to go to someone else's sympa
installation and clicked on their forgotten email link.  Then email
from them was complete and I could see everything in it, including the
link to go reset a password on their server.

--------------------------------------
Casey Workman
Systems Engineer
Murray State University
270-255-9675

***Please note that Murray State will NEVER ask for your username and
password via email***


On Wed, Feb 24, 2016 at 1:53 PM, Miles Fidelman
<address@concealed> wrote:
> I expect someone else will be able to provide a more detailed answer, but,
> in the interim....
>
> - Passwords are stored in the database
> - There's a section in the Sympa Reference Manual titled "Sympa and its
> Database" - essential reading if you're going to play there
> - /etc/sympa/sympa.conf probably has your database access info (username,
> password) - assuming you have root access
> - if you're good with SQL, you can change things using the the command line
> (e.g., for mysql, the mysql command line), but, you're probably better off
> using a GUI like phpmyadmin (or see
> http://www.databasejournal.com/features/mysql/slideshows/top-10-mysql-gui-tools.html)
>
> But before digging around, you might try to figure out why you're list reset
> password is coming through without the link.  You'd need to figure out which
> routine generates it and look at the formatting files.  It could be that
> your email program is displaying the link properly - look at the source
> email.
>
> Hope this helps,
>
> Miles Fidelman
>
>
> On 2/24/16 2:15 PM, Casey Workman (via sympa-users Mailing List) wrote:
>>
>> I can't get logged into our Sympa installation with the main
>> listmaster account.  I think one of the other admins accidentally
>> changed the password and now we are locked out.  I have tried to use
>> the "Lost Password" link but the email I recieve is incomplete.  All
>> it says is...
>>
>> ------------------------
>> Someone, probably you, requested to create or renew your password for
>> your list server account list.abcdefg.edu. (This request cames from
>> host x.x.x.x at ).
>> ------------------------
>>
>> It is missing the link at the end of the email that takes me to the
>> form to change the password.  So my question is, how do I go about
>> resetting that password?  Can it be accomplished from the command
>> line?  In the database?
>>
>>
>> --------------------------------------
>> Casey Workman
>> Systems Engineer
>> Murray State University
>> 270-255-9675
>>
>> ***Please note that Murray State will NEVER ask for your username and
>> password via email***
>
>
> --
> In theory, there is no difference between theory and practice.
> In practice, there is.  .... Yogi Berra
>