Problems Logging In

[saturdayplace]

I just installed the server software on a test server. Easy
install. Now I tried to login with username: admin, a blank
password, and I get the "Unable to authenticate with the username/
password combination" message. Using a blank password, because the
'admin' username in the database has a blank password. So I tried to
change the password in the database using SQL:

UPDATE user SET password=PASSWORD('mypassword') WHERE
username='admin';

And logging in with that didn't work either. So I tried to change the
password in the database like so:

UPDATE user SET password='mypassword' WHERE username='admin';

Still no dice.

So I tried to create a user using SQL

INSERT INTO user VALUES(1, 'myusername', 'mypassword', 'My Name',
'myad...@mydomain.com', 1, 0);

Still no dice, so I update the password:

UPDATE user SET password = PASSWORD('maestro') WHERE username =
'myusername';

Nothing.

So I try to create a new user through the 'sign-up' link on the
homepage, but got this error message: "Your profile submission failed.
Please check all fields and try again."

As far as I can tell, all my database settings in config.inc.php are
right. I'm stuck. Any help?

[olif]

When I installed Concerto, I had same problem. I guess it was saved by
hashing type password.

My solution is (May be it's not right way, but it works), make one
account ID 'test' and password 'test' in Web.

And, select query in MySql about 'test', then you can see hashed
password for 'test'.

Copy the hashed password, and update that as a password about 'admin'.

Now, your admin account's password is 'test'.

Have a nice day ~~

On 11월25일, 오전4시26분, saturdayplace <saturdaypl...@gmail.com> wrote:
> I just installed the server software on a test server. Easy
> install. Now I tried to login with username: admin, a blank
> password, and I get the "Unable to authenticate with the username/
> password combination" message. Using a blank password, because the
> 'admin' username in the database has a blank password. So I tried to
> change the password in the database using SQL:
>
> UPDATE user SET password=PASSWORD('mypassword') WHERE
> username='admin';
>
> And logging in with that didn't work either. So I tried to change the
> password in the database like so:
>
> UPDATE user SET password='mypassword' WHERE username='admin';
>
> Still no dice.
>
> So I tried to create a user using SQL
>
> INSERT INTO user VALUES(1, 'myusername', 'mypassword', 'My Name',

> 'myaddr...@mydomain.com', 1, 0);

[Andrew Elwell]

> I just installed the server software on a test server.   Easy
> install.  Now I  tried to login with username: admin, a blank
> password, and I get the "Unable to authenticate with the username/
> password combination" message.  Using a blank password, because the
> 'admin' username in the database has a blank password.  So I tried to
> change the password in the database using SQL:

Yep - I got bitten by this one too
the PHP scripts (common/user.php) do a simple $password = md5($password);

Magic trick is therefore to generate the has of your desired pass:

$> php -r 'print md5("ubersecretpass");'
0685b7b24eccf2368fcce5202ff5f194

then update the DB with it

mysql> update user set password="0685b7b24eccf2368fcce5202ff5f194" where id = 0;


course, its a bit crap really as there's no salting of passwords


Andrew

[saturdayplace]

Thanks a million. I'm on my way now.