The mailing list for listmasters using Sympa

[Casey Workman <address@concealed>]

I would love to do that.  Unfortunately I'm just the admin to the
system, I don't really use it.  So I don't have any other passwords
available to me at this point.  In fact the web server interface is
behind a firewall that no one can access.  Our user base just pushes
email to it and they never log in, so out of luck there.  If anyone
want to send me a hash of something simple stupid that would be great.
If I could get a hash of "changeme", then I could use that in the
database to get me in and change it from there.

--------------------------------------
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 2:06 PM, Tim Kuehn <address@concealed> wrote:
> copy the hashed password from an account you know the password to, and
> you should be good to go.
>
> On Wed, Feb 24, 2016 at 2:58 PM, Casey Workman
> <address@concealed> wrote:
>> 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
>>>
>
>
>
> --
> Tim Kuehn - Senior Consultant, TDK Consulting Services
> Progress Openedge and Application Modernization Consulting, Moodle
> Learning Management Systems
>
> Skype: timothy.kuehn
> Ph: 519-576-8100
> Cell: 519-781-0081