build fails make test
After building, I ran make test. The func_group test failed. Here is the output: func_group [ fail ] Errors are (from /mnt/raid/download/computer/software/mysql/mysql-5.0.2-alpha/mysql-test/var/log/mysqltest-time) : /mnt/raid/download/computer/software/mysql/mysql-5.0.2-alpha/client/.libs/mysqltest: At line 477: Result content mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: --- *** r/func_group.result 2004-12-01 03:31:35.0 +0300 --- r/func_group.reject 2005-03-09 02:00:49.0 +0300 *** *** 578,584 explain select min(a1) from t1 where a1 != 'KKK'; idselect_type table typepossible_keys key key_len refrows Extra ! 1 SIMPLE t1 index PRIMARY PRIMARY 3 NULL14 Using where; Using index explain select max(a3) from t1 where a2 2 and a3 'SEA'; idselect_type table typepossible_keys key key_len refrows Extra --- 578,584 explain select min(a1) from t1 where a1 != 'KKK'; idselect_type table typepossible_keys key key_len refrows Extra ! 1 SIMPLE t1 range PRIMARY PRIMARY 3 NULL14 Using where; Using index explain select max(a3) from t1 where a2 2 and a3 'SEA'; idselect_type table typepossible_keys key key_len refrows Extra --- I re-ran mysql-test-run --force from the mysql-test directory. The following also failed: greedy_optimizer group_min_max (Their combined .reject files are well over 100k. Let me know where to send compressed versions.) Note that the entire build and test process was done from a user account, not from the root account. How-To-Repeat: simply ran make test after building. Fix: Unknown Submitter-Id: submitter ID Originator:Mark Johnson Organization: n/a MySQL support: none Synopsis: func_group test failed. Severity: Priority: Category: mysql Class: sw-bug Release: mysql-5.0.2-alpha (Source distribution) C compiler:gcc (GCC) 3.4.3 C++ compiler: g++ (GCC) 3.4.3 Environment: System: Linux enterprise 2.6.10 #1 Sat Feb 5 14:42:44 MST 2005 i686 unknown unknown GNU/Linux Architecture: i686 Additional notes on the system: It is based on Slackware 10.0, with security patches from slackware.com applied.When I tried to compile MySQL with the gcc version 3.3.4, which came with Slackware 10, there was an internal compiler error. I upgraded the compiler to the current version from slackware-current. Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc/i486-slackware-linux/3.4.3/specs Configured with: ../gcc-3.4.3/configure --prefix=/usr --enable-shared --enable-threads=posix --enable-__cxa_atexit --disable-checking --with-gnu-ld --verbose --target=i486-slackware-linux --host=i486-slackware-linux Thread model: posix gcc version 3.4.3 Compilation info: CC='gcc' CFLAGS='-O2 -march=pentium2' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 2004-10-21 06:28 /lib/libc.so.6 - libc-2.3.2.so -rwxr-xr-x 1 root root 1250840 2004-05-24 22:44 /lib/libc-2.3.2.so -rw-r--r-- 1 root root 2532408 2004-05-24 22:44 /usr/lib/libc.a -rw-r--r-- 1 root root 204 2004-05-24 22:31 /usr/lib/libc.so Configure command: ./configure 'CFLAGS=-O2 -march=pentium2' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't get MySQL running on RH7.0 at all.
The only think I did was copy 'my-medium.cnf' to 'my.cnf' and ran mysql_install_db (successfully) and then ran mysqld as instructed which didn't run successfuly and reported the errors below. I didn't change anything in my.cnf, I didn't touch anything at all... Is there a way that I can start fresh without reinstalling the OS? - Original Message - From: Dana Powers [EMAIL PROTECTED] To: Mark Johnson [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 1:04 AM Subject: Re: Can't get MySQL running on RH7.0 at all. The error logs seem to indicate that the pid file you've specified is not writable and that the system database tables are not installed properly. 1. make sure that you ran mysql_install_db. If you did, make sure that you didnt change the my.cnf datadir setting without moving your system files or re running mysql_install_db. 2. ( #1 usually takes care of this, but ) make sure the pid file is writable ( find path in error log message or ./mysqld --help or /etc/my.cnf if you've overrided default ) dpk - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 17, 2001 9:42 PM Subject: Can't get MySQL running on RH7.0 at all. I must be a moron but I can't seem to figure out what I need to do to get mysql to work on RH, on Mandrake it just worked straight away. I read and followed the instructions in the INSTALL-BINARY (inspite of the fact that the way red hat installed mysql does not even closely resemble the instructions) but mysql will not come up. This is the error log: 010917 11:26:38 mysqld started 010917 11:26:38 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:26:38 mysqld ended 010917 11:32:09 mysqld started 010917 11:32:10 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld.pid' (Errcode: 13) 010917 11:32:10 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:32:10 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' (Errcode: 2) 010917 11:32:10 mysqld ended There must be some secret bit of knowledge that is obvious to everybody else and i'm just not reading the right document or something. I'm sure somebody has been able to install MySQL via the RPMs and get it to work. Can anyone help me with this? Do I need to create a user called mysql and add them to the group root? I'm suspicious of the permission problems... thanks for your time... - 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 - 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 - 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
Can't get MySQL running on RH7.0 at all.
I must be a moron but I can't seem to figure out what I need to do to get mysql to work on RH, on Mandrake it just worked straight away. I read and followed the instructions in the INSTALL-BINARY (inspite of the fact that the way red hat installed mysql does not even closely resemble the instructions) but mysql will not come up. This is the error log: 010917 11:26:38 mysqld started 010917 11:26:38 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:26:38 mysqld ended 010917 11:32:09 mysqld started 010917 11:32:10 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld.pid' (Errcode: 13) 010917 11:32:10 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:32:10 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' (Errcode: 2) 010917 11:32:10 mysqld ended There must be some secret bit of knowledge that is obvious to everybody else and i'm just not reading the right document or something. I'm sure somebody has been able to install MySQL via the RPMs and get it to work. Can anyone help me with this? Do I need to create a user called mysql and add them to the group root? I'm suspicious of the permission problems... thanks for your time... - 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
Re: Setting user passwords per database
I tried that, all it did was change my password for mysql completelyhowever, i could have done something wrong... - Original Message - From: Gerald R. Jensen [EMAIL PROTECTED] To: Mark Johnson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 27, 2001 5:35 AM Subject: Re: Setting user passwords per database It would see you could us ethe GRANT command: GRANT ALL PRIVILEGES ON database1.* TO user@% IDENTIFIED BY 'password1'; GRANT ALL PRIVILEGES ON database2.* TO user@% IDENTIFIED BY 'password2'; GRANT ALL PRIVILEGES ON database3.* TO user@% IDENTIFIED BY 'password3'; - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 26, 2001 10:40 PM Subject: Setting user passwords per database Is it possible to set a differenent password per database for the same user? It doen't appear to be possible - 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 - 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
Setting user passwords per database
Is it possible to set a differenent password per database for the same user? It doen't appear to be possible - 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
Question about users
I created a perl script that opens that database like this: my $dbh = DBI-connect( 'DBI:mysql:devjournal:username=mjohnson:host=morpheus' ); This works great if I run the script from another machine, but if i run in on morpheus it says that [EMAIL PROTECTED] does not have access. If I leave off the host part it works fine. But I would like to be able to run this script unchanged for any machine including morpheus. I have added myself as mjohnson@localhost and mjohnson@%, do I need to add myself as [EMAIL PROTECTED]? thanks for your help! - 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