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]<mailto:[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]<mailto:[email protected]>] Inviato: martedì 16 settembre 2014 12:17 A: [email protected]<mailto:[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]<mailto:[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]<mailto:[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]] Inviato: lunedì 15 settembre 2014 16:26 A: [email protected]<mailto:[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]<mailto:[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]<mailto:[email protected]>] Inviato: lunedì 15 settembre 2014 16:21 A: [email protected]<mailto:[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]<mailto:[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]<mailto:[email protected]>] Inviato: lunedì 15 settembre 2014 16:04 A: [email protected]<mailto:[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]<mailto:[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
