Author: Kevin Clymans

Set application environment variables with systemd

2017-11-08Kevin Clymans

Using systemd it's rather simple to set specific environment variables for a specific application. In this example ill set a http(s) and noproxy settings for docker. First we create systemd drop-in directory for the docker service: sudo mkdir /etc/systemd/system/docker.service.d Add file called /etc/systemd/system/docker.service.d/http-proxy.conf that includes the HTTP_PROXY environment variable: [Service] Environment="HTTP_PROXY=http://proxy.internal:3128/" Environment="HTTPS_PROXY=http://proxy.internal:3128/" Environment="NO_PROXY=localhost,127.0.0.1/8" Reload the daemon $ su...

sql developer substitution variable

2017-08-172017-08-17Kevin Clymans

To disable those pesky "Enter Substitution Variable" dialog boxes, run "set define off;" before the query

SAP ASE storage migration

2017-07-152017-07-06Kevin Clymans

A storage migration can cause a major outage on your database which is never a good idea. If your ASE system is using RAW devices we can reduce our outage by using the mirror command. (more…)

Selenium python bindings on Centos 7

2017-07-052017-07-05Kevin Clymans

Selenium is a web testing toolkit that allows you to test a web site in a browser of your choice. In this post I'm going to explain how to setup Selenium with Firefox and PhantomJS on a RHEL / Centos 7. We start off by installing pip which in turn installs selenium. (more…)

Invalid RSI Locater

2017-03-122017-03-10Kevin Clymans

If the RSI locaters at the primary and replicate Replication Servers are not identical, then the primary Replication Server might delete messages from its stable queue at an incorrect location and invalidate the RSI locater at the replicate Replication Server. RSI locaters must be identical. If they are not identical you need to reset the correct entry in the rs_locater system table in the Replication Server System Database (RSSD) (more…)

Starting ASE after a system kill

2017-03-10Kevin Clymans

Killing ASE with a SIGKILL is obviously not a good idea but you can run out of other options. Data-loss can and will happen because no checkpoint will be given to the database. Should it unavoidable you need to check some actions before starting such as the shared memory segments and files. The shared memory files are located under the $SYBASE/$SYBASE_ASE directory with the SERVER_NAME.krg file name. The sybase process should be able to read and write in this file. Shared memory segments also need to be cleaned up. These can be identified with ipcs | grep sybase and ipcrm -M <KEY&gt...

Manage Oracle ALOM from Solaris

2016-11-29Kevin Clymans

Solaris ships with a System Controller Administration (scadm) utility. This allows you to manage the alom card from inside the os. Always useful for cards that are stuck or forgotten passwords. (more…)

Mysql: Innodb architecture

2016-09-222016-09-22Kevin Clymans

This schema gives a nice overview of the InnoDB architecture used by Mysql, MariaDb and Percona. I keep this near when I am running performance tweaks on my databases. The flows and bottle necks are much more clear when you have a visual overview of the architecture.

Satellite 6: Sync Katello repos with Pulp repos

2016-09-06Kevin Clymans

When you skip,unlock or delete a task in katello that caused a repository to be deleted or not created in pulp we get various strange behavior between the 2 sub systems of satellite 6. This mostly comes up when you are upgrading to a later version and is very difficult to debug. Mostly this shows a 404 Resource Not Found. (more…)

SteamOS

2016-07-312016-07-23Kevin Clymans

Ever since the start I have been a huge fan of SteamOS and I have been running Alchemist since the closed BETA. The fact that I can stream games from my Desktop to my TV is a major plus for me in games like Pro Evolution Soccer. Certain games such as the Witcher can run natively on my SteamOS. (more…)