Importing pandas from the web2py shell works just fine.
administrator@ubuntu16-2:/home/www-data/web2py$ sudo python web2py.py -a password -S connect web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2016 Version 2.14.6-stable+timestamp.2016.05.10.00.21.47 Database drivers available: pymysql, imaplib, MySQLdb, sqlite3, pg8000, pyodbc WARNING:web2py:import IPython error; use default python shell Python 2.7.12 (default, Jul 1 2016, 15:12:24) [GCC 5.4.0 20160609] on linux2 Type "help", "copyright", "credits" or "license" for more information. (InteractiveConsole) >>> import pandas >>> On Tue, Aug 16, 2016 at 2:37 PM, Richard Vézina <ml.richard.vez...@gmail.com > wrote: > Which version of web2py? > > I just try impor... with command line web2py instance and it works... > > I am using web2py 2.14.6 > > Richard > > On Tue, Aug 16, 2016 at 3:34 PM, Jim Steil <ato.st...@gmail.com> wrote: > >> Let me restate my issue >> >> I can use pandas just fine on ubuntu 16.04. The problem occurs when I'm >> importing a module into a web2py controller and that module fails to import >> on the 'import pandas as pd' line. >> >> Just to be clear, pandas works find on the box. It is when it runs on >> web2py through the nginx/uwsgi stack that it fails. >> >> -Jim >> >> >> On Tue, Aug 16, 2016 at 2:30 PM, Richard Vézina < >> ml.richard.vez...@gmail.com> wrote: >> >>> Strange! >>> >>> Missing dependency which didn't install because of a broken link? >>> >>> Richard >>> >>> On Tue, Aug 16, 2016 at 3:22 PM, Jim Steil <ato.st...@gmail.com> wrote: >>> >>>> From my system: >>>> >>>> administrator@ubuntu16-2:/etc/nginx/sites-enabled$ sudo pip show pandas >>>> [sudo] password for administrator: >>>> --- >>>> Metadata-Version: 2.0 >>>> Name: pandas >>>> Version: 0.18.1 >>>> Summary: Powerful data structures for data analysis, time series,and >>>> statistics >>>> Home-page: http://pandas.pydata.org >>>> Author: The PyData Development Team >>>> Author-email: pyd...@googlegroups.com >>>> Installer: pip >>>> License: BSD >>>> Location: /usr/local/lib/python2.7/dist-packages >>>> Requires: pytz, python-dateutil, numpy >>>> Classifiers: >>>> Development Status :: 5 - Production/Stable >>>> Environment :: Console >>>> Operating System :: OS Independent >>>> Intended Audience :: Science/Research >>>> Programming Language :: Python >>>> Programming Language :: Python :: 2 >>>> Programming Language :: Python :: 3 >>>> Programming Language :: Python :: 2.7 >>>> Programming Language :: Python :: 3.4 >>>> Programming Language :: Python :: 3.5 >>>> Programming Language :: Cython >>>> Topic :: Scientific/Engineering >>>> >>>> I'm experiencing this on multiple Ubuntu 16.04 systems. Pip has been >>>> updated using: >>>> >>>> sudo pip install --upgrade pip >>>> >>>> ...before installing pandas which I installed using pip and not an >>>> ubuntu package. >>>> >>>> -Jim >>>> >>>> btw - really appreciate your help with this... >>>> >>>> >>>> On Tue, Aug 16, 2016 at 2:19 PM, Richard Vézina < >>>> ml.richard.vez...@gmail.com> wrote: >>>> >>>>> Maybe try reinstall pip package, or if you use ubuntu package, use pip >>>>> one instead... >>>>> >>>>> On Tue, Aug 16, 2016 at 3:16 PM, Richard Vézina < >>>>> ml.richard.vez...@gmail.com> wrote: >>>>> >>>>>> Can you identify the responsible piece of pandas code that cause the >>>>>> issue? It don't make sens if you can't import pandas as pd in U16.04... I >>>>>> just try and it works... >>>>>> >>>>>> >>>>>> sudo pip show pandas >>>>>> --- >>>>>> Metadata-Version: 1.1 >>>>>> Name: pandas >>>>>> Version: 0.18.1 >>>>>> Summary: Powerful data structures for data analysis, time series,and >>>>>> statistics >>>>>> Home-page: http://pandas.pydata.org >>>>>> Author: The PyData Development Team >>>>>> Author-email: pyd...@googlegroups.com >>>>>> License: BSD >>>>>> Location: /usr/local/lib/python2.7/dist-packages >>>>>> Requires: python-dateutil, pytz, numpy >>>>>> Classifiers: >>>>>> Development Status :: 5 - Production/Stable >>>>>> Environment :: Console >>>>>> Operating System :: OS Independent >>>>>> Intended Audience :: Science/Research >>>>>> Programming Language :: Python >>>>>> Programming Language :: Python :: 2 >>>>>> Programming Language :: Python :: 3 >>>>>> Programming Language :: Python :: 2.7 >>>>>> Programming Language :: Python :: 3.4 >>>>>> Programming Language :: Python :: 3.5 >>>>>> Programming Language :: Cython >>>>>> Topic :: Scientific/Engineering >>>>>> >>>>>> Richard >>>>>> >>>>>> On Tue, Aug 16, 2016 at 2:52 PM, Jim Steil <ato.st...@gmail.com> >>>>>> wrote: >>>>>> >>>>>>> Richard >>>>>>> >>>>>>> I have not had it successfully running under ubuntu 16.04 with a >>>>>>> prior version of pandas. I have it running on Ubuntu 14.04 with the >>>>>>> same >>>>>>> version of pandas. It fails on: >>>>>>> >>>>>>> import pandas as pd >>>>>>> >>>>>>> -Jim >>>>>>> >>>>>>> On Tue, Aug 16, 2016 at 1:02 PM, Richard Vézina < >>>>>>> ml.richard.vez...@gmail.com> wrote: >>>>>>> >>>>>>>> Massimo's has always said it wasn't secure, I ignore the exact >>>>>>>> reason(s)... >>>>>>>> >>>>>>>> I suggest downgrading pandas with this rational you were using is >>>>>>>> in previous version of pandas and nginx without this problem... >>>>>>>> >>>>>>>> I do use pandas (but not HDF5 Store) and I don't experiment this >>>>>>>> issue... neither in 12.04 or 16.04 >>>>>>>> >>>>>>>> Richard >>>>>>>> >>>>>>>> On Tue, Aug 16, 2016 at 1:55 PM, Jim S <j...@qlf.com> wrote: >>>>>>>> >>>>>>>>> In my reading I didn't see that downgrading pandas would help. Am >>>>>>>>> I missing something or did I mislead you with my post? Downgrading >>>>>>>>> ubuntu >>>>>>>>> would help (which is what we have now, but would like to run the >>>>>>>>> latest >>>>>>>>> ubuntu). >>>>>>>>> >>>>>>>>> But, back to the main question, what are the biggest factors in >>>>>>>>> not recommending rocket for production use? Does putting haproxy in >>>>>>>>> front >>>>>>>>> of the rocket servers alleviate the concerns? >>>>>>>>> >>>>>>>>> -Jim >>>>>>>>> >>>>>>>>> On Tuesday, August 16, 2016 at 11:48:59 AM UTC-5, Richard wrote: >>>>>>>>>> >>>>>>>>>> You can't downgrade pandas package? >>>>>>>>>> >>>>>>>>>> Richard >>>>>>>>>> >>>>>>>>>> On Tue, Aug 16, 2016 at 12:35 PM, Jim S <j...@qlf.com> wrote: >>>>>>>>>> >>>>>>>>>>> Ron >>>>>>>>>>> >>>>>>>>>>> It would depend on what OS you're running on the x86 box. This >>>>>>>>>>> would be a good place to start http://web2py.com/books/ >>>>>>>>>>> default/chapter/29/13/deployment-recipes >>>>>>>>>>> >>>>>>>>>>> Also, if you don't mind, could you re-post this in a new thread >>>>>>>>>>> so this thread could focus on my initial question? >>>>>>>>>>> >>>>>>>>>>> -Jim >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Tuesday, August 16, 2016 at 11:23:17 AM UTC-5, Ron Chatterjee >>>>>>>>>>> wrote: >>>>>>>>>>>> >>>>>>>>>>>> On that note, can someone point me to documentation about how >>>>>>>>>>>> to set up an environment in dedicated sever on X86? I am thinking >>>>>>>>>>>> about >>>>>>>>>>>> co-locating than shared hosting. If someone does go that route, >>>>>>>>>>>> how we >>>>>>>>>>>> manage to set up the hosting environment? >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Tuesday, August 16, 2016 at 11:50:51 AM UTC-4, Jim S wrote: >>>>>>>>>>>>> >>>>>>>>>>>>> Hi >>>>>>>>>>>>> >>>>>>>>>>>>> I currently have my app deployed using Ubuntu 14.04 / nginx / >>>>>>>>>>>>> uwsgi. I have a couple of servers load-balanced behind a haproxy >>>>>>>>>>>>> server. >>>>>>>>>>>>> I'm running ssl on the haproxy system and talking http to web2y >>>>>>>>>>>>> through >>>>>>>>>>>>> nginx/uwsgi. >>>>>>>>>>>>> >>>>>>>>>>>>> Now, I'm trying to upgrade ubuntu to 16.04 and an having >>>>>>>>>>>>> issues with pandas (used in my web2py app) through the >>>>>>>>>>>>> nginx/uwsgi stack. >>>>>>>>>>>>> See this issue for what might be causing it - >>>>>>>>>>>>> http://stackoverflow.com/questions/19439190/segmentation-f >>>>>>>>>>>>> ault-while-using-pandas-in-uwsgi >>>>>>>>>>>>> >>>>>>>>>>>>> Fixing this error is obviously something beyond my >>>>>>>>>>>>> capabilities so it got me thinking about alternative deployment >>>>>>>>>>>>> options. >>>>>>>>>>>>> One that I'm considering is replacing my nginx / uwsgi stack with >>>>>>>>>>>>> just the >>>>>>>>>>>>> rocket server to serve the web2py app. My rocket servers (2 of >>>>>>>>>>>>> them) would >>>>>>>>>>>>> be behind the haproxy server so would not be public-facing. >>>>>>>>>>>>> >>>>>>>>>>>>> I'm aware of the recommendation against running rocket in a >>>>>>>>>>>>> production environment but am not aware of the reasons for the >>>>>>>>>>>>> recommendation. >>>>>>>>>>>>> >>>>>>>>>>>>> My question - does running multiple rocket servers behind >>>>>>>>>>>>> haproxy remove the concerns about rocket in a production >>>>>>>>>>>>> environment? >>>>>>>>>>>>> >>>>>>>>>>>>> -Jim >>>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>> Resources: >>>>>>>>>>> - http://web2py.com >>>>>>>>>>> - http://web2py.com/book (Documentation) >>>>>>>>>>> - http://github.com/web2py/web2py (Source code) >>>>>>>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>>>>>>>>> --- >>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>> Google Groups "web2py-users" group. >>>>>>>>>>> To unsubscribe from this group and stop receiving emails from >>>>>>>>>>> it, send an email to web2py+un...@googlegroups.com. >>>>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>> Resources: >>>>>>>>> - http://web2py.com >>>>>>>>> - http://web2py.com/book (Documentation) >>>>>>>>> - http://github.com/web2py/web2py (Source code) >>>>>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>>>>>>> --- >>>>>>>>> You received this message because you are subscribed to the Google >>>>>>>>> Groups "web2py-users" group. >>>>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>>>> send an email to web2py+unsubscr...@googlegroups.com. >>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Resources: >>>>>>>> - http://web2py.com >>>>>>>> - http://web2py.com/book (Documentation) >>>>>>>> - http://github.com/web2py/web2py (Source code) >>>>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>>>>>> --- >>>>>>>> You received this message because you are subscribed to a topic in >>>>>>>> the Google Groups "web2py-users" group. >>>>>>>> To unsubscribe from this topic, visit >>>>>>>> https://groups.google.com/d/topic/web2py/MTOjl8gPuTk/unsubscribe. >>>>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>>>> web2py+unsubscr...@googlegroups.com. >>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Resources: >>>>>>> - http://web2py.com >>>>>>> - http://web2py.com/book (Documentation) >>>>>>> - http://github.com/web2py/web2py (Source code) >>>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>>>>> --- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "web2py-users" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to web2py+unsubscr...@googlegroups.com. >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> >>>>> -- >>>>> Resources: >>>>> - http://web2py.com >>>>> - http://web2py.com/book (Documentation) >>>>> - http://github.com/web2py/web2py (Source code) >>>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>>> --- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "web2py-users" group. >>>>> To unsubscribe from this topic, visit https://groups.google.com/d/to >>>>> pic/web2py/MTOjl8gPuTk/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> web2py+unsubscr...@googlegroups.com. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> -- >>>> Resources: >>>> - http://web2py.com >>>> - http://web2py.com/book (Documentation) >>>> - http://github.com/web2py/web2py (Source code) >>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "web2py-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to web2py+unsubscr...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >>> Resources: >>> - http://web2py.com >>> - http://web2py.com/book (Documentation) >>> - http://github.com/web2py/web2py (Source code) >>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "web2py-users" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/to >>> pic/web2py/MTOjl8gPuTk/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> web2py+unsubscr...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to web2py+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/web2py/MTOjl8gPuTk/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
