Web Hosting Talk







View Full Version : need help w/ssl & mysql


studiosoho
02-07-2006, 06:47 PM
HI:

I need some directories on my webserver password protected. The usernames and passwords are part of another application and are stored in a mysql database.

Here is the situation:
We are running a private portal. Users need to log in to access the content and downloads on the portal. However, if they go directly to the directory that holds the docs, they can download the documents without logging into the application. We need to block them from doing this unless they are already logged into the system.

I believe this is the solution:

> http://www.spikesource.com/docs/cs_1.6.0-win32/doc/apache/apache_quick
> startguide.html)
>
> *How to configure MySQL authentication in Apache?*
>
> In order to use MySQL authenticaiton, the mod_auth_mysql module
> should be loaded in apache using the LoadModule directive in
> httpd.conf. The directory that needs MySQL authentication should
> be protected as shown below:
>
> <Directory "/opt/oss/share/apache2/htdocs/withauthmysql">
> Options Indexes FollowSymLinks
> AuthName "Apache / MySQL Authentication try guest/guest"
> AuthType Basic
> AuthMySQLHost localhost
> AuthMySQLSocket /opt/oss/var/mysql/mysql.sock
> AuthMySQLDB apacheauth
> AuthMySQLUserTable authh
> AuthMySQLNameField user
> AuthMySQLPasswordField passwd
> AuthMySQLPwEncryption none
> require valid-user
> </Directory>
>


This is out of my depth. Can anyone assist? Please PM me with your contact details (IM if you have it) and a price.

Thanks!

Kelly

studiosoho
02-07-2006, 06:51 PM
btw. i should add: using cookies or htaccess instead of mysql are not options as we have explored both.

thanks,

Kelly

superprogram
02-08-2006, 12:08 AM
Kelly
Please feel free to contact me for this work
San

studiosoho
02-09-2006, 01:48 AM
HI:

thanks to those who contacted me. cniemira completed the job for me and did a great job!

Thanks CJ!