iis settings

[MWH1711]

Guess I am almost there...

We current have one website using port 80, I use 8090 for qatrack instead.

1. When I enable proxy in Application Request Routing Cache, I got empty page (http://localhost:8090).

2. When I turn off proxy, I got this on the web page (http://localhost:8090):

Does anyone have similar experience using multiple ports?

Thank you.

[Randle Taylor]

I think I would need to know more about how you have things setup with your proxy rules to really help.  CherryPy typically runs on port 8080 so unless you changed the CherryPy configuration to use a different port, it would be running there. What happens if you visit http://localhost:8080?   You should also confirm the QATrackCherryPyService is running  (in the services tab of the task manager).

--
You received this message because you are subscribed to the Google Groups "QATrack+" group.
To unsubscribe from this group and stop receiving emails from it, send an email to qatrack+unsubscribe@googlegroups.com.
To post to this group, send email to qat...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Meng Wei Ho]

QATrackCherryPyService status is ‘Started’ in service.

The page is empty on port 8080. In Application Request Routing, I just checked ‘Enable proxy’ and didn’t adjust anything else.

On Wed, Jan 31, 2018 at 7:35 PM Randle Taylor <randle...@gmail.com> wrote:

I think I would need to know more about how you have things setup with your proxy rules to really help.  CherryPy typically runs on port 8080 so unless you changed the CherryPy configuration to use a different port, it would be running there. What happens if you visit http://localhost:8080?   You should also confirm the QATrackCherryPyService is running  (in the services tab of the task manager).

On 31 January 2018 at 18:41, MWH1711 <meng...@gmail.com> wrote:

Guess I am almost there...

We current have one website using port 80, I use 8090 for qatrack instead.

1. When I enable proxy in Application Request Routing Cache, I got empty page (http://localhost:8090).

2. When I turn off proxy, I got this on the web page (http://localhost:8090):

Does anyone have similar experience using multiple ports?

Thank you.

--
You received this message because you are subscribed to the Google Groups "QATrack+" group.

To unsubscribe from this group and stop receiving emails from it, send an email to qatrack+u...@googlegroups.com.

[Randle Taylor]

Is there anything showing in the log files?  i.e. C:\deploy\qatrackplus\logs\cherry_py_err.log (or std_err.log / std_out.log).

On 31 January 2018 at 19:46, Meng Wei Ho <meng...@gmail.com> wrote:

QATrackCherryPyService status is ‘Started’ in service.

The page is empty on port 8080. In Application Request Routing, I just checked ‘Enable proxy’ and didn’t adjust anything else.

On Wed, Jan 31, 2018 at 7:35 PM Randle Taylor <randle...@gmail.com> wrote:

I think I would need to know more about how you have things setup with your proxy rules to really help.  CherryPy typically runs on port 8080 so unless you changed the CherryPy configuration to use a different port, it would be running there. What happens if you visit http://localhost:8080?   You should also confirm the QATrackCherryPyService is running  (in the services tab of the task manager).

On 31 January 2018 at 18:41, MWH1711 <meng...@gmail.com> wrote:

Guess I am almost there...

We current have one website using port 80, I use 8090 for qatrack instead.

1. When I enable proxy in Application Request Routing Cache, I got empty page (http://localhost:8090).

2. When I turn off proxy, I got this on the web page (http://localhost:8090):

Does anyone have similar experience using multiple ports?

Thank you.

--
You received this message because you are subscribed to the Google Groups "QATrack+" group.

To unsubscribe from this group and stop receiving emails from it, send an email to qatrack+unsubscribe@googlegroups.com.

[Meng Wei Ho]

Do I need to do anything to FastCGI? I installed it but didn't do anything to it. (Or install wfastCGI module?)

This is the message in cherry_py_err.log:

[31/Jan/2018:19:42:09] ENGINE KeyError('delete_selected',)

Traceback (most recent call last):

  File "C:\deploy\venvs\qatrack\lib\site-packages\cherrypy\wsgiserver\__init__.py", line 1408, in communicate

    req.respond()

  File "C:\deploy\venvs\qatrack\lib\site-packages\cherrypy\wsgiserver\__init__.py", line 862, in respond

    self.server.gateway(self).respond()

  File "C:\deploy\venvs\qatrack\lib\site-packages\cherrypy\wsgiserver\__init__.py", line 2335, in respond

    response = self.req.server.wsgi_app(self.env, self.start_response)

  File "C:\deploy\venvs\qatrack\lib\site-packages\cherrypy\_cptree.py", line 287, in __call__

    return app(environ, start_response)

  File "C:\deploy\venvs\qatrack\lib\site-packages\django\core\handlers\wsgi.py", line 206, in __call__

    response = self.get_response(request)

  File "C:\deploy\venvs\qatrack\lib\site-packages\django\core\handlers\base.py", line 194, in get_response

    response = self.handle_uncaught_exception(request, resolver, sys.exc_info())

  File "C:\deploy\venvs\qatrack\lib\site-packages\django\core\handlers\base.py", line 232, in handle_uncaught_exception

    if resolver.urlconf_module is None:

  File "C:\deploy\venvs\qatrack\lib\site-packages\django\core\urlresolvers.py", line 360, in urlconf_module

    self._urlconf_module = import_module(self.urlconf_name)

  File "C:\deploy\venvs\qatrack\lib\site-packages\django\utils\importlib.py", line 40, in import_module

    __import__(name)

  File "C:\deploy\qatrackplus\qatrack\urls.py", line 6, in <module>

    admin.autodiscover()

  File "C:\deploy\venvs\qatrack\lib\site-packages\django\contrib\admin\__init__.py", line 29, in autodiscover

    import_module('%s.admin' % app)

  File "C:\deploy\venvs\qatrack\lib\site-packages\django\utils\importlib.py", line 40, in import_module

    __import__(name)

  File "C:\deploy\qatrackplus\qatrack\qa\admin.py", line 23, in <module>

    admin.site.disable_action("delete_selected")

  File "C:\deploy\venvs\qatrack\lib\site-packages\django\contrib\admin\sites.py", line 122, in disable_action

    del self._actions[name]

KeyError: 'delete_selected'

[Randle Taylor]

No you don't need FastCGI.   I can't explain why you would see that error off the top of my head.  You might want to ensure all the correct package versions are installed by doing `winpty pip install -r requirements/base.txt`.  A comment here: https://stackoverflow.com/questions/6912633/django-admin-delete-selected-problem suggested finding any .pyc and deleting them.  You should be able to do that in bash by doing "find ./ -name "*.pyc" | xargs rm"

Randy

[Meng Wei Ho]

No luck after deleting .pyc files

This is what I got when I ran installation comment:

$ winpty pip install -r requirements/base.txt

Requirement already satisfied: Django==1.6.11 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 1))

Obtaining django_genericdropdown-master from git+https://github.com/randlet/django-genericdropdown.git@616a32a32ef6102a59163cadbc3d9380667549b6#egg=django_genericdropdown-master (from -r requirements/ba

se.txt (line 2))

  Skipping because already up-to-date.

  Running setup.py (path:C:\deploy\venvs\qatrack\src\django-genericdropdown-master\setup.py) egg_info for package django-genericdropdown-master produced metadata for project name django-genericdropdown.

 Fix your #egg=django-genericdropdown-master fragments.

Requirement already satisfied: django-tastypie==0.9.16 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 3))

Obtaining django_registration-master from git+https://github.com/macropin/django-registration.git@19c4cb643a95040ba22ba945cd2e3b9136a2addb#egg=django_registration-master (from -r requirements/base.txt (

line 4))

  Skipping because already up-to-date.

  Running setup.py (path:C:\deploy\venvs\qatrack\src\django-registration-master\setup.py) egg_info for package django-registration-master produced metadata for project name django-registration. Fix your

 #egg=django-registration-master fragments.

Requirement already satisfied: django-braces==1.4.0 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 5))

Requirement already satisfied: logilab-astng>=0.24.3 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 6))

Requirement already satisfied: logilab-common>=0.62.1 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 7))

Requirement already satisfied: mimeparse==0.1.3 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 8))

Requirement already satisfied: python-dateutil==2.2 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 9))

Requirement already satisfied: python-ntlm==1.1.0 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 10))

Requirement already satisfied: pytz==2014.7 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 11))

Requirement already satisfied: South==1.0.1 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 12))

Requirement already satisfied: numpy in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 13))

Requirement already satisfied: scipy in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 14))

Requirement already satisfied: matplotlib>=1.0 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 15))

Requirement already satisfied: django-admin-views==0.5.0 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 16))

Requirement already satisfied: django-listable==0.3.10 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 17))

Requirement already satisfied: pydicom==0.9.9 in c:\deploy\venvs\qatrack\lib\site-packages (from -r requirements/base.txt (line 18))

Requirement already satisfied: six in c:\deploy\venvs\qatrack\lib\site-packages (from django-braces==1.4.0->-r requirements/base.txt (line 5))

Requirement already satisfied: setuptools in c:\deploy\venvs\qatrack\lib\site-packages\setuptools-0.6c11-py2.7.egg (from logilab-common>=0.62.1->-r requirements/base.txt (line 7))

Requirement already satisfied: colorama in c:\deploy\venvs\qatrack\lib\site-packages (from logilab-common>=0.62.1->-r requirements/base.txt (line 7))

Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.1 in c:\deploy\venvs\qatrack\lib\site-packages (from matplotlib>=1.0->-r requirements/base.txt (line 15))

Requirement already satisfied: backports.functools-lru-cache in c:\deploy\venvs\qatrack\lib\site-packages (from matplotlib>=1.0->-r requirements/base.txt (line 15))

Requirement already satisfied: cycler>=0.10 in c:\deploy\venvs\qatrack\lib\site-packages (from matplotlib>=1.0->-r requirements/base.txt (line 15))

Installing collected packages: django-genericdropdown, django-registration

  Found existing installation: django-genericdropdown 0.1

    Uninstalling django-genericdropdown-0.1:

      Successfully uninstalled django-genericdropdown-0.1

  Running setup.py develop for django-genericdropdown

  Found existing installation: django-registration 1.0

    Uninstalling django-registration-1.0:

      Successfully uninstalled django-registration-1.0

  Running setup.py develop for django-registration

Successfully installed django-genericdropdown django-registration

[Meng Wei Ho]

When I disable the rules in URL Rewrite, I was able to see the file list:

Another question. When I tried windows+Apache, I failed in numpy installation:

$ easy_install numpy==1.7

Searching for numpy==1.7

Reading http://pypi.python.org/simple/numpy/

Couldn't find index page for 'numpy' (maybe misspelled?)

Scanning index of all packages (this may take a while)

Reading http://pypi.python.org/simple/

No local packages or download links found for numpy==1.7

Best match: None

Traceback (most recent call last):

  File "C:\deploy\venvs\qatrack\Scripts\easy_install-script.py", line 8, in <module>

    load_entry_point('setuptools==0.6c11', 'console_scripts', 'easy_install')()

  File "build/bdist.linux-i686/egg/setuptools/command/easy_install.py", line 1712, in main

  File "build/bdist.linux-i686/egg/setuptools/command/easy_install.py", line 1700, in with_ei_usage

  File "build/bdist.linux-i686/egg/setuptools/command/easy_install.py", line 1716, in <lambda>

  File "c:\python27\Lib\distutils\core.py", line 151, in setup

    dist.run_commands()

  File "c:\python27\Lib\distutils\dist.py", line 953, in run_commands

    self.run_command(cmd)

  File "c:\python27\Lib\distutils\dist.py", line 972, in run_command

    cmd_obj.run()

  File "build/bdist.linux-i686/egg/setuptools/command/easy_install.py", line 211, in run

  File "build/bdist.linux-i686/egg/setuptools/command/easy_install.py", line 434, in easy_install

  File "build/bdist.linux-i686/egg/setuptools/package_index.py", line 475, in fetch_distribution

AttributeError: 'NoneType' object has no attribute 'clone'

​

[Meng Wei Ho]

I restarted cherrypy service and visited http://localhost:8080. This is the error I got:

OperationalError at /

(com_error(-2147352567, 'Exception occurred.', (0, u'Microsoft SQL Server Native Client 11.0', u'Cannot open database "qatrack" requested by the login. The login failed.', None, 0, -2147467259), None), u'Error opening connection: DATA SOURCE=localhost\\SQLEXPRESS;Initial Catalog=qatrack;Integrated Security=SSPI;PROVIDER=sqlncli11;DataTypeCompatibility=80;MARS Connection=True')

Request Method:	GET
Request URL:	http://localhost:8080/
Django Version:	1.6.11
Exception Type:	OperationalError
Exception Value:	(com_error(-2147352567, 'Exception occurred.', (0, u'Microsoft SQL Server Native Client 11.0', u'Cannot open database "qatrack" requested by the login. The login failed.', None, 0, -2147467259), None), u'Error opening connection: DATA SOURCE=localhost\\SQLEXPRESS;Initial Catalog=qatrack;Integrated Security=SSPI;PROVIDER=sqlncli11;DataTypeCompatibility=80;MARS Connection=True')
Exception Location:	C:\deploy\venvs\qatrack\lib\site-packages\sqlserver_ado\dbapi.py in connect, line 187
Python Executable:	C:\deploy\venvs\qatrack\lib\site-packages\pywin32-220-py2.7-win32.egg\PythonService.exe
Python Version:	2.7.14
Python Path:	[u'C:\\deploy\\qatrackplus', 'C:\\deploy\\venvs\\qatrack\\lib\\site-packages\\pywin32-220-py2.7-win32.egg', 'C:\\deploy\\venvs\\qatrack\\lib\\site-packages\\setuptools-0.6c11-py2.7.egg', 'c:\\deploy\\venvs\\qatrack\\src\\django-genericdropdown-master', 'c:\\deploy\\venvs\\qatrack\\src\\django-registration-master', 'C:\\Windows\\system32\\python27.zip', 'C:\\deploy\\venvs\\qatrack\\DLLs', 'C:\\deploy\\venvs\\qatrack\\lib', 'C:\\deploy\\venvs\\qatrack\\lib\\plat-win', 'C:\\deploy\\venvs\\qatrack\\lib\\lib-tk', 'c:\\python27\\Lib', 'c:\\python27\\DLLs', 'c:\\python27\\Lib\\lib-tk', 'C:\\deploy\\venvs\\qatrack', 'C:\\deploy\\venvs\\qatrack\\lib\\site-packages', 'C:\\deploy\\venvs\\qatrack\\lib\\site-packages\\win32', 'C:\\deploy\\venvs\\qatrack\\lib\\site-packages\\win32\\lib', 'C:\\deploy\\venvs\\qatrack\\lib\\site-packages\\Pythonwin', 'C:/deploy/qatrackplus/']

[Randle Taylor]

That looks to me like either you haven't set the username/password correctly in local_settings.py or have not added the user to the qatrack database in SQLExpress.

RT

[Meng Wei Ho]

Yes. Couple mistakes I made: 

1. I didn't put username and password in local_settings.py

2. Server authentication has to set "SQL server and windows authentication mode"

3. URL Rewrite setup in website instead of top level since I use different port and several websites in this server.

It is working right now. Thank you very much for your help.

[Randle Taylor]

Great! Glad to hear it.