BiTel

radius 07-30/23:00:08 ERROR [radiusListener-p-9-t-4] RadiusListenerWorker - java.sql.SQLException: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate() or Connection.prepareStatement().
ru.bitel.bgbilling.common.BGException: java.sql.SQLException: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate() or Connection.prepareStatement().
        at ru.bitel.bgbilling.kernel.log.server.bean.ConnectionLogEntryDao.update(ConnectionLogEntryDao.java:67)
        at ru.bitel.bgbilling.modules.inet.radius.InetRadiusListenerWorker.accessRequest(InetRadiusListenerWorker.java:88)
        at ru.bitel.bgbilling.modules.inet.radius.InetRadiusListenerWorker.accessRequest(InetRadiusListenerWorker.java:1)
        at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.processPacket(RadiusListenerWorker.java:163)
        at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.runImpl(RadiusListenerWorker.java:87)
        at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:74)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
        at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40)
Caused by: java.sql.SQLException: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate() or Connection.prepareStatement().
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.StatementImpl.getGeneratedKeys(StatementImpl.java:1876)
        at org.apache.commons.dbcp.DelegatingStatement.getGeneratedKeys(DelegatingStatement.java:315)
        at ru.bitel.bgbilling.server.util.ServerUtils.lastInsertId(ServerUtils.java:621)
        at ru.bitel.bgbilling.kernel.log.server.bean.ConnectionLogEntryDao.updateImpl(ConnectionLogEntryDao.java:138)
        at ru.bitel.bgbilling.kernel.log.server.bean.ConnectionLogEntryDao.update(ConnectionLogEntryDao.java:63)
        ... 9 more

Jul 31 04:39:35: RADIUS/ENCODE(00000A4B):Orig. component type = VPDN
Jul 31 04:39:35: RADIUS(00000A4B): Config NAS IP: 0.0.0.0
Jul 31 04:39:35: RADIUS/ENCODE: Best Local IP-Address 10.56.255.251 for Radius-Server X.X.X.X
Jul 31 04:39:35: RADIUS(00000A4B): Send Access-Request to X.X.X.X:1812 id 1645/24, len 153
Jul 31 04:39:35: RADIUS(00000A4B): Started 5 sec timeout
Jul 31 04:39:35: RADIUS: Received from id 1645/24 X.X.X.X:1812, Access-Accept, len 185
Jul 31 04:39:35: RADIUS: response-authenticator decrypt fail, pak len 185
Jul 31 04:39:35: RADIUS: packet dump: 021800B94E34658404FAAA4552B4FEC9876DECB208060A00001C1A2A00000137112480009085B00C36D3C811E77614A8FEDF4092FD2ECECF8642B5DEFC7571A89D25DCBC1A2A0000013710248000904359D63A1A017CB71BC091B4A450C4D7686D411EE82CE359866BC248A6087A1A0C000001370706000000011A0C000001370806000000041A33000001371A2D3F533D45333332373639433633363231364634363944453731393337304442304437443544464532313141
Jul 31 04:39:35: RADIUS: expected digest: 21FFFFFF9CFFFFFFBE43FFFFFFE0FFFFFF8AFFFFFFB3FFFFFFA7751AFFFFFF8113FFFFFFDF76FFFFFFC06A
Jul 31 04:39:35: RADIUS: response authen: 4E3465FFFFFF8404FFFFFFFAFFFFFFAA4552FFFFFFB4FFFFFFFEFFFFFFC9FFFFFF876DFFFFFFECFFFFFFB2
Jul 31 04:39:35: RADIUS: request  authen: CCE5B53F3E30839C448AFECBA9347CD6
Jul 31 04:39:35: RADIUS: Response (24) failed decrypt
Jul 31 04:39:40: RADIUS(00000A4B): Request timed out
Jul 31 04:39:40: RADIUS: Retransmit to (X.X.X.X:1812,1813) for id 1645/24
Jul 31 04:39:40: RADIUS(00000A4B): Started 5 sec timeout
Jul 31 04:39:40: RADIUS: Received from id 1645/24 X.X.X.X:1812, Access-Accept, len 185
Jul 31 04:39:40: RADIUS: response-authenticator decrypt fail, pak len 185
Jul 31 04:39:40: RADIUS: packet dump: 021800B972D310E6A3CD735DCF8CD3063A3FBB9108060A00001D1A2A00000137112480009085B00C36D3C811E77614A8FEDF4092FD2ECECF8642B5DEFC7571A89D25DCBC1A2A0000013710248000904359D63A1A017CB71BC091B4A450C4D7686D411EE82CE359866BC248A6087A1A0C000001370706000000011A0C000001370806000000041A33000001371A2D3F533D45333332373639433633363231364634363944453731393337304442304437443544464532313141
Jul 31 04:39:40: RADIUS: expected digest: FFFFFFFDFFFFFF86FFFFFFDD76705138FFFFFFC3FFFFFFCB4E72205B02FFFFFFB9FFFFFFE2
Jul 31 04:39:40: RADIUS: response authen: 72FFFFFFD310FFFFFFE6FFFFFFA3FFFFFFCD735DFFFFFFCFFFFFFF8CFFFFFFD3063A3FFFFFFFBBFFFFFF91
Jul 31 04:39:40: RADIUS: request  authen: CCE5B53F3E30839C448AFECBA9347CD6
Jul 31 04:39:40: RADIUS: Response (24) failed decrypt
Jul 31 04:39:44: RADIUS(00000A4B): Request timed out
...
Jul 31 04:39:53: RADIUS: No response from (X.X.X.X:1812,1813) for id 1645/24
Jul 31 04:39:53: RADIUS/DECODE: No response from radius-server; parse response; FAIL
Jul 31 04:39:53: RADIUS/DECODE: Case error(no response/ bad packet/ op decode);parse response; FAILConnection closed by foreign host.

09-22/15:20:35  INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@16921fd] to java:comp/env/mq/connec$
 09-22/15:20:35  INFO [main] DefaultServerSetup - Init DB connection pools
 09-22/15:20:35  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
 09-22/15:20:35 ERROR [main] DefaultServerSetup - Access denied for user 'bill'@'localhost' (using password: YES)
java.sql.SQLException: Access denied for user 'bill'@'localhost' (using password: YES)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
        at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:475)
        at ru.bitel.bgbilling.server.util.Setup.init(Setup.java:103)
        at ru.bitel.bgbilling.server.util.Setup.<init>(Setup.java:46)
        at ru.bitel.bgbilling.kernel.application.server.Application.<init>(Application.java:93)
        at ru.bitel.bgbilling.kernel.application.server.Application.main(Application.java:582)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at ru.bitel.common.bootstrap.Boot.boot(Boot.java:129)
        at ru.bitel.common.bootstrap.Boot.main(Boot.java:178)
09-22/15:20:35 ERROR [main] Preferences -
java.lang.NullPointerException
        at ru.bitel.common.Preferences.loadModuleSetup(Preferences.java:452)
        at ru.bitel.bgbilling.server.util.Setup.init(Setup.java:105)
        at ru.bitel.bgbilling.server.util.Setup.<init>(Setup.java:46)
        at ru.bitel.bgbilling.kernel.application.server.Application.<init>(Application.java:93)
        at ru.bitel.bgbilling.kernel.application.server.Application.main(Application.java:582)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at ru.bitel.common.bootstrap.Boot.boot(Boot.java:129)
        at ru.bitel.common.bootstrap.Boot.main(Boot.java:178)
 09-22/15:20:35 ERROR [main] ServerUtils -
java.lang.NullPointerException
        at ru.bitel.bgbilling.server.util.ServerUtils.closeConnection(ServerUtils.java:722)
        at ru.bitel.bgbilling.server.util.ServerUtils.closeConnection(ServerUtils.java:706)
        at ru.bitel.bgbilling.server.util.Setup.init(Setup.java:107)
        at ru.bitel.bgbilling.server.util.Setup.<init>(Setup.java:46)
        at ru.bitel.bgbilling.kernel.application.server.Application.<init>(Application.java:93)
        at ru.bitel.bgbilling.kernel.application.server.Application.main(Application.java:582)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at ru.bitel.common.bootstrap.Boot.boot(Boot.java:129)
        at ru.bitel.common.bootstrap.Boot.main(Boot.java:178)
 09-22/15:20:35  INFO [main] DefaultServerSetup - Init trash pools..
mq 09-22/15:20:35  INFO [EventProcessor-init] EventProcessor - Init EventProcessor MQ connection factory...
 09-22/15:20:36 ERROR [EventProcessor-init] EventProcessor - User name or password is invalid.
javax.jms.JMSException: User name or password is invalid.
        at org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.java:49)
        at org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1273)
        at org.apache.activemq.ActiveMQConnection.ensureConnectionInfoSent(ActiveMQConnection.java:1368)
        at org.apache.activemq.ActiveMQConnection.createSession(ActiveMQConnection.java:303)
        at ru.bitel.bgbilling.kernel.event.EventProcessor.newInstance0(EventProcessor.java:948)
        at ru.bitel.bgbilling.kernel.event.EventProcessor.access$1(EventProcessor.java:921)
        at ru.bitel.bgbilling.kernel.event.EventProcessor$4.call(EventProcessor.java:885)

[root@severlink BGInetAccess]# /usr/local/BGInetAccess/update.sh

Starting libraries updating. Requesting to BGBillingServer lib info.
 09-22/15:22:25  INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@ee22f7] to java:comp/env/mq/connectionFactory
 09-22/15:22:25  INFO [main] DefaultServerSetup - Init DB connection pools
 09-22/15:22:25  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
 09-22/15:22:26 ERROR [main] DefaultServerSetup - Access denied for user 'bill'@'localhost' (using password: YES)
java.sql.SQLException: Access denied for user 'bill'@'localhost' (using password: YES)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)