Thanks Shantanu for the response. I installed dbvisualizer and it seems to work perfectly fine with infobright.
On Mon, May 2, 2016 at 1:04 PM, Shantanu Kumar <kumar.shant...@gmail.com> wrote: > Could you try connecting to InfoBright using DbVisualizer? It is a Java > based tool and any differences w.r.t. the MySQL JDBC driver would be > evident if it fails to work with DbVisualizer. > > https://www.dbvis.com/ > > Shantanu > > > On Monday, 2 May 2016 12:48:16 UTC+5:30, Sunil Nandihalli wrote: >> >> Hi Everybody, >> I have tried to connect to infobrite server using clojure.java.jdbc . >> Infobrite server is supposed to be identical to mysql in terms of the >> protocol. I have successfully used mysqlworkbench to talk to it. When I try >> to connect to the infobrite server using clojure.java.jdbc, I get the >> following exception >> >> java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is >> required >> >> however if I use the exact same code to query a mysql db it works >> perfectly fine. Can somebody help please me with this? >> Thanks and regards, >> Sunil. >> >> The code i use is >> >> (ns cpi.core >> (:require [clojure.java.jdbc :as jdbc] >> [clojure.string :as s])) >> >> (defn run-query [{:keys [url user password db] :as cnf} & qs] >> (println qs) >> (println cnf) >> (jdbc/with-db-connection [db-conn {:classname "com.mysql.jdbc.Driver" >> :subprotocol "mysql" >> :subname (str "//" url "/" db) >> :user user >> :password password}] >> (jdbc/query db-conn qs))) >> > -- > You received this message because you are subscribed to the Google > Groups "Clojure" group. > To post to this group, send email to clojure@googlegroups.com > Note that posts from new members are moderated - please be patient with > your first post. > To unsubscribe from this group, send email to > clojure+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/clojure?hl=en > --- > You received this message because you are subscribed to the Google Groups > "Clojure" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to clojure+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Clojure" group. To post to this group, send email to clojure@googlegroups.com Note that posts from new members are moderated - please be patient with your first post. To unsubscribe from this group, send email to clojure+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/clojure?hl=en --- You received this message because you are subscribed to the Google Groups "Clojure" group. To unsubscribe from this group and stop receiving emails from it, send an email to clojure+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
