Reinstalacion por tercera vez

[okm_ros]

Acabo de bajar la ultima version(OpenKM-5.0.2_JBoss-4.2.3.GA.zip).
y Me sigue apareciendo este error

Code: Select all

2011-02-22 15:02:05,903 ERROR [STDERR] javax.naming.NamingException: [LDAP: error code 1 - 000020D6: SvcErr: DSID-031006CC, problem 5012 (DIR_ERROR), data 0
]; remaining name 'o=dgt.es'

Adjunto trace del log.

----------------------Describo mi instalación:------------------------
Server: Ubuntu 10
base_datos: MS SQL Server 2005
Ldap: MS Active Directory.

Despues del primer arranque con el parametro( hibernate.hbm2ddl=create) tuve que hacer lo siguiente por
los errores que me aparecia en el archivo server.log.

Code: Select all

1)
ALTER TABLE [dbo].[OKM_ACTIVITY]
     ALTER COLUMN [ACT_ITEM] varchar(MAX)

2)
ALTER TABLE [dbo].[OKM_EXTENSION]
ALTER COLUMN [EX_DESCRIPTION] varchar(MAX)

3)
CREATE TABLE OKM_PROFILE (
        PRF_ID int identity NOT NULL,
        PRF_NAME varchar(255) NOT NULL,
        PRF_ACTIVE tinyint NOT NULL,
        PRF_MSC_ADVANCED_FILTERS tinyint DEFAULT 0 NULL,
        PRF_MSC_USER_QUOTA numeric(19,0) DEFAULT 0 NULL,
        PRF_MSC_WEB_SKIN varchar(255) DEFAULT 'default' NULL,
        PRF_MSC_PRINT_PREVIEW tinyint DEFAULT 1 NULL,
        PRF_CHT_CHAT_EN tinyint DEFAULT 0 NULL,
        PRF_CHT_AUTO_LOGIN_EN tinyint DEFAULT 0 NULL,
        PRF_WZRD_KEYWORDS_EN tinyint DEFAULT 0 NULL,
        PRF_WZRD_CATEGORIES_EN tinyint DEFAULT 0 NULL,
        PRF_STCK_TAXONOMY_VIS tinyint DEFAULT 1 NULL,
        PRF_STCK_CATEGORIES_VIS tinyint DEFAULT 1 NULL,
        PRF_STCK_THESAURUS_VIS tinyint DEFAULT 1 NULL,
        PRF_STCK_TEMPLATES_VIS tinyint DEFAULT 1 NULL,
        PRF_STCK_PERSONAL_VIS tinyint DEFAULT 1 NULL,
        PRF_STCK_MAIL_VIS tinyint DEFAULT 1 NULL,
        PRF_STCK_TRASH_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DESKTOP_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_SEARCH_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DASHBOARD_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_ADMIN_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DOC_PROPS_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DOC_SECURITY_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DOC_NOTES_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DOC_VERSIONS_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DOC_PREVIEW_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DOC_PROP_GRPS_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_FLD_PROPS_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_FLD_SECURITY_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_FLD_NOTES_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_ML_PROPS_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_ML_SECURITY_VIS tinyint DEFAULT 1 NULL,
        PRF_DB_USER_VIS tinyint DEFAULT 1 NULL,
        PRF_DB_MAIL_VIS tinyint DEFAULT 1 NULL,
        PRF_DB_NEWS_VIS tinyint DEFAULT 1 NULL,
        PRF_DB_GENERAL_VIS tinyint DEFAULT 1 NULL,
        PRF_DB_WORKFLOW_VIS tinyint DEFAULT 1 NULL,
        PRF_DB_KEYWORDS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FILE_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_EDIT_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_TOOLS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_BOOKMARKS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HELP_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_CREATE_FLD_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_FIND_FLD_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_GO_FLD_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_DOWNLOAD_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_DOWNLOAD_PDF_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_ADD_DOC_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_START_WORKFLOW_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_REFRESH_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_SCANNER_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_UPLOADER_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_PURGE_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_PURGE_TRASH_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_RESTORE_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_EXPORT_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_CREATE_FROM_TPL_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_SEND_DOC_LINK_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_SEND_DOC_ATTACH_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_LOCK_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_UNLOCK_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_CIN_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_COUT_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_CANCEL_COUT_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_DELETE_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_RENAME_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_COPY_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_MOVE_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_ADD_PROP_GRP_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_REM_PROP_GRP_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_ADD_SUBS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_REM_SUBS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_BM_MNG_BOOKMARKS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_BM_ADD_BOOKMARK_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_BM_SET_HOME_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_BM_GO_HOME_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_TL_LANGS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_TL_SKIN_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_TL_DEBUG_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_TL_ADMIN_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_TL_PREFS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HLP_DOC_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HLP_BUG_TRACKING_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HLP_SUPPORT_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HLP_FORUM_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HLP_CHANGELOG_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HLP_WEB_SITE_VIS tinyint DEFAULT 1 NULL,
        PRF_MNU_HLP_ABOUT_VIS tinyint DEFAULT 1 NULL,
        PRIMARY KEY (PRF_ID)
);
 
ALTER TABLE OKM_USER_CONFIG ADD constraint FK7798F4E88FDAFE34 FOREIGN KEY (UC_PROFILE) REFERENCES OKM_PROFILE;
 
INSERT INTO OKM_USER (USR_ID, USR_NAME, USR_PASSWORD, USR_EMAIL, USR_ACTIVE) 
VALUES ('okmadmin', 'Administrator', ' ', 'okmadmin@bancobsf.com.ar', 1);
 
INSERT INTO OKM_ROLE (ROL_ID, ROL_ACTIVE) VALUES ('AdminRole', 1);
INSERT INTO OKM_ROLE (ROL_ID, ROL_ACTIVE) VALUES ('UserRole', 1);
INSERT INTO OKM_USER_ROLE (UR_USER, UR_ROLE) VALUES ('okmadmin', 'AdminRole');
INSERT INTO OKM_PROFILE (PRF_NAME, PRF_ACTIVE) VALUES ('Default', 1);

4)
ALTER TABLE [dbo].[OKM_PROFILE]
ADD  [PRF_WZRD_PROPERTY_GROUPS] VARCHAR(255) DEFAULT ''

5)
ALTER TABLE [dbo].[OKM_PROFILE]
add [PRF_WZRD_WORKFLOWS] VARCHAR(255) DEFAULT ''

Aguardo, sus comentarios.

Estamos suscriptos.(Floress.ds)

[jllort]

Borraste la base de datos y la volviste a crear ? mejor si esta todo limpio.

El error concretamente lo continuas teniendo con el ldap no ? Si tiras por los usuarios embebidos funciona bien ?

Mírate el final de este post http://forum.openkm.com/viewtopic.php?f=14&t=4546 que parece que hubo problemas al subir este fichero la semana pasada.

Si te vas a la administración te aparece la version 5.0.2 no ?

[okm_ros]

------Borraste la base de datos y la volviste a crear ? mejor si esta todo limpio.
Si completamente.

-----El error concretamente lo continuas teniendo con el ldap no ? Si tiras por los usuarios embebidos funciona bien ?
Cualquier usuario que entra, se loguea bien, y la aplicación funciona bien.
Pero en el log, sigue apareciendo este error.

-----Mírate el final de este post viewtopic.php?f=14&t=4546 que parece que hubo problemas al subir este fichero la semana pasada.
Lo baje ayer (23/02/2011)

------Si te vas a la administración te aparece la version 5.0.2 no ?

OpenKM - Knowledge Management
Version: 5.0.2 (build: 4894)

© 2006-2010 OpenKM

Support
support@openkm.com

Installation ID
835545577689114830213156384780


Lo que no pude resolver es: Recuperar la dirección de correo del LDAP( Active directory).

Gracias por responder.

[pavila]

The was some problems with the uploaded OpenKM + JBoss bundle. Now is corrected but need to spread across the SourceForge mirrors. Download http://sourceforge.net/projects/openkm/ ... p/download and replace your OpenKM.war with this one.