Hi Mario, Register and log in, and then you can attach a comment.
Karl On Tue, Sep 16, 2014 at 8:34 AM, Bisonti Mario <[email protected]> wrote: > MySql Version : '5.5.38' > > > > ManifoldCF : 1.7 > > > > The problem still remains with single quote ‘ ‘ > > > > How could I attach a comment to the ticket, please? > > > > > > *Mario* > > > > > > > > > > *Da:* Karl Wright [mailto:[email protected]] > *Inviato:* martedì 16 settembre 2014 14:05 > > *A:* [email protected] > *Oggetto:* Re: Connection status:Threw exception: 'Driver class not > found: com.mysql.jdbc.Driver' > > > > Hi Mario, > > I've create CONNECTORS-1032 to track your issue. MySQL queries have > worked fine in the past against MySQL 5.5. So I suggest that you try > single-quotes, and if that does not work either, we're going to have to > have more information and some debugging time. > > First -- what version of MySQL is this? > Second, what version of MCF are you working with? > > I will propose a debugging output patch that will let us see what the > column names the JDBC query is returning if I have that information. > Please attach it as a comment to the ticket. > > Thanks, > Karl > > > > On Tue, Sep 16, 2014 at 7:59 AM, Bisonti Mario <[email protected]> > wrote: > > Yes, it works, and “ “ aren’t necessary. > > > > Note this: > from MySql Client > > SELECT command_id AS $(IDCOLUMN) FROM icinga_commands > not work > instead > SELECT command_id AS “$(IDCOLUMN)” FROM icinga_commands > > Works. > > So it seems that “ “ are necessary, but when I use insiede ManifoldCF it > doesn’t work with “ “ > > > > > > Mario > > > > > > > > *Da:* Karl Wright [mailto:[email protected]] > *Inviato:* martedì 16 settembre 2014 13:50 > > > *A:* [email protected] > *Oggetto:* Re: Connection status:Threw exception: 'Driver class not > found: com.mysql.jdbc.Driver' > > > > Hi Mario, > > What's happening is that the JDBC connector cannot find the proper column > in the resultset. > > Can you do the following in the mysql client: > > SELECT command_id AS lcf__id FROM icinga_commands > > Please let me know what the returned columns are. If there is not a > column that precisely matches "lcf__id" then that explains the error. > > Karl > > > > On Tue, Sep 16, 2014 at 7:41 AM, Bisonti Mario <[email protected]> > wrote: > > Yes, but I obtained the same error. > > > > SELECT command_id AS “$(IDCOLUMN)” FROM icinga_commands > > I tried the query SELECT command_id AS $(IDCOLUMN) FROM icinga_commands > by a MySql Client and it works. > > > > > > > > > > > > > > > > *Da:* Karl Wright [mailto:[email protected]] > *Inviato:* martedì 16 settembre 2014 12:17 > > > *A:* [email protected] > *Oggetto:* Re: Connection status:Threw exception: 'Driver class not > found: com.mysql.jdbc.Driver' > > > > Hi Mario, > > Did you try putting quotes in your query around "$(IDCOLUMN)" as it > suggests? For some databases this is necessary to preserve case properly. > > Karl > > > > On Tue, Sep 16, 2014 at 4:53 AM, Bisonti Mario <[email protected]> > wrote: > > When I start a test job to extract a table I obtain: > > > > Error: Bad seed query; doesn't return $(IDCOLUMN) column. Try using quotes > around $(IDCOLUMN) variable, e.g. "$(IDCOLUMN)". > > > > My configuration: > > > > Seeding query: > > SELECT command_id AS $(IDCOLUMN) FROM icinga_commands > > > > Data query: > SELECT command_id AS $(IDCOLUMN), command_line AS $(URLCOLUMN),object_id > AS $(DATACOLUMN) FROM icinga_commands where command_id IN $(IDLIST) > > > > What could I check? > > > > Thanks a lot > > > > Mario > > > > > > *Da:* Bisonti Mario > *Inviato:* martedì 16 settembre 2014 09:58 > *A:* '[email protected]' > *Oggetto:* R: Connection status:Threw exception: 'Driver class not found: > com.mysql.jdbc.Driver' > > > > Thanks a lot! > > > > Connection now is working! > > > > Mario > > > > > > > > *Da:* Karl Wright [mailto:[email protected] <[email protected]>] > *Inviato:* lunedì 15 settembre 2014 16:26 > > > *A:* [email protected] > *Oggetto:* Re: Connection status:Threw exception: 'Driver class not > found: com.mysql.jdbc.Driver' > > > > Hi Mario, > > You can download the -src and -lib distribution, and then run "ant > make-deps build", and you should be able to use proprietary MySQL database > connections. > > Thanks, > Karl > > > > On Mon, Sep 15, 2014 at 10:24 AM, Bisonti Mario <[email protected]> > wrote: > > I understood. > > > > Infact, I haven’t example-proprietary because I use a binary version of > ManifoldCF so i can’t use MySQL as repository connection. > > > > Thanks a lot. > > > > > > > > > > *Da:* Karl Wright [mailto:[email protected]] > *Inviato:* lunedì 15 settembre 2014 16:21 > > > *A:* [email protected] > *Oggetto:* Re: Connection status:Threw exception: 'Driver class not > found: com.mysql.jdbc.Driver' > > > > Hi Mario, > > cd /usr/share/manifoldcf/example-proprietary > sudo java –jar start.jar > > If you do not have example-proprietary, it is because you did not actually > build ManifoldCF yourself. In order to use MySQL as a backend, you must > build ManifoldCF yourself. > > Thanks, > Karl > > > > On Mon, Sep 15, 2014 at 10:14 AM, Bisonti Mario <[email protected]> > wrote: > > I am on > > /usr/share/manifoldcf/example/ > > and I execute: sudo java –jar start.jar > > > > Instead *mysql-connector-java-5.1.32-bin.jar is in > /usr/share/manifoldcf/connector-lib-proprietary/* > > *So, how could I run ManifoldCF ?* > > *Excuse me but I am not a linux expertise…* > > *Thanks a lot.* > > > > > > > > *Da:* Karl Wright [mailto:[email protected]] > *Inviato:* lunedì 15 settembre 2014 16:04 > *A:* [email protected] > *Oggetto:* Re: Connection status:Threw exception: 'Driver class not > found: com.mysql.jdbc.Driver' > > > > Hi Mario, > > You need to run ManifoldCF out of one of the example-proprietary > directories in order for it to pick up the mysql jar in the classpath. > > Thanks, > Karl > > > > On Mon, Sep 15, 2014 at 9:32 AM, Bisonti Mario <[email protected]> > wrote: > > > > > > *Hallo.* > > > > *I tried to setup a mysql repository connection but I obtain the error > mentioned.* > > > > *I put mysql-connector-java-5.1.32-bin.jar in * > > */apache-manifoldcf-1.7/connector-lib-proprietary* > > *and* > > */apache-manifoldcf-1.7/lib-proprietary* > > *folder but I obtain the error in the object* > > > > *What could I check?* > > > > *Thanks a lot* > > > > *Mario* > > > > > > > > > > > > >
