Author: Josh
-
Could not initialize master info structure; more error messages can be found in the MySQL error log
At times I’ve received this message when restarting a mysql slave server: Could not initialize master info structure; more error messages can be found in the MySQL error log This often occurs when changing the hostname of the slave (ie, master failover) and relay-log is not set in the my.cnf. The answer here is to…
-
MySQL – Large Dataset Dump and Restore
When performing a dump and restore of large datasets in MySQL that take multiple days to perform, I typically use the process outlined here. Note that it is critical to connect to the server in question and establish a screen session to perform all commands and operations within. This prevents issues with client connections dropping.…
-
Book Review: Instant Chef Starter, by John Ewart
Instant Chef Starter is an introductory book about Chef, an open-source configuration management and automation platform. John Ewart and Packt Publishing have published a book that will allow a system administrator with no prior Chef experience to get Chef up and running within a day, if not a few hours, by using this guide. If…
-
Upcoming book review: Instant Chef Starter
Packt Publishing has sent me a copy of Instant Chef Starter, by John Ewart to review. I should have this review up within the week. This is a great opportunity as one of the most important tools that any system administrator can learn is configuration management, and Chef is a leader in that space. Chef…
-
Proxy Splunk via Apache
I have had to setup Apache to proxy splunk several times over the past 6 months and keep forgetting the splunk configuration to make this work. Be sure to set the following in /opt/splunk/etc/system/local/web.conf: enableSplunkWebSSL = 0 root_endpoint = /splunk tools.proxy.on = True This assumes a proxy configuration of the following for apache 2.2: ProxyPass…
-
How to completely remove a file from git!
I recently made a mistake and committed an ISO file to git that was 2GB in size. I did not immediately notice this issue and made several local commits without a push to github working properly. I did some research and figured out how to fix this problem. Note that this might not be a…
-
ldapmodify fails with “Server is unwilling to perform (53)”
I recently ran into an issue when setting up a new LDAP directory using OpenLDAP 2.4.23 on Mac OSX. The issue was that I would get the following error when attempting to modify any entry in the directory: modifying entry “olcDatabase={1}bdb,cn=config” ldap_modify: Server is unwilling to perform (53) additional info: shadow context; no update referral…
-
AWS VPC DB Security Group
The other day I was working with a client and creating a CloudFormation template that used RDS instances within a VPC. I found that while creating the DB security group object that I was getting an error like the following: STACK_EVENT CloudFormationName DBSecurityGroupName AWS::RDS::DBSecurityGroup 2012-12-17T22:30:20Z CREATE_FAILED Please see the documentation for authorizing DBSecurityGroup ingress. For…
-
Configure MAC OSX Network Interface from the Command Line
Command line network configuration for the MAC is quite a bit different when compared to Linux or Unix. The networksetup command is used instead of ifconfig to configure devices. The first step is to get a list of all network services – these are really physical and virtual devices, VPNs, etc.. networksetup -listallnetworkservices The next…
-
MAC OSX: Create a new user on the command line.
One common task that any system administrator will perform is to add a new user to a system or application. I recently had a need to add a new user to a MAC server over an SSH connection and found it much more difficult than it should have been. I ended up writing a script…