No, I stand corrected: the right class is in that jar:

>>>>>>
C:\wip\mcf\trunk\dist\lib-proprietary>"c:\Program Files\Java\jdk1.8.0_181\bin\jar" -tf jtds-1.2.4.jar | grep Driver
net/sourceforge/jtds/jdbc/Driver.class
<<<<<<

Interesting that it cannot be found.  Can I ask again which process it is that dumps this message?  Is it the UI?

Karl


On Wed, Feb 20, 2019 at 11:42 AM Karl Wright <daddywri@gmail.com> wrote:
It's also possible that the jtds driver now needs another jar included as a dependency for working with mssql.
Unfortunately, you'll probably need to figure this out on your own.  Please let me know what you find so that I can update instructions or code.

Karl


On Wed, Feb 20, 2019 at 11:31 AM Karl Wright <daddywri@gmail.com> wrote:
OK, you are basically having trouble with the JDBC connector, not the basic functioning of ManifoldCF.  That was not clear.

The JDBC driver class name for MSSQL has likely been updated and we'll need to figure out what it got changed to.

Karl


On Wed, Feb 20, 2019 at 11:20 AM Bisonti Mario <Mario.Bisonti@vimar.com> wrote:

Yes, infact:

administrator@sengvivv01:/opt/manifoldcf/multiprocess-zk-example-proprietary$ more options.env.unix

-Xms3048m

-Xmx3048m

-Dorg.apache.manifoldcf.configfile=./properties.xml

-cp

.:../lib/mcf-core.jar:../lib/mcf-agents.jar:../lib/mcf-pull-agent.jar:../lib/hsqldb-2.3.2.jar:../lib/postgresql-42.1.3.jar:../lib/commons-codec-1.10.jar:../lib/commons-collections-3.2.1.jar:../l

ib/commons-collections4-4.1.jar:../lib/commons-discovery-0.5.jar:../lib/commons-el-1.0.jar:../lib/commons-exec-1.3.jar:../lib/commons-fileupload-1.3.3.jar:../lib/commons-io-2.5.jar:../lib/common

s-lang-2.6.jar:../lib/commons-lang3-3.6.jar:../lib/commons-logging-1.2.jar:../lib/ecj-4.3.1.jar:../lib/gson-2.8.0.jar:../lib/guava-25.1-jre.jar:../lib/httpclient-4.5.6.jar:../lib/httpcore-4.4.10.jar:../lib/jasper-6.0.35.jar:../lib/jasper-el-6.0.35.jar:../lib/javax.servlet-api-3.1.0.jar:../lib/jna-4.3.0.jar:../lib/jna-platform-4.3.0.jar:../lib/json-simple-1.1.1.jar:../lib/jsp-api-2.1-glassfish-2.1.v20091210.jar:../lib/juli-6.0.35.jar:../lib/log4j-1.2-api-2.4.1.jar:../lib/log4j-api-2.4.1.jar:../lib/log4j-core-2.4.1.jar:../lib/mail-1.4.5.jar:../lib/serializer-2.7.1.jar:../lib/slf4j-api-1.7.25.jar:../lib/slf4j-simple-1.7.25.jar:../lib/velocity-1.7.jar:../lib/xalan-2.7.1.jar:../lib/xercesImpl-2.10.0.jar:../lib/xml-apis-1.4.01.jar:../lib/zookeeper-3.4.10.jar:../lib-proprietary/jtds-1.2.4.jar:../lib-proprietary/mariadb-java-client-1.1.7.jar:../lib-proprietary/mysql-connector-java-5.1.33.jar:

 

 

And:

administrator@sengvivv01:/opt/manifoldcf/multiprocess-zk-example-proprietary$ sudo -u tomcat ./initialize.sh

[sudo] password for administrator:

Configuration file successfully read

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:zookeeper.version=3.4.10-39d3a4f269333c922ed3db283be479f9deacaa0f, built on 03/23/2017 10:13 GMT

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:host.name=sengvivv01.vimar.net

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.version=10.0.2

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.vendor=Oracle Corporation

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.home=/usr/lib/jvm/java-11-openjdk-amd64

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.class.path=.:../lib/mcf-core.jar:../lib/mcf-agents.jar:../lib/mcf-pull-agent.jar:../lib/hsqldb-2.3.2.jar:../lib/postgresql-42.1.3.jar:../lib/commons-codec-1.10.jar:../lib/commons-collections-3.2.1.jar:../lib/commons-collections4-4.1.jar:../lib/commons-discovery-0.5.jar:../lib/commons-el-1.0.jar:../lib/commons-exec-1.3.jar:../lib/commons-fileupload-1.3.3.jar:../lib/commons-io-2.5.jar:../lib/commons-lang-2.6.jar:../lib/commons-lang3-3.6.jar:../lib/commons-logging-1.2.jar:../lib/ecj-4.3.1.jar:../lib/gson-2.8.0.jar:../lib/guava-25.1-jre.jar:../lib/httpclient-4.5.6.jar:../lib/httpcore-4.4.10.jar:../lib/jasper-6.0.35.jar:../lib/jasper-el-6.0.35.jar:../lib/javax.servlet-api-3.1.0.jar:../lib/jna-4.3.0.jar:../lib/jna-platform-4.3.0.jar:../lib/json-simple-1.1.1.jar:../lib/jsp-api-2.1-glassfish-2.1.v20091210.jar:../lib/juli-6.0.35.jar:../lib/log4j-1.2-api-2.4.1.jar:../lib/log4j-api-2.4.1.jar:../lib/log4j-core-2.4.1.jar:../lib/mail-1.4.5.jar:../lib/serializer-2.7.1.jar:../lib/slf4j-api-1.7.25.jar:../lib/slf4j-simple-1.7.25.jar:../lib/velocity-1.7.jar:../lib/xalan-2.7.1.jar:../lib/xercesImpl-2.10.0.jar:../lib/xml-apis-1.4.01.jar:../lib/zookeeper-3.4.10.jar:../lib-proprietary/jtds-1.2.4.jar:../lib-proprietary/mariadb-java-client-1.1.7.jar:../lib-proprietary/mysql-connector-java-5.1.33.jar:

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.library.path=/usr/java/packages/lib:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.io.tmpdir=/tmp

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.compiler=<NA>

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:os.name=Linux

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:os.arch=amd64

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:os.version=4.15.0-45-generic

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:user.name=tomcat

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:user.home=/opt/tomcat

[main] INFO org.apache.zookeeper.ZooKeeper - Client environment:user.dir=/opt/manifoldcf/multiprocess-zk-example-proprietary

[main] INFO org.apache.zookeeper.ZooKeeper - Initiating client connection, connectString=localhost:8349 sessionTimeout=300000 watcher=org.apache.manifoldcf.core.lockmanager.ZooKeeperConnection$ZooKeeperWatcher@14008db3

[main-SendThread(localhost6.localdomain6:8349)] INFO org.apache.zookeeper.ClientCnxn - Opening socket connection to server localhost6.localdomain6/0:0:0:0:0:0:0:1:8349. Will not attempt to authenticate using SASL (unknown error)

[main-SendThread(localhost6.localdomain6:8349)] INFO org.apache.zookeeper.ClientCnxn - Socket connection established to localhost6.localdomain6/0:0:0:0:0:0:0:1:8349, initiating session

[main-SendThread(localhost6.localdomain6:8349)] INFO org.apache.zookeeper.ClientCnxn - Session establishment complete on server localhost6.localdomain6/0:0:0:0:0:0:0:1:8349, sessionid = 0x1690ba14da30059, negotiated timeout = 100000

WARNING: An illegal reflective access operation has occurred

WARNING: Illegal reflective access by org.postgresql.jdbc.TimestampUtils (file:/opt/manifoldcf/lib/postgresql-42.1.3.jar) to field java.util.TimeZone.defaultTimeZone

WARNING: Please consider reporting this to the maintainers of org.postgresql.jdbc.TimestampUtils

WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations

WARNING: All illegal access operations will be denied in a future release

[main] INFO org.apache.zookeeper.ZooKeeper - Initiating client connection, connectString=localhost:8349 sessionTimeout=300000 watcher=org.apache.manifoldcf.core.lockmanager.ZooKeeperConnection$ZooKeeperWatcher@2f05be7f

[main-SendThread(localhost6.localdomain6:8349)] INFO org.apache.zookeeper.ClientCnxn - Opening socket connection to server localhost6.localdomain6/0:0:0:0:0:0:0:1:8349. Will not attempt to authenticate using SASL (unknown error)

[main-SendThread(localhost6.localdomain6:8349)] INFO org.apache.zookeeper.ClientCnxn - Socket connection established to localhost6.localdomain6/0:0:0:0:0:0:0:1:8349, initiating session

[main-SendThread(localhost6.localdomain6:8349)] INFO org.apache.zookeeper.ClientCnxn - Session establishment complete on server localhost6.localdomain6/0:0:0:0:0:0:0:1:8349, sessionid = 0x1690ba14da3005a, negotiated timeout = 100000

Successfully unregistered all domains

Successfully unregistered all output connectors

Successfully unregistered all transformation connectors

Successfully unregistered all mapping connectors

Successfully unregistered all authority connectors

Successfully unregistered all repository connectors

[main] INFO org.apache.zookeeper.ZooKeeper - Initiating client connection, connectString=localhost:8349 sessionTimeout=300000 watcher=org.apache.manifoldcf.core.lockmanager.ZooKeeperConnection$ZooKeeperWatcher@163d04ff

[main-SendThread(localhost.localdomain:8349)] INFO org.apache.zookeeper.ClientCnxn - Opening socket connection to server localhost.localdomain/127.0.0.1:8349. Will not attempt to authenticate using SASL (unknown error)

[main-SendThread(localhost.localdomain:8349)] INFO org.apache.zookeeper.ClientCnxn - Socket connection established to localhost.localdomain/127.0.0.1:8349, initiating session

[main-SendThread(localhost.localdomain:8349)] INFO org.apache.zookeeper.ClientCnxn - Session establishment complete on server localhost.localdomain/127.0.0.1:8349, sessionid = 0x1690ba14da3005b, negotiated timeout = 100000

Successfully registered output connector 'org.apache.manifoldcf.agents.output.solr.SolrConnector'

Successfully registered output connector 'org.apache.manifoldcf.agents.output.searchblox.SearchBloxConnector'

Successfully registered output connector 'org.apache.manifoldcf.agents.output.opensearchserver.OpenSearchServerConnector'

Successfully registered output connector 'org.apache.manifoldcf.agents.output.nullconnector.NullConnector'

Successfully registered output connector 'org.apache.manifoldcf.agents.output.mongodboutput.MongodbOutputConnector'

Successfully registered output connector 'org.apache.manifoldcf.agents.output.kafka.KafkaOutputConnector'

Successfully registered output connector 'org.apache.manifoldcf.agents.output.hdfs.HDFSOutputConnector'

Successfully registered output connector 'org.apache.manifoldcf.agents.output.gts.GTSConnector'

Successfully registered output connector 'org.apache.manifoldcf.agents.output.filesystem.FileOutputConnector'

Successfully registered output connector 'org.apache.manifoldcf.agents.output.elasticsearch.ElasticSearchConnector'

Successfully registered output connector 'org.apache.manifoldcf.agents.output.cmisoutput.CmisOutputConnector'

Successfully registered output connector 'org.apache.manifoldcf.agents.output.amazoncloudsearch.AmazonCloudSearchConnector'

Successfully registered transformation connector 'org.apache.manifoldcf.agents.transformation.tikaservice.TikaExtractor'

Successfully registered transformation connector 'org.apache.manifoldcf.agents.transformation.tika.TikaExtractor'

Successfully registered transformation connector 'org.apache.manifoldcf.agents.transformation.opennlp.OpenNlpExtractor'

Successfully registered transformation connector 'org.apache.manifoldcf.agents.transformation.nullconnector.NullConnector'

Successfully registered transformation connector 'org.apache.manifoldcf.agents.transformation.htmlextractor.HtmlExtractor'

Successfully registered transformation connector 'org.apache.manifoldcf.agents.transformation.forcedmetadata.ForcedMetadataConnector'

Successfully registered transformation connector 'org.apache.manifoldcf.agents.transformation.documentfilter.DocumentFilter'

Successfully registered transformation connector 'org.apache.manifoldcf.agents.transformation.contentlimiter.ContentLimiter'

Successfully registered mapping connector 'org.apache.manifoldcf.authorities.mappers.regexp.RegexpMapper'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.sharepoint.SharePointAuthority'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.sharepoint.SharePointADAuthority'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.nuxeo.NuxeoAuthorityConnector'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.nullauthority.NullAuthority'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.meridio.MeridioAuthority'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.ldap.LDAPAuthority'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.jira.JiraAuthorityConnector'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.jdbc.JDBCAuthority'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.generic.GenericAuthority'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.DCTM.AuthorityConnector'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.confluence.ConfluenceAuthorityConnector'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.cmis.CmisAuthorityConnector'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.amazons3.AmazonS3Authority'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.alfrescowebscript.AlfrescoAuthorityConnector'

Successfully registered authority connector 'org.apache.manifoldcf.authorities.authorities.activedirectory.ActiveDirectoryAuthority'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.wiki.WikiConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.webcrawler.WebcrawlerConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.sharepoint.SharePointRepository'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.rss.RSSConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.nuxeo.NuxeoRepositoryConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.meridio.MeridioConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.jira.JiraRepositoryConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.jdbc.JDBCConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.sharedrive.SharedDriveConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.hdfs.HDFSRepositoryConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.gridfs.GridFSRepositoryConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.googledrive.GoogleDriveRepositoryConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.generic.GenericConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.filesystem.FileConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.filenet.FilenetConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.email.EmailConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.dropbox.DropboxRepositoryConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.DCTM.DCTM'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.confluence.ConfluenceRepositoryConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.cmis.CmisRepositoryConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.amazons3.AmazonS3Connector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.alfresco.AlfrescoRepositoryConnector'

Successfully registered repository connector 'org.apache.manifoldcf.crawler.connectors.alfrescowebscript.AlfrescoConnector'

Successfully registered notification connector 'org.apache.manifoldcf.crawler.notifications.slack.SlackConnector'

Successfully registered notification connector 'org.apache.manifoldcf.crawler.notifications.rocketchat.RocketChatConnector'

Successfully registered notification connector 'org.apache.manifoldcf.crawler.notifications.email.EmailConnector'

Successfully initialized database and registered all connectors

[Shutdown thread] INFO org.apache.zookeeper.ZooKeeper - Session: 0x1690ba14da3005b closed

[main-EventThread] INFO org.apache.zookeeper.ClientCnxn - EventThread shut down for session: 0x1690ba14da3005b

[Shutdown thread] INFO org.apache.zookeeper.ZooKeeper - Session: 0x1690ba14da3005a closed

[main-EventThread] INFO org.apache.zookeeper.ClientCnxn - EventThread shut down for session: 0x1690ba14da3005a

[Shutdown thread] INFO org.apache.zookeeper.ZooKeeper - Session: 0x1690ba14da30059 closed

[main-EventThread] INFO org.apache.zookeeper.ClientCnxn - EventThread shut down for session: 0x1690ba14da30059

 

 

 

Furthermore, my MCF start from Tomcat Service and I configured  /etc/systemd/system/tomcat.service :

[Unit]

Description=Apache Tomcat Web Application Container

After=network.target

 

[Service]

Type=forking

 

Environment=JAVA_HOME= /usr/lib/jvm/java-1.11.0-openjdk-amd64

Environment=CATALINA_PID=/opt/tomcat/temp/tomcat.pid

Environment=CATALINA_HOME=/opt/tomcat

Environment=CATALINA_BASE=/opt/tomcat

Environment='CATALINA_OPTS=-Xms512M -Xmx1024M -server -XX:+UseParallelGC -Dorg.apache.manifoldcf.configfile=/opt/manifoldcf/multiprocess-zk-example-proprietary/properties.xml'

Environment='JAVA_OPTS=-Djava.awt.headless=true -Djava.security.egd=file:/dev/./urandom'

 

ExecStart=/opt/tomcat/bin/startup.sh

ExecStop=/opt/tomcat/bin/shutdown.sh

 

User=tomcat

Group=tomcat

UMask=0007

RestartSec=10

Restart=always

 

[Install]

WantedBy=multi-user.target

 

 

And I added to properties.xml:

  <libdir path="../connector-common-lib"/>

  <libdir path="../connector-lib-proprietary"/>

<!-- Inserisco per fargli vedere i jar dentro la cartella lib-proprietary -->

  <libdir path="../lib-proprietary"/>

  <!-- Any additional local properties go here -->

</configuration>

 

When I try to create a new “Repository connector”, I selected “JDBC”, after I choosed as database “ “MSSQL” I compiled server, username and password, I saved and I obtain the error:

 

Threw exception: 'Driver class not found: net.sourceforge.jtds.jdbc.Driver'

 

 

 

Da: Karl Wright <daddywri@gmail.com>
Inviato: mercoledì 20 febbraio 2019 17:06
A: user@manifoldcf.apache.org
Oggetto: Re: Threw exception: 'Driver class not found: net.sourceforge.jtds.jdbc.Driver'

 

You should be doing the following to run initialize.sh:

 

cd dist/multiprocess-zk-example-proprietary

./initialize.sh

 

The class path is pulled in from options.env.unix, which should include your jar:

>>>>>>

C:\wip\mcf\trunk\dist\multiprocess-zk-example-proprietary>more options.env.unix

-Xms512m

-Xmx512m

-Dorg.apache.manifoldcf.configfile=./properties.xml

-cp

.:../lib/mcf-core.jar:../lib/mcf-agents.jar:../lib/mcf-pull-agent.jar:../lib/hsqldb-2.3.2.jar:../lib/postgresql-42.1.3.jar:../lib/commons-codec-1.10.jar:../lib/commons-collections-3.2.1.jar:../lib/commons-collections4-4.1.jar:../lib/commons-discovery-0.5.jar:../lib/commons-el-1.0.jar:../lib/commons-exec-1.3.jar:../lib/commons-fileupload-1.3.3.jar:../lib/commons-io-2.5.jar:../lib/commons-lang-2.6.jar:../lib/commons-lang3-3.6.jar:../lib/commons-logging-1.2.jar:../lib/ecj-4.3.1.jar:../lib/gson-2.8.0.jar:../lib/guava-25.1-jre.jar:../lib/httpclient-4.5.6.jar:../lib/httpcore-4.4.10.jar:../lib/jasper-6.0.35.jar:../lib/jasper-el-6.0.35.jar:../lib/javax.servlet-api-3.1.0.jar:../lib/jna-4.3.0.jar:../lib/jna-platform-4.3.0.jar:../lib/json-simple-1.1.1.jar:../lib/jsp-api-2.1-glassfish-2.1.v20091210.jar:../lib/juli-6.0.35.jar:../lib/log4j-1.2-api-2.4.1.jar:../lib/log4j-api-2.4.1.jar:../lib/log4j-core-2.4.1.jar:../lib/mail-1.4.5.jar:../lib/serializer-2.7.1.jar:../lib/slf4j-api-1.7.25.jar:../lib/slf4j-simple-1.7.25.jar:../lib/velocity-1.7.jar:../lib/xalan-2.7.1.jar:../lib/xercesImpl-2.10.0.jar:../lib/xml-apis-1.4.01.jar:../lib/zookeeper-3.4.10.jar:../lib-proprietary/jtds-1.2.4.jar:../lib-proprietary/mariadb-java-client-1.1.7.jar:../lib-proprietary/mysql-connector-java-5.1.33.jar:

<<<<<< 

 

If it does not include your jar, it's because you did not rebuild after you placed the jar in the appropriate place.

 

Karl

 

 

On Wed, Feb 20, 2019 at 10:58 AM Karl Wright <daddywri@gmail.com> wrote:

The question is: how are you *starting* the processes?  and what process are you seeing the error from?  You should *not* need to make any changes to the configuration if you put the jar file in place before building.

 

Karl

 

 

On Wed, Feb 20, 2019 at 9:47 AM Bisonti Mario <Mario.Bisonti@vimar.com> wrote:

Thanks, Karl but I didn’t download manually the .jar files.

 

I compiled MCF 2.12 and I found the jar in the lib-proprietary folder.

 

I added in properties.xml the :

 

  <libdir path="../lib-proprietary"/>

 

I tried to :

initialize.sh the db but I have the same error.

 

 

 

 

Da: Karl Wright <daddywri@gmail.com>
Inviato: mercoledì 20 febbraio 2019 15:15
A: user@manifoldcf.apache.org
Oggetto: Re: Threw exception: 'Driver class not found: net.sourceforge.jtds.jdbc.Driver'

 

Hi Mario,

 

You can't just plop down a jar in a directory and have this work, because ManifoldCF requires all JDBC drivers to be in the root classpath.  They are therefore built into the classpath, which should happen if you use the startup scripts.  Please review the "how-to-build-and-deploy" page.

 

Karl

 

 

On Wed, Feb 20, 2019 at 9:09 AM Bisonti Mario <Mario.Bisonti@vimar.com> wrote:

 

Hallo, I would like to use MSSQL as repository.

 

I use /opt/manifoldcf/multiprocess-zk-example-proprietary/ so I added in properties.xml

.

.

  <libdir path="../lib-proprietary"/>

.

 

My MCF 2.12 was compiled by me.

In the folder:
/opt/manifoldcf/lib-proprietary I ave the files:

jtds-1.2.4.jar

mariadb-java-client-1.1.7.jar

mysql-connector-java-5.1.33.jar

jtds-1.2.4.jar

 

My tomcat startup script points to:

Environment='CATALINA_OPTS=-Xms512M -Xmx1024M -server -XX:+UseParallelGC -Dorg.apache.manifoldcf.configfile=/opt/manifoldcf/multiprocess-zk-example-proprietary/properties.xml'

 

I restarted all, but when I try to use a MSSQL repository I obtain:

Threw exception: 'Driver class not found: net.sourceforge.jtds.jdbc.Driver'

 

What could I check?

Thanks a lot

 

Mario