Reset the root password for MariaDB (or MySQL)

Submitted by donmc on Tue, 12/16/2014 - 14:26
Please note that if you haven't changed over to MariaDB - you should ... But more to the point for this post - if you need to reset your root mysql or mariadb password, the easiest way to do it on an Ubuntu platform is to run the following commands: First, you need to know what version of mysql or MariaDB you have, so run this to search for the package name: root@bazingah:/usr/local/bin# dpkg-query -S mariadb-server

PhpMyAdmin error message when the script has not been run during install...

Submitted by donmc on Mon, 11/03/2014 - 17:35

I see this fairly often when I have done fast installs of ubuntu:
"Connection for controluser as defined in your configuration failed."

What happens is I ignore the install script that needs to run for PhpMyAdmin to establish its database etc.
Happily the fix is fairly easy - just run the script again now:
sudo dpkg-reconfigure phpmyadmin

SAMBA4 issues with webmin (somewhat resolved) ... (for Ubuntu 14.04)

Submitted by donmc on Wed, 10/08/2014 - 18:53

I am surprised that there have been no updates to the webmin interface to support the new samba version (that has been rolled out to most major linux distros now) -- am I the only one that has been using webmin to do my admin on samba servers ? I think NOT...

Anyway - here is a quick and dirty fix to the start/stop entries in the webmin samba module to correct it for Version 4:

Command to stop Samba servers
service smbd stop && service nmbd stop

Command to start Samba servers
service smbd start && service nmbd start

scripted (bash) password changes for Samba users...

Submitted by donmc on Fri, 06/27/2014 - 19:49

I was excited to find this, so I am saving it here.

To change an smb passwd in a bash script:

echo -e "newpasswd\nnewpasswd" | (smbpasswd -s username)

And note the "\n" in there to push a newline between the two passwords...

For the unix (Linux) username:

echo -e "newpass\nnewpass" | (passwd --stdin username)

Use composer to install drush on Linux

Submitted by donmc on Sun, 06/15/2014 - 11:51
I have been building a new web server platform and tried to install drush using pear as I have in the past, but it is not NOT the recommended way to install it any longer (who knew?).
Drush has developed a huge cult following for it's ease of use in maintaining multiple drupal based sites very easily from the CLI. I cannot recommend drush highly enough - I can update the code for all of my sites in a few minutes - back in the gory days it would take me ages to do that... These steps worked flawlessly for me on Ubuntu 14.04 today.

Quick Image library check for PHP-GD

Submitted by donmc on Sat, 04/19/2014 - 15:16
donmc@etiikka:~$ php -r 'print_r(gd_info());' Array ( [GD Version] => 2.0 [FreeType Support] => 1 [FreeType Linkage] => with freetype [T1Lib Support] => 1 [GIF Read Support] => 1 [GIF Create Support] => 1 [JPEG Support] => 1 [PNG Support] => 1 [WBMP Support] => 1 [XPM Support] => [XBM Support] => [JIS-mapped Japanese Font Support] => )

Recently had to patch my web servers for this SSL Bug: "Heartbleed"

Submitted by donmc on Sat, 04/12/2014 - 12:47
You can install the patches (for Ubuntu 12.04 and up) with the following three commands: sudo add-apt-repository ppa:george-edison55/openssl-heartbleed-fix sudo apt-get update sudo apt-get upgrade
Any errors running "add-apt-repository" on Ubuntu 12.04, will probably mean that you need to install the "python-software-properties" package with the following command:
sudo apt-get install python-software-properties