Installing Alfresco with MySQL

Operating System : CentOS 7

Software : Alfresco Community Edition

As we already knew, Alfresco is a software which is made as a solution for Enterprise Content Management (ECM) and Business Process Management (BPM).

Alfresco come with a community edition which can be downloaded and installed in our own workstation. Below is the installation step which is explaining on how to install Alfresco with an advanced installation type. We will divide it into three general steps which is the pre-installation step, the installation step itself and the last step which is actually the most important step is the post-installation step.

Pre-Installation Step :

Install your own Java Runtime Environment (JRE). Luckily I have already installed and it can be checked by executing the following command on the bash prompt :

java -version

Here below is the output of executing the above command :

java version "1.8.0_102"
Java(TM) SE Runtime Environment (build 1.8.0_102-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.102-b14, mixed mode)

The installed Java Runtime Environment (JRE) is needed to run Apache Tomcat Webserver. Alfresco’s execution process relies on it.

Installation Step :

1. Download Alfresco community version installer. It can be found and downloaded when this article is created at 2nd September 2016 in the following URL :

2. Run the Alfresco community version by typing the following command in the bash prompt :

Continue reading “Installing Alfresco with MySQL”

Cannot Access MySQL because Alfresco’s log consumed space storage

MySQL Database cannot be accessed because the Server’s storage is exhausted.

One of the application crashed and was displaying error messages. One of the most highlighted error message is that the application itself cannot connect to MySQL server.

This is step-by-step actions taken to resolve the problem :

  1. To be able to resolve the problem, we have to check it first by logging in to the database server which is represented by the IP Address of the database server itself.

Connect with the following command :

ssh username@IP_Address_Database_Server
  1. Try to log in to MySQL Console by executing the following command :
mysql -uroot -p

There is an error when we are trying to connect to MySQL console which the error itself can be specified as follows :

Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (38)

It means that we cannot connect to MySQL Server but before we go further, we have to check the status of MySQL service as follows :

systemctl status mysql.service

It can be shown as follows :

Continue reading “Cannot Access MySQL because Alfresco’s log consumed space storage”

Checking Alfresco Version

Checking Alfresco Version

Based on the official site of Alfresco, it is said that Alfresco is a software which is intended for business software as an open platform. To check version of currently running Alfresco, we can do it by checking the log file which is produced by Alfresco itself. To check the log file, we can actually execute the following command so we can check currently running version of Alfresco :

grep –i “alfresco started” alfresco.log

Pattern :

grep [parameter] [keyword] [log file name]

Where grep is a command which is used to print lines matching a pattern specified in the parameter value.

-i is an additional parameter which is used for insensitive search.

The keyword is placed after the additional parameter given which is enclosed within double quotes. To be able to find alfresco’s version, we have to search keyword related with the start of the alfresco process. The keyword is “alfresco started” in this context is picked because it will also provide additional information of the already started alfresco process which is more specifically the version of alfresco.

Continue reading “Checking Alfresco Version”