forum.bitel.ru
http://forum.bitel.ru/

Не стартует bgcrm
http://forum.bitel.ru/viewtopic.php?f=51&t=6815		 Страница 1 из 1
Автор:  dmitry_k [ 26 май 2012, 01:59 ]
Заголовок сообщения:  Не стартует bgcrm
Код:
root@vpn1:/usr/local/BGCRM# java -version
java version "1.6.0_32"
Java(TM) SE Runtime Environment (build 1.6.0_32-b05)
Java HotSpot(TM) Server VM (build 20.7-b02, mixed mode)


после
root@vpn1:/usr/local/BGCRM# ./crm_start.sh
в логе:

Код:
root@vpn1:/usr/local/BGCRM# cat /usr/local/BGCRM/log/bgcrm.log
05-26/00:10:23 ERROR [main] Setup - Communications link failure

Last packet sent to the server was 0 ms ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
        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:406)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
        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:406)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)
        at ru.bgcrm.util.Setup.getDBConnectionFromPool(Setup.java:89)
        at ru.bgcrm.util.Setup.loadConfigMap(Setup.java:123)
        at ru.bgcrm.util.Setup.<init>(Setup.java:66)
        at ru.bgcrm.util.Setup.getSetup(Setup.java:53)
        at ru.bgcrm.util.Setup.getSetup(Setup.java:46)
        at ru.bgcrm.Server.<clinit>(Server.java:43)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 1 ms ago.
        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:406)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)
        ... 20 more
Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(Unknown Source)
        at java.net.PlainSocketImpl.connectToAddress(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:253)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
        ... 21 more
05-26/00:10:23 ERROR [main] Setup -
java.lang.NullPointerException
        at ru.bgcrm.dao.ConfigDAO.getActiveGlobalConfig(ConfigDAO.java:117)
        at ru.bgcrm.util.Setup.loadConfigMap(Setup.java:143)
        at ru.bgcrm.util.Setup.loadConfigMap(Setup.java:126)
        at ru.bgcrm.util.Setup.<init>(Setup.java:66)
        at ru.bgcrm.util.Setup.getSetup(Setup.java:53)
        at ru.bgcrm.util.Setup.getSetup(Setup.java:46)
        at ru.bgcrm.Server.<clinit>(Server.java:43)
05-26/00:10:23  INFO [main] Server - Starting BGCRM..
05-26/00:10:23  INFO [main] Server - catalinaHome => /usr/local/BGCRM; hostname => localhost
05-26/00:10:23  INFO [main] Server - Try start server HTTP port: 9088; listen address: null
05-26/00:10:23  INFO [main] Http11Protocol - Initializing ProtocolHandler ["http-bio-9088"]
05-26/00:10:23  INFO [main] StandardService - Starting service Tomcat
05-26/00:10:23  INFO [main] StandardEngine - Starting Servlet Engine: Apache Tomcat/7.0.23
05-26/00:10:23  INFO [pool-2-thread-1] ContextConfig - No global web.xml found
05-26/00:10:24  INFO [pool-2-thread-1] ActionServlet - Loading chain catalog from jar:file:/usr/local/BGCRM/lib/ext/struts-core.jar!/org/apache/struts/chain/chain-config.xml
05-26/00:10:24  INFO [pool-2-thread-1] TilesPlugin - Tiles definition factory loaded for module ''.
05-26/00:10:24  INFO [main] Http11Protocol - Starting ProtocolHandler ["http-bio-9088"]
05-26/00:10:24  INFO [main] AdminPortListener - Starting listen admin port 2010
05-26/00:10:25  INFO [main] PluginManager - Loaded plugin: bgbilling
05-26/00:10:25  INFO [main] PluginManager - Loaded plugin: ufanet
05-26/00:10:25  INFO [main] PluginManager - Loaded plugin: report
05-26/00:10:25  INFO [main] PluginManager - Loaded plugin: document
05-26/00:10:25  INFO [Thread-2] Scheduler - Starting scheduler..
05-26/00:10:25  INFO [Thread-2] Config - Reload tasks config.
05-26/00:10:25 ERROR [main] Setup - Communications link failure

Last packet sent to the server was 0 ms ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
        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:406)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
        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:406)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)
        at ru.bgcrm.util.Setup.getDBConnectionFromPool(Setup.java:89)
        at ru.bgcrm.dynamic.ReadWriteClassManager.recompileAll(ReadWriteClassManager.java:49)
        at ru.bgcrm.Server.<init>(Server.java:197)
        at ru.bgcrm.Server.main(Server.java:223)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
        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:406)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)
        ... 18 more
Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(Unknown Source)
        at java.net.PlainSocketImpl.connectToAddress(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:253)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
        ... 19 more
05-26/00:10:25 ERROR [main] Server -
java.lang.NullPointerException
        at ru.bgcrm.dynamic.dao.DynamicCodeDao.clearTables(DynamicCodeDao.java:531)
        at ru.bgcrm.dynamic.ReadWriteClassManager.recompileAll(ReadWriteClassManager.java:54)
        at ru.bgcrm.Server.<init>(Server.java:197)
        at ru.bgcrm.Server.main(Server.java:223)
05-26/00:10:28 ERROR [main] Setup - Communications link failure

Last packet sent to the server was 0 ms ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
        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:406)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
        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:406)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)
        at ru.bgcrm.util.Setup.getDBConnectionFromPool(Setup.java:89)
        at ru.bgcrm.util.Setup.loadConfigMap(Setup.java:123)
        at ru.bgcrm.util.Setup.<init>(Setup.java:66)
        at ru.bgcrm.util.Setup.getSetup(Setup.java:53)
        at ru.bgcrm.util.Setup.getSetup(Setup.java:46)
        at ru.bgcrm.Server.<clinit>(Server.java:43)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
        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:406)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)
        ... 20 more
Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(Unknown Source)
        at java.net.PlainSocketImpl.connectToAddress(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:253)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
        ... 21 more
05-26/00:10:28 ERROR [main] Setup -
java.lang.NullPointerException
        at ru.bgcrm.dao.ConfigDAO.getActiveGlobalConfig(ConfigDAO.java:117)
        at ru.bgcrm.util.Setup.loadConfigMap(Setup.java:143)
        at ru.bgcrm.util.Setup.loadConfigMap(Setup.java:126)
        at ru.bgcrm.util.Setup.<init>(Setup.java:66)
        at ru.bgcrm.util.Setup.getSetup(Setup.java:53)
        at ru.bgcrm.util.Setup.getSetup(Setup.java:46)
        at ru.bgcrm.Server.<clinit>(Server.java:43)
Автор:  skyb [ 28 май 2012, 05:55 ]
Заголовок сообщения:  Re: Не стартует bgcrm
Код:
Last packet sent to the server was 0 ms ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Так эта, мускул то работает?
Автор:  dmitry_k [ 28 май 2012, 11:00 ]
Заголовок сообщения:  Re: Не стартует bgcrm
root@vpn1:/usr/local/BGCRM# ps axf | grep mysql
12379 pts/2 S+ 0:00 \_ grep mysql
29820 pts/0 S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid --skip-networking
29851 pts/0 Sl 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-external-locking --port=3306 --socket=/var/run/mysql/mysql.sock --skip-networking
Автор:  skyb [ 28 май 2012, 12:06 ]
Заголовок сообщения:  Re: Не стартует bgcrm
да не, то что процес есть пол беды, подключится клиентом то можете, и как настроен бгцрм на бд, все верно? что за ось?
Автор:  dmitry_k [ 28 май 2012, 17:42 ]
Заголовок сообщения:  Re: Не стартует bgcrm
skyb писал(а):
да не, то что процес есть пол беды, подключится клиентом то можете, и как настроен бгцрм на бд, все верно? что за ось?

Клиентом подцепиться могу, могу пользователем bgcrm залогиниться, могу им таблички в бд посмотреть, поменял юзера в bgcrm.properties на рута, тот же эффект :(


Код:
root@vpn1:/usr/local/BGCRM# cat /etc/slackware-version
Slackware 12.0.0
root@vpn1:/usr/local/BGCRM# uname -a
Linux vpn1 2.6.29.4 #1 SMP Thu May 28 09:06:19 MSD 2009 i686 Intel(R) Xeon(R) CPU           E5405  @ 2.00GHz GenuineIntel GNU/Linux
root@vpn1:/usr/local/BGCRM# mysql -v -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.0.37 Source distribution

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
Автор:  skyb [ 29 май 2012, 05:55 ]
Заголовок сообщения:  Re: Не стартует bgcrm
логин/пароль/хост верно все прописано?
Даже не, не так, покажите как прописан хост в bgcrm.properties
Автор:  Администратор [ 29 май 2012, 17:06 ]
Заголовок сообщения:  Re: Не стартует bgcrm
mysql -v -p -h127.0.0.1 - а вот так соединяет?
У вас, возможно, skip_networking стоит в my.cnf - подключение только через файловый сокет.
Автор:  skyb [ 29 май 2012, 18:36 ]
Заголовок сообщения:  Re: Не стартует bgcrm
Администратор а ещё может на ipv6 на localhost ругаться
Автор:  dmitry_k [ 29 май 2012, 19:56 ]
Заголовок сообщения:  Re: Не стартует bgcrm
Администратор писал(а):
mysql -v -p -h127.0.0.1 - а вот так соединяет?
У вас, возможно, skip_networking стоит в my.cnf - подключение только через файловый сокет.


Да, так и было, скрипт который стартовал mysqld подсовывал --skip-networking, закоментил, теперь соединяет на 127.0.0.1
Код:
root@vpn1:/usr/local/BGCRM# lsof -i|grep mysqld
mysqld    23824     mysql   12u  IPv4 4385851       TCP *:3306 (LISTEN)


теперь ругается так:

Код:
root@vpn1:/usr/local/BGCRM# ./crm_start.sh
root@vpn1:/usr/local/BGCRM# cat log/bgcrm.log
05-29/18:02:44  INFO [main] Server - Starting BGCRM..
05-29/18:02:44  INFO [main] Server - catalinaHome => /usr/local/BGCRM; hostname => localhost
05-29/18:02:44  INFO [main] Server - Try start server HTTP port: 9088; listen address: null
05-29/18:02:45  INFO [main] Http11Protocol - Initializing ProtocolHandler ["http-bio-9088"]
05-29/18:02:45  INFO [main] StandardService - Starting service Tomcat
05-29/18:02:45  INFO [main] StandardEngine - Starting Servlet Engine: Apache Tomcat/7.0.23
05-29/18:02:45  INFO [pool-2-thread-1] ContextConfig - No global web.xml found
05-29/18:02:46  INFO [pool-2-thread-1] ActionServlet - Loading chain catalog from jar:file:/usr/local/BGCRM/lib/ext/struts-core.jar!/org/apache/struts/chain/chain-config.xml
05-29/18:02:46  INFO [pool-2-thread-1] TilesPlugin - Tiles definition factory loaded for module ''.
05-29/18:02:46  INFO [main] Http11Protocol - Starting ProtocolHandler ["http-bio-9088"]
05-29/18:02:46  INFO [main] AdminPortListener - Starting listen admin port 2010
05-29/18:02:46  INFO [main] PluginManager - Loaded plugin: bgbilling
05-29/18:02:46  INFO [main] PluginManager - Loaded plugin: ufanet
05-29/18:02:46  INFO [main] PluginManager - Loaded plugin: report
05-29/18:02:46  INFO [main] PluginManager - Loaded plugin: document
05-29/18:02:46  INFO [Thread-2] Scheduler - Starting scheduler..
05-29/18:02:46  INFO [Thread-2] Config - Reload tasks config.
05-29/18:02:46 ERROR [main] Server -
java.lang.NullPointerException
        at ru.bgcrm.dynamic.CompilerWrapper.compile(CompilerWrapper.java:63)
        at ru.bgcrm.dynamic.ReadWriteClassManager.recompile(ReadWriteClassManager.java:87)
        at ru.bgcrm.dynamic.ReadWriteClassManager.recompileAll(ReadWriteClassManager.java:57)
        at ru.bgcrm.Server.<init>(Server.java:197)
        at ru.bgcrm.Server.main(Server.java:223)
Автор:  Администратор [ 30 май 2012, 12:35 ]
Заголовок сообщения:  Re: Не стартует bgcrm
Вероятнее всего вы вместо JDK поставили JRE. В JRE нет компилятора.
Автор:  dmitry_k [ 30 май 2012, 19:04 ]
Заголовок сообщения:  Re: Не стартует bgcrm
Администратор писал(а):
Вероятнее всего вы вместо JDK поставили JRE. В JRE нет компилятора.

Вы правы, спасибо
Страница 1 из 1 Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/