Friday, February 1, 2019

Installing SubjectPlus 4.2 on Ubuntu 16.04 LTS

SubjetcPlus is a free and open source tool to help you manage several interrelated parts of your library data

sudo apt update

sudo apt install mysql-server

sudo systemctl start mysql.service

then
CREATING USERS AND DATABASES


To create a MySQL database and user, follow these steps: At the command line, log in to MySQL as the root user:

mysql -u root -p

Type the MySQL root password, and then press Enter

CREATE DATABASE subjectplus;

CREATE USER sp@localhost;

SET PASSWORD FOR sp@localhost= PASSWORD("yourpassword");

GRANT ALL  ON `sp`.* TO `sp`@`localhost` IDENTIFIED BY 'yourpassword';

GRANT ALL PRIVILEGES ON subjectplus.* TO sp@localhost IDENTIFIED BY 'password';

FLUSH PRIVILEGES;

SHOW DATABASES;

View All MySQL Databases

To view the database you’ve created simply issue the following command:
exit 

Your result should be similar to this:

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| spdb               |
| mysql              |
| test               |
| tutorial_database  |
+--------------------+
4 rows in set (0.00 sec)


sudo service apache2 restart

sudo service mysql restart

apt-get install unzip

mkdir -p /var/www/html/sp

wget https://github.com/subjectsplus/SubjectsPlus/archive/master.zipunzip -q /var/www/html/sp/master.zip

chown -R www-data.www-data /var/www/html/spchmod -R 755 /var/www/html/sp
URL http://localhost/sp/SubjectsPlus-master/

No comments:

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...