This document explains how to populate a MySQL database within OpenShift. In this example we have an application with three gears; HAProxy, PHP and MySQL. We have RHC configured. We have the SQL dump file available via http but it could be by ftp or ssh. First we connect to
Read moreGet help with Linux, Automation, Cybersecurity and more. AGIX staff have the know-how and experience to help your organisation with best-practices, current technology in various Cloud environments including Amazon AWS. Our technicians support Ubuntu, Redhat, Databases, Firewalls, Ansible and Terraform, Storage and more.
This page shows examples of our work that AGIX shares freely with you. For a fully supported compute environment, contact our team to find out how we can help your organization move forward in the right way.
Contact our friendly team to get started.
Install Memcached on OpenShift
Because gears don’t share memory, the only way to handle sessions in a scalable application is to use a database. Or, you can use memcached which is simple enough to do but it will consume another gear in a scalable application. Using the “rhc” command, we can add the memcahced
Read moreNasty .DS_Store Files Linux
This is a simple one liner to remove all .DS_Store files that maybe sitting on your Linux box. There are many reasons that you might want to do this but the one that prompted me was this output from an OpenVAS report. MacOS X creates a hidden file, ‘.DS_Store’ in
Read moreWorking with OpenShift on the CLI (Users and Admin)
This article demonstrates how to add applications, gears and cartridges to your OpenShift account using the command line tool. It’s from the point of view of both the OpenShift subscriber and the administrator. I’m sure those who are new to OpenShift will find this useful. Some Definitions Applications: An application
Read moreGet the size of MySQL databases
This is a one-liner that will show you the size of your MySQL databases. This works for RDS MySQL databases. Having logged into your MySQL server as the root user: SELECT table_schema “Database Name”, sum( data_length + index_length ) / 1024 / 1024 “Database Size in MB” FROM information_schema.TABLES GROUP
Read moreInstall OpenShift Origin on CentOS 6.4
This article describes how to install OpenShift Origin (the community version) on a Redhat or CentOS 6.4 server. We’re doing this as a test on an AWS EC2 CentOS 6.4 (With Updates) and a machine type of “m3.medium”. Do this on a fresh system, not one that has real previous
Read moreReset a lost MySQL Password on CentOS and Redhat Linux
Use these instructions to reset a lost MySQL root password. I’ve taken these steps from the website “http://www.rackspace.com/knowledge_center/article/mysql-resetting-a-lost-mysql-root-password”. All credit to them. Note that this is done as the ‘root’ user. First stop MySQL and start it in ‘safe mode’: service mysqld stop mysqld_safe –skip-grant-tables & Now login without the
Read moreApache proxy to Tomcat on CentOS/Redhat
This article discusses how to use Apache web server as a proxy (reverse proxy) to a Tomcat server. Apache is often used as a proxy to Tomcat. This allows the server to host a website that needs a traditional site (html, php, etc) as well as some java served by
Read moreSee your YUM history
Yum has the ability to show you the yum activity of the past. For example, if you want to know when you (or someone) ran a YUM command on a given system, you can. To get an overview, issue the following command yum history You’ll get something like this: [[email protected]:
Read moreGit with OpenShift for SysAdmins
This article is a short overview of how to use Git for Linux system administrators particularly when using OpenShift. When you create your OpenShift application, OpenShift will present you with the Git location you must use for uploading and downloading the web-application code. Updates to the web application code in
Read more