KB

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:

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

Renames all *.thtml files to *.ctp

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:

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:

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

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

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

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

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

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

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:

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

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: