• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Windows Problem with passwords. Znote 3.0, tfs 0.3.6

niti

niti

New Member
Joined
Nov 22, 2009
Messages
258
Reaction score
2
Hello again.
I just bumped in to a new problem. When I create an account in the Website I get a random password. I create an account and password but suddenly when I check the database I see the password has been changed to something like this: 7c4a8d09ca3762af61e59520943dc26494f8957c.
Help me and I rep++ you.
 
Sort by date Sort by votes
Passwords are encrypted using sha1, you must set up your server (config.lua) to also use sha1 for passwords. You will not be able to read the password in the database, but it's not random, just encrypted.
 
Upvote 0 Downvote
forgee said:
Passwords are encrypted using sha1, you must set up your server (config.lua) to also use sha1 for passwords. You will not be able to read the password in the database, but it's not random, just encrypted.
Click to expand...
Where do I change? In which line? Be more specefik. I'm not very good at this since I never had a problem like that before.
 
Upvote 0 Downvote
The passwords are supposed to look like that. If you have set encryptionType = "sha1" in config.lua you should be able to log in with the password you made (not the one you see in the database but the one you entered when you made the account).
 
Upvote 0 Downvote
forgee said:
The passwords are supposed to look like that. If you have set encryptionType = "sha1" in config.lua you should be able to log in with the password you made (not the one you see in the database but the one you entered when you made the account).
Click to expand...
It says, username and password combination is wrong.
 
Upvote 0 Downvote
forgee said:
The passwords are supposed to look like that. If you have set encryptionType = "sha1" in config.lua you should be able to log in with the password you made (not the one you see in the database but the one you entered when you made the account).
Click to expand...
Well now I can log in. But I cannot log in to the site with the old accounts. Is that normal?
 
Upvote 0 Downvote
Yes, if the old accounts have "plain" passwords they will be unable to log in to the website. You can try to go to your site and enter /special/database2znoteaac.php to convert the old accounts.
 
Upvote 0 Downvote
What is that mean?
Code: 
string(56) "SELECT `password` FROM `accounts` WHERE `id` = LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1

thats what happends when try to go link http://127.0.0.1/special/database2znoteaac.php
 
Upvote 0 Downvote
Back
Top