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.

Set up Mac files share for Windows

http://macs.about.com/od/networking/qt/sharingleopard.htm
http://lifehacker.com/#!247541/how-to-access-a-macs-files-on-your-pc