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'
Run VSQL under CygWin?
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Run VSQL under CygWin?
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!
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!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Run VSQL under CygWin?
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
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?
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.
When it tries to run the "chop" command, it sais that it doesn't exist.
Re: Run VSQL under CygWin?
Hi!
find a difference in commands(HINT: chop vs chcp)
JimKnicely wrote: ↑Thu Jun 08, 2017 3:01 pmI installed Cygwin on Windows 7. I edited thec:\cygwin64\bin\cygwin1.batfile 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?
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.
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?
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
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