Page 2 of 3

Re: Some problems with logger

Posted: Fri Aug 05, 2016 8:43 am
by Sacrifice
Sdw wrote:Yeah ?

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

Re: Some problems with logger

Posted: Fri Aug 05, 2016 11:03 am
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...

Re: Some problems with logger

Posted: Fri Aug 05, 2016 12:51 pm
by HorridoJoho
No hardcoding of ssl usage and timezone please.

Re: Some problems with logger

Posted: Fri Aug 05, 2016 1:35 pm
by Sacrifice
HorridoJoho wrote:No hardcoding of ssl usage and timezone please.
We dont plan to use it?. No?.

Re: Some problems with logger

Posted: Fri Aug 05, 2016 4:16 pm
by Sdw
Getting closer.

Now with your full new fresh SQL install, try to run gameserver

Re: Some problems with logger

Posted: Fri Aug 05, 2016 4:18 pm
by Sacrifice
Are you registered first new gameserver using RegisterGameServer.bat file on login folder?

Re: Some problems with logger

Posted: Fri Aug 05, 2016 4:39 pm
by Sdw
Guess it would trigger the issue too

Re: Some problems with logger

Posted: Sat Aug 20, 2016 8:33 pm
by Sacrifice
Sdw wrote:Guess it would trigger the issue too
Well, we do not anticipate events yet...

Re: Some problems with logger

Posted: Sun Aug 21, 2016 7:21 pm
by Sacrifice
With ecj 4.5.1 works very well

Re: Some problems with logger

Posted: Sun Aug 21, 2016 7:26 pm
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

??

Re: Some problems with logger

Posted: Sun Aug 21, 2016 10:34 pm
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.

Re: Some problems with logger

Posted: Mon Aug 22, 2016 8:02 pm
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 ;)

Re: Some problems with logger

Posted: Tue Aug 23, 2016 10:15 pm
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

Re: Some problems with logger

Posted: Wed Aug 24, 2016 3:54 pm
by u3games
Ok ok work perfet. My error:

Image

is in l2j-eventengine last version.

Re: Some problems with logger

Posted: Wed Aug 24, 2016 4:38 pm
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.