topic Re: Unable to login in Alfresco Archive

Unable to login

dserodio — Thu, 02 Mar 2006 14:57:58 GMT

I downloaded Alfresco's WAR, ran db_sqtup.sql against our MySQL server (same host as Tomcat), and deployed the WAR via Tomcat Manager, but I'm unable to login.I tried admin/admin, but I get a Unable to login - unknown username/password error.The only authentication-related message in alfresco.log is

Re: Unable to login

greg — Tue, 07 Mar 2006 00:13:29 GMT

I also have tried the default admin/admin in the web client and receive the error:

19:41:20,406 WARN [app.servlet.AuthenticationHelper] Unable to login as Guest: Access Denied. You do not have the appropriate permissions to perform this operation.

in the catalina.out. The install is completely fresh, Ubuntu/Debian with Alfresco 1.2/Tomcat. I had a 1.12 Alfresco install with exactly the same platform and setup which worked fine. Since I did not have anything worth keeping I refrormatted and installed fresh but now have the inability to login.

Re: Unable to login

derek — Tue, 07 Mar 2006 09:13:07 GMT

Hi, (also answering http://www.alfresco.org/forums/viewtopic.php?p=4448#4448)

Apart from the database being cleaned out, were there any existing indexes or content stores lurking around?
Did you point the dir.root location to a fixed location?

The system expects the database and indexes to by synchronized. If one or the other is out of synch, then these types of symptoms tend to appear.

Regards

Re: Unable to login

dserodio — Tue, 07 Mar 2006 13:09:02 GMT

Following your suggestion, I removed all alf_data directories on my server, dropped and re-created Alfresco's DB. Now I can login as guest.

But, following http://www.alfresco.org/mediawiki/index.php/Repository_Configuration, I had created a TOMCAT_HOME/shared/classes/alfresco/extension/custom-services-context.xml file, containing:

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>

<beans>

    <!– import further configurations –>
    <import resource="file:/etc/alfresco/more-config.xml" />

</beans>‍‍‍‍‍‍‍‍‍

Then, I created a /etc/alfresco/more-config.xml exactly like the one in the document above linked.

I created a TOMCAT_HOME/shared/classes/alfresco/alfresco/repository.properties, with dir.root=/var/lib/alfresco, but Alfresco created an alf_data directory under TOMCAT_HOME/logs/!!!

What is wrong with this setup? Thanks!

Re: Unable to login

dserodio — Tue, 07 Mar 2006 13:23:59 GMT

Damn! I spoke too soon… I was able to login as guest, but as soon as I tried to login as admin I got the ClassNotFoundException: cryptix.jce.provider.md.MD4 problem mentioned here: http://www.alfresco.org/forums/viewtopic.php?t=1159

After restarting Tomcat, I can no longer login as neither admin nor guest.

Re: Unable to login

derek — Tue, 07 Mar 2006 13:31:01 GMT

The configuration itself looks fine. In fact, Spring would complain if any of the files could not be found, with the exception of the custom-services-context.xml. Check the permissions on that file and could you confirm that the application classloader is NOT seeing that file by modifying the TOMCAT_HOME/webapps/alfresco/WEB-INF/classes/alfresco/application-context.xml as follows:

Change

<import resource="classpath*:alfresco/extension/*-context.xml" />‍

<import resource="classpath:alfresco/extension/custom-services-context.xml" />‍

This is just a test to see where the classloader is going wrong. If Spring doesn't complain about the file being missing when you start the server, then change the custom-services-context.xml to be invalid XML. If that doesn't fail, change to

<import resource="file:(yourpath)/alfresco/extension/custom-services-context.xml" />‍

You might also do a search for a similarly named file elsewhere on the classpath. Spring will not load the same named file twice.

Regards

Re: Unable to login

derek — Tue, 07 Mar 2006 13:41:57 GMT

You can't login because the indexes are not where they should be. It is down to the configuration, I am afraid. Try to get the Spring failures as described above, and we can go on from there.

Re: Unable to login

dserodio — Wed, 08 Mar 2006 12:52:26 GMT

Thank you for your time.

I tried your first suggestion and nothing changed. So I changed custom-services-context.xml to be invalid XML, and Spring complained:

org.springframework.beans.factory.BeanDefinitionStoreException: Line 10 in XML document from class path resource [alfresco/extension/custom-services-context.xml] is invalid; nested exception is org.xml.sax.SAXParseException: XML document structures must start and end within the
 same entity.‍‍

Tomcat is running as root, so I don't think it's a permission problem.
Where do we go from here?

Re: Unable to login

derek — Wed, 08 Mar 2006 13:23:09 GMT

Hi,

OK. That is at good news. The server is picking the files up. Could you post the other files, please.

Regards

Re: Unable to login

dserodio — Wed, 08 Mar 2006 17:31:49 GMT

As I opened my /etc/alfresco/more-config.xml to paste it here I noticed it contained:

…

    <!– overriding to point to custom properties –>
    <bean id="repository-properties" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="ignoreUnresolvablePlaceholders">
            <value>true</value>
        </property>
        <property name="locations">
            <list>
                <value>classpath:alfresco/repository.properties</value>
                <value>classpath:alfresco/version.properties</value>
                <value>classpath:alfresco/domain/transaction.properties</value>
                <!– override core properties –>
                <!–
                <value>file:/etc/alfresco/live.repository.properties</value>
                –>
            </list>
        </property>
    </bean>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

but my configuration lives in /etc/alfresco/live.repository.properties. The reference to this file was commented out!!! (/me hides in shame ) ops:
Thank you very much for your help, and I hope others will benefit from this thread.

Re: Unable to login

derek — Wed, 08 Mar 2006 19:58:08 GMT

It happens - and raises the point that perhaps we should provide some .xml.sample files for this config.
I hope you have a good experience with the product.

Re: Unable to login

dserodio — Thu, 09 Mar 2006 21:49:38 GMT

A sample XML file for this config would be nice. However, I'd like to suggest keeping only configuration files under /etc (or /usr/local/etc), and data files under /srv. From the Filesystem Hierarchy Standard:

The /etc hierarchy contains configuration files. A "configuration file" is a local file used to control the operation of a program; it must be static and cannot be an executable binary.
…
/srv contains site-specific data which is served by this system.

Re: Unable to login

derek — Thu, 16 Mar 2006 15:38:02 GMT

The WIKI has been changed.
http://wiki.alfresco.com/wiki/Repository_Configuration#Configuration_Changes