Here are the xml files. I will run again once I change the log file location
On Wed, Jul 17, 2019 at 2:00 AM Soisik Froger <[email protected]>
wrote:
> On 16/07/2019 21:04, Mike Hollingsworth wrote:
> > We are using on ubuntu server with openldap and receive this error
> > Connecting to LDAP server
> ldap://mcsd-ds01:389/dc=local,dc=mcschools,dc=us as
> cn=admin,dc=local,dc=mcschools,dc=us
> > Jul 16 13:58:43 - ERROR - org.lsc.exception.LscConfigurationException:
> Configuration exception: Something bad happened while building the
> SqlMapClient instance.java.lang.RuntimeException: Error occurred. Cause:
> com.ibatis.common.xml.NodeletException: Error parsing XML. Cause:
> java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.
> Cause: java.net.UnknownHostException: etc
> > /usr/bin/lsc: line 73: /var/log/lsc/lsc.log: Permission denied
> >
> > Thanks
> >
> > Mike Hollingsworth
>
>
> Hi,
>
> Does the user executing LSC have write permission on /var/log/lsc ?
> You can change the target log file in logback.xml.
>
> If you still get errors, please provide relevant part of your
> configuration files and the version of java.
>
> Regards
> --
> Soisik Froger | Software Architect
>
> [email protected]
>
> Worteks | https://www.worteks.com
> _______________________________________________________________
> Ldap Synchronization Connector (LSC) - http://lsc-project.org
>
> lsc-users mailing list
> [email protected]
> https://lists.lsc-project.org/cgi-bin/mailman/listinfo/lsc-users
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd";>
<!--
LDAP Synchronization Connector (LSC) - http://lsc-project.org
This file configure iBatis to read sqlMap files.
Settings should be generated here automatically.
The only section you need to check is the sqlMap entries at the bottom.
-->
<sqlMapConfig>
<!-- The settings element has a number of configuration switches and properties
that configure the SQL Maps engine. Most are performance tweaks or resource
management. They are pretty self explanatory. The defaults are shown here.
There can be only one settins element. -->
<!-- <settings
lazyLoadingEnabled="true"
cacheModelsEnabled="true"
enhancementEnabled="true"
maxRequests="512"
maxSessions="128"
maxTransactions="32"
/> -->
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property value="${driver}" name="JDBC.Driver" />
<property value="${url}" name="JDBC.ConnectionURL" />
<property value="${username}" name="JDBC.Username"/>
<property value="${password}" name="JDBC.Password"/>
<property value="15" name="Pool.MaximumActiveConnections"/>
<property value="15" name="Pool.MaximumIdleConnections"/>
<property value="1000" name="Pool.MaximumWait"/>
</dataSource>
</transactionManager>
<!-- Finally, the SQL Maps themselves must be registred with the configuration file.
Below are some examples of some SQL Map reference elements. Notice that an
SQL Map can be located in the classpath (resource) or at a URL (e.g. file://
or http://). There can be any number of sqlMap elements. -->
<!--
<sqlMap url="file://${lsc.config}/sql-map-config.d/InetOrgPerson.xml"/>
-->
<sqlMap url="file://etc/lsc/sql-map-config.d/InetOrgPerson.xml"/>
</sqlMapConfig>
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd";>
<sqlMap namespace="InetOrgPerson">
<!--
<select id="getInetOrgPerson" resultClass="java.util.HashMap" parameterClass="java.util.Map">
Select
'inetOrgPerson' objectClass,
pers."ID",
pers."UID",
pers."SN",
pers."GIVENNAME",
pers."CN",
pers."MAIL",
pers."GIVENNAME",
pers."ADDRESS",
pers."TELEPHONENUMBER"
FROM csvdata pers
WHERE pers."MAIL" LIKE #mail#
</select>
-->
<select id="getInetOrgPerson" resultClass="java.util.HashMap" parameterClass="java.util.Map">
Select
'inetOrgPerson' objectClass,
pers."ID",
pers."UID",
pers."SN",
pers."GIVENNAME",
pers."CN",
pers."MAIL",
pers."GIVENNAME",
pers."ADDRESS",
pers."TELEPHONENUMBER"
pers."EMPLOYEETYPE"
pers."EMPLOYEENUMBER"
pers."DESCRIPTION"
FROM csvdata pers
WHERE pers."MAIL" LIKE #mail#
</select>
<select id="checkPersonForClean" resultClass="java.util.HashMap" parameterClass="java.util.Map">
Select
pers."ID" AS ID
FROM csvdata pers
WHERE pers."MAIL" LIKE #mail#
</select>
<select id="getInetOrgPersonList" resultClass="java.util.HashMap">
SELECT pers."MAIL" AS mail
FROM csvdata pers
</select>
</sqlMap>
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
https://lists.lsc-project.org/cgi-bin/mailman/listinfo/lsc-users
