mod_auth_mysql - GoFuckYourself.com

FiReC · 12-13-2004, 11:57 AM

anyone use it on a busy members area? i've heard of some complaints like it hits the db multiple times per page request that really slow down the server, any one experience this?

retro · 12-13-2004, 12:00 PM

It's going to be slower than .htaccess - but as long as your hardware is appropriate it shouldnt be a problem.

FiReC · 12-13-2004, 12:12 PM

how many lines can you have in a standard flat text file before regular htaccess starts to slow way down, anyone know?

Babaganoosh · 12-13-2004, 12:17 PM

Quote:

Originally posted by FiReC
how many lines can you have in a standard flat text file before regular htaccess starts to slow way down, anyone know?

I think that would depend on the server but on a moderatly built server I had about 50K entries before logins got unbearably slow. You can also auth through mysql without using mod_auth_mysql which is what I did.

FiReC · 12-13-2004, 12:25 PM

i like the idea of throwing an htaccess file into a directory and having it hit the mysql server for authentication, and then only having to change the directives in the htaccess for each site (group). I know it can be done different ways using mysql (ie sessions), but the apache module looked pretty sweet, just want to get some more input on it.

Babaganoosh · 12-13-2004, 12:28 PM

I tried mod_auth_mysql but members kept complaining that they couldn't log in. I could never duplicate the problem but when I switched to an auto_prepend scheme most of the complaints stopped. Apparently mod_auth_mysql works for some people but not for everyone all the time. I didn't trust it so I gave up on it.

s9ann0 · 12-13-2004, 12:31 PM

I think there are 2 mod_auth_mysl's

12-13-2004, 11:57 AM	#1
FiReC Confirmed User Industry Role: Join Date: Jan 2002 Location: Land o Nubiles Posts: 2,350	mod_auth_mysql anyone use it on a busy members area? i've heard of some complaints like it hits the db multiple times per page request that really slow down the server, any one experience this? __________________ www.nubilefilms.com \| www.nubiles.net \| www.anilos.com \| tubescript.nubiles.net \| icq4162727

12-13-2004, 12:00 PM	#2
retro Registered User Join Date: Dec 2004 Location: NYC Posts: 62	It's going to be slower than .htaccess - but as long as your hardware is appropriate it shouldnt be a problem. __________________ Send your traffic to RetroDate.Com ICQ 194-452-393

12-13-2004, 12:12 PM	#3
FiReC Confirmed User Industry Role: Join Date: Jan 2002 Location: Land o Nubiles Posts: 2,350	how many lines can you have in a standard flat text file before regular htaccess starts to slow way down, anyone know? __________________ www.nubilefilms.com \| www.nubiles.net \| www.anilos.com \| tubescript.nubiles.net \| icq4162727

12-13-2004, 12:25 PM	#5
FiReC Confirmed User Industry Role: Join Date: Jan 2002 Location: Land o Nubiles Posts: 2,350	i like the idea of throwing an htaccess file into a directory and having it hit the mysql server for authentication, and then only having to change the directives in the htaccess for each site (group). I know it can be done different ways using mysql (ie sessions), but the apache module looked pretty sweet, just want to get some more input on it. __________________ www.nubilefilms.com \| www.nubiles.net \| www.anilos.com \| tubescript.nubiles.net \| icq4162727

12-13-2004, 12:28 PM	#6
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	I tried mod_auth_mysql but members kept complaining that they couldn't log in. I could never duplicate the problem but when I switched to an auto_prepend scheme most of the complaints stopped. Apparently mod_auth_mysql works for some people but not for everyone all the time. I didn't trust it so I gave up on it.

12-13-2004, 12:31 PM	#7
s9ann0 Confirmed User Join Date: Sep 2001 Location: Boston Posts: 4,873	I think there are 2 mod_auth_mysl's