RE: ODBC logging via ISS Internet Scanner
From: JC (jchaser@yahoo.com)Date: 12/21/01
- Previous message: Jeffrey Keyser : "Re: Locking down IIS"
- Maybe in reply to: JC: "ODBC logging via ISS Internet Scanner"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 20 Dec 2001 23:15:59 -0800 (PST) From: JC <jchaser@yahoo.com> To: William Holmberg <bill.holmberg@chrobinson.com>, security-basics@securityfocus.com
It seems as though I have found kind of an answer to
this problem. “ISS ODBC LOGGING”
Here is a synopsis of the situation: I want ISS
Internet Scanner version 6.21.2001.320 to log to a
MySQL server. I have a ODBC connection to this MySQL
server that I have setup and I have verified that it
works.
When I launch ISS click on Tools > Database
Administration > New DSN > Then either select and
existing ODBC data source only shows the .mdb data
source files not the MySQL one. If you do a create new
data source I don't have the opportunity to specify
the login, password, database, hostname, port # in
which to use to configure ISS to use MySQL.
I stopped looking around the iss.net site, and started
to look for a solution that would allow me to go from
Access to MySQL. I found out that you can do this from
within Access, but you have to do this table by table.
Click on the table that you want to export and then
click File > export from the export window scroll to
the bottom of the list and select ODBC data another
window will pop up that will ask you the table in
which you want to export to, then click on the user or
system DSN that you created and click ok. This will
export the table to the database that you setup in the
ODBC properties. Do note however that I have found
this to be a one-way street if the table is already
defined the export fails, so if the table has not been
defined then it will create the table for you
I hope that this little tid bit will possibly help any
of you wishing to accomplish something similar.
JC
--- William Holmberg <bill.holmberg@chrobinson.com>
wrote:
> Interesting! I'll pass this on to our guy and see if
> he has more for
> you, but it sounds like you found a "soft spot"...
> Best of Luck,
> Bill
>
> -----Original Message-----
> From: JC [mailto:jchaser@yahoo.com]
> Sent: Tuesday, December 18, 2001 4:44 PM
> To: William Holmberg;
> security-basics@securityfocus.com;
> mattc@guarded.net
> Subject: RE: ODBC logging via ISS Internet Scanner
>
>
> Hi Again,
>
> Thanks for the info, but I already did that. I have
> a
> DSN called mysql that points to my linux mysql
> server.
> I have a perl script that I wrote that I've used to
> verify that the DSN is working and I do have access
> and sufficient rights to do insert,select and the
> like.
>
> I am using ISS Internet Scanner 6.21.2001.320. When
> I
> launch ISS click on Tools > Database Administration
> >
> New DSN > Then either select and existing ODBC data
> source only shows the .mdb data source files not the
> MySQL one. If you do a create new datasource I don't
> have the opportunity to specify the login, password,
> database, hostname, port # in which to use to
> configure ISS to use MySQL.
>
> I want to log to a single MySQL server through an
> ODBC
> connection that I have already established and
> verified that works. I understand that I may be
> required to duplicate the schema on the MySQL server
> I
> have no problem with that. I'm not looking for a
> product that has all of these fancy bells and
> whistles
> that my company would have to pay for.
>
> There was a mention of a utility that can output to
> a
> .csv file where I would need to do a bulk copy into
> MySQL that's fine too. Since I don't have the
> installation CD I've looked for db2u and I didn't
> find
> it on the local system or on the web (google wasn't
> good to me this time).
>
>
>
> Thanks again
>
> JC
>
> __________________________________________________
> Do You Yahoo!?
> Check out Yahoo! Shopping and Yahoo! Auctions for
> all of
> your unique holiday gifts! Buy at
> http://shopping.yahoo.com
> or bid at http://auctions.yahoo.com
__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
- Previous message: Jeffrey Keyser : "Re: Locking down IIS"
- Maybe in reply to: JC: "ODBC logging via ISS Internet Scanner"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
