Okay, this seems to have to do with characters acting as wildcards in the
password itself. This is in the .env file:
vvv*8Ezr30R%$n?L5!
but printlin in the Clojure code outputs:
vvv*8Ezr30R%?L5!
The "$n" simply vanishes.
Why is that? This is not a regular expression. I didn't think plain strings
in Clojure would be interpreted like this.
Or is this how bash interprets it?
On Friday, March 4, 2022 at 8:06:56 AM UTC-5 Lawrence Krubner wrote:
> So, as a new way to test this, I've ssh'ed to an EC2 instance that is in
> the same VCP as the RDS database. I upload my jar file so I can run it on
> this EC2 instance.
>
> println the hash map at startup:
>
> {:dbtype mysql, :dbname pulsedata, :user pulseuser, :password xxxx, :host
> pulse-data.cclr8stksfch.us-west-2.rds.amazonaws.com}
> This gets me the above error. But if I copy and paste the values and use
> them with the mysql client:
>
> mysql -u pulseuser -h pulse-data.cclr8stksfch.us-west-2.rds.amazonaws.com
> -p pulsedata
>
> I am able to log in. This is in the same terminal window: the MySQL
> client, at the command line in my terminal, logs me into MySQL, but "java
> -jar user.jar" in the same terminal window gives me this error, about me
> being rejected. I am copying and pasting the same values for user and host
> and password.
>
> It has to be something about the Clojure code.
>
>
> On Friday, March 4, 2022 at 6:35:59 AM UTC-5 [email protected] wrote:
>
>> The error message indicates that you connect with user `pulseuser` - is
>> that the expected user?
>>
>> I would print out the configuration that you’re passing in to jdbc.next
>> to be absolutely certain it contains the values you expect it does.
>>
>> When you say “cli”, do you mean a mysql client? Double check the
>> credentials (dbname, user, password) that *it* uses.
>>
>> Best,
>> Orestis
>>
>> On 4 Mar 2022, at 13.27, Lawrence Krubner <[email protected]> wrote:
>>
>> 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 [email protected] 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 <[email protected]>
>>> 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 [email protected]
>>>> Note that posts from new members are moderated - please be patient with
>>>> your first post.
>>>> To unsubscribe from this group, send email to
>>>> [email protected]
>>>> 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 [email protected].
>>>> 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 [email protected]
>> Note that posts from new members are moderated - please be patient with
>> your first post.
>> To unsubscribe from this group, send email to
>> [email protected]
>> 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 [email protected].
>>
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/clojure/9e58a686-29fb-43d4-af41-2cf0345425c6n%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/clojure/9e58a686-29fb-43d4-af41-2cf0345425c6n%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 [email protected]
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/clojure/d2f7ee47-097d-438b-9d94-ee8bd2b3662cn%40googlegroups.com.
