`.profile` works with `sh` or `bash`. However `.bash_profile` is bash-specific and will override `.profile` if present.

I believe mac OS X environment checks `.bash_profile`, `.bash_login`, `.profile` in this order. It will run whichever is the highest in the hierarchy, so, if you have `.bash_profile`, it will not check `.profile`.

I have a problem to send the view to back. In Android we have a method like `bringToFront()`, to place the view on top of the another view. Like that, I want to put the view on below the previous image. 

Is there any method like `sendToBack()` or `bringToBack()` in Android. If so, can any one help me in this. 

Note: that I do not want to control the z-order by the order of placing items in layout I want to control the z-order programmatically. 

I do not want to hide the views on the front I just want them to be behind the view that is moving. 

How to send view to back ? How to control the z-order programmatically?

I want to select distinct values in a database. Let me run you through a quick example.

Table:

    foo bar
    --- ---
    a   c
    c   f
    d   a
    c   a
    f   c
    a   c
    d   a
    a   c
    c   a
    f   c

Right, let&#39;s say my SQL is `SELECT DISTINCT foo, bar from table`. These are my results:

    foo bar
    --- ---
    a   c
    c   f
    d   a
    c   a
    f   c

However the problem is is that there are repetitions of `a c` / `c a` just that they are in a different order. I don&#39;t want to select these, I want distinct values from both columns, please help!

MYSQL select DISTINCT values in two columns

I am going to set the path for mySQl on my computer (I&#39;m running Snow Leopard) but I see different instructions online.

Some say to change the .profile file and some say to change the .bash_profile file. What is the difference?

Difference between .profile and .bash_profile on Snow Leopard

<p>I am going to set the path for mySQl on my computer (I'm running Snow Leopard) but I see different instructions online.</p>
<p>Some say to change the .profile file and some say to change the .bash_profile file. What is the difference?</p>


Just upgraded my computer to Mac OS X Lion and went to terminal and typed &quot;make&quot; but it says:
-bash: make: command not found

Where did the &quot;make&quot; command go?



Where can I find &quot;make&quot; program for Mac OS X Lion?

I recently upgraded to OSX 10.7, at which point my rails installation completely borked when trying to connect to the psql server.   When I do it from the command line using 

    psql -U postgres

it works totally fine, but when I try to run the rails server or console with the same username and password, I get this error 

    ...activerecord-3.0.9/lib/active_record/connection_adapters/postgresql_adapter.rb:950:in `initialize&#39;: could not connect to server: Permission denied (PGError)	
    Is the server running locally and accepting
    	connections on Unix domain socket &quot;/var/pgsql_socket/.s.PGSQL.5432&quot;?

Any ideas what might be going on would be super helpful!  Thanks!

Repairing Postgresql after upgrading to OSX 10.7 Lion

I need to retrieve the default gateway on a Mac machine. I know that in Linux route -n will give an output from which I can easily retrieve this information. However this is not working in Mac OSX(Snow Leopard). 

I also tried `netstat -nr | grep &#39;default&#39;`, but I was hoping for a cleaner output like that produced by `route -n` in Linux/Unix. `netstat -nr` lists all the interfaces and the default gateway for them.

Any kind of suggestion or a hint in the right direction will be appreciated.

How to get default gateway in Mac OSX

I have recently updated to Lion and enabled Web Sharing in the System Preferences but I am unable to get php working.

I added an info file to the web root directory and it outputs the file as text.

    info.php
    with the content
    &lt;?php phpinfo(); ?&gt;



How do you get php working on Mac OS X?

I recently upgraded from Snow Leopard to Lion and Xcode 4.1, and word jumping stopped working in both Terminal and iTerm2. Did the mappings change?

This is with *and* without a homebrew installation of `readline`.

My `.inputrc` looks like this:

    &quot;\e[1;5D&quot;: backward-word
    &quot;\e[1;5C&quot;: forward-word

Thanks!

Word jumping in iTerm2 or Terminal in OSX Lion

I&#39;m running Vim on a gnome terminal. But the alt key mappings are not working.
&lt;br&gt;For example (this is just an example):

    :imap &lt;A-i&gt; &lt;Esc&gt;


It works fine in GVim. But when I run the same command with Vim in the gnome terminal it just doesn&#39;t work.
&lt;br&gt;So I think the problem is with the terminal, right?
&lt;br&gt;How can I fix it?

Thanks

**EDIT:** I have Windows 7 installed on the same machine, and with Windows terminal it works just fine too.

Alt key shortcuts not working on gnome terminal with Vim

I was trying to make the syntax highlighting (with 256 colors) of ```vim``` work inside ```screen```, which is running inside ```gterm```.

It works quite fine in the beginning. What I mean by &quot;in the beginning&quot; is, after I start ```screen```, and enter ```vim```, the colors look fine, and there are really 256 colors.

But after a while (I don&#39;t know exactly how long) the colors automatically change back to an appearance as if there are only 8 (or 16?) colors.

For example, after this has already occurred, if I enter the command

    hi Comment ctermfg=68

inside ```vim```, the comments appear to be &quot;pure&quot; green; however, if I open another ```vim``` outside screen (in the same terminal), then with the same command the comments appear to be a &quot;yellowish&quot; green.

The following is my .screenrc settings related to color:

    attrcolor b &quot;.I&quot;
    defbce &quot;on&quot;
    termcapinfo xterm &#39;Co#256:AB=\E[48;5;%dm:AF=\E[38;5;%dm&#39;
    term xterm-256color

After running a python script to display all the colors, I find out that maybe this is a problem of screen itself, and has nothing to do with vim.

What I did is, inside the ```screen``` session with problems, this script gives 256 colors, but many of them are actually the same; however, when I start a new screen session with the same configuration, this script gives 256 colors which are distinct from each other.

Edit:

Last night I connected to my Linux computer (which is in my office and it is always on) with ```putty```, then opened a ```screen``` session with multiple windows in it. The colors are correct last night. Then before I went to sleep I detached the ```screen``` session and closed ```putty```.

Now in the morning when I attach that ```screen``` session in ```putty``` again, the colors crash: they appear as if there are only 8 colors.

The colors are fine outside ```screen``` (but still in ```putty```).


Edit:

Three years later after I asked this question, today I saw a similar problem.  The problem is that ```vim``` can display 256 colors outside ```screen```, and ```screen``` can display 256 colors with a test script, but ```vim``` can&#39;t display any color (can only display black and white) inside ```screen```.  Just as a note to myself, here is the ```.screenrc``` file I am using

    hardstatus alwayslastline &quot;%{.bW}%-w%{.rW}%n %t%{-}%+w %=%{..G} %H %{..Y} %Y-%m-%d %c&quot;
    shell &quot;bash&quot;
    startup_message off
    vbell off
    altscreen on
    attrcolor b &quot;.I&quot;
    defbce &quot;on&quot;
    termcapinfo xterm* &#39;is=\E[r\E[m\E[2J\E[H\E[?7h\E[?1;4;6l&#39;
    termcapinfo xterm &#39;Co#256:AB=\E[48;5;%dm:AF=\E[38;5;%dm&#39;
    term screen-256color

The solution to the problem is already mentioned in the accepted answer, namely, I need to include

    export TERM=xterm-256color

in ```.bashrc```.

Strange behavior of vim color inside screen with 256 colors

After the installation of OSX Lion, I tried to:

    nano /etc/apt/sources.list

But I get this error:

    Error opening terminal: xterm-256color

If I try to switch terminal.app preferences to open terminal windows in &quot;xterm color&quot; instead of `xterm-256color` everything works fine.

What&#39;s happening?


nano error: Error opening terminal: xterm-256color

I want to differentiate the STDOUT and STDERR messages in my terminal.
If a script or command is printing a message in terminal I want to differentiate by colors; is it possible?

(E.g. stderr font color is red, and stdout font color is blue.)

Example (using bold):

&gt; `$date`  
&gt; `Wed Jul 27 12:36:50 IST 2011`
&gt;
&gt; `$datee`  
&gt; **`bash: datee: command not found`**
&gt;
&gt; `$alias ls`  
&gt; `alias ls=&#39;ls --color=auto -F&#39;`
&gt;
&gt; `$aliass ls`  
&gt; **`bash: aliass: command not found`**



How to set font color for STDOUT and STDERR

I recently uninstalled Xcode 4.2 and re-installed Xcode 4.3.1. Command Line Tools are installed. I then installed MacPort using “dmg” disk images for Lion from macports.org. Since, I was getting `sudo: port: command not found` after every use of port, I followed [this][1] and [this post][2] to create a `.bash_profile` file(wasn&#39;t present earlier) and then put in it the following but to no avail.

    export PATH=$PATH:/opt/local/bin
    export MANPATH=$MANPATH:/opt/local/share/man
    export INFOPATH=$INFOPATH:/opt/local/share/info 



Following [this post][3]

    ➜  ~ git:(master) ✗ rvm install 1.8.7 --with-openssl-dir=/opt/local
    You requested building with &#39;/usr/bin/gcc-4.2&#39; but it is not in your path.
    ➜  ~ git:(master) ✗ vi .rvmrc 

    rvm_archflags=&quot;-arch x86_64&quot;
    
    export CC=&quot;/usr/bin/gcc-4.2&quot;
    
    export CFLAGS=&quot;-O2 -arch x86_64&quot;
    export LDFLAGS=&quot;-L/opt/local/lib&quot;
    export CPPFLAGS=&quot;-I/opt/local/include&quot;

Renaming `.bash_profile` to `.profile`

    ➜  ~ git:(master) ✗ vi .bash_profile
    ➜  ~ git:(master) ✗ mv .bash_profile .profile
    ➜  ~ git:(master) ✗ mv .profile              
    usage: mv [-f | -i | -n] [-v] source target
           mv [-f | -i | -n] [-v] source ... directory
    ➜  ~ git:(master) ✗ mv -f .bash_profile .profile
    mv: rename .bash_profile to .profile: No such file or directory
    ➜  ~ git:(master) ✗ port
    zsh: correct &#39;port&#39; to &#39;pr&#39; [nyae]? n
    zsh: command not found: port
    ➜  ~ git:(master) ✗ which port
    port not found
    ➜  ~ git:(master) ✗ 

`.profile` content:

    export PATH=$PATH:/opt/local/bin
    export MANPATH=$MANPATH:/opt/local/share/man
    export INFOPATH=$INFOPATH:/opt/local/share/info

  [1]: http://bparanj.blogspot.com/2007/03/sudo-port-command-not-found.html
  [2]: https://stackoverflow.com/questions/7501678/set-environment-variables-on-mac-os-x-lion
  [3]: http://beginrescueend.com/integration/macports/


sudo: port: command not found

I was trying to install Sencha Touch SDK tools 2.0.0 but could not run it properly. It created an entry in the $PATH variable. 
Later I deleted the sencha sdk tools folder but didn&#39;t realize that the path variable is still there. 

When i did `echo $PATH` I got -

`/Applications/SenchaSDKTools-2.0.0-beta3:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin`

I searched on how to remove variables from $PATH and followed these steps : 

 1. Gave the command `PATH=&quot;/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin&quot;`
 2. Did `echo $PATH` which showed `/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin`
 3. gave the command `export PATH`
 4. Closed terminal and reopened it. Gave the command `echo $PATH`. This time I got 
`/Applications/SenchaSDKTools-2.0.0-beta3:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin`

Can anyone tell me what am i doing wrong?

How to remove entry from $PATH on mac

Above doesn&#39;t work first time, works 2nd time.

Try to set ruby version to 2.0.0 for any new shell windows.

Doing

    $ rvm use 2.0.0 --default

gives

    Warning! PATH is not properly set up, &#39;/home/durrantm/.rvm/gems/ruby-1.9.3-p125/
    bin&#39; is not at first place,
             usually this is caused by shell initialization files - check them for &#39;
    PATH=...&#39; entries,
             it might also help to re-add RVM to your dotfiles: &#39;rvm get stable --au
    to-dotfiles&#39;,
             to fix temporarily in this shell session run: &#39;rvm use ruby-1.9.3-p125&#39;
    .
    Using /home/durrantm/.rvm/gems/ruby-2.0.0-p247

Then doing the same

    $ rvm use 2.0.0 --default

now gives no error, i.e.

    $ rvm use 2.0.0 --default
    Using /home/durrantm/.rvm/gems/ruby-2.0.0-p247
    durrantm.../durrantm$ 

but new windows are still giving me ruby 1.9.3, not 2.0.0

My `.bashrc` file has in it:

    PATH=$PATH:$HOME/.rvm/bin # Add RVM to PATH for scripting
    [[ -s &quot;/home/durrantm/.rvm/scripts/rvm&quot; ]] &amp;&amp; . &quot;/home/durrantm/.rvm/scripts/rvm&quot;

My .bash_profile has:

    source ~/.profile
    case $- in *i*) . ~/.bashrc;; esac

Trying

    rvm get stable

seems to work but at the end of a lot of green output shows: 

    Could not update RVM, get some help at #rvm IRC channel at freenode servers.

A new terminal windows with `rvm list rubies` shows this:

    $ rvm list rubies
    Warning! PATH is not properly set up, &#39;/home/durrantm/.rvm/gems/ruby-1.9.3-p125/bin&#39; is not at first place,
             usually this is caused by shell initialization files - check them for &#39;PATH=...&#39; entries,
             it might also help to re-add RVM to your dotfiles: &#39;rvm get stable --auto-dotfiles&#39;,
             to fix temporarily in this shell session run: &#39;rvm use ruby-1.9.3-p125&#39;.
    
    rvm rubies
    
    =&gt; ruby-1.9.3-p125 [ x86_64 ]
       ruby-1.9.3-p194 [ x86_64 ]
     * ruby-2.0.0-p247 [ x86_64 ]
    
    # =&gt; - current
    # =* - current &amp;&amp; default
    #  * - default

Getting &quot;Warning! PATH is not properly set up&quot; when doing rvm use 2.0.0 --default

I am running Mac 10.9 Mavericks and have installed Anaconda. However, despite that, when I access python via terminal, I still get the default Apple version: 

    Python 2.7.5 (default, Sep  2 2013, 05:24:04) 
    [GCC 4.2.1 Compatible Apple LLVM 5.0 (clang-500.0.68)] on darwin

My .bash_profile is this:

    export PATH=&quot;$HOME/anaconda/bin:$PATH&quot;
    
    MONGO_PATH=/usr/local/mongodb/bin
    SQL_PATH=/usr/local/mysql
    
    export PATH=&quot;/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:$PATH&quot;

Is there anything I can do to use the Anaconda version of Python? At a loss at the moment.

Thank you

Mac using default Python despite Anaconda install

I&#39;ve to set up a local web development environment on my OS X 10.9 and installed Homebrew. Next step in my guide tells me to add logic to my `~/.bash_profile` with the following command:

    echo &quot;export PATH=\$(echo \$PATH | sed &#39;s|/usr/local/bin||; s|/usr/local/sbin||; s|::|:|; s|^:||; s|(.*)|/usr/local/bin:/usr/local/sbin:\1|&#39;)&quot; &gt;&gt; ~/.bash_profile &amp;&amp; source ~/.bash_profile

When I enter it in the terminal I get:

    sed: 1: &quot;s|/usr/local/bin||; s|/ ...&quot;: \1 not defined in the RE

Is it `export PATH=/usr/local/bin:/usr/local/sbin:$PATH` that should be written to my `.bash_profile`? And why do I get that error?

Content Type	Original Author	Original Content on Stackoverflow
Question	redconservatory	View Question on Stackoverflow
Solution 1 - Macos	Paul R	View Answer on Stackoverflow
Solution 2 - Macos	hlim	View Answer on Stackoverflow

Difference between .profile and .bash_profile on Snow Leopard

Macos Problem Overview

Macos Solutions

Solution 1 - Macos

Solution 2 - Macos

MYSQL select DISTINCT values in two columns

How to send view to back ? How to control the z-order programmatically?

Attributions