Installation on Linux/Debian: Difference between revisions

From nuBuilderForte
Jump to navigation Jump to search
Line 29: Line 29:
</pre>
</pre>


== '''Creation of database.''' ==
== '''Creation of database''' ==





Revision as of 10:27, 2 January 2021

LAMP server installation on Linux Debian

Before installing nuBuilder Forte on your server you need to make sure that Apache2, MariaDB and PHP are properly installed, configured and fully operational.

To do this, you can follow any Linux/Debian installation guide. A few links which can be helpful are listed below:

(It is best to just apply the recommended settings during the installation process)

https://www.cyberciti.biz/faq/how-to-install-lamp-on-debian-10-buster/

https://www.tecmint.com/install-lamp-on-debian-10-server/

https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mariadb-php-lamp-stack-on-debian-10

https://linuxhint.com/install_phpmyadmin_debian_10/


Recommended PHP modules to install (adjust acc. to your version):

php7.4-cli php7.4-fpm php7.4-pdo php7.4-mysql php7.4-zip php7.4-gd  php7.4-mbstring php7.4-curl php7.4-xml

php7.4-bcmath php7.4-json php7.4-common php7.4-intl php7.4-bz2 php7.4-soap php7.4-mysql php7.4-readline

php7.4-opcache php7.4-mbstring php7.4-gd php7.4-curl php7.4-pspell php7.4-zip php7.4-xmlrpc php7.4-tidy php7.4-sqlite3

php7.4-imap php7.4-cli php7.4-fpm php7.4-cgi php7.4-cgi-dbgsym libapache2-mod-php7.4

Creation of database

The database for nuBuilder Forte can be created from the command line or with phpMyAdmin which will allow a more user friendly way to perform that process. (The installation of phpMyAdmin is included in the last link).

Please note that phpMyAdmin is included in the nuBuilder package and will be available from it after full installation and commissioning of nuBuilder.


Example (Name of database: TestDB)

In case of mysql command line the database can be created as following:

First, open the mysql command line from the system terminal with:

mysql -u root -pYourRootPsw

Next, the DB and user can be created and privileges granted as follows:

CREATE DATABASE IF NOT EXISTS MyNuBuilder4DB;
GRANT ALL PRIVILEGES ON MyNuBuilder4DB.* to 'globeadmin'@'%' identified by 'nuBpsw';

Downloading nuBuilder Forte

Download the nuBuilder Forte zipped files from SourceForge, place in your webroot, unzip and set permissions like:

cd /var/www/html
wget --no-check-certificate -c https://sourceforge.net/projects/nubuilder/files/latest/download -O nubuilder4.zip
unzip nubuilder4
mv nubuilder4 nubuilder
chown -R www-data:www-data nubuilder

nuBuilder configuration

Edit nuconfig.php (nano editor can be used or any other)

>>> nano /var/www/html/TestDB/nuconfig.php

For simplicity the same name and password both for DB and nuBuilder accounts were used here - but different ones can be used as well.

There are more settings possibilities in nuconfig.php but for the beginning the following ones are sufficient to set-up:

$nuConfigDBName                     = "TestDB";
$nuConfigDBUser                     = "globeadmin";
$nuConfigDBPassword                 = "nuBpsw";
$nuConfigDBGlobeadminUsername       = "globeadmin";
$nuConfigDBGlobeadminPassword       = "nuBpsw";
$nuConfigTitle                      = "TestDB - nuBuilder";''

Launch of nuBuilder

After the configuration you can login to nuBuilder with link to the folder on your http server.

(But of course you need to use your own server address)

http://192.168.1.10/TestDB/index.php

when the login window appears enter the nuBuilder user and password:

User: globeadmin

Password: nuBpsw

All the required tables will be created automatically. So no need to import manually the initial nubuilder4.sql to MariaDB - (anyway manual import is as well allowed).