ModuleNotFoundError: No module named 'sqlalchemy' #28

New issue

Open

opened 2025-10-14 17:27:43 -06:00 by navan · 0 comments

navan commented

2025-10-14 17:27:43 -06:00

Owner

Originally created by @simonmacdonald on 10/31/2021

I am new to Python and program-y
I am running an AWS EC2 server using Amazon Linux
Python v3.7
Program-y v.5.0.1 from pyp1.org

As far as I can see I have installed Program-y correctly in a test virtual environment and downloaded y-bot.
Running the bot resuts in

👍 Traceback (most recent call last):
  File "/usr/lib64/python3.7/runpy.py", line 193, in _run_module_as_main
    "__main__", mod_spec)
  File "/usr/lib64/python3.7/runpy.py", line 85, in _run_code
    exec(code, run_globals)
  File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/clients/events/console/client.py", line 19, in <module>
    from programy.clients.events.client import EventBotClient
  File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/clients/events/client.py", line 19, in <module>
    from programy.clients.client import BotClient
  File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/clients/client.py", line 37, in <module>
    from programy.clients.botfactory import BotFactory
  File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/clients/botfactory.py", line 19, in <module>
    from programy.bot import Bot
  File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/bot.py", line 29, in <module>
    from programy.clients.config import ClientConfigurationData
  File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/clients/config.py", line 21, in <module>
    from programy.storage.config import StorageConfiguration
  File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/storage/config.py", line 21, in <module>
    from programy.storage.stores.sql.config import SQLStorageConfiguration
  File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/storage/stores/sql/config.py", line 19, in <module>
    from programy.storage.stores.sql.engine import SQLStorageEngine
  File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/storage/stores/sql/engine.py", line 17, in <module>
    from sqlalchemy import create_engine
ModuleNotFoundError: No module named 'sqlalchemy'

As far as I can tell from 'pip list' SQLAlchemy 1.3.12 is installed.

The $PYTHONPATH -

(testbot) [ec2-user@quiraang xnix]$ echo "$PYTHONPATH" | tr ":" "\n" | nl

     1  /usr/lib64/python3.7/site-packages
     2  /usr/local/lib64/python3.7/site-packages
     3  /usr/lib/python3.7/site-packages
     4  /home/ec2-user/mybots/testbot/lib64/python3.7/site-packages

I'm obviously doing something wrong - any advice would be grateful.
Thank you.

*Originally created by @simonmacdonald on 10/31/2021* I am new to Python and program-y I am running an AWS EC2 server using Amazon Linux Python v3.7 Program-y v.5.0.1 from pyp1.org As far as I can see I have installed Program-y correctly in a test virtual environment and downloaded y-bot. Running the bot resuts in ~~~ 👍 Traceback (most recent call last): File "/usr/lib64/python3.7/runpy.py", line 193, in _run_module_as_main "__main__", mod_spec) File "/usr/lib64/python3.7/runpy.py", line 85, in _run_code exec(code, run_globals) File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/clients/events/console/client.py", line 19, in <module> from programy.clients.events.client import EventBotClient File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/clients/events/client.py", line 19, in <module> from programy.clients.client import BotClient File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/clients/client.py", line 37, in <module> from programy.clients.botfactory import BotFactory File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/clients/botfactory.py", line 19, in <module> from programy.bot import Bot File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/bot.py", line 29, in <module> from programy.clients.config import ClientConfigurationData File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/clients/config.py", line 21, in <module> from programy.storage.config import StorageConfiguration File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/storage/config.py", line 21, in <module> from programy.storage.stores.sql.config import SQLStorageConfiguration File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/storage/stores/sql/config.py", line 19, in <module> from programy.storage.stores.sql.engine import SQLStorageEngine File "/home/ec2-user/mybots/testbot/lib64/python3.7/site-packages/programy/storage/stores/sql/engine.py", line 17, in <module> from sqlalchemy import create_engine ModuleNotFoundError: No module named 'sqlalchemy' ~~~ As far as I can tell from 'pip list' SQLAlchemy 1.3.12 is installed. The $PYTHONPATH - ~~~ (testbot) [ec2-user@quiraang xnix]$ echo "$PYTHONPATH" | tr ":" "\n" | nl 1 /usr/lib64/python3.7/site-packages 2 /usr/local/lib64/python3.7/site-packages 3 /usr/lib/python3.7/site-packages 4 /home/ec2-user/mybots/testbot/lib64/python3.7/site-packages ~~~ I'm obviously doing something wrong - any advice would be grateful. Thank you.

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: github/program-y#28

No description provided.

Rows
Columns