Re: What user does django server runs?
Well, I solved my connection problems. It seems I had two versions of PostgreSQL installed and I had created the database with one version and was running the server with the other version. When I used the "createdb" command for both versions, one of them said that the database was corrupt. So I removed the database and recreated it with the newest PostgreSQL and suddenly everything worked! I had some problems getting PostgreSQL to work when I installed it, so I tried several source codes and packages before it worked. That's probably why I had two different versions. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: What user does django server runs?
On Jan 2, 6:48 pm, "Michel Thadeu Sabchuk" <[EMAIL PROTECTED]> wrote: > I'm deploying a django project with postgresql as database backend. I > used to create a local user with the same name of the database user > (owner of the database), so I just need to run the webserver as the > local user and the database should work without problems (this was true > for webware). I try to run django as the local user and hit the page > without success, the error message tells me: FATAL: Ident > authentication failed for user "saraswati". If u're running under Windows you should check out the hidden file at C:\Documents and Settings\\Application Data\postgresql \pgpass.conf which contains info in the format: localhost:5432:*:YOUR_USER:YOUR_PASSWORD Lorenzo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: What user does django server runs?
On 3 Jan, 02:54, Kenneth Gonsalves <[EMAIL PROTECTED]> wrote: > On 02-Jan-07, at 11:18 PM, Michel Thadeu Sabchuk wrote: > > > without success, the error message tells me: FATAL:Ident > > authentication failed for user "saraswati".edit pg_hba.conf - change > > authentication fromident'sameuser' to > password > > -- > > regards > kghttp://lawgon.livejournal.comhttp://nrcfosshelpline.in/web/ I have this same error when i run "python manage.py syncdb". I tried changing "pg_hba.conf" but without success. I got around the problem temporarily by running manage.py logged in as user "postgres", but then I get: "psycopg2.OperationalError: FATAL: database "sp" does not exist" At this point, the Apache server isn't running, and it's not needed, right? So what else can be the problem? I created the database "sp" with the shell command "createdb" in postgresql and I can access it through the psql-shell. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: What user does django server runs?
Hi guys! I'm not very familiar with pg_hba.conf file but with your help I will :D Thanks for help! -- Michel Thadeu Sabchuk Curitiba/PR --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: What user does django server runs?
On 03-Jan-07, at 1:58 AM, Jacob M wrote: Then create a postgresql user and password in psql. that is createuser saraswati -P -- regards kg http://lawgon.livejournal.com http://nrcfosshelpline.in/web/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: What user does django server runs?
On 02-Jan-07, at 11:18 PM, Michel Thadeu Sabchuk wrote: without success, the error message tells me: FATAL: Ident authentication failed for user "saraswati". edit pg_hba.conf - change authentication from ident 'sameuser' to password -- regards kg http://lawgon.livejournal.com http://nrcfosshelpline.in/web/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: What user does django server runs?
If you're running django under mod_python it will be using whichever account apache is running under - www-data, apache, etc. I typically use password-based authentication instead of same-user ident authentication in postgresql. Look in pg_hba.conf on your system. My pg_hba.conf typically looks like this: local all postgres ident sameuser local all all password hostall all 127.0.0.1 255.255.255.255 password That allows password-based authentication for locally-initiated connections - either over local unix sockets or tcp connections on the loopback interface. Then create a postgresql user and password in psql. On 1/2/07, Michel Thadeu Sabchuk <[EMAIL PROTECTED]> wrote: Hi guys! I'm deploying a django project with postgresql as database backend. I used to create a local user with the same name of the database user (owner of the database), so I just need to run the webserver as the local user and the database should work without problems (this was true for webware). I try to run django as the local user and hit the page without success, the error message tells me: FATAL: Ident authentication failed for user "saraswati". What can I do? Thanks > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: What user does django server runs?
Assuming that you're running this under Apache+Mod_Python (complete guess - please correct me if I'm wrong), the server will be running as whatever Apache is configured to run as. Typically that's not a local username like "saraswati". If you run Django with a front-end of Lighttpd+FLUP/fgci, then it can easily run under your user account - a fairly common setup on hosted solutions like TextDrive. -joe On 1/2/07, Michel Thadeu Sabchuk <[EMAIL PROTECTED]> wrote: Hi guys! I'm deploying a django project with postgresql as database backend. I used to create a local user with the same name of the database user (owner of the database), so I just need to run the webserver as the local user and the database should work without problems (this was true for webware). I try to run django as the local user and hit the page without success, the error message tells me: FATAL: Ident authentication failed for user "saraswati". What can I do? Thanks > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
What user does django server runs?
Hi guys! I'm deploying a django project with postgresql as database backend. I used to create a local user with the same name of the database user (owner of the database), so I just need to run the webserver as the local user and the database should work without problems (this was true for webware). I try to run django as the local user and hit the page without success, the error message tells me: FATAL: Ident authentication failed for user "saraswati". What can I do? Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---