Alfresco Cannot login with admin:admin

[eleanor]

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 login dialog says: "Unable to login - unknown username/password."

Did default username and password change in the latest version of Alfresco. I'm using the following versions:
- Alfresco: 4.2.f
- Tomcat: 7
- System: Debian 7

Thank you

[eswbitto]

Did you define your admin password on the install?

[eleanor]

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

[romschn]

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

[eleanor]

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.

[romschn]

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

[eleanor]

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>

[romschn]

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

[eleanor]

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?

[romschn]

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.