[OpenSIPS-Users] OpenXCAP - Can't connect to MySQL server when mysql port is defined

[Duane Larson]

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)")*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121107/415970ed/attachment.htm>