patents

If you can pay, please consider donating to HelioHost so that you can move to production servers: Tommy or Ricky. You can donate minimum $1.

Oh. I have not thought of checking this way.

I tested my site: http://patents.heliohost.org/plrplus/ on google PageSpeed Insight and the results are:

Okay. Thanks for sharing knowlege.

HelioHost is the only to provide django+postgres.

Thanks helio.

My concern is are we using the best way to host django? nginx+uwsgi is what I here most. I have no knowledge what is for what.

Thanks again.

Thanks. It working.

When I open official django website its says.

Ridiculously fast:

but it is not the case on heliohost. Is there anything we can do?

I am able to connect to the remote connection at home. But on my work computer it is blocked.

yea tried 755, 777 for demo.py but still the same error.

https://krydos.heliohost.org/cgi-bin/modules36.py ---> cgi (I don't know what is that and how to do)

CGI is really easy. Here's a simple example:

#!/usr/bin/python3.6
print("Content-Type: text/html\n\n")
print("HelioHost rules!")

While trying python + Django, I kind of think that krydos might be using more than one folder level configurations.

for example.

http://krydos.heliohost.org/ ---> don't know which technology he is using.

https://krydos.heliohost.org/djangotest/ ---> Django

https://krydos.heliohost.org/cgi-bin/modules36.py ---> cgi (I don't know what is that and how to do)

so I tried from the tutorial in django wik (and edited it) and come to know that I can configure more than one django projects on heliohost.

I it ok to do that for normal user?

I have no plans to have thousands but one for root level and couple inside.

Is installation of postgreSQL required on my machine to access remotely?

I tried manually using python.

This is the input and output:

In [1]: import psycopg2
In [2]: conn = psycopg2.connect(database='patents_plrdb',
   ...: user='patents_plrusr',
   ...: password='',
   ...: host='tommy.heliohost.org',
   ...: port=5432)
---------------------------------------------------------------------------
OperationalError                          Traceback (most recent call last)
<ipython-input-4-3976c641658e> in <module>()
      3 password='',
      4 host='tommy.heliohost.org',
----> 5 port=5432)


C:\Users\rahulkumar.patel\AppData\Roaming\plrplus\WinPython-32bit-3.6.2.0Qt5\python-3.6.2\lib\site-packages\psycopg2\__init__.py in connect(dsn, connection_factory, cursor_factory, **kwargs)
    128 
    129     dsn = _ext.make_dsn(dsn, **kwargs)
--> 130     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
    131     if cursor_factory is not None:
    132         conn.cursor_factory = cursor_factory


OperationalError: could not connect to server: Connection timed out (0x0000274C/10060)
Is the server running on host "tommy.heliohost.org" (65.19.143.6) and accepting
TCP/IP connections on port 5432?

I am still not able to access the remote db.

I tried.

DATABASES = {
    'default': {     
        
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'patents_plrdb',                      
        'USER': 'patents_plrusr',
        'PASSWORD': '',
        'HOST': 'tommy.heliohost.org',
        'PORT': '5432',
        
    }
}

'HOST': '65.19.143.6',

if yes:
    username: patents_plrusr
    database: patents_plrdb
    user(off course): patents
else:
    no worry.

Access to all IPs needed as I dont have static IP.

Thanks.

Can you install docxtpl on tommy, python 3.6.3?

Thanks.

Oh I got it.

It means other than me nobody trying django + postgress on heliohost.

Please install psycopg2.

I am still not able to use postgresql with django on tommy.

Here is what I have tried so far,

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'patents_posttest',
        'USER': 'patents_postusr',
        'PASSWORD': 'pass',
        'HOST': '65.19.143.6',
        'PORT': '5432',
    }
}

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'patents_posttest',
        'USER': 'patents_postusr',
        'PASSWORD': 'pass',
        'HOST': '65.19.143.6',
        'PORT': '5433',
    }
}

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'patents_posttest',
        'USER': 'patents_postusr',
        'PASSWORD': 'pass',
        'HOST': 'localhost',
        'PORT': '',
    }
}

What is username and password? cpannel or created in mysql wizard?

I just created demo username and password from cpannel mysql wizard.

db = patents_demodb

user=patents_demousr

pass=demopass

if you have local python, and mysql driver, can you try this for me please?

import MySQLdb
myDB = MySQLdb.connect(host="65.19.143.6",port=3306,user="patents_demousr",passwd="demopass",db="patents_demodb")

I shall delete the same after confirmation.

Thanks.

It doesn't work. Same Error. This is also open issue. https://www.helionet.org/index/topic/27644-tommy-mysql-remote-connections-not-working/.

It seems there is something wrong with remote database on tommy.

I can see that page. I was checking weather I had access to port but could not find any solution. Thanks.

I tried manually connecting using:

import MySQLdb
myDB = MySQLdb.connect(host="tommy.heliohost.org",port=3306,user="patents_mypollsu",passwd="XXXXX",db="patents_mypolls")

but it gives same error:

OperationalError: (2003, "Can't connect to MySQL server on 'tommy.heliohost.org' (10060)")

Also tried host="65.19.143.6" but again same error. I don't know what is the matter.

On searching the internet I came to know that 10060 is related to remote access. It means that the remote access is not enabled.

I added % in my remote mysql db on cpannel tab. Is there anything else i need to do?

Thanks.

Thanks. It worked.

Username is Patents.

I tried but for me the remote mysql is not working for my computer. This is my database setting for remote mysql. I added % in the allowed host.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'patents_mypolls',
        'USER': 'patents_mypollsu',
        'PASSWORD': 'mypass',
        'HOST': 'tommy.heliohost.org',
        'PORT': '3306',
    }
}

This is my remote Mysql allowed hosts:

Access Hosts

%

65.19.143.6

I get error:

django.db.utils.OperationalError: (2003, "Can't connect to MySQL server on 'tommy.heliohost.org' (10060)")

I think the port 3306 is blocked on my computer and I don't know how to fix it. I am on windos 7.