For those who are getting this error: "... Connection timed out", these are what I did to solve the problem: from top right change zone N. California work with me then - Go to "Security group rules" (under "Connectivity & security") - Click the item "default" Security group - Click "Actions" > "Edit inbound rules" > "Add rule" - Select... Type: "All traffic", Source: "My IP", then click "Save rules"
So glad I found Dennis Ivy. Its easy to find good Django tutorial for beginners but its hard to find solid intermediate tutorials for Django. This really helps get to the next level and see how it all comes together. Thanks
Thank you Adam :) A lot of my videos are still somewhat basic but I do plan on going into much deeper topics and advanced projects. Appreciate your comment :)
@@louzynerd129 I dont know if you have solved this already. I had the same issue but if I recall correclty you get a prompt in which you can reset your master password. That fixed it for me..
For those who are getting this error: "... Connection timed out (0x0000274C/10060)", these are what I did to solve the problem: - Go to "Security group rules" (under "Connectivity & security") - Click the item "default" Security group - Click "Actions" > "Edit inbound rules" > "Add rule" - Select... Type: "All traffic", Source: "My IP", then click "Save rules"
Why haven't I found this earlier!! Thanks Dennis, you're rocking it in the Django Community man. I've seen you in Traversy Media also. Awesome association.
Did u work on it during production? If so can u please give me tips on the configurations, which settings I must be aware of when I'm configuring, I'm sure some mistakes may prove costly. I'll be trying it soon too
Your tutorials are really very interesting, your videos are now my reference in django, thanx really man for this excellent work, hope one day see a tutorial to connect django to mangodb and work with it. thanx a lot.
I'm honed to hear that Kamal! I'll definitely make a video on this in the near future since I still primary build in django but want to switch my database to Mongo DB. I'll share after I master it.
For my lads with ubuntu or similar....you might have postgres already installed in your system....installing some other version over the existing one can create unnecessary trouble for beginners(like me).....check if you have it installed in your system already....if you want to upgrade delete the previous one or make necessary settings for proper functioning
I'm so glad YT recommended this to me. Most tutorials are about the basic stuff, default settings with sqlite. You explain how to take this from ground up to real-time, production level stuff in a crystal clear way. In one video, you introduced the viewer to both postgres and AWS effortlessly. Thanks a lot Dennis! More power to you man!
Hi Dennis, First thank you for your clear tutorials! I first tried to set this up using Azure SQL server but that was giving me a lot of problems. I added the postgres to the other ecommerce tutorial you've made. One remark with that one. When the cart is checked with the total in the form to set the order to complete the values do not match anymore. For instance 23.4 is regarded not equal to 23.40. So setting both values to the same data type (for instance float) did solve it for me.
Hi Dennis, PostgreSQL for Amazon RDS isn't free, at least not anymore. There is no option to select free tier when creating the database, and if you scroll at the bottom it will say how much a month it costs.
I got the PostgreSQL database to work, but now it wont let me log in with my existing users. How do you get the existing users into the postgreSQL database?
Getting error in linking rds to my pgadmin. Unable to connect to server: could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "xxxxxxxxxxxxxxxxxxxxxxxxxxx" (xx.xxx.xxx.xx) and accepting TCP/IP connections on port 5432?
@@danielampey9131 Could you be a little bit more specific please? What do you mean with AWS location, for example: us-east-2b? And we have to add it to which setting of the settings file? Thanks beforehand!
@@jorjolandes Ok sure. So you will add: AWS_S3_HOST = 's3.us-east-2.amazonaws.com' and AWS_S3_REGION_NAME = 'us-east-2' in your settings.py. However, 'us-east-2' is my location, you have to change to your location. I hope this solves your issue.
Thanks for this video. It has been very helpfull. I have an issue: after creating my database in aws and setting my database configuration in my project, I still getting errors while running migration. #connection error
Hi Dennis, I'm simply not able to connect the postgres to AWS. I followed all your instructions yet it says "Error Saving Properties. Unable to connect to server: timeout expired." Any ideas why I might be getting this error. Any help would be much appreciated! Thanks.
If its the error I think your getting then its probably because you forgot to allow "Public accessibility". I talk about this at 11:20. This means you haven't set permissions to access the database outside of AWS. Is this error happening when connecting from PG Admin.
@@DennisIvy First of all, thank you for putting out this great content. Been following the series since the beginning, and almost done. But I am having the same issue. I followed along and even made sure to give permission to access the database outside of AWS. I deleted the database and tried again, but still same issue. I tried finding other solutions online, but also no luck. If you have any suggestions I would appreciate it much. Thanks, and looking forward to all the good content to come.
@@DennisIvy same problem for me too UPDATE: I've solved my problem! I've uninstalled postgresql, then I've re-installed both postgresql and pgAdmin and now it works, don't ask me why. When the db in AWS is created, now I notice that my first security group type is 'CIDR/IP - Inbound', while before it was 'EC2 something'...
I also subscribed to ur channel... I liked the way u r explaining... However, I think u r missing something that matters much for understanding to minimize the error during the project using ur follow-up guidelines step-by-step by those users who are completely new to Django... The way u r explaining is quite good for those who have already evolved into Django... I do hope u will figure this out and make ur video tutorial the best one... I watched all the parts, all parts are very good enough contents and enough explanations as well... One seriously following ur guidelines will definitely develop a Django app and deploy for the production grade.....
Hi Dennis, i've been following your tutos but i wonder why for none of them, you didn't build on virtual environments. For instance getting the project to work with psycopg2 under a mac virtualenv is a nightmare
Hi Dennis, awesome content, thanks so much! Here I leave a comment in case it can help some people. I finally have my database live thanks to you :) For anyone experiencing the "timeout expired" error, which I have experienced myself, I would recommend following the documentation: aws.amazon.com/getting-started/tutorials/create-connect-postgresql-db/?nc2=type_a The main difference with this video is that you don't use existing VPC security groups, you use a new one which you can name yourself. I am not very experienced so I can't explain much. I followed the docs and solved my problem.
Thank you. Your suggestion solved my timeout issue as well. To reiterate... when creating the database, you have to select "Create New" for the "VPC security group" and then give it a name. That's the ONLY thing I did different from the video, and it works great.
Hey guys, I can't seem to install and configure postgresql and Pgadmin4 them to work. I'm using Ubuntu operaring system. Any help is appreciate. So far i've been liking the tutorials; great stuff, no ghost code, everything explained in details. Thanks Dennis
Debit card should do but I suppose you mean card in general. That's to bad, I don't know of any hosting platforms that don't require a payment method upfront.
Hi Dennis and everyone, I'm having a problem with the endpoint that I'm using because once I added it to the HostName/Address this error pops up "Unable to connect to server: could not connect to server: Connection timed out (0x0000274C/10060)" I don't know if is this about the region since I'm in the Philippines?
"The view accounts.decorators.wrapper_function didn't return an HttpResponse object. It returned None instead." This is the error showing. the wrapper_function couldn't find the Groups I created, neither admin nor customer. I once uninstalled Postgresql cause it wasn't connecting to AWS. Now the AWS issue is solved and this is the new malfunction. @Dennis do reply sir. You never replied to any of my queries.
Hi Dennis, I know this session is for connecting PostgresSQL DB to the django project. I'm working on a use case where I want to connect to an existing graph database (neo4j), and I want to incorporate some visualizations into my application. Could you address how I can combine what I've built through your course, but also connect to a separate existing graph database in django?
Hi Dennis , I am currently wondering how to estimate the fees for hosting a web app on a hosting services. I saw a lot of offers plans but I don't what the technicals terms are such as bandwidth... Do you know how to estimate the price od this kind of stuff for a lot of website in the same hosting service? For example , if the traffic increase how could we estimate the budget or the storage of images and video ? Thanks in advance your content is very clear and help us a lot.
ERROR: LINE 1: ..." ("products_id", "tag_id") VALUES (1, 1), (1, 2) ON CONFLIC... The author’s request to show how to cope with these errors, the second day I can’t continue to work normally because of migrations to Postgres! I tried everything that is described below!
hi thanks for this, i just have question. if ever in the future i want to change the name like the name of tables and models or add new tables and database, all i have to do is to rewrite the code base and migrate it again right?
Amazing you are my mentor thanks sir i have some problem for me in series toturial that is TypeError at / 'QuerySet' object is not callable when i am try to add filter my django project hes said like this
Can you please send your source code to dennisivy11@gmail.com? I’ll take a look at this for you. A screenshot of the view and template may be enough for now.
Hello, I got stuck on the user role permission of allowing only a customer or admin to view some specific parts. Is there a better way to write this? It is my first time into writing anything in django. It doesnt allow me to login as a customer, but only as admin and only in the admin section. This is piece of code is the problem "def admin_only(view_func): def wrapper_function(request, *args, **kwargs): group = None if request.user.groups.exists(): group = request.user.groups.all()[0].name if group == 'customer': return redirect('user') if group == 'admin': return view_func(request, *args, **kwargs) return wrapper_function" And results into this error [ ValueError at / The view accounts.decorators.wrapper_function didn't return an HttpResponse object. It returned None instead.] Any help will be very great
i have one doubt about ReactJs course.I m full stack django developer but i m much curious about React and how it works with django web and i want to do full course on React.if i will do some course on Reactjs and after doing it can i m able to jump to my django project directly to use react or i have to do some other course to use react in my django project?pls suggest it will be appreciable.
I'm new to these issues. I have a question. Changes made in Django for the database will now be kept on the Cloud, right? so if change something in Django, it will change on Cloud too(i am talking for database). am i wrong?
I assume there is free service without credit cards also, any tip about that? I might be para noid about creditcard fraud, but a company that only accepts local laws is one I fear have an issue with the law.
Hi guys I'm having an issue I'm getting an error during installation, something about database cluster could not be created, I am using a Windows 10 OS Thanks for your help
for newbies like me just uninstall whatever database you are using and install it again, and also check if you mispelled the 'PASSWORD' i cracked my head and found that i only have one 'S' :D
Hey Dennis, thanks for the video. Not using Python/Django, however trying to connect to RDS from Node, which is kinda similar using node-postgres. My question is why do you put 'postgres' in your database name if you have 'database-1' in your RDS and it works. Initially I used 'database-1' in my app, I got an error that my database doesn't exist. However after changing my database variable in my app to 'postgres' the connection magically worked. Can you explain what's happening or do you have any assumptions? Thank you!
after modifying database object and running command "python manage.py migrate" giving error: django.db.utils.ProgrammingError: relation "auctions_category" does not exist
thanks for the tutorials, is it okay to download psycopg2-binary? i can't install the psycopg2 in virtual environment. I read about differences between those psycopg2, one for production and the other one is for dev and test.
is the process same if we buy a different instance of postgres sql? i have bought db.t3.micro . and when i try to create server in pdAdmin it gives me error this error saying : "unable to connect to server; timeout expired" .. can u please help me out with this one. or atlease guide me on what can resolve the issue! thanks in advance!
I'm not sure why I had issues with connecting to the AWS DB from my PC, but I had to change the "Inbound" rules on AWS to allow "My IP" rather than allow any.. Maybe it's some mistake I've made along the way.
Hi Dennis! Very useful tutorial. By the way, I cannot log-in or register after migrating the database to postgres and AWS. Error shows django.contrib.auth.models.Group.DoesNotExist: Group matching query does not exist.
My one question, hope u do reply... U didn't create Virtual environment for the project, however automatically appeared at 05:52/17:08 in part-21 folder named ENV, how?
I also subscribed to ur channel... I liked the way u r explaining... However, I think u r missing something that matters much for understanding to minimize the error during the project using ur follow-up guidelines step-by-step by those users who are completely new to Django... The way u r explaining is quite good for those who have already evolved into Django... I do hope u will figure this out and make ur video tutorial the best one... I watched all the parts, all parts are very good enough contents and enough explanations as well... One seriously following ur guidelines will definitely develop a Django app and deploy for the production grade.....
In my country(India), you can use any debit card, doesn't need to be yours, and when it asks for tax details you just say don't have any. They will probably give an automated call or something to verify the account. If you stay within the free tier its all good. Check if you have something similar in your country.
After this I could enter the details in pgadmin and updated the same in settings.py. But when i ran "python manage.py" migrate it gave error as Operational error:FATAL: database does not exist. Pls advise
Unable to connect to server: FATAL: password authentication failed for user "postgres" FATAL: password authentication failed for user "postgres" I'm getting this error while creating SERVER. Please help to resolve this issue. I am using master password while creating SERVER but getting error.
@@amankumar-qs5fy stuck with the same issue, did you find the cause? It seems that the database is connected properly for some reason, when I switch back to local database to works with no problems
this shows because ip address set in rds changes all the time, so if you refresh ip address in security group rules (set again my ip) it will work. But problem is that with next computer start ip changes again. Solution is elastic iP but I don't know how to set it for rds.
for linux devs After installing postgres on the machine,do this to follow along: $ psql -U postgres -h localhost then ---> $ CREATE DATABASE OWNER postgres; ----->$\l ---> to check if database i created if the above is successful change the connection details in settings.py file and run migrations for AWS RDS: after creating the database Open the database security group in AWS; and choose "Edit inbound rules"; "Add rule". There is a "My IP" option in the dropdown menu; select that option to auto-populate with your computer's public IP address in CIDR notation and click Save rules Now if that is finished ,you will be able to connect to the RDS successfully using this command,hope u remember ur initial database name,password,username and port. -->psql --host= --port=5432 --username= --password --dbname= If the above was successful ,change the connection details and do migrations.
You can connect to other databases if you like. But the standard SQLite is not fit for running on a production environment because it is a very lightweight database and the possibilities that locks or other errors occur are not something you want to have in a production-like environment.
I'm using MacOS and ran the following command in terminal: "pip install psycopg2" and I got this error: Error: pg_config executable not found Not sure how to fix this any help would be appreciated. Thank you in advance :) Full error message " pg_config is required to build psycopg2 from source. Please add the directory containing pg_config to the $PATH or specify the full executable path with the option: python setup.py build_ext --pg-config /path/to/pg_config build ... or with the pg_config option in 'setup.cfg'. If you prefer to avoid building psycopg2 from source, please install the PyPI 'psycopg2-binary' package instead. For further information please check the 'doc/src/install.rst' file (also at ). ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output. "
I upgraded my pip using the following command in terminal: "pip install --upgrade pip" I also installed homebrew (its a packagemanager like pip) using the follwoing commandline: "/bin/bash -c "$(curl -fsSL raw.githubusercontent.com/Homebrew/install/master/install.sh)" Then I entered this into terminal and things started to work: "brew install postgresql" I hope this helps I was stuck on this for ages
For anyone receiving ERROR: Command errored out with exit status 1: I was unable to install psycog2 directly. However, I was successful in downloading the psycog2 binary file. You can follow this link to help solve your problem or reply to this comment and I'll do what I can to help. www.dark-hamster.com/programming/how-to-solve-error-on-installing-psycopg2-using-pip-by-using-psycopg2-binary-instead/