-
Posts
24,600 -
Joined
-
Last visited
-
Days Won
871
Everything posted by Krydos
-
[Solved] Remote access for PostgreSQL database on Ricky
Krydos replied to gtchuah's topic in Escalated Requests
Remote access enabled. -
Still the same error as yesterday, only now there is another write permission error on the log file: [Thu Feb 13 02:22:16.431547 2020] [wsgi:error] [pid 6287] /usr/local/python3.7/lib/python3.7/site-packages/dotenv/main.py:52: UserWarning: File doesn't exist [Thu Feb 13 02:22:16.431630 2020] [wsgi:error] [pid 6287] warnings.warn("File doesn't exist {}".format(self.dotenv_path)) # type: ignore [Thu Feb 13 02:22:16.656787 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] mod_wsgi (pid=6287): Failed to exec Python script file '/home/nutra/public_html/api/flask.wsgi'. [Thu Feb 13 02:22:16.656925 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] mod_wsgi (pid=6287): Exception occurred processing WSGI script '/home/nutra/public_html/api/flask.wsgi'. [Thu Feb 13 02:22:16.716822 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] Traceback (most recent call last): [Thu Feb 13 02:22:16.716987 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] File "/home/nutra/public_html/api/flask.wsgi", line 9, in <module> [Thu Feb 13 02:22:16.717013 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] from server import app [Thu Feb 13 02:22:16.717040 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] File "/home/nutra/public_html/api/server.py", line 17, in <module> [Thu Feb 13 02:22:16.717057 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] from ntserv.accounts import ( [Thu Feb 13 02:22:16.717082 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] File "/home/nutra/public_html/api/ntserv/accounts.py", line 11, in <module> [Thu Feb 13 02:22:16.717099 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] from .postgres import psql [Thu Feb 13 02:22:16.717122 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] File "/home/nutra/public_html/api/ntserv/postgres.py", line 14, in <module> [Thu Feb 13 02:22:16.717138 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] options=f"-c search_path={PSQL_SCHEMA}", [Thu Feb 13 02:22:16.717164 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] File "/usr/local/python3.7/lib/python3.7/site-packages/psycopg2/__init__.py", line 126, in connect [Thu Feb 13 02:22:16.717216 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] conn = _connect(dsn, connection_factory=connection_factory, **kwasync) [Thu Feb 13 02:22:16.717291 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] psycopg2.OperationalError: FATAL: no pg_hba.conf entry for host "::1", user "root", database "nutra", SSL off [Thu Feb 13 02:22:16.717314 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] [Thu Feb 13 02:22:16.717346 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] [Thu Feb 13 02:22:16.717363 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] During handling of the above exception, another exception occurred: [Thu Feb 13 02:22:16.717425 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] [Thu Feb 13 02:22:16.717464 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] Traceback (most recent call last): [Thu Feb 13 02:22:16.717523 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] File "/home/nutra/public_html/api/flask.wsgi", line 20, in <module> [Thu Feb 13 02:22:16.717544 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] with open('error.txt', 'w+') as f: [Thu Feb 13 02:22:16.717597 2020] [wsgi:error] [pid 6287] [client 65.19.141.66:62057] PermissionError: [Errno 13] Permission denied: 'error.txt'
-
There you go https://krydos2.heliohost.org/cgi-bin/modules37.py
-
Unarchived. You'll need to reset your password before you'll be able to log in.
-
[Inactive] SSL Page Still Still Showing Up Even After Configured
Krydos replied to taylors1's topic in Customer Service
You get the error messages in your browser because you have self-signed certificates installed. You have to install certificates from a valid certificate authority like Let's Encrypt to get ssl without the warnings. We recommend this guide https://wiki.helionet.org/Installing_a_Let%27s_Encrypt_SSL_Certificate -
[Wed Feb 12 04:01:47.630248 2020] [wsgi:error] [pid 10510] /usr/local/python3.7/lib/python3.7/site-packages/dotenv/main.py:52: UserWarning: File doesn't exist [Wed Feb 12 04:01:47.630302 2020] [wsgi:error] [pid 10510] warnings.warn("File doesn't exist {}".format(self.dotenv_path)) # type: ignore [Wed Feb 12 04:01:48.077793 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] mod_wsgi (pid=10510): Failed to exec Python script file '/home/nutra/public_html/api/flask.wsgi'. [Wed Feb 12 04:01:48.077974 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] mod_wsgi (pid=10510): Exception occurred processing WSGI script '/home/nutra/public_html/api/flask.wsgi'. [Wed Feb 12 04:01:48.120412 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] Traceback (most recent call last): [Wed Feb 12 04:01:48.120571 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] File "/home/nutra/public_html/api/flask.wsgi", line 7, in <module> [Wed Feb 12 04:01:48.120600 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] from server import app as application [Wed Feb 12 04:01:48.120628 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] File "/home/nutra/public_html/api/server.py", line 17, in <module> [Wed Feb 12 04:01:48.120645 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] from ntserv.accounts import ( [Wed Feb 12 04:01:48.120670 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] File "/home/nutra/public_html/api/ntserv/accounts.py", line 11, in <module> [Wed Feb 12 04:01:48.120687 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] from .postgres import psql [Wed Feb 12 04:01:48.120710 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] File "/home/nutra/public_html/api/ntserv/postgres.py", line 14, in <module> [Wed Feb 12 04:01:48.120727 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] options=f"-c search_path={PSQL_SCHEMA}", [Wed Feb 12 04:01:48.120752 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] File "/usr/local/python3.7/lib/python3.7/site-packages/psycopg2/__init__.py", line 126, in connect [Wed Feb 12 04:01:48.120769 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] conn = _connect(dsn, connection_factory=connection_factory, **kwasync) [Wed Feb 12 04:01:48.120843 2020] [wsgi:error] [pid 10510] [client 65.19.141.66:56883] psycopg2.OperationalError: FATAL: no pg_hba.conf entry for host "::1", user "root", database "nutra", SSL off You're trying to connect to postgres with the username root. That's never going to work. If you look at the first two lines, it looks to me like it's not finding your .env file.
-
[Solved] Remote access for PostgreSQL db in Johnny
Krydos replied to stewartp's topic in Escalated Requests
Remote access enabled. -
These two lines have to reference the same file name. In the top line you say the file is named api.wsgi, and in the second line you say it's flask.wsgi. Which one is it actually? The logic behind these two lines is the first one says "Is the request going through api.wsgi? If so stop processing rules and leave the request as is." The second line basically says, "If the request isn't going to flask.wsgi already redirect the request and process it through the .wsgi file." Since the two lines don't reference the same file name it just endlessly loops.
-
/usr/local/bin/php should work and on Johnny it's php 7.2 Here's the errors your script is showing: PHP Warning: fopen(../../cgi-bin/div_radar_cgi/curl_log_updateStocks.txt): failed to open stream: No such file or directory in /home/ckuo/public_html/div_radar/tools/updateStocks.php on line 15 PHP Warning: curl_setopt(): supplied argument is not a valid File-Handle resource in /home/ckuo/public_html/div_radar/tools/updateStocks.php on line 17 d1 = 2020/02/11 d7 = 2020/02/18 PHP Warning: fclose() expects parameter 1 to be resource, bool given in /home/ckuo/public_html/div_radar/tools/updateStocks.php on line 25
-
Unarchived.
-
Unarchived. Your username is skab33 now.
-
Your backup can be downloaded from https://www.heliohost.org/backup/
-
[Solved] Support Email Robots Stuck in a Loop :P
Krydos replied to wolstech's topic in Escalated Requests
I added that email address to the blacklist so even if they send another email it won't start a loop again. -
Remote access enabled.
- 2 replies
-
- Postgresql
- access
-
(and 1 more)
Tagged with:
-
[Inactive] Tommy MySQL Too Many Connections
Krydos replied to wolstech's topic in Escalated Requests
Probably. Every two hours mysql closes all the connections so that helps clear out the people who might be abusing the server. I have seen error logs showing the too many connections error, but I've never been at a computer when it was happening. For now I doubled the number of total available connections so that should help a little, but if someone is determined to try to crash the server they will still be able to since we don't have a per user limit. If you see this while it's happening run the command ./mysql_connections and it'll print them all out for you. I can set up automated logging if neither of us are able to run that command while the server is maxed out on connections. -
[Solved] Remote access for PostgreSQL database on Jonhny
Krydos replied to rehub's topic in Escalated Requests
When I originally created my first HelioHost account I had to stay up until 2am three nights in a row to get an account because I was too slow the first two days. Back then there was no option to donate to get an account on the best server so you're lucky that that exists. -
[Solved] Remote access for PostgreSQL db in Johnny
Krydos replied to linuxct's topic in Escalated Requests
Remote access enabled. -
[Solved] Remote access for PostgreSQL database on Jonhny
Krydos replied to rehub's topic in Escalated Requests
Remote access enabled. -
Merged threads about the same thing.
-
Unarchived.
-
I already deleted his domain, and re-added it once. It didn't help last time. Back to the original point of this thread, AutoSSL isn't going to work as long as your nameservers don't show up for 50% of the world, but you still may be able to manually install an ssl certificate using our instructions here https://wiki.helionet.org/Installing_a_Let%27s_Encrypt_SSL_Certificate
-
Removed.
-
[Solved] Tax Deduction information about donations and such
Krydos replied to a topic in Escalated Requests
I summed, created, signed, and sent a receipt for Roy's 2019 donations.