• RSS
  • Twitter
  • FaceBook

Welcome to ISAserver.org

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

MS-ISA-Server + MySQL

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> MS-ISA-Server + MySQL Page: [1]
Login
Message << Older Topic   Newer Topic >>
MS-ISA-Server + MySQL - 21.Feb.2005 9:51:00 PM   
my-sql

 

Posts: 3
Joined: 21.Feb.2005
Status: offline
I try to get configure M$-I$A 2004 to make its logs to MySQL database. Standalone all works fine. But together is problem. So I$A 2004 and MySQL runs on same server M$ Windowz 2003 $erver, I had create users, database and required tables (same as M$-$QL), install and configure ODBC data source, ODBC test is OK. Next, I make change to put packet filter and web proxy logs to MySQL, but I$A does not make the logs. Why?
And what should I do to power I$A to put its logs to MySQL?
With M$-$QL 2000 I$A 2004 works, is it special surprize from M$?
For me, MySQL is best solution from many nominations, it's perfect, no reason to change it and M$-$QL is wrong choise.
Help, if you know how.
P.S.: Many days before M$-Proxy 2.0, 2.1 on WinNT 4.0, Win 2K works fine and puts logs to MySQL on FreeBSD. Next, I$A 2000 has special dummy and not configurable columns RULE#1, RULE#2 making difficult to implement MySQL logging breaks special symbol # without ''. I$A 2004 has no such suxs, but what is prevent to make such aproach?

[ February 28, 2005, 12:51 PM: Message edited by: tshinder ]
Post #: 1
RE: MS-ISA-Server + MySQL - 27.Feb.2005 4:39:00 PM   
my-sql

 

Posts: 3
Joined: 21.Feb.2005
Status: offline
I install ODBC-translator: I$A -> Acce$$ -> MySQL. Asses can use MySQL tables, but I$A could not dumping its log to Asses:

The ISA Server Web filter was unable to open ODBC Data Source ISA_access, Table: webproxylog, under User Name []. The ODBC Error description is: [State=S1104][Error=98][Microsoft][ODBC Microsoft Access Driver]Invalid precision value .
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

The Microsoft Firewall was unable to open ODBC Data Source ISA_access, Table: firewalllog, under User Name []. The ODBC Error description is: [State=S1104][Error=98][Microsoft][ODBC Microsoft Access Driver]Invalid precision value .
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

There is no any ODBC properties for precision, neither Access no MySQL data sources.
I try to change decimal separator in regional settings without success.
How to fix it?

(in reply to my-sql)
Post #: 2
RE: MS-ISA-Server + MySQL - 22.Mar.2005 5:35:00 PM   
likesj

 

Posts: 1
Joined: 22.Mar.2005
Status: offline
Was anyone able to resolve this?

(in reply to my-sql)
Post #: 3

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> MS-ISA-Server + MySQL Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts