pam-mysql-general — A general list for PAM-MYSQL, subscribe if you want to ask anything :)

Re: [Pam-mysql-general] SELECT returned no result

[Gary W. S. <ga...@pr...>]

> Apr  4 13:51:23 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
> WHERE scalix =3D 'lastfirstscalixfirst last' AND (1=3D1) Apr  4 =
13:51:23
> scalix in.imap41d: pam_mysql - SELECT returned no result.

This should indeed return something if the same thing is return a result
directly with mysql.  This is beyond me.  At this point I would just see
about email the author to see if he knows anything else that we may have
missed.

Gary

Re: [Pam-mysql-general] SELECT returned no result

[xyon <xy...@in...>]

On Wed, 2007-04-04 at 10:37 -0700, Gary W. Smith wrote:
> > =3D=3D> /var/log/secure <=3D=3D
> > Apr  4 11:24:50 scalix in.imap41d: pam_mysql - option verbose is set
> to
> > "1"
> > Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_sm_authenticate()
> > called.
> > Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
> > called.
> > Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
> > returning 0.
> > Apr  4 11:24:50 scalix in.imap41d: pam_mysql -
> pam_mysql_check_passwd()
> > called.
> > Apr  4 11:24:50 scalix in.imap41d: pam_mysql -
> > pam_mysql_format_string() called Apr  4 11:24:50 scalix in.imap41d:
> > pam_mysql - pam_mysql_quick_escape() called.
> > Apr  4 11:24:50 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
> > WHERE scalix =3D 'UserTestscalixTest User' AND (idUsers > 0) Apr  4
>=20
> SELECT pwd FROM users WHERE scalix =3D 'UserTestscalixTest User' AND
> (idUsers > 0)
>=20
> Is this just a typo (or replacement) or does the username actually have
> a space in it?
Yes, there is purposely a space.

>   Also, when you cut and paste this exact SQL statement
> into mysql client do you indeed get a new result.
I get a proper result when cutting and pasting this exact statement into
the MySQL command line.

>   If you do then it could be the tunnel.
I have eliminated the tunnel from the equation, and am just connecting
to the MySQL host directly (since this is not in production and I'm
using a test database/passwords and it's all on a private subnet,
encryption isn't a big deal for troubleshooting) and have the exact same
results (see below).

I have the 'mysqlclient14' libs installed, but accessing a mysql5
server, although I don't see how this could be a problem as I've done
this many times with other applications before.


Here is the log results:
=3D=3D> /var/log/secure <=3D=3D
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - option verbose is set to
"1"
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_sm_authenticate()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
returning 0.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_format_string()
called
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_quick_escape()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
WHERE scalix =3D 'lastfirstscalixfirst last' AND (1=3D1)
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - SELECT returned no
result.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
returning 1.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_sql_log()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_sql_log()
returning 0.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_converse()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_format_string()
called
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_quick_escape()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
WHERE scalix =3D 'lastfirstscalixfirst last' AND (1=3D1)
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - SELECT returned no
result.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
returning 1.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_sql_log()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_sql_log()
returning 0.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_sm_authenticate()
returning 10.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_release_ctx()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_destroy_ctx()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_close_db()
called.




--=20
xyon

-------------------------------------------------------------------------
"They who can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety." --Benjamin Franklin
-------------------------------------------------------------------------

Re: [Pam-mysql-general] SELECT returned no result

[Gary W. S. <ga...@pr...>]

> =3D=3D> /var/log/secure <=3D=3D
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql - option verbose is set
to
> "1"
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_sm_authenticate()
> called.
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
> called.
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
> returning 0.
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql -
pam_mysql_check_passwd()
> called.
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql -
> pam_mysql_format_string() called Apr  4 11:24:50 scalix in.imap41d:
> pam_mysql - pam_mysql_quick_escape() called.
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
> WHERE scalix =3D 'UserTestscalixTest User' AND (idUsers > 0) Apr  4

SELECT pwd FROM users WHERE scalix =3D 'UserTestscalixTest User' AND
(idUsers > 0)

Is this just a typo (or replacement) or does the username actually have
a space in it?  Also, when you cut and paste this exact SQL statement
into mysql client do you indeed get a new result.  If you do then it
could be the tunnel.

Re: [Pam-mysql-general] SELECT returned no result

[xyon <xy...@in...>]

On Wed, 2007-04-04 at 08:40 -0700, Gary W. Smith wrote:
> > "SELECT pwd FROM users WHERE scalix =3D 'lastfirstscalixfirst last' AND
> > ()"
>=20
>=20
> In this case you could also just do 1=3D1 in the where clause. =20

Ah, I see. Thanks!

>=20
> > FYI, this is an stunnel connection redirecting 127.0.0.1:3306 to a
> > remote mysql host, could that have anything to do with the problems?
> > MySQL from the linux command line as the user defined works fine,
> > though.
>=20
> This could have something to do with it.  I don't do much with stunnels.
>=20
>=20
> As for the debugging, are you seeing the expected SQL statement as
> output in the secure log file?  If so can you post the section of the
> log for an entire pam-mysql access?

Certainly, here it is:

=3D=3D> /var/log/secure <=3D=3D
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - option verbose is set to
"1"
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_sm_authenticate()
called.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
called.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
returning 0.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
called.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_format_string()
called
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_quick_escape()
called.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
WHERE scalix =3D 'UserTestscalixTest User' AND (idUsers > 0)
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - SELECT returned no
result.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
returning 1.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_sql_log()
called.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_sql_log()
returning 0.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_converse()
called.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
called.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
called.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_format_string()
called
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_quick_escape()
called.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
WHERE scalix =3D 'UserTestscalixTest User' AND (idUsers > 0)
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - SELECT returned no
result.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
returning 1.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_sql_log()
called.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_sql_log()
returning 0.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_sm_authenticate()
returning 10.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_release_ctx()
called.
Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_destroy_ctx()
called.
Apr  4 11:24:51 scalix in.imap41d: pam_mysql - pam_mysql_close_db()
called.


The statement used by pam_mysql (SELECT pwd FROM users WHERE scalix =3D
'UserTestscalixTest User' AND (idUsers > 0)) returns results when run
from the mysql prompt.


--=20
xyon

-------------------------------------------------------------------------
"They who can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety." --Benjamin Franklin
-------------------------------------------------------------------------

Re: [Pam-mysql-general] SELECT returned no result

[Gary W. S. <ga...@pr...>]

> "SELECT pwd FROM users WHERE scalix =3D 'lastfirstscalixfirst last' =
AND
> ()"


In this case you could also just do 1=3D1 in the where clause. =20

> FYI, this is an stunnel connection redirecting 127.0.0.1:3306 to a
> remote mysql host, could that have anything to do with the problems?
> MySQL from the linux command line as the user defined works fine,
> though.

This could have something to do with it.  I don't do much with stunnels.


As for the debugging, are you seeing the expected SQL statement as
output in the secure log file?  If so can you post the section of the
log for an entire pam-mysql access?

Re: [Pam-mysql-general] SELECT returned no result

[xyon <xy...@in...>]

Ah, I think the formatting of the email left some things out, but you
are correct I did leave user.status_column and users.where_clause
undefined, I thought they were not needed, I apologize.

Here is what I currently have:

users.host =3D 127.0.0.1;
users.database =3D staging;
users.db_user =3D scalix;
users.db_passwd =3D mypass;
users.where_clause =3D idUsers > 0;
users.table =3D users;
users.user_column =3D scalix;
users.password_column =3D pwd;
users.status_column =3D 'A';
users.password_crypt =3D 0;
users.use_323_password =3D false;
users.use_md5 =3D false;
users.update_table =3D ;
verbose =3D 1;

The reason I put a where clause like that listed above is when
'users.where_clause' is defined, pam_mysql adds an "AND ()" to the end
of the statement causing the query to break:
"MySQL error(You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near ')' at line 1)"
"SELECT pwd FROM users WHERE scalix =3D 'lastfirstscalixfirst last' AND
()"

I've rebooted just in case pam_mysql had any cached settings from stale
connections, and tried with the above config, but I still receive
"SELECT returned no result", while a manual query works fine. Is there
further debugging I can turn on in pam_mysql?

FYI, this is an stunnel connection redirecting 127.0.0.1:3306 to a
remote mysql host, could that have anything to do with the problems?
MySQL from the linux command line as the user defined works fine,
though.


On Wed, 2007-04-04 at 07:39 -0700, Gary W. Smith wrote:
> > #users.where_clause =3D domainusers.active =3D 1 and domains.active=3D1=
 and
> > servers.active =3D 1 and servers.server_name in ('servername','*');
> >=20
> > #users.table =3D domainusers inner join domains on domainusers.domain_i=
d
> > =3D domains.domain_id inner join servers on domains.server_id =3D
> > servers.server_id; users.table =3D users;
> >=20
> > users.user_column =3D scalix;
> > users.password_column =3D pwd;
> > #users.status_column =3D 'A';
>=20
> Why are you commenting out the where, table and status_columns?  Leave
> users.status_column =3D 'A' in place.   It will have no impact but I
> believe it's a required field.
>=20
> You commented out the table and where clause but didn't put another one
> in. =20
--=20
xyon

-------------------------------------------------------------------------
"They who can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety." --Benjamin Franklin
-------------------------------------------------------------------------

Re: [Pam-mysql-general] SELECT returned no result

[Gary W. S. <ga...@pr...>]

> #users.where_clause =3D domainusers.active =3D 1 and =
domains.active=3D1 and
> servers.active =3D 1 and servers.server_name in ('servername','*');
>=20
> #users.table =3D domainusers inner join domains on =
domainusers.domain_id
> =3D domains.domain_id inner join servers on domains.server_id =3D
> servers.server_id; users.table =3D users;
>=20
> users.user_column =3D scalix;
> users.password_column =3D pwd;
> #users.status_column =3D 'A';

Why are you commenting out the where, table and status_columns?  Leave
users.status_column =3D 'A' in place.   It will have no impact but I
believe it's a required field.

You commented out the table and where clause but didn't put another one
in. =20

Re: [Pam-mysql-general] SELECT returned no result

[xyon <xy...@in...>]

Thank you very much for the samples! I've extracted your data and have
come up with the below configs.

Yet, I am still getting the same error that SELECT returned no result. I
can run the same query with results just fine manually as the scalix
user from the scalix host. I've gone from pam_mysql 0.6.2 to 0.7RC1, yet
the same results.

# cat /var/opt/scalix/sx/s/sys/pam.d/ual.remote
#%PAM-1.0
#auth       required     /lib/security/pam_stack.so service=3Dsystem-auth
#account    required     /lib/security/pam_stack.so service=3Dsystem-auth

auth       sufficient   /lib/security/pam_mysql.so
config_file=3D/etc/pam-mysql.conf
account    sufficient   /lib/security/pam_mysql.so
config_file=3D/etc/pam-mysql.conf

# cat /etc/pam-mysql.conf
users.host =3D 127.0.0.1;
users.database =3D staging;
users.db_user =3D scalix;
users.db_passwd =3D mypass;

#users.where_clause =3D domainusers.active =3D 1 and domains.active=3D1 and
servers.active =3D 1 and servers.server_name in ('servername','*');

#users.table =3D domainusers inner join domains on domainusers.domain_id =
=3D
domains.domain_id inner join servers on domains.server_id =3D
servers.server_id;
users.table =3D users;

users.user_column =3D scalix;
users.password_column =3D pwd;
#users.status_column =3D 'A';
users.password_crypt =3D 0;
users.use_323_password =3D false;
users.use_md5 =3D false;
users.update_table =3D ;

verbose =3D 1;



On Tue, 2007-04-03 at 15:51 -0700, Gary W. Smith wrote:
> Hmm, I guess I didn't use the complete SQL statement.  That was
> nss-mysql.  Anyway, here is my pam-mysql statement.  This may or may not
> work for you.  I have to create a custom patch of either pam-mysql or
> nss-mysql to use my complicated joins.  I can't remember which one off
> the top of my head and the code isn't redily available where I'm at
> today.  Anyway, here is the pam.d/ file and the pam-mysql.conf file
> (which is loaded from the pam.d/ file).
>=20
> Please note that this is from one of our dev boxes and the passwords are
> in clear text
>=20
> Hope this helps.
>=20
> [root@ etc]# cat pam.d/pop3
> #%PAM-1.0
> #auth       required     /lib/security/pam_stack.so service=3Dsystem-auth
> #account    required     /lib/security/pam_stack.so service=3Dsystem-auth
>=20
> auth       sufficient   /lib/security/pam_mysql.so
> config_file=3D/etc/pam-mysql.conf
> auth       required     /lib/security/pam_stack.so service=3Dsystem-auth
> account    sufficient   /lib/security/pam_mysql.so
> config_file=3D/etc/pam-mysql.conf
> account    required     /lib/security/pam_stack.so service=3Dsystem-auth
> session    required     pam_mkhomedir.so   skel=3D/etc/skel   umask=3D007=
7
>=20
> [root@ etc]# cat pam-mysql.conf=20
> users.host =3D ;
> users.database =3D ;
> users.db_user =3D ;
> users.db_passwd =3D ;
>=20
> users.where_clause =3D domainusers.active =3D 1 and domains.active=3D1 an=
d
> servers.active =3D 1 and servers.server_name in ('servername','*');
>=20
> users.table =3D domainusers inner join domains on domainusers.domain_id =
=3D
> domains.domain_id inner join servers on domains.server_id =3D
> servers.server_id;
>=20
> users.user_column =3D domainusers.user_name;
> users.password_column =3D domainusers.shell_password;
> users.status_column =3D 'A';
> users.password_crypt =3D 0;
> users.use_323_password =3D false;
> users.use_md5 =3D false;
> users.update_table =3D ;
>=20
> verbose =3D 0;
>=20
>=20
> > -----Original Message-----
> > From: pam...@li... [mailto:pam-
> > mys...@li...] On Behalf Of xyon
> > Sent: Tuesday, April 03, 2007 3:44 PM
> > To: Gary W. Smith
> > Cc: pam...@li...
> > Subject: Re: [Pam-mysql-general] SELECT returned no result
> >=20
> > Hi Gary,
> >=20
> > Thank you so much for your reply.
> >=20
> > I thought I had debugging turned on with "verbose=3D1", but perhaps
> > there's even more verbose debugging available?
> >=20
> > Here is what I've extracted from /var/log/secure (I apologize for the
> > bad formatting in my previous message):
> > pam_mysql - SELECT pwd FROM users WHERE scalix =3D 'UserTestscalixTest
> > User'
> >=20
> > I didn't realize you could use a fully customized SQL statement with
> > PAM_MySQL. Would you mind sharing some of your config, please?
> >=20
> > Thank you,
> >=20
> > On Tue, 2007-04-03 at 15:17 -0700, Gary W. Smith wrote:
> > > Xyon,
> > >
> > > Try to turn on debugging for pam-mysql.  If you do that then it will
> > > put the full SQL statement executed into the security log (or
> > > /var/log/secure on Linux).  This will help see what pam-mysql is
> > > thinking.  It's possible that it's doing something completely
> > > different than what your are expecting.
> > >
> > > Personally I use a custom SQL statement with pam-mysql.
> > >
> > > Hope that helps.
> > >
> > > Gary Wayne Smith
> > >
> > > > -----Original Message-----
> > > > From: pam...@li... [mailto:pam-
> > > > mys...@li...] On Behalf Of xyon
> > > > Sent: Tuesday, April 03, 2007 2:06 PM
> > > > To: pam...@li...
> > > > Subject: [Pam-mysql-general] SELECT returned no result
> > > >
> > > > Good day to everyone,
> > > >
> > > > I am having a hard time getting pam_mysql to work with a custom
> > > > database. Here is some information:
> > > >
> > > >
> > > >                                  Code:
> > > >
> > > >         # grep -v ^# /var/opt/scalix/sx/s/sys/pam.d/ual.remote
> > > >
> > > >            auth    sufficient  /lib/security/pam_mysql.so \
> > > >                                 user=3Dscalix passwd=3Dmypass \
> > > >                           host=3D127.0.0.1 db=3Dstaging table=3Duse=
rs \
> > > >                            usercolumn=3Dscalix passwdcolumn=3Dpwd \
> > > >                                      crypt=3D0 verbose=3D1
> > > >                      auth    required    pam_deny
> > > >
> > > >                        account  required om_auth
> > > >                    password required om_auth nullok
> > > >
> > > >
> > > > /var/log/secure:
> > > >                                  Code:
> > > >
> > > >   Apr  2 17:24:45 scalix in.imap41d: pam_mysql - SELECT pwd FROM
> > users
> > > >                WHERE scalix =3D 'UserTestscalixTest User'
> > > >    Apr  2 17:24:45 scalix in.imap41d: pam_mysql - SELECT returned
> > no
> > > >                                 result.
> > > > Apr  2 17:24:45 scalix in.imap41d: pam_mysql -
> > > pam_mysql_check_passwd()
> > > >                              returning 1.
> > > >   Apr  2 17:24:45 scalix in.imap41d: pam_mysql -
> > pam_sm_authenticate()
> > > >                              returning 10.
> > > >
> > > >
> > > >
> > > >                                  Code:
> > > >
> > > > mysql> SELECT pwd FROM users WHERE scalix =3D 'UserTestscalixTest
> > > > mysql> User';
> > > >                                +------+
> > > >                                | pwd  |
> > > >                                +------+
> > > >                                | test |
> > > >                                +------+
> > > >                         1 row in set (0.00 sec)
> > > >
> > > >                                 mysql>
> > > >
> > > >
> > > >
> > > > As you can see running the query manually brings back results, but
> > > > it appears it doesn't when run from pam_mysql.
> > > >
> > > > Perhaps I have a misconfiguration in the ual.remote file? The
> > > > ual.remote file is used by Scalix to login web/imap/pop users.
> > > >
> > > > Is there a way to test pam_mysql without scalix being involved so
> I
> > > can
> > > > narrow down the culprits?
> > > >
> > > > Thanks,
> > > >
> > > > --
> > > > xyon
> > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > -
> > > -
> > > > --
> > > > "They who can give up essential liberty to obtain a little
> > temporary
> > > > safety deserve neither liberty nor safety." --Benjamin Franklin
> > > >
> > >
> ---------------------------------------------------------------------
> > -
> > > -
> > > > --
> > >
> > --
> > xyon
> >=20
> >
> -----------------------------------------------------------------------
> > --
> > "They who can give up essential liberty to obtain a little temporary
> > safety deserve neither liberty nor safety." --Benjamin Franklin
> >
> -----------------------------------------------------------------------
> > --
>=20
--=20
xyon

-------------------------------------------------------------------------
"They who can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety." --Benjamin Franklin
-------------------------------------------------------------------------

Re: [Pam-mysql-general] SELECT returned no result

[Gary W. S. <ga...@pr...>]

Hmm, I guess I didn't use the complete SQL statement.  That was
nss-mysql.  Anyway, here is my pam-mysql statement.  This may or may not
work for you.  I have to create a custom patch of either pam-mysql or
nss-mysql to use my complicated joins.  I can't remember which one off
the top of my head and the code isn't redily available where I'm at
today.  Anyway, here is the pam.d/ file and the pam-mysql.conf file
(which is loaded from the pam.d/ file).

Please note that this is from one of our dev boxes and the passwords are
in clear text

Hope this helps.

[root@ etc]# cat pam.d/pop3
#%PAM-1.0
#auth       required     /lib/security/pam_stack.so =
service=3Dsystem-auth
#account    required     /lib/security/pam_stack.so =
service=3Dsystem-auth

auth       sufficient   /lib/security/pam_mysql.so
config_file=3D/etc/pam-mysql.conf
auth       required     /lib/security/pam_stack.so service=3Dsystem-auth
account    sufficient   /lib/security/pam_mysql.so
config_file=3D/etc/pam-mysql.conf
account    required     /lib/security/pam_stack.so service=3Dsystem-auth
session    required     pam_mkhomedir.so   skel=3D/etc/skel   =
umask=3D0077

[root@ etc]# cat pam-mysql.conf=20
users.host =3D ;
users.database =3D ;
users.db_user =3D ;
users.db_passwd =3D ;

users.where_clause =3D domainusers.active =3D 1 and domains.active=3D1 =
and
servers.active =3D 1 and servers.server_name in ('servername','*');

users.table =3D domainusers inner join domains on domainusers.domain_id =
=3D
domains.domain_id inner join servers on domains.server_id =3D
servers.server_id;

users.user_column =3D domainusers.user_name;
users.password_column =3D domainusers.shell_password;
users.status_column =3D 'A';
users.password_crypt =3D 0;
users.use_323_password =3D false;
users.use_md5 =3D false;
users.update_table =3D ;

verbose =3D 0;


> -----Original Message-----
> From: pam...@li... [mailto:pam-
> mys...@li...] On Behalf Of xyon
> Sent: Tuesday, April 03, 2007 3:44 PM
> To: Gary W. Smith
> Cc: pam...@li...
> Subject: Re: [Pam-mysql-general] SELECT returned no result
>=20
> Hi Gary,
>=20
> Thank you so much for your reply.
>=20
> I thought I had debugging turned on with "verbose=3D1", but perhaps
> there's even more verbose debugging available?
>=20
> Here is what I've extracted from /var/log/secure (I apologize for the
> bad formatting in my previous message):
> pam_mysql - SELECT pwd FROM users WHERE scalix =3D 'UserTestscalixTest
> User'
>=20
> I didn't realize you could use a fully customized SQL statement with
> PAM_MySQL. Would you mind sharing some of your config, please?
>=20
> Thank you,
>=20
> On Tue, 2007-04-03 at 15:17 -0700, Gary W. Smith wrote:
> > Xyon,
> >
> > Try to turn on debugging for pam-mysql.  If you do that then it will
> > put the full SQL statement executed into the security log (or
> > /var/log/secure on Linux).  This will help see what pam-mysql is
> > thinking.  It's possible that it's doing something completely
> > different than what your are expecting.
> >
> > Personally I use a custom SQL statement with pam-mysql.
> >
> > Hope that helps.
> >
> > Gary Wayne Smith
> >
> > > -----Original Message-----
> > > From: pam...@li... [mailto:pam-
> > > mys...@li...] On Behalf Of xyon
> > > Sent: Tuesday, April 03, 2007 2:06 PM
> > > To: pam...@li...
> > > Subject: [Pam-mysql-general] SELECT returned no result
> > >
> > > Good day to everyone,
> > >
> > > I am having a hard time getting pam_mysql to work with a custom
> > > database. Here is some information:
> > >
> > >
> > >                                  Code:
> > >
> > >         # grep -v ^# /var/opt/scalix/sx/s/sys/pam.d/ual.remote
> > >
> > >            auth    sufficient  /lib/security/pam_mysql.so \
> > >                                 user=3Dscalix passwd=3Dmypass \
> > >                           host=3D127.0.0.1 db=3Dstaging =
table=3Dusers \
> > >                            usercolumn=3Dscalix passwdcolumn=3Dpwd =
\
> > >                                      crypt=3D0 verbose=3D1
> > >                      auth    required    pam_deny
> > >
> > >                        account  required om_auth
> > >                    password required om_auth nullok
> > >
> > >
> > > /var/log/secure:
> > >                                  Code:
> > >
> > >   Apr  2 17:24:45 scalix in.imap41d: pam_mysql - SELECT pwd FROM
> users
> > >                WHERE scalix =3D 'UserTestscalixTest User'
> > >    Apr  2 17:24:45 scalix in.imap41d: pam_mysql - SELECT returned
> no
> > >                                 result.
> > > Apr  2 17:24:45 scalix in.imap41d: pam_mysql -
> > pam_mysql_check_passwd()
> > >                              returning 1.
> > >   Apr  2 17:24:45 scalix in.imap41d: pam_mysql -
> pam_sm_authenticate()
> > >                              returning 10.
> > >
> > >
> > >
> > >                                  Code:
> > >
> > > mysql> SELECT pwd FROM users WHERE scalix =3D 'UserTestscalixTest
> > > mysql> User';
> > >                                +------+
> > >                                | pwd  |
> > >                                +------+
> > >                                | test |
> > >                                +------+
> > >                         1 row in set (0.00 sec)
> > >
> > >                                 mysql>
> > >
> > >
> > >
> > > As you can see running the query manually brings back results, but
> > > it appears it doesn't when run from pam_mysql.
> > >
> > > Perhaps I have a misconfiguration in the ual.remote file? The
> > > ual.remote file is used by Scalix to login web/imap/pop users.
> > >
> > > Is there a way to test pam_mysql without scalix being involved so
I
> > can
> > > narrow down the culprits?
> > >
> > > Thanks,
> > >
> > > --
> > > xyon
> > >
> > >
> >
---------------------------------------------------------------------
> -
> > -
> > > --
> > > "They who can give up essential liberty to obtain a little
> temporary
> > > safety deserve neither liberty nor safety." --Benjamin Franklin
> > >
> >
---------------------------------------------------------------------
> -
> > -
> > > --
> >
> --
> xyon
>=20
>
-----------------------------------------------------------------------
> --
> "They who can give up essential liberty to obtain a little temporary
> safety deserve neither liberty nor safety." --Benjamin Franklin
>
-----------------------------------------------------------------------
> --

Re: [Pam-mysql-general] SELECT returned no result

[xyon <xy...@in...>]

Hi Gary,

Thank you so much for your reply.

I thought I had debugging turned on with "verbose=3D1", but perhaps
there's even more verbose debugging available?

Here is what I've extracted from /var/log/secure (I apologize for the
bad formatting in my previous message):
pam_mysql - SELECT pwd FROM users WHERE scalix =3D 'UserTestscalixTest
User'

I didn't realize you could use a fully customized SQL statement with
PAM_MySQL. Would you mind sharing some of your config, please?

Thank you,

On Tue, 2007-04-03 at 15:17 -0700, Gary W. Smith wrote:
> Xyon,=20
>=20
> Try to turn on debugging for pam-mysql.  If you do that then it will put
> the full SQL statement executed into the security log (or
> /var/log/secure on Linux).  This will help see what pam-mysql is
> thinking.  It's possible that it's doing something completely different
> than what your are expecting.
>=20
> Personally I use a custom SQL statement with pam-mysql.
>=20
> Hope that helps.
>=20
> Gary Wayne Smith
>=20
> > -----Original Message-----
> > From: pam...@li... [mailto:pam-
> > mys...@li...] On Behalf Of xyon
> > Sent: Tuesday, April 03, 2007 2:06 PM
> > To: pam...@li...
> > Subject: [Pam-mysql-general] SELECT returned no result
> >=20
> > Good day to everyone,
> >=20
> > I am having a hard time getting pam_mysql to work with a custom
> > database. Here is some information:
> >=20
> >=20
> >                                  Code:
> >=20
> >         # grep -v ^# /var/opt/scalix/sx/s/sys/pam.d/ual.remote
> >=20
> >            auth    sufficient  /lib/security/pam_mysql.so \
> >                                 user=3Dscalix passwd=3Dmypass \
> >                           host=3D127.0.0.1 db=3Dstaging table=3Dusers \
> >                            usercolumn=3Dscalix passwdcolumn=3Dpwd \
> >                                      crypt=3D0 verbose=3D1
> >                      auth    required    pam_deny
> >=20
> >                        account  required om_auth
> >                    password required om_auth nullok
> >=20
> >=20
> > /var/log/secure:
> >                                  Code:
> >=20
> >   Apr  2 17:24:45 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
> >                WHERE scalix =3D 'UserTestscalixTest User'
> >    Apr  2 17:24:45 scalix in.imap41d: pam_mysql - SELECT returned no
> >                                 result.
> > Apr  2 17:24:45 scalix in.imap41d: pam_mysql -
> pam_mysql_check_passwd()
> >                              returning 1.
> >   Apr  2 17:24:45 scalix in.imap41d: pam_mysql - pam_sm_authenticate()
> >                              returning 10.
> >=20
> >=20
> >=20
> >                                  Code:
> >=20
> > mysql> SELECT pwd FROM users WHERE scalix =3D 'UserTestscalixTest User'=
;
> >                                +------+
> >                                | pwd  |
> >                                +------+
> >                                | test |
> >                                +------+
> >                         1 row in set (0.00 sec)
> >=20
> >                                 mysql>
> >=20
> >=20
> >=20
> > As you can see running the query manually brings back results, but it
> > appears it doesn't when run from pam_mysql.
> >=20
> > Perhaps I have a misconfiguration in the ual.remote file? The
> > ual.remote file is used by Scalix to login web/imap/pop users.
> >=20
> > Is there a way to test pam_mysql without scalix being involved so I
> can
> > narrow down the culprits?
> >=20
> > Thanks,
> >=20
> > --
> > xyon
> >=20
> >
> -----------------------------------------------------------------------
> > --
> > "They who can give up essential liberty to obtain a little temporary
> > safety deserve neither liberty nor safety." --Benjamin Franklin
> >
> -----------------------------------------------------------------------
> > --
>=20
--=20
xyon

-------------------------------------------------------------------------
"They who can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety." --Benjamin Franklin
-------------------------------------------------------------------------

Re: [Pam-mysql-general] SELECT returned no result

[Gary W. S. <ga...@pr...>]

Xyon,=20

Try to turn on debugging for pam-mysql.  If you do that then it will put
the full SQL statement executed into the security log (or
/var/log/secure on Linux).  This will help see what pam-mysql is
thinking.  It's possible that it's doing something completely different
than what your are expecting.

Personally I use a custom SQL statement with pam-mysql.

Hope that helps.

Gary Wayne Smith

> -----Original Message-----
> From: pam...@li... [mailto:pam-
> mys...@li...] On Behalf Of xyon
> Sent: Tuesday, April 03, 2007 2:06 PM
> To: pam...@li...
> Subject: [Pam-mysql-general] SELECT returned no result
>=20
> Good day to everyone,
>=20
> I am having a hard time getting pam_mysql to work with a custom
> database. Here is some information:
>=20
>=20
>                                  Code:
>=20
>         # grep -v ^# /var/opt/scalix/sx/s/sys/pam.d/ual.remote
>=20
>            auth    sufficient  /lib/security/pam_mysql.so \
>                                 user=3Dscalix passwd=3Dmypass \
>                           host=3D127.0.0.1 db=3Dstaging table=3Dusers =
\
>                            usercolumn=3Dscalix passwdcolumn=3Dpwd \
>                                      crypt=3D0 verbose=3D1
>                      auth    required    pam_deny
>=20
>                        account  required om_auth
>                    password required om_auth nullok
>=20
>=20
> /var/log/secure:
>                                  Code:
>=20
>   Apr  2 17:24:45 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
>                WHERE scalix =3D 'UserTestscalixTest User'
>    Apr  2 17:24:45 scalix in.imap41d: pam_mysql - SELECT returned no
>                                 result.
> Apr  2 17:24:45 scalix in.imap41d: pam_mysql -
pam_mysql_check_passwd()
>                              returning 1.
>   Apr  2 17:24:45 scalix in.imap41d: pam_mysql - pam_sm_authenticate()
>                              returning 10.
>=20
>=20
>=20
>                                  Code:
>=20
> mysql> SELECT pwd FROM users WHERE scalix =3D 'UserTestscalixTest =
User';
>                                +------+
>                                | pwd  |
>                                +------+
>                                | test |
>                                +------+
>                         1 row in set (0.00 sec)
>=20
>                                 mysql>
>=20
>=20
>=20
> As you can see running the query manually brings back results, but it
> appears it doesn't when run from pam_mysql.
>=20
> Perhaps I have a misconfiguration in the ual.remote file? The
> ual.remote file is used by Scalix to login web/imap/pop users.
>=20
> Is there a way to test pam_mysql without scalix being involved so I
can
> narrow down the culprits?
>=20
> Thanks,
>=20
> --
> xyon
>=20
>
-----------------------------------------------------------------------
> --
> "They who can give up essential liberty to obtain a little temporary
> safety deserve neither liberty nor safety." --Benjamin Franklin
>
-----------------------------------------------------------------------
> --

[Pam-mysql-general] SELECT returned no result

[xyon <xy...@in...>]

Good day to everyone,

I am having a hard time getting pam_mysql to work with a custom
database. Here is some information:


                                 Code:
                                   =20
        # grep -v ^# /var/opt/scalix/sx/s/sys/pam.d/ual.remote=20
                                   =20
           auth    sufficient  /lib/security/pam_mysql.so \=20
                                user=3Dscalix passwd=3Dmypass \=20
                          host=3D127.0.0.1 db=3Dstaging table=3Dusers \=20
                           usercolumn=3Dscalix passwdcolumn=3Dpwd \=20
                                     crypt=3D0 verbose=3D1=20
                     auth    required    pam_deny=20
                                   =20
                       account  required om_auth=20
                   password required om_auth nullok=20


/var/log/secure:=20
                                 Code:
                                   =20
  Apr  2 17:24:45 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
               WHERE scalix =3D 'UserTestscalixTest User'=20
   Apr  2 17:24:45 scalix in.imap41d: pam_mysql - SELECT returned no
                                result.=20
Apr  2 17:24:45 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
                             returning 1.=20
  Apr  2 17:24:45 scalix in.imap41d: pam_mysql - pam_sm_authenticate()
                             returning 10.=20
                                   =20


                                 Code:
                                   =20
mysql> SELECT pwd FROM users WHERE scalix =3D 'UserTestscalixTest User';=20
                               +------+=20
                               | pwd  |=20
                               +------+=20
                               | test |=20
                               +------+=20
                        1 row in set (0.00 sec)=20
                                   =20
                                mysql>=20
                                   =20


As you can see running the query manually brings back results, but it
appears it doesn't when run from pam_mysql.

Perhaps I have a misconfiguration in the ual.remote file? The ual.remote
file is used by Scalix to login web/imap/pop users.

Is there a way to test pam_mysql without scalix being involved so I can
narrow down the culprits?

Thanks,

--=20
xyon

-------------------------------------------------------------------------
"They who can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety." --Benjamin Franklin
-------------------------------------------------------------------------

[Pam-mysql-general] MD5 problem

[Tiron A. <tir...@ya...>]

Hello,=0A=0AThis is what i get when i run ./configure=0A=0Aconfigure: WARNI=
NG: md5.h: present but cannot be compiled=0Aconfigure: WARNING: md5.h:     =
check for missing prerequisite headers?=0Aconfigure: WARNING: md5.h: see th=
e Autoconf documentation=0Aconfigure: WARNING: md5.h:     section "Present =
But Cannot Be Compiled"=0Aconfigure: WARNING: md5.h: proceeding with the pr=
eprocessor's result=0Aconfigure: WARNING: md5.h: in the future, the compile=
r will take precedence=0Aconfigure: WARNING:     ## -----------------------=
------------- ##=0Aconfigure: WARNING:     ## Report this to the pam_mysql =
lists.  ##=0Aconfigure: WARNING:     ## -----------------------------------=
- ##=0Achecking for md5.h... yes=0A=0A=0AAny ideas?=0AThanks,=0AA.=0A=0A=0A=
=0A=0A =0A_________________________________________________________________=
___________________=0AAny questions? Get answers on any topic at www.Answer=
s.yahoo.com.  Try it now.

[Pam-mysql-general] (no subject)

[Tiron A. <tir...@ya...>]

Hello,=0A=0AThis is what i get when i run configure:=0A=0Aconfigure: WARNIN=
G: md5.h: present but cannot be compiled=0Aconfigure: WARNING: md5.h:     c=
heck for missing prerequisite headers?=0Aconfigure: WARNING: md5.h: see the=
 Autoconf documentation=0Aconfigure: WARNING: md5.h:     section "Present B=
ut Cannot Be Compiled"=0Aconfigure: WARNING: md5.h: proceeding with the pre=
processor's result=0Aconfigure: WARNING: md5.h: in the future, the compiler=
 will take precedence=0Aconfigure: WARNING:     ## ------------------------=
------------ ##=0Aconfigure: WARNING:     ## Report this to the pam_mysql l=
ists.  ##=0Aconfigure: WARNING:     ## ------------------------------------=
 ##=0Achecking for md5.h... yes=0A=0AAny ideas?=0A=0AThanks,=0AA.=0A=0A=0A=
=0A=0A=0A =0A______________________________________________________________=
______________________=0ADon't pick lemons.=0ASee all the new 2007 cars at =
Yahoo! Autos.=0Ahttp://autos.yahoo.com/new_cars.html 

Re: [Pam-mysql-general] pam_mysql-0.7RC1 won't build...

[<PBr...@bc...>]

Hello Anders,
   Well, it doesn't seem to.  I am really wondering if there is a
dependency package that I might be missing...
Here is the errors that I have in my log.  Any ideas??  Thanks!  I really
appreciate this!  -Cheers, Peter.

Jan 19 11:25:15 www2 vsftpd: PAM unable to
dlopen(/lib/security/pam_mysql.so)
Jan 19 11:25:15 www2 vsftpd: PAM [dlerror: /lib/security/pam_mysql.so:
undefined symbol: MD5]
Jan 19 11:25:15 www2 vsftpd: PAM adding faulty module:
/lib/security/pam_mysql.so


====================
 In specification, Murphy's
Law supersedes Ohm's Law.
       --Unknown

[Pam-mysql-general] Girls prefer real things, not toothpicks.

[Nielsen R. <Ak...@me...>]

The Most Potent Male Muscle Boosting System!

The better and most powerful product to enlarge your schlong
available on the market!

This products tested, analyzed and approved by doctors.

Order Our Product NOW! 

You can do it here: http://www.gwconline.info

P.S.: If it doesn't work for you, we garantee 100% of your money back!



-- 
gkkhjhjofnjqktkqknjlfljqjnjfjpjhkfktmiknkrjkjijqgmjoksghkikqjq
cvmbnwespqkrxmgrgdlgkjgs
     Embarrassed, Ivan gave a groan but said nothing. ' The  joyless  autumn
days came,' the visitor went on, ' the  appalling failure of my novel seemed
to have withered part of my soul. In fact I no longer had anything to do and
I only lived for my meetings with her. Then something began to happen to me.
God  knows  what it was; I  expect Stravinsky has unravelled  it long ago. I
began to  suffer  from  depression  and strange forebodings.  The  articles,
incidentally, did not stop. At first I simply laughed at them, then came the
second  stage : amazement. In literally  every line  of  those articles  one
could detect a sense of falsity, of unease, in spite of  their confident and
threatening tone. I couldn't help  feeling--and the conviction grew stronger

[Pam-mysql-general] why your prick is so small? :))

[Gaustadnes H. <Paw...@b2...>]

The Most Potent Male Muscle Boosting System!

The better and most powerful product to enlarge your schlong
available on the market!

This products tested, analyzed and approved by doctors.

Order Our Product NOW! 

You can do it here: http://xantheantoniou.info

P.S.: If it doesn't work for you, we garantee 100% of your money back!



-- 
hulnmnmmilmgljlsltjrfrjkjljpjfkjjljjlojljhkukoksfgjikmgrkskgjg
cvmbndfjkghwrglkfjggdfgr
outside had stopped did the visitor move away from Ivan and speak louder :
     'Yes, so there I stood, out in my little yard, one night in the middle
of January, wearing the same overcoat but without any buttons now  and I was
freezing with cold. Behind me the lilac bush was buried in snowdrifts, below
and in front of me were  my feebly lit  windows with  drawn blinds. I  knelt
down to the first of them and listened--a gramophone was playing in my room.
I could hear it but see nothing. After a slight pause I went out of the gate
and  into the street.  A snowstorm  was howling  along it. A  dog which  ran
between  my legs frightened  me,  and to get away from  it I crossed to  the
other side.  Cold and  fear, which had become my inseparable companions, had

Re: [Pam-mysql-general] pam_mysql-0.7RC1 won't build...

[Anders N. <an...@no...>]

Hi again.
I just made a clean build for 9.3, it's in the repositary at 
ftp://ftp.norrbring.com/pub/linux/inst-source/9.3
I can't say if works, just that it built correctly.. Unfortunately, I 
don't have the time to pull up a 9.3 system to test it, so please do 
report to me if it works (or not).. ;)

Anders.




PBr...@bc... skrev:
> Dear Anders,
>    I am running on SuSE v9.3 and I can not upgrade...
> Unfortunatly your source rpm runs into the same errors I have had compiling
> manually.
> Sorry...  -Cheers, Peter.
>
>
> ====================
>  In specification, Murphy's
> Law supersedes Ohm's Law.
>        --Unknown
>
>
>
>                                                                            
>              Anders Norrbring                                              
>              <anders@norrbring                                             
>              .se>                                                       To 
>                                        PBr...@bc...,           
>              07.01.2007 14:57          pam...@li...urceforge 
>                                        .net                                
>                                                                         cc 
>                                                                            
>                                                                    Subject 
>                                        Re: [Pam-mysql-general]             
>                                        pam_mysql-0.7RC1 won't build...     
>                                                                            
>                                                                            
>                                                                            
>                                                                            
>                                                                            
>                                                                            
>
>
>
>
> Hiya.
> You can try my src rpm
> (ftp://ftp.norrbring.com/pub/linux/inst-source/10.1/src) and use the
> build script from openSUSE
> (
> http://software.opensuse.org/download/home:/lnussel/SUSE_Factory/repodata/repoview/build-0-0.0_SVNr930M-2.1.html
> )
>
> Those would make a successful build.. ;)
>
> Anders.
>
>
> PBr...@bc... wrote:
>   
>> Dear list members,
>>    Hello...  I have a question that I just can not figure out...  if you
>> could provide a bit of assistance, it would be greatly appreciated!
>>
>> I am attempting to build pam_mysql-0.7RC1 on a SuSE v9.3 box... but I can
>> not get it to complete the configure script.
>> I keep getting the following...
>>
>> -- SNIP --
>> checking pam_appl.h usability... no
>> checking pam_appl.h presence... yes
>> configure: WARNING: pam_appl.h: present but cannot be compiled
>> configure: WARNING: pam_appl.h:     check for missing prerequisite
>>     
> headers?
>   
>> configure: WARNING: pam_appl.h: see the Autoconf documentation
>> configure: WARNING: pam_appl.h:     section "Present But Cannot Be
>> Compiled"
>> configure: WARNING: pam_appl.h: proceeding with the preprocessor's result
>> configure: WARNING: pam_appl.h: in the future, the compiler will take
>> precedence
>> configure: WARNING:     ## ------------------------------------ ##
>> configure: WARNING:     ## Report this to the pam_mysql lists.  ##
>> configure: WARNING:     ## ------------------------------------ ##
>> checking for pam_appl.h... yes
>> checking pam_modules.h usability... no
>> configure: error: Cannot find pam headers. Please check if your system is
>> ready for pam module development.
>> -- /SNIP --
>>
>> I have pam-dev, mysql-dev, mysql-shared-compat, and zlib-dev installed.
>> The pam_modules.h and pam_appl.h files do exist in
>>     
> /usr/include/security...
>   
>> Any thoughts??
>>
>>  Thanks! -Cheers, Peter.
>>
>>
>> ====================
>>  In specification, Murphy's
>> Law supersedes Ohm's Law.
>>        --Unknown
>>
>>
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>>     
> your
>   
>> opinions on IT & business topics through brief surveys - and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Pam-mysql-general mailing list
>> Pam...@li...
>> https://lists.sourceforge.net/lists/listinfo/pam-mysql-general
>>
>>     

[Pam-mysql-general] We can double your sausage size.

[Ceylan C. <Ki...@de...>]

Hei dude

Don't tell me why your weenie is so small,
I will better help you to make it really Bigger!

Why bigger? Because over 72% of all women need a longer
meat to satisfy their desire!

Go there and get your solution: http://www.persinons.info

It'll really help you!

We will ship it worldwide within 24 hours, and if
you find our product useless - we'll refund all your money!



-- 
jjfigkgnkqgpfgfpfqgmkggpgqggtkuititurjtotuujuruppjuntppitftptj
cvmbnwespqkrxmgrgdlgkjgs
     'Sshh! ' whispered  the man.  He bounded  out  on to the  balcony and
closed the grille behind him.
     Praskovya  Fyodorovna looked in, asked Ivan how he felt and  whether he
wanted  to sleep in the dark or the light. Ivan asked her to leave the light
on and Praskovya Fyodorovna departed, wishing him good  night. When  all was
quiet again the visitor returned.
     He told  Ivan in a whisper that a new  patient had been  put  into  No.
119--a fat man  with a purple  face who kept muttering about  dollars in the
ventilation shaft and  swearing  that the  powers of darkness had taken over
their house on Sadovaya. ' He curses Pushkin for all  he's  worth and  keeps

[Pam-mysql-general] Never thought that so small woody exists.

[Lewis A. <Nik...@je...>]

Salute sir

Don't tell me why your thing is so small,
I will better help you to make it really Bigger!

Why bigger? Because over 87% of all women need a longer
prick to satisfy their desire!

Go there and get your solution: http://www.ticketsforsports.info

It'll really help you!

We will ship it worldwide within 24 hours, and if
you find our product useless - we'll refund all your money!



-- 
qruqtstfpithtothtiuuqouhuiuoustququmsrugumtrsjshnrsfrhnqrnrhsr
cvmbndfjkghwrglkfjggdfgr
the flies rose with a buzz and the  victim's face was revealed, swollen with
bites, puff-eyed, unrecognisable.
     Forcing open his eyelids, Ha-Notsri looked down. His usually clear eyes
were now dim and glazed.
     'Ha-Notsri!' said the executioner.
     Ha-Notsri moved his swollen lips and answered in a hoarse croak:
     'What do you want? Why have you come? '
     'Drink! ' said the executioner and a water-soaked sponge was raised to
Yeshua's lips on the point of a lance. Joy lit up his eyes, he put his mouth
to the sponge and greedily sucked its moisture.  From  the next  gibbet came

Re: [Pam-mysql-general] pam_mysql-0.7RC1 won't build...

[<PBr...@bc...>]

:-)
   Thank you!

 -Cheers, Peter.


====================
 In specification, Murphy's
Law supersedes Ohm's Law.
       --Unknown



                                                                           
             Anders Norrbring                                              
             <anders@norrbring                                             
             .se>                                                       To 
             Sent by:                  pam...@li...urceforge 
             pam-mysql-general         .net                                
             -bo...@li...                                          cc 
             urceforge.net                                                 
                                                                   Subject 
                                       Re: [Pam-mysql-general]             
             14.01.2007 03:07          pam_mysql-0.7RC1 won't build...     
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




I'll take a look at it within the next couple of days.. I'm sure it'll
build, but maybe I need to edit the spec file a little. I'll let you know!

Anders.



PBr...@bc... skrev:
> Dear Anders,
>    I am running on SuSE v9.3 and I can not upgrade...
> Unfortunatly your source rpm runs into the same errors I have had
compiling
> manually.
> Sorry...  -Cheers, Peter.
>
>
> ====================
>  In specification, Murphy's
> Law supersedes Ohm's Law.
>        --Unknown
>
>
>
>

>              Anders Norrbring

>              <anders@norrbring

>              .se>
To
>                                        PBr...@bc...,

>              07.01.2007 14:57
pam...@li...urceforge
>                                        .net

>
cc
>

>
Subject
>                                        Re: [Pam-mysql-general]

>                                        pam_mysql-0.7RC1 won't build...

>

>

>

>

>

>

>
>
>
>
> Hiya.
> You can try my src rpm
> (ftp://ftp.norrbring.com/pub/linux/inst-source/10.1/src) and use the
> build script from openSUSE
> (
>
http://software.opensuse.org/download/home:/lnussel/SUSE_Factory/repodata/repoview/build-0-0.0_SVNr930M-2.1.html

> )
>
> Those would make a successful build.. ;)
>
> Anders.
>
>
> PBr...@bc... wrote:
>
>> Dear list members,
>>    Hello...  I have a question that I just can not figure out...  if you
>> could provide a bit of assistance, it would be greatly appreciated!
>>
>> I am attempting to build pam_mysql-0.7RC1 on a SuSE v9.3 box... but I
can
>> not get it to complete the configure script.
>> I keep getting the following...
>>
>> -- SNIP --
>> checking pam_appl.h usability... no
>> checking pam_appl.h presence... yes
>> configure: WARNING: pam_appl.h: present but cannot be compiled
>> configure: WARNING: pam_appl.h:     check for missing prerequisite
>>
> headers?
>
>> configure: WARNING: pam_appl.h: see the Autoconf documentation
>> configure: WARNING: pam_appl.h:     section "Present But Cannot Be
>> Compiled"
>> configure: WARNING: pam_appl.h: proceeding with the preprocessor's
result
>> configure: WARNING: pam_appl.h: in the future, the compiler will take
>> precedence
>> configure: WARNING:     ## ------------------------------------ ##
>> configure: WARNING:     ## Report this to the pam_mysql lists.  ##
>> configure: WARNING:     ## ------------------------------------ ##
>> checking for pam_appl.h... yes
>> checking pam_modules.h usability... no
>> configure: error: Cannot find pam headers. Please check if your system
is
>> ready for pam module development.
>> -- /SNIP --
>>
>> I have pam-dev, mysql-dev, mysql-shared-compat, and zlib-dev installed.
>> The pam_modules.h and pam_appl.h files do exist in
>>
> /usr/include/security...
>
>> Any thoughts??
>>
>>  Thanks! -Cheers, Peter.
>>
>>
>> ====================
>>  In specification, Murphy's
>> Law supersedes Ohm's Law.
>>        --Unknown
>>
>>
>>
>>
-------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>>
> your
>
>> opinions on IT & business topics through brief surveys - and earn cash
>>
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Pam-mysql-general mailing list
>> Pam...@li...
>> https://lists.sourceforge.net/lists/listinfo/pam-mysql-general
>>
>>
(See attached file: smime.p7s)
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Pam-mysql-general mailing list
Pam...@li...
https://lists.sourceforge.net/lists/listinfo/pam-mysql-general

Re: [Pam-mysql-general] pam_mysql-0.7RC1 won't build...

[Anders N. <an...@no...>]

I'll take a look at it within the next couple of days.. I'm sure it'll 
build, but maybe I need to edit the spec file a little. I'll let you know!

Anders.



PBr...@bc... skrev:
> Dear Anders,
>    I am running on SuSE v9.3 and I can not upgrade...
> Unfortunatly your source rpm runs into the same errors I have had compiling
> manually.
> Sorry...  -Cheers, Peter.
>
>
> ====================
>  In specification, Murphy's
> Law supersedes Ohm's Law.
>        --Unknown
>
>
>
>                                                                            
>              Anders Norrbring                                              
>              <anders@norrbring                                             
>              .se>                                                       To 
>                                        PBr...@bc...,           
>              07.01.2007 14:57          pam...@li...urceforge 
>                                        .net                                
>                                                                         cc 
>                                                                            
>                                                                    Subject 
>                                        Re: [Pam-mysql-general]             
>                                        pam_mysql-0.7RC1 won't build...     
>                                                                            
>                                                                            
>                                                                            
>                                                                            
>                                                                            
>                                                                            
>
>
>
>
> Hiya.
> You can try my src rpm
> (ftp://ftp.norrbring.com/pub/linux/inst-source/10.1/src) and use the
> build script from openSUSE
> (
> http://software.opensuse.org/download/home:/lnussel/SUSE_Factory/repodata/repoview/build-0-0.0_SVNr930M-2.1.html
> )
>
> Those would make a successful build.. ;)
>
> Anders.
>
>
> PBr...@bc... wrote:
>   
>> Dear list members,
>>    Hello...  I have a question that I just can not figure out...  if you
>> could provide a bit of assistance, it would be greatly appreciated!
>>
>> I am attempting to build pam_mysql-0.7RC1 on a SuSE v9.3 box... but I can
>> not get it to complete the configure script.
>> I keep getting the following...
>>
>> -- SNIP --
>> checking pam_appl.h usability... no
>> checking pam_appl.h presence... yes
>> configure: WARNING: pam_appl.h: present but cannot be compiled
>> configure: WARNING: pam_appl.h:     check for missing prerequisite
>>     
> headers?
>   
>> configure: WARNING: pam_appl.h: see the Autoconf documentation
>> configure: WARNING: pam_appl.h:     section "Present But Cannot Be
>> Compiled"
>> configure: WARNING: pam_appl.h: proceeding with the preprocessor's result
>> configure: WARNING: pam_appl.h: in the future, the compiler will take
>> precedence
>> configure: WARNING:     ## ------------------------------------ ##
>> configure: WARNING:     ## Report this to the pam_mysql lists.  ##
>> configure: WARNING:     ## ------------------------------------ ##
>> checking for pam_appl.h... yes
>> checking pam_modules.h usability... no
>> configure: error: Cannot find pam headers. Please check if your system is
>> ready for pam module development.
>> -- /SNIP --
>>
>> I have pam-dev, mysql-dev, mysql-shared-compat, and zlib-dev installed.
>> The pam_modules.h and pam_appl.h files do exist in
>>     
> /usr/include/security...
>   
>> Any thoughts??
>>
>>  Thanks! -Cheers, Peter.
>>
>>
>> ====================
>>  In specification, Murphy's
>> Law supersedes Ohm's Law.
>>        --Unknown
>>
>>
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>>     
> your
>   
>> opinions on IT & business topics through brief surveys - and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Pam-mysql-general mailing list
>> Pam...@li...
>> https://lists.sourceforge.net/lists/listinfo/pam-mysql-general
>>
>>     

[Pam-mysql-general] Hurry do not let yourself to miss this incredible offer.

[Nasdaq.com A. <imm...@xt...>]

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML><HEAD><TITLE>This is your big opportunity to double your investment for short period.</TITLE>
</HEAD>
<BODY>

<html>
<head>
Following a meetingAbout three million have fled their homes. Sudan has always rejected plans to replace the AU force with a larger, stronger UN mission. On Thursday, UN chief Kofi Annan had said a compromise had been reached for a hybrid UN-AU force, to break the deadlock over the Darfur mission. More than 200,000 people have died in three years of conflict in the region. His Foreign Minister Lam Akol specified that "there should be no talk about a mixed force". <br>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
style5 {
	color: #0000FF;
	font-weight: bold;
}
body {
	background-color: #FFFFCC;
}
style8 {color: #000000}
style9 {color: #0000FF}
style14 {color: #FFFF00}
style19 {color: #000000; font-weight: bold; }
style21 {color: #FFFFFF}
style23 {color: #0000FF; font-size: medium; }
-->
</style>
</head>

<body>
<table width="486" border="2" align="center" cellspacing="10" bordercolor="#000000">
  <tr>
    <td width="458" bordercolor="#0000FF" bgcolor="#FFFF00"><div align="center" class="style5 style8"><tt>THE MOST UNBELIEVABLE STOCKS THAT YOU CAN BUY RIGHT NOW!!!

    </tt></div></td>
  </tr>
  <tr>
    <td bordercolor="#0000FF" bgcolor="#00FF00"><div align="center" class="style5 style8"> 
      <p><tt><span class="style9">MARSHALL HOLDINGS INTERNATIONAL INC(MHII.OB)</span> SAFETY IS GUARANTEED.</tt></p>
    </div></td>
  </tr>
  <tr>
    <td bordercolor="#0000FF" bgcolor="#FFFF00"><div align="center" class="style8"><tt><strong>YOU CAN EARN A LOT OF MONEY JUST MAKE YOUR BROKERS GRAB THIS INCREDIBLESTOCK.

    </strong></tt></div></td>
  </tr>
  <tr>
    <td bordercolor="#0000FF" bgcolor="#FF0000"><div align="center" class="style8"> 
      <p><strong> <tt>IT IS ON <span class="style14">FIRE</span>!!! HURRY UP <span class="style14">TERRIFIC</span> GROWTH WILL BE ON <span class="style21">ON TUESDAY 16 JANUARY!!!</span> </tt></strong></p>
    </div></td>
  </tr>
  <tr>
    <td bordercolor="#0000FF" bgcolor="#00FF00"><div align="center" class="style19"><tt> FIND OUT DETAIL NEWS ABOUT THIS STOCK AT OUR WEB-SITE. </tt></div></td>
  </tr>
    <tr>
    <td bordercolor="#0000FF" bgcolor="#00FF00"><div align="center" class="style19"><tt> THE NEXT PRICES ARE: JAN 8=0.01$ AND CURRENT JAN 12=0.04$<br>!!!
MORE THAN <span class="style14">40%</span> EVERY DAY!!! <u><span class="style23">ON TUESDAY 16 JANUARY</span></u> IT WILL <span class="style23">0.17$</span>!!!
 </tt></div></td>
  </tr>

    <tr>
    <td bordercolor="#0000FF" bgcolor="#FF0000"><div align="center" class="style19"><tt> JUST <span class="style14">GET</span> IT AND YOU WILL NEVER SORRY ABOUT IT. </tt></div></td>
  </tr>
</table>

</body>
He told the BBC there would be no UN troops. About three million have fled their homes. Chad in anti-Sudan alliance  Following a meeting<br>
</html>


</BODY></HTML>

Re: [Pam-mysql-general] pam_mysql-0.7RC1 won't build...

[<PBr...@bc...>]

Dear Anders,
   I am running on SuSE v9.3 and I can not upgrade...
Unfortunatly your source rpm runs into the same errors I have had compiling
manually.
Sorry...  -Cheers, Peter.


====================
 In specification, Murphy's
Law supersedes Ohm's Law.
       --Unknown



                                                                           
             Anders Norrbring                                              
             <anders@norrbring                                             
             .se>                                                       To 
                                       PBr...@bc...,           
             07.01.2007 14:57          pam...@li...urceforge 
                                       .net                                
                                                                        cc 
                                                                           
                                                                   Subject 
                                       Re: [Pam-mysql-general]             
                                       pam_mysql-0.7RC1 won't build...     
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




Hiya.
You can try my src rpm
(ftp://ftp.norrbring.com/pub/linux/inst-source/10.1/src) and use the
build script from openSUSE
(
http://software.opensuse.org/download/home:/lnussel/SUSE_Factory/repodata/repoview/build-0-0.0_SVNr930M-2.1.html
)

Those would make a successful build.. ;)

Anders.


PBr...@bc... wrote:
> Dear list members,
>    Hello...  I have a question that I just can not figure out...  if you
> could provide a bit of assistance, it would be greatly appreciated!
>
> I am attempting to build pam_mysql-0.7RC1 on a SuSE v9.3 box... but I can
> not get it to complete the configure script.
> I keep getting the following...
>
> -- SNIP --
> checking pam_appl.h usability... no
> checking pam_appl.h presence... yes
> configure: WARNING: pam_appl.h: present but cannot be compiled
> configure: WARNING: pam_appl.h:     check for missing prerequisite
headers?
> configure: WARNING: pam_appl.h: see the Autoconf documentation
> configure: WARNING: pam_appl.h:     section "Present But Cannot Be
> Compiled"
> configure: WARNING: pam_appl.h: proceeding with the preprocessor's result
> configure: WARNING: pam_appl.h: in the future, the compiler will take
> precedence
> configure: WARNING:     ## ------------------------------------ ##
> configure: WARNING:     ## Report this to the pam_mysql lists.  ##
> configure: WARNING:     ## ------------------------------------ ##
> checking for pam_appl.h... yes
> checking pam_modules.h usability... no
> configure: error: Cannot find pam headers. Please check if your system is
> ready for pam module development.
> -- /SNIP --
>
> I have pam-dev, mysql-dev, mysql-shared-compat, and zlib-dev installed.
> The pam_modules.h and pam_appl.h files do exist in
/usr/include/security...
>
> Any thoughts??
>
>  Thanks! -Cheers, Peter.
>
>
> ====================
>  In specification, Murphy's
> Law supersedes Ohm's Law.
>        --Unknown
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Pam-mysql-general mailing list
> Pam...@li...
> https://lists.sourceforge.net/lists/listinfo/pam-mysql-general
>


--

Anders Norrbring
Norrbring Consulting

[Pam-mysql-general] Hei, Smallest meat of the year, how are you? :-)

[Laeremans P. <St...@aq...>]

YO buddy

I don't care why your member is so small, but 80% of women do.
They are pretty sure that bigger Johnson will make their desire
stronger. You have the chance to change your life.

Here http://www.dorothyshepherd.com you can get the thing.

It will help you for sure.
The remedy can be sent worldwide.
If you wont be satisfied - we will return all you money.
No bullshit.



-- 
runnonomslognjnsntlrhrlklllplfmjllljjolllhmumomshglimmirmsmglg
weiuvbmdngsdfwelkgjhhpjw
sweet and fresh after the storm.
     The  asylum was asleep. The white  frosted-glass  bulbs in  the  silent
corridors  were extinguished  and  in  their  place  glowed  the  weak  blue
night-lights. The  nurses'  cautious  footsteps  were  heard  less and  less
frequently walking the rubber-tiled floor of the corridor.
     Ivan now lay in sweet lassitude ; glancing at his bedside lamp, then at
the dim  ceiling  light and at the moon rising in the  dark,  he  talked  to
himself.
     'I wonder why I got so excited about Berlioz  falling under that tram?
'  the poet reasoned.  ' After all he's dead, and we all die some time. It's