itsecureadmin.com

Author: Josh

  • AWS Adds Object Expiration to S3!

    —

    by

    Josh
    in

    This is great news! One of the headaches of managing any file/object store is pruning old data, although that is something we’ve all dealt with for years with standard filesystems and storage devices, this makes working in the cloud easier. It’s applied by policy to a bucket (without versioning enabled). Check it out in the…

  • Enabling the binary log on a MySQL Replication Master

    —

    by

    Josh
    in

    A common task when working with MySQL is to enable binary logging which will allow you to add read only slaves (often a good idea even if you aren’t adding the replication slaves now). According to the official MySQL documentation, there are only 3 steps required to enable binary logging: assign a unique server-id to…

  • List MySQL Table Space Consumption

    —

    by

    Josh
    in , ,

    How much space is MySQL consuming? How do I find out which MySQL tables are the largest? Can I query MySQL to determine how much space it’s consuming? Try this to list the top 20 space offenders: SELECT engine, concat( table_schema, ‘.’, table_name ) table_name, concat( round( data_length / ( 1024 *1024 ) , 2…

  • Open Source Software Support

    —

    by

    Josh
    in

    I am once again consulting. If you have any needs related to open source software, let me know! linux (at) itsecureadmin (dot) com I specialize in Linux authentication and access control, OpenLDAP directory management, configuration management, and monitoring. ITSA Consulting, LLC.

  • Encrypted Volume Management

    —

    by

    Josh
    in

    A few weeks ago, I posted about how to add a pass-phrase to a LUKS encrypted volume. After filling the 8 available slots, that would no longer be an option and you would need to remove some old pass-phrases or update existing slots to add new pass-phrases. To list the slots, use the luksDump command:…

  • Domain Auto-Enrollment / Hostname Management with Powershell (v2)

    —

    by

    Josh
    in ,

    I am realizing now that I need to get a git repo setup that is publicly accessible which will allow me to share scripts and other code snippets that I’m working on. Here is the second iteration of the powershell domain/hostname management script that I’m working on. It will also update the SQL Server dbname…

  • Update ssh private key pass phrase.

    —

    by

    Josh
    in

    I like to keep certain pass words in sync with one another as I perform gigs for various clients and adhere to pass word policies for each company. As part of the password update, I typically need to update my SSH key pass phrase using the following command: $ ssh-keygen -f ~/.ssh/id_rsa -p Note that…

  • Domain Auto-Enrollment / Hostname Management with Powershell

    —

    by

    Josh
    in

    I am working on a project where I spin up a number of Windows servers into AWS and had to automate the AD enrollment and hostname setting. To do this, I used the following powershell script which I setup as a scheduled task to run at startup and then create an AMI and/or template from…

  • Fedora 15 Automatic Updates

    —

    by

    Josh
    in

    Now why would a Linux distribution have automatic updates? They don’t. They never have. They allow the user to maintain software updates without intervention. Automation is performed by the administrator and that’s why most folks use Linux. Not any more. I was tailing the system log on my Fedora 15 desktop yesterday when I see…

  • Jenkins Slave Authentication

    —

    by

    Josh
    in

    Note that the following applies to a Windows Slave connecting to a Linux master. When implementing authentication with Jenkins and using slaves, it is important to allow slaves to authenticate to the master in order to continue working. When using the JNLP protocol with slaves, the following may be done to authenticate slaves to the…