0

Tips & Tricks : MariaDB on CentOS : Installation and first configuration

-

In order to install MySQL/MariaDB database engine on CentOS follow these:

[root@localhost ~]# yum install mariadb-server
[root@localhost ~]# systemctl enable mariadb
[root@localhost ~]# systemctl start mariadb

[root@localhost ~]# mysql_secure_installation
/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] Y
New password: 
Re-enter new password: 
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.


Remove anonymous users? [Y/n] y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] n
 ... skipping.

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!
[root@localhost ~]#

Recommended is also to deploy phpMyAdmin, if you don’t have any issues with installing web server on same box as database.

That will simplify MySQL/MariaDB management.

0

How-To : SharePoint Foundation 2010 Installation

-

Screenshots from SharePoint Foundation 2010 installation process.

(more…)

0

Code snippets : Exchange Server : Count messages submitted by user

-

In some companies performance is measured based on number of emails someone sent. regardless the reason for those emails and content, what matters the most is if someone is sending something to others. So, I was asked to produce quick count how many emails one individual sent.

Here is quick PowerShell command which I ran on Exchange 2007 Mailbox server to find requested number:

(more…)

0

Tips & Tricks : Issue with SmartCode VNC Manager License

-

Sometimes i thappens that SmartConde VNC Manager fails to activate. In that case follow steps below to fix issue with licensing:

  1. Open cmd.exe and change directory to:
    • Enterprise Edition: C:\Program Files\SmartCode Solutions\VNC Manager (Enterprise Edition)\
    • Standard Edition: C:\Program Files\SmartCode Solutions\VNC Manager (Standard Edition)\
  2. Run the following command: vncmanager.exe /licdev
  3. You will be prompted to enter a serial number. You must complete this step. After that the application will close.
  4. Start SmartCode VNC Manager normally via the start menu shortcut.

Source: SmartCode Knowledgebase

0

Tips & Tricks : Migrating Mozilla Thunderbird settings between computers

-

If you have to move Mozilla Thunderbird data from one computer to another, you can do it by simply copying files between computer.

Folder with Thunderbird profiles is located here:

%APPDATA%\Thunderbird\Profiles\

There will be at least one or more sub-folders with profile data.

What you need to copy is content of Thunderbird profile you want to migrate to new computer.

On destination computer install Thunderbird and in same folder there will be sub-folder with default profile.

Copy all file from source profile to destination and that’s it.

In case you want to create Thunderbird profile in different folder start Thunderbird with following command:

thunderbird -p

That will allow you to define location of the new profile.

How that helps with migrating Thunderbird between folders/drives or computers.

0

Tips & Tricks : ShoreTel : Logon and Logoff extension

-

Quick procedure to logon or logoff phone extension to or from ShoreTel IP phone. Steps listed below will allow to bring your phone extension to phone located in remote site and then send back to home ShoreTel IP phone. Of course both phones have to be part of same ShoreTel infrastructure (have to be managed from same ShoreTel HQ server).

(more…)

0

Games : Codes : Skyrim – Hanging Gardens quest from Urag gro-Shub

-

I had problem with task given by Urag gro-Shub (he is sitting in The Arcaneum in Winterhold). He requested to bring him book “Hanging Gardens”. Problem was that at some point, before I got quest from him, I did get that book. Regardless that quest couldn’t be completed.

If that happens only solution is to enforce book to be dropped using codes:

  • player.drop 1AD08 1 – drops the book “Hanging Gardens” even is quest for that is already started

Once book is dropped pick it up and quest will move on.

0

Tips & Tricks : Using EPEL with CentOS

-

If you use CentOS and want to add some extra packages you can use EPEL.

Extra Packages for Enterprise Linux is project created by Fedora.

In order to use repositories on CentOS first download and install RPM appropriate for your version of CentOS from here:

Method 1

http://dl.fedoraproject.org/pub/epel/

Then install it and enjoy more packages from new repo.

 

Method 2

[root@localhost ~]# yum install epel-release

Here is example from CenOS 7 how to add EPEL repositories:

(more…)

5

Tips & Tricks : Office 365 Error 30088-4 “Something went wrong”

-

What to do when Office 365 shows you message “Something went wrong”?

o365-error-30088-4-01

(more…)

0

Code snippets : Unzip file in PowerShell

-

Recently I needed to unzip file from PowerShell script. Here is result what I did use to achieve that:

$archiveDir = "C:\Downloads"
$fileZip = $archiveDir + "\file.zip"
$shell=new-object -com shell.application
$zip = $shell.NameSpace($fileZip)
foreach ($item in $zip.items())
{
 $shell.NameSpace($archiveDir).CopyHere($item)
}