manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karl Wright <daddy...@gmail.com>
Subject Re: Threw exception: 'Driver class not found: net.sourceforge.jtds.jdbc.Driver'
Date Tue, 26 Feb 2019 13:29:04 GMT
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>
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>
> *Inviato:* lunedì 25 febbraio 2019 19:36
> *A:* 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> 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> wrote:
>
> It's also possible that the jtds driver now needs another jar included as
> a dependency for working with mssql.
>
> Unfortunately, you'll probably need to figure this out on your own.
> Please let me know what you find so that I can update instructions or code.
>
>
>
> Karl
>
>
>
>
>
> On Wed, Feb 20, 2019 at 11:31 AM Karl Wright <daddywri@gmail.com> wrote:
>
> OK, you are basically having trouble with the JDBC connector, not the
> basic functioning of ManifoldCF.  That was not clear.
>
> The JDBC driver class name for MSSQL has likely been updated and we'll
> need to figure out what it got changed to.
>
>
> Karl
>
>
>
>
>
> On Wed, Feb 20, 2019 at 11:20 AM Bisonti Mario <Mario.Bisonti@vimar.com>
> wrote:
>
> Yes, infact:
>
> administrator@sengvivv01:/opt/manifoldcf/multiprocess-zk-example-proprietary$
> more options.env.unix
>
> -Xms3048m
>
> -Xmx3048m
>
> -Dorg.apache.manifoldcf.configfile=./properties.xml
>
> -cp
>
>
> .:../lib/mcf-core.jar:../lib/mcf-agents.jar:../lib/mcf-pull-agent.jar:../lib/hsqldb-2.3.2.jar:../lib/postgresql-42.1.3.jar:../lib/commons-codec-1.10.jar:../lib/commons-collections-3.2.1.jar:../l
>
>
> ib/commons-collections4-4.1.jar:../lib/commons-discovery-0.5.jar:../lib/commons-el-1.0.jar:../lib/commons-exec-1.3.jar:../lib/commons-fileupload-1.3.3.jar:../lib/commons-io-2.5.jar:../lib/common
>
>
> s-lang-2.6.jar:../lib/commons-lang3-3.6.jar:../lib/commons-logging-1.2.jar:../lib/ecj-4.3.1.jar:../lib/gson-2.8.0.jar:../lib/guava-25.1-jre.jar:../lib/httpclient-4.5.6.jar:../lib/httpcore-4.4.10.jar:../lib/jasper-6.0.35.jar:../lib/jasper-el-6.0.35.jar:../lib/javax.servlet-api-3.1.0.jar:../lib/jna-4.3.0.jar:../lib/jna-platform-4.3.0.jar:../lib/json-simple-1.1.1.jar:../lib/jsp-api-2.1-glassfish-2.1.v20091210.jar:../lib/juli-6.0.35.jar:../lib/log4j-1.2-api-2.4.1.jar:../lib/log4j-api-2.4.1.jar:../lib/log4j-core-2.4.1.jar:../lib/mail-1.4.5.jar:../lib/serializer-2.7.1.jar:../lib/slf4j-api-1.7.25.jar:../lib/slf4j-simple-1.7.25.jar:../lib/velocity-1.7.jar:../lib/xalan-2.7.1.jar:../lib/xercesImpl-2.10.0.jar:../lib/xml-apis-1.4.01.jar:../lib/zookeeper-3.4.10.jar:..
> /lib-proprietary/jtds-1.2.4.jar
> :../lib-proprietary/mariadb-java-client-1.1.7.jar:../lib-proprietary/mysql-connector-java-5.1.33.jar:
>
>
>
>
>
> And:
>
> administrator@sengvivv01:/opt/manifoldcf/multiprocess-zk-example-proprietary$
> sudo -u tomcat ./initialize.sh
>
> [sudo] password for administrator:
>
> Configuration file successfully read
>
> [main] INFO org.apache.zookeeper.ZooKeeper - Client
> environment:zookeeper.version=3.4.10-39d3a4f269333c922ed3db283be479f9deacaa0f,
> built on 03/23/2017 10:13 GMT
>
> [main] INFO org.apache.zookeeper.ZooKeeper - Client environment:host.name
> <https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fhost.name&data=01%7C01%7CMario.Bisonti%40vimar.com%7C1aec138b5ed94a30a34f08d69b502f7f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=FwrV5aeylq9HkVDB3%2F9q3RcLUk3I6nsmQhA7wttCgbw%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%7C1aec138b5ed94a30a34f08d69b502f7f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=gSIa4Xh3hszg0JQEhuyahqxCdTSquGKpe6NGV9Tr1A0%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%7C1aec138b5ed94a30a34f08d69b502f7f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=Ccs6%2BZ1Z3ZJvNX%2Bxl3MQEwrdjRKKhtDHxXwYkj%2Bp0ag%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%7C1aec138b5ed94a30a34f08d69b502f7f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=OGAZdU0NEd2s%2FAIxRM9ESndF8H7DMoPTOR49Hc6aRr8%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
>
> [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
> <https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2F127.0.0.1%3A8349&data=01%7C01%7CMario.Bisonti%40vimar.com%7C1aec138b5ed94a30a34f08d69b502f7f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=6tLzBz3VypNfsHK4WITqeHzbsy3TX%2FuBNwFU3iToxzU%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%7C1aec138b5ed94a30a34f08d69b502f7f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=6tLzBz3VypNfsHK4WITqeHzbsy3TX%2FuBNwFU3iToxzU%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%7C1aec138b5ed94a30a34f08d69b502f7f%7Ca1f008bcd59b4c668f8760fd9af15c7f%7C1&sdata=6tLzBz3VypNfsHK4WITqeHzbsy3TX%2FuBNwFU3iToxzU%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>
> *Inviato:* mercoledì 20 febbraio 2019 17:06
> *A:* user@manifoldcf.apache.org
> *Oggetto:* Re: Threw exception: 'Driver class not found:
> net.sourceforge.jtds.jdbc.Driver'
>
>
>
> You should be doing the following to run initialize.sh:
>
>
>
> cd dist/multiprocess-zk-example-proprietary
>
> ./initialize.sh
>
>
>
> The class path is pulled in from options.env.unix, which should include
> your jar:
>
> >>>>>>
>
> C:\wip\mcf\trunk\dist\multiprocess-zk-example-proprietary>more
> options.env.unix
>
> -Xms512m
>
> -Xmx512m
>
> -Dorg.apache.manifoldcf.configfile=./properties.xml
>
> -cp
>
>
> .:../lib/mcf-core.jar:../lib/mcf-agents.jar:../lib/mcf-pull-agent.jar:../lib/hsqldb-2.3.2.jar:../lib/postgresql-42.1.3.jar:../lib/commons-codec-1.10.jar:../lib/commons-collections-3.2.1.jar:../lib/commons-collections4-4.1.jar:../lib/commons-discovery-0.5.jar:../lib/commons-el-1.0.jar:../lib/commons-exec-1.3.jar:../lib/commons-fileupload-1.3.3.jar:../lib/commons-io-2.5.jar:../lib/commons-lang-2.6.jar:../lib/commons-lang3-3.6.jar:../lib/commons-logging-1.2.jar:../lib/ecj-4.3.1.jar:../lib/gson-2.8.0.jar:../lib/guava-25.1-jre.jar:../lib/httpclient-4.5.6.jar:../lib/httpcore-4.4.10.jar:../lib/jasper-6.0.35.jar:../lib/jasper-el-6.0.35.jar:../lib/javax.servlet-api-3.1.0.jar:../lib/jna-4.3.0.jar:../lib/jna-platform-4.3.0.jar:../lib/json-simple-1.1.1.jar:../lib/jsp-api-2.1-glassfish-2.1.v20091210.jar:../lib/juli-6.0.35.jar:../lib/log4j-1.2-api-2.4.1.jar:../lib/log4j-api-2.4.1.jar:../lib/log4j-core-2.4.1.jar:../lib/mail-1.4.5.jar:../lib/serializer-2.7.1.jar:../lib/slf4j-api-1.7.25.jar:../lib/slf4j-simple-1.7.25.jar:../lib/velocity-1.7.jar:../lib/xalan-2.7.1.jar:../lib/xercesImpl-2.10.0.jar:../lib/xml-apis-1.4.01.jar:../lib/zookeeper-3.4.10.jar:../lib-proprietary/jtds-1.2.4.jar:../lib-proprietary/mariadb-java-client-1.1.7.jar:../lib-proprietary/mysql-connector-java-5.1.33.jar:
>
> <<<<<<
>
>
>
> If it does not include your jar, it's because you did not rebuild after
> you placed the jar in the appropriate place.
>
>
>
> Karl
>
>
>
>
>
> On Wed, Feb 20, 2019 at 10:58 AM Karl Wright <daddywri@gmail.com> wrote:
>
> The question is: how are you *starting* the processes?  and what process
> are you seeing the error from?  You should *not* need to make any changes
> to the configuration if you put the jar file in place before building.
>
>
>
> Karl
>
>
>
>
>
> On Wed, Feb 20, 2019 at 9:47 AM Bisonti Mario <Mario.Bisonti@vimar.com>
> wrote:
>
> Thanks, Karl but I didn’t download manually the .jar files.
>
>
>
> I compiled MCF 2.12 and I found the jar in the lib-proprietary folder.
>
>
>
> I added in properties.xml the :
>
>
>
>   <libdir path="../lib-proprietary"/>
>
>
>
> I tried to :
>
> initialize.sh the db but I have the same error.
>
>
>
>
>
>
>
>
>
> *Da:* Karl Wright <daddywri@gmail.com>
> *Inviato:* mercoledì 20 febbraio 2019 15:15
> *A:* user@manifoldcf.apache.org
> *Oggetto:* Re: Threw exception: 'Driver class not found:
> net.sourceforge.jtds.jdbc.Driver'
>
>
>
> Hi Mario,
>
>
>
> You can't just plop down a jar in a directory and have this work, because
> ManifoldCF requires all JDBC drivers to be in the root classpath.  They are
> therefore built into the classpath, which should happen if you use the
> startup scripts.  Please review the "how-to-build-and-deploy" page.
>
>
>
> Karl
>
>
>
>
>
> On Wed, Feb 20, 2019 at 9:09 AM Bisonti Mario <Mario.Bisonti@vimar.com>
> wrote:
>
>
>
> Hallo, I would like to use MSSQL as repository.
>
>
>
> I use /opt/manifoldcf/multiprocess-zk-example-proprietary/ so I added in
> properties.xml
>
> .
>
> .
>
>   <libdir path="../lib-proprietary"/>
>
> .
>
>
>
> My MCF 2.12 was compiled by me.
>
> In the folder:
> /opt/manifoldcf/lib-proprietary I ave the files:
>
> jtds-1.2.4.jar
>
> mariadb-java-client-1.1.7.jar
>
> mysql-connector-java-5.1.33.jar
>
> jtds-1.2.4.jar
>
>
>
> My tomcat startup script points to:
>
> Environment='CATALINA_OPTS=-Xms512M -Xmx1024M -server -XX:+UseParallelGC
> -Dorg.apache.manifoldcf.configfile=/opt/manifoldcf/multiprocess-zk-example-proprietary/properties.xml'
>
>
>
> I restarted all, but when I try to use a MSSQL repository I obtain:
>
> Threw exception: 'Driver class not found: net.sourceforge.jtds.jdbc.Driver'
>
>
>
> What could I check?
>
> Thanks a lot
>
>
>
> Mario
>
>
>
>

Mime
View raw message