Так-с, вот что получилось:
Для чистоты эксперимента снес все, установил заново. Добавил модуль ipn, создал 3 услуги, хотя для создания шлюза этого можно было и не делать.
Код:
Installing module: ipn version 4.3...
File's copy finished...
File copy => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
Module Instance init => OK
Executing call ExecuteSQL; param: atc.sql
Executing database update...OK
Result => true
Executing call AddSchedulerTasks; param: ipn.sc
Scheduled class bitel.billing.server.ipn.LogCalculator inserted into database.
Scheduled class bitel.billing.server.ipn.IPNTestGates inserted into database.
Scheduled class bitel.billing.server.ipn.MaxCalculator inserted into database.
Result => true
Executing call ExecuteSQL; param: add_bgs.sql
Executing database update...OK
Result => true
Execute calls => OK
Module ipn version 4.3 was sucsessfull installed!
Please, restart BGBilling server.
Сервер стартует.
Код:
INFO 08.11.2007 11:18:58 Starting BGBillingServer..
INFO 08.11.2007 11:18:58 HttpRequest.maxFormContentSize: 10000000
INFO 08.11.2007 11:18:58 HTTP port: 8080
INFO 08.11.2007 11:18:58 Starting HTTP listener..
INFO 08.11.2007 11:18:58 HTTPS port: 0
INFO 08.11.2007 11:18:58 Browsing installed modules..
INFO 08.11.2007 11:18:58 ipn v. 4.3 build 14 from 29.10.2007 15:36:11
INFO 08.11.2007 11:18:58 Starting listen admin port 2005
INFO 08.11.2007 11:19:10 Admin command: status
Далее иду в "модули->IPN->типы шлюзов", создаю например D-Link, для параметры:
Код:
rule_type.editor.class=bitel.billing.module.services.ipn.editor.SwitchRuleTypeEditor
user_rule.editor.class=bitel.billing.module.services.ipn.editor.SwitchContractRuleEditor
gate_manager.class=bitel.billing.server.ipn.SwitchGateWorker
#версия snmp 1 или 2c
snmp.version=1
iface.1=ETH1
iface.2=ETH2
iface.3=ETH3
Далее пытаюсь создать шлюз на вкладке "шлюзы": указываю ip, 161 порт, тип шлюза, но в разворачивающемся списке он не отображается а в server.out выдается это:
Код:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'bgbilling.ipn_service_link_plan_1' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
at bitel.billing.server.ipn.bean.ServiceLinkPlanManager.getPlanList(ServiceLinkPlanManager.java:43)
at bitel.billing.server.ipn.action.ActionServiceLinkPlanList.doAction(ActionServiceLinkPlanList.java:17)
at bitel.billing.server.Executer.doModule(Executer.java:570)
at bitel.billing.server.Executer.doPost(Executer.java:168)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822)
at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:37)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)
at org.mortbay.http.HttpServer.service(HttpServer.java:896)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'parent_id' in 'order clause'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
at bitel.billing.server.ipn.bean.GateManager.getGatesList(GateManager.java:59)
at bitel.billing.server.ipn.bean.GateManager.getGateTree(GateManager.java:79)
at bitel.billing.server.ipn.action.ActionGateInfo.doAction(ActionGateInfo.java:19)
at bitel.billing.server.Executer.doModule(Executer.java:570)
at bitel.billing.server.Executer.doPost(Executer.java:168)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822)
at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:37)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)
at org.mortbay.http.HttpServer.service(HttpServer.java:896)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'parent_id' in 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
at bitel.billing.server.ipn.bean.GateManager.updateGate(GateManager.java:244)
at bitel.billing.server.ipn.action.ActionUpdateGate.doAction(ActionUpdateGate.java:54)
at bitel.billing.server.Executer.doModule(Executer.java:570)
at bitel.billing.server.Executer.doPost(Executer.java:168)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822)
at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:37)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)
at org.mortbay.http.HttpServer.service(HttpServer.java:896)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Возможно что-то упустил из виду? Заранее спасибо.
Вход
Регистрация
FAQ
Поиск
. При попытке просмотреть отчет выводится окошко с ошибкой "bitel/billing/common/BGDecimalFormat". Как быть? Заранее спасибо.