manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bisonti Mario <Mario.Biso...@vimar.com>
Subject R: Threw exception: 'Driver class not found: net.sourceforge.jtds.jdbc.Driver'
Date Tue, 26 Feb 2019 14:36:35 GMT
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 <daddywri@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.Bisonti@vimar.com<mailto:Mario.Bisonti@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 <daddywri@gmail.com<mailto:daddywri@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 <daddywri@gmail.com<mailto:daddywri@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 <daddywri@gmail.com<mailto: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<mailto: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<mailto: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<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 <daddywri@gmail.com<mailto:daddywri@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 <daddywri@gmail.com<mailto: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<mailto: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<mailto:daddywri@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.Bisonti@vimar.com<mailto: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

Mime
View raw message