on-rev remote database

stephen barncard stephenREVOLUTION2 at barncard.com
Tue Oct 19 10:54:57 CDT 2010


This is not a universal restriction with all web hosts. Datamost, for
instance, will allow any number of MYSQL databases and the user can tie
those DB users with any end computers' IPs from the Dreamhost control panel.
In fact, it's possible to use the % wild card and specify partial or even
all domains (not recommended) so it could work from anywhere. Dreamhost
gives their users a lot of rope (including shell access over ssh.). On-Rev
is more restrictive.

Of course if you need and are using on-rev, then you would need to buy and
install revserver at Dreamhost as well.

For best security (and if you have thousands of users, it's really
recommended) to use the cgi 'firewall' as suggested to protect your server
and clients' data. You will find that

opening and closing MYSQL frequently has almost no overhead, compared to
returning the data to the client.

the "hit" that the server will take with a cgi firewall will be minimal. Rev
server is FAST.

On 19 October 2010 04:56, Len Morgan <len-morgan at crcom.net> wrote:

>  This is all a moot point now since I have just been informed by Heather
> that the only way the on-rev server can be set up to do this is if you give
> them all of the IP addresses that people are going to connect from and they
> will allow those IP addresses to connect.  This of course will never work
> with a large potential user base of hundreds or thousands.  I guess I'm
> going to have to throw away everything I've done so far and start over with
> the web based approach that Pierre suggested.  It's going to kill my
> performance but it's the only option I've got open to me at this point.
>
> len morgan
>
>
> On 10/19/2010 2:27 AM, Pierre Sahores wrote:
>
>> Le 18 oct. 2010 à 20:41, Andrew Kluthe a écrit :
>>
>>  The client never actually gets the login credentials for the database
>>> because they are stored in our private "big" client DB. On startup the
>>> rev
>>> program fetches the credentials from our database and connects to theirs
>>> to
>>> begin working with it.
>>>
>> Definitively the way to go !
>>
>>> I would hate to have to rewrite my entire suite of programs to center
>>> around
>>> an irev script for the transactions. I would love to use On-Rev as a
>>> database host because of how close it is to where I am located and the
>>> power
>>> of revServer.
>>>
>> If you prefer, you can do this in having your client (web browser or
>> LiveCode ria app) posting their credentials to a PHP script indeed but in
>> any case you will have to be sure that the server-side script will respond
>> to the clients requests and interact with the db-backend only when each
>> client will have been authenticated as allowed to interact with its own
>> account on your on-line app.
>>
>> If most of your customers are, alike mine, using dynamic IP to connect the
>> cloud and subsequently your or mine on-line apps, an IP-based authentication
>> system will not be usable nor safe at all in such a context.
>>
>> HTH,
>>
>> --
>> Pierre Sahores
>> mobile : (33) 6 03 95 77 70
>>
>> www.woooooooords.com
>> www.sahores-conseil.com
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>
>>
>>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



-- 



Stephen Barncard
San Francisco Ca. USA

more about sqb  <http://www.google.com/profiles/sbarncar>



More information about the use-livecode mailing list