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 <[email protected]> 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 <[email protected]>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 <[email protected]>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 >>> >>>
