cancel
Showing results for 
Search instead for 
Did you mean: 

Alfresco Cannot login with admin:admin

eleanor
Champ in-the-making
Champ in-the-making
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
11 REPLIES 11

eswbitto
Confirmed Champ
Confirmed Champ
Did you define your admin password on the install?

eleanor
Champ in-the-making
Champ in-the-making
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
Star Collaborator
Star Collaborator
Try hitting this webscript - http://localhost:8080/alfresco/service/api/login?u=admin&pw=admin and see what it returns?

eleanor
Champ in-the-making
Champ in-the-making
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
Star Collaborator
Star Collaborator
Interesting. Can you try login/hit above webscript once with the password that you entered for db user while installation?

eleanor
Champ in-the-making
Champ in-the-making
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
Star Collaborator
Star Collaborator
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
Champ in-the-making
Champ in-the-making
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
Star Collaborator
Star Collaborator
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.