Some problems with logger

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Sacrifice
Advanced User
Advanced User
Posts: 1026
Joined: Thu Aug 14, 2014 6:31 am

Re: Some problems with logger

Post by Sacrifice »

Sdw wrote:Yeah ?

Try to make a clean db install, have fun.
Give errors mysql connector also?
Sacrifice
Advanced User
Advanced User
Posts: 1026
Joined: Thu Aug 14, 2014 6:31 am

Re: Some problems with logger

Post by Sacrifice »

Sacrifice wrote:
Sdw wrote:Yeah ?

Try to make a clean db install, have fun.
Give errors mysql connector also?
FIXED!

Code: Select all

diff --git a/build.gradle b/build.gradle
index 07978b7..46ab553 100644
--- a/build.gradle
+++ b/build.gradle
@@ -21,7 +21,7 @@
 	compile 'com.zaxxer:HikariCP:2.4.7'
 	compile 'mysql:mysql-connector-java:6.0.3'
 	compile 'org.bitlet:weupnp:0.1.4'
-	compile 'org.eclipse.jdt.core.compiler:ecj:4.5.1'
+	compile 'org.eclipse.jdt.core.compiler:ecj:4.4.2'
 	compile 'com.google.guava:guava:19.0'
 	compile 'org.python:jython:2.2.1'
 	compile 'org.slf4j:slf4j-api:1.7.21'
diff --git a/src/main/java/com/l2jserver/tools/dbinstaller/util/mysql/MySqlConnect.java b/src/main/java/com/l2jserver/tools/dbinstaller/util/mysql/MySqlConnect.java
index 303b76b..f0f1311 100644
--- a/src/main/java/com/l2jserver/tools/dbinstaller/util/mysql/MySqlConnect.java
+++ b/src/main/java/com/l2jserver/tools/dbinstaller/util/mysql/MySqlConnect.java
@@ -38,7 +38,7 @@
 		try (Formatter form = new Formatter())
 		{
 			Class.forName("com.mysql.jdbc.Driver").newInstance();
-			final String formattedText = form.format("jdbc:mysql://%1$s:%2$s", host, port).toString();
+			final String formattedText = form.format("jdbc:mysql://%1$s:%2$s?useSSL=false&serverTimezone=Europe/Berlin", host, port).toString();
 			con = DriverManager.getConnection(formattedText, user, password);
 			
 			try (Statement s = con.createStatement())
@@ -111,4 +111,4 @@
 			return null;
 		}
 	}
-}
+}
\ No newline at end of file
I edited: Can be do it more better...
Last edited by Sacrifice on Sun Aug 21, 2016 7:20 pm, edited 1 time in total.
HorridoJoho
L2j Senior Developer
L2j Senior Developer
Posts: 795
Joined: Sun Aug 14, 2005 11:27 am

Re: Some problems with logger

Post by HorridoJoho »

No hardcoding of ssl usage and timezone please.
Sacrifice
Advanced User
Advanced User
Posts: 1026
Joined: Thu Aug 14, 2014 6:31 am

Re: Some problems with logger

Post by Sacrifice »

HorridoJoho wrote:No hardcoding of ssl usage and timezone please.
We dont plan to use it?. No?.
Sdw
L2j Veteran
L2j Veteran
Posts: 855
Joined: Mon May 03, 2010 8:38 am
Location: France

Re: Some problems with logger

Post by Sdw »

Getting closer.

Now with your full new fresh SQL install, try to run gameserver
Sacrifice
Advanced User
Advanced User
Posts: 1026
Joined: Thu Aug 14, 2014 6:31 am

Re: Some problems with logger

Post by Sacrifice »

Are you registered first new gameserver using RegisterGameServer.bat file on login folder?
Sdw
L2j Veteran
L2j Veteran
Posts: 855
Joined: Mon May 03, 2010 8:38 am
Location: France

Re: Some problems with logger

Post by Sdw »

Guess it would trigger the issue too
Sacrifice
Advanced User
Advanced User
Posts: 1026
Joined: Thu Aug 14, 2014 6:31 am

Re: Some problems with logger

Post by Sacrifice »

Sdw wrote:Guess it would trigger the issue too
Well, we do not anticipate events yet...
Sacrifice
Advanced User
Advanced User
Posts: 1026
Joined: Thu Aug 14, 2014 6:31 am

Re: Some problems with logger

Post by Sacrifice »

With ecj 4.5.1 works very well
User avatar
u3games
Posts: 1156
Joined: Sun Feb 27, 2011 7:00 pm
Location: España
Contact:

Re: Some problems with logger

Post by u3games »

Sacrifice wrote:I dont know with security what's 'the shit' differences between ecj version 4.5.1 and ecj version 4.4.2, but with this patch, server comes back to life!!!.
Remember to refresh gradle projects (both)

Code: Select all

diff --git a/build.gradle b/build.gradle
index 07978b7..46ab553 100644
--- a/build.gradle
+++ b/build.gradle
@@ -21,7 +21,7 @@
 	compile 'com.zaxxer:HikariCP:2.4.7'
 	compile 'mysql:mysql-connector-java:6.0.3'
 	compile 'org.bitlet:weupnp:0.1.4'
-	compile 'org.eclipse.jdt.core.compiler:ecj:4.5.1'
+	compile 'org.eclipse.jdt.core.compiler:ecj:4.4.2'
 	compile 'com.google.guava:guava:19.0'
 	compile 'org.python:jython:2.2.1'
 	compile 'org.slf4j:slf4j-api:1.7.21'
Anybody can commit this please meanwhile ECJ 4.5.1 becomes... FUNCTIONAL? :lol:
Thx, fix error to last commit. But... in gameserver console:

Image

??
Image
Sacrifice
Advanced User
Advanced User
Posts: 1026
Joined: Thu Aug 14, 2014 6:31 am

Re: Some problems with logger

Post by Sacrifice »

I dont have issues like yours... I edited .bat and .sh start files with classpath and 0.0 problems now.

I repeat that with last libs that L2J liberate is working, just edit launchers.
User avatar
u3games
Posts: 1156
Joined: Sun Feb 27, 2011 7:00 pm
Location: España
Contact:

Re: Some problems with logger

Post by u3games »

Sacrifice wrote:I dont have issues like yours... I edited .bat and .sh start files with classpath and 0.0 problems now.

I repeat that with last libs that L2J liberate is working, just edit launchers.
post the edit pls ;)
Image
Sacrifice
Advanced User
Advanced User
Posts: 1026
Joined: Thu Aug 14, 2014 6:31 am

Re: Some problems with logger

Post by Sacrifice »

Login windon

Code: Select all

java -Xms128m -Xmx256m -cp ./../libs/*;l2jlogin.jar com.l2jserver.loginserver.L2LoginServer
Game windon

Code: Select all

java -Djava.util.logging.manager=com.l2jserver.util.L2LogManager -Dpython.cachedir=../cachedir -Xms1024m -Xmx1536m -cp ./../libs/*;l2jserver.jar com.l2jserver.gameserver.GameServer
Login linux

Code: Select all

#!/bin/bash

err=1
until [ $err == 0 ]; 
do
	[ -f log/java0.log.0 ] && mv log/java0.log.0 "log/`date +%Y-%m-%d_%H-%M-%S`_java.log"
	[ -f log/stdout.log ] && mv log/stdout.log "log/`date +%Y-%m-%d_%H-%M-%S`_stdout.log"
	java -Xms128m -Xmx256m -cp ./../libs/*;l2jlogin.jar com.l2jserver.loginserver.L2LoginServer > log/stdout.log 2>&1
	err=$?
	sleep 10;
done
Game Linux

Code: Select all

#!/bin/bash

# exit codes of GameServer:
#  0 normal shutdown
#  2 reboot attempt

while :; do
	[ -f log/java0.log.0 ] && mv log/java0.log.0 "log/`date +%Y-%m-%d_%H-%M-%S`_java.log"
	[ -f log/stdout.log ] && mv log/stdout.log "log/`date +%Y-%m-%d_%H-%M-%S`_stdout.log"
	java -Djava.util.logging.manager=com.l2jserver.util.L2LogManager -Dpython.cachedir=../cachedir -Xms1024m -Xmx1536m -cp ./../libs/*;l2jserver.jar com.l2jserver.gameserver.GameServer > log/stdout.log 2>&1
	[ $? -ne 2 ] && break
#	/etc/init.d/mysql restart
	sleep 10
done
User avatar
u3games
Posts: 1156
Joined: Sun Feb 27, 2011 7:00 pm
Location: España
Contact:

Re: Some problems with logger

Post by u3games »

Ok ok work perfet. My error:

Image

is in l2j-eventengine last version.
Image
Sacrifice
Advanced User
Advanced User
Posts: 1026
Joined: Thu Aug 14, 2014 6:31 am

Re: Some problems with logger

Post by Sacrifice »

u3games wrote:Ok ok work perfet. My error:

Image

is in l2j-eventengine last version.
Recompile server with l2jeventengine.jar inside server libs folder to be added in compilation. This will create a new l2jserver.jar replace it in server too. With this indications sure will work fine.
Post Reply