There are many reasons for this, so first check that MySQL/MariaDB is running properly, that you are using the correct credentials and that the the appropriate user@localhost has access.

Also check you aren't using skip-name-resolve and bind-address in your my.cnf file if accessing from outside of the localhost. These are things you will find with a google search.

Apart from this one other reason why 127.0.0.1 will work and localhost will not work is if you are using something other than the default socket=/var/lib/mysql/mysql.sock location in your my.cnf.

Unfortunately you can't do this the same way as an apache configtest, but there are a few sites out there to validate .htaccess files:

I use this one: htaccesscheck.com

Here's a pretty nice combination of parameters for command line grep using egrep (which supports regex):

egrep -rHnC1 "\bpraj\b" .

This will search in the current directory recursively through all files that match the word "praj" (regex boundary \b tags) and return the file name and context (1 line either side of the match) with line numbers.

For example here's the resut with the matching word highlighted as well on the terminal.

You can add the following to your .vimrc file to force the vim background to match the terminal background (e.g. black):

Here's one method of comparing strings by case in MySQL. You can use the md5 function to hash the string and compare to its lower case value.

This example is for checking for usernames that are not lower case in moodle.

select username, md5(username), md5(lower(username)) from mdl_user where deleted = 0 and suspended = 0 and md5(username) != md5(lower(username));

If you find that your global $_SESSION variable is empty there can be several reasons, here are a few:

The session.save_path is invalid (does not exist) or is not writable.

The session.cookie_secure is set to true but you not using a secure site (SSL/https).

I've had this issue on OSX Mavericks and Yosemite on soapUI 5.x versions. Here's a fix that disables the browser in soapUI which seems to cause it to hang.

Open /Applications/SoapUI-5.2.0.app/Contents/ (adjust to suit your version).

Editvmoptions.txt and add line: -Dsoapui.browser.disabled=true

Open /Applications/SoapUI-5.2.0.app/Contents/java/app/bin (adjust to suit your version)

You can find the session.save_path through php info or using the command line:

php -i | grep save_path

E.g. /var/lib/php/session

Say you have a variable that comprises of another variable like so:

var_name=test var_name_full=$var_name_and_extension

The above won't work as bash will interpret the underscore after $var_name as part of the variable name and look for a variable called $var_name_and_extension and not find it.

Two ways to solve this:

Enclose in curly braces as follows:

var_name=test var_name_full=${var_name}_and_extension

Use double quotes to delineate between the variable name and the string:

The following grep command will search for any constants such as define('CONSTANT', 1) within your PHP code base so you can see their values. Useful as many applications store the constant's value in the database and not the constant's friendly name.

This requires regular expressions, hence the use of egrep.

Found this morning that my Mac Slack client (v1.13, build 2813) kept on crashing on start up (I'm running Mac OSX 10.9 Mavericks). It was working fine until the latest Mac update (Security Update 2015-006 version 1.0 18/08/2015).

The crash reporter tells me something along the lines of this:

Application Specific Information: *** Terminating app due to uncaught exception 'NSInternalInconsistencyException', reason: 'Could not make an sqlite3 statement for: CREATE TABLE IF NOT EXISTS downloads (team TEXT NOT NULL, token TEXT NOT NULL, href TEXT NOT NULL, state TEXT NOT NULL DEFAULT 'pending', http_status TEXT NOT NULL DEFAULT '', file_path TEXT NOT NULL DEFAULT '', file_exists TEXT NOT NULL DEFAULT 'false', mime_type TEXT NOT NULL DEFAULT '', start_ts TEXT NOT NULL DEFAULT '', end_ts TEXT NOT NULL DEFAULT '', base64_png TEXT NOT NULL DEFAULT ''); | ( )' terminating with uncaught exception of type NSException abort() called

Uninstalling/reinstalling didn't fix the issue. I ended up deleting the following folder in my home directory:

~/Library/Containers/com.tinyspeck.slackmacgap

Use the following formula to get the day of the week (e.g. Friday) for the given date field:

=TEXT(WEEKDAY(A1), "DDDD")

Use the str_to_date function and provide the format you need to it. for example, if you have a field called created_dttm with a date which is in the format "24-07-2015 06:00:00" you can use this to convert into a MySQL date so that you use various MySQL date functions on it.

select str_to_date(created_dttm, '%d-%M-%Y %H:%i%s');

Current date/time to Unixtime (to the nearest second, hence the trunc):

select trunc(extract(epoch from now()));

Note this will include your timezone.

Unix time stamp to PostgreSQL timestamp

I have an ASUS AC68U wireless router and lLgitech G930 wireless headset, and I kept finding that my headset with drop out. After some research, I came to the conclusion that I should try changing the wireless control channel on my router.

Neat shortcut to switch apps in the iOS Simulator:

CMD+SHIFT+H+H

Note you need to press H+H fairly quickly. Just

CMD+SHIFT+H

This happens on occassion on the Mac Book Pro - You lose the internal speakers and are only left with digital out. A sign this has occurred is that the red light in the headphone port (where you plug in your headphones) will be on.

There are numerous ways to try to fix this, anything from system preference tweaks all the way to opening up your Mac Book.

Here's the simplest thing you can try (and it does seem to work with a bit of persistence):

Open System Preferences > Sound

Plug in your headphones as you won't have control over the volume/mute of the digital output

Once headphones shows up on the list, move the volume slider up and down and check/uncheck the mute button.

Unplug your headphones

Check if digital out has disppeared and been replaced by Internal Speakers.

Rinse and repeat. Note it can take several attempts before this works. For example, after 3 times, I finally had internal speakers appear for a second then disappear back to digital out. On the fifth attempt, internal speakers appeared again and this time stayed. Basically what you are doing is trying to get the Macbook to recheck its sensors and correctly revert to internal speakers.