pam-mysql-general

[pam-mysql-general] controlling log output

[Erick C. <e...@ar...>]

hi everyone,

every day I get an e-mail from logwatch including a section, a sample  
of which I've reproduced below.  my question for the list today is:  
this seems to me like debugging output... how can I get only problems  
instead of following the workings of pam_mysql blow by blow?

thanks - erick

-------------------- sasl auth daemon Begin ------------------------

**Unmatched Entries**

pam_mysql - option debug is set to ""
pam_mysql - pam_mysql_close_db() called.
pam_mysql - pam_sm_authenticate() called.
pam_mysql - pam_mysql_open_db() called.
pam_mysql - pam_mysql_open_db() returning 0.
pam_mysql - pam_mysql_check_passwd() called.
pam_mysql - pam_mysql_format_string() called
pam_mysql - pam_mysql_quick_escape() called.
pam_mysql - SELECT password FROM users WHERE email = 'e...@ar...'
pam_mysql - pam_mysql_check_passwd() returning 6.
pam_mysql - pam_mysql_sql_log() called.
pam_mysql - pam_mysql_sql_log() returning 0.
pam_mysql - pam_mysql_converse() called.
pam_mysql - pam_mysql_open_db() called.
pam_mysql - pam_mysql_check_passwd() called.
pam_mysql - pam_mysql_format_string() called
pam_mysql - pam_mysql_quick_escape() called.
pam_mysql - SELECT password FROM users WHERE email = 'e...@ar...'
pam_mysql - pam_mysql_check_passwd() returning 0.
pam_mysql - pam_mysql_sql_log() called.
pam_mysql - pam_mysql_sql_log() returning 0.
pam_mysql - pam_sm_authenticate() returning 0.
pam_mysql - option user is set to "mail_admin"
pam_mysql - option passwd is set to "mail_admin_pwd"
pam_mysql - option host is set to "127.0.0.1"
pam_mysql - option db is set to "mail"
pam_mysql - option table is set to "users"
pam_mysql - option usercolumn is set to "email"
pam_mysql - option passwdcolumn is set to "password"
pam_mysql - option crypt is set to "Y"
pam_mysql - option debug is set to ""
pam_mysql - pam_mysql_close_db() called.
pam_mysql - pam_sm_acct_mgmt() called.
pam_mysql - pam_mysql_open_db() called.
pam_mysql - pam_mysql_open_db() returning 0.
pam_mysql - pam_mysql_query_user_stat() called.
pam_mysql - pam_mysql_format_string() called
pam_mysql - pam_mysql_quick_escape() called.
pam_mysql - SELECT 0, password FROM users WHERE email = 'e...@ar...'
pam_mysql - pam_mysql_query_user_stat() returning 0.
pam_mysql - pam_mysql_sql_log() called.
pam_mysql - pam_mysql_sql_log() returning 0.
pam_mysql - pam_sm_acct_mgmt() returning 0.
pam_mysql - pam_mysql_release_ctx() called.
pam_mysql - pam_mysql_destroy_ctx() called.
pam_mysql - pam_mysql_close_db() called.

<snip>

---------------------- sasl auth daemon End -------------------------

Re: [pam-mysql-general] controlling log output

[Erick C. <e...@ar...>]

hei everyone, I wrote at the end of November but never got a reply.   
anyone got a clue for me?

On Nov 30, 2009, at 12:04 PM, Erick Calder wrote:

> hi everyone,
>
> every day I get an e-mail from logwatch including a section, a  
> sample of which I've reproduced below.  my question for the list  
> today is: this seems to me like debugging output... how can I get  
> only problems instead of following the workings of pam_mysql blow by  
> blow?
>
> thanks - erick
>
> -------------------- sasl auth daemon Begin ------------------------
>
> **Unmatched Entries**
>
> pam_mysql - option debug is set to ""
> pam_mysql - pam_mysql_close_db() called.
> pam_mysql - pam_sm_authenticate() called.
> pam_mysql - pam_mysql_open_db() called.
> pam_mysql - pam_mysql_open_db() returning 0.
> pam_mysql - pam_mysql_check_passwd() called.
> pam_mysql - pam_mysql_format_string() called
> pam_mysql - pam_mysql_quick_escape() called.
> pam_mysql - SELECT password FROM users WHERE email = 'e...@ar...'
> pam_mysql - pam_mysql_check_passwd() returning 6.
> pam_mysql - pam_mysql_sql_log() called.
> pam_mysql - pam_mysql_sql_log() returning 0.
> pam_mysql - pam_mysql_converse() called.
> pam_mysql - pam_mysql_open_db() called.
> pam_mysql - pam_mysql_check_passwd() called.
> pam_mysql - pam_mysql_format_string() called
> pam_mysql - pam_mysql_quick_escape() called.
> pam_mysql - SELECT password FROM users WHERE email = 'e...@ar...'
> pam_mysql - pam_mysql_check_passwd() returning 0.
> pam_mysql - pam_mysql_sql_log() called.
> pam_mysql - pam_mysql_sql_log() returning 0.
> pam_mysql - pam_sm_authenticate() returning 0.
> pam_mysql - option user is set to "mail_admin"
> pam_mysql - option passwd is set to "mail_admin_pwd"
> pam_mysql - option host is set to "127.0.0.1"
> pam_mysql - option db is set to "mail"
> pam_mysql - option table is set to "users"
> pam_mysql - option usercolumn is set to "email"
> pam_mysql - option passwdcolumn is set to "password"
> pam_mysql - option crypt is set to "Y"
> pam_mysql - option debug is set to ""
> pam_mysql - pam_mysql_close_db() called.
> pam_mysql - pam_sm_acct_mgmt() called.
> pam_mysql - pam_mysql_open_db() called.
> pam_mysql - pam_mysql_open_db() returning 0.
> pam_mysql - pam_mysql_query_user_stat() called.
> pam_mysql - pam_mysql_format_string() called
> pam_mysql - pam_mysql_quick_escape() called.
> pam_mysql - SELECT 0, password FROM users WHERE email = 'e...@ar...'
> pam_mysql - pam_mysql_query_user_stat() returning 0.
> pam_mysql - pam_mysql_sql_log() called.
> pam_mysql - pam_mysql_sql_log() returning 0.
> pam_mysql - pam_sm_acct_mgmt() returning 0.
> pam_mysql - pam_mysql_release_ctx() called.
> pam_mysql - pam_mysql_destroy_ctx() called.
> pam_mysql - pam_mysql_close_db() called.
>
> <snip>
>
> ---------------------- sasl auth daemon End -------------------------
>

Re: [pam-mysql-general] controlling log output

[Craig W. <cr...@xe...>]

Hi,

On Mon, Jan 18, 2010 at 06:09, Erick Calder <e...@ar...> wrote:
> hei everyone, I wrote at the end of November but never got a reply.
> anyone got a clue for me?


Try setting verbose to 0 (zero).

  http://pam-mysql.sourceforge.net/Documentation/package-readme.php?seemore=y

Possibly you need to recompile.

  http://www.weltraumsofa.de/pam_mysql/doku_pamnssmysql_jh_en.html#4.6

Cheers,
Craig
-- 
Craig Webster   | http://barkingiguana.com/~craig
Xeriom Networks | http://xeriom.net/

Re: [pam-mysql-general] controlling log output

[Erick C. <e...@ar...>]

thanks for the reply.  that documentation is in the README file but  
what the file doesn't say is where the config file (where I would put  
that setting) is located.  I'm running on Fedora with a precompiled  
package and it doesn't include a config file (typically in /etc)

I do hope I don't have to recompile!

On Jan 18, 2010, at 1:57 AM, Craig Webster wrote:

> Hi,
>
> On Mon, Jan 18, 2010 at 06:09, Erick Calder <e...@ar...> wrote:
>> hei everyone, I wrote at the end of November but never got a reply.
>> anyone got a clue for me?
>
>
> Try setting verbose to 0 (zero).
>
>  http://pam-mysql.sourceforge.net/Documentation/package-readme.php?seemore=y
>
> Possibly you need to recompile.
>
>  http://www.weltraumsofa.de/pam_mysql/doku_pamnssmysql_jh_en.html#4.6
>
> Cheers,
> Craig
> -- 
> Craig Webster   | http://barkingiguana.com/~craig
> Xeriom Networks | http://xeriom.net/

Re: [pam-mysql-general] controlling log output

[Craig W. <cr...@xe...>]

Hi,

On Mon, Jan 18, 2010 at 09:57, Craig Webster <cr...@xe...> wrote:
> On Mon, Jan 18, 2010 at 06:09, Erick Calder <e...@ar...> wrote:
>> hei everyone, I wrote at the end of November but never got a reply.
>> anyone got a clue for me?

Looking again, these seem to be saslauthd debug messages. saslauthd is
probably using your syslogd configuration. Check how to control log
facility and level for that.

Sorry for the noise.

Cheers,
Craig
-- 
Craig Webster   | http://barkingiguana.com/~craig
Xeriom Networks | http://xeriom.net/

Re: [pam-mysql-general] controlling log output

[Erick C. <e...@ar...>]

Craig,

I've looked through the docs on my installed version of rsyslogd (see  
link below):

	http://www.arix.com/docs/rsyslog-3.22.1/rsyslog_conf.html

but I don't find any reference to saslauthd... I've also googled but  
there's precious little out there about what I need.  it seems to me  
that even if I "filter" out these messages something is still  
generating them so I'm wondering how they can be turned off...  
saslauthd has a -d for debugging output but from looking at my /etc/ 
sysconfig/saslauthd I don't see that it's used.  also, I see there a  
choice to pass options to the underlying mechanism (pam) but none are  
passed.  so I'm wondering: if saslauthd calls pam, then pam must call  
pam-mysql... but when I look in /etc/pam.d I see nothing for pam-mysql.

help!

On Jan 18, 2010, at 2:00 AM, Craig Webster wrote:

> Hi,
>
> On Mon, Jan 18, 2010 at 09:57, Craig Webster <cr...@xe...> wrote:
>> On Mon, Jan 18, 2010 at 06:09, Erick Calder <e...@ar...> wrote:
>>> hei everyone, I wrote at the end of November but never got a reply.
>>> anyone got a clue for me?
>
> Looking again, these seem to be saslauthd debug messages. saslauthd is
> probably using your syslogd configuration. Check how to control log
> facility and level for that.
>
> Sorry for the noise.
>
> Cheers,
> Craig
> -- 
> Craig Webster   | http://barkingiguana.com/~craig
> Xeriom Networks | http://xeriom.net/

Re: [pam-mysql-general] controlling log output

[Erick C. <e...@ar...>]

hei.  I sent this about 10 days ago but have not seen any reply.  did  
I mail the right list?

On Nov 30, 2009, at 12:04 PM, Erick Calder wrote:

> hi everyone,
>
> every day I get an e-mail from logwatch including a section, a  
> sample of which I've reproduced below.  my question for the list  
> today is: this seems to me like debugging output... how can I get  
> only problems instead of following the workings of pam_mysql blow by  
> blow?
>
> thanks - erick
>
> -------------------- sasl auth daemon Begin ------------------------
>
> **Unmatched Entries**
>
> pam_mysql - option debug is set to ""
> pam_mysql - pam_mysql_close_db() called.
> pam_mysql - pam_sm_authenticate() called.
> pam_mysql - pam_mysql_open_db() called.
> pam_mysql - pam_mysql_open_db() returning 0.
> pam_mysql - pam_mysql_check_passwd() called.
> pam_mysql - pam_mysql_format_string() called
> pam_mysql - pam_mysql_quick_escape() called.
> pam_mysql - SELECT password FROM users WHERE email = 'e...@ar...'
> pam_mysql - pam_mysql_check_passwd() returning 6.
> pam_mysql - pam_mysql_sql_log() called.
> pam_mysql - pam_mysql_sql_log() returning 0.
> pam_mysql - pam_mysql_converse() called.
> pam_mysql - pam_mysql_open_db() called.
> pam_mysql - pam_mysql_check_passwd() called.
> pam_mysql - pam_mysql_format_string() called
> pam_mysql - pam_mysql_quick_escape() called.
> pam_mysql - SELECT password FROM users WHERE email = 'e...@ar...'
> pam_mysql - pam_mysql_check_passwd() returning 0.
> pam_mysql - pam_mysql_sql_log() called.
> pam_mysql - pam_mysql_sql_log() returning 0.
> pam_mysql - pam_sm_authenticate() returning 0.
> pam_mysql - option user is set to "mail_admin"
> pam_mysql - option passwd is set to "mail_admin_pwd"
> pam_mysql - option host is set to "127.0.0.1"
> pam_mysql - option db is set to "mail"
> pam_mysql - option table is set to "users"
> pam_mysql - option usercolumn is set to "email"
> pam_mysql - option passwdcolumn is set to "password"
> pam_mysql - option crypt is set to "Y"
> pam_mysql - option debug is set to ""
> pam_mysql - pam_mysql_close_db() called.
> pam_mysql - pam_sm_acct_mgmt() called.
> pam_mysql - pam_mysql_open_db() called.
> pam_mysql - pam_mysql_open_db() returning 0.
> pam_mysql - pam_mysql_query_user_stat() called.
> pam_mysql - pam_mysql_format_string() called
> pam_mysql - pam_mysql_quick_escape() called.
> pam_mysql - SELECT 0, password FROM users WHERE email = 'e...@ar...'
> pam_mysql - pam_mysql_query_user_stat() returning 0.
> pam_mysql - pam_mysql_sql_log() called.
> pam_mysql - pam_mysql_sql_log() returning 0.
> pam_mysql - pam_sm_acct_mgmt() returning 0.
> pam_mysql - pam_mysql_release_ctx() called.
> pam_mysql - pam_mysql_destroy_ctx() called.
> pam_mysql - pam_mysql_close_db() called.
>
> <snip>
>
> ---------------------- sasl auth daemon End -------------------------
>