Great !!!!! The problem wasn’t about the driver! Your suggestion illuminated me!
It isn’t necessary to add to proprierty.xml the lib-proprietary folder, my problem was that I deployed in Tomcat: /opt/manifoldcf/web/war/mcf-api-service.war /opt/manifoldcf/web/war/mcf-authority-service.war /opt/manifoldcf/web/war/mcf-crawler-ui.war So, I undeployed the above .war and deployed: /opt/manifoldcf/web-proprietary/war/mcf-api-service.war /opt/manifoldcf/web-proprietary/war/mcf-authority-service.war /opt/manifoldcf/web-proprietary/war/mcf-crawler-ui.war And It works!!! Yeaaaah! Thanks a lot! Mario Da: Karl Wright <daddy...@gmail.com> Inviato: martedì 26 febbraio 2019 14:29 A: user@manifoldcf.apache.org Oggetto: Re: Threw exception: 'Driver class not found: net.sourceforge.jtds.jdbc.Driver' The UI web interface finds the jar in the deployed war file. If you are not using the proprietary war, it will not contain the jtds jar. Since you aren't seeing this error in the log for the java-agents process, I bet that's what you did. Karl On Tue, Feb 26, 2019 at 2:55 AM Bisonti Mario <mario.biso...@vimar.com<mailto:mario.biso...@vimar.com>> wrote: Hi Karl. The only message that I obtain from the UI web interface, is 'Driver class not found: net.sourceforge.jtds.jdbc.Driver', in the manifoldcf.log no info, so, I don’t know how could I investigate on it. Me too I obtain: /opt/manifoldcf/lib-proprietary$jar -tf jtds-1.2.4.jar | grep Driver net/sourceforge/jtds/jdbc/Driver.class What could I try to solve the issue? Thanks a lot Mario Da: Karl Wright <daddy...@gmail.com<mailto:daddy...@gmail.com>> Inviato: lunedì 25 febbraio 2019 19:36 A: user@manifoldcf.apache.org<mailto:user@manifoldcf.apache.org> Oggetto: Re: Threw exception: 'Driver class not found: net.sourceforge.jtds.jdbc.Driver' Hi, any news here? Karl On Wed, Feb 20, 2019 at 1:35 PM Karl Wright <daddy...@gmail.com<mailto:daddy...@gmail.com>> wrote: 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 <daddy...@gmail.com<mailto:daddy...@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 <daddy...@gmail.com<mailto:daddy...@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.biso...@vimar.com<mailto:mario.biso...@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<https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fhost.name&data=01%7C01%7CMario.Bisonti%40vimar.com%7C0246b1d400b449aaede808d69bee6c6f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=cPFKTCq%2FEbzjBbLFr3THJJMk%2FogZebJu32BmhRHYIpE%3D&reserved=0>=sengvivv01.vimar.net<https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fsengvivv01.vimar.net&data=01%7C01%7CMario.Bisonti%40vimar.com%7C0246b1d400b449aaede808d69bee6c6f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=LsoyWD7gZ54ATuU1ZuVky8Ln00Qjs8xCyVIpY%2BpRrp4%3D&reserved=0> [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<https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fos.name&data=01%7C01%7CMario.Bisonti%40vimar.com%7C0246b1d400b449aaede808d69bee6c6f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=bQTboJlzzg2OkFk2FP2yHwPgFLrM1dXkiOIkW9EgzjM%3D&reserved=0>=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<https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fuser.name&data=01%7C01%7CMario.Bisonti%40vimar.com%7C0246b1d400b449aaede808d69bee6c6f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=%2BCREQcm%2BTbnSr55lT%2FbaSFtEi4gDgZF9cCrqASjBWEY%3D&reserved=0>=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<mailto: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<mailto: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<mailto: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<https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2F127.0.0.1%3A8349&data=01%7C01%7CMario.Bisonti%40vimar.com%7C0246b1d400b449aaede808d69bee6c6f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=wfP2X%2BI11WH3BaN4Y2s6uxVpJSSfLE8xOE4a%2FdcI5kU%3D&reserved=0>. 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<https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2F127.0.0.1%3A8349&data=01%7C01%7CMario.Bisonti%40vimar.com%7C0246b1d400b449aaede808d69bee6c6f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=wfP2X%2BI11WH3BaN4Y2s6uxVpJSSfLE8xOE4a%2FdcI5kU%3D&reserved=0>, initiating session [main-SendThread(localhost.localdomain:8349)] INFO org.apache.zookeeper.ClientCnxn - Session establishment complete on server localhost.localdomain/127.0.0.1:8349<https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2F127.0.0.1%3A8349&data=01%7C01%7CMario.Bisonti%40vimar.com%7C0246b1d400b449aaede808d69bee6c6f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=wfP2X%2BI11WH3BaN4Y2s6uxVpJSSfLE8xOE4a%2FdcI5kU%3D&reserved=0>, 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 <daddy...@gmail.com<mailto:daddy...@gmail.com>> Inviato: mercoledì 20 febbraio 2019 17:06 A: user@manifoldcf.apache.org<mailto: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 <daddy...@gmail.com<mailto:daddy...@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.biso...@vimar.com<mailto:mario.biso...@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 <daddy...@gmail.com<mailto:daddy...@gmail.com>> Inviato: mercoledì 20 febbraio 2019 15:15 A: user@manifoldcf.apache.org<mailto: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.biso...@vimar.com<mailto:mario.biso...@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
