Installing RabbitMQ on CentOS, Fedora and RHEL

# Login as root. Note "-" in su command, it is important to get proper shell definitions including the PATH
su -
....enter password


#verify OS version
cat /etc/*release*

# Download and enable EPEL
# for CentOS 5:

# rpm -Uvh http://download.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm

# for CentOS 6:
rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm 


#Get & install Erlang
wget -O /etc/yum.repos.d/epel-erlang.repo http://repos.fedorapeople.org/repos/peter
/erlang/epel-erlang.repo

yum install erlang

# Get RabbitMQ signing key
rpm --import http://www.rabbitmq.com/rabbitmq-signing-key-public.asc

# check for the latest version at RabbitMQ web site: http://www.rabbitmq.com/install-rpm.html
rpm -Uvh http://www.rabbitmq.com/releases/rabbitmq-server/v2.8.4/rabbitmq-server-2.8.4-1.noarch.rpm

yum install rabbitmq-server-2.8.4-1.noarch.rpm

# if this command did not work take a look what you got in online repositories:
# http://repos.fedorapeople.org/repos/peter/erlang/
# probably your RPM does not exists there
# in this case you can try using older RPM
# if you decided to do that, do teh following:
vi /etc/yum.repos.d/epel-erlang.repo

#comment line
baseurl=http://repos.fedorapeople.org/repos/peter/erlang/epel-$releasever/$basearch/

# and replace it with
baseurl=http://repos.fedorapeople.org/repos/peter/erlang/epel-5/$basearch/

# next, comment line
baseurl=http://repos.fedorapeople.org/repos/peter/erlang/epel-$releasever/SRPMS

# and replace it with
baseurl=http://repos.fedorapeople.org/repos/peter/erlang/epel-5/SRPMS

# exit vi and try again running
# yum install rabbitmq-server-2.8.4-1.noarch.rpm

# Add RabbitMQ to list of services to be started on reboot
chkconfig rabbitmq-server on

# Add RabbitMQ management plugin:
/usr/sbin/rabbitmq-plugins enable rabbitmq_management sudo

# start RabbitMQ server

service rabbitmq-server start


# point your browser to  http://[your-rabbitmq-server]:55672
# enter user name / pwd: the defaults are guest / guest

Installing InfoBright Enterprise Edition (trial) on CentOS 5.7

# create license file on InfoBright web
# download the latest Infobright RPM

> rpm -i ib-installation-file.rpm

#copy license file to IB installation
> cp iblicense-yan123_yan123-89359130-IEE.lic /usr/local/infobright

# run the DB
/etc/init.d/mysqld-ib start

# make IB service running after reboot
> chkconfig --add /etc/init.d/mysqld-ib
> chkconfig mysqld-ib on

# change IB / MySQL root pwd
/usr/local/infobright-4.0.6-x86_64/bin/mysqladmin -u root password 'new-password'

# run mysql client and grant all privileges to a user
# from another host who comes with a certain password
mysql-ib -u root -p
[enter root password on prompt]
> GRANT ALL ON *.* TO 'myuser' IDENTIFIED BY 'some-user-password';

#add remote access and other permissions for 'root' too
> GRANT ALL ON *.* TO 'root' IDENTIFIED BY 'some-root-password';

Installing InfoBright database VM on Windows 7 with VMWare Player

1. Get Inforbright community edition (ICE) here: http://www.infobright.org/downloads/vm/ice32_352.zip
2. Get VMPlayer from vmware.com. Free registration required.
3. Run ice32.vmx file - WMPlayer opens.
4. In WMPlayer, "Virtual Machine->Power-Stop" - stop the VM and reconfigure to what you need: give it more CPUs and more RAM if needed. The default values are 1GB RAM and 1 CPU.
5. Restart VM
While rebooting you will see VM IP. Write it down.
Once VM goes up, point your web browser to that IP. You should see ICE32 web page with access credentials.
6. Login with
user: ice
password: infobright
7. Go to VMPlayer and run
mysql-ib -u root
8. Run in MySQL client the following command so you can access MySQL from another machine (e.g. from the machine where the VMWare is installed) -
grant all privileges on *.* to 'root'@'x.x.x.x' with grant option;
Note: The default install of InfoBright Database on VM is configured with user root with no password.

Now you should be able to connect to InfoBright running on your VMWare Palyer from an external machine.

9. Connection: The default port is 5029. You can check it out in my.cnf file (port=1234)

10. in VMPlayer (Ubuntu):
sudo /bin/bash
- change to root this way and edit /etc/my-ib.cnf if required.
For instance, add
max_heap_table_size = 1024M
under
[mysqld]
section

11. Restart Infobright DB:
sudo /etc/init.d/mysqld-ib stop
sudo /etc/init.d/mysqld-ib start

How to disable top administration bar in WordPress for all users in one SQL query (MySQL)

REPLACE INTO `wp_usermeta` (`user_id`,`meta_key`, `meta_value`)
SELECT ID, 'show_admin_bar_front', 'false' FROM wp_users

Next, you can can run an UPDATE query removing this row for all users who have administrative permissions.

SOLVED: Netbeans 7 FTP uploads fails after upgrading to JDK 7

Netbeans 7.0.1, JDK7, Windows 7 / Vista
32/64 bit

Netbeans FTP uploads to a remote site fail after upgrading to JDK 7.
The issue is related to new features introduced in JDK7 FTP and by default blocked by Windows Firewall.

Solution:
1. Run cmd.exe as an administrator.
2. Run the following command in cmd:
netsh advfirewall set global StatefulFTP disable

You are done, try Netbeans FTP uploads now.

Installing MYSQL on RedHat Enterprise Linux RHEL 6.1

Get MySQL here: http://www.mysql.com/downloads/mysql/#downloads


Select TAR installation if available, get the link of TAR and run
wget [link]

Uncompress
 tar -xvf MySQL-5.5.13-1.rhel5.x86_64.tar


Install server:
rpm -Uvh MySQL-server-5.5.13-1.rhel5.x86_64.rpm

Install client:
rpm -Uvh MySQL-client-5.5.13-1.rhel5.x86_64.rpm


Note this warning:
----------------------
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h ip-10-34-70-147 password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!

-----------------------------------

Start MySQL:
service mysql start

RDC error "terminal service exceeds number of connections"

If trying to remote login as Administrator to a remote MS computer via Remote Desktop gives an error about too many open connections, do the following:

1. open cmd.exe on your local Windows machine

2. Run from command line:
mstsc /admin

This will run Remote Desktop and allow the login.

optional - 3. Open Task Monitor on the remote computer and 'logoff' all the logged in users but yours.