RE: Finally found mysql-nt service error 1061 1067
At 20:02 18/03/02 -0600, Gerald R. Jensen wrote: Hi, For to avoid the install of the service in local account I will add code for to verify if the user that is making the install process has administrator rights and display the error message if he/she doesn't have. Regards, Miguel >Alex: > >I doubt this issue is a 'general mysql-nt problem'. In truth, MySQL is a >very well-designed, well-behaved service. > >I have installed about 80 MySQL servers on customer-owned WinNT/2K servers. >If this were a 'general mysql-nt problem', I would have had to set a login >account in the SCM for each one. To the best of my recollection, I have >only had to do it twice in a little more than two years. > >I tend to think it has something to do with permissions on the machine or >perhaps a general configuration setting in WinNT/2K, but I can't >prove/disprove that. > >Miguel Solorzano is a MySQL full-timer with a good deal of experience in >this area ... he reads the list, and may be able to offer some insight >here. > >Gerald Jensen > >-Original Message- >From: Alexander Hampel [SMTP:[EMAIL PROTECTED]] >Sent: Monday, March 18, 2002 9:05 AM >To: [EMAIL PROTECTED] >Cc: Gerald Jensen; [EMAIL PROTECTED] >Subject:Finally found mysql-nt service error 1061 1067 > >Hi Gerald, > >The 'System-Account' did not work BUT the 'Admin' user account did! >You were right :-) >How comes? > >That's what I always do: >(1) Install a service on 'System Account' and than >(2) change it to an user account of my choice > >After 2 days wasting time trying to get the installation run, >I ask myself how things like this can happen? >Seems to be a 'general mysql-nt problem' if I take a look at how >many questions arise to this specific issue. > >Anyway - thanks to all of you helping me by giving me advices :-) >Special thanks to you Gerald, > >so long A:lex > > > >-Ursprungliche Nachricht- > >Von: Gerald Jensen [mailto:[EMAIL PROTECTED]] > >Gesendet: Montag, 18. Marz 2002 15:13 > >An: [EMAIL PROTECTED] > >Betreff: Re: NT service problem > > > > > >Then you may have a problem with services running under the System Account > >on this machine. > > > >Try this: > >- Go into the Control Panel's Service Control Manager > >- Click on the MySQL service > >- Click on the 'Startup' button > >- Make sure 'Automatic' is selected > >- Select 'This Account' (instead of 'System Account') > >- Choose an Admin-level user and set the correct password > >- Click 'OK' then click 'Start' > > > >Gerald Jensen > > > >- Original Message - > >From: "Alexander Hampel" <[EMAIL PROTECTED]> > >To: "Gerald R. Jensen" <[EMAIL PROTECTED]> > >Sent: Monday, March 18, 2002 7:45 AM > >Subject: AW: NT service problem > > > > > >> Thanks - my.ini is used. > >> Tried to use come of your parameters - but nothing changed. > >> The interesting part: the standalone run is fine, the service > >> part is wrong -> so it has something todo with the service ?!? > >> > >> So long A:lex > >> > >> > >> > >> >-Ursprungliche Nachricht- > >> >Von: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] > >> >Gesendet: Montag, 18. Marz 2002 13:40 > >> >An: [EMAIL PROTECTED]; [EMAIL PROTECTED] > >> >Betreff: Re: NT service problem > >> > > >> > > >> >Check the location of the configuration file (should be either >c:\my.cnf > >~ > >> >OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a > >> >sample: > >> > > >> >[client] > >> >#password=my_password > >> >port=3306 > >> >#socket=MYSQL > >> ># > >> >[mysqld] > >> >port=3306 > >> >#socket=MYSQL > >> >skip-locking > >> >#enable-locking > >> >set-variable = key_buffer=16M > >> >set-variable = max_allowed_packet=1M > >> >set-variable = thread_stack=128K > >> >set-variable = flush_time=1800 > >> >log=C:/mysql/mysql.log > >> >basedir = C:/MYSQL/ > >> ># > >> >[mysqldump] > >> >quick > >> >set-variable = max_allowed_packet=16M > >> ># > >> >[MYSQL] > >> >no-auto-rehash > >> ># > >> >[isamchk] > >> >set-variable= KEY=16M > >> ># > >> >[client_fltk] > >> >help_file= C:\\MYSQL\guiclient\MYSQL.help > >> >client_file= C:\\MYSQL\mysql.opt > >> >history_length=20 > >> >database = goetznet > >> >queries_root= C:\\MYSQL\queries > >> >last_database_file= C:\\MYSQL\lastdb > >> > > >> > > >> > > >> >- Original Message - > >> >From: "Alexander Hampel" <[EMAIL PROTECTED]> > >> >To: <[EMAIL PROTECTED]> > >> >Sent: Monday, March 18, 2002 1:37 AM > >> >Subject: NT service problem > >> > > >> > > >> >Hi Pierre, > >> > > >> >Thanks, for your help. > >> >That's what I exaclty do and this is for '--standalone' fine. > >> >But the point ist, I want to start mysqld-nt as NT service - > >> >and this is the problem - it wouldn't let me start it as service: > >> >>C:\>net start mysql > >> >>System error 1069 > >> >>Could not start service > >> > > >> >The service is an important issue. Lets you run a programm under > >> >different user rights. > >> > > >> >Probably I'll find some other solution. > >> > > >> >Thanks, > >>
RE: Finally found mysql-nt service error 1061 1067
Alex: I doubt this issue is a 'general mysql-nt problem'. In truth, MySQL is a very well-designed, well-behaved service. I have installed about 80 MySQL servers on customer-owned WinNT/2K servers. If this were a 'general mysql-nt problem', I would have had to set a login account in the SCM for each one. To the best of my recollection, I have only had to do it twice in a little more than two years. I tend to think it has something to do with permissions on the machine or perhaps a general configuration setting in WinNT/2K, but I can't prove/disprove that. Miguel Solorzano is a MySQL full-timer with a good deal of experience in this area ... he reads the list, and may be able to offer some insight here. Gerald Jensen -Original Message- From: Alexander Hampel [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 9:05 AM To: [EMAIL PROTECTED] Cc: Gerald Jensen; [EMAIL PROTECTED] Subject:Finally found mysql-nt service error 1061 1067 Hi Gerald, The 'System-Account' did not work BUT the 'Admin' user account did! You were right :-) How comes? That's what I always do: (1) Install a service on 'System Account' and than (2) change it to an user account of my choice After 2 days wasting time trying to get the installation run, I ask myself how things like this can happen? Seems to be a 'general mysql-nt problem' if I take a look at how many questions arise to this specific issue. Anyway - thanks to all of you helping me by giving me advices :-) Special thanks to you Gerald, so long A:lex >-Ursprungliche Nachricht- >Von: Gerald Jensen [mailto:[EMAIL PROTECTED]] >Gesendet: Montag, 18. Marz 2002 15:13 >An: [EMAIL PROTECTED] >Betreff: Re: NT service problem > > >Then you may have a problem with services running under the System Account >on this machine. > >Try this: >- Go into the Control Panel's Service Control Manager >- Click on the MySQL service >- Click on the 'Startup' button >- Make sure 'Automatic' is selected >- Select 'This Account' (instead of 'System Account') >- Choose an Admin-level user and set the correct password >- Click 'OK' then click 'Start' > >Gerald Jensen > >- Original Message - >From: "Alexander Hampel" <[EMAIL PROTECTED]> >To: "Gerald R. Jensen" <[EMAIL PROTECTED]> >Sent: Monday, March 18, 2002 7:45 AM >Subject: AW: NT service problem > > >> Thanks - my.ini is used. >> Tried to use come of your parameters - but nothing changed. >> The interesting part: the standalone run is fine, the service >> part is wrong -> so it has something todo with the service ?!? >> >> So long A:lex >> >> >> >> >-Ursprungliche Nachricht- >> >Von: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] >> >Gesendet: Montag, 18. Marz 2002 13:40 >> >An: [EMAIL PROTECTED]; [EMAIL PROTECTED] >> >Betreff: Re: NT service problem >> > >> > >> >Check the location of the configuration file (should be either c:\my.cnf >~ >> >OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a >> >sample: >> > >> >[client] >> >#password=my_password >> >port=3306 >> >#socket=MYSQL >> ># >> >[mysqld] >> >port=3306 >> >#socket=MYSQL >> >skip-locking >> >#enable-locking >> >set-variable = key_buffer=16M >> >set-variable = max_allowed_packet=1M >> >set-variable = thread_stack=128K >> >set-variable = flush_time=1800 >> >log=C:/mysql/mysql.log >> >basedir = C:/MYSQL/ >> ># >> >[mysqldump] >> >quick >> >set-variable = max_allowed_packet=16M >> ># >> >[MYSQL] >> >no-auto-rehash >> ># >> >[isamchk] >> >set-variable= KEY=16M >> ># >> >[client_fltk] >> >help_file= C:\\MYSQL\guiclient\MYSQL.help >> >client_file= C:\\MYSQL\mysql.opt >> >history_length=20 >> >database = goetznet >> >queries_root= C:\\MYSQL\queries >> >last_database_file= C:\\MYSQL\lastdb >> > >> > >> > >> >- Original Message - >> >From: "Alexander Hampel" <[EMAIL PROTECTED]> >> >To: <[EMAIL PROTECTED]> >> >Sent: Monday, March 18, 2002 1:37 AM >> >Subject: NT service problem >> > >> > >> >Hi Pierre, >> > >> >Thanks, for your help. >> >That's what I exaclty do and this is for '--standalone' fine. >> >But the point ist, I want to start mysqld-nt as NT service - >> >and this is the problem - it wouldn't let me start it as service: >> >>C:\>net start mysql >> >>System error 1069 >> >>Could not start service >> > >> >The service is an important issue. Lets you run a programm under >> >different user rights. >> > >> >Probably I'll find some other solution. >> > >> >Thanks, >> > A:lex >> > >> > >> > >> >>-Ursprungliche Nachricht- >> >>Von: Pierre du Parte [mailto:[EMAIL PROTECTED]] >> >>Gesendet: Montag, 18. Marz 2002 08:04 >> >>An: [EMAIL PROTECTED] >> >>Cc: [EMAIL PROTECTED] >> >>Betreff: Re: New to MySQL - can't start server :-( >> >> >> >> >> >>Hi Alexander, >> >>I use the PHPDEV compilation for local PHP/mySQL development work >> >>(http://www.firepages.com.au/devindex.htm for a no-brainer approach to >> >>getting PHP/mySQL/Apache up and running in seconds!) >> >> >> >>Anyway, for me >> >> >> >>star