Fifth game of the multiplayer slow game server

For topics that do not fit in another sub-forum.

Moderator: Oberlus

Message
Author
User avatar
swaq
Space Dragon
Posts: 384
Joined: Tue Aug 20, 2019 1:56 pm

Re: Fifth game of the multiplayer slow game server

#46 Post by swaq »

They did not show up in my junk folder either. I have the freeorion-test e-mail address in my contacts list in order to prevent that too.

User avatar
alleryn
Space Dragon
Posts: 259
Joined: Sun Nov 19, 2017 6:32 pm

Re: Fifth game of the multiplayer slow game server

#47 Post by alleryn »

swaq wrote: Tue Oct 01, 2019 8:12 pm They did not show up in my junk folder either. I have the freeorion-test e-mail address in my contacts list in order to prevent that too.
As o01eg mentioned, you won't get the emails while you are logged in. How did you leave the game when you left? Resign button or some other method?

User avatar
swaq
Space Dragon
Posts: 384
Joined: Tue Aug 20, 2019 1:56 pm

Re: Fifth game of the multiplayer slow game server

#48 Post by swaq »

alleryn wrote: Tue Oct 01, 2019 8:15 pm
swaq wrote: Tue Oct 01, 2019 8:12 pm They did not show up in my junk folder either. I have the freeorion-test e-mail address in my contacts list in order to prevent that too.
As o01eg mentioned, you won't get the emails while you are logged in. How did you leave the game when you left? Resign button or some other method?
I think I used the resign button. But the server was crashed at that time so I don't think it would have received my log-out.

User avatar
alleryn
Space Dragon
Posts: 259
Joined: Sun Nov 19, 2017 6:32 pm

Re: Fifth game of the multiplayer slow game server

#49 Post by alleryn »

The Silent One wrote: Tue Oct 01, 2019 7:15 pm
Oberlus wrote:It seems I broke it by connecting as o01eg's delegate.
And the bug-hunt is on again!
I guess my first thought here is are we logging in the right player name when we log in a delegate? When Oberlus logs in as o01eg's delegate, it should try to authenticate him as o01eg, right? So i'm trying to search for where this happens in the PUBLIC_SERVER.md file to make sure we are inserting the correct data into all the tables.

Not sure if this is helpful or not, but i thought i would just update what i was trying.

o01eg
Programmer
Posts: 2026
Joined: Sat Dec 10, 2011 5:46 am

Re: Fifth game of the multiplayer slow game server

#50 Post by o01eg »

alleryn wrote: Tue Oct 01, 2019 8:33 pm
The Silent One wrote: Tue Oct 01, 2019 7:15 pm
Oberlus wrote:It seems I broke it by connecting as o01eg's delegate.
And the bug-hunt is on again!
I guess my first thought here is are we logging in the right player name when we log in a delegate? When Oberlus logs in as o01eg's delegate, it should try to authenticate him as o01eg, right? So i'm trying to search for where this happens in the PUBLIC_SERVER.md file to make sure we are inserting the correct data into all the tables.

Not sure if this is helpful or not, but i thought i would just update what i was trying.
It isn't issue here as password was sent to Oberlus e-mail as well.
Gentoo Linux x64, gcc-11.2, boost-1.78.0
Ubuntu Server 22.04 x64, gcc-12, boost-1.74.0
Welcome to the slow multiplayer game at freeorion-lt.dedyn.io.Version 2024-04-14.ad50e93.
Donations're welcome:BTC:bc1q007qldm6eppqcukewtfkfcj0naut9njj7audnm

User avatar
alleryn
Space Dragon
Posts: 259
Joined: Sun Nov 19, 2017 6:32 pm

Re: Fifth game of the multiplayer slow game server

#51 Post by alleryn »

What about this part (lines 315-322 in PUBLIC_SERVER.md):

Code: Select all

FROM games.players p
 INNER JOIN auth.users u ON u.player_name = p.delegate_name
 INNER JOIN auth.contacts c ON c.player_name = u.player_name
  AND c.is_active = TRUE
  AND c.delete_ts IS NULL
 WHERE p.player_name = player_name_param
 AND p.game_uid = game_uid_param
 AND delegate_name IS NOT NULL;
In that last line shouldn't it be p.delegate_name ?

Doesn't seem like it would be the source of our problem here, i'm just trying to get a handle on whether i'm reading this correctly.

o01eg
Programmer
Posts: 2026
Joined: Sat Dec 10, 2011 5:46 am

Re: Fifth game of the multiplayer slow game server

#52 Post by o01eg »

alleryn wrote: Tue Oct 01, 2019 8:55 pm What about this part (lines 315-322 in PUBLIC_SERVER.md):

Code: Select all

FROM games.players p
 INNER JOIN auth.users u ON u.player_name = p.delegate_name
 INNER JOIN auth.contacts c ON c.player_name = u.player_name
  AND c.is_active = TRUE
  AND c.delete_ts IS NULL
 WHERE p.player_name = player_name_param
 AND p.game_uid = game_uid_param
 AND delegate_name IS NOT NULL;
In that last line shouldn't it be p.delegate_name ?

Doesn't seem like it would be the source of our problem here, i'm just trying to get a handle on whether i'm reading this correctly.
There no other delegate_name fields.
Gentoo Linux x64, gcc-11.2, boost-1.78.0
Ubuntu Server 22.04 x64, gcc-12, boost-1.74.0
Welcome to the slow multiplayer game at freeorion-lt.dedyn.io.Version 2024-04-14.ad50e93.
Donations're welcome:BTC:bc1q007qldm6eppqcukewtfkfcj0naut9njj7audnm

User avatar
swaq
Space Dragon
Posts: 384
Joined: Tue Aug 20, 2019 1:56 pm

Re: Fifth game of the multiplayer slow game server

#53 Post by swaq »

Should I be trying something else to log in? Still not getting any e-mails.

User avatar
alleryn
Space Dragon
Posts: 259
Joined: Sun Nov 19, 2017 6:32 pm

Re: Fifth game of the multiplayer slow game server

#54 Post by alleryn »

swaq wrote: Tue Oct 01, 2019 9:48 pm Should I be trying something else to log in? Still not getting any e-mails.
I think probably we should wait until Oberlus can try to log in again as delegate? Then if bug with delegate is still occuring, o01eg can get coredump (i don't know what it is, but maybe it will help us find the problem).

Hopefully this email problem is related to delegate problem, so if we fix one we fix the other? (Problem didn't occur before delegate crash).

This would be my suggestion.

By the way, turn length for the testgame was increased to 24 hours i think. Did everyone get a chance to log in yet? I believe i saw TSO, o01leg, swaq, Magnate and myself. So i guess everyone except JonCST (i think he usually logs on later in the day)?

User avatar
Oberlus
Cosmic Dragon
Posts: 5759
Joined: Mon Apr 10, 2017 4:25 pm

Re: Fifth game of the multiplayer slow game server

#55 Post by Oberlus »

o01eg wrote: Tue Oct 01, 2019 7:48 pmCould you try to login again?
I was able to connect, had a glance of some chats in the lobby and FO crashed again.

Code: Select all

Error: XML start/end tag mismatch - bout
I guess the problem is I haven't updated freeorion and my client is incompatible with some of the latest additions :oops:
I'll report back when I update and try again.

User avatar
Geoff the Medio
Programming, Design, Admin
Posts: 13603
Joined: Wed Oct 08, 2003 1:33 am
Location: Munich

Re: Fifth game of the multiplayer slow game server

#56 Post by Geoff the Medio »

Oberlus wrote: Tue Oct 01, 2019 11:03 pmI was able to connect, had a glance of some chats in the lobby and FO crashed again.

Code: Select all

Error: XML start/end tag mismatch - bout
Please post logs after producing this, ideally with trace logging on, probably in a separate thread or on github.

o01eg
Programmer
Posts: 2026
Joined: Sat Dec 10, 2011 5:46 am

Re: Fifth game of the multiplayer slow game server

#57 Post by o01eg »

Oberlus wrote: Tue Oct 01, 2019 11:03 pm
o01eg wrote: Tue Oct 01, 2019 7:48 pmCould you try to login again?
I was able to connect, had a glance of some chats in the lobby and FO crashed again.

Code: Select all

Error: XML start/end tag mismatch - bout
I guess the problem is I haven't updated freeorion and my client is incompatible with some of the latest additions :oops:
I'll report back when I update and try again.
The server didn't crashed. Yes, it better to have a same version.
Gentoo Linux x64, gcc-11.2, boost-1.78.0
Ubuntu Server 22.04 x64, gcc-12, boost-1.74.0
Welcome to the slow multiplayer game at freeorion-lt.dedyn.io.Version 2024-04-14.ad50e93.
Donations're welcome:BTC:bc1q007qldm6eppqcukewtfkfcj0naut9njj7audnm

o01eg
Programmer
Posts: 2026
Joined: Sat Dec 10, 2011 5:46 am

Re: Fifth game of the multiplayer slow game server

#58 Post by o01eg »

swaq wrote: Tue Oct 01, 2019 9:48 pm Should I be trying something else to log in? Still not getting any e-mails.
The server says in the logs it sends you e-mail. Maybe try different address or even XMPP?
Gentoo Linux x64, gcc-11.2, boost-1.78.0
Ubuntu Server 22.04 x64, gcc-12, boost-1.74.0
Welcome to the slow multiplayer game at freeorion-lt.dedyn.io.Version 2024-04-14.ad50e93.
Donations're welcome:BTC:bc1q007qldm6eppqcukewtfkfcj0naut9njj7audnm

User avatar
Oberlus
Cosmic Dragon
Posts: 5759
Joined: Mon Apr 10, 2017 4:25 pm

Re: Fifth game of the multiplayer slow game server

#59 Post by Oberlus »

I've upgraded to latest Windows version and tried to reconnect as o01eg. Now I'm not receiving the email with the pass. I've waited several minutes, checked every folder of email...

Then I tried to log in as Oberlus, got the email with the pass, got to the lobby, and that's it. No crash but game is not accepting new players.

Then tried again as o01eg, still no pass in my email.

o01eg
Programmer
Posts: 2026
Joined: Sat Dec 10, 2011 5:46 am

Re: Fifth game of the multiplayer slow game server

#60 Post by o01eg »

Oberlus wrote: Wed Oct 02, 2019 7:28 am I've upgraded to latest Windows version and tried to reconnect as o01eg. Now I'm not receiving the email with the pass. I've waited several minutes, checked every folder of email...

Then I tried to log in as Oberlus, got the email with the pass, got to the lobby, and that's it. No crash but game is not accepting new players.

Then tried again as o01eg, still no pass in my email.
The server gets error '451 Authentication failed: Maximum credits exceeded' when sending e-mail to me. Looks strange.
Gentoo Linux x64, gcc-11.2, boost-1.78.0
Ubuntu Server 22.04 x64, gcc-12, boost-1.74.0
Welcome to the slow multiplayer game at freeorion-lt.dedyn.io.Version 2024-04-14.ad50e93.
Donations're welcome:BTC:bc1q007qldm6eppqcukewtfkfcj0naut9njj7audnm

Post Reply