I just moved over to a new mysql server and the port I need to connect to is no longer the default 3306 that mysql uses. I now need to connect to port 19994 on the new mysql server. With OpenXCAP are you able to connet to define a different mysql port? When I restart OpenXCAP I see the following error.
<div><br></div><div><br></div><div><div>[Database]</div><div><br></div><div>; The database connection URI for the datase with subscriber accounts </div><div>;authentication_db_uri = mysql://user:pass@<b>OLDMYSQLIP</b>/opensips <--- This worked</div>
<div>authentication_db_uri = mysql://user:pass@<b>NewMySQLIP:19994</b>/opensips <--- This doesn't appear to work</div><div><br></div><div>; The database connection URI for the database that stores the XCAP documents</div>
<div>;storage_db_uri = mysql://user:pass@<b>OLDMYSQLIP</b>/opensips <--- This worked </div><div>storage_db_uri = mysql://user:pass@<b>NewMySQLIP:19994</b>/opensips <--- This doesn't appear to work</div>
<div><br></div><div>; Authentication and storage tables</div><div>subscriber_table = subscriber</div><div>xcap_table = xcap</div><div><br></div><div><br></div><div><br></div><div>Nov 7 11:13:59 xcap01 openxcap[11529]: Received SIGTERM, shutting down.</div>
<div>Nov 7 11:13:59 xcap01 openxcap[11529]: (TCP Port 80 Closed)</div><div>Nov 7 11:13:59 xcap01 openxcap[11529]: error: Unhandled error in Deferred:</div><div><b>Nov 7 11:13:59 xcap01 openxcap[11529]: OperationalError: (2003, "Can't connect to MySQL server on 'NewMySQLIP' (111)")</b></div>
<div>Nov 7 11:13:59 xcap01 openxcap[11529]: Main loop terminated.</div><div>Nov 7 11:13:59 xcap01 openxcap[12975]: Starting OpenXCAP 2.0.1</div><div>Nov 7 11:13:59 xcap01 openxcap[12975]: using set_wakeup_fd</div><div>
Nov 7 11:14:00 xcap01 openxcap[12975]: Listening on: 173.XX.XX.111:80</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: XCAP root: <a href="http://xcap.xxx.com/xcap-root">http://xcap.xxx.com/xcap-root</a></div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: xcap.server.HTTPFactory starting on 80</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: Traceback (most recent call last):</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/threading.py", line 504, in __bootstrap</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: self.__bootstrap_inner()</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/threading.py", line 532, in __bootstrap_inner</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: self.run()</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/threading.py", line 484, in run</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: self.__target(*self.__args, **self.__kwargs)</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: --- <exception caught here> ---</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/python/threadpool.py", line 207, in _worker</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: result = context.call(ctx, function, *args, **kwargs)</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/python/context.py", line 118, in callWithContext</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: return self.currentContext().callWithContext(ctx, func, *args, **kw)</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/python/context.py", line 81, in callWithContext</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: return func(*args,**kw)</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/enterprise/adbapi.py", line 445, in _runInteraction</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: conn = self.connectionFactory(self)</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/enterprise/adbapi.py", line 38, in __init__</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: self.reconnect()</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/enterprise/adbapi.py", line 75, in reconnect</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: self._connection = self._pool.connect()</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/enterprise/adbapi.py", line 414, in connect</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: conn = self.dbapi.connect(*self.connargs, **self.connkw)</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/pymodules/python2.6/MySQLdb/__init__.py", line 81, in Connect</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: return Connection(*args, **kwargs)</div><div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 170, in __init__</div>
<div>Nov 7 11:14:00 xcap01 openxcap[12975]: error: super(Connection, self).__init__(*args, **kwargs2)</div><div><b>Nov 7 11:14:00 xcap01 openxcap[12975]: error: _mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'NewMySQLIP' (111)")</b></div>
</div>