CGI/Perl Guide | Learning Center | Forums | Advertise | Login Site Search: in Perl Guide PerlGuru Forums Learning Ctr

	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	LOG IN

Home: Perl Programming Help: Intermediate: Mod_Auth_MySQL

Zimmy New User Mar 30, 2002, 3:41 PM Post #1 of 4 (910 views) Mod_Auth_MySQL Can't Post hello All, (this might not be the right forum. But i hope you can help me) I am using Mod_Auth_MySQL in replacment for .htpasswd I am wounding if any has ever come across any problems with it. The current problems i am having are... -MySQL is working very very hard. and is making the site run SLOW. I have a lot of traffic and i assume each time a user logs in it is doing 1 query for each page a member hits. Is there anything in replacement to Mod_Auth_MySQL (besides .htpasswd Could it be its not installed correctly ? Anyone with some experience with this Apache Module that can help me out would be a bonus! Thank you in advanced, Drew

Coderifous journeyman Mar 30, 2002, 4:21 PM Post #2 of 4 (907 views) Re: [Zimmy] Mod_Auth_MySQL [In reply to] Can't Post I use the mod_auth_mysql module with no problems or slowdown at all. In fact, it operates extremely fast for the site I'm using it on. ( 3 different servers in fact ) I'm running apache 1.3.something on windows NT 4.0 systems of various power. I'm running perl embedded (mod_perl) not that it should make a difference here. I wonder why you are experiencing slow down... I have experienced one time when I had to restart apache and the mysql server becuase the authorization wasn't working at all, but after the restart, faster than a speeding bullet. And by the way, the lowest end of my servers ( a total joke given it's surroundings ) has a 200 mhz processor! How pathetic! But it still does it's job. --Jim

Zimmy New User Mar 30, 2002, 4:32 PM Post #3 of 4 (904 views) Re: [Coderifous] Mod_Auth_MySQL [In reply to] Can't Post Would you mind posting your .htaccess file so i can make sure I have the same configuration. I might be doing something there... Also.. How much traffic are you bringing in ? This would make a difference right ? I am on average at 5,000 - 10, 000 / day Would this have anything to do with it ? Thanx, Drew (This post was edited by Zimmy on Mar 30, 2002, 4:33 PM)

Coderifous journeyman Mar 31, 2002, 6:13 AM Post #4 of 4 (890 views) Re: [Zimmy] Mod_Auth_MySQL [In reply to] Can't Post I don't use an .htaccess file, I just put directives in the apache httpd.conf to limit access to certain directories. Maybe that is the difference that matters. I haven't tried it with .htaccess files. My server is handling less traffic, but your traffic shouldn't at all be near the capacity of your technology. So my knee jerk reaction would be "no" that's not the reason it's malfunctioning - but you'd be amazed at how many times I've been wrong before. Does MySQL/Mod_Auth_Mysql lock the table every time an authorization is done? I wouldn't think that it would be necessary. --Jim

Announcements     PerlGuru Announcements Perl Programming Help     Frequently Asked Questions     Beginner     Intermediate     Advanced     Regular Expressions     mod_perl     DBI     Win32 Programming Help Fun With Perl     Perl Quizzes - Learn Perl the Fun Way     Perl Golf     Perl Poetry Need a Custom or Prewritten Perl Program?     I need a program that...     I Need a Programmer for Freelance Work     Throw Down The Gauntlet General Discussions     General Questions     Feedback     Tutorial/Article Suggestions for The Learning Cent     Internet Security Other Programming Languages     Javascript     PHP

Search this forum this category all forums for All words Any words Whole Phrase (options)

Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives