[Maria-discuss] Problem with MariaDb as a Windows service
Some person claimed here around one week ago that MariaDB would not run as service after "mysqld --install". I replied that it worked for me - but it does not with the latest stable version 5.2.3 (it did with the 5.2.3 RC) (so my apology to this person!) Windows console output: C:\maria52\bin>sc delete maria52 [SC] DeleteService LYKKEDES C:\maria52\bin>mysqld --install maria52 Service successfully installed. C:\maria52\bin>net start maria52 Tjenesten maria52 starter... Tjenesten maria52 kunne ikke startes. Der opstod en systemfejl. Systemfejlen 1067 opstod. (From Danish --> service could not start --> the system error 1067 occurred) I have tried with both old datadir and the empty one shipped with mariaDB and also my old my.ini as well as a fresh one. Also I tried to add --defaults-dir to the registry (just in case I had overlooked a my.ini copy in C:\ or C:\Windows) and adding doublequotes key manually like "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" maria52 I double checked there are no conflicts wit all settings. The command "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" .. starts the server (also when --defaults-file is omitted) .. but not as a service of course. Was it tested with the 5.2.3 GA release that it will run as a Windows service? The RC worked as a charm - but the GA will not. Any idea? (I am using Win7, 64 bit, Home Premium) Peter (Webyog)
Hi,
It seems that the service requires the --console option to operate properly.
Here is how I could make it work:
1. In the Services Control panel, open up the properties for the service
2. In the "Start Parameters" box, type "--console" without the quotation
marks
3. In the same dialog box, hit Start
Philip Stoev
----- Original Message -----
From: "Peter Laursen"
Some person claimed here around one week ago that MariaDB would not run as service after "mysqld --install". I replied that it worked for me - but it does not with the latest stable version 5.2.3 (it did with the 5.2.3 RC) (so my apology to this person!)
Windows console output:
C:\maria52\bin>sc delete maria52 [SC] DeleteService LYKKEDES
C:\maria52\bin>mysqld --install maria52 Service successfully installed.
C:\maria52\bin>net start maria52 Tjenesten maria52 starter... Tjenesten maria52 kunne ikke startes.
Der opstod en systemfejl.
Systemfejlen 1067 opstod.
(From Danish --> service could not start --> the system error 1067 occurred)
I have tried with both old datadir and the empty one shipped with mariaDB and also my old my.ini as well as a fresh one. Also I tried to add --defaults-dir to the registry (just in case I had overlooked a my.ini copy in C:\ or C:\Windows) and adding doublequotes key manually like "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" maria52
I double checked there are no conflicts wit all settings.
The command "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" .. starts the server (also when --defaults-file is omitted) .. but not as a service of course.
Was it tested with the 5.2.3 GA release that it will run as a Windows service? The RC worked as a charm - but the GA will not. Any idea? (I am using Win7, 64 bit, Home Premium)
Peter (Webyog)
--------------------------------------------------------------------------------
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
I tried. I did not work.
(let me add that I have UAC completely disabled)
-- Peter
On Sat, Nov 20, 2010 at 20:04, Philip Stoev
Hi,
It seems that the service requires the --console option to operate properly. Here is how I could make it work:
1. In the Services Control panel, open up the properties for the service 2. In the "Start Parameters" box, type "--console" without the quotation marks 3. In the same dialog box, hit Start
Philip Stoev
----- Original Message ----- From: "Peter Laursen" < peter_laursen@webyog.com> To:
; < maria-developers@lists.launchpad.net> Sent: Saturday, November 20, 2010 3:36 PM Subject: [Maria-discuss] Problem with MariaDb as a Windows service Some person claimed here around one week ago that MariaDB would not run as
service after "mysqld --install". I replied that it worked for me - but it does not with the latest stable version 5.2.3 (it did with the 5.2.3 RC) (so my apology to this person!)
Windows console output:
C:\maria52\bin>sc delete maria52 [SC] DeleteService LYKKEDES
C:\maria52\bin>mysqld --install maria52 Service successfully installed.
C:\maria52\bin>net start maria52 Tjenesten maria52 starter... Tjenesten maria52 kunne ikke startes.
Der opstod en systemfejl.
Systemfejlen 1067 opstod.
(From Danish --> service could not start --> the system error 1067 occurred)
I have tried with both old datadir and the empty one shipped with mariaDB and also my old my.ini as well as a fresh one. Also I tried to add --defaults-dir to the registry (just in case I had overlooked a my.ini copy in C:\ or C:\Windows) and adding doublequotes key manually like "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" maria52
I double checked there are no conflicts wit all settings.
The command "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" .. starts the server (also when --defaults-file is omitted) .. but not as a service of course.
Was it tested with the 5.2.3 GA release that it will run as a Windows service? The RC worked as a charm - but the GA will not. Any idea? (I am using Win7, 64 bit, Home Premium)
Peter (Webyog)
--------------------------------------------------------------------------------
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Also let me add that I am using the FULL package (.zip archive). Not the
NSIS installer. -- Peter
On Sat, Nov 20, 2010 at 20:18, Peter Laursen
I tried. I did not work. (let me add that I have UAC completely disabled)
-- Peter
On Sat, Nov 20, 2010 at 20:04, Philip Stoev
wrote: Hi,
It seems that the service requires the --console option to operate properly. Here is how I could make it work:
1. In the Services Control panel, open up the properties for the service 2. In the "Start Parameters" box, type "--console" without the quotation marks 3. In the same dialog box, hit Start
Philip Stoev
----- Original Message ----- From: "Peter Laursen" < peter_laursen@webyog.com> To:
; < maria-developers@lists.launchpad.net> Sent: Saturday, November 20, 2010 3:36 PM Subject: [Maria-discuss] Problem with MariaDb as a Windows service Some person claimed here around one week ago that MariaDB would not run
as service after "mysqld --install". I replied that it worked for me - but it does not with the latest stable version 5.2.3 (it did with the 5.2.3 RC) (so my apology to this person!)
Windows console output:
C:\maria52\bin>sc delete maria52 [SC] DeleteService LYKKEDES
C:\maria52\bin>mysqld --install maria52 Service successfully installed.
C:\maria52\bin>net start maria52 Tjenesten maria52 starter... Tjenesten maria52 kunne ikke startes.
Der opstod en systemfejl.
Systemfejlen 1067 opstod.
(From Danish --> service could not start --> the system error 1067 occurred)
I have tried with both old datadir and the empty one shipped with mariaDB and also my old my.ini as well as a fresh one. Also I tried to add --defaults-dir to the registry (just in case I had overlooked a my.ini copy in C:\ or C:\Windows) and adding doublequotes key manually like "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" maria52
I double checked there are no conflicts wit all settings.
The command "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" .. starts the server (also when --defaults-file is omitted) .. but not as a service of course.
Was it tested with the 5.2.3 GA release that it will run as a Windows service? The RC worked as a charm - but the GA will not. Any idea? (I am using Win7, 64 bit, Home Premium)
Peter (Webyog)
--------------------------------------------------------------------------------
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hello,
Can you please check what ends up in your Application log in the Event
Viewer? When I get error 1067 from "net start", I get two entries in the
Event Viewer. One is an Error entry saying "Aborting ... For more
information, see Help and Support Center" and the other is an Information
entry saying "MySQL: Shutdown complete".
Note that after you add --console, you need to use the Start button located
in the same dialog bog. Otherwise, Windows will not honor the --console
option.
Philip Stoev
----- Original Message -----
From: "Peter Laursen"
I tried. I did not work. (let me add that I have UAC completely disabled)
-- Peter
On Sat, Nov 20, 2010 at 20:04, Philip Stoev
wrote: Hi,
It seems that the service requires the --console option to operate properly. Here is how I could make it work:
1. In the Services Control panel, open up the properties for the service 2. In the "Start Parameters" box, type "--console" without the quotation marks 3. In the same dialog box, hit Start
Philip Stoev
----- Original Message ----- From: "Peter Laursen" < peter_laursen@webyog.com> To:
; < maria-developers@lists.launchpad.net> Sent: Saturday, November 20, 2010 3:36 PM Subject: [Maria-discuss] Problem with MariaDb as a Windows service Some person claimed here around one week ago that MariaDB would not run as
service after "mysqld --install". I replied that it worked for me - but it does not with the latest stable version 5.2.3 (it did with the 5.2.3 RC) (so my apology to this person!)
Windows console output:
C:\maria52\bin>sc delete maria52 [SC] DeleteService LYKKEDES
C:\maria52\bin>mysqld --install maria52 Service successfully installed.
C:\maria52\bin>net start maria52 Tjenesten maria52 starter... Tjenesten maria52 kunne ikke startes.
Der opstod en systemfejl.
Systemfejlen 1067 opstod.
(From Danish --> service could not start --> the system error 1067 occurred)
I have tried with both old datadir and the empty one shipped with mariaDB and also my old my.ini as well as a fresh one. Also I tried to add --defaults-dir to the registry (just in case I had overlooked a my.ini copy in C:\ or C:\Windows) and adding doublequotes key manually like "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" maria52
I double checked there are no conflicts wit all settings.
The command "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" .. starts the server (also when --defaults-file is omitted) .. but not as a service of course.
Was it tested with the 5.2.3 GA release that it will run as a Windows service? The RC worked as a charm - but the GA will not. Any idea? (I am using Win7, 64 bit, Home Premium)
Peter (Webyog)
--------------------------------------------------------------------------------
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
I do not think the 'Event Veiwer' interface is quite the same in Win7 as
earlier versions.
I go to adminstration .. logbog .. administrative hændelser (administration
.. logs .. administrative events)
I find
1) one log item with 'owner' "Sercice Control Manager": "Tjenesten maria52
afsluttede uventet. Dette er sket 4 gang(e)." (English translation: the
maria53 service stopped unexpectedly. This has happened 4 times!)
and
2) another log item with 'owner' "MySQL": "For more information, see Help
and Support Center at http://www.mysql.com. "
.. and I *do* use the Start button located in the same dialog bog! :-)
-- Peter
On Sat, Nov 20, 2010 at 20:41, Philip Stoev
Hello,
Can you please check what ends up in your Application log in the Event Viewer? When I get error 1067 from "net start", I get two entries in the Event Viewer. One is an Error entry saying "Aborting ... For more information, see Help and Support Center" and the other is an Information entry saying "MySQL: Shutdown complete".
Note that after you add --console, you need to use the Start button located in the same dialog bog. Otherwise, Windows will not honor the --console option.
Philip Stoev
----- Original Message ----- From: "Peter Laursen" < peter_laursen@webyog.com> To: "Philip Stoev"
Cc: ; < maria-developers@lists.launchpad.net> Sent: Saturday, November 20, 2010 9:18 PM Subject: Re: [Maria-discuss] Problem with MariaDb as a Windows service I tried. I did not work.
(let me add that I have UAC completely disabled)
-- Peter
On Sat, Nov 20, 2010 at 20:04, Philip Stoev
wrote: Hi,
It seems that the service requires the --console option to operate properly. Here is how I could make it work:
1. In the Services Control panel, open up the properties for the service 2. In the "Start Parameters" box, type "--console" without the quotation marks 3. In the same dialog box, hit Start
Philip Stoev
----- Original Message ----- From: "Peter Laursen" < peter_laursen@webyog.com> To:
; < maria-developers@lists.launchpad.net> Sent: Saturday, November 20, 2010 3:36 PM Subject: [Maria-discuss] Problem with MariaDb as a Windows service Some person claimed here around one week ago that MariaDB would not run as
service after "mysqld --install". I replied that it worked for me - but it does not with the latest stable version 5.2.3 (it did with the 5.2.3 RC) (so my apology to this person!)
Windows console output:
C:\maria52\bin>sc delete maria52 [SC] DeleteService LYKKEDES
C:\maria52\bin>mysqld --install maria52 Service successfully installed.
C:\maria52\bin>net start maria52 Tjenesten maria52 starter... Tjenesten maria52 kunne ikke startes.
Der opstod en systemfejl.
Systemfejlen 1067 opstod.
(From Danish --> service could not start --> the system error 1067 occurred)
I have tried with both old datadir and the empty one shipped with mariaDB and also my old my.ini as well as a fresh one. Also I tried to add --defaults-dir to the registry (just in case I had overlooked a my.ini copy in C:\ or C:\Windows) and adding doublequotes key manually like "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" maria52
I double checked there are no conflicts wit all settings.
The command "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" .. starts the server (also when --defaults-file is omitted) .. but not as a service of course.
Was it tested with the 5.2.3 GA release that it will run as a Windows service? The RC worked as a charm - but the GA will not. Any idea? (I am using Win7, 64 bit, Home Premium)
Peter (Webyog)
--------------------------------------------------------------------------------
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
On Sat, Nov 20, 2010 at 21:11, Peter Laursen
I do not think the 'Event Veiwer' interface is quite the same in Win7 as earlier versions.
I go to adminstration .. logbog .. administrative hændelser (administration .. logs .. administrative events)
I find 1) one log item with 'owner' "Sercice Control Manager": "Tjenesten maria52 afsluttede uventet. Dette er sket 4 gang(e)." (English translation: the maria5 -- 2, of course service stopped unexpectedly. This has happened 4 times!) and 2) another log item with 'owner' "MySQL": "For more information, see Help and Support Center at http://www.mysql.com. "
.. and I *do* use the Start button located in the same dialog bog! :-)
-- Peter
On Sat, Nov 20, 2010 at 20:41, Philip Stoev
wrote: Hello,
Can you please check what ends up in your Application log in the Event Viewer? When I get error 1067 from "net start", I get two entries in the Event Viewer. One is an Error entry saying "Aborting ... For more information, see Help and Support Center" and the other is an Information entry saying "MySQL: Shutdown complete".
Note that after you add --console, you need to use the Start button located in the same dialog bog. Otherwise, Windows will not honor the --console option.
Philip Stoev
----- Original Message ----- From: "Peter Laursen" < peter_laursen@webyog.com> To: "Philip Stoev"
Cc: ; < maria-developers@lists.launchpad.net> Sent: Saturday, November 20, 2010 9:18 PM Subject: Re: [Maria-discuss] Problem with MariaDb as a Windows service I tried. I did not work.
(let me add that I have UAC completely disabled)
-- Peter
On Sat, Nov 20, 2010 at 20:04, Philip Stoev
wrote: Hi,
It seems that the service requires the --console option to operate properly. Here is how I could make it work:
1. In the Services Control panel, open up the properties for the service 2. In the "Start Parameters" box, type "--console" without the quotation marks 3. In the same dialog box, hit Start
Philip Stoev
----- Original Message ----- From: "Peter Laursen" < peter_laursen@webyog.com> To:
; < maria-developers@lists.launchpad.net> Sent: Saturday, November 20, 2010 3:36 PM Subject: [Maria-discuss] Problem with MariaDb as a Windows service Some person claimed here around one week ago that MariaDB would not run as
service after "mysqld --install". I replied that it worked for me - but it does not with the latest stable version 5.2.3 (it did with the 5.2.3 RC) (so my apology to this person!)
Windows console output:
C:\maria52\bin>sc delete maria52 [SC] DeleteService LYKKEDES
C:\maria52\bin>mysqld --install maria52 Service successfully installed.
C:\maria52\bin>net start maria52 Tjenesten maria52 starter... Tjenesten maria52 kunne ikke startes.
Der opstod en systemfejl.
Systemfejlen 1067 opstod.
(From Danish --> service could not start --> the system error 1067 occurred)
I have tried with both old datadir and the empty one shipped with mariaDB and also my old my.ini as well as a fresh one. Also I tried to add --defaults-dir to the registry (just in case I had overlooked a my.ini copy in C:\ or C:\Windows) and adding doublequotes key manually like "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" maria52
I double checked there are no conflicts wit all settings.
The command "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" .. starts the server (also when --defaults-file is omitted) .. but not as a service of course.
Was it tested with the 5.2.3 GA release that it will run as a Windows service? The RC worked as a charm - but the GA will not. Any idea? (I am using Win7, 64 bit, Home Premium)
Peter (Webyog)
--------------------------------------------------------------------------------
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (2)
-
Peter Laursen
-
Philip Stoev