Hi, I now have more information about my project: web2py server acting as a bridge between two other non-web2py remote servers.
I was instructed that the way to access the remote mysql db is via VPN. Do you have any recommendations to establish a web2py db connection: - from: my web2py ubuntu server (using its own different local postgresql db), - to: a remote win server 2008 R2 non-web2py server, using mysql 5.1, via VPN?. Should I use "VPS tunneling"?. Once I connect to the VPN, should I keep this connection "open" for future remote db access?. Can I somehow use web2py pooling in this scenario?. Does ubuntu server have packages that allow me to accomplish all this?. All recommendations are very welcome, thanks!, Carlos On Saturday, April 21, 2012 10:31:35 PM UTC-5, Carlos wrote: > > Hi Bruce, > > It would be awesome if I could use web2py to connect to the remote MySQL > server (using DAL to manipulate the database, instead of raw SQL commands), > I really hope so, but I still can't confirm this, until maybe Monday or > Tuesday when I will have more information about this. > > I'll likely come back here again to ask more related questions, when I > actually have more specific information. > > Thanks again for your input! > > Carlos > > On Saturday, April 21, 2012 9:15:17 PM UTC-5, Bruce Wade wrote: >> >> If you are going to have access to the database server, then why not just >> write the api with web2py and use web2py DAL to connect and execute >> commands. Otherwise you will need another RPC server or something on the >> database server to do mysql queries. >> >> Like this site I did: 96.126.99.73 has web2py running on 3 different >> servers that visitors are dynamically connected to (using stickiness). Each >> of them servers connect to 3 different databases on completely different >> servers depending on what information they need. >> >> On Sat, Apr 21, 2012 at 7:02 PM, Carlos <carlosgali...@gmail.com> wrote: >> >>> Thanks for your responses Bruce and Jonathan. >>> >>> With respect to Bruce's questions: >>> >>> >> Do you want to basically get a request from the client and pass that >>> request to a server/mysql which will determine what to do with the request, >>> return you data and that data is returned back to the client? >>> >>> Basically, yes. >>> >>> >> How is the non-web2py server listening for connections? Does it >>> already have an api programmed or is that also your task? >>> >>> There's no api, it's also part of my question, do you recommend any >>> specific api to connect a web2py server (SYS) to a remote non-web2py MySql >>> server (SERVER)?, I will likely have remote access to the computer where >>> MySQL runs, but I have no idea how to configure such server to accept >>> remote connections to execute remote SQL commands from my web2py SYS server. >>> >>> Thanks again. >>> >>> On Saturday, April 21, 2012 1:57:27 PM UTC-5, Bruce Wade wrote: >>>> >>>> Hi Carlos, >>>> >>>> Thanks for clarifying. >>>> >>>> Do you know how can my web2py server connect remotely to a non-web2py >>>> server to execute some SQL commands? >>>> >>>> I think you need to think about this at a python level more then a >>>> web2py level. web2py uses python which means yes you can connect to >>>> whatever non-web2py server that handles network protocols in one way or >>>> another. >>>> >>>> Do you want to basically get a request from the client and pass that >>>> request to a server/mysql which will determine what to do with the >>>> request, >>>> return you data and that data is returned back to the client? >>>> >>>> How is the non-web2py server listening for connections? Does it already >>>> have an api programmed or is that also your task? >>>> >>>> >>>> On Sat, Apr 21, 2012 at 11:20 AM, Carlos <carlosgali...@gmail.com>wrote: >>>> >>>>> Hi Bruce, >>>>> >>>>> Thanks, but that's not the case. >>>>> >>>>> My web2py system is already a complete cloud SaaS server, with a >>>>> single postgresql db, multi-tenancy, multi-apps, single-sign-on, etc. >>>>> >>>>> And one potential customer (tenant), who will use all the other apps >>>>> in the cloud, requires this new scenario/app where my system handles web >>>>> services requests from an external non-web2py system (named CLIENT) and >>>>> collects the respective data from another external non-web2py system >>>>> (named >>>>> SERVER), therefore acting as a middle-server (or so). >>>>> >>>>> All 3 systems (my own cloud SaaS SYS, and CLIENT, and SERVER) are >>>>> completely independent (with no relation whatsoever). >>>>> >>>>> Thanks, >>>>> >>>>> Carlos >>>>> >>>>> >>>>> On Saturday, April 21, 2012 1:08:55 PM UTC-5, Bruce Wade wrote: >>>>>> >>>>>> From what you explained it sounds like you just want: >>>>>> 1) Independent database server >>>>>> 2) Web2py to handle requests via a service >>>>>> 3) Javascript to connect to a web2py service using ajax and or sockets >>>>>> >>>>>> If that is what you are asking it web2py can handle that simply if >>>>>> that is not what you are suggesting then I am not sure, and need more >>>>>> details. >>>>>> >>>>>> On Sat, Apr 21, 2012 at 11:02 AM, Carlos <carlosgali...@gmail.com>wrote: >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> My environment: latest web2py trunk, ubuntu, postgresql, nginx, >>>>>>> uwsgi. >>>>>>> >>>>>>> Following are some requirements for my new potential project (where >>>>>>> SYS is my web2py system, and CLIENT and SERVER are two completely >>>>>>> different >>>>>>> / independent non-web2py remote servers): >>>>>>> >>>>>>> (for each web services call ...) >>>>>>> >>>>>>> + CLIENT initiates the communication to SYS via web services to >>>>>>> request some data. >>>>>>> >>>>>>> + during this same connection (in real time), SYS connects to the >>>>>>> remote SERVER to execute some SQL commands (in a MySQL database) and >>>>>>> get >>>>>>> the requested data. >>>>>>> >>>>>>> + finally SYS responds to CLIENT with the data. >>>>>>> >>>>>>> In summary, SYS will act as the middle-man between CLIENT and SERVER. >>>>>>> >>>>>>> Questions: >>>>>>> >>>>>>> Is this doable?, should I be aware of any issues that might arise?, >>>>>>> concurrency, others?. >>>>>>> >>>>>>> Do you recommend other ways to accomplish this?. >>>>>>> >>>>>>> Do you know how can my web2py server connect remotely to a >>>>>>> non-web2py server to execute some SQL commands?. >>>>>>> >>>>>>> Will SYS have enough time for this process to complete on each web >>>>>>> service call?. >>>>>>> >>>>>>> I would just like to know your general (or specific) recommendations >>>>>>> about this scenario. >>>>>>> >>>>>>> Thanks!, >>>>>>> >>>>>>> Carlos >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> -- >>>>>> Regards, >>>>>> Bruce Wade >>>>>> http://ca.linkedin.com/in/**bruc**elwade<http://ca.linkedin.com/in/brucelwade> >>>>>> http://www.wadecybertech.com >>>>>> http://www.fittraineronline.**co**m <http://www.fittraineronline.com>- >>>>>> Fitness Personal Trainers Online >>>>>> http://www.warplydesigned.com >>>>>> >>>>>> >>>> >>>> >>>> -- >>>> -- >>>> Regards, >>>> Bruce Wade >>>> http://ca.linkedin.com/in/**brucelwade<http://ca.linkedin.com/in/brucelwade> >>>> http://www.wadecybertech.com >>>> http://www.fittraineronline.**com <http://www.fittraineronline.com> - >>>> Fitness Personal Trainers Online >>>> http://www.warplydesigned.com >>>> >>>> >> >> >> -- >> -- >> Regards, >> Bruce Wade >> http://ca.linkedin.com/in/brucelwade >> http://www.wadecybertech.com >> http://www.fittraineronline.com - Fitness Personal Trainers Online >> http://www.warplydesigned.com >> >>
