IJC ldap security configuration issue

User 55ffa2f197

10-10-2012 13:28:49

Hi, I was able to configure LDAP based IJC authentication using the LDAP template for one schema. Now I am using the same configuration XML file to another IJC schema for LDAP configuration, but when I try to log in to the IJC schema I am getting following error as shown in the IJC client side log file. Can someone do a webex with me to debug the issue. I have checked every details I can but could not figure out what went wrong. I have also attached the LDAP configration template I am using.



Error from log file:


INFO [com.im.ijc.core.api.util.SchemaInitManager]: Schema init failed in 'Loading schema' with message: Property table null does not exist or is not known
java.lang.IllegalArgumentException: Property table null does not exist or is not known
 at com.im.ijcs.impl.ddl.JChemTableManagerImpl.getPropertyTableData(JChemTableManagerImpl.java:927)
 at com.im.ijcs.impl.ddl.JChemTableManagerImpl.buildTableSetInfoForCartStdTable(JChemTableManagerImpl.java:1359)
 at com.im.ijcs.impl.ddl.DefaultDDLService.synthesizeTsi(DefaultDDLService.java:1557)
 at com.im.ijcs.impl.ddl.DefaultDDLService.getModel(DefaultDDLService.java:263)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
 at $Proxy26.getModel(Unknown Source)
 at com.im.df.impl.db.sprovider.DDLModeSelectionState.readSchema(DDLModeSelectionState.java:307)
 at com.im.df.impl.db.sprovider.DDLModeSelectionState.proceedToNextState(DDLModeSelectionState.java:162)
 at com.im.df.impl.db.sprovider.SchemaProviderImpl.proceedToNextState(SchemaProviderImpl.java:124)
[catch] at com.im.ijc.core.api.util.SchemaInitManager.startInit(SchemaInitManager.java:245)
 at com.im.ijc.core.api.util.SchemaInitManager.access$000(SchemaInitManager.java:55)
 at com.im.ijc.core.api.util.SchemaInitManager$1.run(SchemaInitManager.java:87)
 at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
 at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
StopWatch 'Schema Init steps': running time (millis) = 9969
ms     %     Task name
00000  000%  Step 1: Reading connection info
03328  033%  Step 2: Connecting to database
01953  020%  Step 3: Authenticating IJC username/password
00032  000%  Step 4: Upgrading IJC Schema...
04656  047%  Step 5: Loading schema

ChemAxon aa7c50abf8

10-10-2012 13:40:30

Moved to the appropriate forum.

ChemAxon 37bb34e128

10-10-2012 14:04:56

Hi Dong,

I don't think that the error has anything to do with the LDAP authentication. How did you create that other IJC schema? Does the database user you are using to login to the database have access to all the tables within the schema? The error suggests that there is a problem with one of the properties tables. It's usually called jchemproperties, but can have other names too.

You IJC schema seem to contain an entity based on a standard table with cartridge index, this entity needs a jchem properties table and it can't be found for some reason. It either was deleted or is no longer accessible for the db user you are using.

I'll have a look in the code to see if I can diagnose this a bit more.


User 55ffa2f197

10-10-2012 14:22:18

if I switch to authentication via IJC database, I am fine, I can login. This schema is a bit messy, a couple of people touch on it, three months ago I did LDAP configuration, it works just fine. Yes it is a standard table, I put cart index on structure column.