You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by Xiongfei Wang <wa...@arches.uga.edu> on 2003/02/03 15:39:00 UTC
[users@httpd] problem with configure MySQL for authentication
I have redhat 7.3 server wiht apache 1.3.23 running on it. i want to use
my sql for user athentication. I did it following the instruction from
p196 to p212 in Kabi's Apache Server 2 bible. After I added
---------------------------------------------------------------
# Using mysql database for authrization and authentication
Auth_MySQL_Info db_hostname db_username db_password
Auth_MySQL_General_DB database_name
-----------------------------------------------------
to httpd.conf and retarted the httpd i got error msg:
-------------------------------------------------------
[root@mango mysqlsrc]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: Syntax error on line 100 of /etc/httpd/conf/httpd.conf:
Invalid command 'Auth_MySQL_Info', perhaps mis-spelled or defined by a
module not included in the server configuration [FAILED]
--------------------------------------------------------------------------
It says Auth_MySQL_Info is an invalid command, but i copy it from kabir's
book.
What is the reason, and how can i fix this problem?
Thanks
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] problem with configure MySQL for authentication
Posted by Xiongfei Wang <wa...@arches.uga.edu>.
my .htacess has
-------------------------
AuthType Basic
AuthName "perkdb-dev"
#Auth_MySQL on
AuthMySQLHost localhost
AuthMySQLUser httpd
AuthMySQLPassword httpd1830
AuthMySQLDB registeredusers
AuthMySQLUserTable perkdbdevusers
AuthMySQLNameField username
#AuthMySQLGroupField user_group
AuthMySQLPasswordField passwd
-----------------------------------
MySql table
mysql> select * from perkdbdevusers
-> ;
+----------+----------+
| username | passwd |
+----------+----------+
| jianping | erdtrgfe |
| chichi | erdtrgfe |
+----------+----------+
2 rows in set (0.00 sec)
when i try to login using user chichi and provide the password erdtrgfe, i
i failed and following msg in error log:
error log file:
[Mon Feb 3 22:09:15 2003] [error] user chichi: password mismatch: /
What is wrong here and how i can fix the problem?
Thanks
On Mon, 3 Feb 2003, Leander Jedamus wrote:
> Hi!
>
> Try this one:
> ----8<----8<----8<----8<----8<----8<----8<----8<----
> AuthName "password for ..."
> AuthType Basic
> AuthMySQLHost db_hostname
> AuthMySQLUser db_user
> AuthMySQLPassword your_password_here
> AuthMySQLDB db_name
> AuthMySQLUserTable table_name
> AuthMySQLGroupTable table_name2
> AuthMySQLNameField user_name
> AuthMySQLGroupField user_group
> AuthMySQLPasswordField user_passwd
> require valid-user
> ----8<----8<----8<----8<----8<----8<----8<----8<----
>
> Bis dann,
> Leander Jedamus
> Am Montag, 3. Februar 2003 15:39 schrieb Xiongfei Wang:
> > I have redhat 7.3 server wiht apache 1.3.23 running on it. i want to use
> > my sql for user athentication. I did it following the instruction from
> > p196 to p212 in Kabi's Apache Server 2 bible. After I added
> >
> > ---------------------------------------------------------------
> > # Using mysql database for authrization and authentication
> > Auth_MySQL_Info db_hostname db_username db_password
> > Auth_MySQL_General_DB database_name
> > -----------------------------------------------------
> >
> > to httpd.conf and retarted the httpd i got error msg:
> >
> > -------------------------------------------------------
> > [root@mango mysqlsrc]# service httpd restart
> > Stopping httpd: [ OK ]
> > Starting httpd: Syntax error on line 100 of /etc/httpd/conf/httpd.conf:
> > Invalid command 'Auth_MySQL_Info', perhaps mis-spelled or defined by a
> > module not included in the server configuration [FAILED]
> > --------------------------------------------------------------------------
> >
> > It says Auth_MySQL_Info is an invalid command, but i copy it from kabir's
> > book.
> >
> > What is the reason, and how can i fix this problem?
> >
> > Thanks
> >
> >
> > ---------------------------------------------------------------------
> > The official User-To-User support forum of the Apache HTTP Server Project.
> > See <URL:http://httpd.apache.org/userslist.html> for more info.
> > To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> > " from the digest: users-digest-unsubscribe@httpd.apache.org
> > For additional commands, e-mail: users-help@httpd.apache.org
>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] problem with configure MySQL for authentication
Posted by Xiongfei Wang <wa...@arches.uga.edu>.
Thanks for rerponse;
what is the directives for having plaintext as password or encryped
passwords?
Thanks
On Mon, 3 Feb 2003, Leander Jedamus wrote:
> Hi!
>
> Try this one:
> ----8<----8<----8<----8<----8<----8<----8<----8<----
> AuthName "password for ..."
> AuthType Basic
> AuthMySQLHost db_hostname
> AuthMySQLUser db_user
> AuthMySQLPassword your_password_here
> AuthMySQLDB db_name
> AuthMySQLUserTable table_name
> AuthMySQLGroupTable table_name2
> AuthMySQLNameField user_name
> AuthMySQLGroupField user_group
> AuthMySQLPasswordField user_passwd
> require valid-user
> ----8<----8<----8<----8<----8<----8<----8<----8<----
>
> Bis dann,
> Leander Jedamus
> Am Montag, 3. Februar 2003 15:39 schrieb Xiongfei Wang:
> > I have redhat 7.3 server wiht apache 1.3.23 running on it. i want to use
> > my sql for user athentication. I did it following the instruction from
> > p196 to p212 in Kabi's Apache Server 2 bible. After I added
> >
> > ---------------------------------------------------------------
> > # Using mysql database for authrization and authentication
> > Auth_MySQL_Info db_hostname db_username db_password
> > Auth_MySQL_General_DB database_name
> > -----------------------------------------------------
> >
> > to httpd.conf and retarted the httpd i got error msg:
> >
> > -------------------------------------------------------
> > [root@mango mysqlsrc]# service httpd restart
> > Stopping httpd: [ OK ]
> > Starting httpd: Syntax error on line 100 of /etc/httpd/conf/httpd.conf:
> > Invalid command 'Auth_MySQL_Info', perhaps mis-spelled or defined by a
> > module not included in the server configuration [FAILED]
> > --------------------------------------------------------------------------
> >
> > It says Auth_MySQL_Info is an invalid command, but i copy it from kabir's
> > book.
> >
> > What is the reason, and how can i fix this problem?
> >
> > Thanks
> >
> >
> > ---------------------------------------------------------------------
> > The official User-To-User support forum of the Apache HTTP Server Project.
> > See <URL:http://httpd.apache.org/userslist.html> for more info.
> > To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> > " from the digest: users-digest-unsubscribe@httpd.apache.org
> > For additional commands, e-mail: users-help@httpd.apache.org
>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] problem with configure MySQL for authentication
Posted by Leander Jedamus <je...@Fh-Worms.DE>.
Hi!
Try this one:
----8<----8<----8<----8<----8<----8<----8<----8<----
AuthName "password for ..."
AuthType Basic
AuthMySQLHost db_hostname
AuthMySQLUser db_user
AuthMySQLPassword your_password_here
AuthMySQLDB db_name
AuthMySQLUserTable table_name
AuthMySQLGroupTable table_name2
AuthMySQLNameField user_name
AuthMySQLGroupField user_group
AuthMySQLPasswordField user_passwd
require valid-user
----8<----8<----8<----8<----8<----8<----8<----8<----
Bis dann,
Leander Jedamus
Am Montag, 3. Februar 2003 15:39 schrieb Xiongfei Wang:
> I have redhat 7.3 server wiht apache 1.3.23 running on it. i want to use
> my sql for user athentication. I did it following the instruction from
> p196 to p212 in Kabi's Apache Server 2 bible. After I added
>
> ---------------------------------------------------------------
> # Using mysql database for authrization and authentication
> Auth_MySQL_Info db_hostname db_username db_password
> Auth_MySQL_General_DB database_name
> -----------------------------------------------------
>
> to httpd.conf and retarted the httpd i got error msg:
>
> -------------------------------------------------------
> [root@mango mysqlsrc]# service httpd restart
> Stopping httpd: [ OK ]
> Starting httpd: Syntax error on line 100 of /etc/httpd/conf/httpd.conf:
> Invalid command 'Auth_MySQL_Info', perhaps mis-spelled or defined by a
> module not included in the server configuration [FAILED]
> --------------------------------------------------------------------------
>
> It says Auth_MySQL_Info is an invalid command, but i copy it from kabir's
> book.
>
> What is the reason, and how can i fix this problem?
>
> Thanks
>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org