Re: Linux Internet Server Project

[Ricky Bryce <rbryce@mcleodusa.net>]

Tim,

I hope someone is watching this chat that can help out with the SQL part.  
I am in West Virginia this week, so dont have access to all my 
documentation.  I am pretty sure you can import data from the access 
database without a problem.  It looks like the only issue left to resolve 
then is how to configure VB to write to a MySQL database.  If you can get 
the data into the MySQL, then pulling the data from MySQL and displaying 
it on a web page should not be a problem.   You can use PHP for that.  

Hopefully someone has used VB to write to MySQL before, and can give some 
tips.  I dont think it would take much of a machine for the little amount 
of data that you are wanting to acquire.   Just make sure the components 
you purchase will work with the version of Linux you choose.  If you 
decide to use RedHat, then during the installation, just make sure you set 
up the firewall, and install MySQL, and PHP, and the PHP rpm which 
contains the MySQL commands...  It is clearly labeled.  You will also want 
to install the Apache server, and the OpenSSH server for your remote 
adminstration.  

I might be able to try connecting VB to a MySQL database tomorrow and see 
what I come up with.  Maybe the MySQL site will have some good information 
too.  It might take an extra component for VB to be able to use MySQL...  
I have no idea.  

I will work on it tomorrow and let you know what I find out.

Talk to you later.

Ricky


On Mon, 11 Feb 2002, Tim McDonough wrote:

> From: "Ricky Bryce" <rbryce@mcleodusa.net>
> > I am trying to visualize what you are working toward.  It is my
> > understanding that you are going to have a program running on a
> windows 98
> > machine that pulls data out of your PLC's or embedded computers, and
> write
> > this data to a Linux server database.
> 
> Starting out this is correct. What we have now is not ideal but it
> does work. Over the next few months I need to concentrate on pieces
> that do not exist at all. Then I can work more towards an ideal end to
> end solution.
> 
> > You are then going to run a web
> > server on this server which uses embedded tags in the HTML code to
> display
> > data from the database...  You can probably use PHP for that.
> 
> Yes. The piece that is missing will get the data from our present PC,
> make subsets of it available to specific customers via web pages.
> 
> I don't know that it's too important for these discussions but the
> remote equipment communicates with our Win98 "host" once each day to
> let us know it's alive and well and then as frequently as needed to
> pass information regarding changes. The host can also initiate
> communication to a remote but this is very infrequent.
> 
> The remote units are designed by us (me) and include an embedded
> microcontroller, modem chip set, sensor inputs, etc.
> 
> > We just need to know what the program is that is pulling data from
> your
> > plant floor and putting it in the access database, so we can get
> that
> > redirected to the Linux machine.
> 
> The host presently runs Win98 because that's what I inherited. A VB
> application answers the phones, validates the data and stuffs it into
> Access. Other than time and workload there's no reason a Linux app
> cannot eventually do these tasks in conjunction with MySQL or
> something else.
> 
> > By the way...  What city is your plant located?
> 
> I'm located in Springfield, IL.
> 
> Tim
> 
> 
> 
> -
> To unsubscribe, send email to majordomo@luci.org with
> "unsubscribe luci-discuss" in the body.
> 
> 


-
To unsubscribe, send email to majordomo@luci.org with
"unsubscribe luci-discuss" in the body.