vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   htaccess calls vbb database for username/pass's (https://vborg.vbsupport.ru/showthread.php?t=28923)

Flare945 09-26-2001 03:23 AM
can someone *please* write a htaccess file that does this

im sorry - i admit - i am unskilled, plz plz plz can you help me?

need to have htaccess use the vbulletin user database for its logins/pass's (so that when u add a new user - its automatically updated in htaccess, when a user chgs their pass - its auto updated <-- just literally uses SQL db for its logins)

thanks in advance

Ruth 09-26-2001 06:09 PM
Module: mod_auth_mysql
OS: Unix, Linux , WinNT.

Example:


AuthType Basic
AuthName "MySQL Member Page"

Auth_MYSQLhost www.vbulletin.com
Auth_MYSQLusername root
Auth_MYSQLpassword *****
Auth_MYSQLdatabase forum
Auth_MYSQLpwd_table user
Auth_MYSQLuid_field username
Auth_MYSQLpwd_field password
Auth_MYSQL_EncryptedPasswords off

<LIMIT GET POST>
require valid-user
</LIMIT>


for more information about this module contact your webhost.

Dock 11-12-2001 11:17 AM
I spoke to my webhost and they said they won't support mod_auth_mysql unless they can find a version that will work as a DSO (a module that can be loaded at run time into the web server). They were having trouble setting up my_auth_mysql so that it didn't just use one global database, so that each user could use it independantly.

Does anyone have any experience with this or any advice?

Scott MacVicar 11-12-2001 04:24 PM
Its a DSO as standard now

just tell them to download the latest version from
http://sourceforge.net/project/showf...lease_id=44678

gunzip it then untar it

go into mod_auth_mysql-3.2 open Makefile and change the axps and mysql paths respecitvely and then save. type make and then your done :)

dirgotronix 11-12-2001 08:32 PM
What is axps, and how do I come about having it? ran an updatedb;locate axps with no results.

Running Debian 2.2.18pre21 (potato) with apache 1.3.9 and mysql 3.23.36, php 4.0.3pl1

I'd like to install this, couldn't find anything in apt regarding mod_auth_mysql, and when I grabbed the source at sourceforge, there was no configure, just a makefile, and I'm not too sure as how to go about modifying that.

Scott MacVicar 11-12-2001 08:45 PM
try whereis apxs

and type
pico Makefile to open it and you should be able to edit it, you will need to edit the paths for MySQL and apxs to whatever, probably
/usr/sbin/apxs

i typed it wrong in my post, my bad :stupid:

dirgotronix 11-12-2001 09:32 PM
No apxs, no axps, nothing. Not with locate, not with whereis. apt-get install axps or apxs returns no packages.

and pico? use vi like a man. ;)

dirgotronix 11-13-2001 02:39 AM
Anyone know where I can get axps or apxs or whatever? From my assumption it comes with apache, but it's nowhere to be found on my system.

Virix 11-13-2001 10:59 AM
Look in /usr/local/apache/bin
or /etc/httpd/bin

dirgotronix 11-13-2001 04:42 PM
argh, I've already pointed out that it is not on my system. where do I download it.

thewitt 11-13-2001 09:08 PM
APXS is the Apache Extension Tool and makes Apache DSO modules work. You get it from the Apache website - with Apache...

-t

dirgotronix 11-13-2001 09:16 PM
argh...

nevermind, I'll live without.

/me bangs head on table

Vinney 05-19-2002 01:27 PM
Quote:
Originally posted by Ruth
Module: mod_auth_mysql
OS: Unix, Linux , WinNT.

Example:


AuthType Basic
AuthName "MySQL Member Page"

Auth_MYSQLhost www.vbulletin.com
Auth_MYSQLusername root
Auth_MYSQLpassword *****
Auth_MYSQLdatabase forum
Auth_MYSQLpwd_table user
Auth_MYSQLuid_field username
Auth_MYSQLpwd_field password
Auth_MYSQL_EncryptedPasswords off

<LIMIT GET POST>
require valid-user
</LIMIT>


for more information about this module contact your webhost.
How do you restrict this to specific user groups.?? My forum is a club website . .... there is registerd forum users ( Non PGAC Members, userid = 2) and there is registerd forum users with Private access who have paid ( PGAC Members, userid = 8)


I want to be able to use the forum database but only allow the PGAC members to access the areas i want via this htaccess thing.

NTLDR 05-19-2002 06:25 PM
Quote:
Originally posted by Vinney


How do you restrict this to specific user groups.?? My forum is a club website . .... there is registerd forum users ( Non PGAC Members, userid = 2) and there is registerd forum users with Private access who have paid ( PGAC Members, userid = 8)

I want to be able to use the forum database but only allow the PGAC members to access the areas i want via this htaccess thing.
This hack cannot do that, all the files are in the same directory so an individual forum cannot be protected by .htaccess you need to use Forum Permissions to set which groups can access a forum and which can't.

Vinney 05-19-2002 06:30 PM
yeah you can .... i found out for my self ...

this is wot i ment.

<DIRECTORY /home/testdir>
AuthType Basic
AuthUserfile /dev/null
AuthName "Member Access Only"
AuthType Basic
AuthGroupFile /dev/null
AuthMySQLHost localhost
AuthMySQLCryptedPasswords Off
AuthMySQLUser <user>
AuthMySQLPassword <pw>
AuthMySQLDB <forums dbase name>
AuthMySQLUserTable user
AuthMySQLNameField username
AuthMySQLPasswordField password
AuthMySQLGroupField usergroupid
<Limit GET POST>
require group 6 7
</limit>
</DIRECTORY>

NTLDR 05-19-2002 07:07 PM
That won't protect an individual forum though, unless you two boards installed in different directories.

Vinney 05-19-2002 10:11 PM
There is only one forum !!! I want to be able to use the forum presmissions to grant access to other areas of the clubs website !! for example ... the chat room ....

NTLDR 05-20-2002 02:39 PM
If they are PHP files make sure the include golbal.php and have like following after it:

PHP Code:
if ($bbuserinfo['usergroupid'] == id){
elseif ($bbuserinfo['usergroupid']){
    show_nopermission();
} 
This may not be correct, I'll test it when I get home, I think it should work.

esemay 07-25-2002 03:26 AM
Is there a way to get this to work on Win 2000 running IIS 5?

Shawn

Mr_P 09-27-2002 10:49 PM
er...in a word

"No"

Htaccess is an Apache thing.

Erwin 09-28-2002 12:39 AM
Why would you want to use the same username and passwords for .htaccess? Isn't it better to have a different set of username and passwords in case the database ones gets compromised? That's what I do.

Black Tiger 04-10-2010 04:25 PM
Quote:
Htaccess is an Apache thing.
Nope. In several web servers (most commonly Apache), .htaccess (hypertext access) is the default name of a directory-level configuration file that allows for decentralized management of web server configuration.
It works on several webservers so also on Sun Java System Web Server and Zeus Web Server.

So it's not specific an Apache thing but a webserver thing on a *nix (Unix/Linux) environment. And that's the reason it won't work on windows. Otherwise people get confused why it won't work with Apache for windows.

mikey1991 04-11-2010 07:07 AM
Wow, old thread.

Marco van Herwaarden 04-11-2010 02:27 PM
At the time this information was posted it was probably correct.

Closing as this is a 8 year old thread.


All times are GMT. The time now is 04:44 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01064 seconds
  • Memory Usage 1,764KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (24)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete