|
Home > Archive > IIS Server > June 2005 > IIS ODBC logging to MySQL??
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
IIS ODBC logging to MySQL??
|
|
| [SteelValor] 2005-06-28, 7:50 am |
| Is this possible or is MS only support MsSQL or Access? I want to move all my
..logs to a database server so I can cut down on storage, run queries for my
own log parser and increase security. Any info will help. I've don't have
access to the help files since this is a production server and run PRO on my
workstation which doesn't support ODBC logs.
Thanks in advance
| |
| Mark [exmsft] 2005-06-28, 5:54 pm |
| "[SteelValor]" <SteelValor@discussions.microsoft.com> wrote in message
news:57BC9CE3-5148-4303-BA80-79628F4BC57F@microsoft.com...
> Is this possible or is MS only support MsSQL or Access? I want to move all
> my
> .logs to a database server so I can cut down on storage, run queries for
> my
> own log parser and increase security. Any info will help. I've don't have
> access to the help files since this is a production server and run PRO on
> my
> workstation which doesn't support ODBC logs.
I don't have a direct answer, but you can find a full copy of the IIS 6
documentation online at
http://www.microsoft.com/technet/pr...81dd09b015.mspx
I'd be willing to bet, however, that as long as you can install a good ODBC
driver for mysql and can use the .sql scripts that come with IIS to create
the necessary tables on/in your mysql server/database, that IIS will be able
to log directly to MySQL.
Thanks,
Mark
| |
| Kristofer Gafvert [MVP] 2005-06-28, 5:54 pm |
| Hello,
MySQL provides support for ODBC, so i suppose it will work
http://dev.mysql.com/doc/mysql/en/odbc-connector.html
http://www.microsoft.com/technet/pr...682dae3264.mspx
--
Regards,
Kristofer Gafvert (IIS MVP)
www.gafvert.info - My Articles and help
www.ilopia.com
[SteelValor] wrote:
> Is this possible or is MS only support MsSQL or Access? I want to move
all my
> .logs to a database server so I can cut down on storage, run queries for
my
> own log parser and increase security. Any info will help. I've don't have
> access to the help files since this is a production server and run PRO
on my
> workstation which doesn't support ODBC logs.
>
> Thanks in advance
| |
| Jeff Cochran 2005-06-28, 5:54 pm |
| On Tue, 28 Jun 2005 05:54:01 -0700, [SteelValor]
<SteelValor@discussions.microsoft.com> wrote:
>Is this possible or is MS only support MsSQL or Access? I want to move all my
>.logs to a database server so I can cut down on storage, run queries for my
>own log parser and increase security. Any info will help. I've don't have
>access to the help files since this is a production server and run PRO on my
>workstation which doesn't support ODBC logs.
IIS can log to any ODBC database, including MySQL. The setup scripts
are for Access/SQL Server, but you could likely modify them for MySQL
or just create the appropriate database/tables and go.
A better option might be to log to a file, using the W3C format, since
the ODBC logs don't show as much. Then import the logs on a nightly
job into your database for analysis.
Cutting down on space usually isn't an end result of ODBC logging.
Microsoft's log parser tool is fully scriptable and there are quite a
few anlysis tools for the standard IIS text log files. And there's no
security advantage to logging to a database either.
The only real advantage to logging directly to a database is in a web
farm or other aggregated multiple server environment, and even there
it's questionable.
Jeff
|
|
|
|
|