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.
