topic Re: Login Authentication not working after install with script in Alfresco Archive

Login Authentication not working after install with script

chris_c — Tue, 24 Feb 2015 20:49:09 GMT

First Alfresco Community install, ran the following script :https://github.com/loftuxab/alfresco-ubuntu-installPostgres 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 opti

Re: Login Authentication not working after install with script

s_palyukh — Wed, 25 Feb 2015 14:07:48 GMT

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

Re: Login Authentication not working after install with script

chris_c — Wed, 25 Feb 2015 21:33:00 GMT

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….

Re: Login Authentication not working after install with script

rjohnson — Thu, 26 Feb 2015 08:47:50 GMT

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

Re: Login Authentication not working after install with script

chris_c — Thu, 26 Feb 2015 19:55:00 GMT

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?

Re: Login Authentication not working after install with script

rjohnson — Fri, 27 Feb 2015 08:13:53 GMT

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.

Re: Login Authentication not working after install with script

chris_c — Fri, 27 Feb 2015 13:39:29 GMT

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?

Re: Login Authentication not working after install with script

rjohnson — Fri, 27 Feb 2015 14:31:00 GMT

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.

Re: Login Authentication not working after install with script

chris_c — Sat, 28 Feb 2015 02:51:00 GMT


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?

Re: Login Authentication not working after install with script

rjohnson — Sun, 01 Mar 2015 10:43:32 GMT

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.

Re: Login Authentication not working after install with script

chris_c — Mon, 02 Mar 2015 18:04:21 GMT

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

Re: Login Authentication not working after install with script

chris_c — Mon, 02 Mar 2015 18:52:00 GMT

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!