On Sat, 20 Mar 2021 at 07:19, Sangeeta Verma <[email protected]> wrote:
>
> Hi All,
> 1. I lost my admin password after installation . I can't go with email reset
> as I have not configured my email server.
> I know i can install all over again so my question is what encryption is used
> to
> update password in om_user? I tried MD5 obviously thats not the case.
> What encryption can I use
you have several options:
1) manually update `configuration` DB table and set email server details
SELECT * FROM openmeetings.configuration WHERE om_key like '%mail%';
2) the tricky way
2.1) self-register as a new user with known password
2.2) copy the password hash from this user to admin
2.3) restart OM
3) you can try this hash
update om_user set password =
'q5Rtr+mIbwXsKtrjwDvzS5v3jgkE9Oa3B6qonUHGUSEZUeTbYhB2e4kUay5t/JuRt7nN/E8c4mmAIrMMg60bh3RBy6YI4P/tra9wT8wnW751mP/W2YhC7CUrt3LpUAig9fpTMo7Z+sP56Yi37ZzWUFapf8G0EnBnQ3yoZAbLuMBYkzRXpbYASgD3lrWtbsEnhLTLjzr2M8cpLYKCgU2fTX7X0GlShKeIKgi0IY71X71BUiagEMn50m9psiN8ekMg25jdCEVvy318SWfaaT4c0IXVJHeQ5j8QCcu9FphGY8QCt9X35ThW5eZhrycLb1hYlTXG520wEZ1Vi0VS7RiRTpg3roTTsh/OW+8z7cnhboOJ4RjaksCinll9kikFRSjkBj+Pb+LeYgd4Oa1NRBZpqQyPnFFdiv8FWGbulWoA+GNq4gqUkBZjCRDFo6qP2zjEJ79yVVRKZ3BhsErJs6PSE9zj9l/I5xtHkUSKdtXBVaAZYnQJC80rdTWA+Z+o8TG49om6pDpUHCIzsHOxKJlxF+CHyoLaZs0aFUGxsMAqUk5JR7GoV+31OZTe84rnMmf2Ke8Wx68lTRPH6FbvEksEwkAcCd2GJ2QbOqFrcOfhQl9YoMlgCjgNIuhap1aaqMjtcGAEu4KbURv61XSA4AEWgA/hjVRzAEQLTS7xjp4ol4g=:bG954Ev3VIecHOJHaV9fiXQmD5ZT02DXIBs/S/VbIV9bpT4d724SlYGS+8Xl1XPDPZblA0bUO38mPloxOC4u/eIsrUxLctbY/iDZTbQRYPNC92yPuBYUTROIAZhHehJuDzAL6NqMEmEoEYEWwm3Pzqw//MleFK62QdKBprEIVKDw784EY+NGZWtbInEByLgN0k/8CPiOcoGUt7e+PcCp63DHFh8TZxnUcdoe3SQHzv2kpRGhXxBL2Ovl7PQtCQXmKqSSMeKCavo='
WHERE id = XXXXX;
this way the password should be 12345
please don't forget to restart OM after DM manipulations
>
> 2. Also if I have to re-install again after first try, all I need to do is to
> delete the database right? or is there anything else OM is
> maintaining within the app server environment?
you will need to delete then create empty DB with correct collation
I would delete existing profile pictures/files/recordings due to they
will be useless
>
> We definitely want docker LB. I will be creating a ticket on that.
What is "docker LB"? :))
>
> Thank you,
> Regards,
> Sangeeta
--
Best regards,
Maxim
