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.