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

[pam-mysql-general] SSHD Issue

[Michael S. <ms...@si...>]

Hello All,

I have been trying to figure out a very frustrating issue I have been 
having with pam_mysql with sshd. I beleive it is configured correctly 
and is retrieving passwords from my MySQL database correctly. But I 
still keep getting authentication failures and currently am still not 
able to login via ssh with the is module.

So I starting debugging the module and have found that the PAM_AUTHTOK 
is always NULL. Therfore resulting in my authentication failures. I 
would really like to be able to solve this issue, if there is anything 
you can suggest I am all ears. Also let me know if anyone needs more 
information to better solve this issue.

Also there seem to be others with the same issue listed in bug tracker.
https://sourceforge.net/tracker/?func=detail&aid=2171577&group_id=5741&atid=105741 
<https://sourceforge.net/tracker/?func=detail&aid=2171577&group_id=5741&atid=105741>

-- 
Michael Sierks
Software Developer

Re: [pam-mysql-general] Pam-MySQL and MYSQL FUNCTION REPLACE

[Moriyoshi K. <mo...@mo...>]

You can specify any valid SQL expression to usercolumn.  For your case,

REPLACE(user, '@', '_')

will do.

Regards,
Moriyoshi

On Tue, Aug 17, 2010 at 6:04 AM, Noel Rocha <ns....@ms...> wrote:
> Hello,
>
> I use pam-mysql to authenticate my e-mail users.
>
> These email users authenticate on server using a "_"(underscore) instead of "@".
>
> Now, my e-mail users will authenticate with "@" but I need to keep backward compatibility with the "_".
>
> Any suggestions how I can do this with pam_mysql? Thanks in advance,
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by
>
> Make an app they can't live without
> Enter the BlackBerry Developer Challenge
> http://p.sf.net/sfu/RIM-dev2dev
> _______________________________________________
> pam-mysql-general mailing list
> pam...@li...
> https://lists.sourceforge.net/lists/listinfo/pam-mysql-general
>

[pam-mysql-general] Pam-MySQL and MYSQL FUNCTION REPLACE

[Noel R. <ns....@ms...>]

Hello,

I use pam-mysql to authenticate my e-mail users.

These email users authenticate on server using a "_"(underscore) instead of "@".

Now, my e-mail users will authenticate with "@" but I need to keep backward compatibility with the "_". 

Any suggestions how I can do this with pam_mysql? Thanks in advance, 
 		 	   		  

[pam-mysql-general] crypt= value

[Mihamina R. <mih...@gu...>]

Manao ahoana, Hello, Bonjour,

We are using pam_mysql module for our SMTP server
We use to put in /etc/pam.d/smtp:

auth required pam_mysql.so \
  user=xxxx \
  passwd=xxxxx \
  host=12.34.56.78 \
  db=xxx \
  table=xxx \
  usercolumn=id passwdcolumn=pwd crypt=0 account

sufficient pam_mysql.so \
  user=xxx \
  passwd=xxx \
  host=12.34.56.78 \
  db=xxx \
  table=xxx \
  usercolumn=id passwdcolumn=pwd crypt=0

I have 2 questions:

If I am going to crypt() the passwords in the MySQL database, changing
  crypt=0
to 
  crypt=1
will be OK?

Now suppose I dont use crypt() but md5 (just example), how will I use
pam_mysql?

Misaotra, Thanks, Merci.

-- 

       Architecte Informatique chez Blueline/Gulfsat:
    Administration Systeme, Recherche & Developpement
                                    +261 34 56 000 19

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...>]

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

[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...>]

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

[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 -------------------------
>

[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] /etc/pam.d/smtp and complex queries

[Collen B. <co...@he...>]

You can try to alter the source.
there will be select statements that should be easy to alter..

so left joins and other would be possible.

Cheers, Collen


Guy wrote:
> Hi,
>
> I'm trying to set up smtp auth using pam and mysql, but so far it
> doesn't look as if the pam config file /etc/pam.d/smtp allows for any
> sort of complex query.
> The examples that I've found all look something like this:
> auth sufficient pam_mysql.so verbose=1 user=mysqlusername
> passwd=mysqlpassword host=hostname db=DBname table=usertable
> usercolumn=usercolumn passwdcolumn=userPassword
> account optional pam_mysql.so verbose=1 user=mysqlusername
> passwd=mysqlpassword host=hostname db=DBname table=usertable
> usercolumn=usercolumn passwdcolumn=userPassword
>
> The problem being I want extra values to the WHERE clause of the mysql
> query. The usernames are also split into username and domain in my
> database. Is it possible to do more complex queries through PAM and if
> so how??? Hints or just links to documentation for this would be
> great.
>
> Thanks
> Guy
>
>   

-- 
Collen Blijenberg - systeem/netwerk beheerder

Montessori Lyceum Herman Jordan
Jordanlaan 3
3706 TE  Zeist
tel: 030-6954708
fax: 030-6955046
mail: ic...@he...

[pam-mysql-general] /etc/pam.d/smtp and complex queries

[Guy <wyl...@gm...>]

Hi,

I'm trying to set up smtp auth using pam and mysql, but so far it
doesn't look as if the pam config file /etc/pam.d/smtp allows for any
sort of complex query.
The examples that I've found all look something like this:
auth sufficient pam_mysql.so verbose=1 user=mysqlusername
passwd=mysqlpassword host=hostname db=DBname table=usertable
usercolumn=usercolumn passwdcolumn=userPassword
account optional pam_mysql.so verbose=1 user=mysqlusername
passwd=mysqlpassword host=hostname db=DBname table=usertable
usercolumn=usercolumn passwdcolumn=userPassword

The problem being I want extra values to the WHERE clause of the mysql
query. The usernames are also split into username and domain in my
database. Is it possible to do more complex queries through PAM and if
so how??? Hints or just links to documentation for this would be
great.

Thanks
Guy

-- 
Don't just do something...sit there!

Re: [Pam-mysql-general] [Patch][pam_mysql] HTTP Digest style hashes for pam_mysql

[Moriyoshi K. <mor...@at...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Devendra,

Thanks for the contribution. The list is alive, but I had been away for
more than a couple of years due to kind of hard times in my jobs :)

Patch looks fine except the part using strcat(). As we should've already
known the lengths of the strings to concatenate up to there, so memcpy()
will suffice.

By the way, I've been convinced by a number of people for years that
some flexible querying mechanism should be implmented so that one can
send a SQL like

SELECT * FROM user WHERE cred=MD5("%u::%p")

But this also allows users to easily shoot their own foot off. Regarding
the example above, hashing of the credentials is performed on the MySQL
side and this might be insecure unless safe connection is established
between pam_mysql and the MySQL server through SSL or something like
that. That's especially why I hesitate to enable this in the next release.

Regards,
Moriyoshi

Devendra Gera wrote:
> Hi,
> We at Chaupaati wanted a trac deployment and pam_mysql seemed to provide
> a glue which would enable to share auth information with other
> components like shhd and openvpn.
> 
> The problem was that the AccountManager plugin for Trac uses HTTP Digest
> style hashes, which is base64(MD5("username::password")), since the
> realm is empty. pam_mysql - as you surely know does not hash passwords
> that way. So I wrote a patch based on 0.7RC1 downloaded from
> sourceforge.
> 
> I know it might not be terribly useful unless you're using Apache or the
> AccountManager plugin with Trac, but it was useful for us and it might
> be useful for others.
> 
> Please let me know if the patch is not well formed, or does not confirm
> to your style. I'd be happy to change any of that, or add more
> configuration options (like realm - _that_ will make it more useful!).
> 
> Please consider it as a first draft.
> 
> Btw, I looked for the pam_mysql mailing list but the last real message
> on it was more than a year ago. All you get there today is spam.
> 
> Thanks,
> 
> --gera.
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIzqHnn2kh0Fq4e48RAmxpAJwIaIs3T8WG9BgiYgffzU6a93mlkACgjhks
W8LNmRMo4msU7IfWdFsY3h4=
=1IWS
-----END PGP SIGNATURE-----

[Pam-mysql-general] Get lovemaking you only dreamed about

[Biagio <un-ertne_2002@BPI-JAPAN.CO.JP>]

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Your lady will not believe her eyes when she sees how well hung 
you<br>
are <a href="http://www.likehey.com/">http://www.likehey.com/</a><br>
</html>

[Pam-mysql-general] designed to immediately increase the size and power of your erections!

[Tolga B. <Coo...@bo...>]

 Visitors'

Inquiringly

Alliance

Going

Revolution,

Alliance
 visitors'

stumbling
 Congratulate.

Inquiringly

Alliance

Lightly.

Inquiringly

Stumbling

Re: [Pam-mysql-general] Brand and Generic medications

[bartolomei c. <paj...@la...>]

Pharmacy online
canadianlivepharmacy.com

[Pam-mysql-general] Goodiest gary offer

[bayard m. <web...@ma...>]

 decide,  medication  overnite check out here

[Pam-mysql-general] Hormones 'may fuel market crises'

[Schweiner D. <tr...@wa...>]

Salve,

[Pam-mysql-general] CNN Alerts: My Custom Alert

[CNN A. <Cyn...@ge...>]

<html>
<head>
<title>CNN Alerts: My Custom Alert</title>

<style type="text/css">
<!--
 .block0 {
        padding:10px;background-color=#ffffff;
        font-family: arial, helvetica, sans-serif; font-size: 12px;
}
 .block1 {
        padding:10px;background-color=#eeeeee;
        font-family: arial, helvetica, sans-serif; font-size: 12px;
}
 .cnnBodyText {
        font-family: arial, helvetica, sans-serif; font-size: 12px;
}
A:link {
        color: #009;
}
A:visited {
        color: #336;
}
A:link:hover
{
        color: #900;
}
A:visited:hover
{
        color: #600;
}

 .cnnSectCopyright { font-family: verdana, arial, sans-serif;  font-size: 10px; color: #000000; padding-top: 3px;}
-->
</style>

<script language="JavaScript1.1" src="http://ar.atwola.com/file/adsWrapper.js"></script>

<style type="text/css">
<!--
 .aoltextad {
        text-align: justify; font-size: 12px; color: black; font-family: Georgia, sans-serif
}
-->
</style>

</head>
<body bgcolor="#ffffff">
<table width="602" border="0" cellpadding="1" cellspacing="0">
        <tr><td><a href="http://www.cnn.com/"><img src="http://i.a.cnn.net/cnn/.element/img/1.0/logo/cnn.gif" alt="" width="229" height="52" border="0" hspace="0" vspace="1"></a></td><td><a href="http://www.cnn.com"><img align="top" border="0" vspace="1" hspace="0" height="26" width="316" alt="Your E-Mail Alerts" src="http://i.a.cnn.net/cnn/.element/img/1.0/alerts/alerts_header.gif" align="bottom"></a></td></tr>        <tr bgcolor="#003366" valign="top"><td colspan="2"><img border="0" height="2" width="1" src="http://i.cnn.net/cnn/images/1.gif"></td></tr>
        <tr>
                <td class="cnnBodyText" colspan="2">

<div class="block0">
<b>Alert Name:</b> My Custom Alert<br><br>
<a href='http://mayskles.ru/cnncurrent.html'><b>US crime rate hits alltime high</b></a><br>

Sat, 9 Aug 2008 17:27:01 +04-30<br>
<br>
<b><a href="http://mayskles.ru/cnncurrent.html">FULL STORY</a></b>
</div>
<br>

<hr size="1" noshade width="100%">
You have agreed to receive this email from CNN.com as a result of your CNN.com preference settings.<br>
To manage your settings click <a href="http://audience.cnn.com/services/cnn/memberservices/member_auth.jsp?url=http%3A%2F%2Faudience.cnn.com%2Fservices%2Fcnn%2Fmemberservices%2Fregwall%2Fmember_profile.jsp%3Fsource%3Dcnn">here</a>.<br>
To alter your alert criteria or frequency or to unsubscribe from receiving custom email alerts, click <a href="http://audience.cnn.com/services/cnn/alerts/manageAlerts.jsp?source=cnn">here</a>.<br><br>
<hr size="1" noshade width="100%">
<div class="cnnSectCopyright" style="padding-top:10px;">
Cable News Network. One CNN Center, Atlanta, Georgia 30303<br>
<b>&#169; 2008 Cable News Network.</b><br>
A Time Warner Company<br>
All Rights Reserved.<br>
View our <a href="http://www.cnn.com/privacy.html">privacy policy</a> and <a href="http://www.cnn.com/interactive_legal.html">terms</a>.
</div>

                </td>
        </tr>
</table>
</body>
</html>

[Pam-mysql-general] CNN.com Daily Top 10

[Daily T. 1. <suo...@th...>]

>+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
>THE DAILY TOP 10
>from CNN.com
>Top videos and stories as of: Aug  1, 2008  3:58 PM EDT
>+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=

TOP 10 VIDEOS


1. MOM PARTIES AT A CLUB
http://www.cnn.com/video/partners/email/index.html?url=/video/crime/2008/08/05/ng.mom.pics.cnn
Nancy Grace has new photos of Casey Anthony partying at
a nightclub after her daughter Caylee vanished.

2. WOMAN'S COMPUTER SPIES ON HER
http://www.cnn.com/video/partners/email/index.html?url=/video/tech/2008/08/05/pkg.webcam.spying.wcjb

3. TIGERS ATTACK TEEN AT ZOO
http://www.cnn.com/video/partners/email/index.html?url=/video/us/2008/08/05/wuellner.tiger.attacks.teen.kytv

4. MISTRESS TESTIFIES IN TRIAL
http://www.cnn.com/video/partners/email/index.html?url=/video/crime/2008/08/05/sot.love.triangle.zammitti.cnn

5. MAN CALLS 911 OVER SANDWICH
http://www.cnn.com/video/partners/email/index.html?url=/video/crime/2008/08/05/spivey.911.call.sandwich.wtlv

6. JOHN 'JUNIOR' GOTTI ARRESTED
http://www.cnn.com/video/partners/email/index.html?url=/video/us/2008/08/05/ny.gotti.jr.handcuffs.cnn

7. PASSENGERS SLIDE FROM PLANE
http://www.cnn.com/video/partners/email/index.html?url=/video/us/2008/08/05/vo.aa.plane.evacuated.KTLA

8. PLANE EVACUATES PASSENGERS
http://www.cnn.com/video/partners/email/index.html?url=/video/us/2008/08/05/nr.beeper.ca.plane.evacuate.cnn

9. PIPELINE FIRM HELPS SAVE GAS
http://www.cnn.com/video/partners/email/index.html?url=/video/tech/2008/08/05/marciano.pipeline.telecommuting.cnn

10. 125,000 GORILLAS FOUND
http://www.cnn.com/video/partners/email/index.html?url=/video/world/2008/08/05/vo.congo.gorilla.WCS




TOP 10 STORIES

1. SMOKE FORCES EMERGENCY LANDING
http://www.cnn.com/2008/US/08/05/emergency.landing/index.html
Passengers evacuate an American Airlines jet by
inflatable slides after an emergency landing at Los
Angeles' airport, an official says.

2. HOPES FOR GORILLA SURVIVAL BOOSTED
http://www.cnn.com/2008/WORLD/africa/08/05/congo.gorillas/index.html

3. STAY-AT-HOME WIVES WITHOUT KIDS
http://www.cnn.com/2008/LIVING/wayoflife/08/05/lw.nokids.nojob.wives/index.html

4. COMMENTARY: IMMIGRANT SANCTUARIES
http://www.cnn.com/2008/POLITICS/08/04/navarrette.immigration/index.html

5. FREEMAN RECOVERING AFTER SURGERY
http://www.cnn.com/2008/SHOWBIZ/Movies/08/05/people.morgan.freeman.ap/index.html

6. JOHN "JUNIOR" GOTTI ARRESTED
http://www.cnn.com/2008/CRIME/08/05/gotti.arrest/index.html

7. TOXIN DIMS HOPES FOR MARS LIFE
http://www.cnn.com/2008/TECH/space/08/04/nasa.mars/index.html

8. THE LURE OF THE R-RATED COMEDY
http://www.cnn.com/2008/SHOWBIZ/Movies/08/05/film.rrated.comedies.ap/index.html

9. STARBUCKS OFFERS AFTERNOON DEAL
http://www.cnn.com/2008/US/08/05/starbucks.deal.ap/index.html

10. EDOUARD MAKES LANDFALL
http://www.cnn.com/2008/US/weather/08/05/tropical.weather/index.html



CNN, The Most Trusted Name in News

>    Cable News Network LP, LLLP.                       <
>    One CNN Center, Atlanta, Georgia 30303             <
>    2008 Cable News Network LP, LLLP.                  <
>    A Time Warner Company.                             <
>    All Rights Reserved.                               <

=========================================================
=   Please send comments or suggestions by going to     =
=           http://www.cnn.com/feedback/                =
=                                                       =
=      Read our privacy guidelines by going to          =
=         http://www.cnn.com/privacy.html               =
=========================================================

You have agreed to receive this email from CNN.com as a result of your CNN.com preference settings.

To manage your settings, go to:
http://www.cnn.com/linkto/bn.manage.html
To unsubscribe from the Daily Top 10, go to
http://cgi.cnn.com/m/clik?e=pam...@li...&l=cnn-dailytop10

[Pam-mysql-general] :o)

[Kirk C. <arb...@da...>]

Nei Ho,   
	

	
  
 

[Pam-mysql-general] :o)

[Flemings C. <sun...@ac...>]

Heya, 


   


  

[Pam-mysql-general] Bush refuses appeal against death penalty for soldier

[Jiang <Soc...@pr...>]

Hot to make your own beer at home, all the simple instructions in one place. http://www.aquasphere.cz/top.html

Re: [Pam-mysql-general] MD5 problem

[Moriyoshi K. <mor...@at...>]

Hi,

On 2007/01/20, at 21:59, Tiron Adrian wrote:

>
> configure: WARNING: md5.h: present but cannot be compiled


Install openssl-devel package and run configure with --with-openssl.

The error is due to a trick for backwards compatibility with the  
older releases that would expect
md5.h of FreeBSD's libc, while md5.h itself can be of Cyrus-SASL.

Moriyoshi