delorie.com/archives/browse.cgi   search  
Mail Archives: cygwin/2007/06/19/09:54:50

X-Spam-Check-By: sourceware.org
Date: Tue, 19 Jun 2007 09:54:03 -0400 (EDT)
From: Igor Peshansky <pechtcha AT cs DOT nyu DOT edu>
Reply-To: cygwin AT cygwin DOT com
To: =?ISO-8859-1?Q?Tilman_Schr=F6der?= <tilman DOT schroeder AT gmx DOT de>
cc: cygwin AT cygwin DOT com
Subject: Re: Running mysql as a service ...
In-Reply-To: <20070616194641.21020@gmx.net>
Message-ID: <Pine.GSO.4.63.0706190843210.3119@access1.cims.nyu.edu>
References: <20070616194641 DOT 21020 AT gmx DOT net>
MIME-Version: 1.0
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id: <cygwin.cygwin.com>
List-Unsubscribe: <mailto:cygwin-unsubscribe-archive-cygwin=delorie DOT com AT cygwin DOT com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com

---559023410-33463914-1182261243=:3119
Content-Type: TEXT/PLAIN; charset=iso-8859-1
Content-Transfer-Encoding: 8BIT

<http://cygwin.com/acronyms/#PCYMTWLL>.  Thanks.

On Sat, 16 Jun 2007, "Tilman Schröder" wrote:

> Hello everyone,
>
> I just spend some frunstrating hours on figuring out how to run a
> self-compiled cygwin mysql daemon as a service (win xp).
>
> first of all:
> using cygrunsrv.exe did not work for me, I do not know why, the problem
> is that there is no error log file for cygrunsrv or i am too stupid and
> did not found the log file

Check the Windows Event Log (under "My Computer"->"Manage", or whatever
the Deutsche equivalent is).

You did not tell us what command you are using to install mysql as service
(with cygrunsrv).  Also, you didn't provide the error you are getting from
cygrunsrv on the console (you must be getting something, even if it's
"service not started").

Another option is to install syslog-ng and run that as a service.  Then
all errors will be logged wherever you configure them to be (e.g., in
/var/log/mysqld.log)...

> then i tried this:
>
> C:\Programme\cygwin\bin\bash.exe -login -i -c "/usr/local/mysql/libexec/mysqlmanager.exe --run-as-service &"
>
> this command opens up 3 console windows which are being closed
> immediately again and after this, the mysql-server runs in the
> background!

The console windows are the consequence of the implicit -mconsole.  If you
compile with -mwindows instead, you'll lose the ability to display
messages on the console, so that's probably not a good option.

> it's not a very good solution because this is no real
> service but just a command which can be put into the Autostart folder
> ... and now we have got a problem when more than one real windows user
> is logged in ...
>
> Does anyone know how to start the cygwin mysql server as a windows
> service ???
> Would be very nice if somebody knew the trick ...

Sure -- use cygrunsrv.  Beyond that, you need to check various permissions
(cygrunsrv will run as SYSTEM), and make sure the paths are in order, etc
(e.g., c:\cygwin\bin needs to be in the PATH unless mysqld is in /bin).

> BTW: no its not an option to use the precompiled windows mysql binaries
> because i need the php postscript extension on windows which needs
> pslib. and pslib can only be compiled within cygwin, not mingw or native
> windows. and if pslib only works in a cygwin environment, then the
> postscript extension and php have to be built within cygwin. but a
> cygwin php cannot be linked against windows binaries and therefor i need
> a cygwin version of mysql, too :(

HTH,
	Igor
-- 
				http://cs.nyu.edu/~pechtcha/
      |\      _,,,---,,_	    pechtcha AT cs DOT nyu DOT edu | igor AT watson DOT ibm DOT com
ZZZzz /,`.-'`'    -.  ;-;;,_		Igor Peshansky, Ph.D. (name changed!)
     |,4-  ) )-,_. ,\ (  `'-'		old name: Igor Pechtchanski
    '---''(_/--'  `-'\_) fL	a.k.a JaguaR-R-R-r-r-r-.-.-.  Meow!

Freedom is just another word for "nothing left to lose"...  -- Janis Joplin

---559023410-33463914-1182261243=:3119
Content-Type: text/plain; charset=us-ascii

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

- Raw text -


  webmaster     delorie software   privacy  
  Copyright © 2019   by DJ Delorie     Updated Jul 2019