I think you want to achieve is something call SOA : http://en.wikipedia.org/wiki/Service-oriented_architecture
Richard On Mon, Apr 23, 2012 at 4:43 PM, Carlos <carlosgali...@gmail.com> wrote: > Btw I forgot to mention that IPsec must be used. > > > On Monday, April 23, 2012 3:32:58 PM UTC-5, Carlos wrote: >> >> 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/**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 >>>> >>>>