foss

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

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

Force Default messaging preferences on Patron Categories #Koha

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

Koha Notices via Custom Self Hosted End Point

#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

Utilizing Off Time in Internet Radio

No one likes a silence when tuning to a radio station, and for a radio manager its tough to have 24*7 programmes, in case you are running an Internet Radio Station using Airtime you probably would be programming your shows and in Offtime your radio is always silent i would suggest you to play some random tracks in this Offtime and also include a track which tells when your station plays live so here is how to achieve this

Resize Multiple Images

I am sure you would have come to a situation when you would have to resize multiple images say you copied 200 images from your Digital Camera and now need to upload them and need to resize them all, now doing this using GIMP would take ages here is a easy way.

Step 1) Install ImageMagick

sudo apt-get install imagemagick

Step 2) Change to the Directory where all Images are Present

Step 3)

a) If you need to reduce images to a specific Percentage

mogrify -resize 20% -format jpg *

b) If you need to reduce to Specific Width & Height

mogrify -resize 800x600 -format jpg *

c) If you need to reduce to Specific Width

mogrify -resize 1024x -format jpg *

Further Reading Click Here !!!

Broadcom 43xxx on Linux (openSUSE)

Hopefully there would be many like me who have struggled in configuring Broadcom Wifi Cards on Linux due to their proprietory drivers, now a days it works fine in Ubuntu if you download the drivers available but still it doesnot work with various other distros. so here is a 3 step guide to configure Broadcom Wifi on your linux box these steps have been tested on openSUSE but would work on any distro Step 1 ) Download a file from here. Step 2) Install bcm43xx-fwcutter it is commonly avaiable for all distros Step 3 ) follow the commands

GNUnify 09

GNUnifyGNUnify is one of the biggest FOSS event which is completely managed and organized by the students of Symbiosis Institute of Computer Studies & Research. Each batch of MSc (CA) only gets one opportunity to organize it last time we "RESPAWN" organized and the tradition continued with the current batch which organized the 7th GNUnify. It was sponsored by Mozilla, they also presented a few talks this year which were great.

GNUnify '09

GNUnify enters 7th Year
What it is?
GNUnify, an annual technical extravaganza is organized by the students of Symbiosis institute of computer studies and research (SICSR) GNUnify, the name symbolizes GNU / Linux, the philosophy behind Free/Open source, unifying and strengthening the free / open source movement, sharing and spreading knowledge with the help of IT.

Ichalkaranji Workshop Day three - July 9th 2008

I and Gaurav Pant from PLUG (Pune Gnu/Linux Users Group) were the faculty for Day 3 @ IchalkaranjiWorkshop.

Ichalkaranji Workshop was organized at D.K.T.E.'s Textile & Engg Institute, Ichalkaranji by NRCFoss and was co-sponsored by Ministry of Information Technology, Govt of Inida

The first half of day's was conducted by Gaurav.