Question

When setting up TWiki on Linux, after enabling basic user authentication: upon registration the username and password hash are entered in the .htpasswd file, an email is sent, but the browser keeps prompting for a username and password. You are typing the correct username and password. Upon examination of your Apache /var/log/error_log, you notice MySQL errors for every login attempt:

[Fri Jul 15 19:27:38 2005] [error] [client 192.168.208.153] MySQL ERROR: Table 'test.user_info' doesn't exist: /twiki/bin/viewauth/Main/%USERLAYOUTURL%, referer: http://hawker/twiki/bin/view
[Fri Jul 15 19:27:38 2005] [error] [client 192.168.208.153] MySQL user TWikiGuest not found: /twiki/bin/viewauth/Main/%USERLAYOUTURL%, referer: http://hawker/twiki/bin/view

Environment

-- GuenterBuenter - 16 Jul 2005

Answer

The answer is likely to do with your Apache. If you installed the Apache module mod_auth_mysql, or you used an RPM package to install Apache and didn't deselect this mod, Apache will try to authenticate against MySQL even if you have you basic password configuration set up perfectly. See http://forum.agileco.com/archive/index.php/t-763.html.

To get around this issue, deinstall mod_auth_mysql or add the AuthMySQLEnable off directive to your httpd.conf:

<Directory />
   Options All
   AuthMySQLEnable off
   AllowOverride All
</Directory>

-- GuenterBuenter - 16 Jul 2005

Thanks Guenter for sharing this!

-- PeterThoeny - 16 Jul 2005

It resolve my problem!! Thank u very much! niegq

-- TWikiGuest - 16 Feb 2006