Convert .htpasswd into MySQL? - GoFuckYourself.com

Jizar II · 01-22-2003, 11:02 AM

How can I convert/export current member info into a MySQL DB? I'm currently using epoch as processor, and would like to them to postback the joins to my own DB, this seems quite easy, but I don't know what to do with the recurring members.. I need their Username/Password + email as the minimum..

Jizar II · 01-22-2003, 01:14 PM

thanks for the great help!!

NetRodent · 01-22-2003, 01:59 PM

What exactly are you asking? How much of your question is technique (ie what modules do I use) and how much is theory (ie what sort of info should I track for recurring).

I can't really comment specifically on using epoch with DB authentication. We haven't used them in almost 2 years, so a lot might have changed.

wwwcashmountain · 01-22-2003, 03:20 PM

Hi

We work all our our members from a mysql database. We pretty much hack any scripts we get from billing companies (that work with htpasswd files) to work with mysql - (typically the check/add/delete routines).

We don't use mysql for realtime authentication tho, i dont know how the load would go when you have big numbers of members.

Robert

dnsmonster · 01-22-2003, 04:10 PM

Use Apache AuthMySQL module.

NetRodent · 01-22-2003, 04:59 PM

Quote:

Originally posted by wwwcashmountain

We don't use mysql for realtime authentication tho, i dont know how the load would go when you have big numbers of members.

If you authenticate against a properly indexed db, you'll have much lower load than with plain text. Especially for large numbers of members. Just make sure that you're very careful about doing operations on that table that might block.

Jizar II · 01-22-2003, 05:17 PM

Thank you for the answers

wwwcashmountain:
Great info

NetRodent:
Can I buy your service?

..icq? email?

01-22-2003, 11:02 AM	#1
Jizar II Confirmed User Industry Role: Join Date: May 2001 Location: LLL© Posts: 1,425	Convert .htpasswd into MySQL? How can I convert/export current member info into a MySQL DB? I'm currently using epoch as processor, and would like to them to postback the joins to my own DB, this seems quite easy, but I don't know what to do with the recurring members.. I need their Username/Password + email as the minimum..

01-22-2003, 01:59 PM	#3
NetRodent Confirmed User Join Date: Jan 2002 Location: In the walls of your house. Posts: 3,985	What exactly are you asking? How much of your question is technique (ie what modules do I use) and how much is theory (ie what sort of info should I track for recurring). I can't really comment specifically on using epoch with DB authentication. We haven't used them in almost 2 years, so a lot might have changed. __________________ "Every normal man must be tempted, at times, to spit on his hands, hoist the black flag, and begin slitting throats." --H.L. Mencken

01-22-2003, 03:20 PM	#4
wwwcashmountain Confirmed User Join Date: Dec 2002 Posts: 194	Hi We work all our our members from a mysql database. We pretty much hack any scripts we get from billing companies (that work with htpasswd files) to work with mysql - (typically the check/add/delete routines). We don't use mysql for realtime authentication tho, i dont know how the load would go when you have big numbers of members. Robert __________________ SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

01-22-2003, 04:10 PM	#5
dnsmonster Confirmed User Join Date: Jul 2002 Location: A warm place. Posts: 634	Use Apache AuthMySQL module. __________________ I couldn't possibly know what I'm talking about, I'm completely, absolutely and definitively out of my fucking mind.

01-22-2003, 01:14 PM	#2
Jizar II Confirmed User Industry Role: Join Date: May 2001 Location: LLL© Posts: 1,425	thanks for the great help!!

01-22-2003, 05:17 PM	#7
Jizar II Confirmed User Industry Role: Join Date: May 2001 Location: LLL© Posts: 1,425	Thank you for the answers wwwcashmountain: Great info NetRodent: Can I buy your service? ..icq? email?