php-windows Digest 4 Oct 2003 09:24:42 -0000 Issue 1940
Topics (messages 21672 through 21673):
MySQL security hole - how to fix??
21672 by: Roderick Martin
Re: Mysql Purge script
21673 by: Svensson, B.A.T. (HKG)
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
According to this article, there is a major security leak in all
versions of MySQL...
http://www.eweek.com/article2/0,4149,1306270,00.asp
The article provides a link to a patch, but I find two things
confusing...
1. All the patches on that page are ancient. Why wouldn't these patches
have been incorporated into MySQL by now, or is the article incorrect.
2. I can't tell which of the patches I need to fix MySQL running on
Windows 2000 under IIS.
Can someone more knowledgeable than I shed some light on these?
Thanks!
--- End Message ---
--- Begin Message ---
Reference for what?
-----Original Message-----
From: Ryan Vesely
To: Svensson, B.A.T. (HKG); ''[EMAIL PROTECTED] ' '
Sent: 10/3/2003 7:07 PM
Subject: RE: [PHP-WIN] Mysql Purge script
just one way to create record created. not really relevant
to the delete statement, other than for reference.
----------------------------------------------------------------
Ryan Vesely
Sales Engineer
Pinnacor
685 Market Street, Suite 500
San Francisco, CA 94105
tel 415.369.4762
fax 415.512.2085
www.pinnacor.com <http://www.pinnacor.com/>
The preceding e-mail message contains privileged, confidential
information.
Intended conveyance is only to designated and named recipient(s). If you
feel that you may have received this message in error or if you are not
the
named recipient, please notify Pinnacor at once at the sender's email
address, or call 212.691.7900. Unauthorized use, dissemination,
distribution
or reproduction of this message is strictly prohibited and may be
unlawful.
-----Original Message-----
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 9:57 AM
To: ''[EMAIL PROTECTED] ' '
Subject: RE: [PHP-WIN] Mysql Purge script
As well as it assumes that a delete trigger takes care of
any dependent existences with other rows in other tables.
Secondly, what is the purpose of all assignments below?
-----Original Message-----
From: Ryan Vesely
To: 'Php2tor '; '[EMAIL PROTECTED] '
Sent: 3-10-2003 18:35
Subject: RE: [PHP-WIN] Mysql Purge script
This assumes one of the columns on your DB is RecordCreated:
$today = getdate();
$year = $today['year'];
$month = $today['mon'];
$day = $today['mday'];
$hours = $today['hours'];
$minutes = $today['minutes'];
$seconds = $today['seconds'];
$RecordCreated = $year."-".$month."-".$day."
".$hours.":".$minutes.":".$seconds;
$delete_query = "DELETE from $table1 where (TO_DAYS(Now()) -
TO_DAYS(RecordCreated) >= 30));";
$execute_delete = mysql_query($delete_query) or die ("delete failed");
----------------------------------------------------------------
Ryan Vesely
Sales Engineer
Pinnacor
685 Market Street, Suite 500
San Francisco, CA 94105
tel 415.369.4762
fax 415.512.2085
www.pinnacor.com <http://www.pinnacor.com/>
The preceding e-mail message contains privileged, confidential
information.
Intended conveyance is only to designated and named recipient(s). If you
feel that you may have received this message in error or if you are not
the
named recipient, please notify Pinnacor at once at the sender's email
address, or call 212.691.7900. Unauthorized use, dissemination,
distribution
or reproduction of this message is strictly prohibited and may be
unlawful.
-----Original Message-----
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 9:27 AM
To: 'Php2tor '; '[EMAIL PROTECTED] '
Subject: RE: [PHP-WIN] Mysql Purge script
DELETE FROM <table(s)>
WHERE <some-date-attribute-converted-to-days> > <than-30-days>
-----Original Message-----
From: Php2tor
To: [EMAIL PROTECTED]
Sent: 3-10-2003 18:15
Subject: [PHP-WIN] Mysql Purge script
Does anyone have a script that will purge a MySQL DB that
has entries over 30 days old?
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
