Форум администраторов игровых серверов

Форум администраторов игровых серверов (https://forum.zone-game.info/TT.php)
-   Работа со скриптами (https://forum.zone-game.info/forumdisplay.php?f=37)
-   -   Вопрос по установке сервера Gracia! (https://forum.zone-game.info/showthread.php?t=3859)

JeweLs 07.06.2009 00:15

Вопрос по установке сервера Gracia!
 
Я 1 раз ставлю сервер грации:angl:. регистр гейм сервер выдаёт ошибку...В нём есть такие строки
Classpath и oldclasspath
Что-нибудь там надо писать или просто я сделал что-то не так??:rolleyes:

piratik 07.06.2009 20:11

Ответ: Вопрос по установке сервера Gracia!
 
Цитата:

Я 1 раз ставлю сервер грации. регистр гейм сервер выдаёт ошибку...В нём есть такие строки
Classpath и oldclasspath
Что-нибудь там надо писать или просто я сделал что-то не так??
скорей всего второй вариант что-то сделал неправильно посмотри вот эту тему думаю она тебе поможет.

Redvain 07.06.2009 21:59

Ответ: Вопрос по установке сервера Gracia!
 
Единственное что может быть в данном случае-некорректные параметры подключения к базе данных.
Полный лог ошибки опубликуй.

JeweLs 07.06.2009 22:49

Ответ: Вопрос по установке сервера Gracia!
 
[SPOILER]================================================== ===-[ Network Configuration ]
Loading: ./config/network/network.properties.
Loading: ./config/network/security.properties.
================================================== ======-[ Main Configuration ]
Loading: ./config/main/ban.properties.
Loading: ./config/main/loginserver.properties.
================================================== =-[ Developer Configuration ]
=================================================-[ Versionning Configuration ]
Loading: ./config/versionning/build-time.properties.
================================================== ================-[ Database ]
INFO : MLog clients using log4j logging.
INFO : Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace
: 10]
INFO : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ jav
a.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [num
ThreadsAwaitingCheckoutDefaultUser] ]
WARN : SQL Error: 1049, SQLState: 42000
ERROR : Unknown database 'l2emu_db'
WARN : Could not obtain connection metadata com.mysql.jdbc.exceptions.jdbc4.MySQ
LSyntaxErrorException: Unknown database 'l2emu_db'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3447)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:911)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 3953)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 76)
at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onImpl.java:2048)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.java:723)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:282)
at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManag
erDataSource.java:119)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.j ava:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.jav a:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.ja va:82)
at org.hibernate.cfg.SettingsFactory.buildSettings(Se ttingsFactory.java:
84)
at org.hibernate.cfg.Configuration.buildSettings(Conf iguration.java:2073
)
at org.hibernate.cfg.Configuration.buildSessionFactor y(Configuration.jav
a:1298)
at org.springframework.orm.hibernate3.LocalSessionFac toryBean.newSession
Factory(LocalSessionFactoryBean.java:816)
at org.springframework.orm.hibernate3.LocalSessionFac toryBean.buildSessi
onFactory(LocalSessionFactoryBean.java:734)
at org.springframework.orm.hibernate3.AbstractSession FactoryBean.afterPr
opertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.Abstract AutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableB eanFactory.java:1367)
at org.springframework.beans.factory.support.Abstract AutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBean Factory.java:1333)
at org.springframework.beans.factory.support.Abstract AutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFa ctory.java:471)
at org.springframework.beans.factory.support.Abstract AutowireCapableBean
Factory$1.run(AbstractAutowireCapableBeanFactory.j ava:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.Abstract AutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFact ory.java:380)
at org.springframework.beans.factory.support.Abstract BeanFactory$1.getOb
ject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultS ingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:2 17)
at org.springframework.beans.factory.support.Abstract BeanFactory.doGetBe
an(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean
(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean
(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultL istableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactor y.java:423)
at org.springframework.context.support.AbstractApplic ationContext.finish
BeanFactoryInitialization(AbstractApplicationConte xt.java:729)
at org.springframework.context.support.AbstractApplic ationContext.refres
h(AbstractApplicationContext.java:381)
at org.springframework.context.support.ClassPathXmlAp plicationContext.<i
nit>(ClassPathXmlApplicationContext.java:139)
at org.springframework.context.support.ClassPathXmlAp plicationContext.<i
nit>(ClassPathXmlApplicationContext.java:93)
at net.l2emuproject.L2Registry.loadRegistry(L2Registr y.java:63)
at net.l2emuproject.gsregistering.GameServerRegister. main(GameServerRegi
ster.java:46)

INFO : Loaded 127 server names
WARN : SQL Error: 1049, SQLState: 42000
ERROR : Unknown database 'l2emu_db'
WARN : SQL Error: 1049, SQLState: 42000
ERROR : Unknown database 'l2emu_db'
Exception in thread "main" org.springframework.transaction.CannotCreateTransa cti
onException: Could not open Hibernate Session for transaction; nested exception
is org.hibernate.exception.SQLGrammarException: Cannot open connection
at org.springframework.orm.hibernate3.HibernateTransa ctionManager.doBegi
n(HibernateTransactionManager.java:550)
at org.springframework.transaction.support.AbstractPl atformTransactionMa
nager.getTransaction(AbstractPlatformTransactionMa nager.java:377)
at org.springframework.transaction.interceptor.Transa ctionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupp ort.java:263)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.in
voke(TransactionInterceptor.java:101)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$D ynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:635)
at net.l2emuproject.loginserver.services.GameserversS ervices$$EnhancerBy
CGLIB$$4045099a.getAllGameservers(<generated>)
at net.l2emuproject.loginserver.manager.GameServerMan ager.load(GameServe
rManager.java:208)
at net.l2emuproject.loginserver.manager.GameServerMan ager.<init>(GameSer
verManager.java:112)
at net.l2emuproject.loginserver.manager.GameServerMan ager.getInstance(Ga
meServerManager.java:81)
at net.l2emuproject.gsregistering.GameServerRegister. main(GameServerRegi
ster.java:51)
Caused by: org.hibernate.exception.SQLGrammarException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.j
ava:67)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelp
er.java:43)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelp
er.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransa ctionManager.doBegi
n(HibernateTransactionManager.java:509)
... 10 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown da
tabase 'l2emu_db'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3447)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:911)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 3953)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 76)
at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onImpl.java:2048)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.java:723)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:282)
at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManag
erDataSource.java:119)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.j ava:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.jav a:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.ja va:82)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:423)
... 15 more
Для продолжения нажмите любую клавишу . . .[/SPOILER]

Magister 07.06.2009 22:53

Ответ: Вопрос по установке сервера Gracia!
 
Твоя проблема в данной ошибки следующая:

1. Нет соединения с базой Mysql, доступ к ней по Login и Pass.
2. Отсутствует база данных для сервера "l2emu_db"

Вообщем, проверь в файлах настройки сервера пункт 1.
Потом в базе проверь пункт 2.

Если что непонятно, напиши, обязательно решим твою проблему. ;) Также пиши свои результаты работы по запуску. :)

JeweLs 08.06.2009 16:10

Ответ: Вопрос по установке сервера Gracia!
 
АХахахахаха....Люди простите меня за глупость=)) Просто кто устанавливал сервера ит то знают то что там можно просто изменить инстал дб=)А в грации нельзя помоему=) Спасибо всем=))Лучше помогуте вот с чем=)

http://forum.zone-game.info/showthre...4221#post34221


Текущее время: 16:12. Часовой пояс GMT +3.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd. Перевод: zCarot