How Can We Help? Search Print Editing the pg_hba.conf file on a postgresql database server so that a specific (other) server will be able to connect to the postgresql database server. Example: Say I have a server where all of my postgresql databases are running and I have an application on another server that needs to access a database from the database server. To make this possible I need to...
How to send the output of a PostgreSQL query to a CSV file using the CLI (Command Line Interface)
How Can We Help? Search Print Log into the PostgreSQL interface on the command line, you should see a similar screen like the one below Welcome to psql 8.1.21, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit ...
How to view your PostgreSQL history
How Can We Help?
Search
Print PostgreSQL stores all the history SQL commands that were executed in the .psql_history file within your home directory
To view it execute the command below
cat ~/.psql_history
How to package/ backup a CPanel account from the command line
How Can We Help?
Search
Print This can be done by running the /scripts/pkgacct script from the cli. Running this command will create a cpmove archive which can be used to restore on another cpanel server.
Usage:
/scripts/pkgacct [arguments] username destination
Example:
/scripts/pkgacct accountusername /tmp
The above command will create a full backup and store the archive in the tmp directory.
Receive a copy for Outgoing Emails from a specific address on a CPanel server with Exim
How Can We Help? Search Print Within Web Host Manager, go to Exim Configuration Manager then Advanced Editor, click on Save without changing anything in this section This should create a file named /etc/exim.conf.local Edit the above mentioned file and add some configurations to the @CONFIG@and @TRANSPORTSTART@ sections @CONFIG@ system_filter_directory_transport = local_copy_outgoing...
How to create a symbolic link in Linux
How Can We Help? Search Print What is a symbolic link? A symbolic link is a special file that points to another file on the system. When you access one of these files, it has a pathname stored inside it. Use this pathname to advance to the file or directory on the system represented by the pathname stored in the symbolic link. How to create a symbolic link? Create a symbolic link with...
How to install Right click open in terminal Ubutu
How Can We Help? Search Print I’m using Ubuntu 9.04 and needed to have the RIGHT CLICK OPEN IN TERMINAL option enabled. eg. If you need to work in the desktop directory via the terminal and you don’t want to navigate to the directory via typing this application will come in handy. To enable/install this follow the steps below. STEP 1 Make sure you are connected to the Internet STEP 2...
How To Install The Internet Explorer On Ubuntu 8.04/9.04
How Can We Help? Search Print This tutorial will guide you how to install Internet Explorer on UBUNTU Linux via IEs4Linux. IEs4Linux only contains Internet Explorer 5, 5.5 and 6. IEs4Linux comes in handy especially for Web Developers who need to test their web applications on Internet Explorer. NOTE: For security reasons only use IEs4Linux for development and not to surf the Internet. STEP 1 Open...
How to search for certain text/information within files using Linux
How Can We Help? Search Print Example: If you have a directory with 10 000 text files in it and you need to find a certain word in a certain file but you aren’t sure what the name of the file is. You can use the method described below to find the file with selected text within it. Answer: In the command line type the following command: grep -rni “Hello World” *.txt and press...
I installed phpMyAdmin in Ubuntu 9.04 via apt-get install but when I type http://localhost/phpmyadmin in the address bar in my Internet Browser the page is not found
How Can We Help? Search Print I installed phpMyAdmin in Ubuntu 9.04 via apt-get install phpmyadmin but when I type in the address bar in my Internet Browser the page is not found? I have installed PHP, Apache2, mySql and have restarted Apache but still nothing happens when I type . Create a symbolic link in /etc/apache2/conf.d that points to/etc/phpmyadmin/apache.conf Files included in...
How to add a Apache VirtualHost on Ubuntu
How Can We Help? Search Print With this tutorial I assume that you know what Apache web server is and that you have PHP and Apache installed on your machine. Also ensure that you are able to serve web pages. NOTE: This has been tested on Ubuntu 9.04 Answer: Open your Terminal Window or the command line. Navigate to the /etc/apache2/sites-available directory with this command: cd...
Creating Aliases in Ubuntu
How Can We Help? Search Print How to create Aliases in Ubuntu? If you have a command that you run all the time in Ubuntu like pwd to print your working directory, you can create an alias for that specific command. In otherwords a shorter version for the pwd command. Open a Terminal Window (CLI = Command Line Interface) Type the command cd to take you to your home directory. Now you need to...
How to view Hidden Files and Folders in Ubuntu/Linux
How Can We Help?
Search
Print
In the File Browser (Graphical) press the key combination ctrl+h together in order to view all the hidden files and folders.
In the command line when listing directory contents (ls) use the option -a eg. ls -ato list all hidden files. Files or folders that start with a . (dot)
Firefox Flash Player Problems with Ubuntu 9.04
How Can We Help? Search Print When loading Flash enabled websites in Firefox I get Flash Player problems? I’m running Firefox 3.0.13 on Ubuntu 9.04 Examples: When loading Google Analytics some flash features like the Dashboard, Visitors Overview and Map Overlay just load the whole time without any results displaying. Some sites eg. www.sterkinekor.co.za does not work properly in Firefox...
How to rename files and folders using the command line in Linux
How Can We Help? Search Print We accomplish this by using the “mv” (move command) Example: File Example: {codecitation class=”brush: bash;”}mv old_file new_file{/codecitation} Directory Example: {codecitation class=”brush: bash;”}mv old_directory new_directory{/codecitation} NOTE: mv can move several files into a destination folder, or a single file...
How to convert RPM packages to DEB packages using Ubuntu
How Can We Help? Search Print NOTE: Has been tested on Ubuntu 9.10 In Ubuntu open Synaptic Package Manager ‘System->Administration->Synaptic Package Manager‘ Now we need to install 2 apps called alien and fakeroot alien – Convert and install rpm and other packages fakeroot – Gives a fake root environment To install them simply type alien in the Quick search box and...
Installing Adobe Air on Ubuntu
How Can We Help? Search Print NOTE: Tested on Ubuntu 9.10 Open a new Terminal Window Download the following file using the wget command{codecitation class=”brush: bash;”}wget {/codecitation} Save the file in your Home Directory or any other Directory Give the file executable privelages by using the following command {codecitation class=”brush: bash;”}chmod +x...
How to search for files on the command line in Linux
How Can We Help? Search Print By using the find command we can search for files and directories using the command line. The find command uses a raw search to find files and directories. The usage is find [PATH] [OPTIONS][SEARCH CRITERIA] Example: find /home/ -name test The example above finds all files/directories within the home directory that contain the word test Below are different common...
How to unzip a ZIP file in Linux on the Command Line to a folder
How Can We Help?
Search
unzip zipFile.zip -d directory
unzip – list, test and extract compressed files in a ZIP archive
-d = An optional directory to which to extract files.
directory = The directory where to extract the files to
zipFile.zip = Your ZIP file