Re: NT service starts, but I still have to start MySQL as an application - Tony Groves - com.mysql.lists.win32

12 messages in com.mysql.lists.win32Re: NT service starts, but I still ha...

From	Sent On	Attachments
Tony Groves	10 Aug 2003 14:31
Tony Groves	11 Aug 2003 03:57
Yogesh Kadalgikar	11 Aug 2003 04:27
Tony Groves	11 Aug 2003 06:08
Tony Groves	11 Aug 2003 06:09
Nils Valentin	11 Aug 2003 06:18
Tony Groves	11 Aug 2003 06:59
Armin Schöffmann	11 Aug 2003 07:28
Tony Groves	11 Aug 2003 11:54
Tony Groves	11 Aug 2003 11:58
Nils Valentin	11 Aug 2003 18:23
Yogesh Kadalgikar	11 Aug 2003 21:50

Subject:	Re: NT service starts, but I still have to start MySQL as an application
From:	Tony Groves (tony...@ireland.com)
Date:	08/11/2003 06:59:12 AM
List:	com.mysql.lists.win32

Nils - thanks again.

I'm sorry, maybe my wording has been a bit ambiguous.

What I am saying is that I can start the MySQL service (as in "NT service") with no problem, either automatically or manually, but the service (which is definitely running and using about 10MB memory) does not accept connections. However, when I start MySQL as an application, then I can connect to the database, whether or not the service is also running. As I mentioned earlier, the commands used to start both the service and the application are identical.

I hope that makes things clearer.

Tony.

----- Original Message ----- From: "Nils Valentin" <ni...@knowd.co.jp> To: "Tony Groves" <tony...@ireland.com>; <win...@lists.mysql.com> Sent: Monday, August 11, 2003 2:18 PM Subject: Re: NT service starts, but I still have to start server manually.

Hi Tony,

O.K let me Step 2 steps back and one forward - just to make sure.

You said the service is running - that means your mysql server is up and running (and should also be accepting any connection from a client).

If for any reason you have to start the service manually than the mysql service (server) is NOT running, or am I missing something ??

Best regards

2003年 8月 11日月曜日 22:08、Tony Groves さんは書きました:

Nils - Thanks for your response.

There is never any problem starting the service, either manually or automatically; the problem is that the service doesn't let me connect to the database! What I have to do is to start MySQL as an application (using the same command that the service uses); then I can connect.

Thanks a lot.

----- Original Message ----- From: "Nils Valentin" <ni...@knowd.co.jp> To: "Tony Groves" <tony...@ireland.com> Cc: <mys...@lists.mysql.com> Sent: Monday, August 11, 2003 12:08 PM Subject: Re: NT service starts, but I still have to start server manually.

Hi Tony,

First, as I just saw that everything is on C:\. In this case you wont even need the two settings basedir and datadir as far as my understanding goes.

I remember that after having registered the service itself "mysqld --install", I used the command "net start mysql" to start the service. I am not sure anymore if I had to go to the services and set it to automatic startup mode or not.

I have no Windows machine installed right now to quickly check it. Also I did this on Windows 2000, but I believe thats more or less the same ;-) - I hope nobody is flaming me for that statement. ;-)

Thats all really I can remember

1) mysqld --install 2) net start mysql 3) checking if the mysql servie is set to automatic startup in the services processlist.

I hope that this helps a bit. Le me know how it went.

Best regards

2003年 8月 11日月曜日 19:50、Tony Groves さんは書きました:

Nils - Thanks for your response.

Everything is on the C: drive, in the default locations.

C:\winnt\my.ini consists of the following: [client] port=3306 [mysqld] port=3306 basedir = c:/mysql/ datadir = c:/mysql/data/ innodb_data_home_dir = c:/mysql/ibdata/ innodb_log_group_home_dir = c:/mysql/iblogs/ innodb_data_file_path = ibdata1:10M:autoextend set-variable = lower_case_table_names=0 [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-max-nt.exe All the file paths referred to there exist.

The MySQL service runs using the system account, and uses the following "ImagePath" value: c:\mysql\bin\mysqld-max-nt.exe This is the same command that I use to start the server as an application. It is strange that the service starts but does not work, while an application program using the same command does work.

Any more suggestions would be gratefully acepted.

Thanks a lot.

Tony Groves.

----- Original Message ----- From: "Nils Valentin" <ni...@knowd.co.jp> To: "Jason Kushmaul" <syna...@hiphopinfinity.com>;

<myo...@lists.mysql.com>

Cc: <tony...@ireland.com> Sent: Monday, August 11, 2003 9:52 AM Subject: Re: NT service starts, but I still have to start server manually.

Hi Tony,

Just out of interest. The NT installation itself and the MySQL server are both installed on the C:\ drive ?

In case the MySQL server would be installed not on C:\ but f.e on E:\, then I would perhaps have a solution.

In case the mysql server is installed in another drive (and only then), then you have to tell this to the MySQL server by setting the option --basedir or in the my.cnf file like

[mysqld] basedir=E:/mysql

But only then really.

Another possibility would be that the installed service is pointing to the wrong location. I had this when I uninstalled the previous version,but forgot to unregister the service. The new installation was installed, but I did not get the service up and running, as it was pointing to the old installation (which was removed ;-)

Best regards

Nils Valentin Tokyo/Japan

2003年 8月 11日月曜日 16:58、Jason Kushmaul さんは書きました:

Is there a C:\my.cnf? If not try copying a distributed my-<medium,large,small>.cnf it to C:\winnt\my.ini. I had this problem

windows NT4, It seemed that everytime I created the file C:\my.cnf, it would get renamed to C:\my_cnf.bak, but no C:\my.cnf would exist. I

read

somewhere that this happens when you do not have C:\winnt\my.ini. It

fixed

my problem of mysql appearing to start, but it wasn't...

----- Original Message ----- From: "Tony Groves" <tony...@ireland.com> To: <win...@lists.mysql.com> Sent: Sunday, August 10, 2003 5:32 PM Subject: NT service starts, but I still have to start server manually.

I have installed MySQL (latest version) on my Windows NT4 (SP6)

machine

and

have started testing it. The MySQL service starts successfully at boot

time

as expected, but I can never connect to the database until I start the server manually - it makes no difference whether the service is

already

running or not, and whether it had been started automatically or manually.

Any ideas, anybody?

http://lists.mysql.com/win32?unsub=syna...@hiphopinfinity.com