ISP Hosted database

------=_NextPart_000_002A_01C6F462.5E7954A0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_002B_01C6F462.5E7954A0"


------=_NextPart_001_002B_01C6F462.5E7954A0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hello,

I don't know if this is a proper question for this list but I do know there
are some very knowledgable people here who will be able to send me in the
right direction or inform me that I'm off base.

I've built a web site for receiving entries for shows (type of show doesn't
matter could be horse, dog, cat, car etc.) . These show entries are stored
in a MySQL database. When an entry is received the information is not only
captured in the MySQL database but it is also emailed to the Show Secretary.
The Show Secretary has an Access Database that can connect to the web site
and pick up these entries which are then copied to the Access database.
That's the 30,000 foot picture of what's going on.

Now here's my problem. This site is hosted at an ISP in a shared environment
because I cannot afford to have a dedicated server until this thing can get
going (if it ever does). The ISP requires that each user's IP address be
white listed and the problem being is that many (if not most) of the users
are on dial-up so the IP address is not static. So in short it doesn't work
for them.

I'm told that to eliminate the white listing requirement would mean turning
off the fire wall which would open a real can of worns. If this is in fact
true I cannot imagine any ISP not making white listing IP addresses
mandatory for remote connections. On the other hand there must be a way to
secure the environment and not have to use the IP address. I like the way it
currently works because it is a seamless connection to the remote database
making it very easy to use which I really need as most of the users are not
computer savy.

Can anyone offer ideas on either an ISP that does not require white listing
IP addresses in a shared environment or possibly another approch to
accomplishing the same thing?

Thanks very much!


Vic









------=_NextPart_001_002B_01C6F462.5E7954A0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable



charset=3Dus-ascii">

Re: ISP Hosted database

Vic,

You need a proxy server script running on your ISP which takes posted or
otherwise provided data from users and does with it what a direct
connect would do. From your description, I don't entirely understand
how it's done, but it seems that you have some kind of client which goes
to the database directly.

What you want is users to use a browser to get to one place on your Web
site, and that place then provides the information they key
in/upload/sync to the database, mediated by some scripts.

- Jan


On Fri, 20 Oct 2006 16:11:12 -0700, "Vic Spainhower"
said:
> Hello,
>
> I don't know if this is a proper question for this list but I do know
> there are some very knowledgable people here who will be able to send
> me in the right direction or inform me that I'm off base.
>
> I've built a web site for receiving entries for shows (type of show
> doesn't matter could be horse, dog, cat, car etc.) . These show
> entries are stored in a MySQL database. When an entry is received the
> information is not only captured in the MySQL database but it is also
> emailed to the Show Secretary. The Show Secretary has an Access
> Database that can connect to the web site and pick up these entries
> which are then copied to the Access database. That's the 30,000 foot
> picture of what's going on.
>
> Now here's my problem. This site is hosted at an ISP in a shared
> environment because I cannot afford to have a dedicated server until
> this thing can get going (if it ever does). The ISP requires that each
> user's IP address be white listed and the problem being is that many
> (if not most) of the users are on dial-up so the IP address is not
> static. So in short it doesn't work for them.
>
> I'm told that to eliminate the white listing requirement would mean
> turning off the fire wall which would open a real can of worns. If
> this is in fact true I cannot imagine any ISP not making white listing
> IP addresses mandatory for remote connections. On the other hand
> there must be a way to secure the environment and not have to use the
> IP address. I like the way it currently works because it is a seamless
> connection to the remote database making it very easy to use which I
> really need as most of the users are not computer savy.
>
> Can anyone offer ideas on either an ISP that does not require white
> listing IP addresses in a shared environment or possibly another
> approch to accomplishing the same thing?
>
> Thanks very much!
>
>
> Vic
>
>
>
>
>
>
>
>
--=20
Jan Theodore Galkowski (o°) =

jtgalkowski@alum.mit.edu
http://tinyurl.com/qty7d



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: ISP Hosted database

----- Original Message -----
From: "Vic Spainhower"
To:
Sent: Saturday, October 21, 2006 1:11 AM
Subject: ISP Hosted database


> Hello,
>
> I've built a web site for receiving entries for shows (type of show
> doesn't
> matter could be horse, dog, cat, car etc.) . These show entries are stored
> in a MySQL database. When an entry is received the information is not only
> captured in the MySQL database but it is also emailed to the Show
> Secretary.
> The Show Secretary has an Access Database that can connect to the web site
> and pick up these entries which are then copied to the Access database.
> That's the 30,000 foot picture of what's going on.
>
You can to write some backend script in PHP. I precede that your ISP allow
to run PHP pages. This script should to have at least two functions.
First function would be for downloading data from server to local Access
database in some acceptable form, eg. data dump, XML or CSV.
Second function would be for data uploading to server analogous to previous
function.
I know, it is not ideal, but for dialup users this should be a solution.

Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: ISP Hosted database

On 10/20/06, Petr Vileta wrote:
> ----- Original Message -----
> From: "Vic Spainhower"
> To:
> Sent: Saturday, October 21, 2006 1:11 AM
> Subject: ISP Hosted database
>
>
> > Hello,
> >
> > I've built a web site for receiving entries for shows (type of show
> > doesn't
> > matter could be horse, dog, cat, car etc.) . These show entries are stored
> > in a MySQL database. When an entry is received the information is not only
> > captured in the MySQL database but it is also emailed to the Show
> > Secretary.
> > The Show Secretary has an Access Database that can connect to the web site
> > and pick up these entries which are then copied to the Access database.
> > That's the 30,000 foot picture of what's going on.
> >
> You can to write some backend script in PHP. I precede that your ISP allow
> to run PHP pages. This script should to have at least two functions.
> First function would be for downloading data from server to local Access
> database in some acceptable form, eg. data dump, XML or CSV.
> Second function would be for data uploading to server analogous to previous
> function.
> I know, it is not ideal, but for dialup users this should be a solution.
>

That's the best approach, besides changing ISP. I've done it a few
times, returning XML code based on GET variables at the URL to feed
Office applications. An upload script uses the same idea.

The good thing is that once you decide to get a dedicated server or
move from server, it will go on working no matter what environment you
have.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: ISP Hosted database

------=_NextPart_000_0075_01C6F681.6FCBF750
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Vic,
=20
Q1. Do you have a virtual host with your own ip address?
=20
If so, check with your ISP to see what they can provide in the way of =
"per
virtual host" firewalling and port forwarding.
=20
Q2. Have you considered eliminating the client Access connection and
providing a PHP to http server interface on your host?
=20
This would probably mean that you'd have to get into the business of
providing the local tools that the end users (Show Secretaries) would
normally implement for their own use. But if the Show Secretaries are =
not
computer/Access proficient, you might be better off providing a =
functional
interface than an Access infrastructure. This approach would use the =
normal
port 80 (http://) interface that the ISP is set up for. You would have =
to
implement your own security with passwords in the PHP interface. For =
those
Show Secretaries who are computer development savvy, I think there are =
ways
to access data via the port 80 type of interface (e.g. downloads).
=20
My level of experience in how to provide this kind of data over a port =
80
interface is limited to providing web pages via PHP code interfaced to
Apache so some of my assumptions may be off base for your situation.
=20
Good luck and regards.
=20
=20

Lawson
lawson@vrtinc.com
+1(480)308-0641 (Voice)
+1(602)996-0376 (Fax)
=20

-----Original Message-----
From: Vic Spainhower [mailto:vic@showsec.com]=20
Sent: Friday, October 20, 2006 4:11 PM
To: win32@lists.mysql.com
Subject: ISP Hosted database


Hello,
=20
I don't know if this is a proper question for this list but I do know =
there
are some very knowledgable people here who will be able to send me in =
the
right direction or inform me that I'm off base.
=20
I've built a web site for receiving entries for shows (type of show =
doesn't
matter could be horse, dog, cat, car etc.) . These show entries are =
stored
in a MySQL database. When an entry is received the information is not =
only
captured in the MySQL database but it is also emailed to the Show =
Secretary.
The Show Secretary has an Access Database that can connect to the web =
site
and pick up these entries which are then copied to the Access database.
That's the 30,000 foot picture of what's going on.
=20
Now here's my problem. This site is hosted at an ISP in a shared =
environment
because I cannot afford to have a dedicated server until this thing can =
get
going (if it ever does). The ISP requires that each user's IP address be
white listed and the problem being is that many (if not most) of the =
users
are on dial-up so the IP address is not static. So in short it doesn't =
work
for them.
=20
I'm told that to eliminate the white listing requirement would mean =
turning
off the fire wall which would open a real can of worns. If this is in =
fact
true I cannot imagine any ISP not making white listing IP addresses
mandatory for remote connections. On the other hand there must be a way =
to
secure the environment and not have to use the IP address. I like the =
way it
currently works because it is a seamless connection to the remote =
database
making it very easy to use which I really need as most of the users are =
not
computer savy.
=20
Can anyone offer ideas on either an ISP that does not require white =
listing
IP addresses in a shared environment or possibly another approch to
accomplishing the same thing?
=20
Thanks very much!
=20
=20
Vic
=20
=20
=20
=20
=20

=20


------=_NextPart_000_0075_01C6F681.6FCBF750--