[H-GEN] Msql vs. Mysql and windows script launching

[Martin Pool]

[ Humbug *General* list - semi-serious discussions about Humbug and
Unix-related topics. ]

Nikolai Lusan wrote:

> Hi,
>    A friend of mine wants a database to catalog his collection of stuff
> in, as the machine has for the purpose is not enough to run an M$
> operating system I will be doing it with a minimal linux install. I was
> after peoples opinions as to whether to use Msql or Mysql, I have used
> Msql before but thought some comparison might be in order. 

I would strongly prefer MySQL.

> Essentially
> the DB would have a web interface using a boa or apache server on the
> machine so php or perl look like being used for cgi scripts. 

I'd also recommend PHP: it's much better suited to web scripting, is an
easier language to maintain than Perl, and more approachable for people
who don't use it all the time.

Also have a look at Zope <www.zope.org>, which includes Python web
scripting, a funky remote admin interface, and builtin object and
relational DBs.

> It also
> dawned on me that it would be easier for admin purposes if this was his
> dial-up box with a small masq/firewall setup on it, this way if he adds
> more machines to his network (say for his wife) then they call all use
> the web at once and I can login via ssh to fix any hiccups that develop
> in my scripts. 

> The problem with this is how to get the '95 box to
> initiate a script on the linux box, I don't feel that Dial-on-Demand is
> the right option here I think an icon on his dektop that when
> double-clicked runs pon on the linux box would be a better option for
> him....but how can I do this?

Can you put ssh on the Windows box and have it SSH in to execute the ppp
start command?  How about a web page on the Linux box with a button to
turn the link on and off by executing said command.

> All help/ideas/useful critisism/intresting conversation  greatfully
> apreciated.

-- 
Martin

The computer *is* the game.

--
This is list (humbug) general handled by majordomo at lists.humbug.org.au .
Postings only from subscribed addresses of lists general or general-post.