Hi, any news here? Karl On Wed, Feb 20, 2019 at 1:35 PM Karl Wright <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> 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> 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> >>> 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 <daddy...@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 <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> >>>> 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> >>>> *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.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 >>>> >>>> >>>> >>>>