Re: [Koha] Connection timed out whenever I try a Z39.50 search
Thank you for your response. Which ports should I check? No Z39.50 service is working, not even the Library of Congress. Kind regards, Dimitrios Dalagiorgos 3rd high school of Kozani Greece Στις Παρ 13 Οκτ 2023 στις 10:24 π.μ., ο/η David Nind έγραψε: > One thing to look for is to see if the ports used for the Z39.50 services > you are trying to access are blocked by your organisation's firewall. > > Or maybe the Z39.50 sources are no longer available... I'm sure there is a > way to check if they are, but not sure how to myself. > > David Nind > New Zealand > > On Fri, 13 Oct 2023 at 20:17, Δημήτρης Δαλαγιώργος < > dimitrios.dalagior...@gmail.com> wrote: > >> Dear all, >> >> I have added several Z39.50 interfaces to my library but for some reason >> searching through Z39.50 no longer works; I get a connection timeout error >> message. >> >> Where should I start looking to remedy this? >> >> Kind regards, >> >> Dimitrios Dalagiorgos >> 3rd high school of Kozani >> Greece >> ___ >> >> 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
Re: [Koha] Can't send email from koha
Thank you for your response. It proved to be even simpler than that: I had forgotten to make the smtp server the default mail server, so Koha was trying to use the localhost to send the emails, and failed. Kind regards, Dimitrios Dalagiorgos 3rd high school of Kozani Greece Στις Παρ 13 Οκτ 2023 στις 10:42 π.μ., ο/η David Nind έγραψε: > You need to ensure that the MTA (Message Transport Agent) you are using on > your server to send email is configured and working correctly. There are > many MTAs, such as Postfix, Sendmail, Exim4. There are plenty of tutorials > and guides on the internet, but these are not specific in any way to Koha. > > I don't know anything about MTAs myself, and these days sending email can > be "complicated"... > > If your MTA is working - that is, you can successfully send external email > from the server (for example, from the server command line) - then in Koha > you need to ensure: > - you have emails in the system preferences configured, including > KohaAdminEmailAddress and ReplyTo > - your patrons have email addresses > - email is enabled for your Koha instance: koha-email-enable > yourinstancename > - the cronjob to process emails is set up and running: emails are added to > the message_queue table in the database and are sent when the > process_message_queue.pl cronjob is run (perl misc/cronjobs/ > process_message_queue.pl) > > I hope this helps a little. Hopefully, someone with experience in this can > comment. > > Normally logs are easy to read if you have the right permissions, as they > are just text files. Do you have enough disk space on the volume your logs > are on? (df -h /) > > David Nind > New Zealand > > > On Fri, 13 Oct 2023 at 20:19, Δημήτρης Δαλαγιώργος < > dimitrios.dalagior...@gmail.com> wrote: > >> Dear all, >> >> I think I have properly set up my email setting on Koha, but I can't send >> any emails. Trying to see the logs crashes the system. >> >> Where can I start looking to remedy this? >> >> Kind regards, >> >> Dimitrios Dalagiorgos >> 3rd high school of Kozani >> Greece >> ___ >> >> 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
[Koha] Can't send email from koha
Dear all, I think I have properly set up my email setting on Koha, but I can't send any emails. Trying to see the logs crashes the system. Where can I start looking to remedy this? Kind regards, Dimitrios Dalagiorgos 3rd high school of Kozani Greece ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Connection timed out whenever I try a Z39.50 search
Dear all, I have added several Z39.50 interfaces to my library but for some reason searching through Z39.50 no longer works; I get a connection timeout error message. Where should I start looking to remedy this? Kind regards, Dimitrios Dalagiorgos 3rd high school of Kozani Greece ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to resolve bug Bug 28267? What must I do in mysql?
No I hadn't! I didn't manage to get the script running, but I did log in to mysql, run the SELECT command, get the list of tables, export the tables to excel to make the multiple ALTER TABLE queries and finally run the queries on the mysql server. AND IT WORKED! IHAVE MY CATALOGUE BACK! I'm so happy! Thanks for your help! Dimitrios Dalagiorgos 3rd high school of Kozani Στις Πέμ 2 Μαρ 2023 στις 9:37 π.μ., ο/η Jonathan Druart έγραψε: > > Did you see comment 20? > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267#c20 > > Le jeu. 2 mars 2023 à 06:30, Δημήτρης Δαλαγιώργος > a écrit : >> >> Dear all, >> >> I'm not a developer, and as I mentioned before, I'm stuck with an >> inoperable library catalogue due to the fact that I can't update to >> the latest version because "Older databases fail to upgrade due to >> having a row format other than "DYNAMIC"". >> >> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267 >> >> I've read the comments on this bug but I fail to understand what I >> should do to fix this. Obviously I must login to mysql and perform >> some actions. What actions are those? Can someone point me to detailed >> instructions? >> >> Kind regards, >> >> Dimitrios Dalagiorgos >> 3rd high school of Kozani >> ___ >> >> 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
[Koha] How to resolve bug Bug 28267? What must I do in mysql?
Dear all, I'm not a developer, and as I mentioned before, I'm stuck with an inoperable library catalogue due to the fact that I can't update to the latest version because "Older databases fail to upgrade due to having a row format other than "DYNAMIC"". https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267 I've read the comments on this bug but I fail to understand what I should do to fix this. Obviously I must login to mysql and perform some actions. What actions are those? Can someone point me to detailed instructions? Kind regards, Dimitrios Dalagiorgos 3rd high school of Kozani ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Update database from Koha 22.06.00.078 to 22.11.02.000 failed
Thanks Katrin, Unfortunately I don't understand if I have to create new files, or append the code I see to existing ones. The instructions are obviously intended for developers and I'm not sure who to contact for more details. Dimitrios Dalagiorgos 3rd High School of Kozani Greece ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Update database from Koha 22.06.00.078 to 22.11.02.000 failed
I upgraded my Debian system from 9 to 11. When I tried to log in to koha admin I was welcomed by the web installer. Trying to run the web installer I got the following error: Web installer › Update database We are upgrading from Koha 22.06.00.078 to 22.11.02.000 Updating database structure Update errors : Upgrade to 22.06.00.079 [14:46:54]: Bug 32030 - Add an ERM module ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs at /usr/share/koha/lib/C4/Installer.pm line 739 Added new system preference 'ERMModule' ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs at /usr/share/koha/lib/C4/Installer.pm line 739 Added new permission 'erm' ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs at /usr/share/koha/lib/C4/Installer.pm line 739 I have no idea what they mean and how to fix them. Dimitrios Dalagiorgos 3rd High School of Kozani Greece ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] How do I upgrade to Koha 22.11?
Hi, I've got Koha 22.05.04.000 running on a virtual machine with Linux 4.9.0-19-amd64 #1 SMP Debian 4.9.320-2 (2022-06-30) x86_64 I used to run sudo apt-get update and then sudo apt-get upgrade to get koha upgraded to the newest version. Now it doesn't work or I'm forgetting something. How do I upgrade my koha installation to the latest version? Dimitrios Dalagiorgos 3rd High School of Kozani Greece ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha