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.
[Database] ; The database connection URI for the datase with subscriber accounts ;authentication_db_uri = mysql://user:pass@*OLDMYSQLIP*/opensips <--- This worked authentication_db_uri = mysql://user:pass@*NewMySQLIP:19994*/opensips <--- This doesn't appear to work ; The database connection URI for the database that stores the XCAP documents ;storage_db_uri = mysql://user:pass@*OLDMYSQLIP*/opensips <--- This worked storage_db_uri = mysql://user:pass@*NewMySQLIP:19994*/opensips <--- This doesn't appear to work ; Authentication and storage tables subscriber_table = subscriber xcap_table = xcap Nov 7 11:13:59 xcap01 openxcap[11529]: Received SIGTERM, shutting down. Nov 7 11:13:59 xcap01 openxcap[11529]: (TCP Port 80 Closed) Nov 7 11:13:59 xcap01 openxcap[11529]: error: Unhandled error in Deferred: *Nov 7 11:13:59 xcap01 openxcap[11529]: OperationalError: (2003, "Can't connect to MySQL server on 'NewMySQLIP' (111)")* Nov 7 11:13:59 xcap01 openxcap[11529]: Main loop terminated. Nov 7 11:13:59 xcap01 openxcap[12975]: Starting OpenXCAP 2.0.1 Nov 7 11:13:59 xcap01 openxcap[12975]: using set_wakeup_fd Nov 7 11:14:00 xcap01 openxcap[12975]: Listening on: 173.XX.XX.111:80 Nov 7 11:14:00 xcap01 openxcap[12975]: XCAP root: http://xcap.xxx.com/xcap-root Nov 7 11:14:00 xcap01 openxcap[12975]: xcap.server.HTTPFactory starting on 80 Nov 7 11:14:00 xcap01 openxcap[12975]: error: Traceback (most recent call last): Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/threading.py", line 504, in __bootstrap Nov 7 11:14:00 xcap01 openxcap[12975]: error: self.__bootstrap_inner() Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/threading.py", line 532, in __bootstrap_inner Nov 7 11:14:00 xcap01 openxcap[12975]: error: self.run() Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/threading.py", line 484, in run Nov 7 11:14:00 xcap01 openxcap[12975]: error: self.__target(*self.__args, **self.__kwargs) Nov 7 11:14:00 xcap01 openxcap[12975]: error: --- <exception caught here> --- Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/python/threadpool.py", line 207, in _worker Nov 7 11:14:00 xcap01 openxcap[12975]: error: result = context.call(ctx, function, *args, **kwargs) Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/python/context.py", line 118, in callWithContext Nov 7 11:14:00 xcap01 openxcap[12975]: error: return self.currentContext().callWithContext(ctx, func, *args, **kw) Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/python/context.py", line 81, in callWithContext Nov 7 11:14:00 xcap01 openxcap[12975]: error: return func(*args,**kw) Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/enterprise/adbapi.py", line 445, in _runInteraction Nov 7 11:14:00 xcap01 openxcap[12975]: error: conn = self.connectionFactory(self) Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/enterprise/adbapi.py", line 38, in __init__ Nov 7 11:14:00 xcap01 openxcap[12975]: error: self.reconnect() Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/enterprise/adbapi.py", line 75, in reconnect Nov 7 11:14:00 xcap01 openxcap[12975]: error: self._connection = self._pool.connect() Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/python2.6/dist-packages/twisted/enterprise/adbapi.py", line 414, in connect Nov 7 11:14:00 xcap01 openxcap[12975]: error: conn = self.dbapi.connect(*self.connargs, **self.connkw) Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/pymodules/python2.6/MySQLdb/__init__.py", line 81, in Connect Nov 7 11:14:00 xcap01 openxcap[12975]: error: return Connection(*args, **kwargs) Nov 7 11:14:00 xcap01 openxcap[12975]: error: File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 170, in __init__ Nov 7 11:14:00 xcap01 openxcap[12975]: error: super(Connection, self).__init__(*args, **kwargs2) *Nov 7 11:14:00 xcap01 openxcap[12975]: error: _mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'NewMySQLIP' (111)")*
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
