Domi

Found a solution by myself. The Problem was that: time column was INT instead of DATE in the Database and the second error which occurred right after we fixed this issue was that the hostname column was also INT instead of VARCHAR. Simply ALTER TABLE on bootlog fixed this issue for us. Thanks

Hello again, At the moment we are working on 40k files from speedi with vanilla core 2.4.1 Hotfix 2 and we found an error occurre in our syserr which looks like this: SYSERR: Nov 23 21:20:37 :: pid_init: Start of pid: 958 SYSERR: Nov 23 21:20:37 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'time' at row 1 (query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth_test', 1) errno: 1264) SYSERR: Nov 23 21:22:40 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Nov 23 21:22:40 :: pid_deinit: End of pid MySQL 5.6 with no special changes. - .Domii

I already asked Rumor kindly to move it - got some struggles with that sorry - i'm new to this forum.

Hello metin2dev.org community, I'm currently playing around with a little local server for development using the following setup: VirtualBox FreeBSD 9.2 x64 Speedi Files Vanilla Core rev54250 (2.4.1 Hotfix 2) Test Client for 40250 Traffic will be don't with an exposed host. BIND_IP was also configured in the CONFIGs. Me at my side I can reach the server through the Test Client for 40250 without any problem, the problem shows up when a co worker tries to also log in to the server. After he choose his charakter and will connect to the world server he will be redirected directly to the login view. So my question is: 1. Is it possible to run these files with dyndns? and if 1. Yes 2. do I need a special client? Syslog from my Channel: Nov 24 08:15:00 :: SYSTEM: new connection from [xx.xxx.xx.xxx] fd: 25 handshake 2892314014 output input_len 0, ptr 0x2b15a000 Nov 24 08:15:00 :: SYSTEM: closing socket. DESC #25 Nov 24 08:15:10 :: SYSTEM: new connection from [xx.xxx.xx.xxx] fd: 25 handshake 618977239 output input_len 0, ptr 0x2b15a000 Nov 24 08:15:10 :: Handshake: lower than zero -19 Nov 24 08:15:10 :: Handshake: client_time 0 server_time 109732 Nov 24 08:15:11 :: LOGIN_BY_KEY: testaccount key 384423361 Nov 24 08:15:11 :: LoginSuccess Nov 24 08:15:11 :: player(testuser).job(2) Nov 24 08:15:11 :: player().job(0) Nov 24 08:15:11 :: player().job(0) Nov 24 08:15:11 :: player().job(0) Nov 24 08:15:11 :: success to 192.168.178.59:23070 Nov 24 08:15:11 :: InputDB::login_success: testaccount Nov 24 08:15:17 :: SYSTEM: closing socket. DESC #25 Nov 24 08:15:21 :: SYSTEM: new connection from [xx.xxx.xx.xxx] fd: 25 handshake 109386880 output input_len 0, ptr 0x2b15a000 Nov 24 08:15:21 :: SYSTEM: closing socket. DESC #25 And the syslog from the auth: Nov 24 08:15:09 :: SYSTEM: new connection from [xx.xxx.xx.xxx] fd: 15 handshake 2179630229 output input_len 0, ptr 0x2890e000 Nov 24 08:15:09 :: Handshake: lower than zero -3 Nov 24 08:15:09 :: Handshake: client_time 0 server_time 131363 Nov 24 08:15:09 :: AUTH_PHASE 0x2890e000 Nov 24 08:15:09 :: InputAuth::Login : testaccount(8) desc 0x2890e000 Nov 24 08:15:09 :: SetLoginKey 384423361 Nov 24 08:15:09 :: InputAuth::Login : key 384423361:0x4b59c72f login testaccount Nov 24 08:15:10 :: QID_AUTH_LOGIN: START 384423361 0x2890e000 Nov 24 08:15:10 :: Create_Time 0 19700101 Nov 24 08:15:10 :: Block Time -2 Nov 24 08:15:10 :: SetRemainSecs testaccount 0 type 2 Nov 24 08:15:10 :: SendAuthLogin testaccount key 52168 Nov 24 08:15:10 :: AuthLogin result 1 key 384423361 Nov 24 08:15:10 :: SYSTEM: closing socket. DESC #15 Thanks. - Domi