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 <[email protected]> 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 <[email protected]> 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 <[email protected]> >> 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 <[email protected]> >>> *Inviato:* mercoledì 20 febbraio 2019 17:06 >>> *A:* [email protected] >>> *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 <[email protected]> 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 <[email protected]> >>> 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 <[email protected]> >>> *Inviato:* mercoledì 20 febbraio 2019 15:15 >>> *A:* [email protected] >>> *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 <[email protected]> >>> 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 >>> >>> >>> >>>
