impossible to connect windows 10 pc to mtg vm server hosted on debian10

retikulatus

New Member
Joined
Mar 23, 2021
Messages
12
Dear developers,

First, thank you for your amazing site and the way you explain things:
The https://github.com/ModTheGalaxy/DevEnv and https://github.com/ModTheGalaxy/mtgserver/wiki/Guide-DevEnv-Setup are absolutely fantastic!

First i had to activate virtualization in my bios and after that, everything went smoothly et there was no problems!!!
The core compile and run flawlessly (i see some "error" and "warning" tag, but it works!)

i host your VM server on a debian 10 computer and my client is on a windows 10 pc...
i followed your guide to the letter, i changed the galaxy ip ( in my case: 192.168.1.10)in the swgemu database, i checked swgemu_login.cfg as well (192.168.1.10) port 4453
but when i can't connect to the galaxy with my client.
As my debian 10host and the VM see perfectly the entire network , including my windows computer, but not in the other way, should i need to install samba on the debian host? On the VM?
i am very sorry to bother you and i hope somebody will have a solution.
May the force be with you...
warm regards from Guadeloupe

[EDIT] to be seen on my windows 10 computer, do i need to change the config.lua file as well, changing DBHost and MantisHost "127.0.0.1", to "192.168.1.10" (my lan IP)?
I tried this but the core3 doesn't initiate anymore (mysql password problems....)
 
Last edited:

Aeryna

Moderator
Staff member
Moderator
Joined
Oct 10, 2017
Messages
359
Try Port: 44453. port 4453 is wrong.
In swgemu_login.cfg
loginServerPort0=44453
loginServerAddress0=192.168.1.10 or your public address.


And open in your VM (host & guest) TCP 44443/44455/44480,
TCP 127.0.0.1 - host port 2222, guest port 22 to allow internet on that VM.
UDP (host & guest) 44453/44462/44463
if they are not.
 

retikulatus

New Member
Joined
Mar 23, 2021
Messages
12
whoah , thank you so much for your reply, Aeryna!
Yes i mistyped 44453 in the post :)

i will try to find a software or the appropriate command line to do as you tell me.
I will let you know if it is working!

warm regards from Guadeloupe:)

[EDIT]
Dear Aeryna,
i am a bit confused: when i check on the web infos about opening tcp /udp ports on Linux, they say that ports are by default open.
if you could give me an exemple syntax to open tcp udp on linux, i would be grateful :)

i will configure my internet box to open the ports you mentionned

[EDIT2]
as i saw my VM server IP was different than the host IP, i changed the IP galaxy to the right IP (192.168.1.11) i am now able to see the galaxy in my client but when i try to connect to it, i have these messages randomly:
"Login Error: Your session key is invalid, or has expired. Please re-login" or
"Sorry , you are not allowed to create any more characters on this galaxy" (i have none :p)

one step at a time, hey! :)

[EDIT3]
Did you managed to set/compil/open a non VM MtG server?
i actually didn't find the GIT for the MMOCoreORB of the MtG server...
If there is a guide to do so , please feel free to point me to the right topic. ;)

thank you
 
Last edited:

Aeryna

Moderator
Staff member
Moderator
Joined
Oct 10, 2017
Messages
359
[EDIT]
Dear Aeryna,
i am a bit confused: when i check on the web infos about opening tcp /udp ports on Linux, they say that ports are by default open.
if you could give me an exemple syntax to open tcp udp on linux, i would be grateful :)

i will configure my internet box to open the ports you mentionned

Your ports are open in Linux but maybe not in your Linux VM. Check at VirtualBox Network options if you got those ports i said you.
Open a terminal and do "sudo netstat -lntup" . Watch if your ports are working.
 

Aeryna

Moderator
Staff member
Moderator
Joined
Oct 10, 2017
Messages
359
as i saw my VM server IP was different than the host IP, i changed the IP galaxy to the right IP (192.168.1.11) i am now able to see the galaxy in my client but when i try to connect to it, i have these messages randomly:
"Login Error: Your session key is invalid, or has expired. Please re-login"

Fixing that issue is easy. Just back to login box and get in again.
 

retikulatus

New Member
Joined
Mar 23, 2021
Messages
12
Aeryna,
Again, i think you for your patience and your replies.

i managed to compile a MtG server with no VM...
The core initialize correctly (it connects to the 127.0.0.1 databases, loads the .tre files etc...)
in my windows client, i see the server, i connect to it, when i create a character i see in the swgemu account database the new account.
BUT ( alas! :p) when i create a character, it doesn't really create it (when i log off and try to come back it isn't possible , if i launch again the client, the character is not there.
When i check in the server terminal i get this message:
--------------------------------------
[MySqlDatabase1] ERROR - DatabaseException caused by query: INSERT INTO `characters_dirty` (`character_oid`, `account_id`, `galaxy_id`, `firstname`, `surname`, `race`, `gender`, `template`) VALUES (281474993549012,1,2,'Piba','Suvu',0,0,'object/creature/player/human_male.iff')
1364: Field 'creation_date' doesn't have a default value
(873 s) [MySqlDatabase1] ERROR - DatabaseException caused by query: DatabaseException caused by query: INSERT INTO `characters_dirty` (`character_oid`, `account_id`, `galaxy_id`, `firstname`, `surname`, `race`, `gender`, `template`) VALUES (281474993549012,1,2,'Piba','Suvu',0,0,'object/creature/player/human_male.iff')
1364: Field 'creation_date' doesn't have a default value
1364: Field 'creation_date' doesn't have a default value
(873 s) [Console] ERROR - exception caught while running a task
DatabaseException caused by query: DatabaseException caused by query: INSERT INTO `characters_dirty` (`character_oid`, `account_id`, `galaxy_id`, `firstname`, `surname`, `race`, `gender`, `template`) VALUES (281474993549012,1,2,'Piba','Suvu',0,0,'object/creature/player/human_male.iff')
1364: Field 'creation_date' doesn't have a default value
1364: Field 'creation_date' doesn't have a default value
------------------------------
it is the same error i get with the "regular" swgemu core3 server as well , as i tested it too.
I am sure there is no syntaxe problems in the databases because i created them directly with mysql workbench, the scripts of the 3 databases executed flawlessly...
This is madness!...I am beginning to think i am cursed with swgemu :)

I don't know what to do anymore: i have access to the server, i can create an account, so it isn't a problem of tcp udp ports, i am so close and lost at the same time...

Big thanks to you, anyway ! :)

[EDIT] i tested it with a modified client (with the MtG .tre files) and the regular swgemu client, and i have the same results...so i don't think it is a problem of client configuration...
 
Last edited:

Aeryna

Moderator
Staff member
Moderator
Joined
Oct 10, 2017
Messages
359
Install a workbench for Mysql for Debian (sudo apt-get install mysql-workbench). Or open a terminal:
mysql -u root -p
SHOW DATABASES;
USE swgemu;
SELECT * FROM accounts; (look for your account)
SELECT * FROM characters_dirty; (search any toon there).

* Maybe i'm wrong because i'm thinking this without a terminal.

Open your mysql and look for "characters_dirty" inside swgemu db. Check if you got any toon there and you'll get the issue. Your client and server don't hace the same TRE files or version updated.

((* I read now you had a workbench :p))
 

retikulatus

New Member
Joined
Mar 23, 2021
Messages
12
hello again. :)

no, i don't have any toon there, "it" simply refuses to create a character.
i even tried to create, manually , one "characters_dirty" in the swgemu database, after shutting down the server: the core simply delete it when i relaunch it!

Anyway, thank you very much, again, for your reply!
 

retikulatus

New Member
Joined
Mar 23, 2021
Messages
12
Dear Aeryna,

[EDIT]

I tried a solution: edit swgemu.sql and modify in "characters_dirty" the raw
`creation_date` TIMESTAMP NOT NULL, by
`creation_date` TIMESTAMP NOT NULL DEFAULT '0',
then i dropped the schema swgemu in mysql workbench, recreated the schema swgemu and reinstalled swgemu.sql,datatables.sql and mantis.sql.
set the right IP address in the galaxy table (again! :p)
systemctl restart mysql
and relaunched the core3....

as the core is runnning, i can log off, log on and my character is still stored in the "characters_dirty" database, but its creation_date is set 0000.00.00 (etc...) not the appropriate date of creation...

unfortunately, when i shutdown the core, the character created is somehow deleted...
I suppose i will have to reverse what i did ( remove the "DEFAULT '0'"...

i saw this guide :
https://ourcodeworld.com/articles/read/757/how-to-solve-mysql-exception-sqlstatehy000-general-error-1364-field-field-name-doesnt-have-a-default-value
i will try to test it tomorrow...


Thank you again for your assistance.
may the force be with you!
warm regards from Guadeloupe
 
Last edited:

retikulatus

New Member
Joined
Mar 23, 2021
Messages
12
[SOLVED]
A last!
After changing the mode of mysql by : ALLOW_INVALID_DATE , i was FINALLY able to create characters in the server!
My thanks to Aeryna who took the time to answer me! ( /deepbow Aeryna)
Website admins, fell free to add a [SOLVED] in my topic, as i don't know how to proceed, please.
kind regards from Guadeloupe.
 
Top Bottom