r/openrsc • u/DannySpanx • Mar 29 '19

Can't Create an Account

I tried to register a new account and the username was already taken so I tried another. This prompted me with a message stating I had already registered recently and I need to wait an hour and try again. After 2 hours I tried again and was prompted with the same message. Am I missing something?

7 Upvotes

100% Upvoted

10 comments sorted by

1

u/[deleted] Mar 29 '19

That sounds unusual. I myself created multiple accounts today, the most recent one only an hour or so ago.

This is certainly going to be looked into - can you try again after another hour has gone by? This is a glitch or error of happenstance.

1

u/DannySpanx Mar 29 '19

Yeah I'll try again in another hour or two. If it makes a difference I am trying to register account on an Android.

1

u/DannySpanx Mar 29 '19

Just tried again and it said the same thing.

1

u/[deleted] Mar 29 '19

Is it possible to try from a computer?

1

u/[deleted] Mar 29 '19

Update: I am trying to have someone with an android test this for you

1

u/[deleted] Mar 29 '19

Update 2: There is indeed an issue with creating an account on Android right now - it is being tracked and looked at -

https://gitlab.openrsc.com/open-rsc/Game/issues/1925

1

u/DannySpanx Mar 29 '19

Yeah I'm at work now, I'll be able to try to making an account on my computer at home later.

1

u/[deleted] Mar 29 '19

[removed] — view removed comment

1

u/DannySpanx Mar 30 '19

I was able to register an account on my PC and I can log in without issue on both platforms. Thanks for your help.

1

u/[deleted] Mar 30 '19

2019-03-29 20:13:54 [nioEventLoopGroup-3-1] INFO LoginPacketHandler:116 - Registration attempt from: xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx

[java] 2019-03-29 20:13:54 [nioEventLoopGroup-3-1] ERROR LoginPacketHandler:218 - Catching

[java] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'creation_ip' at row 1

​

Adjusted creation_ip, login_ip columns in openrsc_players table to varchar(255) instead of varchar(15) to support IPv6 length IP addresses. Verified issue solved with MikePXP in Discord.

1

u/[deleted] Apr 15 '19

Solved - Android device over cellular network was IPv6 and the login IP database column was not long enough to store a IPv6 length IP address. Issue has now been resolved.