connecting to infobrite server from clojure

[Sunil S Nandihalli]

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)))

[Shantanu Kumar]

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

[Sunil S Nandihalli]

Thanks Shantanu for the response. I installed dbvisualizer and it seems to work perfectly fine with infobright. 

--
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to clo...@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+u...@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+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Sunil S Nandihalli]

Hi Shantanu,

 I am attaching the error stack trace of the exception I got. I am still unable to figure out what is happening.

Thanks,

sunil.

[Sunil S Nandihalli]

Hi Shantanu,

 Thanks for the inputs. I was able to resolve the problem by changing the version of mysql-java-connector library to 5.1.29. I was previously using 6.0.2 (latest). 

Regards,

Sunil