KB Home | Advanced Search | News | Glossary | Login |
|
ASP.NET Hosting Knowledge Base |   |
How To Create Data Queries in PostgreSQL By Using the Select Command
Viewed 14352 times since Mon, Dec 30, 2013
What is PostgreSQL?PostgreSQL is an open source database management system that utilized the SQL querying language. PostgreSQL, or simply "Postgres", is a very useful tool on a server because it can handle the data storage needs of websites and... Read More
How To Setup Ruby on Rails with Postgres
Viewed 11545 times since Mon, Dec 30, 2013
IntroductionPostgres (or PostgreSQL) is an open source database. Ruby on Rails is an open source web framework written in Ruby. Rails is database agnostic, meaning it can be used with a variety of different databases. By default it assumes that... Read More
A Comparison of (Rack) Web Servers for Ruby Web Applications
Viewed 8218 times since Mon, Dec 30, 2013
Meet Ruby's RackNowadays, giving the opportunity to mix-and-match web servers with web applications and other technologies [to developers] is a very powerful, necessary and indeed in-demand aspect of any programming language and framework. A... Read More
How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Debian
Viewed 7732 times since Thu, Dec 26, 2013
About LAMPLAMP stack is a group of open source software used to get web servers up and running. The acronym stands for Linux, Apache, MySQL, and PHP. Since the virtual private server is already running Debian, the linux part is taken care of. Here... Read More
How To Install and Secure phpMyAdmin on Debian 7
Viewed 3656 times since Fri, Dec 27, 2013
phpMyAdminphpMyAdmin is a free web software to work with MySQL on the web. It provides a convenient visual front end to the MySQL capabilities. SetupBefore working with phpMyAdmin, you need to have LAMP installed on your server. If you don't... Read More
Initial Server Setup with Debian 7
Viewed 3644 times since Fri, Dec 27, 2013
The BasicsAfter you have deployed your new server instance, it is important to create a new user and provide it with root privileges. This not only makes your virtual server more secure, but also prevents any drastic system damage/change that can... Read More
Upgrading Debian to Unstable
Viewed 3559 times since Thu, Dec 26, 2013
IntroductionThis article will guide you through the process of upgrading your fresh installation of Debian to Unstable (Sid) version. Don't let the name fool you. While Debian Unstable might sometimes happen to introduce some bugs or... Read More
Initial Server Setup with Arch Linux
Viewed 3465 times since Fri, Dec 27, 2013
The BasicsWhen you first begin to access your fresh new virtual server, there are a few early steps you should take to make it more secure. Some of the first tasks can include setting up a new user, providing them with the proper privileges, and... Read More
How To Set Up Master Slave Replication in MySQL
Viewed 3293 times since Thu, Dec 26, 2013
About MySQL replicationMySQL replication is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database. This can helpful for many reasons including facilating... Read More
How To Create a SSL Certificate on Apache for Ubuntu 12.04
Viewed 3289 times since Mon, Dec 23, 2013
About SSL Certificates A SSL certificate is a way to encrypt a site's information and create a more secure connection. Additionally, the certificate can show the virtual private server's identification information to site visitors.... Read More
How To Create a New User and Grant Permissions in MySQL
Viewed 3274 times since Thu, Dec 26, 2013
About MySQLMySQL is an open source database management software that helps users store, organize, and later retrieve data. It has a variety of options to grant specific users nuanced permissions within the tables and databases—this tutorial... Read More
How To Create, Remove, & Manage Tables in PostgreSQL on a Cloud Server
Viewed 3272 times since Mon, Dec 30, 2013
What is PostgreSQL?PostgreSQL is a database management system that uses the SQL querying language. It is a very stable and feature-rich database system that can be used to store the data from other applications on your server. In this article, we... Read More
How To Install Wordpress on Ubuntu 12.04
Viewed 2591 times since Tue, Dec 24, 2013
About WordpressWordpress is a free and open source website and blogging tool that uses php and MySQL. It was created in 2003 and has since then expanded to manage 22% of all the new websites created and has over 20,000 plugins to customize its... Read More
How To Install Ruby on Rails on Arch Linux with RVM
Viewed 13812 times since Sun, Dec 29, 2013
Step One— Install Ruby with RVMBefore we do anything else, we should run a quick update to make sure that all of the packages we download to our server are up to date: pacman -SyOnce that's done, we can start installing RVM, Ruby Version... Read More
How To Install (LEMP) nginx, MySQL, PHP stack on Arch Linux
Viewed 13577 times since Sun, Dec 29, 2013
About LempLEMP stack is a group of open source software to get web servers up and running. The acronym stands for Linux, nginx (pronounced Engine x), MySQL, and PHP. Since the server is already running Arch Linux, the linux part is taken care of.... Read More
How To Install And Run A Node.js App On Centos 6.4 64bit
Viewed 10386 times since Sun, Dec 29, 2013
Node.js installationNow that we're ready to install Node.js from sources. First, we'll move to /usr/src directory - the usual place to hold software sources. cd /usr/srcNow, we pick the latest compressed source archive from Node.js website... Read More
How To Set Up an NFS Mount on Ubuntu 12.04
Viewed 10274 times since Tue, Dec 24, 2013
About NFS (Network File System) MountsNFS mounts work to share a directory between several virtual servers. This has the advantage of saving disk space, as the home directory is only kept on one virtual private server, and others can connect to it ... Read More
How To Write a Linux Daemon with Node.js
Viewed 10142 times since Sun, Dec 29, 2013
IntroductionA daemon is a program that runs in background and has no controlling terminal. They are often used to provide background services. For example, a web-server or a database server can run as a daemon. This tutorial will show you how to... Read More
Intermediate Sed: Manipulating Streams of Text in a Linux Environment
Viewed 9971 times since Fri, Dec 27, 2013
IntroductionThe sed stream editor is a powerful editing tool that can make sweeping changes with very little input. In our previous article on sed, we discussed the basics of using sed to edit text. This article will continue our introduction by... Read More
How To Manage Content Using the Ghost Blogging Platform
Viewed 8809 times since Sun, Dec 29, 2013
How to Navigate the Content InterfaceGhost's content creation interface is incredibly simple. We can access our content by going to: your_domain_name/ghost You may have to sign in with the credentials you used to create the site. After that, you... Read More
How To Use HAProxy to Set Up MySQL Load Balancing
Viewed 8155 times since Thu, Dec 26, 2013
PreludeHAProxy is an open source software which can load balance HTTP and TCP servers. In the previous article on HAProxy we configured load balancing for HTTP and in this one we'll do the same for MySQL. All your MySQL servers have to be... Read More
How To Manage Packages In Ubuntu and Debian With Apt-Get & Apt-Cache
Viewed 6742 times since Fri, Dec 27, 2013
What is Apt-Get?Apt is a command line frontend for the dpkg packaging system and is the preferred way of managing software from the command line for many distributions. It is the main package management system in Debian and Debian-based Linux... Read More
How To Use Traceroute and MTR to Diagnose Network Issues
Viewed 6654 times since Fri, Dec 27, 2013
IntroductionAn important part of administering servers is monitoring network connectivity. There are a few tools that are simple to use, but valuable to know. In this guide, we will discuss how to use a tool called traceroute to diagnose where a... Read More
How To Configure and Maintain Ghost from the Command Line
Viewed 6562 times since Sun, Dec 29, 2013
How To Control the Ghost ServiceThe Ghost application is implemented on a daemon on our server instance. This means that we can start, stop and restart it easily using Ubuntu's service command. We can control the Ghost service like any other... Read More
How To Copy Files With Rsync Over SSH
Viewed 6507 times since Fri, Dec 27, 2013
Step 1 - Setup public SSH keysOn our origin server, we will generate public SSH keys with no password: ssh-keygen -f ~/.ssh/id_rsa -q -P "" cat ~/.ssh/id_rsa.pubThis is our public SSH key that can be placed on other hosts to give us access: ssh-rsa... Read More
The Basics of Using the Sed Stream Editor to Manipulate Text in Linux
Viewed 6469 times since Fri, Dec 27, 2013
IntroductionThe sed stream editor is a text editor that performs editing operations on information coming from standard input or a file. Sed edits line-by-line and in a non-interactive way. This means that you make all of the editing decisions as... Read More
An Introduction to Linux Basics
Viewed 6411 times since Fri, Dec 27, 2013
About LinuxLinux is a free, open-source operating system. All of ASPHostPortal's offered operating systems are Linux distributions. Linux has been under active development since 1991. It has developed to become versatile and used all over the... Read More
How To Install and Use PostgreSQL on Ubuntu 12.04
Viewed 6203 times since Mon, Dec 30, 2013
Install PostgresBefore we install postgres, we should quick perform a quick update of the apt-get repository: apt-get updateOnce apt-get has updated go ahead and download Postgres and its helpful accompanying dependencies: sudo apt-get install... Read More
How To Install Git on Ubuntu 12.04
Viewed 6189 times since Mon, Dec 23, 2013
About Git Git is a distributed version control system released to the public in 2005. The program allows for non-linear development of projects, and can handle large amounts of data effectively by storing it on the local server. This tutorial will... Read More
How To Use Dokku Plugins to Access Additional Functionality
Viewed 4591 times since Sun, Dec 29, 2013
IntroductionDokku is an application deployment solution that can be used to easily launch code into a production environment. The result is that your application environment will be configured automatically and the necessary software will be... Read More
How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Arch Linux
Viewed 4483 times since Fri, Dec 27, 2013
About LAMPThe LAMP stack is a group of open source software used to get web servers up and running. The acronym stands for Linux, Apache, MySQL, and PHP. Arch Linux uses the powerful Pacman installer which can download all of the most recent,... Read More
How To Use Yaourt to Easily Download Arch Linux Community Packages
Viewed 4091 times since Fri, Dec 27, 2013
IntroductionSomething that can discourage Arch Linux newcomers is the lack of official packages downloadable with its standard package manager pacman. In this article, I hope to explain why Arch has chosen to work this way, as well as how you can... Read More
How To Set Up mod_security with Apache on Debian/Ubuntu
Viewed 4046 times since Thu, Dec 26, 2013
PreludeMod security is a free Web Application Firewall (WAF) that works with Apache, Nginx and IIS. It supports a flexible rule engine to perform simple and complex operations and comes with a Core Rule Set (CRS) which has rules for SQL injection,... Read More
How To Install Node.js with NVM (Node Version Manager) on Server
Viewed 3867 times since Sun, Dec 29, 2013
IntroductionIf you already know what Node.js is what it's for and why it's cool, then skip straight to the installation directions. If you want to know a bit more about node and it's ecosystem read on. For those who haven't... Read More
How To Install Linux, Nginx, MySQL, PHP (LEMP) Stack on Debian 7
Viewed 3845 times since Fri, Dec 27, 2013
Lemp Stack: Basic InfoLEMP stack is a group of open source software to get a server up and running. The acronym includes the Linux (L), MySQL (M), and PHP (P) of the more traditional LAMP stack, but switches out Apache for Nginx (pronounced engine... Read More
How to Get Started With mod_pagespeed with Apache on an Ubuntu and Debian Cloud Server
Viewed 3788 times since Thu, Dec 26, 2013
IntroductionOne of the more recently popular modules for Apache is mod_pagespeed. It is an output filter for Apache 2.2+ that can be configured through a variety of options through configuration files or a .htaccess file. An "output filter” is a... Read More
How To Setup a Rails 4 App With Apache and Passenger on CentOS 6
Viewed 3641 times since Thu, Dec 19, 2013
When the user creates a server instance from a vanilla image (in our case: CentOS 6.4 x64), additional system administration work is needed before a Ruby on Rails application can be run and become available online. This tutorial provides the... Read More
How To Set Up a Postfix Email Server with Dovecot: Dynamic Maildirs and LMTP
Viewed 3572 times since Mon, Dec 30, 2013
PrefaceThis tutorial is based on How To Set Up a Postfix E-Mail Server with Dovecot and picks up where the first part ended. Please go through that tutorial first. In this article, we will divorce mailboxes from system accounts using dovecot&rsquo... Read More
How To Use SuExec in Apache to run CGI Scripts on an Ubuntu
Viewed 3551 times since Mon, Dec 30, 2013
IntroductionThe Apache web server is the most popular web server in the world. It can be used to deliver static and dynamic web content to visitors in a multitude of different contexts. One of the most common ways of generating dynamic content is... Read More
How To Install and Use Memcache on Ubuntu 12.04
Viewed 3508 times since Tue, Dec 24, 2013
About MemcacheMemcache is a system that works to speed up virtual private servers by caching server information. The program allows you to allocate a specific amount of the server ram toward caching recently queried data for a certain amount of... Read More
How To Set Up Apache Virtual Hosts on Ubuntu 12.04 LTS
Viewed 3471 times since Mon, Dec 23, 2013
About Virtual Hosts Virtual Hosts are used to run more than one domain off of a single IP address. This is especially useful to people who need to run several sites off of one virtual private server. The sites display different information to the... Read More
How To Create a SSL Certificate on Apache on Arch Linux
Viewed 3327 times since Sun, Dec 29, 2013
Step One—Switch Into the Apache Config DirectoryThe first step is move into the main apache configuration directory. All of the subsequent steps will take place within the directory: cd /etc/httpd/conf Step Two—Create a Self Signed SSL... Read More
How To Set Up Apache Virtual Hosts on Debian 7
Viewed 3246 times since Fri, Dec 27, 2013
Virtual HostsVirtual Hosts are used to run more than one domain off of a single IP address. This is especially useful to people who need to run several sites off of one virtual private server-- each will display different information to the ... Read More
How To Use a Simple Bash Script To Restart Server Programs
Viewed 3218 times since Fri, Dec 27, 2013
To ensure that the most imperative programs remain online as much as possible (even after a server crash or reboot), one can create a simple bash script to check if the program is running, and if it is not, to launch it. By using cron to schedule... Read More
Geddy.JS: A No-Brainer MVC Node.js Framework
Viewed 3215 times since Sun, Dec 29, 2013
IntroductionGeddy is a full stack open source MVC framework based on ruby on rails methodology with built-in authentication module, passportjs and socket.io integration. Creating realtime secure applications in Geddy takes only a few commands; it... Read More
How To Set Up MySQL Master-Master Replication
Viewed 2885 times since Thu, Dec 26, 2013
IntroThis second installment of "Scaling Web Applications" will list out the steps necessary for scaling a mysql deployment over two server. The first article in this series laid out the steps needed to load-balance nginx over two server, and it... Read More
How To Import and Export Databases and Reset a Root Password in MySQL
Viewed 2877 times since Thu, Dec 26, 2013
How to Import and Export Databases ExportTo Export a database, open up terminal, making sure that you are not logged into MySQL and type, mysqldump -u [username] -p [database name] > [database name].sqlThe database that you selected in the command... Read More
How To Migrate a MySQL Database Between Two Servers
Viewed 2867 times since Thu, Dec 26, 2013
Transferring a database between virtual private servers can be accomplished using a SCP (Secure Copy), a method of copying files derived from the SSH Shell. Keep in mind, you will need to know the passwords for both virtual servers. In order to... Read More
How To Create and Manage Databases in MySQL and MariaDB on a Cloud Server
Viewed 2797 times since Thu, Dec 26, 2013
What are MySQL and MariaDB?MySQL and MariaDB are relational database management systems. These tools can be used on your server to manage the data from many different programs. Both implement forms of the SQL querying language, and either can be... Read More
How To Install nginx on Ubuntu 12.04 LTS
Viewed 2771 times since Tue, Dec 24, 2013
About nginxnginx is a high performance web server software. It is a much more flexible and lightweight program than apache. Set UpThe steps in this tutorial require the user to have root privileges. You can see how to set that up in the Initial... Read More
How To Install Git on Debian 7
Viewed 2693 times since Fri, Dec 27, 2013
About GitGit is a version control system distributed under the terms of the GNU General Public License v.2 since its release in 2005. It allows for non-linear development of projects and can handle large amounts of data effectively. This is the... Read More
How To Protect SSH with fail2ban on Debian 7
Viewed 2654 times since Fri, Dec 27, 2013
IntroductionHaving a server or computer connected to a network comes with a certain amount of risk. Any machine, including a server, connected to the internet is a potential target for malicious attacks. While having a well-configured firewall... Read More
How To Install Z Shell (zsh) on a Cloud Server
Viewed 2653 times since Fri, Dec 27, 2013
IntroductionZ shell, or zsh, is a shell for Linux and other Unix-like operating systems. It is built to be a drop-in replacement for the traditional bash shell. The zsh offers modern auto-completion and auto-correction, powerful scripting... Read More
How To Install an Upstream Version of Node.js on Ubuntu 12.04
Viewed 2586 times since Sun, Dec 29, 2013
About Node.jsNode.js. is a system that uses event-driven (as opposed to thread-based) programming to build scalable applications and network programs. It is especially helpful for building web servers. Written in Javascript, node.js was created... Read More
How to Add a Swap File on an Arch Linux Cloud Server
Viewed 2574 times since Fri, Dec 27, 2013
IntroductionAn easy way to increase the responsiveness of your cloud server is to add some swap space. Swap is an area of the hard drive that can be used to temporarily hold information that is usually stored in RAM. The result is that more RAM... Read More
How To Install Wordpress on Arch Linux
Viewed 2551 times since Sun, Dec 29, 2013
About WordpressWordpress is a free and open source website and blogging tool that uses php and MySQL. It was created in 2003 and has since then expanded to manage 22% of all the new websites created and has over 20,000 plugins to customize its... Read More
Installing and Using the Vim Text Editor on a Cloud Server
Viewed 2493 times since Fri, Dec 27, 2013
IntroductionOne of the most powerful text editors accessible from the command line is the vim editor. Built on the foundation of "vi", an editor dating back to 1976, vim adds additional functionality and power, while maintaining the editing style... Read More
How To Install phpMyAdmin on a LEMP server
Viewed 2416 times since Thu, Dec 26, 2013
About phpMyAdminphpMyAdmin is a free software to work with MySQL on the web—it provides a convenient visual front end to the capabilities of MySQL. SetupPrior to installing phpMyAdmin, be sure that you have LEMP installed on your server. If... Read More
How To Create a SSL Certificate on Apache for Debian 7
Viewed 2406 times since Fri, Dec 27, 2013
Background InformationA SSL certificate is a way to encrypt a site's information and create a more secure connection. While Certificate authorities can issue SSL certificates that verify the server's details, a self-signed certificate ... Read More
How to Setup and Configure an OpenVPN Server on Debian 6
Viewed 2349 times since Thu, Dec 26, 2013
Getting StartedYou will need to open an SSH connection on your cloud server as the root user or an SSH connection to a user with sudo access. This guide assumes a user with sudo access. However you can set things up using root just by stripping... Read More
What is FTP and How Is It Used?
Viewed 2332 times since Fri, Dec 27, 2013
What is FTP?FTP is a way to transfer files between hosts over the internet. It is especially helpful as a way to upload or download files to or from a site quickly. FTP clients allow connections from both anonymous and registered users. When the... Read More
A Basic MySQL Tutorial
Viewed 2288 times since Thu, Dec 26, 2013
About MySQLMySQL is an open source database management software that helps users store, organize, and retrieve data. It is a very powerful program with a lot of flexibility—this tutorial will provide the simplest introduction to MySQL How... Read More
|
||||||||||||||||||||||||||