Scripts « BrakertechBrakertech

Howto make Mongo SSL on Ubuntu 12.04

posted this in Linux, Mongo, Ubuntu on May 3rd, 2013

To make Mongo DB SSL on Ubuntu 12.04 you need to either purchase it or compile from source.

To make compiling from source easy here’s a script to help you out!

Mongo Compile SSL from Source Script

Note: Make sure you are not running an EC2 Small instance or you will run out of space! . . . → Read More: Howto make Mongo SSL on Ubuntu 12.04

passing bash variable to perl command in bash script

posted this in bash, FreeBSD, Linux, O/S, perl, Redhat Centos, Scripts, Server Setup on January 18th, 2013

Recently I tried passing a bash variable to perl command in bash script, it didn’t end well.

Troy Engel from http://tacticalvim.wordpress.com/ was nice enough to point out the issue:

use sed instead of perl for what you need; it’s simpler, faster and uses the bash variables easily.

I set up a test script /home/someuser/test.sh to show:

php mysql update variable

posted this in Admin, MYSQL, php, Wordpress on December 4th, 2012

Goal: Update wordpress post with PHP cli

< ?php

$con = mysql_connect("localhost","root","[redacted]");
if (!$con)
  {
 echo "Unable to connect to DB: " . mysql_error();
    exit;
  }
 if (!mysql_select_db("wordpress")) {
    echo "Unable to select mydbname: " . mysql_error();
    exit;
  }
$myfileText = mysql_real_escape_string(file_get_contents('./code_for_wordpress.html',true));

$sql = "UPDATE `[your_instance_prefix]_posts` SET `post_content` = '$myfileText' WHERE `ID` like '1397';";
$result = mysql_query($sql);
 if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
  }

mysql_close($con);
?>

< ?php

$con = mysql_connect("localhost","root","[redacted]");

if (!$con)

{

echo "Unable to connect to DB: " . mysql_error();

exit;

}

if (!mysql_select_db("wordpress")) {

echo "Unable to select mydbname: " . mysql_error();

exit;

}

$myfileText = mysql_real_escape_string(file_get_contents('./code_for_wordpress.html',true));

$sql = "UPDATE `[your_instance_prefix]_posts` SET `post_content` = '$myfileText' WHERE `ID` like '1397';";

$result = mysql_query($sql);

if (!$result) {

echo "Could not successfully run query ($sql) from DB: " . mysql_error();

exit;

}

mysql_close($con);

sed delete all lines after

posted this in Apache, bash, Linux, Redhat Centos on October 26th, 2012

Objective: Prep dev httpd.conf for production

Tasks:

Remove jenkins virtual host entry (which starts with a comment line “#Start Jenkins”) Replace .dev with nothing (ex: www.dev.example.com becomes www.example.com) Replace debug with error (ex: Loglevel debug becomes Loglevel error) Sed to remove lines after match

In this example we will use sed delete all lines after . . . → Read More: sed delete all lines after

mysql insert cdn sync tool

posted this in MYSQL on September 19th, 2012

To manually update the CDN Sync Tool table (for wordpress plugin CDN Sync Tool) try this MySQL Insert Statement:

Replace the id with the latest id on your table

Manually insert row to cdn sync table
INSERT INTO `wordpressdb`.`prefix_cst_new_files`
(`id`,
`file_dir`,
`remote_path`,
`changedate`,
`synced`)
VALUES
(1567,'/full/path/to/file/filename.txt','filename.txt','1345062888','1');

Manually insert row to cdn sync table

INSERT INTO `wordpressdb`.`prefix_cst_new_files`

(`id`,

`file_dir`,

`remote_path`,

`changedate`,

`synced`)

VALUES

(1567,'/full/path/to/file/filename.txt','filename.txt','1345062888','1');

To confirm your work:

SELECT * FROM `wordpressdb`.`prefix_cst_new_files` where remote_path LIKE `%.txt`;

1	SELECT * FROM `wordpressdb`.`prefix_cst_new_files` where remote_path LIKE `%.txt`;

redhat add multiple users

posted this in bash, Linux, Redhat Centos, Ubuntu on September 13th, 2012

useradd script

to add multiple users to a system and force them to change their password upon login try the following script:

Redhat

# for name in someuser anotheruser yetanotheruser; do useradd $name; echo 'password' | passwd --stdin $name; chage -d 0 $name; done

1	# for name in someuser anotheruser yetanotheruser; do useradd $name; echo 'password' \| passwd --stdin $name; chage -d 0 $name; done

The above script will add three users to the system (someuser anotheruser yetanotheruser) with the password “password” and set the password age to zero. This forces them to change their password . . . → Read More: redhat add multiple users

linux unwrap text file

posted this in Linux, perl, Redhat Centos, Ubuntu on September 13th, 2012

I spent forever trying to figure out how to unwrap an apache access_log that was splitting requests between two lines. I finally found the answer!

Create a perl script called unwrap.pl and run the script like this:

# perl unwrap.pl access_log > accesslog2

1	# perl unwrap.pl access_log > accesslog2

#!/bin/env perl

use strict;

my $sentinel = 0;
my $previous_line;
my $result = "";

sub early_indent { # line next_line
    my $line = shift(@_);
    my $next_line = shift(@_);

    my @words = split(' ', $next_line);
    return (length ($line . " " . $words[0]) < length($next_line));
}

while (<>)
{
    my $this_line = $_;
    chomp $this_line;
    if ($sentinel)
    {
	if (($this_line eq "")
	    || ($previous_line eq "")
	    || ($this_line =~ /^[^A-Za-z0-9]/)
	    || early_indent($previous_line, $this_line))
	{ $result .= $previous_line . "\n"; }
	else {$result .= ($previous_line . " "); }
    }
    $previous_line = $this_line;
    $sentinel = 1;
}

#!/bin/env perl

use strict;

my $sentinel = 0;

my $previous_line;

my $result = "";

sub early_indent { # line next_line

my $line = shift(@_);

my $next_line = shift(@_);

my @words = split(' ', $next_line);

return (length ($line . " " . $words[0]) < length($next_line));

}

while (<>)

{

my $this_line = $_;

chomp $this_line;

if ($sentinel)

{

if (($this_line eq "")

|| ($previous_line eq "")

|| ($this_line =~ /^[^A-Za-z0-9]/)

|| early_indent($previous_line, $this_line))

{ $result .= $previous_line . "\n"; }

else {$result .= ($previous_line . " "); }

}

$previous_line = $this_line;

$sentinel = 1;

}

Bash Server Backup Script

posted this in bash, Linux, Redhat Centos, Scripts, Server Setup, Ubuntu on July 13th, 2012

I’ve created a Bash Server Backup Script that will backup your MySQL databases (each database separately in to .sql and .xml files) and your main directories (/var/log, /var/www/html, /etc, /home, /root) to a timestamped directory. Feel free to re-use or hack up however you’d like

Here’s my Bash Server Backup Script: Download the script here . . . → Read More: Bash Server Backup Script

Reset mysql root password

posted this in MSSQL on June 27th, 2012

To reset the mysql root password follow these steps 1. Stop running mysql instances

# service mysqld stop

1	# service mysqld stop

1a. If that doesn’t work then kill all running mysql instances

# pkill mysql

1	# pkill mysql

1. Stop running mysql instances

# service mysqld stop

1	# service mysqld stop

2. Start Mysql in safe mode

# mysqld_safe --skip-grant-tables

1	# mysqld_safe --skip-grant-tables

3. Run these command replacing somepassword with your new password

mysql> update mysql.user set Password=PASSWORD('somepassword') where user='root';
mysql> flush privileges;
mysql> exit;

mysql> update mysql.user set Password=PASSWORD('somepassword') where user='root';

mysql> flush privileges;

mysql> exit;

4. Start mysqld again . . . → Read More: Reset mysql root password

multiple reverse proxy host broken

posted this in Apache, c#, IIS on April 13th, 2012

Nathan Bridgewater explained how to configure multiple reverse proxies properly with apache and IIS (without losing original domain name). I’m reposting this for myself to keep a record of this fine work.

multiple reverse proxy host broken iis serving up local server name instead of the ServerName that was originally passed to it. How to . . . → Read More: multiple reverse proxy host broken

Brakertech

Howto make Mongo SSL on Ubuntu 12.04

passing bash variable to perl command in bash script

php mysql update variable

sed delete all lines after

mysql insert cdn sync tool

redhat add multiple users

linux unwrap text file

Bash Server Backup Script

Reset mysql root password

multiple reverse proxy host broken

Search Brakertech

Scripts Scripts

dEFENSE

Hacking

Security

Search Brakertech

Scripts Scripts

dEFENSE

Hacking

Tags

Security