Windows Strange error

[pepe1]

Ok when i try to open my server it keeps giving me this error:

The website works perfectly and creates characters to database but the server looks like isnt working with the database or something....

Help please REP+++!

 

[Siramix]

Did you double check your config.lua? I'm not familiar with this error, but it sounds that you lost connection to the databases or something.

 

[chojrak]

It means server can't get remote file @ otland server, because (I guess) there's no that file anymore, it doesn't affect your server nor database. You can drop it in otserv.cpp .

 

[pepe1]

It means server can't get remote file @ otland server, because (I guess) there's no that file anymore, it doesn't affect your server nor database. You can drop it in otserv.cpp .

Can you explain me how to do this? because even when i turn on the server in the webpage it says the server is Offline

 

[chojrak]

Can you explain me how to do this? because even when i turn on the server in the webpage it says the server is Offline

It's not related to that error, you probably did something wrong with website. Write what AAC do you use so it will be easier to help you.

 

[cirtaboy]

Ignore, though it was a different error.

 

[chojrak]

You must change

encryptionType = "plain"

to

encryptionType = "sha1"

You're completely wrong. PLAIN password are still supported, it just displays info about that + you have wait 30 seconds.
Also, as we can notice on screen, there's "USING SHA1 ENCRYPTION.", so yes - he's using sha1.

 

[pepe1]

Im not using plain, my lua code says Sha1, im using gesior AAC.

 

[chojrak]

Okay, first of all find line starting with $sock = @fsockopen in config-and-functions.php and replace first parameter with your IP (there's probably 127.0.0.1 but as I remember it doesn't work with failovers and such, Maybe it's the reason) then wait for about 5 minutes untill status will refresh. If it will still not work, tell me if you are using Linux or Windows.

 

[pepe1]

Okay, first of all find line starting with $sock = @fsockopen in config-and-functions.php and replace first parameter with your IP (there's probably 127.0.0.1 but as I remember it doesn't work with failovers and such, Maybe it's the reason) then wait for about 5 minutes untill status will refresh. If it will still not work, tell me if you are using Linux or Windows.

Ok, this isnt working im using windows XP SP3

 

[chojrak]

Did you wait exactly 5 minutes? It's kind of delay between each status checks in Gesior AAC.

 

[pepe1]

Yes, ive been waiting i wrote my public ip there but still isnt working...

 

[chojrak]

Really don't know what to say. Maybe you have too high status timeout in your config.lua? Maybe there's other status port in config-and-functions.php and config.lua. They're my 2 last thought :|.

 

[pepe1]

I dont know why but i think gesior do not support sha1, maybe?

 

[Samme]

server looks like isnt working with the database or something....

It's working with database as you can see while running database manager [no tables were optimized] what mean that your tables in the database are OK, and they don't need to optimize.

Can you login, on created character?
What error tibia client give?

About that error with parsing remote file - while otland was moving to the new server it may be deleted.

 

[chojrak]

It's working with database as you can see while running database manager [no tables were optimized] what mean that your tables in the database are OK, and they don't need to optimize.

Can you login, on created character?
What error tibia client give?

About that error with parsing remote file - while otland was moving to the new server it may be deleted.

Kinda too late .

 

[pepe1]

Ok i cant log in with any character, keeps saying Invalid password. Maybe because otland moved the file was deleted so how i can fix this? also the webpage keeps saying server offline when i turn it on...

 

[chojrak]

Ok i cant log in with any character, keeps saying Invalid password. Maybe because otland moved the file was deleted so how i can fix this? also the webpage keeps saying server offline when i turn it on...

Nop, again, it's not related to that file.

Go to your database (I guess you are using phpMyAdmin) and check if in account table passwords look like hashes or they're just plain ones. If plain, use this query:

UPDATE `accounts` SET `password` = SHA1(`password`);

 

[pepe1]

Ok they were plain ones, i used the Code and they look like hashes now, the problem is still there but ill try to log in now..
Update:
Okay! I can log in now, but this leads to a new problem, why the passwords generated to DB were in plain text and not sha1? how i can make it so every time someone makes a new acc the password will be set in sha1?
Btw thx chojrak REP++ for you

 

[chojrak]

Go to config-and-functions.php, there's function password_ency~, which doesn't work as it should, replace it with:

function password_ency($password) {
	return sha1($password);
}