Cerb is an open source application for web based collaboration and automation. Cerb is written in PHP and uses MySQL or MariaDB to store data. You can also use Cerb for sending high volumes of emails. It allows you to create a personalised mission control with shared and private workspaces for every team member. It allows you to build bots with sophisticated automation behaviors directly from your web browser (no coding experience required!). Add decisions, outcomes, loops, actions, and subroutines. Make bots smarter using machine learning. Trigger and catch webhooks, Integrate with any API. Some of its features are listed below:
Contact management and Task management
Devblocks, a plugin-driven web development framework
Monitor your performance
Cerb does not require any special hardware to install on your server but we recommend you to install Cerb on a fresh and updated CentOS 7 server. You'll need to be logged in as root user on server to follow this tutorial.
Update the System
Before going through the installation process it is highly recommended you update your system and upgrade all available packages. Run the command given below and it'll do the job for you.
yum -y update
Installing Apache Web Server
Once the system is updated, you can install the dependencies required. To install Cerb you will need to install the Apache web server along with MaraiDB and PHP with a few extensions.
Run the following command to install the Apache web server.
yum -y install httpd
Now you can start Apache and enable it to start at boot time, using the following commands.
You can check status of mariaDB using this below given command and you should see following output.
systemctl status mariadb.service
[root@Sajid ~]# systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2017-02-08 14:47:40 UTC; 22s ago
Main PID: 18035 (mysqld_safe)
├─18035 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─18192 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/ma...
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: The latest information about MariaDB is available at http://mariadb.org/.
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: You can find additional information about the MySQL part at:
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: http://dev.mysql.com
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: Support MariaDB development by buying support/new features from MariaDB
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: Corporation Ab. You can contact us about this at email@example.com.
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: Alternatively consider joining our community based development effort:
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
Feb 08 14:47:39 ip-172-31-22-142 mysqld_safe: 170208 14:47:39 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Feb 08 14:47:39 ip-172-31-22-142 mysqld_safe: 170208 14:47:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Feb 08 14:47:40 ip-172-31-22-142 systemd: Started MariaDB database server.
we recommend you to make sure that this installation is secure and to do so run following command.
You'll be asked to provide root password so enter appropriate password and answer yes to all questions by pressing Y.
Now you'll have to create a database for cerb so please follow the instructions.
mysql -u root -p
You'll be asked to enter password so simply enter a password and now execute the following queries to create a new database.
CREATE DATABASE cerb_data;
The above query will create a database named cerb_data. For the database you can use any name you prefer in the place of cerb_data. Make sure that you use semicolon at the end of each query as a query always ends with a semicolon. Once the database is created you can create a new user and grant the required permissions to the user for the database.
CREATE USER 'cerb_user'@'localhost' IDENTIFIED BY 'StrongPassword';
The above query will create a user with username cerb_user. You can use any preferred username instead of cerb_user. Replace StrongPassword with a strong password.
Now provide the appropriate privileges to your database user over the database you have created. Run the following query to do so.
GRANT ALL PRIVILEGES ON cerb_data.* TO 'cerb_user'@'localhost';
Now run the following query to immediately apply the changes on the database privileges.
Now you can exit from MariaDB prompt using following command.
We will have to install PHP. To do so run following commands as shown below.
Next you'll have to edit some PHP settings to fulfill Cerb requirements in order to do so run these commands.
Now update following lines as shown below:
memory_limit = 128M # 128M or Higher according to the memory available
upload_max_filesize = 2M # 32M or Higher
post_max_size = 8M # 32M or Higher
;upload_tmp_dir = # Uncomment and change it to upload_tmp_dir = /tmp
Next you'll have to restart your apache web server to load new components that we just configured and use following command to restart apache web server.
systemctl restart httpd.service
We have successfully installed all the dependencies required for cerb now we are ready to install cerb on centos server. First of all install git if you do not already have installed using ``yum -y install git`
Next, go to the web root directory and clone the latest version of cerb from git, you can do so using following command.
cd /var/www/htmlgit clone git://github.com/wgm/cerb.git cerb
Next, you'll have to change proper ownership and provide file permissions, you can do so using following command.
cd /var/www/html/cerbchown -R apache:apache .chmod -R u+w framework.config.php storage
Next you'll have to modify firewall rules and if in case you don't have firewalld services installed on your server then you can install it using yum -y install firewalld and you can start it using systemctl start firewalld
Next run these below given command to modify the firewalld rules.
Open up your favorite web browser and visit http://yourserverIP/cerb .
On the database setup page choose the driver MySQLi and engine InnoDB. Also provide the database name and credentials that you have created earlier. Once the database connection is checked, it will ask you to provide details of your SMTP server to send outgoing emails. Finally, create the administrator user.
Truth be told, it’s difficult for a web application that doesn’t have some kind of identification, even if you don’t see it as a security measure in and of itself. The Internet is a kind of lawless land, and even on free services like Google’s, authentication ensures that abuses will...
Although data persistence is almost always a fundamental element of applications, Node.js has no native integration with databases. Everything is delegated to third-party libraries to be included manually, in addition to the standard APIs. Although MongoDB and other non-relational databases are the most common choice with Node because if you...