Unable to connect to Vertica using Powershell

Comments

• Jim_Knicely - Select Field - Administrator

  September 2017 edited September 2017

  Hi,

  Works for me in PS (Windows 7):

  PS C:\Program Files\Vertica Systems\VSQL64> .\vsql -h verticademos.com
  Welcome to vsql, the Vertica Analytic Database interactive terminal.
  
  Type:  \h or \? for help with vsql commands
         \g or terminate with semicolon to execute query
         \q to quit
  
  Warning: Console code page (437) differs from Windows code page (1252)
           8-bit characters may not work correctly. See vsql reference
           page "Notes for Windows users" for details.
  
  dbadmin=> select 'Vertica is Awesome!' "FACT";
          FACT
  ---------------------
   Vertica is Awesome!
  (1 row)
  

  For the server IP address, why are you using "010.010.1.010" instead of "10.10.1.10"?

  Note you can get rid of the console code page warning message by changing the code page...

  PS C:\Program Files\Vertica Systems\VSQL64> chcp 1252
  Active code page: 1252
  
  PS C:\Program Files\Vertica Systems\VSQL64> .\vsql -h verticademos.com
  Welcome to vsql, the Vertica Analytic Database interactive terminal.
  
  Type:  \h or \? for help with vsql commands
         \g or terminate with semicolon to execute query
         \q to quit
  
  dbadmin=>
  

  0
• Slaagh

  September 2017

  That IP address is just a random number. I cannot imagine anyone who would use that convention.

  0
• Slaagh

  September 2017

  I am able to access Vertica using TOAD data tools and CMD Prompt. Do you have any idea why this would hang? Perhaps I need to install something?

  Thank you for your response!

  0
• Jim_Knicely - Select Field - Administrator

  September 2017

  Where is vsql installed? Typically is installed in C:\Program Files\Vertica Systems\VSQL64.

  So I can run it like this:

  PS & 'C:\Program Files\Vertica Systems\VSQL64\vsql' -h 10.10.1.10 -d MY_DATABASE

  Note that if you pass in a bogus IP where Vertica is not running it may take a minute for vsql to report a connection timeout. For example, I ran the above command in PowerShell, and it took about 18 seconds for me to get the "vsql: could not connect to server:..." message. You might think its hanging.

  PS C:\> & 'C:\Program Files\Vertica Systems\VSQL64\vsql' -h 10.10.1.10 -d MY_DATABASE
  vsql: could not connect to server: Connection timed out (0x0000274C/10060)
          Is the server running on host "10.10.1.10" and accepting
          TCP/IP connections on port 5433? 
  

  0