Snort mailing list archives
RE: ACID And MYSQL
From: "John Ceballos-contr" <John.Ceballos-contr () TRW COM>
Date: Fri, 13 Jun 2003 08:26:34 -0400
Thanks for the help. My queries are now fine and I am getting the data correctly. Thanks again for the help.
"Schmehl, Paul L" <pauls () utdallas edu> 06/09/03 05:12PM >>>
I can think of a few things. The mysql account you are using to query the database doesn't have sufficient/correct grants to do the queries. The account password is incorrect. The queries are being done incorrectly. You're not really logging in to the snort database at all. ColdFusion doesn't have the right "connector" to query mysql directly (I somehow doubt this) or you might not have that "connector" enabled. Etc., etc. At this point you're going to have to do some troubleshooting. Start by logging in to mysql as admin and query the snort database directly to see if there's anything in the database. A simple select count(*) from event; should be sufficient. Then try logging in using the account that you created for access to the db and see if it returns anything for the same query. If the database has data in it and the account is able to login and see the data, then it has to be something external to mysql, so then you need to look at ColdFusion and the queries that you've written. I'm pretty sure ColdFusion should be capable of natively interacting with mysql, but I suppose there could be a problem with it. Is there anything in the logs that might point you in the right direction? What OS are you running ColdFusion on? How does it query the database? Remotely? Paul Schmehl (pauls () utdallas edu) Adjunct Information Security Officer The University of Texas at Dallas AVIEN Founding Member http://www.utdallas.edu/~pauls/ -----Original Message----- From: John Ceballos-contr [mailto:John.Ceballos-contr () TRW COM] Sent: Monday, June 09, 2003 3:03 PM To: snort-users () lists sourceforge net; Schmehl, Paul L Subject: RE: [Snort-users] ACID And MYSQL OK. Thanks Paul! My webpage is made with ColdFusion and I can't see why I am not getting the proper info unless I log into the ACID interface. My webpage also queries the database directly. This webpage doesn't have to do anything with ACID. Anybody know if there is something I am missing when I made this page with ColdFusion? Thanks! ------------------------------------------------------- This SF.NET email is sponsored by: eBay Great deals on office technology -- on eBay now! Click here: http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5 _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users
Current thread:
- ACID And MYSQL John Ceballos-contr (Jun 09)
- <Possible follow-ups>
- RE: ACID And MYSQL Schmehl, Paul L (Jun 09)
- RE: ACID And MYSQL John Ceballos-contr (Jun 09)
- RE: ACID And MYSQL Schmehl, Paul L (Jun 09)
- RE: ACID And MYSQL John Ceballos-contr (Jun 13)
- RE: ACID And MYSQL Schmehl, Paul L (Jun 13)
- RE: ACID And MYSQL John Ceballos-contr (Jun 13)