Jump to content

All Activity

This stream auto-updates

  1. Today
  2. I understand that the database connection limit on HelioHost is restricted to 10 simultaneous connections. To ensure that my application does not exceed this limit, I tried two different approaches, but both resulted in errors. First Approach: Using SQLAlchemy Advanced Configuration I configured the SQLALCHEMY_ENGINE_OPTIONS as follows: SQLALCHEMY_ENGINE_OPTIONS = { 'pool_size': 5, 'max_overflow': 2, 'pool_timeout': 20, 'pool_recycle': 280, 'connect_args': { 'connect_timeout': 10 # 10-second timeout for database connections } } However, this resulted in the following errors: 2025-04-16 03:19:26 Error 186.205.7.186 504 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 967 Apache SSL/TLS access 2025-04-16 03:19:47 Error 186.205.7.186 504 GET /bma/flask.wsgi/usuarios HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/usuarios/11 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 967 Apache SSL/TLS access 2025-04-16 03:20:26 Error 186.205.7.186 Timeout when reading response headers from daemon process 'talesaz_wsgi': /home/talesaz.heliohost.us/httpdocs/bma/flask.wsgi Apache error Second Approach: Managing Connections Manually I then tried to manually open and close connections for each request using the following code: @app.before_request def before_request(): g.db = db.session() @app.teardown_request def teardown_request(exception): db.session.remove() Unfortunately, this also resulted in errors: 2025-04-16 03:55:58 Error 186.205.7.186 500 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 986 Apache SSL/TLS access 2025-04-16 03:59:18 Error 186.205.7.186 500 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 986 Apache SSL/TLS access Could you please provide any guidance or tips on how to ensure that my application does not exceed the connection limit imposed by HelioHost? I would greatly appreciate any advice on how to configure SQLAlchemy or manage connections more effectively in this environment. Thank you in advance for your help!
  3. [Tue Apr 15 23:37:05.906471 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ret = self._execute_context( [Tue Apr 15 23:37:05.906475 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ^^^^^^^^^^^^^^^^^^^^^^ [Tue Apr 15 23:37:05.906480 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1818, in _execute_context [Tue Apr 15 23:37:05.906484 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] self._handle_dbapi_exception( [Tue Apr 15 23:37:05.906489 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2352, in _handle_dbapi_exception [Tue Apr 15 23:37:05.906495 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] raise sqlalchemy_exception.with_traceback(exc_info[2]) from e [Tue Apr 15 23:37:05.906499 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1812, in _execute_context [Tue Apr 15 23:37:05.906504 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] context = constructor( [Tue Apr 15 23:37:05.906509 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ^^^^^^^^^^^^ [Tue Apr 15 23:37:05.906513 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 1429, in _init_compiled [Tue Apr 15 23:37:05.906518 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] self.cursor = self.create_cursor() [Tue Apr 15 23:37:05.906523 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ^^^^^^^^^^^^^^^^^^^^ [Tue Apr 15 23:37:05.906527 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 1768, in create_cursor [Tue Apr 15 23:37:05.906532 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] return self.create_default_cursor() [Tue Apr 15 23:37:05.906536 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [Tue Apr 15 23:37:05.906541 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/dialects/mysql/mysqlconnector.py", line 59, in create_default_cursor [Tue Apr 15 23:37:05.906546 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] return self._dbapi_connection.cursor(buffered=True) [Tue Apr 15 23:37:05.906550 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [Tue Apr 15 23:37:05.906555 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 1486, in cursor [Tue Apr 15 23:37:05.906560 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] return self.dbapi_connection.cursor(*args, **kwargs) [Tue Apr 15 23:37:05.906564 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [Tue Apr 15 23:37:05.906569 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/mysql/connector/connection_cext.py", line 824, in cursor [Tue Apr 15 23:37:05.906573 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] raise OperationalError("MySQL Connection not available.") [Tue Apr 15 23:37:05.906581 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] sqlalchemy.exc.OperationalError: (mysql.connector.errors.OperationalError) MySQL Connection not available. MariaDB hasn't restarted for 8 hours, and has had 100% uptime during this error. How many database connections are you using? We limit people to 10 connections so if you try to open more than 10 connections it would explain why you can't open more connections. We used to offer unlimited database connections, but some jerk decided to take advantage of our generosity by opening 173 connections and never closing any of them. One jerk always ruins the fun for everyone else.
  4. Domain added. We can't enable WSGI control until a flask app is installed on the domain (the wsgi file has to exist before we can enable it), so you'll need to install an app first (it can be anything, even a hello world app, as long as it exists). The domain will take up to 2 hours to start working.
  5. Yesterday
  6. Hi Guy, Could you create a second website,talesazoeto.heliohost.us (or something similar), with WSGI restart access enabled? Thank you so much!
  7. Now it works! Thank you so much! Sometimes the website still shows a 500 Internal Server Error, but much less frequently than yesterday, and refreshing the page usually resolves it. The logs don’t provide much information about how to address the issue: 2025-04-15 23:28:23 Error 186.205.7.186 500 GET /bma/flask.wsgi/usuarios/cadastrar HTTP/1.0https://talesaz.heliohost.us/bma/flask.wsgi/conteudo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1000 Apache SSL/TLS access 2025-04-15 23:28:25 Access 186.205.7.186 200 GET /bma/flask.wsgi/usuarios/cadastrar HTTP/1.0https://talesaz.heliohost.us/bma/flask.wsgi/conteudo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 10.8 K Apache SSL/TLS access If you could provide more detailed logs for this event at this timestamp, I would greatly appreciate it.
  8. WSGI control access has been enabled on the domain app.zhirofund.com. To restart your Django app and load new code changes in simply edit /home/app.zhirofund.com/httpdocs/djangotest/djangotest/dispatch.wsgi. Adding a blank line, removing a blank line, adding a space, or removing a space are examples of editing the file. As long as the last modified timestamp changes it will clear the server cache. Let us know if you run into any issues.
  9. This support request is being escalated to our root admins who can set that up for you.
  10. Request WSGI Control Access username: szhiro domain: app.zhirofund.com
  11. WSGI control access has been enabled on the domain talesaz.heliohost.us. To restart your Flask app and load new code changes in simply edit /home/talesaz.heliohost.us/httpdocs/bma/flask.wsgi. Adding a blank line, removing a blank line, adding a space, or removing a space are examples of editing the file. As long as the last modified timestamp changes it will clear the server cache. Let us know if you run into any issues. If you get a 500 error check the error logs, and if there isn't much useful information in there let us know and we may be able to get some more logs for you. Plesk isn't very good at filtering Flask logs into the right user accessible logs. At least with WSGI restart access you won't get 500 errors from bugs that you've already fixed, which is very confusing and frustrating.
  12. Domain added. it can take up to 2 hours to start working.
  13. Sorry, I didn’t read this article earlier, so I didn’t restart. Could you grant me WSGI Control Access? My username is talesaz, and my URL is talesaz.heliohost.us:https://talesaz.heliohost.us/bma.
  14. Hello, When convenient, can you please add "smoothtalker.fwh.is" to my domain list for account under the name "fatalslink" please? Thanks a million! Best, Mike
  15. Did you request WSGI restart access? Source: https://wiki.helionet.org/Flask#WSGI_Uses_Caching
  16. Yes, please reset the account, that'd be great. And if you could tell me if there's a way to install it without errors, properly. I don't want to have to reset the account. Laravel is all confusing, and I can't even tell if the Laravel application I bought is compatible with heliohost :')
  17. I've removed those 2 domains from your account. Please note there is a risk of data loss when domains are removed, since the folder for the domain inside Plesk will be deleted. I made a full account backup for you before I removed the domains, in case you need any of the old files. You can download the backup here: https://heliohost.org/backup If you're not sure how to extract the backup files, please follow our how-to guide here: https://wiki.helionet.org/Account_Backups I've also added the new domains to your account for you. Please note that it may take up to 2 hours for the domain changes to take effect. If after a full 2 hours it doesn't work on your side, please make sure you clear your web browser cache: https://wiki.helionet.org/Clear_Your_Cache
  18. It looks like you just created your account today. Websites can take several weeks to months to appear on Google. It just happens whenever Google gets around indexing it. We don't have any control over that. You could sign up for the Google search console and submit it for indexing to help speed this up. As for the SEO tools in Plesk, we don't have a license for the premium version, so the rank tracker feature does not work. The free version only has the site audit.
  19. I've reset your account as requested. You should receive an email shortly so you can take the next steps to recreate it. I made a backup before the reset, so if you discover you need any of your old files, you can download the backup here: https://heliohost.org/backup If you're not sure how to extract the backup files, please follow our how-to guide here: https://wiki.helionet.org/Account_Backups
  20. Krydos might have more of an idea about why this would happen. I'm not terribly familiar with Python...escalating.
  21. i want remove * media.orcagroup.top and add * portfolio.orcagroup.top * payments.orcagroup.top * forms.orcagroup.top * forbidden.orcagroup.top * docs.orcagroup.top * test.orcagroup.top
  22. hey please wipe out my account to restart fresh account
  23. I'm on the free plan and have that domain. From there, when I try to add keywords to SEO for ranking, I see there are 5, but when I add even 1, it won't let me, saying: Keyword limit is reached. Please contact your administrator. And the counter shows a negative -1. How do I fix this? Nowhere does it mention that I have to pay for this option; it just says to exceed the limit without doing so. I'd also like to know why www.colegiosantoangel.helioho.st doesn't appear in Google with the suffix Colegio Santo Angel Flandes. It should appear, but it doesn't, and Plesk tells me it's well-positioned as such. user brayan2005 I'm looking forward to your response, thank you.
  24. I am encountering an intermittent issue with my Flask application using Flask-SQLAlchemy. The application works for a while, but after refreshing the page a few times, it throws the following error: RuntimeError: Either 'SQLALCHEMY_DATABASE_URI' or 'SQLALCHEMY_BINDS' must be set. Error Context: The error appears in the Apache logs as follows: mod_wsgi (pid=3543435): Exception occurred processing WSGI script '/home/talesaz.heliohost.us/httpdocs/bma/flask.wsgi'. RuntimeError: Either 'SQLALCHEMY_DATABASE_URI' or 'SQLALCHEMY_BINDS' must be set. What I Have Tried: 1) Direct Configuration in config.py: I am not using .env files anymore. All configurations are directly set in config.py. 2) Database Connection Test: I added a test in run.py to check the database connection. 3) Error Handling: I added a generic error handler to capture unexpected exceptions. Behavior Observed: - The application works initially and connects to the database successfully. - After refreshing the page a few times, the error appears. - Refreshing the page again sometimes resolves the issue temporarily. - When running the application locally (on my machine) and connecting to the same MySQL database hosted on HelioHost, everything works perfectly without any issues. - The problem only occurs when the application is hosted directly on HelioHost.
  25. Yeah, Laravel breaks your account if you delete it after installing it using the toolkit. There is no uninstall option, you have to reset your account. Someone did submit a suggestion to Plesk for an uninstall/detach option for Laravel Toolkit (you can vote for it here on Plesk's site), but it has not been added to date. Do you want me to reset your account completely so you can start over (all content will be deleted)?
  26. There's a Logs option in Plesk that show Python errors...they're a bit hard to read because of how Plesk formats them,. but the whole thing including the trace is there. The last line kind of explains it though...your error is this: ModuleNotFoundError: No module named 'pymysql' The modules available on Tommy are shown here: https://krydos1.heliohost.org/pyinfo/info3.12.py You can also request that module be added if you need it.
  1. Load more activity
×
×
  • Create New...