[Database class] database class Re: use of web server

[Paul S. Wang]

Roy and DB class,

I am forwarding Roy's email to the DB class to use the webserver
webdev.cs.kent.edu instead of dbdev.cs.kent.edu.

The one student who
brought this issue up said that he cannot succeed in connecting to
the dbdev database from another server.  If that problem persists he
should see Roy for a solution.

Thanks to all.
Paul


On Tue, Nov 22, 2011 at 10:53:59AM -0500, Roy E. Heath III wrote:
> Date: Tue, 22 Nov 2011 10:53:59 -0500
> From: "Roy E. Heath III" <rheath at cs.kent.edu>
> User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.23) Gecko/20110928 Fedora/3.1.15-1.fc14 Thunderbird/3.1.15
> To: pwang at cs.kent.edu
> CC: systems at cs.kent.edu
> Subject: Re: dbdev web server problem
> In-Reply-To: <20111121222239.GA6589 at cs.kent.edu>
> X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.2.3 (mscan1.vs.cs.kent.edu [131.123.39.204]); Tue, 22 Nov 2011 10:53:59 -0500 (EST)
> X-Virus-Scanned: Maia Mailguard 1.0.2a
> 
> On 11/21/2011 05:22 PM, Paul S. Wang wrote:
> >Dear Systems (Roy)?
> >
> >A student asked and I checked.  Got
> >
> >Not Found
> >
> >The requested URL /~pwang/index.html was not found on this server.
> >Apache/2.2.16 (Fedora) Server at dbdev.cs.kent.edu Port 80
> >
> >But we need per user web space to work for database students in order for 
> >their
> >php scripts to access database on localhost.
> >
> >Thanks,
> >Paul
> >
> 
> Dr. Wang-
> 
> That's because it's a database server and not a general purpose web 
> server.  It wasn't intended for them to be doing web development on that 
> machine when it was set up.  In the past, there wasn't a need or desire 
> to use a webserver for accessing the database.  The only  reason I even 
> have the webserver enabled is so that they can use phpMyAdmin instead of 
> or until they learn enough SQL to do their work on the command line.  
> One of the nice things about phpMyAdmin is that it shows you all of the 
> SQL code used to perform a requested action, so it can be used as a nice 
> aide in teaching someone how to write the SQL when all they know is the 
> theory behind what they want to do.
> 
> This sort of problem is also covered by the fact that their DB accounts 
> are created with both local and remote connections enabled.  They can 
> just as easily refer to the HOST as "dbdev.cs.kent.edu" instead of using 
> "localhost" when they make the database connection.  In fact, it's 
> probably a good idea to make sure they realize that because in the real 
> world, it's quite likely that the two services are separated unless it 
> is a very small site.  It's no different than them using a client on 
> another machine (neptune, poseidon or even their home machine or laptop) 
> to connect to the database and do their work.
> 
> If it's really an issue, I can enable the user home directories in the 
> webserver config files.
> 
> 
> Roy---
> 
> <==============================>
> Roy E. Heath III
> Research Engineer
> Department of Computer Science
> Kent State University
> 
> Email: rheath at cs.kent.edu
> Phone: (330)672-9012
> <==============================>

-- 
==============================================================================
 Paul S. Wang (王士弘)                      Email: pwang at cs.kent.edu            
 Dept. of Computer Science, Kent State U.   Tel: (330) 672-9051
 Kent, Ohio, USA 44242-0001                 http://www.cs.kent.edu/~pwang/ 
==============================================================================