Originally posted by crystalthunder:
<STRONG>I am currently running Yellow Dog Linux on my Beige G3 233 mhz machine and I am having problems running cgi, php, and mysql on it. I was thinking with a GUI I could figure these problems out reletively easily.</STRONG>
Well a GUI might help you but it will also limit you to what the GUI makers decided was important enough to include.
Does your installation of Apache/php/MySQL not work at all? Are you having problems administering the software or just getting it to run? Are you having problems configuring MySQL? Are you having problems understanding how it works?
There is a well regarded GUI for MySQL called phpMyAdmin. It gives you a web browser based GUI to administer the MySQL server and databases. You can find it at:
http://phpwizard.net/projects/phpMyAdmin/ I know several Mac users that swear by it. There are many other GUI tools for PHP and MySQL available at
http://sourceforge.net and
http://freshmeat.net
<STRONG>
So I was wondering if, first of all, does X server support these languages and protocols ( I know basically nothing about X server ) and if it would run efficiently enough for a corporate AND personal web site. Much Thanks.</STRONG>
X server is a graphical environment that also has networking built in. It is the underlying graphics display engine for *nix systems... one can even use it on an OSXS system. There are applications written in the X programming language that provide GUI admin tools for MySQL and the Apache web server. PHP is a programming language... you can use a plain text editor to write PHP code... I know of people that use SimpleText for this... or Dreamweaver or Adobe GoLive on their Macs. Under Linux there are two very good GUI web authoring tools that also include support for PHP: Quanta and Bluefish... these should be available for Linux on the Mac. (see sites mentioned above for downloading).
MySQL is a very powerful database engine and is, IMO, up to the task of the simplest personal databases and most corporate databases. It is very fast and efficient. Once you have MySQL installed and running and a few basic configurations made you may never need to touch the CLI interfaces to MySQL again. All you really need to do is enter the "root" or "admin" users password, after that you can just use GUI tools. Personally, I mainly use the CLI but only for initial setup of a database.
There are dozens, if not hundreds, of excellent tutorials, howtos, and examples available on the web. See
http://www.mysql.com/ for starters or just use
http://www.google.com to search for them.
PHP is a programming language for creating dynamic web content. When connected to a MySQL database it becomes extremely powerful... you can even use other databases like PostgreSQL, MS-SQL, etc. You can use anything from a plain text editor to a GUI web authoring tool for generating PHP code. There is also a large base of tutorials, howtos, and examples available for PHP. See
http://www.php.net/index2.php for starters.
CGI is a general term for programs or scripts that can interact with a web server. The CGI program can be written in any language that will compile and run or interpreted on the host server. CGI can be written in C, C++, Perl, or as a script. The CGI program can interact with other components of the system such as databases and passes HTML back to the webserver as its output.
Apache is a web server. Other than editing a plain text config file a few times.... usually just once for initial setup... there is nothing else that needs to be done. Just run it and monitor the logs as need be.
Hope the above links help. If you have any specific problems just ask.
Top
