mysql logins

Is there a log file or is there some way to create a log file to
monitor logins to a MySQL server?
Is there something that can be added in the my.cnf file or is there a
default log which keeps this information? I am using MySQL 4.1.

I am currently having trouble using AuthMYSQL on a apache web server
and can't tell if it is even attempting to login. I can create a PHP
page and login using the account and can use the local client to login,
but it doesn't appear to be working with AuthMYSQL. I am using the
same .htaccess as I was for mysql 3.53 and transferred it over to a
system with 4.1 and can't seem to get it to work.

I tried to load the module mysql_auth_module in the httpd.conf file
explicitly and I received the error
module mysql_auth_module is already loaded, skipping
upon restarting the system.

<phwashington@comcast.net> wrote in message
news:1141612000.648167.276920@i40g2000cwc.googlegr oups.com...
> I am currently having trouble using AuthMYSQL on a apache web server
....
> I am using the
> same .htaccess as I was for mysql 3.53 and transferred it over to a
> system with 4.1 and can't seem to get it to work.

I don't know anything about AuthMYSQL, but I would guess you might be
experiencing the issue documented here:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

In other words, PHP cannot login to the MySQL database, to do the
authentication for your web app.

Regards,
Bill K.

Thanks for the page. I read through it and it indicates that if this
problem occurs php will not be able to login. I can login with PHP,
but AuthMYSQL doesn't appear to work. I looked at my password length
and they are still old style. less than 16 characters. Thanks for the
effort and the heads up. This will really put a kink in things if I
upgrade to 5.0.

phwashington@comcast.net wrote:
> Is there a log file or is there some way to create a log file to
> monitor logins to a MySQL server?

The general log (--log) logs login attempts to MySQL. Both successful
and unsuccessful.

> I am currently having trouble using AuthMYSQL on a apache web server
> and can't tell if it is even attempting to login.

Where did you get mod_auth_mysql from? I remember there was a broken
version floating around. But I compiled it several times back in the
old days ...

> I am using the
> same .htaccess as I was for mysql 3.53 and transferred it over to a
> system with 4.1 and can't seem to get it to work.

What is "can't get it to work"? No login request from server? Access
denied? Is there anything in the Apache error log?


XL
--
Axel Schwenke, Senior Software Developer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/

Following is the error that I see in the apache logs. Sorry I didn't
include it earlier.

in /var/log/httpd/error_log
configuration error: couldn't check user. No user file?:
/TEST/index.html

I must not have the correct setting in my.cnf because I looked in
/var/log/mysqld.log and in /var/log/messages and cannot find anything
for users logging in. The only thing I see are mysqld shutdowns and
restarts.

phwashington@comcast.net wrote:
> Following is the error that I see in the apache logs. Sorry I didn't
> include it earlier.
>
> in /var/log/httpd/error_log
> configuration error: couldn't check user. No user file?:
> /TEST/index.html

Looks like you haven't loaded mod_auth_mysql into Apache.
Check your httpd.conf. Some mod_auth_mysql settings can
only be done there.


XL
--
Axel Schwenke, Senior Software Developer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/

phwashington@comcast.net wrote:
> I must not have the correct setting in my.cnf because I looked in
> /var/log/mysqld.log and in /var/log/messages and cannot find anything
> for users logging in. The only thing I see are mysqld shutdowns and
> restarts.

The general log has to be turned on explicitly by putting the
--log option onto mysqld commandline or into my.cnf.

http://dev.mysql.com/doc/refman/5.0/en/query-log.html
http://dev.mysql.com/doc/refman/5.0/...ion-files.html


XL
--
Axel Schwenke, Senior Software Developer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/

I created another log as per the option-files and when I log in on the
local client and when I log in via a PHP page the login shows up. But
whenever I go to a directory where I am trying to use AuthMYSQL no
login shows up. So my current guess is that there is a problem with my
configuration or mod_auth_mysql.
I have read and tried to follow the directions in the mod_auth_mysql
documentation and everything appears to be correct.