Installation on Linux/Debian: Difference between revisions
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://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).