Installing Pentaho Business Analytics 5.2 Community Edition on Ubuntu

To download community edition, access the site http://community.pentaho.com. 

Click on the download section on the  page and access Community Edition 5.2 Business Analytics Platform.

Clicking on download, downloads a zip file. Extract the zip file to your folder of choice. It reveals a file called biserver-ce. I renamed my folder to biserver52-ce. Pentaho ships with a tomcat folder. I accessed the /bin directory and executed ./version.sh to check the version of Tomcat bundled.

I changed the standard ports to avoid conflicts with other Tomcat instances on my machine. I made the following changes in the /tomcat/conf/server.xml file.

http port: 8083
redirect port: 8449
shutdown port: 8008
ajp port: 8012

I saved the file and executed ./start-pentaho.sh in my pentaho root folder. This prompts a choice to acceptance automatic version updates. I agreed by pressing Enter and continued.

Accessing http://localhost:8083 launches the Pentaho login screen.

To assist in evaluation, Pentaho ships with an admin and a business user profile. These can be accessed by clicking the "Login as an Evaluator" button that displays the two profiles.

Clicking on "Go" on the admin profile, logs in as the administrator. You can see the admin logged in on the top right corner.

Signing out and logging in as "suzy" the business user logs you in with an end user profile.

That's it folks!

Installing Alfresco 5.0 Community Edition on Ubuntu 13.10

In this post, I want to write about downloading and installing Alfresco 5.0, an Open Source Enterprise Content Management System on Ubuntu 13.10. In a previous post, I had deployed Alfresco 4.2 Community Edition on Ubuntu 12.04. The steps are nearly identical with some minor differences.

From the primary site, I navigated to url http://www.alfresco.com/products/community/download to see available installers for the Community Edition of the software.

Entering the details brought me to the following page:

Clicking on the second link for Linux installer, it starts downloading the installer to your machine.

Once download was complete, I closed the browser to proceed. To install, move the installer to a target folder from the downloads folder.

Next, we need to make the installer executable

$ chmod a+x *.bin

Now, we need to run the installer by issuing the following command

$ ./alfresco-community-5.0.c-installer-linux-x64.bin

This brings the dialog box for default language

Next screen, informs that we are setting up the community edition of the software

Clicked on forward gives the following screen. Since, I knew I would have to modify the port entries, I selected the Advanced option to change default ports and other settings.

On the next screen, I checked off the software components that I already had on my machine (Java, PostgreSQL, LibreOffice) and turned off the components I did not need (SharePoint). Ended up making the following selections

In the next screen, we select the installation folder. I updated the default location to something of my preference.

I wanted to deploy the software against PostgreSQL, which is the option it gave me. I created a user called sa and a database called alfresco5 on my machine using pgAdmin III tool.

With the database created, I can resume the installation to go to the next screen that prompts to enter the database connection values.

The next screen displays the ports to be setup. I checked my open ports using appropriate tools. I have posted on the way to check available ports here. Based on the results, I modified the default port entries as follows:

Next the installation prompted for a ftp port setting. I left it as default.

Next the installer prompted for the RMI port for remote invocation. I again left it as default.

Finally, the installer asks the installer to specify a password for the admin user. I put my admin password as “admin123”, so I could remember it easily.

Clicking on Forward brought a prompt indicating the setup was ready as shown below.

Clicking on the Forward button, starts the installation. It takes a while after setting up the files for the installation to complete.

After the installation is complete, the following prompt is shown.

Next, I launched a browser and accessed the location (http://localhost:8082/alfresco) on my browser.

The application took some time as the initial tables were setup in the database repository and finally the Alfresco site was displayed on the browser. Accessing the site http://localhost:8082/share in Alfresco 5.0 prompts for the admin login and password. I entered my admin credentials in the screen as shown below.

This brings up the Alfresco dashboard as shown below.

In this post, we saw how to setup Alfresco Community Edition, an Enterprise Content Management software on an Ubuntu 13.10 machine.

Installing Liferay 6.2 CE with PostgreSQL on Ubuntu

Liferay is a collaboration and online portal. We can download the community edition from the Liferay website (https://www.liferay.com/downloads/liferay-portal/available-releases). I downloaded the version with Tomcat bundled.

Once downloaded, extract the downloaded version to your selected folder. Navigate to the Tomcat /bin folder and execute ./startup.sh command as shown below.

Now open a browser and access the localhost on the port Tomcat is setup on.. This will show the following setup page. First thing to do is to define the Administrator user.

The default database is hypersonic. We would like to change this to PostgreSQL. Click on Change. First thing, I did was created a new user called "sa", who had privileges to create a database.

Next thing was to create a database called lportal with sa as the owner of the database.

Finally, in Liferay, I changed the database to PostgreSQL, and changed the user as "sa" with the password I had created. Default database name is lportal, which I left as is.

This creates the database structure in the lportal database, and we can see the tables populated.

Now, we will be prompted to provide a password for the admin user.

We will also be asked to specify a question and answer for reminding the password.

That's it. We will now be able to configure the sites and pages we want.

We are now ready to work on Liferay, the way we want.