The Castle Doctrine Forums

st333rrr

Member

Registered: 2016-10-01

Posts: 1

Problems with setting up server

Hello to all. I read wiki page of setting server up and I do it, but... I can't connect. Game writes "Login failed", when I try to connect. Do you have any ideas about this?

zed

Member

Registered: 2013-04-16

Posts: 171

Re: Problems with setting up server

What version of PHP are you using? The server code is written for an old
version, and is broken in a few ways for more recent versions. I've just
edited it to work with PHP 7; I can send you the diffs if you think that might
be the problem.

In particular, if the ticketserver gives any "deprecated" warnings, that'll
confuse the server. s/\<mysql_/@mysql_/g is a hacky way to quickly handle
that.

mv

Member

Registered: 2017-11-19

Posts: 5

Re: Problems with setting up server

could anyone send me patches for php7 please?
I was able to get ticketServer working, but stuck with game server

zed

Member

Registered: 2013-04-16

Posts: 171

Re: Problems with setting up server

Hopefully these should be all you need:
https://gitlab.com/zugz/tcd/commit/1fd5 … f0e2f.diff
https://gitlab.com/zugz/tcd/commit/5130 … 970be.diff

mv

Member

Registered: 2017-11-19

Posts: 5

Re: Problems with setting up server

thanks! I'll try your patches

I used https://github.com/sunhater/php7-mysql/ … -mysql.php
for transition, they are the same on first glance

and then had problems with mysql utf-8 key restriction,
I use mariadb but this is hardly the cause.

I tried to decrease key size and it worked:

< include( "php7-mysql.php" );
---
> 
291c291
<             "ticket_id VARCHAR(100) NOT NULL PRIMARY KEY," .
---
>             "ticket_id VARCHAR(255) NOT NULL PRIMARY KEY," .
321c321
<             "ticket_id VARCHAR(100) NOT NULL," .
---
>             "ticket_id VARCHAR(255) NOT NULL," .

ticketServer is mostly working, but only first key is shown and other fields are empty
(select queries from database contents is ok, all fields present)

maybe it's something with so called 'magic quotes' =\

could you also clarify on php/mysql custom settings?

zed

Member

Registered: 2013-04-16

Posts: 171

Re: Problems with setting up server

Hmm sorry, don't think I had any problems with the ticketServer.
It's part of minorGems, which is actively maintained.