Results 1 to 2 of 2

Thread: mysql CommunicationsException from the IDE

  1. #1
    Join Date
    Aug 2011
    Posts
    116

    Default mysql CommunicationsException from the IDE

    Hello
    I am writing my logs to the database according to http://http://www.wowza.com/forums/c...-to-a-Database
    when i start the Wowza as a service it works great an write all the logs to the database.
    when i start it from the IDE i get the fallowing exception:
    log4j:ERROR Failed to excute sql
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.apache.log4j.jdbc.JDBCAppender.getConnection(Unknown Source)
    at org.apache.log4j.jdbc.JDBCAppender.execute(Unknown Source)
    at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(Unknown Source)
    at org.apache.log4j.jdbc.JDBCAppender.append(Unknown Source)
    at org.apache.log4j.AppenderSkeleton.doAppend(Unknown Source)
    at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(Unknown Source)
    at org.apache.log4j.Category.callAppenders(Unknown Source)
    at org.apache.log4j.Category.forcedLog(Unknown Source)
    at org.apache.log4j.Category.log(Unknown Source)
    at com.wowza.wms.logging.WMSLogger.log(Unknown Source)
    at com.wowza.wms.logging.WMSLogger.info(Unknown Source)
    at com.wowza.wms.server.Server.startServer(Unknown Source)
    at com.wowza.wms.server.Server.start(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.wowza.wms.bootstrap.Bootstrap.startServer(Unknown Source)
    at com.wowza.wms.bootstrap.Bootstrap.main(Unknown Source)
    Caused by: java.net.ConnectException: Connection refused: connect
    at java.net.DualStackPlainSocketImpl.connect0(Native Method)
    at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
    at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
    at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
    at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.SocksSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
    ... 33 more
    when i comment the fallowing line in log4j.properties
    log4j.appender.SQ.layout.EventExclude=comment
    it workes ok but then i get all the logging into my database without the ability to include or exclude event's any idea?

    Thanks

    /Asaf
    Last edited by asaf32; 02-12-2012 at 01:40 AM.

  2. #2
    Join Date
    Dec 2007
    Posts
    21,962

    Default

    Take a look at Roger's post:

    http://www.wowza.com/forums/showthre...0526#post40526

    Richard

Similar Threads

  1. Consultant Needed - Wowza IDE - Advanced Logging into MySQL and more
    By RJDynamic in forum Integrating Wowza into your workflow
    Replies: 1
    Last Post: 02-27-2014, 11:10 AM
  2. please help for mysql
    By bika2008 in forum General Forum
    Replies: 1
    Last Post: 05-03-2013, 02:32 PM
  3. wowza and mysql
    By vision in forum General Forum
    Replies: 1
    Last Post: 03-25-2013, 06:09 AM
  4. module for Autontication with mysql
    By asaf32 in forum Live Streaming and Encoder Discussion
    Replies: 11
    Last Post: 02-15-2012, 10:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •