<div dir="ltr">Does your SQL database string contain 127.0.0.1 or localhost?<div><br></div><div><a href="https://dev.mysql.com/doc/refman/5.5/en/connecting.html">https://dev.mysql.com/doc/refman/5.5/en/connecting.html</a></div><div><br></div><div><p style="margin:0px 0px 15px;padding:0px;border:0px;outline:0px;font-size:13.3488px;vertical-align:baseline;line-height:23.3604px;color:rgb(85,85,85);font-family:'Open Sans',Arial,Helvetica,sans-serif;background-position:initial initial;background-repeat:initial initial">On Unix, MySQL programs treat the host name <code class="literal" style="margin:0px;padding:0px;border:0px;outline:0px;font-size:12.6814px;vertical-align:baseline;color:black;font-family:'Courier New',Courier,fixed,monospace;background-color:transparent;background-position:initial initial;background-repeat:initial initial">localhost</code> specially, in a way that is likely different from what you expect compared to other network-based programs. For connections to <code class="literal" style="margin:0px;padding:0px;border:0px;outline:0px;font-size:12.6814px;vertical-align:baseline;color:black;font-family:'Courier New',Courier,fixed,monospace;background-color:transparent;background-position:initial initial;background-repeat:initial initial">localhost</code>, MySQL programs attempt to connect to the local server by using a Unix socket file. This occurs even if a <a class="link" href="https://dev.mysql.com/doc/refman/5.5/en/connecting.html#option_general_port" style="margin:0px;padding:0px;font-size:13.3488px;vertical-align:baseline;text-decoration:none;color:rgb(0,116,163);background:transparent"><code class="option" style="margin:0px;padding:0px;border:0px;outline:0px;font-size:12.6814px;vertical-align:baseline;text-decoration:underline;color:black;font-family:'Courier New',Courier,fixed,monospace;background-color:transparent;background-position:initial initial;background-repeat:initial initial">--port</code></a> or <code class="option" style="margin:0px;padding:0px;border:0px;outline:0px;font-size:12.6814px;vertical-align:baseline;color:black;font-family:'Courier New',Courier,fixed,monospace;background-color:transparent;background-position:initial initial;background-repeat:initial initial">-P</code> option is given to specify a port number. To ensure that the client makes a TCP/IP connection to the local server, use <a class="link" href="https://dev.mysql.com/doc/refman/5.5/en/connecting.html#option_general_host" style="margin:0px;padding:0px;font-size:13.3488px;vertical-align:baseline;text-decoration:none;color:rgb(0,116,163);background:transparent"><code class="option" style="margin:0px;padding:0px;border:0px;outline:0px;font-size:12.6814px;vertical-align:baseline;text-decoration:underline;color:black;font-family:'Courier New',Courier,fixed,monospace;background-color:transparent;background-position:initial initial;background-repeat:initial initial">--host</code></a> or <code class="option" style="margin:0px;padding:0px;border:0px;outline:0px;font-size:12.6814px;vertical-align:baseline;color:black;font-family:'Courier New',Courier,fixed,monospace;background-color:transparent;background-position:initial initial;background-repeat:initial initial">-h</code> to specify a host name value of <code class="literal" style="margin:0px;padding:0px;border:0px;outline:0px;font-size:12.6814px;vertical-align:baseline;color:black;font-family:'Courier New',Courier,fixed,monospace;background-color:transparent;background-position:initial initial;background-repeat:initial initial">127.0.0.1</code>, or the IP address or name of the local server. You can also specify the connection protocol explicitly, even for <code class="literal" style="margin:0px;padding:0px;border:0px;outline:0px;font-size:12.6814px;vertical-align:baseline;color:black;font-family:'Courier New',Courier,fixed,monospace;background-color:transparent;background-position:initial initial;background-repeat:initial initial">localhost</code>, by using the <a class="link" href="https://dev.mysql.com/doc/refman/5.5/en/connecting.html#option_general_protocol" style="margin:0px;padding:0px;font-size:13.3488px;vertical-align:baseline;text-decoration:none;color:rgb(0,116,163);background:transparent"><code class="option" style="margin:0px;padding:0px;border:0px;outline:0px;font-size:12.6814px;vertical-align:baseline;text-decoration:underline;color:black;font-family:'Courier New',Courier,fixed,monospace;background-color:transparent;background-position:initial initial;background-repeat:initial initial">--protocol=TCP</code></a> option. For example:</p><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Feb 5, 2016 at 5:01 PM, Steve Searles <span dir="ltr"><<a href="mailto:SSearles@zimcom.net" target="_blank">SSearles@zimcom.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>I am having a problem with Designate when installing the DB. Apt runs through the configuration portion and I receive a ECONNREFUSED when connecting to localhost as the mysql server. Mysql connections work fine from the command line to localhost, 127.0.0.1.
Has anyone seen this before? </div>
<div><br>
</div>
<div>
<div>dbconfig-common: writing config to /etc/dbconfig-common/designate-common.conf</div>
<div>granting access to database designatedb for designate-common@localhost: success.</div>
<div>verifying access for designate-common@localhost: success.</div>
<div>creating database designatedb: success.</div>
<div>verifying database designatedb exists: success.</div>
<div>dbconfig-common: flushing administrative password</div>
<div>Now doing 'designate-manage database sync': this may take a while...</div>
<div>No handlers could be found for logger "oslo_config.cfg"</div>
<div>2016-02-05 16:52:29.827 3169 CRITICAL designate [designate-manage - - - - -] OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] ECONNREFUSED)")</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate Traceback (most recent call last):</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/bin/designate-manage", line 10, in <module></div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate sys.exit(main())</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/designate/cmd/manage.py", line 130, in main</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate fn(*fn_args)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/designate/manage/database.py", line 63, in sync</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate get_manager().upgrade(None)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration_cli/manager.py", line 65, in upgrade</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate results.append(plugin.upgrade(None))</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration_cli/ext_migrate.py", line 48, in upgrade</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate init_version=self.init_version)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 74, in db_sync</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate current_version = db_version(engine, abs_path, init_version)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 129, in db_version</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate meta.reflect(bind=engine)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3594, in reflect</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate with bind.connect() as conn:</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2018, in connect</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate return self._connection_cls(self, **kwargs)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 72, in __init__</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate if connection is not None else engine.raw_connection()</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate self.pool.unique_connection, _connection)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate e, dialect, self)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1405, in _handle_dbapi_exception_noconnection</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate exc_info</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate reraise(type(exception), exception, tb=exc_tb)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate return fn()</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318, in unique_connection</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate return _ConnectionFairy._checkout(self)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 713, in _checkout</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate fairy = _ConnectionRecord.checkout(pool)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 480, in checkout</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate rec = pool._do_get()</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1151, in _do_get</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate return self._create_connection()</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate return _ConnectionRecord(self)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 449, in __init__</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate self.connection = self.__connect()</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 607, in __connect</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate connection = self.__pool._invoke_creator(self)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate return dialect.connect(*cargs, **cparams)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 385, in connect</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate return self.dbapi.connect(*cargs, **cparams)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 88, in Connect</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate return Connection(*args, **kwargs)</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 626, in __init__</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate self._connect()</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 818, in _connect</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate 2003, "Can't connect to MySQL server on %r (%s)" % (self.host, e))</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] ECONNREFUSED)")</div>
<div>2016-02-05 16:52:29.827 3169 ERROR designate </div>
<div>root@controller01:/etc/designate# </div>
<div>root@controller01:/etc/designate# </div>
<div>root@controller01:/etc/designate# mysql -u root -p -h localhost</div>
<div>Enter password: </div>
<div>Welcome to the MariaDB monitor. Commands end with ; or \g.</div>
<div>Your MariaDB connection id is 143</div>
<div>Server version: 5.5.46-MariaDB-1ubuntu0.14.04.2 (Ubuntu)</div>
<div><br>
</div>
<div>Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.</div>
<div><br>
</div>
<div>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</div>
<div><br>
</div>
<div>MariaDB [(none)]> </div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div>
<div><span style="color:rgb(89,89,89);font-family:Cambria,serif;font-size:11pt">Steven Searles, CTO | </span><a href="mailto:ssearles@zimcom.net" style="font-family:Cambria,serif;font-size:11pt" target="_blank">ssearles@zimcom.net</a></div>
<div style="font-family:Helvetica;font-size:12px">
<div>
<div>
<div style="margin:0in 0in 0.0001pt;font-size:12pt;font-family:'Times New Roman',serif">
<span style="font-size:11pt;font-family:Cambria,serif;color:rgb(89,89,89)">Zimcom Internet Solutions | <a href="http://www.zimcom.net/" target="_blank">www.zimcom.net</a><u></u><u></u></span></div>
<div style="margin:0in 0in 0.0001pt;font-size:12pt;font-family:'Times New Roman',serif;line-height:24px">
<span style="font-size:11pt;line-height:22px;font-family:Cambria,serif;color:rgb(89,89,89)">O: <a href="tel:513.231.9500" value="+15132319500" target="_blank">513.231.9500</a> | D: <a href="tel:513.233.4130" value="+15132334130" target="_blank">513.233.4130</a><u></u><u></u></span></div>
<div style="margin:0in 0in 0.0001pt;font-size:12pt;font-family:'Times New Roman',serif">
<span style="font-size:11pt;font-family:Cambria,serif;color:rgb(89,89,89)"><br>
</span></div>
</div>
</div>
<br>
</div>
<span style="font-family:Calibri"><img height="36" width="163" src="cid:C0917625-7CD3-48D9-A1DE-1C9B82C658E9" type="image/png"></span></div>
</div>
</div>
<br>_______________________________________________<br>
Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
Post to : <a href="mailto:openstack@lists.openstack.org">openstack@lists.openstack.org</a><br>
Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><span style="font-family:Arial;font-size:8pt"><span style="color:rgb(70,130,180);font-size:10pt">Mohammed Naser</span> — <span style="font-weight:bold">vexxhost</span><br></span><div><span style="font-family:Arial;font-size:8pt"><span><span style="color:rgb(220,220,220)">-----------------------------------------------------</span></span></span></div><div><span style="font-family:Arial;font-size:11px"><span style="font-weight:bold">E. </span><a href="mailto:mnaser@vexxhost.com" target="_blank">mnaser@vexxhost.com</a></span></div><div><span style="font-family:Arial;font-size:11px"><span style="font-weight:bold">W. </span><a href="http://vexxhost.com/" target="_blank">http://vexxhost.com</a></span></div></div>
</div></div></div>