Hi,
I am working on set up the new apache server on Linux using Mysql
databases,
and moving all the files from old server to new one.
Problem I have is how to set the mod_auth_mysql on the new one?
I need to have MySQl authentication when users to get in the website.
Old machine Apache version: 1.3.20 , new machine Apache version is 2.0.
The Mysql data database name is Safety, Safety has SUsers table,
which has susername and spassword ... fields.
on old server httpd.conf, there are follwing two sentences doing the
authentication:
Auth_MYSQL_Info . webadmin password(for webadmin)
Auth_MySQL_General_db Safety
webadmin is in the user table of mysql, but not in the Safety database,
webadmin has all the provileges for Safety database.
I have set user and db tables of mysql according the mysql database of old
one.
on the new one:
In the auth_mysql.conf file, I added the following line:
<Directory /var/www/html>
AuthName "MySQL authenticated zone"
AuthType Basic
AuthMySQLUser webadmin
AuthMySQLPassword password for webadmin
AuthMySQLDB Safety
AuthMySQLUserTable SUsers
AuthMySQLNameField susername
AuthMySQLPasswordField spassword
require valid-user
</Directory>
After stop and start http, I get the authenticated login and password
prompt,
that is what I need, but I can not login use my susername and spassword in
Safety database, which I do not have problem to get in on the old server.
I have tried to reset my spassword in Safety database, it will not let me
in either,
and I tried to use password('xxxx') function to reset my spassword, I can't
get in either,
when I tried use encrypt('xxxx') function to reset my spassword,
and click on the new serve, it even does not give me the authenticated
login and password
prompt and get nothing from Safety database.
I add webadmin to the Safety database and grant all the privileges, it
happened the same
as I use encrypt function to reset my password without prompt for login and
password.
the mysql version on the old machine is 3.23.38, on the new one is 3.26.59
and the spassword field is defined as varchar(16).
Thanks in advance for all your help and I am looking forward to hearing from
you !!!
Shirly Xu
TAMU
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]