Showing posts from August, 2012

Change Ubuntu prompt color


For the impatient:
export PS1="\e[0;33m\[\e]0;\u@\h:\w\a\]${debian_chroot:+($debian_chroot)}\u@\h:\w\$ \e[m"

Now this will change your prompt color instantly if you are using putty, I don't know about other tools or if you are connected to the server.

This should be the color code:


Accessing a web server on a virtual machine hosted on Ubuntu server 12.04 LTS

After you install Ubuntu Server 12.04 (host), then you install a virtual box guest (Windows 2008 Server x64 in my case) and install your services on the guest. You'll have to do the following to access your guest's web server:

Windows Firewall ! Your guest does not enable port 80\8080 by default

If that doesn't fix it already, try turning your guest's NIC into promiscuous mode:

VBoxManage modifyvm "Win2008Server_x64" --nicpromisc1 allow-all

This of course implies that Ubuntu iptables do allow port 80. If you have just installed the server then you have no rules what so ever and all connections are allowed by default so it iptables won't be an issue then.

If you find the first step enough to resolve this, please mention it in a comment. Thanks.

MySQL [Error Code: 1055. 'yourschema.yourtable.yourcolumn' isn't in GROUP BY] error

I recently used this very nice online wizard tool to generate a MySQL configuration file for a dedicated server. The thing is that I enabled the option "SQL Strict Mode" which generated many helpful constraints but one, which was "ONLY_FULL_GROUP_BY".

I don't think many people would like to have this constraint but I know I didn't.

Just open your my.cnf file, remove that constraint and restart your server.