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

Клиент выдает ошибку нет связи с базой данных
http://forum.bitel.ru/viewtopic.php?f=22&t=158		 Страница 1 из 1
Автор:  plus [ 20 мар 2007, 16:38 ]
Заголовок сообщения:  Клиент выдает ошибку нет связи с базой данных
Вот лог

login as: root
root@192.168.0.143's password:
Last login: Tue Feb 20 16:54:04 2007 from 192.168.0.103
[root@localhost ~]# mc
server.out [----] 0 L:[129273+ 1 129274/129324] *(7103531/7106475b)= . 9 0x09
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:94)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:98)
at bitel.billing.server.script.bean.event.EventProcessor.run(EventProcessor.java:91)
java.lang.NullPointerException
at bitel.billing.server.script.bean.event.EventProcessor.run(EventProcessor.java:96)
Returning NULL to pool!!!
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:94)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:98)
at bitel.billing.server.script.bean.event.EventProcessor.run(EventProcessor.java:91)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2707)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:94)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:98)
at bitel.billing.server.script.bean.event.EventProcessor.run(EventProcessor.java:91)
java.lang.NullPointerException
at bitel.billing.server.script.bean.event.EventProcessor.run(EventProcessor.java:96)
Returning NULL to pool!!!
Автор:  Администратор [ 20 мар 2007, 17:09 ]
Заголовок сообщения: 
А если просто набрать в командной строке:
Код:
mysql -ubill -pbgbilling -h127.0.0.1 bgbilling

соединяется?
Автор:  plus [ 20 мар 2007, 17:20 ]
Заголовок сообщения: 
нет соединение не происходит
Автор:  Администратор [ 20 мар 2007, 17:49 ]
Заголовок сообщения: 
mysql-server установлен?
Служба mysql запущена?
Код:
/sbin/service mysqld start
Автор:  plus [ 20 мар 2007, 17:57 ]
Заголовок сообщения: 
служба работает,все ок
login as: root
root@192.168.0.143's password:
Last login: Tue Feb 20 17:33:56 2007 from 192.168.0.103
[root@localhost ~]# mysql -ubill -pbgbilling -h127.0.0.1 bgbilling
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
[root@localhost ~]# mysql -ubill
ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: NO)
[root@localhost ~]# mysql -ubill -pbgbilling -h127.0.0.1
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
[root@localhost ~]# wich mysql
-bash: wich: command not found
[root@localhost ~]# ps ax | grep mysql
4628 ? Ss 0:00 /usr/sbin/mysqlmanager --default-mysqld-path=/usr/sbin/mysqld --user=mysql --run-as-service --pid-file=/var/run/mysqld/mysqlmanager.pid
4629 ? Sl 0:00 /usr/sbin/mysqlmanager --default-mysqld-path=/usr/sbin/mysqld --user=mysql --run-as-service --pid-file=/var/run/mysqld/mysqlmanager.pid
4876 ? Sl 0:00 /usr/sbin/mysqld --no-defaults --user=mysql --datadir=/var/lib/mysql --port=3306 --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --key_buffer=16M --max_allowed_packet=50M --table_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --default_character-set=cp1251 --default-collation=cp1251_general_ci --old_passwords --skip-networking --log-bin=mysql-bin --server-id=1 --innodb_data_home_dir=/var/lib/mysql/ --innodb_data_file_path=ibdata1:10M:autoextend
7233 ? Sl 0:04 /opt/java/jdk1.5.0/bin/java -Dnetworkaddress.cache.ttl=3600 -Xmx256m -Djava.awt.headless=true -cp .:./lib/activation.jar:./lib/avalon-framework.jar:./lib/batik.jar:./lib/bsh-1.3.0.jar:./lib/commons-beanutils.jar:./lib/commons-collections.jar:./lib/commons-dbcp-1.1.jar:./lib/commons-digester.jar:./lib/commons-logging.jar:./lib/commons-pool-1.1.jar:./lib/fop.jar:./lib/gnu-crypto.jar:./lib/image-filters.jar:./lib/jasperreports-0.5.3.jar:./lib/jcommon-0.9.4.jar:./lib/jetty.jar:./lib/jfreechart-0.9.19.jar:./lib/ldap.jar:./lib/log4j-1.2.8.jar:./lib/mail.jar:./lib/mysql-5.0.3.jar:./lib/server.jar:./lib/servlet.jar:./lib/snmp4_13.jar:./lib/xalan.jar:./lib/xercesImpl.jar bitel.billing.server.Server start
14702 pts/2 S+ 0:00 grep --color mysql
[root@localhost ~]# /sbin/service mysql start
Cannot find mysql service
Usage: service -[Rfshv] SERVICE ARGUMENTS
-f|--full-restart: Do a fullrestart of the service.
-R|--full-restart-all: Do a fullrestart of all services currently running.
-s|--status-all: Print a status of all services.
-d|--debug: Launch with debug.
-h|--help: This help.
[root@localhost ~]# /sbin/service mysqld start
MySQL is allready running: [ OK ]
[root@localhost ~]# ps ax | grep mysql
4628 ? Ss 0:00 /usr/sbin/mysqlmanager --default-mysqld-path=/usr/sbin/mysqld --user=mysql --run-as-service --pid-file=/var/run/mysqld/mysqlmanager.pid
4629 ? Sl 0:00 /usr/sbin/mysqlmanager --default-mysqld-path=/usr/sbin/mysqld --user=mysql --run-as-service --pid-file=/var/run/mysqld/mysqlmanager.pid
4876 ? Sl 0:00 /usr/sbin/mysqld --no-defaults --user=mysql --datadir=/var/lib/mysql --port=3306 --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --key_buffer=16M --max_allowed_packet=50M --table_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --default_character-set=cp1251 --default-collation=cp1251_general_ci --old_passwords --skip-networking --log-bin=mysql-bin --server-id=1 --innodb_data_home_dir=/var/lib/mysql/ --innodb_data_file_path=ibdata1:10M:autoextend
7233 ? Sl 0:04 /opt/java/jdk1.5.0/bin/java -Dnetworkaddress.cache.ttl=3600 -Xmx256m -Djava.awt.headless=true -cp .:./lib/activation.jar:./lib/avalon-framework.jar:./lib/batik.jar:./lib/bsh-1.3.0.jar:./lib/commons-beanutils.jar:./lib/commons-collections.jar:./lib/commons-dbcp-1.1.jar:./lib/commons-digester.jar:./lib/commons-logging.jar:./lib/commons-pool-1.1.jar:./lib/fop.jar:./lib/gnu-crypto.jar:./lib/image-filters.jar:./lib/jasperreports-0.5.3.jar:./lib/jcommon-0.9.4.jar:./lib/jetty.jar:./lib/jfreechart-0.9.19.jar:./lib/ldap.jar:./lib/log4j-1.2.8.jar:./lib/mail.jar:./lib/mysql-5.0.3.jar:./lib/server.jar:./lib/servlet.jar:./lib/snmp4_13.jar:./lib/xalan.jar:./lib/xercesImpl.jar bitel.billing.server.Server start
16811 pts/2 S+ 0:00 grep --color mysql
[root@localhost ~]#
Автор:  Администратор [ 20 мар 2007, 18:07 ]
Заголовок сообщения: 
Посмотрите в /etc/my.cnf
Код:
skip-networking

не стоит?
Автор:  plus [ 20 мар 2007, 18:14 ]
Заголовок сообщения: 
стоит
Автор:  Администратор [ 20 мар 2007, 18:19 ]
Заголовок сообщения: 
ну уберите :) и ребутните mysqld
Автор:  plus [ 20 мар 2007, 18:30 ]
Заголовок сообщения: 
уже сделал,все ок, работает, осталось модули прикрутить, в принципе нам инет нужен и сerbercrypt планируем запускать советовали ваш биллинг. Спасибо
Страница 1 из 1 Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/