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.

3d does not allow login

m_r_

Given the last 2 times I've tried to get help in this forum I've been unsuccessful - I'll try again because I'm just that way.

Versions in play:
apache-tomcat-6.0.18
postgresql-server-8.2.9
http://dev.alfresco.com/downloads/nightly/dist/alfresco-labs-war-3d-dev.zip
Tomcat says:
Apache Tomcat/6.0.18    1.6.0_07-b02    The FreeBSD Foundation    FreeBSD    6.3-STABLE    i386

Tomcat log looks like this (BTW the best its looked in this effort) :
INFO: HTMLManager: list: Listing contexts for virtual host 'localhost'
Jan 16, 2009 9:24:40 PM org.apache.catalina.core.ApplicationContext log
INFO: HTMLManager: start: Starting web application at '/alfresco'
Jan 16, 2009 9:24:44 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
21:24:53,246 INFO [web.site.FrameworkHelper] Successfully Initialized Web Framework

Modified WEB-INF/classes/log4j.properties per others comments to a fixed path so this is what I get when the login attempt happens:

21:24:53,246 INFO [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework

to admin:admin and alfresco:alfresco   (the logins that are supposed to work)

Failed to Login
The remote server may be unavailable or your authentication details have not been recognized.
OK

So - what error logging do I need to turn on to figure out why the login is not allowed?

(Oh and have any of you run the install on OpenCMS?   The feedback it gives was nice.   The community might wanna look at what they are doing and ape it.)

Find more posts tagged with

Comments

mikeh

Hi

The login "alfresco:alfresco" has never been configured as far as I know - where did you get that from out of interest?

From the error, you're presumably trying to login to /share, but there's been an error deploying the /alfresco webapp (alfresco.war). Could you post the error(s) in the log file please?

Actually, looking at what you've posted again I don't believe PostgreSQL is supported in Labs V3 releases - only Derby (not recommended for anything other than simple POC) and MySQL (which is what we use day-to-day for development).

Mike

m_r_

The login "alfresco:alfresco" has never been configured as far as I know - where did you get that from out of interest?

Some website talking about their Alfresco config/demo thing. Might have been 'here is our VM - and here are the passwords. Alas, I can not find it again.

From the error, you're presumably trying to login to /share, but there's been an error deploying the /alfresco webapp (alfresco.war). Could you post the error(s) in the log file please?

Already did - there is only the start up messages - no errors. Hence my asking if there was some knob I could turn to increase log verbosity.
So - where is this knob?

Actually, looking at what you've posted again I don't believe PostgreSQL is supported in Labs V3 releases - only Derby (not recommended for anything other than simple POC) and MySQL (which is what we use day-to-day for development).

Lets say your belief is correct. What is the last know to work with PostgreSQL version so that I can use that version in the Advanced Linux course I teach?

mikeh

Lets say your belief is correct. What is the last know to work with PostgreSQL version so that I can use that version in the Advanced Linux course I teach?

Any of the 2.x releases will support PostgreSQL.

Mike

m_r_

Any of the 2.x releases will support PostgreSQL.

2.9?

mikeh

Should do, yes. We're planning to release patches to the PostgreSQL scripts for v3.0 - I don't have a time for that though. http://wiki.alfresco.com/wiki/Alfresco_Labs_3_Stable_Release_Notes

Thanks,
Mike

m_r_

Should do, yes.

Ok - I'll try 2.9 again. My memory is I had an issue - but I don't remember what it was.

We're planning to release patches to the PostgreSQL scripts for v3.0 -

Ok. Just reply to topic/send email. For my class Nuxeo looks like it'll do what I wanted - so I'm not SOL on having some technology that'll work.

m_r_

2B issues: now that I'm trying it again:

So I've changed the file so it uses PostgreSQL
grep -v ^# custom-repository.properties
db.username=alfresco
db.password=redacted
dir.root=/data/alfresco/alf_data
db.driver=org.postgresql.Driver
db.url=jdbc

ostgresql://localhost:5432/alfresco

And I'm seeing errors that its trying MySQL
Caused by: java.sql.SQLException: Access denied for user 'alfresco'@'localhost' (using password: YES)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

And even though I set:
dir.root=/data/alfresco/alf_data
It appears to be being created in webapps/alfresco/extensions/extension
Now its not complaining about not being able to write to alfresco.log - yet the log file was not appended to in the last go-round on attempting to start it. 02:26 is not 02:49

# ls -lt | head
total 216
-rwxrwxrwx 1 root wheel   2087 Jan 20 02:42 custom-repository.properties
-rwxrwxrwx 1 www   wheel 16850 Jan 20 02:26 alfresco.log
drwxrwxrwx 6 www   wheel    512 Jan 20 02:25 alf_data
-rwxrwxrwx 1 root wheel   2238 Jan 20 02:14 file-servers-custom.xml
-rwxrwxrwx 1 root wheel    935 Jan 20 02:14 custom-hibernate-dialect.properties

# pwd
(redaction)/webapps/alfresco/extensions/extension
INFO: HTMLManager: start: Starting web application at '/alfresco'
Jan 20, 2009 2:48:24 AM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
Jan 20, 2009 2:48:28 AM org.apache.catalina.core.ApplicationContext log
INFO: Loading Spring root WebApplicationContext
Jan 20, 2009 2:48:49 AM org.apache.catalina.loader.WebappClassLoader loadClass
INFO: Illegal access: this web application instance has been stopped already. Could not load org.bouncycastle.jce.provider.JDKMessageDigest$MD4. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1273)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)

(A whole lotta BLAH BLAH BLAH now deleted)

02:48:54,503 User

ystem WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
02:49:00,863 User

ystem ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'usageQuotaProtector' defined in class path resource [alfresco/usage-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)

(A whole lotta BLAH BLAH BLAH now deleted)

at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
        … 50 more
Caused by: java.sql.SQLException: Access denied for user 'alfresco'@'localhost' (using password: YES)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)

(The rest of the errors deleted as its all about JDBC failures and that is to be expected with the attempt to connect to MySQL failing)

So - why the MySQL 'I can't log in' messages?

zaizi

You need to edit custom-hibernate-dialect.properties and change it to use PostgreSQL dialect.

See http://wiki.alfresco.com/wiki/Repository_Configuration#Core_Configuration_Files.

m_r_

You need to edit custom-hibernate-dialect.properties and change it to use PostgreSQL dialect.

Although it is not stated above that was done already.   Below is the conformation of that documented change.

# ls -lt | head
total 216
-rwxrwxrwx 1 root wheel   2087 Jan 20 02:42 custom-repository.properties
-rwxrwxrwx 1 www   wheel 16850 Jan 20 02:26 alfresco.log
drwxrwxrwx 6 www   wheel    512 Jan 20 02:25 alf_data
-rwxrwxrwx 1 root wheel   2238 Jan 20 02:14 file-servers-custom.xml
-rwxrwxrwx 1 root wheel    935 Jan 20 02:14 custom-hibernate-dialect.properties
-rwxrwxrwx 1 root wheel   1092 Nov 16 2007 custom-email-server.sample.zip
# date
Tue Jan 20 16:10:54 UTC 2009

# grep -v ^# custom-hibernate-dialect.properties
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
hibernate.query.substitutions=true TRUE, false FALSE

Is there any other changes or have I found another bug?

http://wiki.alfresco.com/wiki/Repository_Configuration#Core_Configuration_Files

Core Configuration Files
The <configRoot> folder, and especially the <configRoot>/alfresco folder contains the core, Alfresco-maintained, configuration files.

Is that still the case today? It is not custom-repository.properties? I found repository.properties in
alfresco/WEB-INF/classes/alfresco/repository.properties

Any ideas on stdout.log:INFO: Illegal access: this web application instance has been stopped already. Could not load org.bouncycastle.jce.provider.JDKMessageDigest$MD4. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.

m_r_

Now what about avm-console.properties

# grep ^db. *
avm-console.properties:db.driver=org.gjt.mm.mysql.Driver
avm-console.properties:db.url=jdbc:mysql://127.0.0.1/avm
avm-console.properties:db.username=root
avm-console.properties:db.password=
avm-console.properties:db.pool.initial=4
avm-console.properties:db.pool.max=32
repository.properties:db.schema.update=true
repository.properties:db.username=alfresco
repository.properties:db.password=alfABCcoke
repository.properties:db.pool.initial=10
repository.properties:db.pool.max=100
repository.properties:db.driver=org.postgresql.Driver
repository.properties:db.url=jdbc

ostgresql://localhost:5432/alfresco

Is that needing modification also?

Because I'm now seeing this which makes me think I have to clear something else:
16:53:58,573 User

ystem WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
16:54:10,059 User

ystem INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
16:55:10,163 User

ystem ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed. Revert to the original database before attempting the upgrade again.
at org.alfresco.error.AlfrescoRuntimeException.create(AlfrescoRuntimeException.java:46)

sorca

I seem to get the same error (on AlfrescoLab3Final, Ubuntu8.10):

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

I followed the installation instructions in the InstallConfigure_Alfresco_Lab3Final-1.pdf which I got off the Alfresco wiki. I installed and tried to start, not changing database, and it worked like a charm. I then edited to change to MySQL from Derby. After starting Alfresco again I cannot login, I only get the fault above. I then tried to do it all over again, deleting Alfresco from /opt, rebooting and installing and changing to MySQL before I start it. Same fault at logon.

I am deeply puzzled over this, though I am hopeful it is just a minor glitch. The instructions in the pdf relates to the complete install on a RedHat system, but hopefully that wouldn´t change anything. I just followed the guide. It differs from the instruction though, I do not get any question on changing the default database from Derby to MySQL, as it states in the "manual". It goes directly from Setup Type to Location of OpenOffice.

I sincerely hope there is a solution

/Oscar

m_r_

I sincerely hope there is a solution

It may be the documentation is out of date/wrong. Some of the stuff looks to be 2.1 vintage, others talk about modifying files in places they are no longer at.

I don't have a working version so I can submit changes/a set of instructions/know if the problem is me or the software.

mikeh

I seem to get the same error (on AlfrescoLab3Final, Ubuntu8.10):
…
/Oscar

I suspect your error is actually different to this topic. Could you start a new thread, posting the contents of the log file / Tomcat startup console please?

One quick thing to check is whether the MySQL database looks populated? If not, check the MySQL connector is on the classpath.

Thanks,
Mike

mikeh

16:55:10,163 Userystem ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed. Revert to the original database before attempting the upgrade again.
at org.alfresco.error.AlfrescoRuntimeException.create(AlfrescoRuntimeException.java:46)

This means the bootstrap failed part-way through running the db scripts.

Easiest solution is to clear-down the database and alf_data folder and restart the app.

Thanks,
Mike

m_r_

16:55:10,163 Userystem ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed. Revert to the original database before attempting the upgrade again.
at org.alfresco.error.AlfrescoRuntimeException.create(AlfrescoRuntimeException.java:46)
This means the bootstrap failed part-way through running the db scripts.

The title of this thread - 3d no longer reflects that I am trying 2.9B to get PostgreSQL.    And perhaps I was unclear in my postings - mea culpa.

But I've changed the files that various documentation says to change - yet the code is asking for MySQL.
And, of course, a request for MySQL fails. Because its never been initialized.    So I'm not sure the re-initialize advice is the correct one.

And my machine is showing the code is talking to PostgreSQL

889 ?? Ss     2:16.76 postgres: stats collector process    (postgres)
22442 ?? Is     0:00.07 postgres: alfresco alfresco 127.0.0.1(55795) idle (po
22443 ?? Is     0:00.08 postgres: alfresco alfresco 127.0.0.1(58276) idle (po
22445 ?? Is     0:00.08 postgres: alfresco alfresco 127.0.0.1(50398) idle (po
22446 ?? Is     0:00.08 postgres: alfresco alfresco 127.0.0.1(64082) idle (po
22447 ?? Is     0:00.07 postgres: alfresco alfresco 127.0.0.1(63780) idle (po
22448 ?? Is     0:00.07 postgres: alfresco alfresco 127.0.0.1(57890) idle (po
22449 ?? Is     0:00.06 postgres: alfresco alfresco 127.0.0.1(57538) idle (po

Of course these are hung/zombies.

Now without PostgreSQL running in the log I see these snipits:

21:34:01,996 User

ystem ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'usageQuotaProtector' defined in class path resource [alfresco/usage-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

This is expected.

When I run postgres as below (with silent turned off and log to stderr)
$ ps ax | grep post
66338 ?? Ss     0:00.12 postgres: writer process    (postgres)
66339 ?? Ss     0:00.01 postgres: stats collector process    (postgres)
66347 ?? Is     0:00.01 postgres: alfresco alfresco 127.0.0.1(59258) idle (po
66348 ?? Is     0:00.01 postgres: alfresco alfresco 127.0.0.1(49561) idle (po
66349 ?? Is     0:00.03 postgres: alfresco alfresco 127.0.0.1(53250) idle (po
66350 ?? Is     0:00.01 postgres: alfresco alfresco 127.0.0.1(55724) idle (po
66351 ?? Is     0:00.01 postgres: alfresco alfresco 127.0.0.1(61816) idle (po
66352 ?? Is     0:00.01 postgres: alfresco alfresco 127.0.0.1(55272) idle (po
66353 ?? Is     0:00.01 postgres: alfresco alfresco 127.0.0.1(65039) idle (po
66354 ?? Is     0:00.01 postgres: alfresco alfresco 127.0.0.1(61197) idle (po
66436 p0 S+     0:00.00 grep post
66336 p1 I+     0:00.27 /usr/local/bin/postgres -d 5 -D /mypostgresdata

I see no actual PostgreSQL queries from the running in foreground postges app.

I do see connections like these:
DEBUG: forked new backend, pid=66545 socket=7
LOG: connection received: host=127.0.0.1 port=50099
LOG: connection authorized: user=alfresco database=alfresco
DEBUG: postgres child[66545]: starting with (
DEBUG:          postgres
DEBUG:          -v196608
DEBUG:          -y
DEBUG:          alfresco
DEBUG: )
DEBUG: InitPostgres
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 1778052/1/0, nestlvl: 1, children: <>
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1778052/1/0, nestlvl: 1, children: <>
DEBUG: forked new backend, pid=66546 socket=7

But that is all.

Instead I get this (And the bouncycastle) error:

21:49:00,355 User

ystem WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
21:49:05,801 User

ystem INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
21:50:06,034 User

ystem ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed. Revert to the original database before attempting the upgrade again.

Thus back to my question - what OTHER files need to be changed?

When you have regression tested PostgreSQL - do you do that on a machine that has no MySQL loaded (ever) on it?

I doubt filing bug reports on 2.9B would have a point, given the move to 3.0. (Not to mention the odds favor me being in error even if my bug reporting to date has been correct.) I'd be willing to wait for 3.0 SP1 if I had any idea of when that might happen - hence my attempt to use 2.9B.

sorca

I will post a new thread with the contents of the log file and a thorough desciption of what I do. I'll come back to this thread when I have done so to inform you.

Thanks,

Oscar

sorca

Hi,

I have started a new topic, Problems logging in after changing to MySQL, Labs3Final where I have included detailed info on how I have installed, error seeking and log transcripts. Hopefully it will help solve the problem.

/Oscar

joglekar

Should do, yes. We're planning to release patches to the PostgreSQL scripts for v3.0 - I don't have a time for that though. http://wiki.alfresco.com/wiki/Alfresco_Labs_3_Stable_Release_Notes

As you stated you use MySQL for development. So will community version always have patches / scripts for MySQL in future.

At present I am using Labs3.b version with PostgreSQL 8.3 fedora 9.0. How can I migrate to MySQL?

To create scripts for v3.0 postgres which files needs changes. is it only in
alfresco/dbscripts/upgrade/2.2/${db.script.dialect}/upgrade-from-2.2SP1.sql
and which other files? If it is only in sql files I will attemt to change.

I have problem to upgrade to 3 Stble. I had same problems when I tried to upgrade to 3c.

Thanks

Joglekar