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]