You may specify an alternative known_hosts file in `$HOME/.ssh/config` or `/etc/ssh/ssh_config`, the parameter `UserKnownHostsFile`.

Alternatively, if you prefer to use alternative known_hosts file for a specific SSH invocation, you may use the SSH command option `-o UserKnownHostsFile=&lt;alternative known_hosts file&gt;`, e.g. `ssh -o UserKnownHostsFile=~/my_temporary_known_host ssh_host`.

How to create tar.gz archive of my files in Windows to upload and extract in cPanel?

How to create tar.gz archive file in Windows?

I have a dump file with a `.SQL` extension (in fact it is a plain-text SQL file). I want to restore it into my created databases. I am using [pgAdmin III][1], and when I use its &quot;Restore Wizard&quot; it does not highlight the button &quot;Restore&quot;. Instead it is expecting a `.backup` file extension.

I tried using shell the commands for restoring the dump, but it still didn&#39;t work.

I am a newbie at this. If anybody could help me I would be obliged.

Edit
----

I used following command to the Shell SQL Pane of PostGres while sitting at the newTestDB.

    newTestDB-# \i E:\db-rbl-restore-20120511_Dump-20120514.sql

It still gave the same error (&quot;Permission Denied&quot;).

After elevating permissions it just shows me the default tables of PostgreSQL:

          List of tablespaces
    Name       |  Owner   | Location
    -----------+----------+----------
    pg_default | postgres |
    pg_global  | postgres |
    
    (2 rows)

 I don&#39;t know what to do for importing/restoring database from an SQL file.

  [1]: http://www.pgadmin.org/

How to restore PostgreSQL dump file into Postgres databases?

Is it possible to run SSH using another `known_hosts` file than the standard `$HOME/.ssh/known_hosts` for the user?

Note, that SSH uses `$HOME` original for the user. If you try to change it, e.g.

    export HOME=some_other_location

it does not affect the location SSH uses to look for `known_hosts`.


ssh use known_hosts other than $HOME/.ssh/known_hosts

Is it possible to run SSH using another <code>known_hosts</code> file than the standard <code>$HOME/.ssh/known_hosts</code> for the user?
Note, that SSH uses <code>$HOME</code> original for the user. If you try to change it, e.g.
<pre><code class="hljs language-ini">export HOME=some_other_location
</code></pre>
it does not affect the location SSH uses to look for <code>known_hosts</code>.

I am trying out some code on Ubuntu. I&#39;m trying to run the following code 

&lt;!-- language: lang-c++ --&gt;

    #include &lt;cstdlib&gt;
    #include &lt;cmath&gt;
    #include &lt;ctime&gt;
    #include &quot;random.h&quot;
    
    using namespace std;
    
    /* Function prototype! */
    void initRandomSeed();
        
    int randomInteger(int low,int high){
    	initRandomSeed();
    	double d= rand()/(double(RAND_MAX)+1);
    	double s= d*(double(high)-low+1);
    	return int(floor(low)+s);    
    }
    
    double  randomReal(int low,int high){
    	initRandomSeed();
    	double d=rand()/(double(RAND_MAX)+1);
    	double s=d*(double(high)-low+1);
    	return low+s;
    }    
    
    bool randomChance(double p){
    	initRandomSeed();
    	return randomReal(0,1)&lt;p;
    }            
    
    void setRandomSeed(int seed){    
    	initRandomSeed();
    	srand(seed);
    }    
    
    void initRandomSeed(){
        // to retain updated values across different stack frames! nice!
    	static bool initialized=false;
    
        // this is executed only very first time and random value obtained from system clock!
    	if(!initialized){
    		srand(int(time(NULL)));
    		initialized=true;
    	}
    }
    
And when I try to compile the above code using `g++`,  I get the following error

&lt;!-- language: lang-none --&gt;

    @ubuntu:~/Chardway$ g++ random.cpp
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 0 has invalid symbol index 10
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 1 has invalid symbol index 11
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 2 has invalid symbol index 2
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 3 has invalid symbol index 2
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 4 has invalid symbol index 10
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 5 has invalid symbol index 12
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 6 has invalid symbol index 12
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 7 has invalid symbol index 12
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 8 has invalid symbol index 2
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 9 has invalid symbol index 2
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 10 has invalid symbol index 11
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 11 has invalid symbol index 12
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 12 has invalid symbol index 12
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 13 has invalid symbol index 12
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 14 has invalid symbol index 12
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 15 has invalid symbol index 12
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 16 has invalid symbol index 12
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 17 has invalid symbol index 12
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 18 has invalid symbol index 12
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 19 has invalid symbol index 12
    /usr/bin/ld: /usr/lib/debug/usr/lib/x86_64-linux-gnu/crt1.o(.debug_info): relocation 20 has invalid symbol index 19
    /usr/lib/gcc/x86_64-linux-gnu/4.6/../../../x86_64-linux-gnu/crt1.o: In function `_start&#39;:
    (.text+0x20): undefined reference to `main&#39;
    collect2: ld returned 1 exit status

Any help or links to questions that help would be really helpful! Thanks! 


Linker returns &quot;relocation has an invalid symbol at symbol index...&quot;

Hi I am a newbie on nginx, I tried to set it up on my server(running Ubuntu 4),  which already has apache running.


So after I `apt-get install` it, I tried to start nginx. Then I get the message like this:

    Starting nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
    configuration file /etc/nginx/nginx.conf test is successful
    [emerg]: bind() to 0.0.0.0:80 failed (98: Address already in use)
    [emerg]: bind() to 0.0.0.0:80 failed (98: Address already in use)
    [emerg]: bind() to 0.0.0.0:80 failed (98: Address already in use)
    [emerg]: bind() to 0.0.0.0:80 failed (98: Address already in use)
    [emerg]: bind() to 0.0.0.0:80 failed (98: Address already in use)

That makes sense as Apache is using port 80.

Then I tried to modify `nginx.conf`, I reference some articles, so I changed it like so:


       server {
    
            listen       8080;
    
            location / {
             proxy_pass  http://xx.xx.xx.xx:9500;
             proxy_set_header   Host             $host:8080;
             proxy_set_header   X-Real-IP        $remote_addr;
             proxy_set_header   X-Forwarded-For  $proxy_add_x_forwarded_for;
             proxy_set_header Via    &quot;nginx&quot;;
            }
     

After saving this and try to start nginx again,  I still get the same error as previously.  I cannot really find a related post about this, could any good people shred some light?













**I should post all the content in conf here:**

    user www-data;
    worker_processes  1;
    
    error_log  /var/log/nginx/error.log;
    pid        /var/run/nginx.pid;
    
    events {
        worker_connections  1024;
        # multi_accept on;
    }
    
    http {
        include       /etc/nginx/mime.types;
    
        access_log  /var/log/nginx/access.log;
    
        sendfile        on;
        #tcp_nopush     on;
    
        #keepalive_timeout  0;
        keepalive_timeout  65;
        tcp_nodelay        on;
    
        gzip  on;
        gzip_disable &quot;MSIE [1-6]\.(?!.*SV1)&quot;;
    
        include /etc/nginx/conf.d/*.conf;
        include /etc/nginx/sites-enabled/*;
    
       server {
    
            listen       81;
    
            location / {
             proxy_pass  http://94.143.9.34:9500;
             proxy_set_header   Host             $host:81;
             proxy_set_header   X-Real-IP        $remote_addr;
             proxy_set_header   X-Forwarded-For  $proxy_add_x_forwarded_for;
             proxy_set_header Via    &quot;nginx&quot;;
            }
    
    
        }
    }
    
     mail {
          See sample authentication script at:
          http://wiki.nginx.org/NginxImapAuthenticateWithApachePhpScript
     
          auth_http localhost/auth.php;
          pop3_capabilities &quot;TOP&quot; &quot;USER&quot;;
          imap_capabilities &quot;IMAP4rev1&quot; &quot;UIDPLUS&quot;;
     
         server {
             listen     localhost:110;
             protocol   pop3;
             proxy      on;
         }
     
         server {
             listen     localhost:143;
             protocol   imap;
             proxy      on;
         }
     }

Basically,  I changed nothing except adding the server part.






How to start nginx via different port(other than 80)

I am trying to uninstall mysql from my ubuntu 12.04 completely. But not able to.

I tried a lot of commands. But nothing is working. Can anyone help out here!

    sudo apt-get remove mysql-server mysql-client mysql-common
    sudo apt-get autoremove
I am not able to understand what to do.
I want to remove everything regarding MySQL. Whenever I am trying to locate it. I am getting that.

I want everything to be removed. mysql-server, mysql-client, mysql-libraries and even configuration.

Please help me!!!

Removing MySQL 5.7 Completely

I have a Linux environment and I have a PHP Web Application that conditionally runs based on environment variables using `getenv` in PHP. I need to know how these environment variables need to be set for the application to work correctly. I am not sure how to set this up on Apache.

Also, I need to be able to configure separate environment variables for each domain separately.

Please advice on how can I achieve this.

Setting environment variables for accessing in PHP when using Apache

I have a machine with Ubuntu 12.04 and have installed Jenkins ver. 1.424.6 using apt-get based on *[this guide*][1], but there is a new version:

    New version of Jenkins (1.447.2) is available for download (changelog).

If I press download, I get a `jenkins.war` file... but how do I use that for upgrading my current installation? or is that not possible before the apt repositories gets updated?


  [1]: http://www.mabishu.com/blog/2012/04/17/setting-up-jenkins-in-ubuntu-precise-12-04-for-php-projects/

Update Jenkins from a war file

I would like to reproduce the way Vagrant logs in to my VM within a shell script using an `ssh` command, so I create an alias to my Vagrant instance.

What is the command syntax to use the regular `ssh` command to access it?

How to ssh to vagrant without actually running &quot;vagrant ssh&quot;?

On the GitHub site there is a link...

https://help.github.com/articles/generating-ssh-keys

... and it states...

&gt; If you have decided not to use the recommended HTTPS method, we can
&gt; use SSH keys to establish a secure connection between your computer
&gt; and GitHub. The steps below will walk you through generating an SSH
&gt; key and then adding the public key to your GitHub account.

Why is HTTPS the recommended method?  Is there some sort of security flaw in the SSH method or is it slower?  I created an SSH key, so would that mitigate any security concerns?

Why does GitHub recommend HTTPS over SSH?

Say your `.ssh` directory contains 30 keys (15 private and 15 public).

Where in Git can one check which one is used to connect to a given remote repository?


Git and SSH, which key is used?

I&#39;m a young a student and received my homework for this week. It&#39;s pretty difficult for me because I have to create a program, that is able to connect to an SSH server and send the command &quot;etc/init.d/networking restart&quot;.

I should program this application in C# and I&#39;m pretty new to it (Just have learned from some school lessons). I also should create a GUI.

I understand the basics of C# (loop, if etc...).

I&#39;ve already created GUI, menus, buttons and a log listbox.
GUI = 3 textboxes (ip, username, password) and a button to connect.

![screenshot of ui][1]

![screenshot of code][2]

I&#39;m coding with Microsoft Vistual Studio.

My question is: How can I establish an SSH connection to my server?


  [1]: http://i.stack.imgur.com/lNzZI.png
  [2]: http://i.stack.imgur.com/Iqqm8.png

C# send a simple SSH command

These days when I create a new repository on GitHub on the setup page I get:

    git remote add origin https://github.com/nikhilbhardwaj/abc.git
    git push -u origin master

And whenever I have to push a commit I need to enter my GitHub username and password.

I can manually change that to 

    git@github.com:nikhilbhardwaj/abc.git

in the `.git/config`. I find this quite irritating - **is there some way I can configure git to use SSH by default?**

Content Type	Original Author	Original Content on Stackoverflow
Question	user1085687	View Question on Stackoverflow
Solution 1 - Ubuntu	Raymond Tau	View Answer on Stackoverflow

ssh use known_hosts other than $HOME/.ssh/known_hosts

Ubuntu Problem Overview

Ubuntu Solutions

Solution 1 - Ubuntu

How to restore PostgreSQL dump file into Postgres databases?

How to create tar.gz archive file in Windows?

Attributions