authentication failure [SMTP: STARTTLS failed (code: 220, response: 2.0.0 SMTP server ready)]

[kimreq]

i dont know y I'm getting this error eveything is correct authentication and all are perfect?
please solve this issue and i want that is this because of version differences????

[JediKev]

@coopjab

Did Microsoft make the switch for your account and force you to use OAuth while disabling the Legacy Authentication?

If so, you will have to wait until we implement OAuth for email authentication.

If not, please post any related errors from your mail server and webserver error logs.

Cheers.

[kimreq]

yes forced to use OAuth

[kimreq]

@JediKev
hey OAuth is disabled and there no authentication in office 365 when i opened mail directly account opened without OAuth .......

help me please where im doing wrong???

[JediKev]

@coopjab

For the SMTP Hostname instead of smtp.office365.com use tls://smtp.office365.com and retry.

Cheers.

[ntozier]

We use:

So maybe the problem is the account being used, or environment based. Here is our environment:

[kimreq]

@JediKev @ntozier
when i was creating db for os ticket in heidi sql i got this error Acess denied root@localhost (password=yes)
after that i tried to create new in fresh machine and still I'm getting stucked in this error
please help me ? where I'm doing wrong

[JediKev]

@coopjab

From first glance, it looks like the credentials you are trying to use are incorrect. Access Denied typically means authentication credentials are incorrect but it could also mean a few other things so you should consult the MySQL error logs and documentation. This unfortunately falls outside the scope of our support so I really wouldn’t be able to help you with this.

Cheers.

[ntozier]

@coopjab as a side note you probably do not want to use the MySQL/MariaDB root user as your database user. If that account ever got compromised it would compromise your entire SQL server. Where as if you use one specific for the osTicket database if that got compromised it would only compromise that database.

As a second note: Depending on how your MySQL/MariaDB server was setup, you might have to use the account locally to create a database. I presume that you are not running the HeidiSQL on the server and are running it on your desktop, which would mean that your root user doesn't have privs to be used remotely. This is a security thing on your root account, and one I recommend that you not remove.

[kimreq]

@ntozier

thanks man i gotcha ... everything is working fine

[ntozier]

If you are all set then place close this issue report. :)

[JediKev]

@coopjab Should I close this issue now?

[kimreq]

thanks man i will close @JediKev