Проблема с запуском

Теги:
 

Lirix

новичок
В общем сделал все как написано тут
При запуске startLoginServer.bat иили startGameServer.bat появляется такая хрень: (взято из лога)
code text
  1. 1141100790713   INFO   10   net.sf.l2j.Config   loading login config 1141100790994   INFO   10   com.mchange.v2.log.MLog   MLog clients using java 1.4+ standard logging. 1141100791094   INFO   10   com.mchange.v2.c3p0.C3P0Registry   Initializing c3p0-0.9.0 [built 08-Август-2005 15:47:30 +0400; debug? false; trace: 5] 1141100791695   INFO   10   com.mchange.v2.c3p0.PoolBackedDataSource   Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@787171 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@b09e89 [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> true, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> b09e89, idleConnectionTestPeriod -> 0, initialPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 10, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@1bf52a5 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1bf52a5, jdbcUrl -> jdbc:mysql://localhost/l2jdb, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> 787171, numHelperThreads -> 3 ] 1141100821528   WARNING   11   com.mchange.v2.resourcepool.BasicResourcePool   com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@9664a1 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30).

А потом нажмите любую клавишу и все. Конец. В чем проблема то?
 
+
-
edit
 

reptily

втянувшийся
Lirix> В общем сделал все как написано тут
Lirix> При запуске startLoginServer.bat иили startGameServer.bat появляется такая хрень: (взято из лога)
Lirix> 1141100790713 INFO 10 net.sf.l2j.Config loading login config 1141100790994 INFO 10 com.mchange.v2.log.MLog MLog clients using java 1.4+ standard logging. 1141100791094 INFO 10 com.mchange.v2.c3p0.C3P0Registry Initializing c3p0-0.9.0 [built 08-Август-2005 15:47:30 +0400; debug? false; trace: 5] 1141100791695 INFO 10 com.mchange.v2.c3p0.PoolBackedDataSource Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource787171 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSourceb09e89 [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> true, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> b09e89, idleConnectionTestPeriod -> 0, initialPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 10, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource1bf52a5 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1bf52a5, jdbcUrl -> jdbc:mysql://localhost/l2jdb, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> 787171, numHelperThreads -> 3 ] 1141100821528 WARNING 11 com.mchange.v2.resourcepool.BasicResourcePool com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@9664a1 — Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30).
Lirix> А потом нажмите любую клавишу и все. Конец. В чем проблема то?

mysql не включил
 

Lirix

новичок
mysql загружено. пхпмайадмин и навикат нормально конектятся к базам. Базы создал, в итоге 53 таблицы. Но вот ява никак не хочет конектится к базам.
 

Lirix

новичок
В файле loginserver.properties и server.properties как должна выглядеть строка Driver и Url? И можно поподробнее про строку driver?
 
+
-
edit
 

mrSteam

втянувшийся
Чтото не понимаю, выложи весь лог прямо из батника.
И выложи конфиг сервера.
Баги для читера это средство выживания Баги для админа это веревка и мыло  

Lirix

новичок
log из батника:

Starting L2J Login Server.

loading login config
MLog clients using java 1.4+ standard logging.
Initializing c3p0-0.9.0 [built 08-└туєёЄ-2005 15:47:30 +0400; debug? false; trac
e: 5]
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource787171 [ conn
ectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSourceb09e
89 [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 100
0, autoCommitOnClose -> true, automaticTestTable -> null, breakAfterAcquireFailu
re -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c
3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnres
olvedTransactions -> false, identityToken -> b09e89, idleConnectionTestPeriod ->
0, initialPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 10, maxStatements ->
100, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.
mchange.v2.c3p0.DriverManagerDataSource1bf52a5 [ description -> null, driverCla
ss -> null, factoryClassLocation -> null, identityToken -> 1bf52a5, jdbcUrl -> j
dbc:mysql://localhost/l2jdb, properties -> {user=******, password=******} ], pre
ferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false,
testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ],
factoryClassLocation -> null, identityToken -> 787171, numHelperThreads -> 3 ]
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@15ff48b — Acquisition
Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed n
ew resource, we failed to succeed more than the maximum number of allowed acquis
ition attempts (30).
Exception in thread "main" java.sql.SQLException: Connections could not be acqui
red from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConne
ction(C3P0PooledConnectionPool.java:236)
at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedData
Source.java:94)
at net.sf.l2j.L2DatabaseFactory. at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:148)
at net.sf.l2j.loginserver.LoginServer.main(LoginServer.java:82)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A Resourc
ePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResou
rcePool.java:970)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicR
esourcePool.java:208)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConne
ction(C3P0PooledConnectionPool.java:232)
... 4 more

Server terminated abnormaly


server terminated

Для продолжения нажмите любую клавишу . . .
[/code]
loginserver.properties
code text
  1. # This is the server configuration file. Here you can set up the connection for your server.
  2. # Usually you have to change the ExternalHostname option to
  3. # - 127.0.0.1 (if you want to play alone / testing purpose)
  4. # - LAN IP* (if you want to play from another computer in the network)
  5. # - WAN IP** (if you want to play with friends over internet)
  6. # - Questions? => http://l2j.sourceforge.net
  7. #
  8. # * = If you want to get your LAN IP, simply choose "Start" => "Run..." then type "cmd" => "ipconfig"
  9. # **= If you want to get you WAN IP, visit http://www.whatismyip.com
  10. # ===================================================================================================
  11.  
  12. # ================================================================
  13. # General server setting !!! REQUIRED to configure to everyone !!!
  14. # ================================================================
  15.  
  16. # This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
  17. ExternalHostname=84.22.138.198
  18.  
  19. # This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname
  20. InternalHostname=84.22.138.198
  21.  
  22. # Bind ip of the loginserver, use * to bind on all available IPs
  23. LoginserverHostname=*
  24. LoginserverPort=2106
  25. LoginTryBeforeBan=20
  26.  
  27. # The port on which login will listen for GameServers
  28. LoginPort=9014
  29.  
  30. # If set to true any GameServer can register on your login's free slots
  31. AcceptNewGameServer = True
  32.  
  33. # If false, the licence (after the login) will not be shown
  34. ShowLicence = True
  35.  
  36. # Database info
  37. Driver=com.mysql.jdbc.Driver
  38. #Driver=org.hsqldb.jdbcDriver
  39. URL=jdbc:mysql://localhost/l2jdb
  40. #URL=jdbc:hsqldb:hsql://localhost/l2jdb
  41. Login=root
  42. Password=
  43. MaximumDbConnections=10
  44. # Useable values: "true" - "false", use this option to choose whether accounts will be created
  45. # automatically or not.
  46. AutoCreateAccounts=true
  47. # ==============================================================
  48. # Test server setting, shoudnt be touched in online game server
  49. # ==============================================================
  50.  
  51. Debug = false
  52. Assert = false
  53. Developer = false

server.properties
[code]






#









GameserverHostname=localhost
GameserverPort=7777



ExternalHostname=84.22.138.198



InternalHostname=127.0.0.1


LoginserverHostname=localhost
LoginserverPort=2106
LoginTryBeforeBan=20


LoginPort=9014
LoginHost=127.0.0.1


RequestServerID = 0

AcceptAlternateID = True


Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
URL=jdbc:mysql://localhost/l2jdb
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=
Login=root
Password=
MaximumDbConnections=10


#DatapackRoot = C:/Work/tmp/DataPackC3








CnameTemplate=.*


MaximumOnlineUsers=100





Debug = False
Assert = False
Developer = False

TestServer = False







ServerListBrackets = False

ServerListClock = False

ServerGMOnly = False



MinProtocolRevision = 557
MaxProtocolRevision = 560


RateXp = 1.
RateSp = 1.
RatePartyXp = 1.
RatePartySp = 1.
RateDropAdena = 1.
RateDropItems = 1.
RateDropSpoil = 1.
RateQuestsReward = 1.
RateKarmaDropEquipment = 1
RateKarmaExpLost = 1
RateSiegeGuardsPrice = 1
RateRaidRegenHp = 500
RateRaidRegenMp = 500


PlayerRateDrop = 20
PlayerRateDropItem = 70
PlayerRateDropEquip = 25
PlayerRateDropEquipWeapon = 5


AutoDestroyDroppedItemAfter = 0



AllowWarehouse = True
AllowFreight = True
AllowWear = True
#Enable water test
AllowWater = False

#Enable pet for rent(wyvern&strider) from pet managers
AllowRentPet = False


AllowDiscardItem = True


EverybodyHasAdminRights = False




AllowL2Walker = False
L2WalkerRevision = 552

AutobanL2WalkerAcc = False



ActivatePositionRecorder = False

#Global/Trade Chat usablitly - ON, OFF, GM
GlobalChat=ON


LogChat = True
LogItems = False


ShowLevelOnCommunityBoard = False
ShowStatusOnCommunityBoard = True
NamePageSizeOnCommunityBoard = 50
NamePerRowOnCommunityBoard = 5

#Zone Setting
#0 = Peace All the Time
#1 = PVP During Siege
#2 = PVP All the Time
ZoneTown=0


MaxDriftRange = 200




MinNPCAnimation = 0
MaxNPCAnimation = 0





ServerSideNpcName = False

ServerSideNpcNameWithLvl = False

AutoDeleteInvalidQuestData = False



DayStatusSunRiseAt = 6
DayStatusSunSetAt = 18

DayStatusForceClientUpdate = True






ThreadPoolSizeHigh = 4
ThreadPoolSizeMed = 10
ThreadPoolSizeLow = 4


DeleteCharAfterDays = 7





DefaultPunish=2



LazyCache=True



ExecutorPriLow=-1
ExecutorPriMed=0
ExecutorPriHigh=1
 
+
-
edit
 

oleg2255

новичок
А кто за тебя пароли к базам в конфиге сервера должен прописывать ? Да и потом адрес логин сервера.
 

Lirix

новичок
У меня без паролей.
 

Lirix

новичок
Я кажись догадываюсь в чем проблема.
У меня при запуске денвера в памяти весит mysqld-max.exe В службах есть просто MySQL, но его не удается запустить, пишет: "Ошибка 1067: Процесс был неожиданно прерван"
Ах-да, забыл :)
Как исправить проблему?
 
+
-
edit
 

oleg2255

новичок
А под денвером новые серваки вообще не работают. Используй или из GH сборки сайт со всем , или ищи аналогичный отдельный сайт под сервак, файл называется DiskW.exe .

з.ы. а пароли на базы всетаки советую поставить.
 

Lirix

новичок
Кароче запустил я сервак, но теперь новая проблема. На экране с выбором сервера пинг 9999, как это исправить?
 
+
-
edit
 

LooteR

новичок
ExternalHostname=сюда свой ип
InternalHostname=сюда тоже ип, который и в экстернал
 

в начало страницы | новое
 
Поиск
Настройки
Твиттер сайта
Статистика
Рейтинг@Mail.ru