AnsweredAssumed Answered

3.3 CE installed - but can't log in using 'admin'/'admin'

Question asked by scottalexander on May 5, 2010
Latest reply on May 5, 2010 by scottalexander
Hi -

SUMMARY

I have installed Alfresco 3.3 Community Edition on Linux Debian Lenny (5.0) - but I cannot log in via a web browser at http://myserver.com:8080/share using username 'admin' and password 'admin'.

It appears that MySQL, OpenOffice, ImageMagick and SWFTools have all been installed correctly and that the file /opt/Alfresco/tomcat/shared/classes/alfresco-global.properties has been modified correctly.

Am I using the wrong username & password - or is something wrong with my configuration?

Further details are shown below - including output for the following three commands:

sudo cat /opt/Alfresco/tomcat/shared/classes/alfresco-global.properties
sudo cat /opt/Alfresco/alfresco.log
sudo netstat -aln

The above three output listings (shown at the end of this post) seem to indicate that Tomcat appears to be running on port 8080 and is able to reach MySQL running on port 3306.

However, I am unable to login at http://myserver.com:8080/share with username 'admin' and password 'admin'.

Thanks for any help.

+++ +++ +++

DETAILS

I have installed Alfresco Community Edition 3.3 on Debian Lenny (5.0), using the Alfresco distribution bundled with Tomcat, downloaded from here:

http://dev.alfresco.com/downloads/nightly/dist/Alfresco-Community-3.3G-Linux-x86-Install

To perform the installation, I first did a 'cd' to the directory where the above file was downloaded. Then I did 'chmod 777', and executed the above file, as follows:

sudo chmod 777 Alfresco-Community-3.3G-Linux-x86-Install
sudo ./Alfresco-Community-3.3G-Linux-x86-Install

I also modified some lines in file /opt/Alfresco/tomcat/shared/classses/alfredo-global.properties to read as follows:

ooo.exe=/usr/bin/soffice
ooo.enabled=true
img.root=/usr/lib/mime/packages/imagemagick
swf.exe=/usr/local/bin/pdf2swf

These correspond to the directories where OpenOffice, ImageMagick, and SWFTools were installed earlier. Before making the modifications above, I confirmed the installation directories for these programs by doing the following commands:

sudo find / -name soffice
sudo find / -name imagemagick
sudo find / -name pdf2swf

It appears that the MySQL database for Alfresco was correctly created, is running, and is accessible from Tomcat.

I checked the MySQL database by going here:

http://myserver.com/phpmyadmin

I see an 'alfresco' database containing 88 files. The directory /opt/Alfresco/tomcat/lib also contains the MySQL connector mysql-connector-java-5.1.7-bin.jar. So it appears that Alfresco has successfully created the MySQL database 'alfresco' and the MySQL user 'alfresco' and can connect to the database.


The output from 'netstat -aln' (see LISTINGS below) seems to indicate that MySQL (port 3306), Tomcat (port 8005), and Alfresco share (port 8080) are running, and that Alfresco is able to connect to MySQL.

So everything appears to be fine.

However, when I try to actually log in to Alfresco by pointing my browser to:

http://myserver.com:8080/share

I see the Alfresco login dialog, with fields 'User name' and 'Password'.

But when I enter "admin"/"admin" in these fields I get an error message saying:

"The remote server may be unavailable or your authentication details have not been recognized."


Should I be using a different username/password - or is there something wrong with my configuration?

+++ +++ +++

To help diagnose this problem, the outputs for the following three commands:

sudo cat /opt/Alfresco/tomcat/shared/classes/alfresco-global.properties
sudo cat /opt/Alfresco/alfresco.log
sudo netstat -aln
are shown below.

LISTINGS

myserver /opt/Alfresco: sudo cat tomcat/shared/classes/alfresco-global.properties
[sudo] password for xxx:

###############################
## Common Alfresco Properties #
###############################

#
# Sample custom content and index data location
#————-
dir.root=./alf_data

#
# Sample database connection properties
#————-
db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=3306

#
# External locations
#————-
#ooo.exe=soffice
#ooo.enabled=false
#img.root=./ImageMagick
#swf.exe=./bin/pdf2swf

ooo.exe=/usr/bin/soffice
ooo.enabled=true
img.root=/usr/lib/mime/packages/imagemagick
swf.exe=/usr/local/bin/pdf2swf

#
# MySQL connection
#————-
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}

#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
#db.driver=org.postgresql.Driver
#db.url=jdbc:postgresql://localhost:5432/alfresco

#
# Index Recovery Mode
#————-
#index.recovery.mode=AUTO

#
# Outbound Email Configuration
#————-
#mail.host=
#mail.port=25
#mail.username=anonymous
#mail.password=
#mail.encoding=UTF-8
#mail.from.default=alfresco@alfresco.org
#mail.smtp.auth=false

#
# Alfresco Email Service and Email Server
#————-

# Enable/Disable the inbound email service.  The service could be used by processes other than
# the Email Server (e.g. direct RMI access) so this flag is independent of the Email Service.
#————-
#email.inbound.enabled=true

# Email Server properties
#————-
#email.server.enabled=true
#email.server.port=25
#email.server.domain=alfresco.com
#email.inbound.unknownUser=anonymous

# A comma separated list of email REGEX patterns of allowed senders.
# If there are any values in the list then all sender email addresses
# must match. For example:
#   .*\@alfresco\.com, .*\@alfresco\.org
# Allow anyone:
#————-
#email.server.allowed.senders=.*

#
# The default authentication chain
# To configure external authentication subsystems see:
# http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems
#————-
#authentication.chain=alfrescoNtlm1:alfrescoNtlm

#
# URL Generation Parameters (The ${localname} token is replaced by the local server name)
#————-
#alfresco.context=alfresco
#alfresco.host=${localname}
#alfresco.port=8080
#alfresco.protocol=http
#
#share.context=share
#share.host=${localname}
#share.port=8080
#share.protocol=http

#imap.server.enabled=true
#imap.server.port=143
#imap.server.host=localhost

myserver /opt/Alfresco: sudo cat alfresco.log
23:35:55,200 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
23:35:55,212 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
23:35:55,222 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/opt/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/tests/alfresco-global.properties]
23:35:55,232 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/opt/Alfresco/tomcat/shared/classes/alfresco-global.properties]
23:35:55,345 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
23:36:19,476 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'registry' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is java.rmi.server.ExportException: Port already in use: 50500; nested exception is:
        java.net.BindException: Address already in use
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1401)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:512)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:280)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:557)
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:842)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:416)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:519)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.rmi.server.ExportException: Port already in use: 50500; nested exception is:
        java.net.BindException: Address already in use
        at sun.rmi.transport.tcp.TCPTransport.listen(TCPTransport.java:310)
        at sun.rmi.transport.tcp.TCPTransport.exportObject(TCPTransport.java:218)
        at sun.rmi.transport.tcp.TCPEndpoint.exportObject(TCPEndpoint.java:393)
        at sun.rmi.transport.LiveRef.exportObject(LiveRef.java:129)
        at sun.rmi.server.UnicastServerRef.exportObject(UnicastServerRef.java:190)
        at sun.rmi.registry.RegistryImpl.setup(RegistryImpl.java:92)
        at sun.rmi.registry.RegistryImpl.<init>(RegistryImpl.java:78)
        at java.rmi.registry.LocateRegistry.createRegistry(LocateRegistry.java:186)
        at org.springframework.remoting.rmi.RmiRegistryFactoryBean.getRegistry(RmiRegistryFactoryBean.java:267)
        at org.springframework.remoting.rmi.RmiRegistryFactoryBean.getRegistry(RmiRegistryFactoryBean.java:236)
        at org.springframework.remoting.rmi.RmiRegistryFactoryBean.getRegistry(RmiRegistryFactoryBean.java:193)
        at org.springframework.remoting.rmi.RmiRegistryFactoryBean.afterPropertiesSet(RmiRegistryFactoryBean.java:164)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1460)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1398)
        … 39 more
Caused by: java.net.BindException: Address already in use
        at java.net.PlainSocketImpl.socketBind(Native Method)
        at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
        at java.net.ServerSocket.bind(ServerSocket.java:319)
        at java.net.ServerSocket.<init>(ServerSocket.java:185)
        at java.net.ServerSocket.<init>(ServerSocket.java:97)
        at sun.rmi.transport.proxy.RMIDirectSocketFactory.createServerSocket(RMIDirectSocketFactory.java:27)
        at sun.rmi.transport.proxy.RMIMasterSocketFactory.createServerSocket(RMIMasterSocketFactory.java:333)
        at sun.rmi.transport.tcp.TCPEndpoint.newServerSocket(TCPEndpoint.java:649)
        at sun.rmi.transport.tcp.TCPTransport.listen(TCPTransport.java:299)
        … 52 more
23:36:36,203 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 227 Web Scripts (+0 failed), 235 URLs
23:36:36,231 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed)
23:36:36,231 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed)
23:36:36,372 INFO  [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 2770.166ms)
23:36:36,916 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
23:36:37,051 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
23:36:37,152 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
23:36:37,157 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
23:36:37,260 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
23:36:37,265 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
myserver /opt/Alfresco:

(The above listing of alfresco.log indicates that the port 50500 wasn't closed when ./alfresco.sh stop was run previously. This appears to be an error which was documented a couple of years ago:

https://issues.alfresco.com/jira/browse/ETHREEOH-512;jsessionid=4270CCC07E38742C325E11B0BBFBD967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

I don't know how important this error is, or whether it would be able to cause an authentication error making it impossible to log in using username/password 'admin'/'admin'.)


Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State

tcp        0      0 127.0.0.1:3306          127.0.0.1:48360         ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:48361         ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:48356         ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:48357         ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:48358         ESTABLISHED
tcp        0      0 127.0.0.1:3306          127.0.0.1:48359         ESTABLISHED
tcp6       0      0 :::50500                :::*                    LISTEN
tcp6       0      0 127.0.0.1:8005          :::*                    LISTEN
tcp6       0      0 :::50501                :::*                    LISTEN
tcp6       0      0 :::50502                :::*                    LISTEN
tcp6       0      0 :::50503                :::*                    LISTEN
tcp6       0      0 :::50504                :::*                    LISTEN
tcp6       0      0 :::50505                :::*                    LISTEN
tcp6       0      0 :::50506                :::*                    LISTEN
tcp6       0      0 :::59819                :::*                    LISTEN
tcp6       0      0 :::50508                :::*                    LISTEN
tcp6       0      0 :::32943                :::*                    LISTEN
tcp6       0      0 :::8080                 :::*                    LISTEN

tcp6       1      0 127.0.0.1:37468         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:38129         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:38278         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:38513         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:38746         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:40302         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:33436         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:35656         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:36132         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:36369         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:36837         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:47415         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:48628         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:42692         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:43069         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:43854         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:54048         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:54241         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:54768         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:56289         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:56886         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:57050         127.0.0.1:8080          CLOSE_WAIT
tcp6       0      0 127.0.0.1:48360         127.0.0.1:3306          ESTABLISHED
tcp6       0      0 127.0.0.1:48361         127.0.0.1:3306          ESTABLISHED
tcp6       0      0 127.0.0.1:48358         127.0.0.1:3306          ESTABLISHED
tcp6       0      0 127.0.0.1:48359         127.0.0.1:3306          ESTABLISHED
tcp6       0      0 127.0.0.1:48356         127.0.0.1:3306          ESTABLISHED
tcp6       0      0 127.0.0.1:48357         127.0.0.1:3306          ESTABLISHED
tcp6       1      0 127.0.0.1:52645         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:58224         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:58297         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:59640         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:59835         127.0.0.1:8080          CLOSE_WAIT
tcp6       1      0 127.0.0.1:60837         127.0.0.1:8080          CLOSE_WAIT

So it appears that Tomcat, MySQL and Alfresco are running - but for some reason the browser is not able to log in using 'admin'/'admin'.

Are these the wrong passwords - or is there something wrong with some configuration file(s)?

Thanks for any help.

Outcomes