After a recent update in mysql client starting MariaDB 15.2 and MySQL clients SSL is enabled by default (ssl-verify-server-cert=TRUE).

Now when you connect using the following command which was being used since ages 

mysql -h <host> -u <user> -p

the following error is seen

ERROR 2026 (HY000): TLS/SSL error: self-signed certificate in certificate chain
 

Now to connect you have the following options

Oh, I was sending Notifications to Patrons on Item Issue, but suddenly the management have instructed to send notifications on Item Return, Renewal etc as well or they have asked to send Notifications as SMS/WhatsApp in addition to Email, and now i realise that this will ge a pain to implement as i will need to implement this for each patron.

NO NO

This can be done automatically here is the solution

Step 1 ) Modify Messaging Preference for each  Patron Categories

#Idea

Use the SMS Service present in Koha to send Notices to Patrons

SMS Plugin which send Notices as JSON Data to an Endpoint using POST, Endpoint can be yours own endpoint or a service provided by a service provider. Handle the JSON data in Endpoint and send the Notice using your Custom Code or Service Provider to WhatsApp / Telegram / Whatever

Drupal 10 is officially with us since a month now , After all the efforts and much wait i have started upgrading sites to D10, have upgraded a few which had very minimum functionality including this site, now planning to upgrade rest to D 9.5 so that D10 could be possible for others soon, but again it will take much time as it requires various modules and theme compatibility issues resolution.