03

Sep

2014

MySQL: Give a User Grant Permissions

September 3, 2014 jonny mysql

I needed to create a new MySQL user that would be able to create new users itself and grant permissions to the accounts that it creates. To do so I used the following: GRANT ALL PRIVILEGES ON *.* TO 'subadmin'@'%' WITH GRANT OPTION;    

21

Aug

2014

Extracting font information from PDF files

August 21, 2014 jonny Gnu Free Software, open source

Today I was sent a PDF file leaflet with info to add to McIvor Farrell Belfast Solicitors website and I wanted to know the fonts used by the graphic designer. I first tried Online Font Converter and that did tell me one of the fonts used.  Online Font... » More

17

Aug

2014

Linux Mint 64-bit and Steam

August 17, 2014 jonny ubuntu

I had the following error message on Linux Mint when trying to play a new game: This application requires either the GL_EXT_texture_compression_s3tc, or the GL_EXT_texture_compression_dxt1 + GL_ANGLE_texture_compression_dxt3 +... » More

05

Aug

2014

Linux GPS Logging Data

August 5, 2014 jonny linux, open source, swimming

I took part in a swim this weekend - The Battle of Carlingford Lough. My friend Cormac gave his Panasonic Lumix camera to Mary in the kayak and set the camera to log GPS data. He sent me the GPS log file and I opened the log file with BT747 - a Java... » More

15

Jul

2014

1and1 Overcharging for Backups

July 15, 2014 jonny rants

So back in November 2013 1and 1 contacted me to tell me they would be physically moving my server from one data centre to another: In the email on the 3rd November they advised signing up for 1and1 Professional Backup. They advised that the backup... » More

19

Jun

2014

Browsing the GitLab Omnibus Postgres Database

June 19, 2014 jonny red hat centos

After installing GitLab Omnibus edition I wanted to take a look at the database tables. To do so I installed phpPgAdmin (available in the EPEL repo): yum install phpPgAdmin I created a user in Postgres for use with phpPgAdmin: su -... » More

10

Jun

2014

Restricting SSH Logins to LDAP Group

June 10, 2014 jonny open source, red hat centos

The are multiple methods of doing this including using pam but I settled for the following: In the /etc/ssh/sshd_config file I currently have: AuthorizedKeysCommand /usr/libexec/openssh/ssh-ldap-wrapper AuthorizedKeysCommandRunAs nobody to check... » More

04

Jun

2014

Installing Darkstat on CentOS 6

June 4, 2014 jonny network, open source

The darkstat software is available in the rpmforge repository so you will need to install RPMforge first: rpm -Uvh http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm Then install Darkstat with: yum... » More

04

Jun

2014

pam_exec.so Execute Commands on User Login

June 4, 2014 jonny linux, red hat centos

In addition to the normal pam_mkhomedir.so I wanted to create a directory for each user on an alternative disk. To do so I edited: vi /etc/pam.d/password-auth added the line below (just above the line: session optional... » More

28

Apr

2014

Gitlab Omnibus – Change the Nginx Port

April 28, 2014 jonny open source

Ignore original text below. The correct method is to amend the /etc/gitlab/gitlab.rb file with the port e.g.: external_url "https://gitlab.domain.co.uk:8443" nginx = "/etc/pki/tls/certs/pubkey.pem" nginx = "/etc/pki/tls/private/privkey.pem" Then... » More