Page 1 of 1
Run VSQL under CygWin?
Posted: Wed Jun 07, 2017 9:55 pm
by usao
Im looking for a way to run VSQL (Windows client) under CygWin.
So far, not much success.
It hangs when asking for the password.
I saw other posts about a cygwin.bat file, but I cannot find that on my system.
BASH_VERSION='4.4.5(1)-release'
Re: Run VSQL under CygWin?
Posted: Thu Jun 08, 2017 3:01 pm
by JimKnicely
Hi,
I installed Cygwin on Windows 7. I edited the c:\cygwin64\bin\cygwin1.bat file and added the following lines:
cmd.exe /c chcp 1252
set CYGWIN=binmode ntsec
Next I opened a Windows command prompt, ran the c:\cygwin64\bin\cygwin1.bat file, then successfully launched vsql...
Here is the output:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\knicely>cd c:\cygwin64
c:\cygwin64>more Cygwin.bat
@echo off
cmd.exe /c chcp 1252
C:
chdir C:\cygwin64\bin
set CYGWIN=binmode ntsec
bash --login -i
c:\cygwin64>Cygwin.bat
Active code page: 1252
knicely@KNICELY6 ~
$ cmd /c "C:\Program Files\Vertica Systems\VSQL64\vsql.exe" -h 192.168.56.102 -U dbadmin -w *******
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=> select * from dual;
dummy
-------
X
(1 row)
dbadmin=> \q
knicely@KNICELY6 ~
Works!
Re: Run VSQL under CygWin?
Posted: Wed Dec 20, 2017 6:37 am
by renith
When I try to run the vsql client, it prompts me for a password. However, it just echos the password to the screen as I type then hangs after I hit enter. If I put the "-w" option with the password on the command line, then vsql just hangs.
oracle training in bangalore :
http://www.besanttechnologies.in/oracle ... alore.html
oracle training in chennai :
https://www.besanttechnologies.com/trai ... e-training
Re: Run VSQL under CygWin?
Posted: Thu Jan 18, 2018 8:20 pm
by usao
I tried to create the cygwin1.bat file (which did not previously exist).
When it tries to run the "chop" command, it sais that it doesn't exist.
Re: Run VSQL under CygWin?
Posted: Sun Jan 21, 2018 5:54 pm
by sKwa
Hi!
usao wrote: ↑Thu Jan 18, 2018 8:20 pm
When it tries to run the "chop" command, it sais that it doesn't exist.
JimKnicely wrote: ↑Thu Jun 08, 2017 3:01 pm
I installed Cygwin on Windows 7. I edited the
c:\cygwin64\bin\cygwin1.bat
file and added the following lines:
cmd.exe /c chcp 1252
set CYGWIN=binmode ntsec
find a difference in commands(HINT: chop vs chcp)
Re: Run VSQL under CygWin?
Posted: Mon Jan 22, 2018 4:13 pm
by usao
Ok, I replaced the chop with chcp, and I was able to run thta batch file from Windows command prompt, but not from Cygwin.
In either case, when I run:
$ cmd /c "C:\Program Files\Vertica Systems\VSQL64\vsql.exe" -h 10.0.3.51 -U dbadmin -w *****
from either Windows CMD or from Cygwin, it just hangs.
Re: Run VSQL under CygWin?
Posted: Tue Jan 23, 2018 12:50 am
by sKwa
Hi!
It can be a problem with environment, so lets check it first - with CygWin install psql and try connect to Vertica with psql(yes, Vertica based on PostgreSQL and psql can connect to Vertica).
**PS**:
https://stackoverflow.com/questions/144 ... -in-cygwin