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
