mental issues

Apache+php+mysql on Mac OS

2013-03-16T16:02:00.000-07:00

All process could be easely found in the web. For example read this http://jason.pureconcepts.net/2012/10/install-apache-php-mysql-mac-os-x/ or this http://coolestguyplanettech.com/downtown/install-and-configure-apache-mysql-php-and-phpmyadmin-osx-108-mountain-lion

What else you may need todo:

1. edit User and Group in /private/etc/apache2/httpd.conf or you could get some strange permission errors. find in you httpd.conf and change to this:

User username

Group #-1

2. Edit you /private/etc/php.ini ... I just copied my old one :)

python .isalpha() for utf-8

2013-01-14T14:39:00.004-08:00

>>> s='ахалаймахалай'
>>> s.isalpha()
False
>>> unicode(s.decode('utf-8')).isalpha()
True

Yii Tips: Add user role to accessRules() in controller

2012-10-21T06:52:00.001-07:00

By default there is no such thing as 'role'.

To add role to accessRules() in controller you could use expressions... smth like this: 'expression' => function(){return Yii::app()->user->getState("role") == 'admin';}

My accessRules():
public function accessRules()
{
return array(
array('allow', // allow all users to perform 'index' and 'view' actions
'actions'=>array('index','view'),
'users'=>array('*'),
),
array('allow', // allow authenticated user to perform 'create' and 'update' actions
'actions'=>array('create','update'),
'users'=>array('@'),
),
array('allow', // allow admin user to perform 'admin' and 'delete' actions
'actions'=>array('admin','delete'),
//Check if user role is admin
'expression' => function(){return Yii::app()->user->getState("role") == 'admin';},
),
array('deny', // deny all users
'users'=>array('*'),
),
);

BTW, you need to set state for user's role in userIdentity component in authenticate.. like this $this->setState('role', $user->role);
My authenticate() in userIdentity.php:
public function authenticate()
{
$user = User::model()->findByAttributes(array('email'=>$this->username));

if ($user===null) { // No user found!
$this->errorCode=self::ERROR_USERNAME_INVALID;
} else if ($user->password !== md5($this->password) ) { // Invalid password!
$this->errorCode=self::ERROR_PASSWORD_INVALID;
} else { // Okay!
$this->errorCode=self::ERROR_NONE;
$this->setState('email', $user->email);
$this->setState('username', $user->username);
// Store the role in a session:
$this->setState('role', $user->role);
$this->_id = $user->id;
}
return !$this->errorCode;
}

My Vim Cheat Sheet

2012-10-20T14:17:00.001-07:00

COMMAND mode:

:ci( - replace text between brackets

:ci" - replace text between quotes

ctrl+g - see where you are

g ctrl+g - advanced where you are

`. - jum to location of last modification

dtx - deletes upto and including the next x

dftx - deletes downto the previous x

:%s/TEXT//ng - count the number of matches

:e - reload current file (similar to :edit)

:set ft=html - change filetype (for example, to indent html inside php file)

Splited views (also helpfull with NERDTree plugin):

ctrl+ww - toogle between splited views

ctrl+wv - split vertical

ctrl+wh - split horizontal

INSERT mode:

ctrl+t - insert indent to current line

ctrl+d - delet indent to current line

ctr+y - insert chars frome above line

ctrl+e - insert chars frome below line

ctrl+x xtrl+o - omni autocomplete(ctrl+n, ctrl+p to move next/previos line in omni autocomplete)

VISUAL mode:

ctrl+v - enter VISUAL BLOCK selection mode

Adding smth to multipple lines: select VISUAL BLOCK, press "I" (capital i) type smth you want to add (it appears only in first line which were selected), hit "ESC"... tadam chars you've entered added to every line which been previously selected. BTW: instead of "I" you could type "c" - it will cut selected blocks and qfter that you could type anything you want (also helpfull to uncomment block of code)

...to be continued

Other stuff:

:cd %:p:h '  - will change the working directory to the dir for current editing file

J - will join that line and the next line together (shift+j)

Mac OS terminal/iterm tips (autocomplete, ignore case etc.)

2012-10-19T14:29:00.004-07:00

add this to your ~/.inputrc:

#Pressing alt+left/right arrow force cursor to jump 1 word left/right

"\e[1;9D": backward-word
"\e[1;9C": forward-word

#this will print all ambiguous variant if you presse TAB

set show-all-if-ambiguous ON

#ignore case in files/folders names in terminal
set completion-ignore-case on
#tab cycles through completion

TAB: menu-complete

#shift+TAB to show all ambiguous variant
"\e[Z": complete

Install rockmongo in MAMP in mac os X

2012-10-15T15:52:00.003-07:00

You should have mongodb installed and running on standart port. mamp instaled.
Turn off MAMP (if it's running)
Download sources from https://github.com/mongodb/mongo-php-driver to /Users/your_username/Temp/
Just do like written here in Installation section: https://github.com/mongodb/mongo-php-driver
phpize
./configure
make
sudo make 

after that you will have mongo.so and mongo.la somewhere 
in /Users/your_username/Temp/mongodb-mongo-php-driver-622828c/modules/

Then copy mongo.so and mongo.la to your MAMP (path should be smth like this):
/Applications/MAMP/bin/php/php5.3.6/lib/php/extensions/no-debug-non-zts-20090626/

Edit your php.ini, it will be somwhere here: 
/Applications/MAMP/bin/php/php5.3.6/conf). Add this line to it's extension section:
extension=mongo.so

Turn on MAMP
Check phpinfo at http://localhost/MAMP/ (search for 'mongo')
Go to rockmongo http://localhost/rockmongo
Thanks to: 
http://www.joyceleong.com/log/mongodb-with-mamp-on-os-x/
https://github.com/mongodb/mongo-php-driver

Writing An Hadoop MapReduce Program In Python

2012-10-14T10:29:00.001-07:00

Great article: Writing An Hadoop MapReduce Program In Python

My bash history (replace "const" with your username):
  543  cd /usr/local/Cellar/hadoop/1.0.3/libexec
  544  hadoop dfs -copyFromLocal /Users/const/Dev/PrjGit/mrpy/tmp/ /user/const/mrpy
  545  hadoop dfs -la
  546  hadoop dfs -ls
  547  hadoop dfs -ls /user/const/mrpy/
  550  jar /usr/local/Cellar/hadoop/1.0.3/libexec/contrib/streaming/hadoop-*streaming*.jar -file /Users/const/Dev/PrjGit/mrpy/mapper.py -mapper /Users/const/Dev/PrjGit/mrpy/mapper.py -file /Users/const/Dev/PrjGit/mrpy/reducer.py -reducer /Users/const/Dev/PrjGit/mrpy/reducer.py -input /user/const/mrpy/* -output /user/const/mrpy-output
  551  hadoop dfs -ls /user/const/mrpy-output
  552  hadoop dfs -cat /user/const/mrpy-output/part-00000

Automator script: open chosen/selected folder in iTerm terminal

2012-10-09T07:31:00.002-07:00

Here is the AppleScript:
on run {input, parameters}
   tell application "iTerm"
   activate
      repeat with someFilename in input
         make new terminal
         tell the first terminal
            activate current session
            launch session "Default Session"
            tell the last session
               set thePath to (quoted form of POSIX path of ¬
                  (someFilename as string))
               set cdCommand to "if [ -d " & thePath & " ]; then cd " ¬ 
                  & thePath & "; else cd `dirname " & thePath & ¬ 
                  "`; fi; clear"
               write text cdCommand
            end tell
         end tell
      end repeat
   end tell
   return input
end run

Iterm2 how to setup word jumpig using alt+left alt+right arrow

2012-10-06T15:01:00.001-07:00

In Preferences->Profiles->Keys:

find "option ←" and edit its "action" like this: select "send escape sequence" and in the "escape sequence box" enter "b"

find "option →" and edit its "action" like this: select "send escape sequence" and in the "escape sequence box" enter "f"

Add this to your ~/.inputrc:
#Pressing alt+left/right arrow force cursor to jump 1 word left/right
"\e[1;9D": backward-word
"\e[1;9C": forward-word

Python MySQLdb with MAMP

2012-03-16T14:57:00.004-07:00

U need xCode, mySQL instaled and MySQL-python-1.2.3
Also you need MAMP instaled.

in MySQL-python-1.2.3 folder in site.cfg file add mysql_config path:
# The path to mysql_config.
# Only use this if mysql_config is not on your PATH, or you have some weird
# setup that requires it.
mysql_config = /Applications/MAMP/Library/bin/mysql_config

in terminal in MySQL-python-1.2.3 folder do this:
$ sudo python setup.py clean
$ sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql
$ sudo python setup.py build
$ sudo python setup.py install

If you got error "Reason: image not found" try this:
sudo cp /usr/local/mysql/lib/libmysqlclient_r.18.dylib /usr/local/mysql/lib/mysql/libmysqlclient_r.18.dylib

or this:

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/

in your python script use unix_socket = path_to_MAMP_socket:
#!/usr/bin/python
import sys
import MySQLdb
import MySQLdb.cursors
db= MySQLdb.connect(unix_socket = '/Applications/MAMP/tmp/mysql/mysql.sock', host="localhost", port=3306 ,user="username", passwd="password",db="database")

related links:
http://paikialog.wordpress.com/2011/05/02/mac-install-python-mysqldb-to-mamp/
http://www.mangoorange.com/2008/08/01/installing-python-mysqldb-122-on-mac-os-x/

Recursively delete .svn directories

2012-03-03T08:01:00.002-08:00

rm -rf `find . -type d -name .svn`

Fixing the “unix:///var/mysql/mysql.sock” not found error on MAMP

2012-03-03T07:44:00.000-08:00

If you've got this problem on mac (with MAMP):
PHP Error[2]: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock)

Try this:
sudo mkdir /var/mysql
sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /var/mysql/mysql.sock

PySide in Eclipse generates false errors

2011-08-17T16:49:00.000-07:00

PyDev starts generating false errors for my code after installing PySide.

To fix this problem follow this steps:
1. In Eclipse open Window -> Preferences -> Pydev -> Interpreter - Python
2. Add C:\Python27\Lib\site-packages to SystemPYTHONPATH (if you already have it... remove this line and add it again)

Installing Eclipse IDE for C++ and QT with MinGW on Windows

2011-08-17T13:40:00.000-07:00

Follow next steps to install Eclipse IDE for C++ and QT with MinGQ on Windows:
1. Instal MinGW (with MSYS) http://sourceforge.net/projects/mingw/files/
2. Install gdb-6.3-2.exe http://citylan.dl.sourceforge.net/project/mingw/MinGW/BaseSystem/GDB/Release%20Candidate_%20gdb-6.3/gdb-6.3-2.exe
3. Add path to MinGW and MSYS folder (for me it's C:\MinGW\bin;C:\MinGW\msys\1.0\bin;) to system variable (PATH)
4. Install QT (qt-win-opensource-4.6.4-mingw.exe) http://get.qt.nokia.com/qt/source/qt-win-opensource-4.6.4-mingw.exe
5. Install Eclipse IDE for C/C++ Developers (includes Incubating components), http://www.eclipse.org/downloads/ - just download and unzip it. INSTALL 32-bit version (and of course you need JRE 32-bit version ...for example this one jre-6u27-windows-i586.exe from here http://www.oracle.com/technetwork/java/javase/downloads/jre-6u27-download-440425.html
6. install QT Eclipse integration http://get.qt.nokia.com/qteclipse/qt-eclipse-integration-win32-1.6.1.exe
7. Reboot and then Run Eclipse
8. In eclipse Preferense->Qt press "Add new Qt version"... and add path to your ...\qt\4.4.1\bin folder

multiple virtualhost in wampserver2

2011-05-26T16:10:00.001-07:00

1. add this line to c:\windows\system32\drivers\etc\hosts
127.0.0.1 mysite.com

2. add this block to httpd.conf file:

NameVirtualHost 127.0.0.1
<virtualhost 127.0.0.1>
ServerName localhost
DocumentRoot "C:/wamp/www"
</VirtualHost>

<virtualhost 127.0.0.1>
ServerName mysite.com
DocumentRoot "C:\wamp\www\share\www"
</VirtualHost>

fo MAMP users, just add this

ServerName devshara
DocumentRoot "/Users/const/Dev/svn/sharamba/development/www"

Light Explorer in Notepad++

2011-05-21T15:11:00.000-07:00

Light Explorer in Notepad++ "allows documents to be opened from a dockable file explorer, that is very light weight and fast. Author: Javier Sanjose"

PHP: Netbeans block comment (like /* comment */)

2011-05-15T06:35:00.000-07:00

To comment multiple lines in Netbeans (like this /* comment */) you need to create macros

Tools -> Options -> Editor -> Macros -> New
The code of macros is:
cut-to-clipboard "/*" paste-from-clipboard "*/"

and Set shortcut to Ctrl+Shift+Q.

Python: how to remove duplicates from list

2011-04-26T13:40:00.000-07:00

# -*- coding: utf-8 -*-
qi=[1,1,3,1,6,4,5,1,6] #some elements repeat
qi.sort() #sort urls (just for fun)
qi_normal=set(qi) #this removes duplicate URL's
print "list wit repeated elemnts:", qi
print "list without repeted ellemnts:",qi_normal

Python: How to remove \n (end of line) symbol

2011-04-26T13:33:00.000-07:00

# -*- coding: utf-8 -*-
str = [u"afaaas\n", "adasf \t"]
print "withouth strip():", str
print "with strip:\n", str[0].strip()
print str[1].strip()

as you can see .strip() also remove \t

Python: read utf-8 file

2011-04-25T16:03:00.000-07:00

This how I read utf-8 (without BOM) file in python:

import codecs
txtfile = codecs.open("bla.txt", "r", "utf-8")
t= txtfile.read()
txtfile.close()
print t

Erlang frameworks comparison

2011-04-24T16:11:00.001-07:00

http://chicagoboss.org/projects/chicagoboss/wiki/Comparison_of_Erlang_Web_Frameworks
http://stackoverflow.com/questions/1822518/current-state-of-erlang-web-development-frameworks-template-languages

Interesting info:
http://brainslugs.blogspot.com/2008/02/yaws-erlang.html

Tut for beginers:
http://www.giantflyingsaucer.com/blog/?p=251
http://www.rsdn.ru/article/erlang/GettingStartedWithErlang.xml

mochiweb:
http://habrahabr.ru/blogs/erlang/111252/

Pylons error in windows 7: "UnicodeDecodeError: 'ascii' codec can't decode byte 0xe0 in position 0 : ordinal not in range(128)"

2011-04-17T11:03:00.000-07:00

to solve this issue i delete all cyrillic sections (smth. like this "аудио/x-gsm") in the windows registry:

[HKEY_CLASSES_ROOT\CLSID\{4063BE15-3B08-470D-A0D5-B37161CFFD69}\EnableFullPage\MIME]
and
[HKEY_CLASSES_ROOT\MIME\Database\Content Type]

pylons installation error "ImportError: No module named _weakrefset"

2011-04-17T10:39:00.000-07:00

in go-pylons.py add after line 43

if sys.version_info[:2] >= (2, 7):
REQUIRED_MODULES.extend(['_weakrefset'])

Console 2 for Windows

2011-04-17T08:08:00.000-07:00

I like it, maybe you like it to, so try it if you can't stand standart windows console:
http://sourceforge.net/projects/console/

If you know some other consoles for windows, plz let me know.

Description:
"Console is a Windows console window enhancement. Console features include: multiple tabs, text editor-like text selection, different background types, alpha and color-key transparency, configurable font, different window styles"

Django error on windows: "Error loading MySQLdb module: No module named MySQLdb"

2011-04-13T15:29:00.001-07:00

If you got this error "Error loading MySQLdb module: No module named MySQLdb" in Django on windows... just install this
http://www.codegood.com/downloads?dl_cat=2