Posts By: jonny

Laravel Quick Start

Quick reminder of steps to setup a Laravel project on Ubuntu/Linux Mint and similar. First install composer:

Install PHP dependencies:

  Use composer to create your Laravel project:

Install composer.json packages:

Generate a key for your new project into the .env file:

Amend the .env file with database details and anything else you want to customise. You may want to install mysql with

Auth Scaffolding Create the login and… Read more »

Resetting Root Password in Single User Mode

Using Red Hat  / CentOS etc one method of resetting the root user password is to boot into single user mode. To do so, interrupt the booting process if necessary so that you see the Grub boot menu: Press the ‘e‘ keyboard button to edit the boot parameters. You will see a menu with the… Read more »

Password-less Login to the MySQL Command Line

The goal here was to be able to log in to the MySQL command prompt be simply typing

rather than:

This is particularly useful for automation of routine backups etc. mysql_config_editor The command mysql_config_editor has several options (e.g. add, remove, print) for managing encrypted passwords. To create a new login

It is… Read more »

Connecting in to Docker MySQL Instance

Just recording a few of these steps for future reference. Pull the MySQL image from the hub:

Run an instance:

Run a shell on the instance:

Once inside the instance use the MySQL client:

and create a new user:

Quit the MySQL client and exit the instance. From the host… Read more »

Gitlab Bulk Update can_create_group

I had been allowing normal users to create groups within Gitlab but subsequently discovered some confusion among users between groups and projects. Some users had been creating a group with a single project when a project with multiple members was more suitable. A decided to update the Gitlab CE database to amend the users table… Read more »

sssd ldap: No Group Members shown

Openldap group

With several machines configured to use OpenLdap for user and group authentication/permissions I was having the problem that the getent and id commands were not returning all the group information. My groups exist in the Ldap directory with members listed under ‘memberuid’ but when entering:

I was getting:

when I should have been… Read more »

Minecraft Overviewer

Minecraft Overviewer

Just some instructions to remind myself how I got the Minecraft Overviewer working on CentOS.

Now create a config file to tell Overviewer where the assets (texture images etc) are:

Then run Overviewer telling it the location of your config file:

After some time the overviewer map should be created. The… Read more »

Gitlab API Command Line Access

There appears to be a few methods for managing a Gitlab installation from the command line. I liked python-gitlab and I installed it onto Linux Mint/Ubuntu as follows:

After installation I created a config file:

With the content as below but the private_token would need changed for your own server:

The python-gitlab… Read more »

Restoring a Gitlab Bundle

I had an odd request today from a guy who had deleted his GitLab project and his local repos. I had been making backups using:

and sifting through the backups under /var/opt/gitlab/backups/  I extracted the latest tar and under the ./repositories/username directory found some .bundle files for each of his projects. After some piddling about… Read more »

PhidgetBoard with Raspberry Pi and Tripwire

I very luckily got landed with a: Phidgets Board 8/8/8 (1018) Lanbao PR18S-TM10DNO Photoelectric Tripwire Sensor (3525) I wired the Tripwire sensor to the Phidget board as described in the wiring diagram and as shown in the video: I connected the USB cable from the Phidgets Board to the USB port on a Raspberry Pi… Read more »