topic Re: Unable to login to Alfresco using "admin" (/alfresco/service/api/login?u=admin&pw=admin) in Alfresco Forum

Unable to login to Alfresco using "admin" (/alfresco/service/api/login?u=admin&pw=admin)

plean — Wed, 26 Jul 2017 09:31:25 GMT

Hello, In a previous post, I was dealing with many problems on my Alfresco-installation. Now most things are working, but I still cannot log in. When I try to login to Alfresco on /share I get the following in my access_log (I have activated most debugging-options on /share):127.0.0.1 - CN=Alfresco

Re: Unable to login to Alfresco using "admin" (/alfresco/service/api/login?u=admin&pw=admin)

cesarista — Wed, 26 Jul 2017 11:34:59 GMT

Hi:

I use this command for generating MD4 passwords in Alfresco, for example for user admin and passwd admin too:

$ printf '%s' "admin" | iconv -t utf16le | openssl md4
(stdin)= 209c6174da490caeb422f3fa5a7ae634

Hope it helps.

--C.

Re: Unable to login to Alfresco using "admin" (/alfresco/service/api/login?u=admin&pw=admin)

plean — Wed, 26 Jul 2017 12:09:21 GMT

Thanks, this gives me:

# printf '%s' "admin" | iconv -t utf16le | openssl md4
(stdin)= 209c6174da490caeb422f3fa5a7ae634

But I can still not login to Alfresco...

Re: Unable to login to Alfresco using "admin" (/alfresco/service/api/login?u=admin&pw=admin)

plean — Thu, 27 Jul 2017 07:27:21 GMT

Well using the correct database makes things easier.

As I did create a database "alfresco2", I did still change password in "alfresco", so wrong DB. The working hash for "admin" is "209c6174da490caeb422f3fa5a7ae634". Thanks to ‌ for his advice!

After following the following procedure it did work:

mysql> SELECT anp1.node_id,        anp1.qname_id,        anp1.string_value as hash_pass,        anp2.string_value as user_string FROM alf_node_properties anp1         INNER JOIN alf_qname aq1            ON aq1.id       = anp1.qname_id         INNER JOIN alf_node_properties anp2             ON anp2.node_id = anp1.node_id         INNER JOIN alf_qname aq2                        ON aq2.id       = anp2.qname_id WHERE aq1.local_name    = 'password' AND aq2.local_name    = 'username';
+---------+----------+----------------------------------+-------------+
| node_id | qname_id | hash_pass                        | user_string |
+---------+----------+----------------------------------+-------------+
|       4 |       11 | .................................| admin       |
|     569 |       11 | 0eeb8b5ee6e96f1a8443edfb1dfc36ad | abeecher    |
|     570 |       11 | 0eeb8b5ee6e96f1a8443edfb1dfc36ad | mjackson    |
+---------+----------+----------------------------------+-------------+
3 rows in set (0.00 sec)

mysql> UPDATE alf_node_properties SET string_value='209c6174da490caeb422f3fa5a7ae634' where node_id=4 and qname_id=11;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0