X-Spam-Check-By: sourceware.org Date: Tue, 19 Jun 2007 10:00:09 -0400 (EDT) From: Igor Peshansky Reply-To: cygwin@cygwin.com To: cygwin@cygwin.com cc: =?ISO-8859-1?Q?Tilman_Schr=F6der?= Subject: Re: Running mysql as a service ... In-Reply-To: Message-ID: References: <20070616194641.21020@gmx.net> MIME-Version: 1.0 Content-Type: MULTIPART/Mixed; BOUNDARY="-559023410-33463914-1182261243=:3119" Content-ID: Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm Precedence: bulk List-Id: List-Unsubscribe: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com Delivered-To: mailing list cygwin@cygwin.com ---559023410-33463914-1182261243=:3119 Content-Type: TEXT/PLAIN; CHARSET=iso-8859-1 Content-Transfer-Encoding: 8BIT Content-ID: On Tue, 19 Jun 2007, Igor Peshansky wrote: > . 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@cs.nyu.edu | igor@watson.ibm.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--