auth decideded to have a spazz?

[SpiritHawk]

something strange happen i have 4 different registration scripts all 4 creates account however but can't login game with none of them however it seems the only registration script i can use to create account and be able to login game with comes from bola's release admin/player panel why is that ?

GQueryPasswd:account is test , login ip is -533319868
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
Received acquired password
java.lang.StringIndexOutOfBoundsException: String index out of range: 4
	at java.lang.String.substring(String.java:1946)
	at com.goldhuman.account.storage.StringPassword(storage.java:399)
	at com.goldhuman.account.storage.acquireIdPasswd(storage.java:425)
	at protocol.MatrixPasswd.Server(Unknown Source)
	at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
	at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
	at com.goldhuman.Common.ThreadPool.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:679)
acquireIdPasswd exception:account=test
gauthd: 23 Apr 2013 09:54:05,177  INFO GAuthServer:? - GQueryPasswd:can not find user test

this is example of one of the scripts when i try to login after creating account

[MentaL]

[argonaut]

It's the authd and the way it reads the encryption/encoding.
For my own server v63 i used a different authd, so when upgrading my server to v69 i will use that same authd.
Different scripts encode information differently to the database, different authd read the different encodings of the database that are encoded by the different scripts.

[SpiritHawk]

which one was v63 there so many here ?

[argonaut]

In all honesty, i had a similar problem with registrations; I could not get the player panel to work for me (gave me some grey hairs), other scripts gave me grief as well (more grey hairs).
It wasn't until i had direct help from tbnanubis that i sort of understood the actual problem.
In reading on certain peoples posts i began also to understand more clearly that this whole problem was the way information was interpreted and stored by the database that was the core of the problem.
I haven't tried other authd to test the effectiveness of the procedures.sql but i'm guessing (like i'm trying to say) that it is not so much in the authd but in the database setup.

This post here has a procedures.sql that is the key to making database work correctly.
Load that up into your PW database.
See here the clue tbnanubis gives.
Rusran gives the different authd (if you really want to try them), but as you can see they become unnecessary.

[SpiritHawk]

i tried that getting error due to procedures preceding this #1304 - PROCEDURE acquireuserpasswd already exists
so how do i go about modify existing procedures?

[argonaut]

try to DROP the procedure first, in saying this i didn't have this problem and this area is by far my weakest point.

[SpiritHawk]

okay strip db down added the procedures removed other one however still in same boot using the advance registration scripts

authd:: add PollIO task.
GAuthServer::OnAddSession com.goldhuman.IO.Protocol.Session@169ca65
gauthd: 25 Apr 2013 17:58:54,098  INFO GAuthServer:66 - <<< clear all online records on zone 1 >>>
Prepare procedure call:{call clearonlinerecords(?,?)}
gauthd: 25 Apr 2013 17:58:54,136  INFO GAuthServer:77 - zone 1  aid 1 announced.
GQueryPasswd:account is spirithawk , login ip is -533319868
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
Received acquired password
java.lang.StringIndexOutOfBoundsException: String index out of range: 12
	at java.lang.String.substring(String.java:1946)
	at com.goldhuman.account.storage.StringPassword(storage.java:399)
	at com.goldhuman.account.storage.acquireIdPasswd(storage.java:425)
	at protocol.MatrixPasswd.Server(Unknown Source)
	at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
	at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
	at com.goldhuman.Common.ThreadPool.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:679)
acquireIdPasswd exception:account=spirithawk
gauthd: 25 Apr 2013 18:01:34,166  INFO GAuthServer:? - GQueryPasswd:can not find user spirithawk

[argonaut]

Did you reboot and re-register a new account?

[SpiritHawk]

yeap now the panel i was creating accounts with is not accepting passwords lol

[argonaut]

Well your original question is why only the player panel works and nothing else, have you tried installing this registration, i do not use the player panel to register accounts,i use renan7899 registration, but for Bola Panel registration i do believe this all works.
Whether Bola uses this procedures.sql i do not know.
I know that with the renan registration and procedures.sql it fixed my problem with player panel login..i did modify player panel considerably but ended up making my own website complete with password change, voting, registration and a nice gallery running from backend of server.
The problem i had with player panel was that some people could log in and some could not.
It came down to my database encryptions looked like ?T?t?Va”iDN&? , and without having to change my mcncc authd and by loading the procedures the change was to 0xd56272d92f9a782c7e6f53a7584d6de6.
This enabled me to use the player panel and dealt with the bug i was having.

[SpiritHawk]

thats the one i been trying to use everytime i use to create account try login i get the error code at top

[argonaut]

I would check first to see if the actual account creation shows in pw/users of the database -just to make sure things are functional.
Assuming they are, i'm mostly out of ideas...i would try using a different authd...if that yields the same problematic results then i really don't know.
My setup uses the procedures.sql, renan rego script and i can use the player panel login with no more errors.
I've also incorporated the password changer into my website (taken from the player panel).

[SpiritHawk]

okay did you change out your auth at all ? or you still using v69?

[argonaut]

Im using the Base64 authd from mcncc v63 files from eons ago, however i believe all 3 are available here...this also has the base64.
The Base 64 is in these 3 types linked.

Did you tried to login?

Well, that kind of "alien" password is the byte form of the md5 hash... read about md5's raw output: PHP: md5 - Manual

Open your table.xml and change all passwd and passwd2 inside to varchar(64). Use CTRL + W to search in nano.

After that, check your mysql tables and change to varchar 64 the passwd and passwd2 if it isn't...

Then you can use these procedures: procedures.sql

That sort of says it for me..so i guess i too have learned the reason the registration works is from the authd being a base 64 version, the 2 go together.
I bet when you use this base 64 authd , everything will work fine

[SpiritHawk]

okay i did as you suggested how ever unable to keep things connected to authd

Protocol Decode Error:type=9,size=-14687226
gauthd: 25 Apr 2013 22:25:04,831  INFO GAuthServer:? - GAuthServer::OnDelSession com.goldhuman.IO.Protocol.Session@14a8cd1

2013-04-25 22:26:25 perfectworld gdeliveryd: err : gdelivery::disconnect from GAuth server. Reconnecting...

amed(1):: OnAddSession 660
gamed(1):: OnAddSession 663
gamed(1):: OnDelSession 664
gamed(1):: OnDelSession 663
gamed(1):: OnDelSession 660
gamed(1):: OnDelSession 666

i think it worked but soon as you login you get server network error nothing wants to stay connected to authd_base64 (and yes i renamed the file to authd)

password is in database but looks like this

pTz^†yvî
çïbx#¬Ñ

[argonaut]

This is my modified my_authd, do not change its name from my_authd.
You will have to change your username and password in etc/table.xml and build/table.xml
However I suspect your authd.file may be wrong?

#!/bin/sh
cd /PWServer/my_authd/build

while true; do

java -cp ../lib/mysql-connector-java-5.0.8-bin.jar:../lib/jio.jar:../lib/application.jar:../lib/commons-collections-3.1.jar:../lib/commons-dbcp-1.2.1.jar:../lib/commons-pool-1.2.jar:../lib/commons-logging-1.0.4.jar:../lib/log4j-1.2.9.jar:.:$CLASSPATH authd /etc/table.xml
sleep 2

done

Line 2 denotes the path
cd /PWServer/my_authd/build
you could change /my_authd to authd, as you have named the folder, if you wish to not use mine.

[SpiritHawk]

dude you are the best man that worked like a charm thank you able to create accounts using that sql and with the my_authd