Create Superuser in Mysql

Login MySQL using

mysql -u root -p

CREATE USER 'superuser'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'superuser'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;

exit;

How to improve ubuntu performamce

 Here I have involved some steps which may helpful to optimize your Ubuntu server speed.

 

1. Update Your System

Regularly update your system to ensure you have the latest performance improvements and security patches.

 sudo apt update

sudo apt upgrade

 2. Remove Unnecessary Start-up Applications

 Disable unnecessary startup applications to reduce boot time and free up system resources.

 sudo apt install gnome-tweak-tool

gnome-tweaks

 Navigate to the "Startup Applications" section and disable unnecessary programs.

 3. Use Lighter Desktop Environments

If you are using a resource-heavy desktop environment like GNOME or KDE, consider switching to a lighter one like XFCE or LXDE.

 sudo apt install xfce4

sudo apt install lxde

 4. Manage Swappiness

Adjust the swappiness value to reduce the use of the swap file and improve performance.

 sudo sysctl vm.swappiness=10

sudo nano /etc/sysctl.conf

Add or edit the line vm.swappiness=10 in /etc/sysctl.conf.

 5. Clean Up Your System

Remove unnecessary files and packages to free up space and reduce clutter.

 sudo apt autoremove

sudo apt clean

sudo apt autoclean

 Use a tool like BleachBit to clean up system files.

 sudo apt install bleachbit

sudo bleachbit

 6. Optimize Disk Usage

Use tools like fsck to check and repair file system errors.

 sudo fsck /dev/sdX

Use fstrim to trim SSDs.

sudo fstrim -v /

 7. Use a Faster DNS Server

Changing your DNS server can improve network performance. Consider using a faster DNS provider like Google DNS or OpenDNS.

 sudo nano /etc/resolv.conf

Add the following lines:

 nameserver 8.8.8.8

nameserver 8.8.4.4

8. Upgrade Hardware

Adding more RAM or upgrading to an SSD can significantly improve system performance.

9. Disable Animations

Disabling animations can make your desktop environment feel snappier.

gsettings set org.gnome.desktop.interface 

enable-animations false

10. Monitor System Resources

Use system monitoring tools to keep an eye on resource usage and identify bottlenecks.

 sudo apt install htop

htop

 11. Use Lightweight Applications

Use lightweight alternatives to resource-heavy applications (e.g., using Featherpad instead of Gedit).

 12. Kernel Optimization

 Use a low-latency kernel if you're doing audio production or other real-time tasks.

 sudo apt install linux-lowlatency

 

Courtesy: ChatGPT

How to migrate Linux Dspace to Window 10

Take a backup of Dspace database and folders

Assume the version is same with both OS [I have tested DSpace 6.3]

sudo su

mkdir dspace_backup

sudo chmod 777 dspace_backup

exit

dspace_backup/backup.sh

Copy below script to backup.sh file

nano /home/dspace/dspace_backup/backup.sh

#!/bin/bash

PGPASSWORD="dspace" pg_dump -U dspace -h localhost -Fc dspace | gzip > home/dspace/dspace_backup/dspace-$(date +%Y-%m-%d-%H.%M.%S).sql.gz

now=$(date +"%d_%m_%Y")

zip -r  /home/dspace/dspace_backup/$now-assetstore.zip /dspace/assetstore

zip -r  /home/dspace/dspace_backup/$now-log.zip /dspace/log

save the file &

Give a permission to file

sudo chmod +x dspace_backup/backup.sh

Go to directory

cd /home/dspace/dspace_backup

Issue the command

sh backup.sh

copy all files from the directory to Window10

(there will be three files sql.gz, assetstore.zip, and log.zip)

Locate all backup of Dspace database and folders anywhere you wish.

No go to Window Tomcat server and stop its service by

stop tomcat sever

Go to start-up button and open PGAdmin-III 

bellow box will appeared 

create new database [dspace] and also create [pgcrypto] Extension also

Now click on database tab and restore dspacesql (gz) file where you have located your .gz file

after restoring dspace db

delete [assetstore] directory from C:/dspace/

copy new assetstore directory to C:/dspace/

then issue the following command in Window machine

open cmd

Go to 

cd C:\dspace\bin\

dspace database info

dspace database migrate

dspace index-discovery -b

dspace filter-media

dspace index-discovery

dspace index-discovery -o

Then restart Tomcat in Window-10

Now check your backup is fully restored http://yourIP:8080/jspui

If you need any further help please book your slot: Here

or Call me 9428415401

Installing Koha 23.05 on ubuntu

apt update

sudo apt-get -y install sudo wget gnupg

wget -q -O- https://debian.koha-community.org/koha/gpg.asc | sudo apt-key add -
sudo apt-get update
echo 'deb http://debian.koha-community.org/koha stable main' | sudo tee /etc/apt/sources.list.d/koha.list    
sudo apt-get update
sudo apt-get install koha-common
sudo apt-get install mysql-server 
sudo nano /etc/apache2/ports.conf
change INTRAPORT to 8080
Listen 80
Listen <staff interface port number> i.e. 8080
sudo nano /etc/koha/koha-sites.conf
sudo a2enmod rewrite 
sudo a2enmod cgi 
sudo service apache2 restart
sudo service apache2 restart 
sudo koha-create --create-db library
sudo nano /etc/apache2/sites-enabled/000-default.conf
sudo service apache2 restart 
To Know the koha_library password
sudo koha-passwd library
http://IP-Domain name:8080 (staff)
http://IP-Domain (OPAC)