Django应用程序中使用postgres和Gunicorn + Nginx作为反向代理,inputinettypes的dbinput语法无效

你能帮我破译这个相当深奥的错误吗? 当我启动应用程序时,一切正常,但是当我尝试login崩溃。

DatabaseError在/ login /

inputinettypes的input语法无效:“”LINE 1:… 00101 Firefox / 41.0','2015-12-12 09:39:55.590036 + 00:00','')

exception位置:/home/mhb11/.virtualenvs/redditpk/local/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py执行中,第54行

我知道, inet数据types接受IPv4和IPv6主机和networking(而不是域名)。

回溯如下:

 Traceback: File "/home/mhb11/.virtualenvs/redditpk/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response 187. response = middleware_method(request, response) File "/home/mhb11/.virtualenvs/redditpk/local/lib/python2.7/site-packages/user_sessions/middleware.py" in process_response 46. request.session.save() File "/home/mhb11/.virtualenvs/redditpk/local/lib/python2.7/site-packages/user_sessions/backends/db.py" in save 86. obj.save(force_insert=must_create, using=using) File "/home/mhb11/.virtualenvs/redditpk/local/lib/python2.7/site-packages/django/db/models/base.py" in save 546. force_update=force_update, update_fields=update_fields) File "/home/mhb11/.virtualenvs/redditpk/local/lib/python2.7/site-packages/django/db/models/base.py" in save_base 650. result = manager._insert([self], fields=fields, return_id=update_pk, using=using, raw=raw) File "/home/mhb11/.virtualenvs/redditpk/local/lib/python2.7/site-packages/django/db/models/manager.py" in _insert 215. return insert_query(self.model, objs, fields, **kwargs) File "/home/mhb11/.virtualenvs/redditpk/local/lib/python2.7/site-packages/django/db/models/query.py" in insert_query 1661. return query.get_compiler(using=using).execute_sql(return_id) File "/home/mhb11/.virtualenvs/redditpk/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql 937. cursor.execute(sql, params) File "/home/mhb11/.virtualenvs/redditpk/local/lib/python2.7/site-packages/django/db/backends/util.py" in execute 41. return self.cursor.execute(sql, params) File "/home/mhb11/.virtualenvs/redditpk/local/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py" in execute 58. six.reraise(utils.DatabaseError, utils.DatabaseError(*tuple(e.args)), sys.exc_info()[2]) File "/home/mhb11/.virtualenvs/redditpk/local/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py" in execute 54. return self.cursor.execute(query, args) Exception Type: DatabaseError at /login/ Exception Value: invalid input syntax for type inet: "" LINE 1: ...00101 Firefox/41.0', '2015-12-12 09:39:55.590036+00:00', '') 

urls.py中的/ login / url是url(r'^login/$', 'django.contrib.auth.views.login', {'template_name': 'login.html'}, name="login"),

环境是:

Django 1.5.1有一个postgresql后端 ,驻留在Ubuntu 14.04机器上。 尤其要注意的是,在我将nginx设置gunicorn之后的反向代理 (使用端口80进行此设置)后,此错误开始出现。 当我在端口8080上单独使用gunicorn(和服务员,另一个纯粹的python web服务器)的时候,情况非常好。

在/ etc / nginx的/网站可用/ myproject的:

 server { listen 80; server_name example.cloudapp.net; location = /favicon.ico { access_log off; log_not_found off; } location /static/ { root /home/mhb11/folder/myproject; } location / { include proxy_params; proxy_pass http://unix:/home/mhb11/folder/myproject/myproject.sock; } error_page 500 502 503 504 /500.html; location = /500.html { root /home/mhb11/folder/myproject/templates/; } } 

的/ etc / nginx的/ proxy_params:

 proxy_set_header Host $http_host; proxy_set_header User-Agent $http_user_agent; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto $scheme; 

/etc/nginx/nginx.conf:

 user www-data; worker_processes 4; pid /run/nginx.pid; env ON_AZURE=1; env awsaccesskeyid=something; env awssecretkey=something; events { worker_connections 1024; multi_accept on; use epoll; } http { ## # Basic Settings ## sendfile on; tcp_nopush on; tcp_nodelay on; keepalive_timeout 65; types_hash_max_size 2048; # server_tokens off; # server_names_hash_bucket_size 64; include /etc/nginx/mime.types; default_type application/octet-stream; ## # Logging Settings ## access_log /var/log/nginx/access.log; error_log /var/log/nginx/error.log; ## # Gzip Settings ## gzip on; gzip_disable "msie6"; # gzip_vary on; # gzip_proxied any; # gzip_comp_level 6; # gzip_buffers 16 8k; # gzip_http_version 1.1; # gzip_types text/plain text/css application/json application/x-javascript text/xml application/xml application/xml+rss text/javascrip$ ## # nginx-naxsi config ## # Uncomment it if you installed nginx-naxsi ## #include /etc/nginx/naxsi_core.rules; ## # nginx-passenger config ## # Uncomment it if you installed nginx-passenger ## #passenger_root /usr; #passenger_ruby /usr/bin/ruby; ## # Virtual Host Configs ## include /etc/nginx/conf.d/*.conf; include /etc/nginx/sites-enabled/*; } #mail { # # See sample authentication script at: # # http://wiki.nginx.org/ImapAuthenticateWithApachePhpScript # # # auth_http localhost/auth.php; # # pop3_capabilities "TOP" "USER"; # # imap_capabilities "IMAP4rev1" "UIDPLUS"; # # server { # listen localhost:110; # protocol pop3; # proxy on; # } # # server { # listen localhost:143; # protocol imap; # proxy on; # } #} 

这是怎么回事?

注意:如果需要更多的信息,请向我咨询,例如我的gunicorn.conf和nginx.conf文件,安装的软件包或者是否需要与db相关的东西。 只是要求离开!

您没有转发代理IP。 这里是我在我的nginx配置中设置的转发头文件集:

 location / { proxy_set_header Host $http_host; proxy_set_header User-Agent $http_user_agent; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto $scheme; proxy_pass ......; } 

nginx文档中的更多选项 – http://nginx.org/en/docs/http/ngx_http_proxy_module.html#proxy_set_header

然后在Django中,你可以这样做:

 user_ip = request.META['HTTP_X_REAL_IP`] or request.META['REMOTE_ADDR'] 

请注意,在使用带有SSL的Django时, X-Forwarded-Proto是必要的,在这种情况下,您还需要配置Django:

 SECURE_PROXY_SSL_HEADER = ('HTTP_X_FORWARDED_PROTO', 'https') 

更多Django文档 – https://docs.djangoproject.com/en/1.9/ref/settings/#std:setting-SECURE_PROXY_SSL_HEADER

您的程序正在尝试使用空的远程IP将某行添加到某个日志表。 我想,当你使用反向代理时,程序不知道远程IP,因为它被代理的IP所遮蔽。

因为它是空的,我想程序试图忽略代理的IP,但它没有找到更好的。 它应该使用X-Forwarded-For标题。

如果没有合理的IP记录,程序应该简单地记录“NULL”作为IP。