DEBIAN 8 – How to install MySQL server 5.6 or 5.7

I recently had to upgrade MySQL to 5.6 but found that Debian provides MySQL server 5.5 with both Jessie (v8) but the latest GA releases are 5.6 and 5.7 with some enhancements and added features, including support for InnoDB Full-text search.

So to install the latest version on Debian do this:

1. Download the MySQL APT repository config tool (you can see more details here: http://dev.mysql.com/downloads/repo/apt/)

wget http://dev.mysql.com/get/mysql-apt-config_0.7.3-1_all.deb

2. Install the MySQL APT repository config tool

dpkg -i mysql-apt-config_0.7.3-1_all.deb

3. If you get an invalid key error run:
sudo apt-key adv --keyserver pgp.mit.edu --recv-keys A4A9406876FCBD3C456770C88C718D3B5072E1F5

You will be asked to select product and version that you want to install. In the first step, select Server and next select either mysql-5.6 or mysql-5.7. Then click Apply.

3. Update APT

apt-get update

4. Install the server

apt-get install mysql-community-server

Job done.

HP Pro 1102w printer installation in Debian with CUPS

All necessary information are available here.

And the bits that I care about:

Download and Install

Click the link, or cut and paste the whole command line below to download the driver.

    $ wget -O foo2zjs.tar.gz http://foo2zjs.rkkda.com/foo2zjs.tar.gz

Now unpack it:

Unpack:
    $ tar zxf foo2zjs.tar.gz
    $ cd foo2zjs

Now compile and install it. The INSTALL file contains more detailed instructions; please read it now.

Compile:
    $ make

Install driver, foomatic XML files, and extra files:
    $ su			OR	$ sudo make install
    # make install

(Optional) If you use CUPS, restart the spooler:
    # make cups			OR	$ sudo make cups

Now create printer entries for your spooler.

Once the above is done simply go to https://Your_cups_server:631/ and add the printer:

cups_p_1102w

and if everything went OK the driver will be visible somewhere near the bottom of the list as listed above.

Debian – VMware Tools

Open VM Tools

Open VM Tools is the open source implementation of VMware Tools and consist of a suite of virtualization utilities that improves the functionality, administration, and management of virtual machines on VMware hypervisors. VMware recommends using the Open VM Tools redistributed by the operating system vendors. For additional information, see knowledge base article 2073803, VMware support of open-vm-tools, at http://kb.vmware.com/kb/2073803.

Install Open VM Tools

  1. Add the following line to the /etc/apt/sources.list file.
    deb http://ftp.debian.org/debian/ wheezy main contrib
  2. Run the commands:
    $ sudo apt-get update
     $ sudo apt-get install open-vm-tools

Source: vmware.com

LINUX – Network Manager – How to get network adapter information

Here is short info how to get network adapter info for systems with network manager:
nmcli dev list iface wlan0

example output:

GENERAL.DEVICE:                         wlan0
GENERAL.TYPE:                           802-11-wireless
GENERAL.VENDOR:                         Broadcom Corporation
GENERAL.PRODUCT:                        BCM4313 802.11b/g/n Wireless LAN Controller
GENERAL.DRIVER:                         brcmsmac
GENERAL.DRIVER-VERSION:                 3.16.0-38-generic
GENERAL.FIRMWARE-VERSION:               N/A
GENERAL.HWADDR:                         00:26:82:9e:AF:11
GENERAL.STATE:                          100 (connected)
GENERAL.REASON:                         0 (No reason given)
GENERAL.UDI:                            /sys/devices/pci0000:00/0000:00:1c.3/0000:44:00.0/bcma0:0/net/wlan0
GENERAL.IP-IFACE:                       wlan0
GENERAL.NM-MANAGED:                     yes
GENERAL.AUTOCONNECT:                    yes
GENERAL.FIRMWARE-MISSING:               no
GENERAL.CONNECTION:                     /org/freedesktop/NetworkManager/ActiveConnection/0
CAPABILITIES.CARRIER-DETECT:            no
CAPABILITIES.SPEED:                     65 Mb/s
CONNECTIONS.AVAILABLE-CONNECTION-PATHS: /org/freedesktop/NetworkManager/Settings/{1}
CONNECTIONS.AVAILABLE-CONNECTIONS[1]:   26d879c4-0d6f-4000-bf02-43c687416e1e | Auto IntoTheWild
WIFI-PROPERTIES.WEP:                    yes
WIFI-PROPERTIES.WPA:                    yes
WIFI-PROPERTIES.WPA2:                   yes
WIFI-PROPERTIES.TKIP:                   yes
WIFI-PROPERTIES.CCMP:                   yes
WIFI-PROPERTIES.AP:                     yes
WIFI-PROPERTIES.ADHOC:                  yes
AP[1].SSID:                             'WiFI-NamE'
AP[1].BSSID:                            CC:AB:BB:12:33:33
AP[1].MODE:                             Infrastructure
AP[1].FREQ:                             2412 MHz
AP[1].RATE:                             54 MB/s
AP[1].SIGNAL:                           37
AP[1].SECURITY:                         WPA WPA2
AP[1].ACTIVE:                           no
AP[2].SSID:                             'AnothErWiFi'
AP[2].BSSID:                            34:3E:1F:33:E2:33
AP[2].MODE:                             Infrastructure
AP[2].FREQ:                             2437 MHz
AP[2].RATE:                             54 MB/s
AP[2].SIGNAL:                           52
AP[2].SECURITY:                         WPA2
AP[2].ACTIVE:                           yes
IP4.ADDRESS[1]:                         ip = 10.0.1.99/24, gw = 192.168.1.254
IP4.DNS[1]:                             10.0.1.60
IP4.DOMAIN[1]:                          home
DHCP4.OPTION[1]:                        domain_name = home
DHCP4.OPTION[2]:                        expiry = 1451147274
DHCP4.OPTION[3]:                        broadcast_address = 10.0.1.255
DHCP4.OPTION[4]:                        dhcp_message_type = 5
DHCP4.OPTION[5]:                        dhcp_lease_time = 604800
DHCP4.OPTION[6]:                        ip_address = 10.0.1.99
DHCP4.OPTION[7]:                        routers = 10.0.1.254
DHCP4.OPTION[8]:                        subnet_mask = 255.255.255.0
DHCP4.OPTION[9]:                        domain_name_servers = 10.0.1.60
DHCP4.OPTION[10]:                       network_number = 10.0.1.0
DHCP4.OPTION[11]:                       dhcp_server_identifier = 10.0.1.60