hostapd how to enable and use WPS to connect wireless devices like printers

Edit your /etc/hostapd/hostapd.conf file like below and restart hostapd. #WPS stuff # Enable control interface for PBC/PIN entry ctrl_interface=/var/run/hostapd eap_server=1 wps_state=2 ap_setup_locked=1 wps_pin_requests=/var/run/hostapd.pin-req config_methods=label display push_button keypad #WPS model info stuff change to suit your needs device_name=USB2.0 WLAN manufacturer=ATHEROS model_name=WAP........

How to configure OpenDKIM on Linux with Postfix and setup bind zonefile

This guide assumes you have a working Postfix server and want it to sign with DKIM. There are a few things we have to understand to make all of this work though, which require you to be familiar with DNS as well. 1.) Install OpenDKIM apt install opendkim systemctl enable opendkim 2.) Edit /etc/opendkim.conf Syslog yes SyslogSuccess yes Mode&nbs........

When is it time to leave your VPS/VDS Cloud Hosting Provider?

When Is It Time to Leave Your VPS, VDS, and Dedicated Server Provider? Choosing the right hosting solution—be it Virtu........

Install Grafana on Linux Debian Ubuntu Tutorial Guide

First we need a few extra packages: apt update apt install -y adduser libfontconfig1 musl sudo wget https://dl.grafana.com/enterprise/release/grafana-enterprise_10.3.1_amd64.deb Install / Enable Grafana dpkg -i grafana-enterprise_10.3.1_amd64.deb dpkg -i grafana-enterprise_10.3.1_amd64.deb (Reading database ... 44309 files and directories currently installed.) Preparin........

Proxmox install issue cannot see the buttons or install wrong / bad resolution cannot see the entire screen problem solution

If you are using a hypervisor to test Proxmox (eg. Vbox) then changing the video card/display adapter can fix it. For example VboxSVGA causes the issue but switching to VMSVGA fixes it. For example VboxSVGA causes the issue but switching to VMSVGA fixes it. ........

How To Upgrade Debian 8,9,10 to Debian 12 Bookworm

Step 1.) Upgrade to Debian 11 first The process to go to Debian 12 is not as smooth as 11, when trying to upgrade from Debian 10. In fact, it doesn't work directly, so you'll first need to follow this guide to update to Debian 11, reboot and come back here if successful. Step 2.) Update sources.list Update your /etc/apt/sources.list like this: deb http://........

How to Configure NVIDIA GPUs with Docker on Ubuntu: A Comprehensive Guide for AI Deep Learning CUDA Solution

Welcome to our in-depth guide on configuring NVIDIA GPUs with Docker on Ubuntu. This post is tailored for developers, data scientists, and IT professionals who are looking to leverage the power of NVIDIA's GPU acceleration within Docker containers. Whether you're working on machine lea........

How to install and configure haproxy on Linux Ubuntu Debian

haproxy is one of the best known and widely used Open Source load balancers out there and a strong competitor to nginx. haproxy is used by many large sites per Wikipedia: HAProxy is used by a number of high-profile websites including GoDaddy, GitHub,........

Virtualbox Best Networking Mode In Lab/Work Environment without using NAT Network or Bridged

Virtualbox is a very powerful tool, but for some use cases it is less than optimal. Say you are in a work, lab or other environment where you are not alone on the physical network and there could be overlap of IPs, but you need all of your VMs to be contactable from your host, VMs need to communicate with each other, and VMs need internet. NAT Network will give you VM to VM communication and internet, however, it is buggy and unstable. It also doesn't allow host to VM co........

How To Restore Partition Table on Running Linux Mint Ubuntu Debian Machine

Here is an easy way to restore things if you have the starting point and size of each partition using fdisk: In this example we pretend that /dev/sda was wiped out, but the running system still has the info in /sys/class/block/sda Go into each partition and record the "start" and "size" hostdev@box /sys/class/block/sda/sda1 $ cat start 2048 hostdev@box /sys/class/block/sda/sd........

Libreoffice Calc Opens CSV Spreadsheet File as Asian Language/Chinese Characters Solution Fix

Usually LIbreoffice gets it right, but if it opens a normal English CSV as UTF-16 by default and shows Asian languages, you'll have ot manually open to fix it (don't double click the file from the File Manager). Solution - Manually Open the File After Opening LibreOffice Calc You'll see it is defaulting to UTF-16 which breaks everything. ........

How To Do Linux Network Bonding Teaming in Mint Debian Ubuntu

Bonding is an excellent way to get both increased redundancy and throughput. It is similar to the "Network Teaming" feature in Windows. There are a few different modes but we will use mode 6, I think it's the best of both worlds, as it is not just a failover, but it provides round robin, so you will get redundancy and load balancing. So if you have a 1G single port, you will have a combined throughput of 4G at this point. Just bear in mind that the true thr........

LXC Containers LXD How to Install and Configure Tutorial Ubuntu Debian Mint

If you are using mint, delete the preference that stops snap from installing (as it is required for lxc) sudo rm /etc/apt/preferences.d/nosnap.pref 1. Install lxd: sudo apt install lxd Issues install lxd or errors? Click here Debian at this time does not have lxd so you'll need to use snap: sudo apt in........

GlusterFS HowTo Tutorial For Distributed Storage in Docker, Kubernetes, LXC, KVM, Proxmox

This can be used on almost anything, since Gluster is a userspace tool, based on FUSE. This means that all Gluster appears as to any application is just a directory. Applications don't need specific support for Gluster, so long as you can tell the application to use a certain directory for storage. One application can be for redundant and scaled storage, including for within Docker and Kubernetes, LXC, Proxmox, OpenStack, etc or just your image/web/video files or even da........

(firefox:9562): LIBDBUSMENU-GLIB-WARNING **: Unable to get session bus: Failed to execute child process "dbus-launch" (No such file or directory) Solution

(firefox:9562): LIBDBUSMENU-GLIB-WARNING **: Unable to get session bus: Failed to execute child process "dbus-launch" (No such file or directory) ExceptionHandler::GenerateDump cloned child 9743 ExceptionHandler::WaitForContinueSignal waiting for continue signal... ExceptionHandler::SendContinueSignalToChild sent continue signal to child [Parent 9562, Gecko_IOThread] WARNING: pipe error (40): Connection reset by peer: file /build/firefox-EymEXX/fire........

Debian Mint Ubuntu Which Package Provides missing top, ps and w Solution

Install procps and it will install the other packages you need: apt install procps Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: libgpm2 libncurses6 libprocps7 lsb-base psmisc Suggested packages: gpm The following NEW packages will be ins........

How To Create OpenVPN Server for Secure Remote Corporate Access in Linux Debian/Mint/Ubuntu with client public key authentication

Why choose OpenVPN instead of a firewall appliance? OpenVPN can be a reliable and easy replacement for traditional hardware or just be an additional tool that your company uses so that the firewall can focus on its job rather than acting as a VPNappliance at the same time. When comparing OpenVPN with traditional firewal........

Ansible Tutorial - Playbook How To Install From Scratch and Deploy LAMP + Wordpress on Remote Server

1. Let's work from an environment where we can install Ansible on. If you are using an older version of Linux based on Mint 18 or Ubuntu 16, you may want to get the PPA and get the latest version of Ansible that way: sudo apt install gpg sudo add-apt-repository ppa:ansible/ansible sudo apt update........

Windows Cannot Format USB drive Device Media is Write Protected Error Solution

First of all make sure that you don't have the write-lock or write-protect switch enabled on the SDCard or USB drive. If the above is not the case, then follow these instructions: Solution - Clear Read Only Attribute Hit "Windows Key+R" and enter "cmd" to enter the command prompt: Now type the following :........

Linux Mint 20 cannot install snapd missing solution

The Linux Mint team has disabled it by setting an apt preference, you can edit or just remove the file: sudo apt install snapd Reading package lists... Done Building dependency tree Reading state information... Done Package snapd is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source........

How to install Kubernetes with microk8s and deploy apps on Debian/Mint/Ubuntu Linux

Kubernetes Easy Beginners Tutorial/Architecture Guide Kubernetes is known as container orchestration and we should start at explaining the container part of it. A Container is what runs the actual application and based on an Image, and are more comparable to something like an LXC Container, Virtuozzo/OpenVZ using the Linux Kernel Namespaces feature. Containers run these images as independent, isolated operating environments under the O........

QEMU KVM Keyboard Problems Not Working Right Repeating Characters, Ctrl+C Copy and Paste not working right when using PS2 mouse in guests Solution

It seems that QEMU/KVM's default PS2 mouse and keyboard doesn't work right in most cases. I have especially observed issues using Ctrl+C and Ctrl+V and in Linux you may see repeated key presses in the terminal and you will wonder why you copied something and it's not in the clipboard when you try to paste. The way to temporarily fix it is to press the key that is repeating once(works in Linux but not really in Windows). Sometimes when moving your mouse it will also s........

Nvidia Ubuntu Linux Screentearing Video with solution driver

This seems to happen on most if not all Nvidia cards but the good news is that if you are using any of the Linux drivers and have the nvidia-settings tool installed it is just a simple command. Solution: nvidia-settings --assign CurrentMetaMode="nvidia-auto-select +0+0 { ForceFullCompositionPipeline = On }" Enter the above command in your terminal and the screentearing will be fixed which is like enabling Tear Free on AMD cards.&........

How To Get Started on Ubuntu with gpt-2 OpenAI Text Prediction

apt install software-properties-common add-apt-repository ppa:deadsnakes/ppa apt update apt install python3-pip apt install python3.7 curl gnupg python3.7-dev git ln -s /usr/bin/python3.7 /usr/bin/python3 pip3 install numpy keras_preprocessing curl https://bazel.build/bazel-release.pub.gpg | sudo apt-key add - echo "deb [arch=amd64] http://storage.googleapis.com/bazel-apt stable jdk1.8" | sudo tee /etc/apt/sources.list.d/bazel........

Linux Debian Ubuntu How To Install PEPPER Faster and Latest Adobe Flash Player in Firefox

Just run this apt install command sudo apt install pepperflashplugin-nonfree browser-plugin-freshplayer-pepperflash After this restart your browser and check Adobe's site to verify if your Pepper flash is working and showing at least version 32. https://helpx.adobe.com/flash-player.html As you'll see below it will download the latest version which is currently 32 and this was not possible with the old/crappy deprecated adobe-flash plu........

using Xvfb on virtual remote ssh server to have X graphical programs work

The scenario here is that you have some sort of remote headless Linux server but would like to run some programs on them and get graphical access to them. The problem is that the remote server may be an image or VMwithout any virtual GPU and even if so, it is likely without KDE or Gnome, so there's no real way to do this, unless you follow our guide. Install xvfb apt install xvfb Reading package lists... D........

MySQL 5.7 on Debian and Ubuntu - How To Reset Root Password

MySQL on Debian versions is configured differently than the native local MySQL plugin so you will be disappointed when your password on the mysql client fails by default. Here is how you reset the MySQL root password the proper and "working way" #first we gracefully stop mysql sudo systemctl stop mysql; #then we forcefully kill any mysqld process just in case sudo killall -9 mysqld mysqld_safe;........

mpv / mplayer with Radeon / AMD GPU Video Card Driver enable VDPAU GPU Accelerated Video Decoding

The easiest way to know if your videos are playing with GPU acceleration are to watch the process of xplayer, mpv or whatever you are playing. The CPU usage should be no more than 10% for that process/program if it is using acceleration. Let's manually play with vdpau to make sure it works before we make it permanent: First make sure you have libvdpau installed: sudo apt install vdpau-driver-all If yo........

Ubuntu Debian Linux Mint r8169 r8168 Network Driver Problem and Solution

This problem has been around forever, Linux seems to think it is fine to use the r8169 driver for an r8168 NIC but this often causes problems including the link not working at all. In my case ethttool shows the link up and detected but it simply does not work especially on a laptop that has been resumed from suspension. Sometimes it takes several minutes for it to work or to unplug and replug the ethernet. Here is the solution: Install th........

How To Install Asterisk 16 17 on Debian Ubuntu Linux

Downloading and compiling from source to get the latest version of Asterisk is really simple with this guide. apt install gcc make g++ libedit-dev uuid-dev libjansson-dev apt install libxml2-dev sqlite3 libsqlite3-dev wget http://downloads.asterisk.org/pub/telephony/asterisk/asterisk-16-current.tar.gz tar -zxvf asterisk-16-current.tar.gz cd asterisk-16.6.2/ ./configure If you get this error change y........

Linux Ubuntu Debian Centos How To Make a Bootable Windows 7, 8, 10, 2016, 2019 Server USB from ISO

Use fdisk on your USB drive to create a bootable NTFS partition (in my case /dev/sdb): sudo fdisk /dev/sdb Welcome to fdisk (util-linux 2.27.1). Changes will remain in memory only, until you decide to write them. Be careful before using the write command. Command (m for help): n Partition type p primary (0 primary, 0 extended, 4 free)........

MySQL Bash Query to pipe input directly without using heredoc trick

Most of us know the heredoc method but what if you need a basic query done repeatedly and manually while working from bash? It is a pain to manually type mysql and login each time. With this command below you can semi-automate those queries: echo "use somedb; select * from auctions" | mysql -u root --password="yourpassword" Just modify the above to suit your needs and you can add more queries by adding a sem........

CentOS 6 and 7 / RHEL Persistent DHCP Solution

It is very silly but the default on the ifup-eth script tells dhclient ( the program that obtains a DHCP IPaddress if you have selected DHCPin your ifcfg-eth* config file) to EXIT / QUIT if the first attempt to obtain a lease fails. No amount of dhclient.conf settings will fix this because if dhclient is started with -1 (which it is by default)then dhclient will quit. This is obviously very bad for MOST cases. Say for example you have a power outage or........

MySQL Cheatsheet Guide and Tutorial

Create Database: create database yourdbname; Show All Databases: show databases; Change Database: use mysql; Drop / Delete a MySQL Database: drop database nameofyourdatabase;........

Debian Ubuntu and Linux Mint Broken Kernel After Date - New Extra Module Naming Convention

I don't consider a lot of these "extra" kernel modules "nice to have" as they often contain drivers for essential items like your soundcard, your NIC and many other devices that may not work. Sometimes you may find that "sound" or "ethernet" worked before a kernel/OS upgrade and now in the new version they don't. Often it will be because you need to install the "extra" kernel modules. One other weird thing is that sometimes........

Virtualbox vbox not starting

If you've just installed VBox and it is not starting or working, the most common problem is usually that you don't have your kernel source installed, which means there is no kernel driver for vbox so it can't work. You may get an error that says "Kernel driver not installed" in your Virtualbox. So the first thing you should do is install your kernel source by running this: sudo apt-get install linux-headers-`uname -r`........

Ubuntu/Gnome/Mint/Centos How To Take a partial screenshot

By default printscreen or alt print screen will get the whole desktop or the application in focus, respectively. But what if you want to select a portion of the screen? gnome-screenshot: ksnapshot compiz This is a nicely integrated solution sudo apt-get install compizconfig-s........

Cisco IP Phone How To Reset To Factory Settings Instructions CP 9971, 8800, 8900, 8845, 8851, 8841, 8831, 7961, 7960, 7945, 7942, 7941, 7940.

This would be crucial especially if the phone is hardened, not being able to reset or change settings could prevent a phone registering in a new environment or even when migrating from office to office. This applies even if you are trying to migrate the phone to another platform such as Asterisk/FreePBX etc... This guide applies to nearly all of the Cisco IP phones that you would use in CME or CUCM from several years ago including models: 9900, 9971, 8800, 8900, 8845, 8851, 8841........

Cisco Unified Communications Manager / CUCM IP 8.6,10,12 Install Error Solution

Install Errors on Version 12: This error happened on QEMU emulator version 2.11.1 pve-qemu-kvm_2.11.1-5 on Proxmox/Debian but installing on QEMU.12 on Centos 6 did not produce the error. *Update it is not related to the OS or QEMU version. This happened in Centos 6 too after a second install. What really causes this even though you successfully install........

Cisco Unified Communications Manager 12 Install Errors on Proxmox/KVM

The strange thing is that usually the first install or two will work on any new machine but then it suddenly won't. I had this experience on QEMU 2.13 on a different machine. There is something finicky or buggy about the CUCM installer even when choosing the same virtual hardware specs. qemu-kvm command: /usr/libexec/qemu-kvm -version QEMU PC emulator version 0.12.1 (qemu-kvm-0.12.1.2-2.506.el6_10.1), Copyright (c) 2003-2008 Fabrice Bellard ........

Microsoft SQL Server Check What Version is Running

This may sound silly but often on the same machine multiple versions of SQL may be installed due to other applications. How do we know which one we are running and connected to? Use the query: select @@version ........

letsencrypt certbot error "Unable to find a virtual host listening on port 80 which is currently needed for Certbot to prove to the CA that you control your domain. Please add a virtual host for port 80."

./certbot-auto --apache certonly Saving debug log to /var/log/letsencrypt/letsencrypt.log Plugins selected: Authenticator apache, Installer apache No names were found in your configuration files. Please enter in your domain name(s) (comma and/or space separated) (Enter 'c' to cancel): yourdomain.com Obtaining a new certificate Performing the following challenges: http-01 challenge for yourdomain.com Cleaning........

VMWare Pro Workstation Nic Disconnected and No IP Using NAT

By default VMWare Workstation often doesn't work as we would like. If you create a VM with a default NAT IP it won't work you will find the NIC is disconnected (even though on the VMWare side it says connected including at Power On). How To Solve It 1.) Create New VMNet for NAT Click "Edit" -> "Virtual Network Editor" Click "Add Network" Select Network To Add "VMNet1" (........

hwloc-nox set CPU affinity in Linux

sudo apt-get install hwloc-nox Reading package lists... Done Building dependency tree Reading state information... Done The following NEW packages will be installed: hwloc-nox 0 upgraded, 1 newly installed, 0 to remove and 530 not upgraded. Need to get 151 kB of archives. After this operation, 453 kB of additional disk space will be used. Get:1 http://archive.ubuntu.com/ubunt........

VMWare Hardware virtualization is selected and cannot be deselected due to selection of VBS Insufficient resources to satisfy configured failover level for vSphere HA.

There is no such option as "VBS" that Ican see in vSphere 6.7 Ibelieve this is actually an issue because of using old hardware in this case L5420 doesn't support Nested Virtualization I believe. Hardware virtualization is selected and cannot be deselected due to selection of VBS Insufficient resources to satisfy configured failover level for vSphere HA.........

Debian Mint Ubuntu compiling xmr-stak

sudo apt-get install libcurl4-openssl-dev git build-essential autotools-dev autoconf libcurl3 sudo apt-get install libcurl4-gnutls-dev git clone https://github.com/wolf9466/cpuminer-multi sudo apt-get install cmake libpthread-* libmicrohttpd-dev libssl-dev libhwloc-dev git clone https://github.com/fireice-uk/xmr-stak-cpu.git make install cd bin chmod +x xmr-stak-cpu ./xmr-stak -O xmr........

linux mint image convert menu option missing solution

Ialready have the caja-image-converter option installed but it shows nothing. Weirdly enough if you install nemo and nautilus converter it does show and work inside caja: The solution is to install *-image-converter sudo apt-get install *-image-converter Reading package lists... Done Building dependency tree Reading state information... Done Note, selecting 'n........

ImageMagick How To Convert Specific PDF Pages or a Range

A very handy feature of ImageMagick's convert command is that it can convert PDF's to other image formats like jpg but did you know you can even manually select a range or specific pages from the PDF? Here is an example of converting a range of pages from a PDF in this case pages 25 to 36: convert -density 300 "vSphere 6.5-1.pdf[25-36]" vsphere.jpg Here is an example of converti........

VMWare 6.7 VCSA VSphere ESXi Management SSO Install Guide on Linux using the CLI

#mount the VCSA DVD mount /dev/sr0 /mnt/cd #alternatively you could mount the iso directly mount -o loop vcsa.iso /your/mount/path #for this purpose we are using the CLI installer on Linux cd /mnt/cd/vcsa-cli-installer/lin64 #no it's not going to be that easy you can't just run vcsa-deploy like that you need to use a template or configured .json file ./vcsa-deploy Usage: vcsa-deploy [-h] [--version] [--supported-deploymen........

Linux Mint Black Screen after boot no graphics solution

This is not the normal "black screen"issue and I was shocked to eventually find out why. The normal advice of reconfiguring Xorg didn't work. Even booting into "Recovery Mode" did not help. Here is the short end of the stick that fixed it: sudo apt-get install mdm mate-desktop-environment Yes you got it right, mdm and the mate-desktop-environment / gnome were somehow uninstalled. This must be whe........

Mozilla Firefox Address Bar History Not Working places.sqlite corruption solution database repair

Here is the only solution Ifound that works in Firefox: *Note you could basically just copy all of the commands in bold (the rest just shows the output) Install sqlite3 sqlite3 places.sqlite sqlite> .clone places.sqlite-fixed moz_places... done moz_historyvisits... done moz_inputhistory..........

MySQL How To Grant Access To ALL Databases For Export and Backup Purposes

GRANT SELECT, LOCK TABLES ON *.* TO yourmysqluser@localhost; All you need to do a full MySQL dump on all databases is the SELECT and LOCK TABLES privileges. This way you don't have to use the mysql root user. Data could be compromised this way but at least no harm from manipulation, changes or deletion are possible by locking down the privileges to the minimum for a full MySQL dump and backup.........

M2Crypto.SSL.Checker.WrongHost: Peer certificate subjectAltName does not match host, expected fedora-archive.ip-connect.vn.ua, got DNS:mirror.ip-connect.vn.ua

You are using Centos 5 which is deprecated so nothing in yum will work until you follow this post to use the vault: http://realtechtalk.com/Centos_59_Working_Vault_Repo_file-1921-articles yum update Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * epel: fedora-archive.ip-connect.vn.ua Traceback........

ffmpeg Linux Mint download, compile and install howto

#if you have nvidia make sure you install the nvidia-cuda-toolkit so hardware acceleration can be used wget http://ffmpeg.org/releases/ffmpeg-3.3.2.tar.bz2 tar -jxvf ffmpeg-3.3.2.tar.bz2 cd ffmpeg-3.3.2/ ./configure --disable-yasm install prefix /usr/local source path ........

Nvidia Linux Mint/Ubuntu screentearing horizontal line solution

Finally after ages I found the solution which is on many pages on the net but not obvious and should have been standard or more common info! Instant Solution: Type this into the terminal (unfortunately the driver config menu doesn't have the option as itis hidden): nvidia-settings --assign CurrentMetaMode="nvidia-auto-select +0+0 { ForceCompositionPipeline = On }" Make permanent Cli........

Openshot 2.2 is very unstable always crashing in Linux Mint 18.1!

Jun 1 15:45:42 videoeditor-desktop org.mate.panel.applet.MintMenuAppletFactory[1882]: project_data:INFO Missing folder chosen by user: Jun 1 15:45:42 videoeditor-desktop org.mate.panel.applet.MintMenuAppletFactory[1882]: project_data:INFO Removed missing file: MAH02949.MP4 Jun 1 15:45:57 videoeditor-desktop org.mate.panel.applet.MintMenuAppletFactory[1882]: ui_util:WARNING Icon theme media-playback-start not found. Will use backup........

Linux Mint 17 How to Enable File Sharing Option in File Manager

I still cannot understand how this would not be enabled by default and I struggled to find the reason why with manually installing samba etc.. wondering why the option for sharing was not in the menu. On Linux Mint "MATE" the package is called "caja-share" and on Cinnamon it is called "nemo-share" so edit the below command as necessary: *Also note that the "samba" package is necessary as it is not inst........

SAS2008 LSI 9200-E Linux Upgrade Flash Firmware with sas2flash

Download from here http://www.avagotech.com/products/server-storage/host-bus-adapters/sas-9200-8e#downloads sudo Installer_P20_for_Linux/sas2flash_linux_i686_x86-64_rel/sas2flash -listall LSI Corporation SAS2 Flash Utility Version 20.00.00.00 (2014.09.18) Copyright (c) 2008-2014 LSI Corporation. All rights reserved &nbs........

Windows showing wrong drive size after resizing the VPS/image or cloning howto fix

How to Increase The Disk and Partition Size in Windows 2022,2019,11,10,8,7 etc.. Server 1, Enter the command prompt Start -> cmd 2. Start diskpart diskpart 3. Find the drive that has the wrong size list volume 4. Select the volume (in this example we use volume 2) select volume 2 5. Extend the volume........

Mysql how to backup/copy row from one table to another

INSERT INTO articles_backup SELECT * FROM articles WHERE articleID="118" It is so simple we always recommend people do this when updating their database so you always have a backup. The above inserts the copy into the table "articles_backup" which has an identical structure. It selects the entry from "articles" where the articleID is "118" but of course you can adapter yours to whatever the situation is.........

Virtualbox errors on Ubuntu/Debian/Mint

The solution was to reinstall the vbox dkms package and do a manual modprobe of the modules it makes. I never sorted out the unable to start due to the USB issue, I did have the guest additions installed but the only way to boot was to change the pointing device from USB to PS2 and then to disable the USB controller (if your pointing device is set as USB, disabling USB will not work because it will re-enable by default when it sees your pointing device is USB, this is w........

Installing zoneminder on Ubuntu/Debian Linux Howto

sudo apt-get install zoneminder [sudo] password for one: Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: libuser-perl python-evince kdebase-apps kwrite unixodbc libgnomeprint2.2-data python-soappy vgabios python-metacity hddtemp python-mediaprof........

Dell CS24-NV7 lspci dmidecode info

0000:00:00.0 RAM memory: NVIDIA Corporation MCP55 Memory Controller (rev a2) 0000:00:01.0 ISA bridge: NVIDIA Corporation MCP55 LPC Bridge (rev a3) 0000:00:01.1 SMBus: NVIDIA Corporation MCP55 SMBus (rev a3) 0000:00:02.0 USB controller: NVIDIA Corporation MCP55 USB Controller (rev a1) 0000:00:02.1 USB controller: NVIDIA Corporation MCP55 USB Controller (rev a2) 0000:00:05.0 IDE interface: NVIDIA Corporation MCP55 SATA Controller (rev a3) 0000:00:05.1 I........

MySQL Allows blank user with no password to login

I just realized I have some blank users which I deleted butI can still login to this dummy account without a password for some reason. mysql -u -p Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 5 Server version: 5.1.69 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation an........

Dell FS12-NV7 2U Server Information and Guide

I've got one of these for testing projects from work at home and got more than I bargained for with the time I've spent on it due to the storage handing/Perc 6/i cards. My particular model came with the following: 2U Rack Mount Server with Rails 2xOpteron 2373 EE (Quad Core, there is a 6-core version that can be found at times) 16GB RAM 2 x 250GB Seagate SATA 2 x Dell Perc 6/i (horrible and a nightmare to work........

MySQL HowTo Copy Duplicate a Table for backup purposes

This is a great way to test and experiment without risking your current table, or to make a backup of your current table to avoid corruption or dataloss due to malicious activity eg. deletion etc.. There are two steps and two commands 1.)Copy Table Structure "cars_backup" is the new table and it will be a copy of the table called "cars"........

MySQL Show Print List of Field Names only without other data or attributes

SELECT column_name FROM information_schema.columns W........

WD 20EARX Dead Again

Another new drive bad from the start: Jun 2 15:14:18 one-desktop kernel: [15895.386779] ata2.00: exception Emask 0x50 SAct 0x1 SErr 0x280900 action 0x6 frozen Jun 2 15:14:18 one-desktop kernel: [15895.386782] ata2.00: irq_stat 0x08000000, interface fatal error Jun 2 15:14:18 one-desktop kernel: [15895.386784] ata2: SError: { UnrecovData HostInt 10B8B BadCRC } Jun 2 15:14:18 one-desktop kernel: [15895.386788] ata2.00: cmd 60/0........

WD 20EARX 2TB Bad within days

This is just trying to read 5GB off the drive with dd and the drive initially tested ok but shortly after I wondered why I was seeing 2MB/s read speeds. Notice the "current_pending_sector", anytime I've seen it at anything above 0 even with no other bad fields/attributes, it means the drive is bad. ata1.00: exception Emask 0x0 SAct 0x3 SErr 0x0 action 0x0 ata1.00: irq_stat 0x40000008 ata1.00: failed command: READ FPDMA QUEUED ata1.00: cmd 60/00:00:........

Country List Names in HTML Select From

This is useful for developing a lot of applications, I'm putting it here to keep it handy for myself and hopefully others: Choose CountryCanadaJapanUnited StatesUnited KingdomAfghanistan........

Samsung Galaxy Note I717M Canadian Version, Root and Unlock

I chose this because I heard a lot of stories about scams and that many providers I contacted said they can't unlock the Canadian I717s (one said "my Bell server" is down). This method worked perfectly on my Bell I717M and should work for all I717 in Canada, I was able to insert a foreign SIMcard. This will work abroad too but remember entering CWM mode is different for I717's in other countries (at least theUS). Step 1 - Root + CWM........

Bad Hard Drive Slows Down Computer

Here's a proven example of what a bad hard drive can do, it was technically functioning OKin a RAID array but the system became extremely low and the load become high and IOWAIT was even higher and I always thought it was a bad application. The truth is that this failing 1TBHitachi has slowly gotten worse and caused huge slowdowns, (eg. 100% load on Thunderbird waiting for e-mails to load etc..). After swapping it out, tabs change instantly, emails are not lagged, and........

Samsung Galaxy Note ICS Corrupting microSDHC partition table?

This was partitioned as a single 32GB VFAT but when I inserted it into the phone it said that it can't read it and now here is how the partition table looks. Interestingly enough the data works and reads fine from the computer still. Disk /dev/sdb1: 32.1 GB, 32085360640 bytes 64 heads, 32 sectors/track, 30598 cylinders, total 62666720 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum........

Lantronix KVM/IP Keyboard/Mouse not working in BIOS before booting the OS

I've run into two issues with Lantronix based KVMs on various servers and here's how I solved them (with that said I like these units as they are Java based and OS independent and work very well, unike some other models like Startech). 1.) If you are connected by USB only and you're sure USB support from the BIOS is enabled, you just need to click the following in Lantronix Interfaces -> Keyboard/Mouse Check "Force USB Full Speed Mode", this fixed the issu........

mdadm: /dev/sdb1 not large enough to join array solution

mdadm --manage /dev/md1 --add /dev/sdb1 mdadm: metadata format 00.90 unknown, ignored. mdadm: metadata format 00.90 unknown, ignored. mdadm: metadata format 00.90 unknown, ignored. mdadm: /dev/sdb1 not large enough to join array md1's first primary member /dev/sda3 has 57394 cylinders while the /dev/sdb1 has 57393 (1 less cylinder) which is why it won't work. fdisk -l /dev/sda3 Disk /dev/sda3: 47........

MySQL how to copy/duplicate a table

CREATE TABLE articles_backup LIKE articles The code above creates a new table called "articles_backup" which has the exact same structure and attributes as the original articles table. CREATE TABLE articles_backup SELECT * FROM articles; The above code does the same thing as the first example, BUT it also copies all of the data.........

HowTo Migrate and Import iPhone/Outlook Contacts into Android without using GMail using .vcf files

I searched for days after getting my Galaxy Note and couldn't find a way to do this (at least not without buying programs for either Android/Windows). All I read was ways to sync and import the contacts to GMail but I don't want to use GMail for privacy reasons. GMail/Google steal all of your personal information and use it for whatever purposes they want to and may sell or release it to who knows where (I don't care what their policy says but this stuff happens), just like the default........

Could not display "trash:///". Error: DBus error org.freedesktop.DBus.Error.NoReply: Did not receive a reply. Possible causes include: the remote application did not send a reply, the message bus security policy blocked the reply, the reply timeout

Could not display "trash:///". Error: DBus error org.freedesktop.DBus.Error.NoReply: Did not receive a reply. Possible causes include: the remote application did not send a reply, the message bus security policy blocked the reply, the reply timeout expired, or the network connection was broken. Please select another viewer and try again. This happened in Ubuntu but only because I was trying to delete millions of files at once and i........

vino crashed/stopped working, restart vino manually without rebooting

The normal solution would be as follows: export DISPLAY=:0.0 /usr/lib/vino/vino-server & But what happens if that doesn't work? I haven't been able to find much documentation about how to find the list of displays and how their numbering works in Xorg. Sometimes you'll get this error when trying to restart vino: Cannot open display: For some reason my display is not on 0.0........

Linux Out of Memory OOM Object Killer Solution "Out of memory: kill process 1955 (sshd) score 81 or a child"

I had a system running a 128MB live CD image with 2.8 gigs of available RAM and the OOM kernel killer went crazy when using dd for more than 8 minutes and kept killing everything. I've read that this is due to a low-memory issue and paging in the kernel and 32-bit systems with lots of RAM. I even enabled swapspace on my LiveCD and the issue happened 25 minutes into dd rather than 8 minutes, so what gives? Also no swap space was ever used! cat /proc/s........

How To Test If Your Hard Drive Is Good/Signs of dying hard drive

I like dd, although it only reads it, usually a read test of the entire disk will uncover if your hard drive is bad in some parts. This is a good thing to do at least once a month, a lot of times bizarre program behavior, laginess and crashing/unnmounting problems etc.. are due to a failing disc and SMART won't know it or indicate a problem: We must also remember there's never a guarantee, I've found that ever since we moved to larger and more platters per drive with 1TB drives........

smart is not smart, it thinks a dead drive is still good

I had a dying drive that smart thought until it totally disappeared was a good drive, and actually all parameters did look fine but this system was causing my system to lockup and other bad behavior: === START OF INFORMATION SECTION === Device Model: WDC WD20EARS-00MVWB0 Serial Number: WD-WMAZ20139 Firmware Version: 50.0AB50 User Capacity: 2,000,398,934,016 bytes Device........

Hitachi 2TB HDS5C3020ALA632 drive DOA

I had one of these shipped and it was not recognized when plugged in, here's what a dead drive looks like (I assume it's teh circuit board which is dead): ata1: link is slow to respond, please be patient (ready=0) ata1: softreset failed (device not ready) ata1: SATA link up 3.0 Gbps (SStatus 123 SControl 300) ata1: link online but device misclassified, retrying ata1: link is slow to respond, please be patient (ready=0) ata1: softreset f........

mysql enable slow query logging/Query Cache Solution - find/track cause of slow mysqld/high IO/CPU usage

If you have a webserver and find you have high IO/lagginess MySQL is one of the first things to check. It turns out MySQL was my problem and it was creating a high load on my server, especially for IO. How to Enable MySQL Slow Query Logging To Find Slow Performance/Queries vi /etc/my.cnf Add this anywhere under [mysqld] #slow queries log-slow-queries = /var/log/mysql/mysqlslowqueries.log long_query_time = 1........

Plesk Get List of E-mail Users & Aliases

When migrating away from Plesk I couldn't figure out an easy way to get a straight list of all e-mails, but here is where I found the solution: http://nakuls77.wordpress.com/2008/08/30/details-of-email-ftp-database-users-from-psa-database/ mysql> SELECT mail.mail_name, accounts.password, domains.name FROM mail, accounts, domains WHERE domains.id=mail.dom_id AND mail.account_id=accounts.id; mysql> SELECT CONCAT(mail.mail_name,’@’,domains.name) AS Em........

Ubuntu/Debian DRBD 8.0 Setup Guide

I've only used it on Centos, soI thought I'd make a quick Debian guide: Install the DRBD Package apt-get install drbd8-utils Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: libswfdec-0.8-0 Use 'apt-get autoremove' to remove them. The following........

WD (Western Digital) Advanced Format Drive Lagged/Slow Speed/Performance/Design Flaw EAD/EARS problem WDC WD20EARS-00S8B1

Let the numbers speak for themselves, from what I read the Load_Cycle_Count which is very high (more than 500,000/half a million times) is the number of head parks. What a stupid"Green" design and design flaw which will probably mean an early life for the drive. This is almost as silly as Seagate's new reputation for BSY/poor quality disks since the 7200.11 series. To make it worse this is also when Western Digital introduced "Advanced Format" o........

Wine stopped working/won't work Solution

After an upgrade wine wouldn't open anything, not even the pre-installed notepad. There are no wine logs and nothing is mentioned in any standard log file about why. I finally decided to run wine from the shell and see what's going on: wine client error:0: version mismatch 398/402. Your wineserver binary was not upgraded correctly, or you have an older one somewhere in your PATH. Or maybe the wrong wineserver is still running?........

Error: DBus error org.freedesktop.DBus.Error.ServiceUnknown: The name :1.1127 was not provided by any .service files Please select another viewer and try again.

This is an SFTP mount that does not work or prompt for password. Error: DBus error org.freedesktop.DBus.Error.ServiceUnknown: The name :1.1127 was not provided by any .service files Please select another viewer and try again. It seems to me that the connection often times out after being opened and the application doesn't know how to handle the disconnection and doesn't realize it needs to kill the instance and restart the connection.........

FUSE/Curlftpfs mount ftp account as drive partition in Linux

This is a great way to use your ftp server space, for example on your web hosting account (althoughI believe many hosts don't allow storage like this), but if you have a VPS/Dedicated Server etc.., this would be perfect. Imagine how easy it is to work with an ftp account that you can just mount as a normal partition or directory in Linux, it would be great for backups etc.. Name curlftpfs - mount a ftp host as a local directory Synopsis........

Use rcconf to edit startup/init.d/init scripts on Debian/Ubuntu based distributions

I've never understood how to enable and disable services for different run levels in Debian based distros, it's just weird, annoying and doesn't make sense. I much prefer chkconfig from RHEL. Just install the package called 'rcconf' and be done with it. rcconf makes things easy for you. apt-get install rcconf Reading package lists... Done Building dependency tree Reading state information... Done........

Seagate Drive 500GB Drive Dying

This drive is clearly on the way out, the Kernel knows it but I'm surprised that SMART is not concerned. I didn't blame Seagate for their past issues until now. This hard drive has hardly been used and has not even been powered on for a year according to SMART. Home page is http://smartmontools.sourceforge.net/ === START OF INFORMATION SECTION === Model Family: Seagate Barracuda 7200.11 Device........

Seagate 7200.11 firmware defect in 500GB, 1000GB (1TB) and 1500GB (1.5TB) Hard Drives

Seagate Inventory/Firmware Check I heard about this issue a long time ago but never looked into it. I figured I wasn't affected since my 500GB drives were running for so long. I've been using Seagate's since 2002 and to this day all of the drives I have are alive from Seagate. *Update the bad news is that I realize one of my 500GB's is about to die, it's not even a year old, but is also not affected by the recall according to Seagate! Seagate Inventory/Firm........

XMPP Chat Protocol using Jabber - Guide Tutorial Setup Linux Chat Server

In Debian based distros: apt-get install jabber Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: fakeroot dkms Use 'apt-get autoremove' to remove them. The following extra packages will be installed: jabber-common The following NEW packag........

PHP cannot access /usr/bin/openssl

PHP cannot access /usr/bin/opensslI have verified the username that runs the process is able to access /usr/bin/openssl and it does exist but the PHP script is saying it doesn't exist: [code:1:1fd0f3abbe] if (!file_exists($OPENSSL)) { //echo "ERROR: OPENSSL $OPENSSL not foundn"; }[/code:1:1fd0f3abbe] I don't get itI can clearly see the contents of /usr/bin by using the PHP system fu........

HTML Create DropDown List

HTML Create DropDown List[code:1:309976db0d] Text To Display [/code:1:309976db0d]........

JavaScript get valued of selected <select> drop down l

JavaScript get valued of selected drop down l [code:1:4be190f44a]Package = OrderForm.package.options[OrderForm.package.selectedIndex].value;[/code:1:4be190f44a] OrderForm = Name of HTML form the SELECT is inside package = Name of SELECT element eg. JavaScript says form name is not defined even though it is I've integrated this into my design and I got an error saying the Form Name i........

Photoshop Center A Selection

Photoshop Center A SelectionYou should have the item in it's own layer, select the layer and use CTRL+A to select the layer. Then look for the alignment controls near the top of the screen (under the menus) Use the Horizontal Center and Vertical Center and then your item will be perfectly centered.........

CREATE Database/Granting Privileges

CREATE Database/Granting PrivilegesCREATE your first database Code: [code:1:0668cd8e74]CREATE database myfirstdb; [/code:1:0668cd8e74] CREATE a user for your first database This one creates the user 'sqladmin' and gives them 'usage' on your new database 'myfirstdb' Code: [code:1:0668cd8e74]mysql> GRANT usage on myfirstdb.* to sqladmin@localhost; Query OK, 0 rows affected (0.00 sec)[/code:1:0668........

MySQL SELECT with multiple where conditions

MySQL SELECT with multiple where conditionsI can get a match on rows for now apparent reason [quote:09cf04e097]SELECT * FROM TABLE WHERE field = 'value' & value = 'field' [/quote:09cf04e097] To make it work as expected use 'AND' instead of '&' they seem to have a completely different and unexpected effect. [quote:09cf04e097]SELECT * FROM TABLE WHERE field = 'value' AND value = 'field' [........

MySQL SubQuery

MySQL SubQueryI was trying to do a sub-query here but it wouldn't work (Syntax Error) in MySQL for some reason even though based on the SQL standards it should be ok. [i:1268bfa39e][b:1268bfa39e]I found the reason this doesn't work. I am using MySQL 3.23 and I read on the MySQL web site that versions before 4.1 DO NOT SUPPORT SUB-QUERIES so it showed me how to rewrite the following as a LEFT join instead of a sub-query. [/b:1268bfa39e][/i:1268bfa39e]........

Create Table with structure of another existing table

Create Table with structure of another existing tableOk, this has many valid uses such as if you need to create backups or the ability to undo changes, you would want to create new tables with the same structure as another. Here is how you do it. [i:7ed9581493] Also remember Indexes such as PRIMARY KEYS [b:7ed9581493]will not be preserved[/b:7ed9581493] so you will have to readd them manually.[/i:7ed9581493] [code:1:7ed9581493]CREATE TABLE NewName AS SEL........

MySQL Error "ERROR 1045 (28000): Access denied for user"

This happened with a select statement which writes the result to an external file. I didn't remember the privilege "FILE" must be granted on *.* for this to work successfully, it wasn't actually an authentication issue as it implies since I was already in the SQL prompt and doing the query. SELECT some_id FROM sometable INTO OUTFILE '/tmp/result.txt'........