Re: Anyone use Snort and Acid?
At 08:22 PM Monday, 11/14/2005, Jason Martin wrote -= On Sun, Nov 13, 2005 at 08:56:12PM -0800, Ed Kasky wrote: Snort v2.4.3 ACID v0.9.6b23 I seem to recall hearing that ACID is deprecated; you might want to look around if there is a newer equivalent. SQUIL (http://sguil.sourceforge.net/) is supposed to be really good. -Jason Martin I finally found out the problem. It has to do with the way ACID was referencing the Schema table and info. One of the developers of BASE, a fork project of ACID, pointed this out. In one of the php scripts I changed: $sql = SELECT vseq FROM schema; to $sql = SELECT vseq FROM `schema`; and it works as advertised. Ed . . . . . . . . . . . . . . . . . . Randomly Generated Quote (229 of 1011): When you get to the end of your rope, tie a knot and hang on. --Franklin Delano Roosevelt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Anyone use Snort and Acid?
I am posting to this list in hopes that someone might have a clue as to why I might be experiencing a problem since upgrading to 5.0.15. Setup is as follows: Snort v2.4.3 MySql v5.0.15 ACID v0.9.6b23 RedHat 7.2 Since upgrading MySql from 4.1.15 to 5.0.15, Acid does not display the signature properly. All it shows is a number - no description/link. I have tried re-creating the database in both MyISAM and InnoDB but no luck. The only thing I have not tried is to back-rev MySql as I am not sure what affect this will have on other db's. Any suggestions/ideas are greatly appreciated... Ed . . . . . . . . . . . . . . . . . . Randomly Generated Quote (125 of 1011): It must be a peace without victory Only a peace between equals can last. --Woodroe Wilson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone use Snort and Acid?
I just discovered that BASE is a newer version of ACID based on some of the same code. It too returns single digit numbers where the signature description should be on the results screen. I will check out SQUIL. Thanks for the tip At 08:22 PM Monday, 11/14/2005, you wrote -= On Sun, Nov 13, 2005 at 08:56:12PM -0800, Ed Kasky wrote: Snort v2.4.3 ACID v0.9.6b23 I seem to recall hearing that ACID is deprecated; you might want to look around if there is a newer equivalent. SQUIL (http://sguil.sourceforge.net/) is supposed to be really good. -Jason Martin -- I have a watch cat! Just break in and she'll watch. This message is PGP/MIME signed. . . . . . . . . . . . . . . . . . . Randomly Generated Quote (127 of 1011): I've noticed that the press tends to be quite accurate, except when they're writing on a subject I know something about. (Keith F. Lynch) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error compiling 5.0.15
log.o log_event.o init.o derror.o sql_acl.o unireg.o des_key_file.o discover.o time.o opt_range.o opt_sum.o records.o filesort.o handler.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innodb.o ha_ndbcluster.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o sql_union.o sql_derived.o client.o sql_client.o mini_client_errors.o pack.o stacktrace.o repl_failsafe.o sql_olap.o sql_view.o gstream.o spatial.o sql_help.o sql_cursor.o tztime.o my_time.o my_decimal.o sp_head.o sp_pcontext.o sp_rcontext.o sp.o sp_cache.o parse_file.o sql_trigger.o ha_example.o ha_archive.o ha_tina.o ha_blackhole.o ha_federated.o ../innobase/usr/libusr.a ../innobase/srv/libsrv.a ../innobase/dict/libdict.a ../innobase/que/libque.a ../innobase/srv/libsrv.a ../innobase/ibuf/libibuf.a ../innobase/row/librow.a ../innobase/pars/libpars.a ../innobase/btr/libbtr.a ../innobase/trx/libtrx.a ../innobase/read/libread.a ../innobase/usr/libusr.a ../innobase/buf/libbuf.a ../innobase/ibuf/libibuf.a ../innobase/eval/libeval.a ../innobase/log/liblog.a ../innobase/fsp/libfsp.a ../innobase/fut/libfut.a ../innobase/fil/libfil.a ../innobase/lock/liblock.a ../innobase/mtr/libmtr.a ../innobase/page/libpage.a ../innobase/rem/librem.a ../innobase/thr/libthr.a ../innobase/sync/libsync.a ../innobase/data/libdata.a ../innobase/mach/libmach.a ../innobase/ha/libha.a ../innobase/dyn/libdyn.a ../innobase/mem/libmem.a ../innobase/sync/libsync.a ../innobase/ut/libut.a ../innobase/os/libos.a ../innobase/ut/libut.a -lrt ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../vio/libvio.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lz -ldl -lpthread -lcrypt -lnsl -lm -lpthread make[2]: Leaving directory `/home/heikki/mysql-5.0.15/sql' make[1]: Leaving directory `/home/heikki/mysql-5.0.15/sql' [EMAIL PROTECTED]:~/mysql-5.0.15/sql$ Ed Kasky wrote: Heikki, Thanks for the reply... gcc (GCC) 3.2 and c++ is 2.96 Being somewhat of a novice at compiling, where in the output should I see wether or not it links ./innobase/libut.a in? Would you know if it is early on in the compilation or closer to where my error is? Best, Ed At 09:39 PM Sunday, 11/6/2005, you wrote -= Ed, what does gcc --version say? I am able to compile with gcc-3.3.1. in ut0dbg.h we have: #if defined(__GNUC__) (__GNUC__ 2) # define UT_DBG_FAIL(EXPR) UNIV_UNLIKELY(!((ulint)(EXPR))) #else extern ulintut_dbg_zero; /* This is used to eliminate compiler warnings */ # define UT_DBG_FAIL(EXPR) !((ulint)(EXPR) + ut_dbg_zero) #endif and in ut0dbg.c: #if defined(__GNUC__) (__GNUC__ 2) #else /* This is used to eliminate compiler warnings */ ulint ut_dbg_zero = 0; #endif Looks like your compiler does define __GNUC__ 2 when you compile ut0dbg.c, but it does NOT define it when you compile ha_innodb.cc. This could be because ha_innodb.cc is C++ code. Another explanation would be that for some reason make fails to link ./innobase/libut.a in. If you look at the gcc output in compilation, do you see it being linked in? Regards, Heikki Oracle/Innobase - Original Message - From: Ed Kasky [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Sunday, November 06, 2005 10:08 PM Subject: Error compiling 5.0.15 I am experiencing problems when trying to compile 5.0.15 on RH 7.3. I run configure --prefix /usr/local/mysql with no apparent errors. when I run make I get the following error: ha_innodb.o: In function `check_trx_exists(THD *)': ha_innodb.o(.text+0x30a): undefined reference to `ut_dbg_zero' ha_innodb.o: In function `innobase_query_caching_of_table_permitted(THD *, char *, unsigned int, unsigned long long *)': ha_innodb.o(.text+0x3ab): undefined reference to `ut_dbg_zero' ha_innodb.o(.text+0x3b6): undefined reference to `ut_dbg_zero' ha_innodb.o: In function `innobase_init(void)': ha_innodb.o(.text+0x69c): undefined reference to `ut_dbg_zero' ha_innodb.o(.text+0x72e): undefined reference to `ut_dbg_zero' ha_innodb.o(.text+0x98c): more undefined references to `ut_dbg_zero' follow collect2: ld returned 1 exit status make[4]: *** [mysqld] Error 1 make[4]: Leaving directory `/usr/src/mysql-5.0.15/sql' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/usr/src/mysql-5.0.15/sql' make[2]: *** [all] Error 2 make[2]: Leaving directory `/usr/src/mysql-5.0.15/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/mysql-5.0.15' make: *** [all] Error 2 Any ideas are greatly appreciated. Also, I know I can use the binary but I have been instaling from src for quite a while and would like to continue if my current OS can handle it. Thanks in advance Ed . . . . . . . . . . . . . . . . . . Randomly Generated Quote (614 of 1009): It is bad luck to be superstitious. -- Andrew W. Mathis -- MySQL General
Error compiling 5.0.15
I am experiencing problems when trying to compile 5.0.15 on RH 7.3. I run configure --prefix /usr/local/mysql with no apparent errors. when I run make I get the following error: ha_innodb.o: In function `check_trx_exists(THD *)': ha_innodb.o(.text+0x30a): undefined reference to `ut_dbg_zero' ha_innodb.o: In function `innobase_query_caching_of_table_permitted(THD *, char *, unsigned int, unsigned long long *)': ha_innodb.o(.text+0x3ab): undefined reference to `ut_dbg_zero' ha_innodb.o(.text+0x3b6): undefined reference to `ut_dbg_zero' ha_innodb.o: In function `innobase_init(void)': ha_innodb.o(.text+0x69c): undefined reference to `ut_dbg_zero' ha_innodb.o(.text+0x72e): undefined reference to `ut_dbg_zero' ha_innodb.o(.text+0x98c): more undefined references to `ut_dbg_zero' follow collect2: ld returned 1 exit status make[4]: *** [mysqld] Error 1 make[4]: Leaving directory `/usr/src/mysql-5.0.15/sql' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/usr/src/mysql-5.0.15/sql' make[2]: *** [all] Error 2 make[2]: Leaving directory `/usr/src/mysql-5.0.15/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/mysql-5.0.15' make: *** [all] Error 2 Any ideas are greatly appreciated. Also, I know I can use the binary but I have been instaling from src for quite a while and would like to continue if my current OS can handle it. Thanks in advance Ed . . . . . . . . . . . . . . . . . . Randomly Generated Quote (614 of 1009): It is bad luck to be superstitious. -- Andrew W. Mathis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem Upgrading
Thanks for pointing me in that direction. The client from the binary distro works fine. I guess I should just stick with the binaries ;-) Ed Gleb Paharenko wrote: If you want to debug this issue, have a look here: http://dev.mysql.com/doc/refman/5.0/en/debugging-client.htmlhttp://dev.mysql.com/doc/refman/5.0/en/debugging-client.html But if I were you I would check first if mysql client from the official binaries produces the same faults. Ed Kasky wrote: I am attempting to upgrade using the source from 4.1.13 to 4.1.15 on a Redhat 7.2 machine and have been experiencing problems using the mysql client. I keep having to revert back to 4.1.13 as it installs just fine. # mysql -h localhost -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 34 to server version: 4.1.15-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql \h Segmentation fault My searches keep coming up empty. I posted this to the list a while back but haven't been able to solve it. . . . . . . . . . . . . . . . . . . Randomly Generated Quote (847 of 1008): The road to Hades is easy to travel. -- Bion
Problem Upgrading
I am attempting to upgrade using the source from 4.1.13 to 4.1.15 on a Redhat 7.2 machine and have been experiencing problems using the mysql client. I keep having to revert back to 4.1.13 as it installs just fine. # mysql -h localhost -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 34 to server version: 4.1.15-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql \h Segmentation fault My searches keep coming up empty. I posted this to the list a while back but haven't been able to solve it. Thanks in advance Ed . . . . . . . . . . . . . . . . . . Randomly Generated Quote (39 of 1008): Cogito ergo I'm right and you're wrong. -- Blair Houghton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: segmentation fault using mysql
At 10:15 AM Saturday, 8/27/2005, Kemin Zhou wrote -= Ed Kasky wrote: Running MySql 4.1.14 on RedHat 7.2 I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems using the mysql client. # /usr/local/mysql/bin/mysql -h localhost -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 34 to server version: 4.1.14-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql \h Segmentation fault I had similar problems before. It was caused by older version of client. Once client is updated this problem goes away. This problem has also occured to me when I use InnoDB instead of the defaul table type. For later case, I make a copy of the innoDB into the regular type, then the problem seem to goes away. Hope my experience will help you. Hmmm... I wonder why the client would not have been updated. I checked the version and could have sworn it was 4.1.14 as well. I have only converted a test table to InnoB - the rest are MyISAM. I will re-run the install (I use the src distro) and see if the client does not get updated. Ed Kasky ~ Randomly Generated Quote (462 of 487): We are born naked and hungry and it's down hill from there. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
segmentation fault using mysql
Running MySql 4.1.14 on RedHat 7.2 I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems using the mysql client. # /usr/local/mysql/bin/mysql -h localhost -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 34 to server version: 4.1.14-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql \h Segmentation fault My searches have not resulted in any solutions at this point - just thought I'd throw it out to the list and see if anyone has had a similar experience. Ed Kasky ~ Randomly Generated Quote (324 of 486): I would have made this shorter, but I ran out of time. . . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Empty database name error
Hello there - I have a couple of questions regarding a new install of MySql 4.1.12 on RH 7.2. Being new to this list, I sure do hope this hasn't been covered before. I have scrubbed Google and searched the archives for this list but can't find an explanation or a solution to 2 issues: 1. I get the following error when starting the daemon: 050605 7:08:51 [Warning] Found an entry in the 'db' table with empty database name; Skipped Is this something that should be fixed and if so, how does one go about it? 2. I have set the error log to /var/log/mysql/error.log in the init script: LOG_ERROR=/var/log/mysql/error.log $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --log-error=$LOG_ERROR However, I am still getting 2 error logs: What I am assuming is the default /usr/local/mysql/var/yoda2.err and the one specified - /var/log/mysql/error.log Is this expected behavior? Is there another place aside from /etc/my.cnf that I might look? Thanks in advance for any tips and/or suggestions. Ed . . . . . . . . . . . . . . . . . . Randomly Generated Quote (116 of 975): It had long since come to my attention that people of accomplishment rarely sat back and let things happen to them. They went out and happened to things. - Elinor Smith -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Empty database name error
I added the line to the configuration file and removed --log-error= line from startup line but it still creates the /usr/local/mysql/var/yoda2.err as well as /var/log/mysql/error.log I am assuming it is reading from my.cnf as I get the following when I run mysqladmin variables log_error | /var/log/mysql/error.log I also checked for possible duplicate my.cnf files but there is only one. Is there another way to check to be sure it's reading the configuration file? At 12:40 PM Sunday, 6/5/2005, Gleb Paharenko wrote -= Unfortunately I could give suggestion only about your second question. Is it possible that /var/log/mysql/error.log created by mysqld_safe (you're specifying it with --log-error command line option) and /usr/local/mysql/var/yuda2.err is created by mysqld process if it founds problems before applying location of error log to it's internal variable? Specify log-error = /var/log/mysql/error.log in your configuration file, and check that MySQL Server actually reads this file. Ed Kasky wrote: Hello there - I have a couple of questions regarding a new install of MySql 4.1.12 on RH 7.2. Being new to this list, I sure do hope this hasn't been covered before. I have scrubbed Google and searched the archives for this list but can't find an explanation or a solution to 2 issues: 1. I get the following error when starting the daemon: 050605 7:08:51 [Warning] Found an entry in the 'db' table with empty database name; Skipped Is this something that should be fixed and if so, how does one go about it? 2. I have set the error log to /var/log/mysql/error.log in the init script: LOG_ERROR=/var/log/mysql/error.log $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --log-error=$LOG_ERROR However, I am still getting 2 error logs: What I am assuming is the default /usr/local/mysql/var/yoda2.err and the one specified - /var/log/mysql/error.log Is this expected behavior? Is there another place aside from /etc/my.cnf that I might look? Thanks in advance for any tips and/or suggestions. Ed . . . . . . . . . . . . . . . . . . Randomly Generated Quote (116 of 975): It had long since come to my attention that people of accomplishment rarely sat back and let things happen to them. They went out and happened to things. - Elinor Smith -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] . . . . . . . . . . . . . . . . . . Randomly Generated Quote (203 of 975): To climb steep hills requires slow pace at first. - William Shakespeare -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Understanding relational database setup/construction
For theory and history, I found the manual to be an excellent place to start... http://www.mysql.com/manual.php and have a walk through the tutorial starting with: http://www.mysql.com/doc/C/o/Connecting-disconnecting.html At 05:05 PM Saturday, 6/22/2002, Timothy J. Luoma wrote -= I've looked through Google and the MySQL website without luck. I'm looking to find a place which discusses the theory of how one should create a database, how to organize the information, etc. There's got to be a good site out there, but I'm obviously plugging in the wrong search terms or something. Ed Kasky Los Angeles, CA . . . . . . . . A closed mind is a beautiful thing to lose. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php