Jump to content

oswako

Members
 View Profile  See their activity

  • Posts

    13

  • Joined

  • Last visited

 Content Type 

Posts posted by oswako

    [Solved] Import Psycopg2 Library Make My Flask Application No Work Properly

    in Customer Service

    Posted

    Hi

     

    I have a flask application that runs perfectly when passing a json package, and returns the same package to the client with no problems but when importing psycopg2 the json package returned is "None" and client complain about the parsing something that is not a json package.

     

    Working Code using json library:

     

    #!/usr/bin/env python
    import sys
    #import psycopg2
    import json
    from flask import Flask,request,jsonify, __version__
    app = Flask(__name__)
    application = app
    @app.route("/")
    def hello():
    return """
    HelioHost rules!<br><br>
    <a href="/flask/python/version/">Python version</a><br>
    <a href="/flask/flask/version/">Flask version</a>
    """
    @app.route("/python/version/")
    def p_version():
    return "Python version %s" % sys.version
    @app.route("/flask/version/")
    def f_version():
    return "Flask version %s" % __version__
    @app.route("/mother")
    def mother():
    return "Hello world mother"
    @app.route("/jsonp",methods=['POST'])
    def jsonp():
    webdatajson = request.get_json() # get json package
    #datajson = jsonify(webdatajson) #make a json package to send back
    datajson = json.dumps(webdatajson) #makes a json package to send back
    return(datajson)
    if __name__ == "__main__":
    app.run()

     

    Another working code using jsonify from flask:

     

    #!/usr/bin/env python
    import sys
    #import psycopg2
    import json
    from flask import Flask,request,jsonify, __version__
    app = Flask(__name__)
    application = app
    @app.route("/")
    def hello():
    return """
    HelioHost rules!<br><br>
    <a href="/flask/python/version/">Python version</a><br>
    <a href="/flask/flask/version/">Flask version</a>
    """
    @app.route("/python/version/")
    def p_version():
    return "Python version %s" % sys.version
    @app.route("/flask/version/")
    def f_version():
    return "Flask version %s" % __version__
    @app.route("/mother")
    def mother():
    return "Hello world mother"
    @app.route("/jsonp",methods=['POST'])
    def jsonp():
    webdatajson = request.get_json() # get json package
    datajson = jsonify(webdatajson) #make a json package to send back
    #datajson = json.dumps(webdatajson) #makes a json package to send back
    return(datajson)
    if __name__ == "__main__":
    app.run()

     

     

     

    NOT WORKING CODE once importing psycopg2:

     

    #!/usr/bin/env python
    import sys
    import psycopg2
    import json
    from flask import Flask,request,jsonify, __version__
    app = Flask(__name__)
    application = app
    @app.route("/")
    def hello():
    return """
    HelioHost rules!<br><br>
    <a href="/flask/python/version/">Python version</a><br>
    <a href="/flask/flask/version/">Flask version</a>
    """
    @app.route("/python/version/")
    def p_version():
    return "Python version %s" % sys.version
    @app.route("/flask/version/")
    def f_version():
    return "Flask version %s" % __version__
    @app.route("/mother")
    def mother():
    return "Hello world mother"
    @app.route("/jsonp",methods=['POST'])
    def jsonp():
    webdatajson = request.get_json() # get json package
    #datajson = jsonify(webdatajson) #make a json package to send back
    datajson = json.dumps(webdatajson) #makes a json package to send back
    return(datajson)
    if __name__ == "__main__":
    app.run()

     

    I'm trying to get the json from the client and then store the data into the postgresql that is why i need the psycopg2 adapter.

     

    Is this adapter installed or am I doing something wrong?

     

    Also for the future when connecting to the postgresql database from the flask app how should I specify the host? ("http://localhost:5432" or "http://ricky.heliohost.org:5432")

     

    Thanks in advanced



    Forgot to mention my data

     

    username: ioteche
    domain: ioteche.heliohost.org
    server: Ricky

    Web App With Web.py On Heliohost Johnny Server

    in Customer Service

    Posted

    Hello , I have Change Server to Ricky and requested remote postgresql connections, now I'm trying to run flask on Ricky as described in the following link http://www.helionet....ohnny/?p=128919, but all I can see when I try to run the application in my browser as http://ioteche.heliohost.org/flask/ and the result is:

    Index of /flask Name Last modified Size Description Parent Directory - a.htaccess 2017-06-12 07:45 185 flask.wsgi 2017-06-12 07:46 253 myapp.py 2017-06-12 08:02 526

     

    Also if I type the http://ioteche.heliohost.org/flask/myapp.py the code text shows up like this:

     

    #!/usr/bin/env python
    import sys

    from flask import Flask, __version__
    app = Flask(__name__)
    application = app

    @app.route("/")
    def hello():
    return """

    HelioHost rules!<br><br>
    <a href="/flask/python/version/">Python version</a><br>
    <a href="/flask/flask/version/">Flask version</a>

    """

    @app.route("/python/version/")
    def p_version():
    return "Python version %s" % sys.version

    @app.route("/flask/version/")
    def f_version():
    return "Flask version %s" % __version__

    if __name__ == "__main__":
    app.run()

     

    I would like to use python 2.7 version with flask on Ricky, at this time I'm just following the little flask tutorial posted on your forum, link that is written on the top of this message.

     

    What I'm doing wrong?

     

    thanks in advance

    Web App With Web.py On Heliohost Johnny Server

    in Customer Service

    Posted

    Hello

     

    I need to run a web app with web.py, Some other devices will Post and Get to the App and this last one needs to be able to reply to the caller with a json package, eventually this App will connect to the postgres database already in place here at heliohost.

    But I have encounter problems when trying to run the python script. and want to know if this is even possible to do here at Helioshost.

     

    Configuration:

     

    Server: jhonny

    Website: oswako.helioshost.org/cgi-bin/helloword.py

    File path: public_html/cgi-bin/helloworld.py

    File Permission: 755

     

    Code:

     

    #!/usr/bin/env python
    import psycopg2
    import web
    import json
    print("Content-type: text/html\n\n")
    urls = (
    '/', 'index',
    '/jsonp', 'jsonp'
    )
    class index:
    def GET(self):
    return "Hello, world!"
    class jsonp:
    def POST(self):
    data = json.loads(web.data())
    print data['ID']
    print data['MAC']
    web.header('Content-Type', 'application/json')
    return json.dumps(data)
    if __name__ == '__main__':
    app = web.application(urls,globals())
    app.run()

     

    Note: The code has been verify on python and works fine on http://localhost:8080/ returning hello world.

     

     

    Error:

     

    when I try to run it in oswako.heliohost.org/cgi-bin/helloworld.py/ comes back with:

    Internal Server Error

    The server encountered an internal error or misconfiguration and was unable to complete your request.

    Please contact the server administrator, webmaster@oswako.heliohost.org and inform them of the time the error occurred, and anything you might have done that may have caused the error.

    More information about this error may be available in the server error log.

    Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

     

    I have seem other forums from people trying to do something like this on helioshost but I can't find out if they were successful or not.

     

    thank you for your guidance and help in advanced.

     

    Oswaldo

    [Solved] Requesting Postgresql Db Access From Pgadmin 4 & From Any Ip

    in Escalated Requests

    Posted

    I'm requesting access to my postgresql database in johnny server via pgadmin 4 for any ip that tries to connect to:

     

    host; johnny.heliohost.org

    maintenance DB: oswako_ioteche

    username: oswako_postgres

    password: *********

    port: 5432

     

    Note: the error displayed when I'm trying to connect through pgadmin 4 is FATAL: no pg_hba.conf entry for host "216.75.232.58", user "oswako_postgres", database "oswako_ioteche", SSL off

     

    Please let me know if you need any other info or I"m missing something.

     

    Thank you

     

     

     

×
×
  • Create New...