KB

[talandis]

httpd port forwarding (OSX 10.10)

The following single command will create the file /Library/LaunchDaemons/co.echo.httpdfwd.plist as root, and owned by root, since it needs elevated privileges.

sudo bash -c 'export TAB=$'"'"'\t'"'"' cat > /Library/LaunchDaemons/co.echo.httpdfwd.plist <<EOF <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> <plist version="1.0"> <dict> ${TAB}<key>Label</key> ${TAB}<string>co.echo.httpdfwd</string> ${TAB}<key>ProgramArguments</key> ${TAB}<array> ${TAB}${TAB}<string>sh</string> ${TAB}${TAB}<string>-c</string> ${TAB}${TAB}<string>ipfw add fwd 127.0.0.1,8080 tcp from any to me dst-port 80 in && sysctl -w net.inet.ip.forwarding=1</string> ${TAB}</array> ${TAB}<key>RunAtLoad</key> ${TAB}<true/> ${TAB}<key>UserName</key> ${TAB}<string>root</string> </dict> </plist> EOF'

This file will be loaded on login and set up the 80->8080 port forward, but we can load it manually now so we don't need to log out and back in.

sudo launchctl load -w /Library/LaunchDaemons/co.echo.httpdfwd.plist

Source: https://echo.co/blog/os-x-109-local-development-environment-apache-php-and-mysql-homebrew

File content for 80 & 443 ports together:

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> <plist version="1.0"> <dict> <key>Label</key> <string>co.echo.httpdfwd</string> <key>ProgramArguments</key> <array> <string>sh</string> <string>-c</string> <string>echo "rdr pass proto tcp from any to any port {80,8080} -> 127.0.0.1 port 8080" | pfctl -a "com.apple/260.HttpFwdFirewall" -Ef - && echo "rdr pass proto tcp from any to any port {443,8443} -> 127.0.0.1 port 8443" | pfctl -a "com.apple/261.HttpFwdFirewall" -Ef - && sysctl -w net.inet.ip.forwarding=1</string> </array> <key>RunAtLoad</key> <true/> <key>UserName</key> <string>root</string> </dict> </plist>

[talandis]

Launching ZF application

1. If you see a blank screen change from mod_php to FCGI

2. If minify doesn't work the URI might be too long. Change suhosin.get.max_value_length

[talandis]

Change file extensions recursively

Renames all *.thtml files to *.ctp

find . -iname "*.thtml" -exec bash -c 'mv "$0" "${0%\.thtml}.ctp"' {} \;

[talandis]

Merge two static libraries with lipo

lipo -create library_armv7.a library_i386.a -output library.a

[talandis]

human readable linux disk usage (du)

alias duf='du -sk * | sort -n | perl -ne '\''($s,$f)=split(m{\t});for (qw(K M G)) {if($s<1024) {printf("%.1f",$s);print "$_\t$f"; last};$s=$s/1024}'\'

[talandis]

mysql import csv / export csv

Export:

SELECT id, name, email INTO OUTFILE '/tmp/result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY ‘\\’ LINES TERMINATED BY '\n' FROM users WHERE 1

Import:

LOAD DATA INFILE '/tmp/result.csv' INTO TABLE users  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' IGNORE 1 LINES LINES TERMINATED BY '\n'

[talandis]

mysql old passwords

If you get similar to this error:

mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the ...

You need to update your mysql user password. You may do that with these two queries:

SET OLD_PASSWORDS = 0; UPDATE `user` SET `password` = PASSWORD('current_password') WHERE `User` = 'your_username'; FLUSH PRIVILEGES; 

[talandis]

Download flv stream

Open http://viastream.viasat.tv/PlayProduct/252697

Find rtmp://video.tv3.lt/tv3/mtg/laidos/450677

Download with RTMPDump

[talandis]

Create custom Facebook page tab

1. Create an app via developer.facebook.com

2. Get app id

3. Go to link: https://www.facebook.com/dialog/pagetab?app_id=APP_ID&display=popup&next=SOME_LINK

4. Select facebook page on which to add the tab

[talandis]

Self-signed OpenSSL certificate

Step1: Generate Private Key:

openssl genrsa -des3 -out private.key 1024

Step2: Generate Certificate Signing Request (CSR):

openssl req -new -key private.key -out request.csr

Step3: Remove key

cp private.key private.key.org openssl rsa -in private.key.org -out private.key

Step4: Generate Certificate

openssl x509 -req -days 365 -in request.csr -signkey private.key -out request.crt

[talandis]

Delete .svn folders on your mac

Sometimes you need to remove hidden subversion folders (.svn) from your project. You may do that with two simple lines:

cd /some/of/your/folders/ rm -rf `find . -type d -name .svn`

[talandis]

Mac OSX HFS Partition Case Sensitivity

If you plan to use Adobe Photoshop, don't use case-sensitive partition. Photoshop won't install on it.

Only one simple solution is available - reformatting..

[talandis]

Mysql stored procedures

While creating stored procedures the following error may occur:

#1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Quickest solution is to execute this query:

SET GLOBAL log_bin_trust_function_creators = on

[talandis]

Internet Explorer sessions and cookies

If one day sessions or cookies stopped working on IE you should check your domain name. It might not your problem but IE's:

Check the name of the server machine. IE has problems with machine names that contain '-' or '_' - they cannot maintain a session

[talandis]

Git SSL (OSX)

when using "git clone" with HTTPS:

error: SSL certificate problem, verify that the CA cert is OK. Details: error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed while accessing https://path_to_repository/repository.git/info/refs

Solution 1:

in terminal: git config --global http.sslVerify false

Solution 2:

in terminal: env GIT_SSL_NO_VERIFY=true git clone https://github...