Re: [web2py] web2py as middle-server between 2 remote servers via web services

2012-04-23 Thread Richard Vézina
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 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, >> >

Re: [web2py] web2py as middle-server between 2 remote servers via web services

2012-04-23 Thread Carlos
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 rem

Re: [web2py] web2py as middle-server between 2 remote servers via web services

2012-04-23 Thread Carlos
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

Re: [web2py] web2py as middle-server between 2 remote servers via web services

2012-04-21 Thread Carlos
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 like

Re: [web2py] web2py as middle-server between 2 remote servers via web services

2012-04-21 Thread Bruce Wade
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

Re: [web2py] web2py as middle-server between 2 remote servers via web services

2012-04-21 Thread Carlos
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? Bas

Re: [web2py] web2py as middle-server between 2 remote servers via web services

2012-04-21 Thread Bruce Wade
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

Re: [web2py] web2py as middle-server between 2 remote servers via web services

2012-04-21 Thread Carlos
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 wh

Re: [web2py] web2py as middle-server between 2 remote servers via web services

2012-04-21 Thread Jonathan Lundell
On Apr 21, 2012, at 11:02 AM, Carlos wrote: > 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 re

Re: [web2py] web2py as middle-server between 2 remote servers via web services

2012-04-21 Thread Bruce Wade
>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 sugges

[web2py] web2py as middle-server between 2 remote servers via web services

2012-04-21 Thread Carlos
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 ...)