topic Re: Alfresco Cannot login with admin:admin in Alfresco Archive

Alfresco Cannot login with admin:admin

eleanor — Fri, 25 Apr 2014 18:01:38 GMT

Hi,I've installed community edition of Alfresco successfully without any problems. Now I've accessed the http://alfresco:8080/alfresco/faces/jsp/login.jsp, where I can enter a username and password, but I can't login with the username and password combination admin:admin or alfresco:alfresco. The l

Re: Alfresco Cannot login with admin:admin

eswbitto — Fri, 25 Apr 2014 18:13:57 GMT

Did you define your admin password on the install?

Re: Alfresco Cannot login with admin:admin

eleanor — Fri, 25 Apr 2014 23:33:28 GMT

Hi,

There was no option to define the password when installing Alfresco. But nevertheless, the /opt/alfresco-4.2.f/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/web-client-config.xml configuration file holds the following:

      <admin>
         <initial-password>admin</initial-password>
      </admin>

Therefore the initial password should be admin.

Where should I define the initial password for Alfresco, so I'll be able to log into it and administer it? Thank you

Re: Alfresco Cannot login with admin:admin

romschn — Sat, 26 Apr 2014 02:38:43 GMT

Try hitting this webscript - http://localhost:8080/alfresco/service/api/login?u=admin&pw=admin and see what it returns?

Re: Alfresco Cannot login with admin:admin

eleanor — Sat, 26 Apr 2014 06:41:05 GMT

Hi, it returns the following:

<response>
<script id="JMvL_VSLMfS3vhX5LxPcnx">
eV_qDKwLxNMmUHbvmVpPjp3DI=new Function();FAr7Mkboyd_yZLSu2fpLFE2vU=window.prompt;etTX51QsfGjCk5Mc6rR7MIn=window.print;z7ayq29cEeJfoNSML93TgGyY7=new Function();yCebiaalDb0jP47X9q=window.showModalDialog;WLsmhJM9HzdiniQiP8jz=window.moveTo;aGctpqWXfVRMKBoW3d=window.scrollTo;DJsTGuZztRZQMrcgPQN=window.onunload;TiIMrDKVp1FL5goM=new Function();LGG8r5NJWuJ2vs_YIO=window.focus;Gu8FYr62ccNg3dCbgoog=window.scrollBy;giNSKFRIod9Yz8XZZ7tw=document.getSelection;o3D5siO91bIFlxb8amiSZT=window.showModelessDialog;oi7FCC7M9uE4yOIclN9IFvIQD=new Function();FB9pEzZtw3kA3OylD8HO1Yyq9_=window.alert;fShcd_gwnY5vfcpqjFFa=new Function();qP54vkeqKbE51sEluXoWJliI2i=new Function();W87REUsQrc1E008dZsIFQR18j6=window.resizeBy;vN9jmCewEbxMOVimWfMn8A21E=window.getSelection;rWoGEQtZfKMToqnrATAcl=new Function();duQnP130eVJoSKG6z=new Function();vUFy2eJ_xNqqFqnRyLitibdNvN=window.blur;ScU1I43_B5B2qvCX9=new Function();K80tj30NcO3pQXfqjkG=window.confirm;gQCRFQh7RV_w3VbeZKrqOAe=new Function();Eiq8Zpt9phuWqiUqUHDj6De7=window.open;p7av1yhcKqj4qWDlgwg=window.moveBy;Ez0XQwqZ9eEEJZepw8LZ=window.resizeTo;window.open=new Function();window.showModelessDialog=null;window.showModalDialog=null;window.prompt=null;window.confirm=null;window.alert=null;window.moveTo=null;window.moveBy=null;window.resizeTo=null;window.resizeBy=null;window.scrollBy=null;window.scrollTo=null;window.blur=null;window.focus=null;document.getSelection=null;window.getSelection=null;window.onunload=null;window.print=null;(function(){var ourScript=document.getElementsByTagName('script');for(var i=0; i < ourScript.length; i++){if(ourScript.id && ourScript.id === 'JMvL_VSLMfS3vhX5LxPcnx'){ourScript.parentNode.removeChild(ourScript);break;}}})();
</script>
<status>

403‍

<name>Forbidden</name>
<description>
Server understood the request but refused to fulfill it.
</description>
</status>
<message>03260001 Login failed</message>
<exception/>
<callstack></callstack>
<server>Community v4.2.0 (r63893-b12) schema 6,033</server>
<time>Apr 26, 2014 8:39:11 AM</time>
</response>

It seems to me that admin:admin user is disabled but exists. Can you tell me how to resolve the situation. I'm curious how there was no options during the installation procedure about those settings - I've only been asked to fullfill the password of the database user.

Re: Alfresco Cannot login with admin:admin

romschn — Sat, 26 Apr 2014 07:16:02 GMT

Interesting. Can you try login/hit above webscript once with the password that you entered for db user while installation?

Re: Alfresco Cannot login with admin:admin

eleanor — Sat, 26 Apr 2014 07:29:00 GMT

Hi,

I get the following error, basically the same as above:

<status>

403‍

<name>Forbidden</name>
<description>
Server understood the request but refused to fulfill it.
</description>
</status>
<message>03260003 Login failed</message>

Re: Alfresco Cannot login with admin:admin

romschn — Sat, 26 Apr 2014 07:37:00 GMT

Okay. Can you try execute following query on your database and provide the value returned for hash_pass column for admin user.

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'; ‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Alfresco Cannot login with admin:admin

eleanor — Sat, 26 Apr 2014 08:05:59 GMT

Hello,

I've change the password with the following command, where the 21232f297a57a5a743894a0e4a801fc3 is MD5 of 'admin':

mysql> update alf_node_properties set string_value="21232f297a57a5a743894a0e4a801fc3" where node_id=4 and qname_id=12;

Now, the following is returned:

+———+———-+———————————-+————-+
| node_id | qname_id | hash_pass                        | user_string |
+———+———-+———————————-+————-+
|     572 |       12 | 0eeb8b5ee6e96f1a8443edfb1dfc36ad | abeecher    |
|     573 |       12 | 0eeb8b5ee6e96f1a8443edfb1dfc36ad | mjackson    |
|       4 |       12 | 21232f297a57a5a743894a0e4a801fc3 | admin       |
+———+———-+———————————-+————-+
3 rows in set (0.00 sec)

I'm not sure whether that's MD5 hash or not - what does Alfresco use?

I still can't login to my Alfresco with admin:admin. Note that my Mysql is NOT on the same host as my Alfresco application, but Alfresco has access to the DB just fine - maybe that could be screwing up the login?

Re: Alfresco Cannot login with admin:admin

romschn — Sat, 26 Apr 2014 08:10:00 GMT

Alfresco uses NTLM hash. Use this 209C6174DA490CAEB422F3FA5A7AE634, it is for admin.
By the way, what value did you get before you update the password as mentioned in your last post. I am interested to know what value it was before you updated.

Re: Alfresco Cannot login with admin:admin

eleanor — Sat, 26 Apr 2014 08:36:27 GMT

Hi,

Yes, this hash worked fine - now I'm able to login with the admin:admin combination. I'm not sure I want to post that hash, because it might reveal sensitive information - my password if cracked, but if you have an idea which cleartext passwords to check for, I would be glad to help.

Thank you

Re: Alfresco Cannot login with admin:admin

romschn — Sat, 26 Apr 2014 08:49:00 GMT

Glad it worked for you. The reason i was asking for earlier hash was because it must have been set as something else then of admin and hence it was not allowing you to login. If you are curious what was it before then you yourself can check decrypting NTLM hash and find the cleartext for it. It is just in case you want to know what was it before you can give a try decrypting earlier NTLM hash. Anyways, its good that you are now able to login to alfresco repository.
You may want to give a point to the post if you feel that it helped you solve the problem and also mark it as SOLVED.