SMTP configuration error
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@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.
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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@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
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
On 10.06.22 12:19, Ms. Naveen Ali wrote: 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@KOHA:/usr/share/koha/bin/cronjobs$ ./process_message_queue.pl unable to locate Koha configuration file koha-conf.xml at
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
/usr/share/koha/lib/C4/Context.pm line 170. 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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
El lun, 13 jun 2022 a las 16:22, Coehoorn, Joel (<jcoehoorn@york.edu>) escribió:
What you will likely need to do instead is set-up a Per-App password <https://support.google.com/accounts/answer/185833> for Koha.
That's what I use in my dev environment. Thanks for the link, Joel! -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
Hi! On Mon, Jun 13, 2022 at 02:21:06PM -0500, Coehoorn, Joel wrote:
What you will likely need to do instead is set-up a Per-App password <https://support.google.com/accounts/answer/185833> for Koha.
One thing that took me a while to figure out (in a non-Koha context[0]) is that you have to enable 2FA ("2-Step Verification") for the account to be able to set up per-app passwords. 0: https://domm.plix.at/perl/2022_05_use_multiple_gmail_accounts_via_mutt_and_o... Greetings, domm -- #!/usr/bin/perl https://domm.plix.at for(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/}
participants (5)
-
Coehoorn, Joel -
Katrin Fischer -
Ms. Naveen Ali -
Thomas Klausner -
Tomas Cohen Arazi