Re: MySQL client, prompt, redux

2010-04-08 Thread Markus Hoenicka

Yaakov (Cygwin/X) yselkow...@users.sourceforge.net was heard to say:

What do you mean by local server?  If you mean a Win32-native  
server, that case is clearly noted in the mysql Cygwin README.  If  
you mean the mysqld which is provided by the Ports package, further  
discussion thereof would be welcome on the cygwin-ports-general list.




I'm sorry I wasn't explicit enough here. The problem occurs if I  
connect to a Win32 mysqld. I don't use the Cygwin mysqld at this time.


I thought I'd mention this limitation because people may try the  
Cygwin client and go like great, this !#**# doesn't work either if  
they are not aware they have to use the -h option in this particular  
case. This was not intended to create the impression something's wrong  
with your port.


regards,
Markus

--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38



--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple



Re: MySQL client, prompt, redux

2010-04-07 Thread Eric Lilja

On 2010-04-07 01:06, Tim McDaniel wrote:

 From Google searches and some experience, it appears that it's a
long-standing situation that, if you run the mysql.exe client program
under mintty or rxvt from Cygwin, then mysql figures that it's not on
an interactive terminal and therefore does not prompt. Is there yet
any workaround other than simply using cmd.exe instead? (In mintty,
BTW, cmd /c mysql ... doesn't prompt, presumably for the same reason
that mysql alone doesn't prompt.)



When I run cygwin inside a TakeCommand shell, I do get a working mysql 
client program. You might want to check it out (it's a commercial app, 
however), see http://jpsoft.com/
Also, I see that the just released beta of MySQL Workbench has a proper 
command interpreter now, another option you might be interested in.


- Eric Lilja


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple



Re: MySQL client, prompt, redux

2010-04-07 Thread Markus Hoenicka

Jeremy Bopp jer...@bopp.net was heard to say:


real Windows console which mintty and rxvt are unable to provide.  If
there is no mysql package in the Cygwin repository, have you tried to
see if Cygwin Ports has a Cygwin-native build which will work for you?



This is just to confirm, for the sake of the archive's completeness,  
that Cygwin Ports has builds, or patch sets if you prefer to build  
them from scratch, and that these Cygwin builds provide a working  
command prompt. The only downside is that I don't seem to be able to  
connect through a socket, so I always have to use the network layer  
(via the -h hostname option) to connect to my local server.


regards,
Markus


--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38



--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple



Re: MySQL client, prompt, redux

2010-04-07 Thread Yaakov (Cygwin/X)

On 2010-04-07 09:24, Markus Hoenicka wrote:

This is just to confirm, for the sake of the archive's completeness,
that Cygwin Ports has builds, or patch sets if you prefer to build them
from scratch, and that these Cygwin builds provide a working command
prompt. The only downside is that I don't seem to be able to connect
through a socket, so I always have to use the network layer (via the -h
hostname option) to connect to my local server.


What do you mean by local server?  If you mean a Win32-native server, 
that case is clearly noted in the mysql Cygwin README.  If you mean the 
mysqld which is provided by the Ports package, further discussion 
thereof would be welcome on the cygwin-ports-general list.



Yaakov
Cygwin Ports

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple



MySQL client, prompt, redux

2010-04-06 Thread Tim McDaniel

 From Google searches and some experience, it appears that it's a
long-standing situation that, if you run the mysql.exe client program
under mintty or rxvt from Cygwin, then mysql figures that it's not on
an interactive terminal and therefore does not prompt.  Is there yet
any workaround other than simply using cmd.exe instead?  (In mintty,
BTW, cmd /c mysql ... doesn't prompt, presumably for the same reason
that mysql alone doesn't prompt.)

--
Tim McDaniel, t...@panix.com

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple



Re: MySQL client, prompt, redux

2010-04-06 Thread Jeremy Bopp
Tim McDaniel wrote:
  From Google searches and some experience, it appears that it's a
 long-standing situation that, if you run the mysql.exe client program
 under mintty or rxvt from Cygwin, then mysql figures that it's not on
 an interactive terminal and therefore does not prompt.  Is there yet
 any workaround other than simply using cmd.exe instead?  (In mintty,
 BTW, cmd /c mysql ... doesn't prompt, presumably for the same reason
 that mysql alone doesn't prompt.)

If you are using the Windows-native build of the mysql client, then
there is no way to fix this.  That build of the client expects to have a
real Windows console which mintty and rxvt are unable to provide.  If
there is no mysql package in the Cygwin repository, have you tried to
see if Cygwin Ports has a Cygwin-native build which will work for you?

-Jeremy

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple



Re: MySQL client, prompt, redux

2010-04-06 Thread Andy Koppe
Jeremy Bopp:
 Tim McDaniel wrote:
  From Google searches and some experience, it appears that it's a
 long-standing situation that, if you run the mysql.exe client program
 under mintty or rxvt from Cygwin, then mysql figures that it's not on
 an interactive terminal and therefore does not prompt.  Is there yet
 any workaround other than simply using cmd.exe instead?  (In mintty,
 BTW, cmd /c mysql ... doesn't prompt, presumably for the same reason
 that mysql alone doesn't prompt.)

 If you are using the Windows-native build of the mysql client, then
 there is no way to fix this.  That build of the client expects to have a
 real Windows console which mintty and rxvt are unable to provide.

Yep. It probably calls isatty() on the standard streams, which in the
case of the Windows C library (MSVCRT) returns false for pipes, which
Cygwin's pty emulation is based on.

It shouldn't be horrendously difficult, however, to add a switch for
forcing interactive mode to the mysql client. Python does have such a
switch. Perhaps you could raise this on the relevant mysql mailing
list?

Andy

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple