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 Mon, 25 Feb 2019 18:36:21 GMT
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=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 <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