X-Spam-Check-By: sourceware.org
Date: Tue, 19 Jun 2007 10:00:09 -0400 (EDT)
From: Igor Peshansky <pechtcha AT cs DOT nyu DOT edu>
Reply-To: cygwin AT cygwin DOT com
To: cygwin AT cygwin DOT com
cc: =?ISO-8859-1?Q?Tilman_Schr=F6der?= <tilman DOT schroeder AT gmx DOT de>
Subject: Re: Running mysql as a service ...
In-Reply-To: <Pine.GSO.4.63.0706190843210.3119@access1.cims.nyu.edu>
Message-ID: <Pine.GSO.4.63.0706190958050.3119@access1.cims.nyu.edu>
References: <20070616194641 DOT 21020 AT gmx DOT net> <Pine DOT GSO DOT 4 DOT 63 DOT 0706190843210 DOT 3119 AT access1 DOT cims DOT nyu DOT edu>
MIME-Version: 1.0
Content-Type: MULTIPART/Mixed; BOUNDARY="-559023410-33463914-1182261243=:3119"
Content-ID: <Pine DOT GSO DOT 4 DOT 63 DOT 0706190958051 DOT 3119 AT access1 DOT cims DOT nyu DOT edu>
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Precedence: bulk
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
Content-ID: <Pine DOT GSO DOT 4 DOT 63 DOT 0706190958052 DOT 3119 AT access1 DOT cims DOT nyu DOT edu>

On Tue, 19 Jun 2007, Igor Peshansky wrote:

> <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).

Forgot to mention: cygrunsrv is a wrapper to run a non-service (console)
program as a service.  That means that you'll need to put mysqld in
non-daemon mode.  Either that, or explore the --pid option of cygrunsrv
(read the man page and the description in the User's Guide).
	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--