Mac OS X SL Server and Gracia Final.

Find the proper support area, Saga-Version.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
wfk
Posts: 3
Joined: Fri Jan 18, 2013 10:42 am

Mac OS X SL Server and Gracia Final.

Post by wfk »

Hello to all!

There are two problems.

1) Can not make friends Gracia Final and Mac OS X 10.6.8 Server.
Everything works fine, but only once.
If you exit the game, and then go back probyvat, the login server receives the data displayed plate with a list of servers and the status online, but when I try to go to the gameserver, nothing happens. And do not let the use of any account.
If the server is restarted, then again everything is in order (up to the first exit).
If you enter two characters, then after the game one character after a while the second character freezes.

2) Can not shut down or restart the server normally. In the process of following the assassination loginserver gameserver and a second process appears with the name "(java)" and the new PID. Somewhere something is hanging for safety have to restart the computer itself.

If any log or config files can help, just tell me what.

P.S. on Windows it works fine.
P.P.S. accept apologies for the English language, translated by Google.
wfk
Posts: 3
Joined: Fri Jan 18, 2013 10:42 am

Re: Mac OS X SL Server and Gracia Final.

Post by wfk »

After quit of the game and failed login attempts to a log file of the game server(stdout.log) writes:

gameserver/logs/stdout.log
SPOILER:
...

SevenSigns: Data updated successfully.
Tue Feb 19 11:46:24 mycomputer.name java[914] <Warning>: CGSShutdownServerConnections: Detaching application from window server
Tue Feb 19 11:46:24 mycomputer.name java[914] <Warning>: CGSDisplayServerShutdown: Detaching display subsystem from window server
2013-02-19 11:46:25.384 java[914:1707] HIToolbox: received notification of WindowServer event port death.
2013-02-19 11:46:25.386 java[914:1707] port matched the WindowServer port created in BindCGSToRunLoop
Connecting to login on 127.0.0.1:9014
Deconnected from Login, Trying to reconnect:
java.net.ConnectException: Connection refused
All ThreadPools are now stoped
SIGTERM received. Shutting down NOW!
Tue Feb 19 11:46:34 mycomputer.name java[914] <Error>: kCGErrorInvalidConnection: CGSReleaseConnection called with invalid connection
Tue Feb 19 11:46:34 mycomputer.name java[914] <Error>: kCGErrorFailure: Set a breakpoint @ CGErrorBreakpoint() to catch errors as they are logged.
Could not store char base data: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 49,332 milliseconds ago. The last packet sent successfully to the server was 127 milliseconds ago.
Problem with checked-in Statement, discarding.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:405)
at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:1132)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)
at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)
at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)
at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)
at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.storeCharBase(L2PcInstance.java:7590)
at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7496)
at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7504)
at net.sf.l2j.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:300)
at net.sf.l2j.gameserver.Shutdown.disconnectAllCharacters(Shutdown.java:550)
at net.sf.l2j.gameserver.Shutdown.saveData(Shutdown.java:484)
at net.sf.l2j.gameserver.Shutdown.run(Shutdown.java:236)
...
gameserver/logs/error0.log.0
SPOILER:
Feb 19, 2013 11:46:34 AM com.mchange.v2.c3p0.stmt.GooGooStatementCache checkinStatement
INFO: Problem with checked-in Statement, discarding.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:405)
at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:1132)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)
at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)
at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)
at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)
at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.storeCharBase(L2PcInstance.java:7590)
at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7496)
at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7504)
at net.sf.l2j.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:300)
at net.sf.l2j.gameserver.Shutdown.disconnectAllCharacters(Shutdown.java:550)
at net.sf.l2j.gameserver.Shutdown.saveData(Shutdown.java:484)
at net.sf.l2j.gameserver.Shutdown.run(Shutdown.java:236)
Feb 19, 2013 11:46:34 AM com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
INFO: An exception occurred while acquiring a poolable resource. Will retry.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
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:2214)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

...
My configs is:

server.properties
SPOILER:
# ---------------------------------------------------------------------------
# Game Server Settings
# ---------------------------------------------------------------------------
# This is the server configuration file. Here you can set up the connection information for your server.
# This was written with the assumption that you are behind a router.
# Dumbed Down Definitions...
# LAN (LOCAL area network) - typically consists of computers connected to the same router as you.
# WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet).
# x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers.
# ---------------------------------------------------------------------------
# Networking
# ---------------------------------------------------------------------------
# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
# Common settings...
# 127.0.0.1 - If you are playing alone on a test server
# 192.168.x.x - This is if you are on a 192.168.x.x type network (behind a standard consumer router) and want other computers from JUST the internal network to be able to connect
# x.x.x.x - WAN IP obtained from http://www.whatismyip.com/. This is if you want people outside your internal network to be able to connect to your server.
# If this IP is resolvable by the Login Server, just leave *.
# ---------------------------------------------------------------------------
# Default: *
ExternalHostname = mydomain.net /////(there is my domain name)

# ---------------------------------------------------------------------------
# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname.
# This can be the internal IP such as 127.0.0.1 or the computer's IP such as 192.168.x.x.
# If this IP is resolvable by the Login Server, just leave *.
# ---------------------------------------------------------------------------
# Default: *
InternalHostname = 192.168.0.10 /////(there is my lan ip)

# Where's the Login server this gameserver should connect to
# Default: 127.0.0.1
LoginHost = 127.0.0.1

# TCP port the login server listen to for gameserver connection requests
# Default: 9014
LoginPort = 9014

# Default: *
GameserverHostname = *

# Default: 7777
GameserverPort = 7777


# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------
# Specify the appropriate driver and url for the database you're using.
# Examples:
# Driver = com.mysql.jdbc.Driver (default)
# Driver = org.hsqldb.jdbcDriver
# Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver = com.mysql.jdbc.Driver
# Database URL
# URL = jdbc:mysql://localhost/l2jdb (default)
# URL = jdbc:hsqldb:hsql://localhost/l2jdb
# URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password =
URL = jdbc:mysql://localhost/l2jdb?useUnicode=true&characterEncoding=UTF-8 /////(there is for unicode char names)
# Database user info (default is "root" but it's not recommended)
Login = login /////(there is my login for MySQL database)
# Database connection password
Password = password /////(there is my password for MySQL database)

# Default: 100
MaximumDbConnections = 100

# Default: 0
MaximumDbIdleTime = 0

# ---------------------------------------------------------------------------
# Misc Server Settings
# ---------------------------------------------------------------------------
# This is the server ID that the Game Server will request.
# Example: 1 = Bartz
# Default: 1
RequestServerID = 1

# True = The Login Server will give an other ID to the server if the requested ID is already reserved.
# Default: True
AcceptAlternateID = True

# Datapack root directory.
# Defaults to current directory from which the server is started unless the below line is uncommented.
#DatapackRoot = C:/Work/tmp/DataPack

# Define how many players are allowed to play simultaneously on your server.
# Default: 100
MaximumOnlineUsers = 100

# Minimum and maximum protocol revision that server allow to connect.
# Warning: You must make sure that the minimum revision is always less than or equal to the maximum revision.
# Default: 83
MinProtocolRevision = 1

# Default: 87
MaxProtocolRevision = 9999


# ---------------------------------------------------------------------------
# Misc Player Settings
# ---------------------------------------------------------------------------

# Character name template.
# Examples:
# CnameTemplate = [A-Z][a-z]{3,3}[A-Za-z0-9]*
# The above setting will allow names with first capital letter, next three small letters,
# and any letter (case insensitive) or number, like OmfgWTF1
# CnameTemplate = [A-Z][a-z]*
# The above setting will allow names only of letters with first one capital, like Omfgwtf
# Default .* (allows any symbol)
CnameTemplate = .*

# This setting restricts names players can give to their pets.
# See CnameTemplate for details
PetNameTemplate = .*

# Maximum number of characters per account.
# Default: 7 (client limit)
CharMaxNumber = 7
loginserver.properties
SPOILER:
# ---------------------------------------------------------------------------
# Login Server Settings
# ---------------------------------------------------------------------------
# This is the server configuration file. Here you can set up the connection information for your server.
# This was written with the assumption that you are behind a router.
# Dumbed Down Definitions...
# LAN (LOCAL area network) - typically consists of computers connected to the same router as you.
# WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet).
# x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers.
# ---------------------------------------------------------------------------
# Networking
# ---------------------------------------------------------------------------
# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
# Common settings...
# 127.0.0.1 - If you are playing alone on a test server
# 192.168.x.x - This is if you are on a 192.168.x.x type network (behind a standard consumer router) and want other computers from JUST the internal network to be able to connect
# x.x.x.x - WAN IP obtained from http://www.whatismyip.com/. This is if you want people outside your internal network to be able to connect to your server.
# ---------------------------------------------------------------------------
# Default: 127.0.0.1
ExternalHostname = mydomain.net /////(there is my domain name)

# ---------------------------------------------------------------------------
# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname.
# This can be the internal IP such as 127.0.0.1 or the computer's IP such as 192.168.x.x.
# ---------------------------------------------------------------------------
# Default: 127.0.0.1
InternalHostname = 192.168.0.10 /////(there is my lan ip)

# ---------------------------------------------------------------------------
# If you are behind a router which using its own local IP for Port Forwarding then set this to the routers
# local IP if you want people outside your internal network to be able to connect to your server.
# ---------------------------------------------------------------------------
# RouterHostname =

# Bind ip of the LoginServer, use * to bind on all available IPs
# Default: *
LoginserverHostname = *

# Default: 2106
LoginserverPort = 2106

# The address on which login will listen for GameServers, use * to bind on all available IPs
# Default: *
LoginHostname = *

# The port on which login will listen for GameServers
# Default: 9014
LoginPort = 9014

# The delay in minutes after which the login updates the gameservers IP's (usefull when their ip is dynamic)
# Default: 15
IpUpdateTime = 15


# ---------------------------------------------------------------------------
# Security
# ---------------------------------------------------------------------------
# Default: True
LogLoginController = True

# How many times you can provide an invalid account/pass before the IP gets banned.
# Default: 10
LoginTryBeforeBan = 10

# Time you won't be able to login back again after LoginTryBeforeBan tries to login.
# Default: 600 (10 minutes)
LoginBlockAfterBan = 600

# If set to True any GameServer can register on your login's free slots
# Default: False
AcceptNewGameServer = False

# Enforce GameGuard authorization from client?
# If True, login server will kick client if the client bypassed GameGuard authentication.
# Default: False
ForceGGAuth = False

# Flood Protection. All values are in MILISECONDS.
# Default: True
EnableFloodProtection = True

# Default: 15
FastConnectionLimit = 15

# Default: 700
NormalConnectionTime = 700

# Default: 350
FastConnectionTime = 350

# Default: 50
MaxConnectionPerIP = 50


# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------
# Specify the appropriate driver and url for the database you're using.
# Examples:
# Driver = com.mysql.jdbc.Driver (default)
# Driver = org.hsqldb.jdbcDriver
# Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver = com.mysql.jdbc.Driver
# Database URL
# URL = jdbc:mysql://localhost/l2jdb (default)
# URL = jdbc:hsqldb:hsql://localhost/l2jdb
# URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password =
URL = jdbc:mysql://localhost/l2jdb?useUnicode=true&characterEncoding=UTF-8 /////(there is for unicode char names)
# Database user info (default is "root" but it's not recommended)
Login = login /////(there is my login for MySQL database)
# Database connection password
Password = password /////(there is my password for MySQL database)

# Default: 10
MaximumDbConnections = 10

# Default: 0
MaximumDbIdleTime = 0


# ---------------------------------------------------------------------------
# Misc.
# ---------------------------------------------------------------------------
# If False, the license (after the login) will not be shown.
# Default: True
ShowLicence = True

# Default: True
AutoCreateAccounts = True


# ---------------------------------------------------------------------------
# Developer Settings
# ---------------------------------------------------------------------------
# Default: False
Debug = False

# Default: False
Assert = False

# Default: False
Developer = False
wfk
Posts: 3
Joined: Fri Jan 18, 2013 10:42 am

Re: Mac OS X SL Server and Gracia Final.

Post by wfk »

Thank's for all. :/
Post Reply