But, again, I can connect from the cli using my terminal. I'm using my
Spectrum connection to the Internet in both cases. If I run the app on my
laptop, or I connect from the terminal, using the CLI, then in all cases
I'm connecting over my Spectrum connection to the Internet. If MySQL was
going to block one, then it would block the other, yes? I think the issue
must have something to do with the Clojure code, since that is the only
difference. I mean, if I do "java -jar user.jar" in the same terminal
window, it fails, but then in that same terminal window I can connect to
RDS without a problem using the CLI.
On Thursday, March 3, 2022 at 3:26:31 PM UTC-5 redc...@gmail.com wrote:
> That is a message from MySQL, not next.jdbc.
>
> MySQL allows you to grant permissions to a user base on the host they are
> connecting from so permission denied kinds of errors include the username
> and the host the users connection came from.
>
> On Thu, Mar 3, 2022, 11:18 Lawrence Krubner <lawr...@virtalabs.com> wrote:
>
>> I just wrote a small app that needs to connect to a MySQL app. I was
>> running it on my laptop, connecting to MySQL on the laptop, and everything
>> was working fine. Then I wanted to connect to one of our test databases in
>> RDS in AWS. I've a simple function that finds the environment variables and
>> returns them as a map:
>>
>> (defn get-config
>> []
>> (check-config)
>> {
>> :dbtype "mysql"
>> :dbname (System/getenv "DATABASE_NAME")
>> :user (System/getenv "DATABASE_USER")
>> :password (System/getenv "DATABASE_PASSWORD")
>> :host (System/getenv "DATABASE_HOST")
>> })
>>
>> This is used simply:
>> ds (jdbc/get-datasource (get-config))
>>
>> I've checked the environment values several times and they are correct.
>> But when the code tries to write to the RDS database, I get:
>>
>> *java.sql.SQLException*: *Access denied for user
>> 'pulseuser'@'cpe-74-71-234-49.nyc.res.rr.com
>> <http://cpe-74-71-234-49.nyc.res.rr.com>' (using password: YES)*
>>
>> I am connecting to the Internet through Spectrum, and apparently "rr.com"
>> is Spectrum. I'm confused, why would next.jdbc use this info? Did I forget
>> some important value in the hash map?
>>
>> From my laptop, I can reach the RDS database using the MySQL CLI, so
>> there are no problems with connectivity. I whitelisted the IP address of my
>> house. This is something specific about what next.jdbc needs in that hash
>> map, I think.
>>
>>
>> --
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/clojure/eadd7b66-d19d-41e8-b02d-76185de0778dn%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/clojure/eadd7b66-d19d-41e8-b02d-76185de0778dn%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/clojure/9e58a686-29fb-43d4-af41-2cf0345425c6n%40googlegroups.com.
