You might need to quote the string with single quotes, otherwise bash will 
probably try and interpolate a var `$n`...

> On 4 Mar 2022, at 15.58, Lawrence Krubner <lawre...@virtalabs.com> wrote:
> 
> 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 
> <http://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 
> <http://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 ore...@orestis.gr 
> <applewebdata://6BFE88BD-3B9F-4213-AF74-7F0072BCBAF4> 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 <lawr...@virtalabs.com <>> 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 red...@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 
>> <http://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 
>> <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 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 
>> <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/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 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 
> <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 
> <mailto:clojure+unsubscr...@googlegroups.com>.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/clojure/d2f7ee47-097d-438b-9d94-ee8bd2b3662cn%40googlegroups.com
>  
> <https://groups.google.com/d/msgid/clojure/d2f7ee47-097d-438b-9d94-ee8bd2b3662cn%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/AC093886-FAE2-4969-B344-8B5169691679%40orestis.gr.

Reply via email to