nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Login Authentication not working after install with script

chris_c

First Alfresco Community install, ran the following script :
https://github.com/loftuxab/alfresco-ubuntu-install

Postgres 9.3, pg jdbc, nginx, tomcat 7, swftools, openjdk, imagemagick, share and alfresco war files, share config files, bart, sharepoint connector, gdocs, libreoffice, solr4, etc.

All options, all default settings.

Login to Alfresco Share fails when using admin/admin

The error message displayed is vague:

Message: "Your authentication details have not been recognized or Alfresco may not be available at this time."

Script author cannot reproduce error on his system.

EDIT: Postgres JDBC jar url was outdated, failed to download.

EDIT: Attached is a new /opt/alfresco/logs/alfresco.log file, plus share.log, and catalina.log

Any suggestion on how to find the cause of the login error?

alfresco_74.log.zip

catalina.2015-02-25.log.zip

share_14.log.zip

Find more posts tagged with

Comments

s_palyukh

Take a look at tomcat/lib folder and try to find postgresql-9.0-802.jdbc4.jar (maybe another version) if there is not jar then you need to upload JDBC driver for postgre into tomcat/lib folder.

Also would be good to attach your alfresco-global.properties

chris_c

Added the Postgres JDBC jar to /opt/alfresco/tomcat/lib
(The script had an outdated Postgres JDBC URL, so it failed to download the jar, and didn't check…)

Still getting the login fail error!
"Your authentication details have not been recognized or Alfresco may not be available at this time."

Logs and alfresco-global.properties are attached….

alfresco-global.properties_11.txt.zip

share_15.log.zip

alfresco_76.log.zip

catalina.2015-02-25_0.log.zip

rjohnson

Alfresco & Share are loadin OK.

Looking at catalina.out, the solr4 web application is failing to load because there is a problem with the config file solr.xml.

I'm not sure why solr would be relevant to a log in, but certainly without it Alfresco will not function. Also the fact that it is aborting may be killing some components that Alfresco login relies upon.

First order of business is to adjust the solr config so that it will load & run

chris_c

Newbie to solr.

Here's three relevant Solr 4 XML files.

/opt/alfresco/solr/solr.xml
/opt/alfresco/tomcat/conf/Catalina/localhost/solr4.xml
/opt/alfresco/tomcat/conf/context.xml

How do these compare to your working XML files ?

Any suggestions?

I'm not using solr 4 so I can't be a lot of help on the config.

That said, I think solr.war is missing or corrupt or a required jar. This is a bit of a guess but it is based on
SEVERE: Exception fixing docBase for context [/solr4]
java.util.zip.ZipException: error in opening zip file

jar / war files are sip files and I suspect one is missing or broken.

chris_c

Good call, solr4.war was an incomplete download. Downloaded somehow stopped at 19MB, the full proper war file is 99MB. Fixed all startup severe exceptions by manually downloading the solr4 war.

The login problem ("Your authentication details have not been recognized or Alfresco may not be available at this time.") is still there.

Where does alfresco write its login failure log?

rjohnson

They would be recorded in share.log / catalina.out but thats not a very informative error.

Usually, when you get that error it means that the alfresco webapp is not running.

First question I would ask is what password did you give the installer when you installed Alfresco because that is your admin password.

Second question is to check alfresco.log / share.log for any kind of errors.

chris_c

02:31:03,538 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: 01280000 
More than one Alfresco schema was found when querying the database metadata.
   Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.countAppliedPatches(SchemaBootstrap.java:644)
‍‍‍‍‍‍‍

Why would it have more than 1 schema?

How to fix?

catalina.2015-02-28.log.zip

It seems it maybe that the script postgresql.sh has been run more than once and if so, the alfresco schema has been created several times.

Fixing this is not something I have any experience of but I would suggest examining each schema using psql and eiter dropping the duplicates or you could edit tomcat/webapps/alfresco/WEB-INF/classes/alfresco/domain/hibernate-cfg.properties and set hibernate.default_schema={pick one of the schemas}

I would start by limiting the schema via hibernate-cfg.properties and then when you have found one that works, back up your installation (make certain Alfresco is shut down if you use file copy) then drop the redundant schemas and remove the hibernate.default_schema={pick one of the schemas} change.

chris_c

Would there be any reason why to not blow away the db and run the postgresql.sh script to create the db from scratch?

chris_c

Finally login works!

Much thanks Bob.

Recap of the commands required in this case:

sudo service alfresco stop
sudo dropdp postgres
sudo dropdb alfrseco
sudo createdb postgres
./postgresql.sh
sudo service postgresql restart
sudo service alfresco start
‍‍‍‍‍‍‍‍‍

Enter the postgres and alfreso username/password info into the config files (it's already there from previous install attemps).
Browse to the IP address of alfresco nginx web server.

Login with username admin pass admin

It logs in, as expected!