On Wed, 2014-10-29 at 11:04 -0700, Paul Fee wrote:
> Hi all (and Stephen Gallagher),
> 
> I'm using CentOS7 + EPEL with ReviewBoard-2.0.11  (fresh install +
> today's updates).  My site is listed in /etc/reviewboard/sites.  When
> httpd starts up, it checks if any sites need upgraded.  I'm using a
> mariadb database.
> 
> When I reboot the box, httpd fails to startup.
> 
> ========
> $ sudo systemctl status httpd
> httpd.service - The Apache HTTP Server
>    Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled)
>   Drop-In: /usr/lib/systemd/system/httpd.service.d
>            └─reviewboard-sites.conf
>    Active: failed (Result: exit-code) since Wed 2014-10-29 17:42:28
> GMT; 16s ago
>   Process: 1184 ExecStartPre=/usr/bin/rb-site upgrade --all-sites
> (code=exited, status=1/FAILURE)
> 
> Oct 29 17:42:28 centos7 rb-site[1184]: File
> "/usr/lib/python2.7/site-packages/django/db/backends/mysql/base.py",
> line 435, in get_new_connection
> Oct 29 17:42:28 centos7 rb-site[1184]: conn =
> Database.connect(**conn_params)
> Oct 29 17:42:28 centos7 rb-site[1184]: File
> "/usr/lib64/python2.7/site-packages/MySQLdb/__init__.py", line 81, in
> Connect
> Oct 29 17:42:28 centos7 rb-site[1184]: return Connection(*args,
> **kwargs)
> Oct 29 17:42:28 centos7 rb-site[1184]: File
> "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 187,
> in __init__
> Oct 29 17:42:28 centos7 rb-site[1184]: super(Connection,
> self).__init__(*args, **kwargs2)
> Oct 29 17:42:28 centos7 rb-site[1184]:
> django.db.utils.OperationalError: (2002, "Can't connect to local MySQL
> server through socket '...k' (2)")
> Oct 29 17:42:28 centos7 systemd[1]: httpd.service: control process
> exited, code=exited status=1
> Oct 29 17:42:28 centos7 systemd[1]: Failed to start The Apache HTTP
> Server.
> Oct 29 17:42:28 centos7 systemd[1]: Unit httpd.service entered failed
> state.
> Hint: Some lines were ellipsized, use -l to show in full.
> ==========
> 
> I can manually start httpd as mariadb is now running by the time I've
> logged in.
> 
> If I remove the /etc/reviewboard/sites file, the issue goes away.  If
> I restore the file, the issue comes back.
> 
> It looks like rb-site upgrade is being run before the database is
> available.  Should systemd be using socket activation to start mariadb
> once a connection attempt is made?  I believe
> the /etc/reviewboard/sites facility is unique to Fedora/EPEL, so this
> is could be a distro issue rather than ReviewBoard.


MariaDB does not currently support socket-activation. What you need to
do as a workaround right now is to add the following lines
to /usr/lib/systemd/system/httpd.service.d/reviewboard-sites.conf:



[Unit]
After=postgresql.service mariadb.service mysql.service



I'll roll this into the Fedora and EPEL packages. I hadn't thought of it
previously. (Note: it's safe to list all of them on the After= line as
this only controls ordering; it doesn't cause any of them to be started
that would not already have been).

Now I just have to hope that Apache never grows a dependency on a
database... :)

-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to