批注 2022-08-03 094310.png - ConcourseSuite Support image

ConcourseSuite Support

Support
http://concursive.com/help/en_us/
Corporate
PUBLIC PROFILE

Back to topics

Discuss Installation and Maintenance

Moderator: Matt Rajkowski

Install error lookup_authentication_classes table

You need to be logged in to post messages

This question is unanswered

Install error lookup_authentication_classes table

9/24/2008 3:06 PM EDT
Default user photo

By tom lamm

When installing ConcourseSuite, the database creation fails with:

An error occurred while trying to create the database schema, the following error was provided: Table 'centric_crm.lookup_authentication_classes' doesn't exist
 

Note, this is not the documented "Invalid object name 'lookup_authentication_classes'" issue. This fails when trying to create the database and the installation will not continue.

Pressing the 'continue' button causes the script to attempt to repeat the step (3 of 4). At that time, the script fails with an error explaining that the 'sites' table already exists.

Thank You

Tom Lamm
Marcal Systems

1. 10/1/2008 12:47 PM EDT (edited)
Default user photo

By tom lamm

tom again....

Turns out the problem is in the mysql install script. If you are using mysql, and the install version is 5.0.6:

edit centric/WEB-INF/setup/mysql/new_cdb.sql

Add this at the end of the script:

CREATE TABLE lookup_authentication_classes

code INT AUTO_INCREMENT PRIMARY KEY,
login_mode varchar(300),
login_authenticator varchar(300),
session_validator varchar(300),
enabled BIT NOT NULL DEFAULT 1,
entered timestamp DEFAULT CURRENT_TIMESTAMP,
modified timestamp NULL
};

That allows the script to run, I do not know what else will be wrong. Hopefully nothing.

Tom Lamm

2. 10/1/2008 1:33 PM EDT
1 person found this helpful.
Tom M. photo

By Tom Manos

I hope that fixes it, too.

We've been so busy with development that we haven't been able to put the time we would like into testing all the various combinations of app server & database that we try to juggle.

We're always most up to date with Tomcat and PostgreSQL, which is what we develop on.

As always, thanks for the feedback. We'll get this fix and anything else you turn up into the code as quickly as we can.

tom lamm wrote:
tom again....

Turns out the problem is in the mysql install script. If you are using mysql, and the install version is 5.0.6:

edit centric/WEB-INF/setup/mysql/new_cdb.sql

Add this at the end of the script:

CREATE TABLE lookup_authentication_classes

code INT AUTO_INCREMENT PRIMARY KEY,
login_mode varchar(300),
login_authenticator varchar(300),
session_validator varchar(300),
enabled BIT NOT NULL DEFAULT 1,
entered timestamp DEFAULT CURRENT_TIMESTAMP,
modified timestamp NULL
};

That allows the script to run, I do not know what else will be wrong. Hopefully nothing.

Tom Lamm

3. 5/2/2009 8:50 PM EDT
Default user photo

By Tim VanDermyden

Same issue when install on Oracle 10g, Centric 5.0.6, and Tomcat 5.5. Will the above noted fix work for Oracle as well?

Getting this error from the log file. During the initial installation on Oracle this is the error;

ERROR [org.aspcfs.modules.setup.actions.Setup] - Inserting default data failed: ORA-02289: sequence does not exist

Dropped the user, cascade, re-run the install from the screen 3 of 4, and continue to get the same error.

Anyone know a fix/workaround?

Thanks and cheers!
Tim

3 results found