WoW Raid Manager: Forums / Support / Login does not work

Forums

WoW Raid Manager :: Forums :: Support

<< Previous thread | Next thread >>

Login does not work

Author

Post

Rahana

Thu Dec 03 2009, 02:35PM

Registered Member #1386
Joined: Thu Dec 03 2009, 02:27PM
Posts: 3

Hello,

just installed fresh WRM on my site. All went well and all seems to work fine, barring the thing I can't log in with the Admin account I created in instalation process. Always end up at

Login failed

You have specified an invalid username or password. Please try again.

I am not really keen on coding and all this stuff - so if you can help me in a simple way that would be best :) If there is any more informations you need, I will try to post them asap.

Thank you.

[ Edited Thu Dec 03 2009, 03:18PM ]

Istari

Thu Dec 03 2009, 04:46PM

Registered Member #1380
Joined: Wed Dec 02 2009, 07:36AM
Posts: 26

Are you sure you input your admin password the same password as you are trying to log in with?

[ Edited Thu Dec 03 2009, 04:47PM ]

Rahana

Thu Dec 03 2009, 11:48PM

Registered Member #1386
Joined: Thu Dec 03 2009, 02:27PM
Posts: 3

100% positive on that.

However I sense something went down south, because when I tried to reset my password putting in name and email of this admin account, I got pretty much nothing by now in my mailbox.

Illydth

Fri Dec 04 2009, 01:27PM

Joined: Mon Sep 24 2007, 02:51PM
Posts: 1886

Ok. This one's going to be an easy fix.

Lets start here. Are you using iUMS authentication support (i.e. built in) or are you bridging with another CMS system? You'd know from what you selected in the installation section (step 4 I think?)

I am going to assume you've used iUMS because otherwise this is handled an entirely different way.

For this to work, you're going to need access to your database. Given you had to create one, I'm going to assume accessing and updating a table won't be a challenge for you.

The table you're looking for is 'wrm_profile' in your WRM database (keep in mind the "wrm_" part is your "table prefix" you set in step 2.)

The profile table is what holds all of the login/auth information.

First things first, you'll want to go into this table and check what user/users are in the table. Assuming that your site isn't configured yet and you JUST installed it I suspect it will be *1* user.

Either way, find the user with the "priv" column set to 1, THIS is the admin user. The "username" field should show you what the user name is, make sure it matches what you think it to be.

Now, password. The "password" field is an md5 hashed value of what you typed in. You cannot "decrypt" this to figure out what your current password is, so if you feel you've entered something wrongly, or if you are using the right username and still not authenticating, it's time to update the password field.

You'll need an md5 hash generator: - Click Here - is a link to one, but there's a HOST out there on the web.

Go to the URL, type in what you want your password to be (EXACTLY as you want it to be) and "generate". The string that it shows you you want to copy EXACTLY as is into the password field for the account.

For instance:

"newpass1" (no quotes) generates the MD5 hash fcccca750f896af3625966911a276bc8 (feel free to check it).

Find your admin user, edit the row, and replace the current hash with fcccca750f896af3625966911a276bc8 and your password will now be set to "newpass1".

Try to log in again. This time it should work.*

* There are a couple of notes here. Support for Multi-byte characters has been problematic for years with this piece of software. As of the 4.0 version I THOUGHT I had this issue fixed, but there's another open thread out there noting that there are still some characters that cause problems. If your admin username (specifically) or password contains characters that are not common on a standard 101 key US English Keyboard (1 - 0, a - z, A - Z, and symbols) you MAY be running into a multi-byte issue.

The BEST thing for you to do to test this out would be to create ANOTHER user (you can do this directly through the database if you wish, you don't have to do it by registering) that does NOT contain multi-byte characters in the username/password.

If this works, you'll want to provide me with the username and password combination (BY PM DO NOT POST IT TO THIS THREAD) that doesn't work so I can test it out myself.

If you are using something other than the iUMS (Integrated User Management System) for authentication, please let me know that as well so we can talk you through changing your password on the external system.

--Illydth

- Douglas Wagner -
Site Admin

Rahana

Fri Dec 04 2009, 03:12PM

Registered Member #1386
Joined: Thu Dec 03 2009, 02:27PM
Posts: 3

Uhm, as I said, I am not really keen on all this stuff... The database I created was through web-admin and I have no clue how to enter it.

I did use iUMS indeed.

Branddy

Wed Jun 30 2010, 11:40AM

Registered Member #1752
Joined: Wed Jun 30 2010, 11:30AM
Posts: 2

Hi @ all,

I have the same problem here, and i Need Help ;-)

I'm using iUms Auth sytem and checked my password with the MD5 generator against the one in the database, it match.

I tried the "newpass1" test -> Login failed

"You have specified an invalid username or password. Please try again."

I used 4.0.4 package on a clean install.

Should I check anithyng else?

EDIT: I tried the phpbb3 Auth system -> Same bug.

If i want to register via WRM it says:

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /mnt/169/sdd/d/f/branddy/raid/auth/auth_phpbb3.php:1) in /mnt/169/sdd/d/f/branddy/raid/auth/auth_phpbb3.php on line 313

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /mnt/169/sdd/d/f/branddy/raid/auth/auth_phpbb3.php:1) in /mnt/169/sdd/d/f/branddy/raid/auth/auth_phpbb3.php on line 313

Warning: session_regenerate_id() [function.session-regenerate-id]: Cannot regenerate session id - headers already sent in /mnt/169/sdd/d/f/branddy/raid/auth/auth_phpbb3.php on line 334
You can not access this file

The 8th of July 2010, I Renamed the directory From ./raid to ./raid.old => No more warnings. But "You have specified an invalid username or password. Please try again." still remains.

here is the link for the web site

EDIT: Update URL and Error Messages.

Anyone has a Clue?

[ Edited Wed Jul 07 2010, 05:36PM ]

Illydth

Fri Jul 09 2010, 03:22PM

Joined: Mon Sep 24 2007, 02:51PM
Posts: 1886

Branddy. First, thanks for the PM / heads up on this thread. My time recently has been for [censored] and I'm not getting here as often as I should to help support you guys.

So let me get this straight: On a clean / fresh install, you've set a password for your admin user in the installation script and then checked the database. The admin user password hash in the password field matches what you are typing in exactly in the password box when you use an MD5 has generator...

That tells me the problem MUST be the username, not the password.

For what I'm going to have you do next, you'll need a system no one else is using as I'm going to be having you print usernames and passwords in plain text to the screen.

My line numbers may be borked but somewhere around line 142, after the { after line that reads:




while($data=$db_raid->sql_fetchrow($result, true))

{

But before the "if" statement that follows that, please add the following code:




echo "<br>Input Username: *" . $username . "*";

echo "<br>Check Username: *" . $strtolower($data[$db_user_name]) . "*";

This should print out the incoming username on the first line and the checked for username on the second. Please let me know if these two match "identically".

--Illydth

- Douglas Wagner -
Site Admin

Illydth

Fri Jul 09 2010, 03:22PM

Joined: Mon Sep 24 2007, 02:51PM
Posts: 1886

*sigh* Too long since i've done this. The file you're looking at is wrm/auth/auth_iums.php

- Douglas Wagner -
Site Admin

Branddy

Sat Jul 10 2010, 04:21AM

Registered Member #1752
Joined: Wed Jun 30 2010, 11:30AM
Posts: 2

First of all, Thx Illydth for your help.

I paste the two lines to check the username. It match (Input = Database)

I found where is the problem. I always have the "Wrong parameter count for strtolower() on lione 120"
and on others lnes too. ;-)

In Auth_iUMS.php in the line 120 you will have:

$username = mb_strtolower(scrub_input($_POST['username']), "UTF-8");

I don't Know why but the function strtolower need to be something like that:

$username = strtolower(scrub_input($_POST['username']));

Free.fr doesn"t use MultiByte.

I've changed all the Strtolower functions from lines 120 to 144 and the Auth system works fine now.

I going to try some others users. to check the cookies ^^

EDIT: Be careful when deleting *UTF8* code.

[ Edited Sat Jul 10 2010, 04:44AM ]

Illydth

Tue Jul 20 2010, 10:24AM

Joined: Mon Sep 24 2007, 02:51PM
Posts: 1886

Ok,

THanks for the information, obviously without multibyte support the app breaks, that's not good news.

THe fix here is to go through all the code (you can use a tool like grep or there are several windows tools) and, if you don't have multibyte support, remove the MB_ parts of all the code...so mb_strtolower becomes just "strtolower()"...then, yes, you'll need to remove the ,"UTF-8" part as well.

IN the next version (if I EVER get time to turn it out) I will be trying to wrap this with a check if the multibyte stuff is turned on. If it is, we use the MB_ stuff, if not we use the regular non mb stuff.

--Illydth

p.s THank you VERY much for diagnosing this one for me...it's been a bit of a thorn in my side.

- Douglas Wagner -
Site Admin

Moderators: Illydth

Main Menu

Welcome

Poll

Latest Forum Posts

Online

Link to us

Forums

Date / Time

Search WoW Raid Manager

Chatbox