pam_mysql: error: sqllog set but logtable not set

Dr_Stein · Last edited by Dr_Stein on Sat Jun 26, 2004 3:44 am; edited 1 time in total

Jun 24 18:11:22 mail saslauthd[7622]: server_exit : master exited: 7622
Jun 24 18:11:23 mail saslauthd[8643]: detach_tty : master pid is: 8643
Jun 24 18:11:23 mail saslauthd[8643]: ipc_init : listening on socket: /var/lib/sasl2/mux
Jun 24 18:11:36 mail saslauthd[8647]: pam_mysql: error: sqllog set but logtable not set
Jun 24 18:11:36 mail saslauthd[8647]: pam_mysql: error: sqllog set but logmsgcolumn not set
Jun 24 18:11:36 mail saslauthd[8647]: pam_mysql: error: sqllog set but logusercolumn not set
Jun 24 18:11:36 mail saslauthd[8647]: pam_mysql: error: sqllog set but loghostcolumn not set
Jun 24 18:11:36 mail saslauthd[8647]: pam_mysql: error: sqllog set but logtimecolumn not set
Jun 24 18:11:45 mail saslauthd[8649]: pam_mysql: error: sqllog set but logtable not set
Jun 24 18:11:45 mail saslauthd[8649]: pam_mysql: error: sqllog set but logmsgcolumn not set
Jun 24 18:11:45 mail saslauthd[8649]: pam_mysql: error: sqllog set but logusercolumn not set
Jun 24 18:11:45 mail saslauthd[8649]: pam_mysql: error: sqllog set but loghostcolumn not set
Jun 24 18:11:45 mail saslauthd[8649]: pam_mysql: error: sqllog set but logtimecolumn not set
Jun 24 18:11:56 mail saslauthd[8643]: pam_mysql: error: sqllog set but logtable not set
Jun 24 18:11:56 mail saslauthd[8643]: pam_mysql: error: sqllog set but logmsgcolumn not set
Jun 24 18:11:56 mail saslauthd[8643]: pam_mysql: error: sqllog set but logusercolumn not set
Jun 24 18:11:56 mail saslauthd[8643]: pam_mysql: error: sqllog set but loghostcolumn not set
Jun 24 18:11:56 mail saslauthd[8643]: pam_mysql: error: sqllog set but logtimecolumn not set

I tried sqllog=0 in /etc/pam.d/smtp but I'm still getting these errors. Apparantly I've been getting them for a long time, too.

How can I get rid of this?

YES YES YES I GOOGLED AND GOOGLED FIRST BEFORE POSTING THIS.

No, I did NOT find an answer - but I believe others may be suffering from this issue as well because I followed the directions straight out of the Virtual-Mailhost HOWTO and it involves pam_mysql - so, check your /var/log/auth.log file if you followed that howto.

I haven't found a solution so far - and I *don't* want to just start using MySQL for logging - I want to use Syslog.

Houdini · Posted: Fri Jun 25, 2004 4:00 am Post subject:

Post your /etc/pam.d/smtp .
_________________
^]:wq

Dr_Stein · Posted: Fri Jun 25, 2004 4:11 am Post subject:

mail log # cat /etc/pam.d/smtp
# $Header: /home/cvsroot/gentoo-x86/net-mail/postfix/files/smtp.pam,v 1.3 2003/12/20 15:03:50 azarah Exp $
#auth required /lib/security/pam_stack.so service=system-auth
#account required /lib/security/pam_stack.so service=system-auth

auth optional pam_mysql.so server=localhost db=mailsql user=mailsql \
passwd=password! table=users usercolumn=email passwdcolumn=clear crypt=0
account required pam_mysql.so server=localhost db=mailsql user=mailsql \
passwd=password! sqllog=0 table=users usercolumn=email passwdcolumn=clear crypt=0

mail log #

Houdini · Posted: Fri Jun 25, 2004 4:15 am Post subject:

The only uncommented lines in your /etc/pam.d/smtp are mysql related. What do you expect?

The default one looks like this:

Dr_Stein · Posted: Fri Jun 25, 2004 4:37 am Post subject:

Won't work - I'm using SMTP AUTH, pulling information from mysql (as per the Virtual mailhost howto)

Houdini · Posted: Fri Jun 25, 2004 5:13 pm Post subject:

Oh. Well, then, set the things it's complaining about.

Google on "sqllog set but logtimecolumn not set", first link, had the answer to this problem. Please google before posting here, to save everyone's time.
_________________
^]:wq

Dr_Stein · Posted: Fri Jun 25, 2004 5:37 pm Post subject:

I *did* Google first.

I hate it when people say "Google first."

That doesn't solve my problem and kind of goes against the "helpful Gentoo community" ideas - if all of the forum posts said "Google first" then Google would be filled with nothing but posts saying "Google first" - I'd like to actually find a solution to the problem. In my Googling, I found a few mailing list posts where people said that they Googled but found nothing as well. So, I'm not the only one having this problem.

Perhaps the Virtual-Mailhost documentation should mention something about this as well, because i have the feeling that it's affecting many more people that just don't realize it.

Also, once I *do* find the solution, I'll post it here -so maybe Google will pick up solutions instead of posts saying "Check Google"

If I go ahead and tell it to log to SQL, that doesn't solve my problem. I want to either disable logging or have it log to syslog.

Houdini · Posted: Sat Jun 26, 2004 3:35 am Post subject:

Well, make your post read like you did the search, and people won't tell you to.

Your original post had nothing to indicate that you wanted syslog logging with mysql authentication. It said "I've got this error: how do I get rid of it?" Without more data to work from, I assumed the simplest reason, since that's the most common here. The other option would be to just not answer, since you can't take the time to formulate a reasonable question.

It would do you well to read http://www.catb.org/~esr/faqs/smart-questions.html.

I don't have an answer for the logging stuff; it's an issue for PAM now.
_________________
^]:wq

Dr_Stein · Posted: Sat Jun 26, 2004 3:41 am Post subject:

Yeah, yeah yeah. I've read that before.

I'm not a Net newbie.

Forgive me for not saying "Yes, I Googled" first.

Now, let me figure out how to delete threads, because this one will serve nobody any useful purpose in the future..

MikePikeFL · Tux's lil' helper Joined: 19 Aug 2003 Posts: 78

Yeah I would like to know how to solve this...

MikePikeFL · Tux's lil' helper Joined: 19 Aug 2003 Posts: 78

FWIW:

https://forums.gentoo.org/viewtopic-t-101174-start-0-postdays-0-postorder-asc-highlight-pammysql+error+sqllog+logtable.html