Installation on Linux/Debian: Difference between revisions

From nuBuilderForte
Jump to navigation Jump to search
 
(23 intermediate revisions by 4 users not shown)
Line 1: Line 1:
Back to [[Documentation]]


== '''LAMP server installation on Linux Debian''' ==
== LAMP server installation on Linux Debian ==




Line 7: Line 8:
To do this, you can follow any Linux/Debian installation guide. A few links which can be helpful are listed below:
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)''
''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.cyberciti.biz/faq/how-to-install-lamp-on-debian-10-buster/
Line 20: Line 22:
Recommended PHP modules to install (adjust acc. to your version):
Recommended PHP modules to install (adjust acc. to your version):
<pre>
<pre>
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
php8.1-cli php8.1-fpm php8.1-pdo php8.1-mysql php8.1-zip php8.1-gd  php8.1-mbstring php8.1-curl php8.1-xml php8.1-bcmath php8.1-common php8.1-xml php8.1-intl php8.1-bz2 php8.1-soap php8.1-mysql php8.1-readline php8.1-opcache php8.1-mbstring php8.1-gd php8.1-curl php8.1-pspell php8.1-zip php8.1-tidy php8.1-sqlite3 php8.1-imap php8.1-cli php8.1-fpm php8.1-cgi php8.1-cgi-dbgsym libapache2-mod-php8.1
 
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
</pre>
</pre>
== Creation of database. ==


== '''Creation of database.''' ==
The database for nuBuilder Forte can be created from the command line or with phpMyAdmin if installed together with LAMP server.  
 
 
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.
Please note that phpMyAdmin is included in the nuBuilder package and will be available from it after full installation and commissioning of nuBuilder.




'''Example'''
''Example (Name of database: TestDB)''
(Name of database: TestDB)


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


First, open the mysql command line from the system terminal with:
First, open the mysql command line from the system terminal with:
Line 47: Line 39:
mysql -u root -pYourRootPsw
mysql -u root -pYourRootPsw
</pre>
</pre>
 
Next, the DB and user can be created as follows:
Next, the DB and user can be created and privileges granted as follows:
<pre>
<pre>
CREATE DATABASE IF NOT EXISTS MyNuBuilder4DB;
create database TestDB;
GRANT ALL PRIVILEGES ON MyNuBuilder4DB.* to 'globeadmin'@'%' identified by 'nuBpsw';
create user 'globeadmin'@'%' identified by 'nuB4psw';
grant all privileges on TestDB.* to 'globeadmin'@'%';
</pre>
</pre>


== '''Downloading nuBuilder Forte''' ==
== Downloading nuBuilder Forte ==


Download the nuBuilder Forte zipped files from SourceForge, place in your webroot, unzip and set permissions like:
Download the nuBuilder Forte zipped files from SourceForge
https://sourceforge.net/projects/nubuilder/
<pre>
wget https://sourceforge.net/projects/nubuilder/files/latest/download -O nubuilder.zip
</pre>
Unpack the downloaded file
<pre>
unzip nubuilder.zip -d TestDB
</pre>
The folder TestDB must be placed in the Apache2 folder to be accessible externally. Typically it will be:
<pre>
<pre>
cd /var/www/html
/var/www/html/TestDB
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
</pre>
</pre>


== '''nuBuilder configuration''' ==
== nuBuilder configuration ==
 
Edit '''nuconfig.php''' (nano editor can be used or any other)
 
>>> ''nano /var/www/html/TestDB/nuconfig.php''


Edit '''nuconfig-sample.php''' (nano editor can be used or any other)
<pre>
nano /var/www/html/TestDB/nuconfig.php
</pre>
For simplicity the same name and password both for DB and nuBuilder accounts were used here - but different ones can be used as well.
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 <tt>nuconfig.php</tt> but for the beginning the following ones are sufficient to set-up:
There are more settings possibilities in nuconfig.php but for the beginning the following ones are sufficient to set-up:
 
<pre>
<pre>
$nuConfigDBName                    = "TestDB";
$nuConfigDBName                    = "TestDB";
$nuConfigDBUser                    = "globeadmin";
$nuConfigDBUser                    = "globeadmin";
$nuConfigDBPassword                = "nuBpsw";
$nuConfigDBPassword                = "nuB4psw";
$nuConfigDBGlobeadminUsername      = "globeadmin";
$nuConfigDBGlobeadminUsername      = "globeadmin";
$nuConfigDBGlobeadminPassword      = "nuBpsw";
$nuConfigDBGlobeadminPassword      = "nuB4psw";
$nuConfigTitle                      = "TestDB - nuBuilder";''
$nuConfigTitle                      = "TestDB - nuBuilder";
</pre>
</pre>


== '''Launch of nuBuilder''' ==


After the configuration you can login to nuBuilder with link to the folder on your http server.
Next, rename '''nuconfig-sample.php''' to '''nuconfig.php'''.
 
== Launch of nuBuilder ==


(But of course you need to use your own server address)
After the configuration you can login to nuBuilder with the link to the folder on your http server.


''But of course you need to use your own server address.''
<pre>
http://192.168.1.10/TestDB/index.php
http://192.168.1.10/TestDB/index.php
 
</pre>
when the login window appears enter the nuBuilder user and password:
when the login window appears enter the nuBuilder user and password:
 
<pre>
User: globeadmin
User: globeadmin
Password: nuB4psw
</pre>
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).


Password: nuBpsw
== Additional system settings ==
Allow nuBuilder and phpMyadmin to access their temp folders.
<pre>
chown -R www-data:www-data /var/www/html/TestDB


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).
cd /var/www/html/TestDB
chmod 400 nuconfig.php
</pre>

Latest revision as of 13:57, 25 February 2023

Back to Documentation

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):

php8.1-cli php8.1-fpm php8.1-pdo php8.1-mysql php8.1-zip php8.1-gd  php8.1-mbstring php8.1-curl php8.1-xml php8.1-bcmath php8.1-common php8.1-xml php8.1-intl php8.1-bz2 php8.1-soap php8.1-mysql php8.1-readline php8.1-opcache php8.1-mbstring php8.1-gd php8.1-curl php8.1-pspell php8.1-zip php8.1-tidy php8.1-sqlite3 php8.1-imap php8.1-cli php8.1-fpm php8.1-cgi php8.1-cgi-dbgsym libapache2-mod-php8.1

Creation of database.

The database for nuBuilder Forte can be created from the command line or with phpMyAdmin if installed together with LAMP server.

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 follows:

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

mysql -u root -pYourRootPsw

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

create database TestDB;
create user 'globeadmin'@'%' identified by 'nuB4psw';
grant all privileges on TestDB.* to 'globeadmin'@'%';

Downloading nuBuilder Forte

Download the nuBuilder Forte zipped files from SourceForge: https://sourceforge.net/projects/nubuilder/

wget https://sourceforge.net/projects/nubuilder/files/latest/download -O nubuilder.zip

Unpack the downloaded file

unzip nubuilder.zip -d TestDB

The folder TestDB must be placed in the Apache2 folder to be accessible externally. Typically it will be:

/var/www/html/TestDB

nuBuilder configuration

Edit nuconfig-sample.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                 = "nuB4psw";
$nuConfigDBGlobeadminUsername       = "globeadmin";
$nuConfigDBGlobeadminPassword       = "nuB4psw";
$nuConfigTitle                      = "TestDB - nuBuilder";


Next, rename nuconfig-sample.php to nuconfig.php.

Launch of nuBuilder

After the configuration you can login to nuBuilder with the 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: nuB4psw

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

Additional system settings

Allow nuBuilder and phpMyadmin to access their temp folders.

chown -R www-data:www-data /var/www/html/TestDB

cd /var/www/html/TestDB
chmod 400 nuconfig.php