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, > >> > 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 > >> >> > >> >>start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone > >> >> > >> >>kicks mySQL off on Win2K, NT and XP very nicely, thank you :) > >> >> > >> >>If your mySQL is in c:\ then > >> >> > >> >>start c:\mysql\bin\mysqld-nt.exe --standalone > >> >> > >> >>should work > >> >> > >> >>But I could be wrong, I often am.... > >> >> > >> >> > >> >>Pierre > >> >> > >> >> > >> >> > >> >> > >> >> > >> >>Alexander Hampel wrote: > >> >> > >> >>> Hi mailing list, > >> >>> > >> >>> I can't start mysqld-nt as I get the eror message 1067. If I start > >> >>> winmysqladmin.exe there is no server visible. > >> >>> > >> >>> The manual tell me in part 2.4 Post-installation Setup and > >> >Testing that I > >> >>> should start the script ./scripts/mysql_install_db but this > >> >script is not > >> >>> availabale (at all) at my Windows distribution. > >> >>> > >> >>> Any ideas what's wrong? > >> >>> > >> >>> > >> >>> Thank you, > >> >>> A:lex > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> >--------------------------------------------------------------------- > >> >>> Before posting, please check: > >> >>> http://www.mysql.com/manual.php (the manual) > >> >>> http://lists.mysql.com/ (the list archive) > >> >>> > >> >>> To request this thread, e-mail <[EMAIL PROTECTED]> > >> >>> To unsubscribe, e-mail > >> >>> <[EMAIL PROTECTED]> > >> >>> Trouble unsubscribing? Try: > >http://lists.mysql.com/php/unsubscribe.php > >> >>> > >> >>> > >> >>> > >> >>> >--------------------------------------------------------------------- > >> >>> Before posting, please check: > >> >>> http://www.mysql.com/manual.php (the manual) > >> >>> http://lists.mysql.com/ (the list archive) > >> >>> > >> >>> To request this thread, e-mail <[EMAIL PROTECTED]> > >> >>> To unsubscribe, e-mail > >> >><[EMAIL PROTECTED]> > >> >>> Trouble unsubscribing? Try: > >http://lists.mysql.com/php/unsubscribe.php > >> >>> > >> >>> > >> >>> > >> >>> > >> >> > >> >> > >> >>-- > >> >>Pierre du Parte > >> >>Final Filer Software > >> >>349 Worrigee Road > >> >>Worrigee, NSW, Australia 2540 > >> >>http://www.finalfiler.com > >> >> > >> >>Phone 61 2 44216374 > >> >>Mobile 0413 483 066 > >> >> > >> >>"If it feels good, do it!" > >> >> > >> >> > >> >>--------------------------------------------------------------------- > >> >>Before posting, please check: > >> >> http://www.mysql.com/manual.php (the manual) > >> >> http://lists.mysql.com/ (the list archive) > >> >> > >> >>To request this thread, e-mail <[EMAIL PROTECTED]> > >> >>To unsubscribe, e-mail > >> >><[EMAIL PROTECTED]> > >> >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >> >> > >> > > >> > > >> > > >> >--------------------------------------------------------------------- > >> >Before posting, please check: > >> > http://www.mysql.com/manual.php (the manual) > >> > http://lists.mysql.com/ (the list archive) > >> > > >> >To request this thread, e-mail <[EMAIL PROTECTED]> > >> >To unsubscribe, e-mail > >> ><[EMAIL PROTECTED]> > >> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >> > > >> > > >> > > >> > > >> > >> > >> > >> > > > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
