6 messages in com.mysql.lists.win32MIGUEL: Re: Custom Service not workin...
FromSent OnAttachments
Troy Engel19 Mar 2003 15:56 
miguel solórzano20 Mar 2003 05:16 
Troy Engel20 Mar 2003 09:46 
Troy Engel24 Mar 2003 09:52 
miguel solórzano25 Mar 2003 10:26 
Troy Engel25 Mar 2003 14:22 
Subject:MIGUEL: Re: Custom Service not working - 3.23.55/Win2k
From:Troy Engel (ten@fluid.com)
Date:03/24/2003 09:52:30 AM
List:com.mysql.lists.win32

Miguel - sorry to yell your name, but apparently you didn't see this. Is this a bug in MySQL/Win32 or not? Anyone? Bueller?

thx, -te

Troy Engel wrote:

Thanks for responding so quick! #1 works, #2 doesn't (and I really need #2). See below -- by the way, is this documented anywhere? If so, I couldn't find it... :(

miguel solórzano wrote:

1- Using the same c:\my.cnf or c:\winnt\my.ini file used for the default MySQL service. ....... [MyFoo] basedir = C:/mybuild datadir = C:/mybuild/data port = 3307

This works! At least I can have the service a different name, if nothing else. But, I really want #2 to work:

2- Using a custom configuration file

mysqld --install MyFoo --defaults-file=c:\mypath\my.ini

[mysqld] basedir = C:/mybuild datadir = C:/mybuild/data port = 3307

This does *not* work, it dies with a 1067. I even tried combining #1 with this (using [MyFoo] section in c:\mybuild\mysql\my.cnf) and just using [mysqld] as directed.

Can you confirm #2 is working with 3.23.55 on your end? Here's some output from me:

C:\mybuild\mysql\bin>mysqld-nt --install MyFoo --defaults-file=c:\mybuild\mysql\my.cnf Service successfully installed.

C:\mybuild\mysql\bin>head -4 c:\mybuild\mysql\my.cnf [mysqld] basedir=c:/mybuild/mysql/ datadir=c:/mybuild/mysql/data/ port=3306

C:\mybuild\mysql\bin>net start MyFoo The MyFoo service is starting. The MyFoo service could not be started.

A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly.

==================

C:\mybuild\mysql\bin>head -7 c:\mybuild\mysql\my.cnf [MyFoo] basedir=c:/mybuild/mysql/ datadir=c:/mybuild/mysql/data/ port=3306

[mysqld] skip-locking

C:\mybuild\mysql\bin>net start MyFoo The MyFoo service is starting. The MyFoo service could not be started.

A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly.

thanks! -te

-- Troy Engel, Systems Engineer "Now, Beakie, we'll just flip this switch and 60,000 refreshing volts of electricity will surge through your body. Ready?"