BiTel

log4j:WARN No appenders could be found for logger (org.bushe.swing.event.EventService).
log4j:WARN Please initialize the log4j system properly.
[ length = 144 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="1CDCEE099FBB6DD60A1F5E6B500FC2E2" status="ok"><count outofdate="0" todo="0"/></data>
http://xx.xx.xx.xx:8080/bgbilling/executer?table_module=dialup&module=admin&action=BGTable&table=lac&BGBillingSecret=XryAkL4dAztOd1ju9YMVRt1u&
[ length = 116 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="D8416C139EC5F55AB1A929AF5C1BB862" status="error"></data>
http://xx.xx.xx.xx:8080/bgbilling/executer?table_module=dialup&module=admin&action=BGTable&table=error&BGBillingSecret=68UWrYphT1kxb5Zn6CN3qkNz&
[ length = 207 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="9796CF0EA127D76783AE08AB625DB626" status="ok"><table_param hiddens="1,1,0,0,0,0,0" positions="0,1,2,3,4,5,6" width="0,0,120,92,70,100,492"/></data>
java.lang.ArrayIndexOutOfBoundsException: 7
   at bitel.billing.module.common.table.BGTable.init(BGTable.java:1573)
   at bitel.billing.module.common.BGPanel.init(BGPanel.java:77)
   at bitel.billing.module.services.call.CallServiceConfigMonitor.init(CallServiceConfigMonitor.java:587)
   at bitel.billing.module.services.ServiceConfig$ServiceConfigPane$1.doInBackground(ServiceConfig.java:58)
   at bitel.billing.module.services.ServiceConfig$ServiceConfigPane$1.doInBackground(ServiceConfig.java:1)
   at javax.swing.SwingWorker$1.call(Unknown Source)
   at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
   at java.util.concurrent.FutureTask.run(Unknown Source)
   at javax.swing.SwingWorker.run(Unknown Source)
   at bitel.billing.module.services.ServiceConfig$ServiceConfigPane.<init>(ServiceConfig.java:89)
   at bitel.billing.module.services.ServiceConfig$ServiceConfigPane.<init>(ServiceConfig.java:37)
   at bitel.billing.module.services.ServiceConfig.addTab(ServiceConfig.java:213)
   at bitel.billing.module.services.ServiceConfig.<init>(ServiceConfig.java:188)
   at bitel.billing.module.services.ServiceConfig.<init>(ServiceConfig.java:128)
   at bitel.billing.module.services.ActionServiceConfigBase.actionPerformed(ActionServiceConfigBase.java:31)
   at ru.bitel.bgbilling.client.common.BGMenuBar$MenuAction.actionPerformed(BGMenuBar.java:89)
   at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
   at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
   at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
   at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
   at javax.swing.AbstractButton.doClick(Unknown Source)
   at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
   at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
   at java.awt.Component.processMouseEvent(Unknown Source)
   at javax.swing.JComponent.processMouseEvent(Unknown Source)
   at java.awt.Component.processEvent(Unknown Source)
   at java.awt.Container.processEvent(Unknown Source)
   at java.awt.Component.dispatchEventImpl(Unknown Source)
   at java.awt.Container.dispatchEventImpl(Unknown Source)
   at java.awt.Component.dispatchEvent(Unknown Source)
   at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
   at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
   at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
   at java.awt.Container.dispatchEventImpl(Unknown Source)
   at java.awt.Window.dispatchEventImpl(Unknown Source)
   at java.awt.Component.dispatchEvent(Unknown Source)
   at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
   at java.awt.EventQueue.access$000(Unknown Source)
   at java.awt.EventQueue$1.run(Unknown Source)
   at java.awt.EventQueue$1.run(Unknown Source)
   at java.security.AccessController.doPrivileged(Native Method)
   at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
   at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
   at java.awt.EventQueue$2.run(Unknown Source)
   at java.awt.EventQueue$2.run(Unknown Source)
   at java.security.AccessController.doPrivileged(Native Method)
   at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
   at java.awt.EventQueue.dispatchEvent(Unknown Source)
   at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
   at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
   at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
   at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
   at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
   at java.awt.EventDispatchThread.run(Unknown Source)
http://xx.xx.xx.xx:8080/bgbilling/executer?to=0&module=dialup&value=&pageSize=50&action=GetLogAndError&from=-1&mid=15&BGBillingSecret=zkvA3j5KpYHLfuCSSinCMJYU&nasList=1&units=b&mode=error&pageIndex=1&
[ length = 296 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="762F897C5A847BAEA887D23282D2C099" status="ok"><contract/><table pageCount="1" pageIndex="1" pageSize="50" recordCount="0"><data/></table><nas><item id="2" title="PPPoE [ PPPoE GW ]"/><item id="1" title="VOIP [ Shutdown ]"/></nas></data>
http://xx.xx.xx.xx:8080/bgbilling/executer?table_module=dialup&module=admin&action=BGTable&table=module_config&BGBillingSecret=tR4yIJEmXutOt8u2ok5mHnWZ&
[ length = 116 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="F3A1BF4C3B856270B4E972393BC99702" status="error"></data>
http://xx.xx.xx.xx:8080/bgbilling/executer?table_module=dialup&module=admin&action=BGTable&table=nasconfig_common&BGBillingSecret=TmbCgV00HUSORCYNZ4Z2vjaU&
[ length = 116 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="4294BCC3AB127485A4EF788526B2FAE6" status="error"></data>
http://xx.xx.xx.xx:8080/bgbilling/executer?table_module=dialup&module=admin&action=BGTable&table=nasconfig&BGBillingSecret=xltQmdJgkDDKykM5tIOsi2HO&
[ length = 116 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="257C3F568D799290D5E2B48E74F966AD" status="error"></data>
http://xx.xx.xx.xx:8080/bgbilling/executer?table_module=dialup&module=admin&action=BGTable&table=naslist&BGBillingSecret=QcAspJcJBe1tuKehz933O28w&
[ length = 116 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="CCD12BE1DC7517A82BBE48482ADD2B86" status="error"></data>
http://xx.xx.xx.xx:8080/bgbilling/executer?table_module=dialup&module=admin&action=BGTable&table=log&BGBillingSecret=O2YC9tNeckzNDjI2F9Gp3gZj&
[ length = 263 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="667644CA2FBD5A1896C910619FC8C85B" status="ok"><table_param hiddens="1,1,1,0,0,0,0,0,0,1,1,0,0,0" positions="3,0,1,2,4,5,6,7,8,10,9,11,12,13" width="163,0,0,0,143,40,121,127,120,120,80,76,88,110"/></data>
http://xx.xx.xx.xx:8080/bgbilling/executer?to=0&module=dialup&value=&pageSize=50&action=GetLogAndError&nas=&from=-1&mid=15&BGBillingSecret=dwMFLp1j5PzMpsokNbMixmvG&units=b&mode=active&pageIndex=1&
[ length = 16398 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="88161996D9152034E4CB4A1992309B50" status="ok"><contract/><table pageCount="2" pageIndex="1" pageSize="50" recordCount="77"><data><row act="true" cid="405" comment="ООО &quot;Э.-К.-Ч.&quot;" contract="ТФ-11-0009-С ( DL-2-013 )" from_to="UNDEF / " id="342" in="979846860" ipaddr="10.9.3.58" out="980591791" record_id="245" session_cost="0.00000" session_start="07.01.2012 07:39:10" session_stop="27.01.2012 02:07:39" session_time="474:28:29 [1708109]"/><row act="true" cid="145" comment="ООО Медицинский центр &quot;Лотос&quot;" contract="ТФ-09-0002-С ( LY-8-001 )" from_to="UNDEF / " id="351" in="2451694885" ipaddr="10.9.3.102" out="2444316258" record_id="247" session_cost="0.00000" session_start="07.01.2012 07:39:16" session_stop="27.01.2012 02:07:45" session_time="474:28:29 [1708109]"/><row act="true" cid="125" comment="ОАО &quot;Собинбанк&quot;" contract="ТФ-08-0001-C ( DL-4-002 )" from_to="UNDEF / " id="377" in="1749252018" ipaddr="10.9.3.5" out="1747298239" record_id="251" session_cost="0.00000" session_start="07.01.2012 07:39:19" session_stop="27.01.2012 02:07:53" session_time="474:28:34 [1708114]"/><row act="true" cid="123" comment="ТСЖ &quot;Наш Дом&quot;" contract="ТФ-07-0001-В ( QT-2-001 )" from_to="UNDEF / " id="380" in="274095256" ipaddr="10.9.3.41" out="286493149" record_id="254" session_cost="0.00000" session_start="07.01.2012 07:39:19" session_stop="27.01.2012 02:07:52" session_time="474:28:33 [1708113]"/><row...
http://xx.xx.xx.xx:8080/bgbilling/executer?id=-1&module=call&action=GetRadiusLogInfo&mid=15&date=&BGBillingSecret=0daTn1rYDJ2Wu0hmUBZhJsAD&cid=400&
[ length = 107 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="653991C58D4AC2F6DBE586857174E3E0" status="ok"/>

ps -ef | grep BGRadius

ps -ef | grep java

select * from log_session_{mid}_201201

select * from user_tables where table_module='dialup' and ( table_id='error' or table_id='log')

delete from user_tables where table_module='dialup' and ( table_id='error' or table_id='log')

select * from user_tables where table_module='dialup' and table_id='lac'

1   dialup   error   0,0,120,92,70,100,492   0,1,2,3,4,5,6   1,1,0,0,0,0,0
11   dialup   log   0,0,0,173,40,132,132,108,80,129,133,110   0,1,2,3,4,5,6,7,8,9,10,11   1,1,1,0,0,0,0,0,1,1,0,0
23   dialup   log   0,0,0,210,40,150,150,150,80,137,232,110   0,1,2,3,4,5,6,7,8,9,10,11   1,1,1,0,0,0,0,0,0,0,0,0
1   dialup   log   199,0,0,0,208,40,150,150,150,120,80,88,124,110   3,0,1,2,4,5,6,7,8,10,9,11,12,13   1,1,1,0,0,0,0,0,0,1,1,0,0,0

4

Пусто (если не считать заголовок таблицы который скопировать нельзя)