Debian Bug report logs - #765425
mysql-server-5.5: mysql-sever lacks a systemd .service file.

Reply or subscribe to this bug.

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: Thayne Harbaugh <thayne.l.h@gmail.com>

To: Debian Bug Tracking System <submit@bugs.debian.org>

Subject: mysql-server-5.5: mysql-sever lacks a systemd .service file.

Date: Tue, 14 Oct 2014 17:39:04 -0600

Package: mysql-server-5.5
Version: 5.5.39-1
Severity: normal

Dear Maintainer,

   The mysql-server-5.5 .deb lacks a systemd .service file.

   * What led up to the situation?

     Saltstack (salt-master .deb) is unable to manage mysql-server on
     a system running systemd.  A /lib/systemd/system/mysql.service
     file will address this.

   * What exactly did you do (or not do) that was effective (or
     ineffective)?

     Potentially the salt systemd module can be expanded to manage
     services running in SysVinit compatibility mode.  Some simple
     tweaks of the salt module were insufficient.

     The /etc/init.d/mysql script is more sophisticated than most.  It
     does not lend itself to a simple .service implementation.

   * Additional information:

     There is a similar Fedora bug that has been addressed and closed:

       https://bugzilla.redhat.com/show_bug.cgi?id=714426

     It appears this was addressed with a combination of a .service
     file as well as some additional scripts.


-- System Information:
Debian Release: jessie/sid
  APT prefers testing
  APT policy: (700, 'testing'), (300, 'unstable'), (200, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.16-2-amd64 (SMP w/8 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-server-5.5 depends on:
ii  adduser                3.113+nmu3
ii  debconf [debconf-2.0]  1.5.53
ii  initscripts            2.88dsf-53.4
ii  libc6                  2.19-11
ii  libdbi-perl            1.631-3+b1
ii  libgcc1                1:4.9.1-16
ii  libstdc++6             4.9.1-16
ii  lsb-base               4.1+Debian13
ii  mysql-client-5.5       5.5.39-1
ii  mysql-common           5.5.39-1
ii  mysql-server-core-5.5  5.5.39-1
ii  passwd                 1:4.2-2+b1
ii  perl                   5.20.1-1
ii  psmisc                 22.21-2
ii  zlib1g                 1:1.2.8.dfsg-2

Versions of packages mysql-server-5.5 recommends:
ii  libhtml-template-perl  2.95-1

Versions of packages mysql-server-5.5 suggests:
ii  mailutils [mailx]  1:2.99.98-1.4
pn  tinyca             <none>

-- debconf information:
  mysql-server/no_upgrade_when_using_ndb:
  mysql-server-5.5/start_on_boot: true
  mysql-server-5.5/postrm_remove_databases: false
  mysql-server-5.5/really_downgrade: false
  mysql-server-5.5/nis_warning:
  mysql-server/error_setting_password:
  mysql-server/password_mismatch:

Message #10 received at 765425@bugs.debian.org (full text, mbox, reply):

From: Otto Kekäläinen <otto@seravo.fi>

To: Thayne Harbaugh <thayne.l.h@gmail.com>, 765425@bugs.debian.org

Subject: Re: [debian-mysql] Bug#765425: mysql-server-5.5: mysql-sever lacks a systemd .service file.

Date: Wed, 15 Oct 2014 22:27:11 +0300

A systemd file for MariaDB would be good too. Upstream does not
provide one and the different downstream versions are wildly different
so this requires more work than just to pick one, see
https://mariadb.atlassian.net/browse/MDEV-427?focusedCommentId=59306&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-59306

Message #15 received at 765425@bugs.debian.org (full text, mbox, reply):

From: Clint Byrum <spamaps@debian.org>

To: Thayne Harbaugh <thayne.l.h@gmail.com>

Cc: 765425 <765425@bugs.debian.org>

Subject: Re: [debian-mysql] Bug#765425: mysql-server-5.5: mysql-sever lacks a systemd .service file.

Date: Wed, 15 Oct 2014 15:02:12 -0700

Excerpts from Thayne Harbaugh's message of 2014-10-14 16:39:04 -0700:
> Package: mysql-server-5.5
> Version: 5.5.39-1
> Severity: normal
> 
> Dear Maintainer,
> 

Hi Thayne. Thanks for taking the time to report a bug. It is much
appreciated and your thoughts are valued.

>    The mysql-server-5.5 .deb lacks a systemd .service file.
> 
>    * What led up to the situation?
> 
>      Saltstack (salt-master .deb) is unable to manage mysql-server on
>      a system running systemd.  A /lib/systemd/system/mysql.service
>      file will address this.
> 

Salt is broken then. There are _thousands_ of perfectly good working
sysvinit scripts. Ansible is quite capable of managing a hybrid system,
perhaps copy their approach?

>    * What exactly did you do (or not do) that was effective (or
>      ineffective)?
> 
>      Potentially the salt systemd module can be expanded to manage
>      services running in SysVinit compatibility mode.  Some simple
>      tweaks of the salt module were insufficient.
> 
>      The /etc/init.d/mysql script is more sophisticated than most.  It
>      does not lend itself to a simple .service implementation.
> 

Agreed on all points.

>    * Additional information:
> 
>      There is a similar Fedora bug that has been addressed and closed:
> 
>        https://bugzilla.redhat.com/show_bug.cgi?id=714426
> 
>      It appears this was addressed with a combination of a .service
>      file as well as some additional scripts.
> 

I know that your intentions, and those of the Fedora developers above
are well meaning. However, IMO this is mostly a waste of time. MySQL is
an application, and isn't going to be part of early-boot plumbing any
time soon. So having a systemd service is entirely for style points.

Send a report that this bug log contains spam.