I am trying to deploy my django project on my company LAN. I am able to get
the site working, however, I lose connectivity to my Microsoft SQL Server
when I run the site through apache and modwsgi. Everything works fine in
the development environment. It seems that when django is trying to connect
using pyodbc is tries to connect as user 'MEDSTAR\COMPUTER_NAME' instead of
'user': ' ' which i put in my django settings file. This is what my db
settings are in my settings.py files:
'mosaiq': {
'ENGINE': 'sql_server.pyodbc',
'NAME': 'MOSAIQ',
'USER': '',
'PASSWORD': '',
'HOST': 'MOSAIQ01T',
'PORT': '',
'OPTIONS': {'driver': 'ODBC Driver 11 for SQL Server',
},
('28000', "[28000] [Microsoft][ODBC Driver 11 for SQL Server][SQL
Server]Login failed for user 'MEDSTAR\COMPUTER_NAME$'. (18456)
(SQLDriverConnect)")
Request Method: GET
Request URL: http://172.23.81.185/patient/165033E/1/
Django Version: 1.11.3
Exception Type: Error
Exception Value:
('28000', "[28000] [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Login
failed for user 'MEDSTAR\\RAMFSHONCDT472$'. (18456) (SQLDriverConnect)")
Exception Location:
c:\users\jxs215\appdata\local\continuum\anaconda3\envs\py3_env\lib\site-packages\sql_server\pyodbc\base.py
in get_new_connection, line 309
Python Executable:
C:\Users\jxs215\wamp64\bin\apache\apache2.4.27\bin\httpd.exe
Python Version: 3.6.2
Python Path:
['C:\\users\\jxs215\\wamp64\\www\\jons_project\\compare\\apps',
'C:\\users\\jxs215\\wamp64\\www\\jons_project',
'C:\\Users\\jxs215\\AppData\\Local\\Continuum\\Anaconda3\\envs\\py3_env\\python36.zip',
'c:\\users\\jxs215\\appdata\\local\\continuum\\anaconda3\\envs\\py3_env\\DLLs',
'c:\\users\\jxs215\\appdata\\local\\continuum\\anaconda3\\envs\\py3_env\\lib',
'C:\\Users\\jxs215\\wamp64\\bin\\apache\\apache2.4.27\\bin',
'c:\\users\\jxs215\\appdata\\local\\continuum\\anaconda3\\envs\\py3_env',
'c:\\users\\jxs215\\appdata\\local\\continuum\\anaconda3\\envs\\py3_env\\lib\\site-packages',
'c:\\users\\jxs215\\appdata\\local\\continuum\\anaconda3\\envs\\py3_env\\lib\\site-packages\\win32',
'c:\\users\\jxs215\\appdata\\local\\continuum\\anaconda3\\envs\\py3_env\\lib\\site-packages\\win32\\lib',
'c:\\users\\jxs215\\appdata\\local\\continuum\\anaconda3\\envs\\py3_env\\lib\\site-packages\\Pythonwin',
'c:\\users\\jxs215\\appdata\\local\\continuum\\anaconda3\\envs\\py3_env\\lib\\site-packages\\setuptools-27.2.0-py3.6.egg',
'C:\\Users\\jxs215\\wamp64\\www\\jons_project']
Server time: Wed, 21 Feb 2018 19:38:09 +00
Does anyone know how to get passed this problem?
--
You received this message because you are subscribed to the Google Groups
"modwsgi" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/modwsgi.
For more options, visit https://groups.google.com/d/optout.
