CREATE TABLE  `address_country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
);
ALTER TABLE `address_city` ADD COLUMN  `country_id` int(11) NOT NULL DEFAULT '1';
INSERT INTO `address_country` SET id=1, title='Россия';

07-08/22:34:36  INFO [AdminPortListener] server - Admin command: stop
tail: log/server.log: file truncated
07-08/22:34:43  INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@ef5502] to java:comp/env/mq/connectionFactory
07-08/22:34:43 DEBUG [main] JNDIReferenceFactory - Creating reference: org.apache.activemq.ActiveMQConnectionFactory,org.apache.activemq.ActiveMQConnectionFactory@ef5502
07-08/22:34:43  INFO [main] DefaultServerSetup - Init DB connection pools
07-08/22:34:43  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
07-08/22:34:45  INFO [main] DefaultServerSetup - Init trash pools..
07-08/22:34:45  INFO [main] Server - Starting BGBillingServer..
07-08/22:34:46  INFO [main] Server - HTTP Connector: *:8080
07-08/22:34:46  INFO [main] Server - Starting HTTP connector...
07-08/22:34:46  INFO [main] Server - HTTPS Connector: null
07-08/22:34:46  INFO [main] Server - Browsing installed modules and plugins...
07-08/22:34:46  INFO [main] Server - ipn v.5.1 build 179 from 05.07.2010 18:26:56
07-08/22:34:48 DEBUG [main] LocalEventProcessor - Add listener bitel.billing.server.ipn.Module$1@16d2633 to BG.LocalEvent.ru.bitel.bgbilling.kernel.event.events.GetErrorLogModulesEvent
07-08/22:34:48  INFO [main] Server - Add servlet for modules and plugins...
07-08/22:34:48  INFO [main] Server - Creating installed modules map...
07-08/22:34:49  INFO [main] server - Starting listen admin port 2005
07-08/22:34:51  INFO [main] AbstractTilesApplicationContextFactory - Initializing Tiles2 application context. . .
07-08/22:34:51  INFO [main] AbstractTilesApplicationContextFactory - Finished initializing Tiles2 application context.
07-08/22:34:51  INFO [main] TilesContainerFactory - Initializing Tiles2 container. . .
07-08/22:34:51 DEBUG [main] BaseLocaleUrlDefinitionDAO - Adding resource 'jndi:/localhost.localdomain/bgbilling/WEB-INF/tiles-defs.xml' to definitions factory.
07-08/22:34:51 DEBUG [main] Digester - register('-//Apache Software Foundation//DTD Tiles Configuration 2.0//EN', 'jar:file:/usr/local/BGBillingServer/lib/tiles-core.jar!/org/apache/tiles/resources/tiles-config_2_0.dtd'
07-08/22:34:51 DEBUG [main] Digester - register('-//Apache Software Foundation//DTD Tiles Configuration 2.1//EN', 'jar:file:/usr/local/BGBillingServer/lib/tiles-core.jar!/org/apache/tiles/resources/tiles-config_2_1.dtd'
07-08/22:34:51  INFO [main] TilesContainerFactory - Tiles2 container initialized
07-08/22:34:51  INFO [main] TilesAccess - Publishing TilesContext for context: org.apache.tiles.servlet.context.ServletTilesApplicationContext
07-08/22:36:49 DEBUG [http-8080-1] EventProcessor - Add listener bitel.billing.server.Executer$1@8990e4 to BG.Event.ru.bitel.bgbilling.kernel.module.api.common.bean.ModuleAddedEvent
07-08/22:36:50 DEBUG [http-8080-1] server - executing bitel.billing.server.admin.action.ActionMenuAndToolBar; time => 86 ms.
07-08/22:36:51 DEBUG [http-8080-1] server - executing bitel.billing.server.installer.action.ActionGetInstalledPlugins; time => 2 ms.
07-08/22:36:51 DEBUG [http-8080-1] server - executing bitel.billing.server.installer.action.ActionGetInstalledModules; time => 807 ms.
07-08/22:36:58 DEBUG [http-8080-1] server - executing bitel.billing.server.admin.action.ActionBGTable; time => 57 ms.
07-08/22:36:58 DEBUG [http-8080-1] server - executing bitel.billing.server.admin.action.ActionGetAddressDirectory; time => 2 ms.
07-08/22:37:01 DEBUG [http-8080-1] server - executing bitel.billing.server.admin.action.ActionBGTable; time => 3 ms.
07-08/22:37:01 DEBUG [http-8080-1] server - executing bitel.billing.server.admin.action.ActionGetContractGroupList; time => 29 ms.
07-08/22:37:02 DEBUG [http-8080-1] server - executing bitel.billing.server.admin.action.ActionBGTable; time => 2 ms.
07-08/22:37:02 DEBUG [http-8080-1] server - executing bitel.billing.server.admin.action.ActionBGTable; time => 2 ms.
07-08/22:37:02 DEBUG [http-8080-1] server - executing bitel.billing.server.admin.action.ActionListDirectory; time => 3 ms.

Java Runtime: Sun Microsystems Inc. Java HotSpot(TM) Client VM [1.6.0_12] /usr/lib/jvm/java-6-sun-1.6.0.12/jre
  Java endorsed dirs: /usr/lib/jvm/java-6-sun-1.6.0.12/jre/lib/endorsed
  OS: Linux 2.6.26-2-686 [i386], file.encoding: UTF-8, user.name: root
  Heap sizes: current=5056k  free=4230k  max=260160k
Jul 8, 2010 10:34:49 PM org.apache.catalina.startup.Embedded start
INFO: Starting tomcat server
Jul 8, 2010 10:34:50 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
Jul 8, 2010 10:34:51 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Jul 8, 2010 10:34:51 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080

>java -version
java version "1.6.0_07"
Java(TM) SE Runtime Environment (build 1.6.0_07-b06)
Java HotSpot(TM) Client VM (build 10.0-b23, mixed mode, sharing)

 07-09/21:09:27 DEBUG [http-8080-2] server - executing bitel.billing.server.admin.action.ActionMenuAndToolBar; time => 142 ms.
07-09/21:09:27 DEBUG [http-8080-2] server - executing bitel.billing.server.installer.action.ActionGetInstalledPlugins; time => 1 ms.
07-09/21:09:28 DEBUG [http-8080-2] server - executing bitel.billing.server.installer.action.ActionGetInstalledModules; time => 887 ms.
07-09/21:09:33 DEBUG [http-8080-2] server - executing bitel.billing.server.admin.action.ActionBGTable; time => 2 ms.
07-09/21:09:33 DEBUG [http-8080-2] server - executing bitel.billing.server.admin.action.ActionGetAddressDirectory; time => 1 ms.
07-09/21:09:36 DEBUG [http-8080-2] server - executing bitel.billing.server.admin.action.ActionBGTable; time => 1 ms.
07-09/21:09:36 DEBUG [http-8080-2] server - executing bitel.billing.server.admin.action.ActionBGTable; time => 2 ms.
07-09/21:09:36 DEBUG [http-8080-2] server - executing bitel.billing.server.admin.action.ActionListDirectory; time => 1 ms.

http://10.78.2.1:8080/bgbilling/executer?module=admin&action=MenuAndToolBar&
[ length = 7687 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data firmTitle="Тестовая лицензия (идент. номер: 5000)" status="ok" user="admin"><params><param key="contract.limit.values" value="=-2000;=-500;=-300;=-150;=-50;=-30;=-10;=0;-5/1;-50/1;-100/1;-15/3;-50/3;-100/3"/><param key="contract.tree.order" value="parameters objects hierarchy status limit mode balance tariff modules groups web tariffGroup script addAction memo"/><param key="pattern.limit.values" value="-2000;-500;-300;-150;-100;-50;-10;0;5;30;100;15;50;100"/></params><menuBar>
    <menu id="contract" title="Договор">
        <menuItem className="bitel.billing.module.contract.ActionNewContract" id="new" keyStroke="ctrl pressed N" title="Новый договор"/>
        <separator/>
        <menuItem className="bitel.billing.module.contract.ActionOpenContract" id="open" keyStroke="ctrl pressed O" title="Открыть договор"/>       
        <menuItem className="bitel.billing.module.contract.ActionDeleteContract" id="delete" title="Удалить договор"/>
        <menuItem className="bitel.billing.module.contract.ActionWrapContract" id="wrap" title="Переоформить договор"/>
        <separator/>       
        <menuItem className="bitel.billing.module.contract.ActionPatternContractEditor" id="pattern" title="Шаблоны"/>
        <separator/>
        <menuItem className="tab.switch.prev" keyStroke="alt pressed Z" title="Предыдущая вк&amp;ладка"/>
        <menuItem className="tab.switch.next" keyStroke="alt pressed X" title="Следующая вкла&amp;дка"/...
http://10.78.2.1:8080/bgbilling/executer?module=installer&action=GetInstalledPlugins&
[ length = 85 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data status="ok"><plugin_list/></data>
http://10.78.2.1:8080/bgbilling/executer?module=installer&action=GetInstalledModules&BGBillingSecret=5YmPVaYEVrRoD7vHtZG1DZ7s&
[ length = 282 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="273993CB75C445FDD878881EE8AA6C17" status="ok"><installed_modules><item build="179" module_name="ipn" name="ipn" version="5.1"/><item build="330" module_name="update" name="client" version="5.1"/></installed_modules></data>
log4j:WARN No appenders could be found for logger (org.bushe.swing.event.EventService).
log4j:WARN Please initialize the log4j system properly.
http://10.78.2.1:8080/bgbilling/executer?table_module=admin&module=admin&action=BGTable&table=city&BGBillingSecret=B7RPBf7hsMdp7SCdKgNpLwwK&
[ length = 116 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="AF0917644BCDBD79A4ED65D0F111992E" status="error"></data>
http://10.78.2.1:8080/bgbilling/executer?module=admin&action=GetAddressDirectory&BGBillingSecret=l4Ub9H5GQlS7CtGvC5BGErKm&mode=5&
[ length = 147 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="19E5C7858A346D4D595A13AA09CC7A2E" status="ok"><directory/><table><data/></table></data>
http://10.78.2.1:8080/bgbilling/executer?table_module=admin&module=admin&action=BGTable&table=2&BGBillingSecret=JnvTU62NhfKyzj4oegzu4XaK&
[ length = 116 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="B4FCB2EE4CEDDF4688D2C4F9B3290D20" status="error"></data>
http://10.78.2.1:8080/bgbilling/executer?table_module=admin&module=admin&action=BGTable&table=3&BGBillingSecret=lOmP0YGkTvuy3ssM778dXhuJ&
[ length = 116 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="623138F5D663AA48BEFC66D3E64A1C4F" status="error"></data>
http://10.78.2.1:8080/bgbilling/executer?id=0&module=admin&action=ListDirectory&BGBillingSecret=OSdZwA6lOxYPfHXaUHwphyfh&mode=4&
[ length = 155 ] xml = <?xml version="1.0" encoding="windows-1251"?>
<data secret="4BEF24C580A7C76266D109BFC9B4104E" status="ok"><directory/><title/><table><data/></table></data>
Exception in thread "AWT-EventQueue-0" java.lang.ArrayIndexOutOfBoundsException: -1
   at java.util.Vector.elementAt(Unknown Source)
   at javax.swing.table.DefaultTableModel.getValueAt(Unknown Source)
   at bitel.billing.module.contract.directory.ContractParameterGroupEditor.bGControlPanel_02_actionPerformed(ContractParameterGroupEditor.java:232)
   at bitel.billing.module.contract.directory.ContractParameterGroupEditor.access$2(ContractParameterGroupEditor.java:215)
   at bitel.billing.module.contract.directory.ContractParameterGroupEditor$3.actionPerformed(ContractParameterGroupEditor.java:100)
   at ru.bitel.common.client.BGButtonPanel.fireActionPerformed(BGButtonPanel.java:156)
   at ru.bitel.common.client.BGButtonPanel$1.actionPerformed(BGButtonPanel.java:109)
   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.plaf.basic.BasicButtonListener.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.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)

INSERT INTO contract_parameter_group_name SET title='Группа'