search

prashants / webzash

Easy to use web based double entry accounting software in PHP - MySQL under MIT License
http://webzash.org
Other
207 stars 109 forks source link

Configure email settings #157

Closed jessicana closed 2 years ago

jessicana commented 2 years ago

How can I configure the mail settings using FTP?

prashants commented 2 years ago

You mean you want to change mail settings directly from a file and upload that using FTP ?

If that's the case then you can change mail settings from MySQL / Sqlite database since settings are stored in the database not in file.

On Wed, Oct 13, 2021 at 4:29 PM jessicana @.***> wrote:

How can I configure the mail settings using FTP?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/prashants/webzash/issues/157, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAAQULCXUOEOOYD43NUOR4DUGVRCVANCNFSM5F44TD2A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

jessicana commented 2 years ago

Yes, I am trying to configure my mailserver settings using the database because I am unable to access the system. I locked myself out :)

jessicana commented 2 years ago

I think this is really relevant to this problem. If a user can configure their email server credentials, they can reset their password and restore their account. I appreciate a hint please.

prashants commented 2 years ago

pls check the original ticket where you had issues with admin password. You were doing it correctly to the point of MySQL query (hope you are using version 3.x).

You should not be using the MD5() method on the password string. Just paste the entire string as it is since cakephp uses its own seed for the hashing function and MD5() will not work.

This is what you should do doing :-

update wzusers set password = "this is where the password string goes without any changes" where ID = 1;

jessicana commented 2 years ago

Solved. Thanks!

I had to add an admin user through the database. I will post the steps here for others to enrich the documentation.

Again, thank you very much for your support.