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 > >