- How to Install MySQL on Ubuntu 14.04 LTS? Pre-Flight Check Continue reading →
- How To Install MySQL / MariaDB on CentOS 7? MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. MariaDB Continue reading →
- How to Install mlocate (locate and updatedb Commands) on Fedora 20? One of the best tools for quickly finding files by filename is the locate command. The locate command reads one or more databases prepared by Continue reading →
- How to Install the Xfce Desktop Environment on Ubuntu 14.04 LTS? By default iaas servers running Ubuntu 14.04 don’t include a graphical desktop environment. It’s easy, however, to install the Xfce Desktop Environment on Ubuntu 14.04 LTS, if need be. Continue reading →
- How to Install mlocate (locate and updatedb Commands) on CentOS 6? One of the best tools for quickly finding files by filename is the locate command. The locate command reads one or more databases prepared by Continue reading →
- How to Update the glibc (GNU libc) on Fedora? Updating Glibc on Fedora Linux is a very simple process. Most commonly you will use the following command in the case of a security vulnerability, or perhaps just to verify that you’re running the most up-to-date library:
yum -y update glibc
In this case, yum is the rpm-based package manager for both Fedora, -y, –assumeyes gives yes as an answer to any question which would be asked by running the command, the update is for updating the package, and Glibc is the package you’re updating!
Assuming your server needed a new version of Glibc and was thus upgraded, reboot your server to complete the process!
- How to Install MariaDB 5.5 on Ubuntu 14.04 LTS? MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.Pre-Flight Check
- These instructions are intended for installing MariaDB 5.5 on a single Ubuntu 14.04 LTS node (without MySQL already installed).
- I’ll be working from an iaas Self Managed Ubuntu 14.04 LTS server, and I’ll be logged in as a non-root user, but with sudo access. For information on giving a user sudo access visit our page on How to Add a User and Grant Root Privileges on Ubuntu 14.04.
Step #1: Add the MariaDB Repository
The software-properties-common package should already be installed, but just in case:
sudo apt-get install software-properties-common
To find which repo you should use with the MariaDB repository generator. We’re going to add the Ubuntu 14.04 “trusty” MariaDB 5.5 repository.
We’ll import the MariaDB public key used by the package management system:
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
Then we’ll add the MariaDB repository:
sudo add-apt-repository 'deb http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu trusty main'
Now reload the package database:
sudo apt-get update
Step #2: Install MariaDB
At this point, installing MariaDB is as simple as running just one command:
sudo apt-get install mariadb-server
You may receive the following prompt or something similar:
After this operation, 116 MB of additional disk space will be used.
Do you want to continue? [Y/n]Enter Y to continue.
Next, you’ll be asked:
New password for the MariaDB “root” user:
This is an administrative account in MariaDB with elevated privileges; enter a strong password.
Then you’ll be asked to verify the root MariaDB password:
Repeat password for the MariaDB “root” user:
That’s it! Your basic MariaDB installation is now complete!
Be sure to stop MariaDB before proceeding to the next step:
sudo service mysql stop
Step 3: Configure and Secure MariaDB for Use
Now we’ll instruct MariaDB to create its database directory structure:
sudo mysql_install_db
Start MariaDB:
sudo service mysql start
And now let’s secure MariaDB by removing the test databases and anonymous user created by default:
sudo mysql_secure_installation
You’ll be prompted to enter your current password. Enter the root MariaDB password set during installation:
Enter current password for root (enter for none):
Then, assuming you set a strong root password, go ahead and enter n at the following prompt:
Change the root password? [Y/n] n
Remove anonymous users, Y:
Remove anonymous users? [Y/n] Y
Disallow root logins remotely, Y:
Disallow root login remotely? [Y/n] Y
Remove test database and access to it, Y:
Remove test database and access to it? [Y/n] Y
And reload privilege tables, Y:
Reload privilege tables now? [Y/n] Y
Step 4: Verify MariaDB Installation
You can check the version of the MariaDB installation with the following command:
mysql -V
Enter the MariaDB command client:
mysql -p
You’ll be asked for the root password for the MariaDB server, which was set earlier in this tutorial:
Enter password:
And then you should be greeted with the following:
Welcome to the MariaDB monitor. Commands end with; or \g.
Your MariaDB connection id is 34
Server version: 5.5.41-MariaDB-1~trusty-log mariadb.org binary distributionCopyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [(none)]>
Exit the command line with the following command:
exit
To stop MariaDB:
sudo service mysql stop
To start MariaDB:
sudo service mysql start
To check the status of MariaDB:
sudo service mysql status
To restart MariaDB:
sudo service mysql restart
- How to Install Squid (Caching / Proxy) on Fedora 21? Squid is a caching and forwarding web proxy. It is most often used in conjunction with a traditional LAMP stack (Linux, Apache, MySQL, PHP), and can be used to filter traffic on HTTP, FTP, and HTTPS, and increase the speed (thus lower the response time) for a web server via caching.Pre-Flight Check
- These instructions are intended specifically for installing Squid on a single Fedora 21 node.
- I’ll be working from an iaas Self Managed Fedora 21 server, and I’ll be logged in as root.
Step #1 Install Squid
First, clean-up yum:
yum clean all
As a matter of best practice we’ll update our packages:
yum -y update
Installing Squid and related packages is now as simple as running just one command:
yum -y install squid
Step #2: Verify and Checking the Version of the Squid the Installation
Use the following command to view information about the ‘squid’ command:
squid -h
Use the following command to check the version number of Squid and the configuration options it was started with:
squid -v
Your results should appear similar to:
Squid Cache: Version 3.4.7
configure options: ‘–build=x86_64-redhat-linux-gnu’ ‘–host=x86_64-redhat-linux-gnu’ ‘–program-prefix=’ ‘–prefix=/usr’ ‘–exec-prefix=/usr’ ‘–bindir=/usr/bin’ ‘–sbindir=/usr/sbin’ ‘–sysconfdir=/etc’ ‘–datadir=/usr/share’ ‘–includedir=/usr/include’ ‘–libdir=/usr/lib64’ ‘–libexecdir=/usr/libexec’ ‘–sharedstatedir=/var/lib’ ‘–mandir=/usr/share/man’ ‘–infodir=/usr/share/info’ ‘–exec_prefix=/usr’ ‘–libexecdir=/usr/lib64/squid’ ‘–localstatedir=/var’ ‘–datadir=/usr/share/squid’ ‘–sysconfdir=/etc/squid’ ‘–with-logdir=/var/log/squid’ ‘–with-pidfile=/var/run/squid/squid.pid’ ‘–disable-dependency-tracking’ ‘–enable-eui’ ‘–enable-follow-x-forwarded-for’ ‘–enable-auth’ ‘–enable-auth-basic=DB,LDAP,MSNT,MSNT-multi-domain,NCSA,NIS,PAM,POP3,RADIUS,SASL,SMB,getpwnam’ ‘–enable-auth-ntlm=smb_lm,fake’ ‘–enable-auth-digest=file,LDAP,eDirectory’ ‘–enable-auth-negotiate=kerberos’ ‘–enable-external-acl-helpers=LDAP_group,time_quota,session,unix_group,wbinfo_group’ ‘–enable-storeid-rewrite-helpers=file’ ‘–enable-cache-digests’ ‘–enable-cachemgr-hostname=localhost’ ‘–enable-delay-pools’ ‘–enable-epoll’ ‘–enable-icap-client’ ‘–enable-ident-lookups’ ‘–enable-linux-netfilter’ ‘–enable-removal-policies=heap,lru’ ‘–enable-snmp’ ‘–enable-ssl’ ‘–enable-ssl-crtd’ ‘–enable-storeio=aufs,diskd,ufs,rock’ ‘–enable-diskio’ ‘–enable-wccpv2’ ‘–enable-esi’ ‘–enable-ecap’ ‘–with-aio’ ‘–with-default-user=squid’ ‘–with-dl’ ‘–with-openssl’ ‘–with-pthreads’ ‘build_alias=x86_64-redhat-linux-gnu’ ‘host_alias=x86_64-redhat-linux-gnu’ ‘CFLAGS=-O2 -g -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong –param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fpie’ ‘LDFLAGS=-Wl,-z,relro -pie -Wl,-z,relro -Wl,-z,now’ ‘CXXFLAGS=-O2 -g -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong –param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fpie’ ‘PKG_CONFIG_PATH=:/usr/lib64/pkgconfig:/usr/share/pkgconfig’Step 3: Configure Squid to Start on Boot
And then start Squid:
systemctl start squid
Be sure that Squid starts at boot:
systemctl enable squid
To check the status of Squid:
systemctl status squid
To stop Squid:
systemctl stop squid
- How to Install Squid (Caching / Proxy) on CentOS 7? Squid is a caching and forwarding web proxy. It is most often used in conjunction with a traditional LAMP stack (Linux, Apache, MySQL, PHP), and can be used to filter traffic on HTTP, FTP, and Continue reading →
- How to Install Squid (Caching / Proxy) on Ubuntu 14.04 LTS ? Squid is a caching and forwarding web proxy. It is most often used in conjunction with a traditional LAMP stack (Linux, Apache, MySQL, PHP), and can be used to filter traffic on HTTP, FTP, and Continue reading →