Jump to content

bee1

Members
  • Posts

    28
  • Joined

  • Last visited

bee1's Achievements

Apprentice

Apprentice (3/14)

  • Collaborator Rare
  • First Post Rare
  • Conversation Starter Rare
  • One Year In Rare
  • Week One Done Rare

Recent Badges

0

Reputation

  1. Hi, I have just created a new postgres db for my account and trying to access it via PGAdmin but getting connection failure errors. When someone has a moment can they please look into enabling remote login, I believe I needed to request it in the past as well. db name: bee1_swarm_report users who should have access: bee1_hive_user, bee1_sensor_user_postgres, bee1_swarm_master Can you provide the hostname / IP for remote connection as well please. Thank you!
  2. Works great - thank you! Much appreciated for the help!!
  3. @Krydos - actually I can't login at all now, it says I have an invalid login
  4. Hi, I am looking to have my account unarchived please. Let me know what information you need.
  5. Yea no worries, I'll find another data visualization service, I appreciate all the assistance, thank you!
  6. No I've been trying for the past day and doing some troubleshooting but I am not sure it will work. I found on their FAQ that they only support up through Version 12, and from my understanding HelioHost is using 13.x, correct? https://support.google.com/looker-studio/answer/7288010#how-to-connect-to-postgresql&zippy=%2Cin-this-article
  7. Hey @Krydos Circling back to the original post on this thread. I was not able to get that database to work, so I created a new database 'bee1_hives' with the user 'bee1_hive_user'. The bee1_hives db now works and I am currently submitting data into it. My next dilemma is that I used to be able to connect a postgres db to Google Data Studio, but when I try to connect this new db I am getting an error on connection (there is no record of what their error codes mean unfortunately). I am trying to troubleshoot this, so I guess my question and thoughts are... - The bee1_hive_user is able to submit data into the db, but is there an additional permission which needs to be enabled for remote connection, reading? - Do you need to allow connection from the Google Data Studio IPs? If so these are the IPs I need opened please, if possible. 142.251.74.0/23 142.251.74.0/23 2001:4860:4807::/48 (Optional, for platforms that support IPv6) 74.125.0.0/16 Reference Article: https://support.google.com/looker-studio/answer/11521624?visit_id=638028271131359562-3095635232&p=jdbc-ip-23&rd=1#jul-14-2022
  8. Thank you, this is working now!
  9. Also, once the above has been granted, will I be able to create a table in the database?
  10. Hi, I have just created a new db for my account called 'bee1_hives'. Can you please... 1. Open access for the new user as well 'bee1_hive_user' for insert and read permissions AND 2. Open access so I can remote into it with PGAdmin please? Thank you!
  11. Hey, So - I've tried all sorts of way to get this to work and it is just not getting there, haha. I am going to create a new table and see if I can commit into that and then check back in with you, I appreciate the help so far!
  12. Hey @Krydos, I am still getting this error.... psycopg2.errors.UndefinedTable: relation "bee_data_table" does not exist LINE 1: INSERT INTO bee_data_table (beekeeper_id, sensor_id, hive_te... There is a little carrot ^ under the "b" of "bee_data_table" on the LINE 1 Here is what I am trying to insert: INSERT INTO bee_data_table (beekeeper_id, sensor_id, hive_temp, hive_hum, weather_temp, weather_hum, time_taken) VALUES (ian, 2, 10, 10, 10, 10, 2020-09-29 13:07:09) I am using the bee1_sensor_user, into the bee1_sensor_data DB Any thoughts would be appreciated, thanks!
  13. Hey @Krydos, Thanks for your help on the above IP address correction. It seems I am still having an issue. I can connect to the database but it says my tables do not exist. I am trying to insert into the "bee_data_table" with the "bee1_sensor_user". Does this user have insert rights?
  14. Hey Krydos, Sorry for the lack of response on this - I've been trying to troubleshoot this but I still cannot commit data into the database. Since my account was moved to Plesk did the IP change? Right now I have it pointing to 65.19.143.6 - is that still correct?
×
×
  • Create New...