[Koha] SMTP configuration error

[Coehoorn, Joel]

Gmail requires OAuth now by default, rather than username/password
authentication.

If you want to allow username/password authentication, you used to need to
enable the Less Secure Apps option. I've written about this before
<https://blogs.msmvps.com/jcoehoorn/blog/2017/05/04/what-are-less-secure-apps-in-google/>.
However, Google also began phasing out Less Secure Apps completely about
two weeks ago <https://support.google.com/accounts/answer/6010255?hl=en>. (*We
should probably be prepared on this mailing list to get more questions from
people who suddenly have their email stop working based on this change*).
The change has not yet come to Google Workspace (Organizational accounts),
and I don't recall seeing a specific date yet, but I do know Google is
committed to follow through with bringing this change to everyone.

What you will likely need to do instead is set-up a Per-App password
<https://support.google.com/accounts/answer/185833> for Koha.

Joel Coehoorn
Director of Information Technology
York College of Nebraska


On Sat, Jun 11, 2022 at 12:07 PM Katrin Fischer <katrin.fischer.83 at web.de>
wrote:

> Hi Naveen,
>
> when running command-line scripts from Koha, make sure to always run
> them as the Koha user. That should take care of the 'koha-conf.xml'
> problem you are seeing. If you have a package installation you can use
> 'koha-shell <instance name>' to give you a shell with the environment
> needed.
>
> There should never be a need to change any paths in files.
>
> Hope this helps,
>
> Katrin
>
>
> On 10.06.22 12:19, Ms. Naveen Ali wrote:
> > Dear All,
> >
> > I am trying to setup SMTP to send email notices;
> >
> > Using KOHA 21.11 and have configured the SMTP servers using the option
> in the Administration Module
> > I have configured Gmail SMTP with the following information
> > Host: smtp.gmail.com Port: 587
> > Timeout:120s SSL: SSL
> > Authentication: Yes (My gmail email address and password)
> >
> > I am receiving failed email status with "Unhandled email failure, check
> the logs for further details"
> >
> > Looking into mailing list threads, i tried running the
> process_message_queue.pl manually and got the following error
> >
> > library at KOHA:/usr/share/koha/bin/cronjobs$ ./process_message_queue.pl
> > unable to locate Koha configuration file koha-conf.xml at
> /usr/share/koha/lib/C4/Context.pm line 170.
> > Use of uninitialized value in concatenation (.) or string at
> /usr/share/koha/lib/C4/Templates.pm line 153.
> > Use of uninitialized value $file in exists at
> /usr/share/koha/lib/Koha/Config.pm line 78.
> > Use of uninitialized value $file in hash element at
> /usr/share/koha/lib/Koha/Config.pm line 79.
> > Use of uninitialized value $file in hash element at
> /usr/share/koha/lib/Koha/Config.pm line 82.
> > Use of uninitialized value $file in exists at
> /usr/share/koha/lib/Koha/Config.pm line 78.
> > Use of uninitialized value $file in hash element at
> /usr/share/koha/lib/Koha/Config.pm line 82.
> > Use of uninitialized value $INC[-1] in string eq at
> /usr/share/koha/lib/Koha/Plugins.pm line 40.
> > Use of uninitialized value $INC[-1] in string eq at
> /usr/share/perl/5.30/Net/Config.pm line 27.
> > Use of uninitialized value in require at
> /usr/share/perl/5.30/Net/Config.pm line 29.
> > Use of uninitialized value $file in exists at
> /usr/share/koha/lib/Koha/Config.pm line 78.
> > Use of uninitialized value $file in hash element at
> /usr/share/koha/lib/Koha/Config.pm line 82.
> > Use of uninitialized value $file in exists at
> /usr/share/koha/lib/Koha/Config.pm line 78.
> > Use of uninitialized value $file in hash element at
> /usr/share/koha/lib/Koha/Config.pm line 82.
> > DBIx::Class::Storage: BI::catch {...} (): DBI Connection failed: Can't
> call method "get" on an undefined value at
> /usr/share/koha/lib/Koha/Database.pm line 61. at
> /usr/share/koha/lib/Koha/Database.pm line 139
> >
> > I tried updating the the /usr/share/koha/lib/C4/Context.pm file with the
> path /etc/koha/sites/library/koha-conf.xml but no success. How do I resolve
> this issue??
> >
> > With thanks and best regards,
> >
> > Naveen Ali
> >
> > ITM-JE (EAKL)
> > Inst Representative for
> > HEC Digital Library Resources.
> > NEDUET, Karachi.
> >
> >
> > _______________________________________________
> >
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>