MySQL with Intel Compiler
Dear Friends, We want to use MySQL compiled with Intel Compiler to get superior performance. Our server is a rack mounted HP DL 380 server with Redhat Enterprise Linux Advanced Server 3.0. We have used mysql-standard-4.1.3-beta-pc-linux-i686-icc.tar.gz. But we are getting the following error : --- [EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user=mysql --force Installing all prepared tables Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 040824 17:29:49 Aborting 040824 17:29:49 ./bin/mysqld: Shutdown complete --- For more details(Full text of Error Message), please see the attachment. But mysql user group is existing. Please kindly help me. Thanks in Advance With Regards Santhanam [EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user=mysql --force Installing all prepared tables Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 040824 17:29:49 Aborting 040824 17:29:49 ./bin/mysqld: Shutdown complete ./bin/mysql_create_system_tables: line 651: 2177 Broken pipe cat END_OF_DATA use mysql; $c_d $i_d $c_h $i_h $c_u $i_u $c_f $i_f $c_t $c_c $c_ht $c_hc $c_hr $c_hk $c_tzn $i_tzn $c_tz $i_tz $c_tzt $i_tzt $c_tztt $i_tztt $c_tzls $i_tzls END_OF_DATA Installation of system tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! [EMAIL PROTECTED] mysql]# -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL with Intel Compiler
Can't change to run as user 'mysql' ; Please check that the user exists! man useradd _ Steve Poirier -Original Message- From: Santhanam [mailto:[EMAIL PROTECTED] Sent: August 24, 2004 8:02 AM To: [EMAIL PROTECTED] Subject: MySQL with Intel Compiler Dear Friends, We want to use MySQL compiled with Intel Compiler to get superior performance. Our server is a rack mounted HP DL 380 server with Redhat Enterprise Linux Advanced Server 3.0. We have used mysql-standard-4.1.3-beta-pc-linux-i686-icc.tar.gz. But we are getting the following error : --- [EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user=mysql --force Installing all prepared tables Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 040824 17:29:49 Aborting 040824 17:29:49 ./bin/mysqld: Shutdown complete --- For more details(Full text of Error Message), please see the attachment. But mysql user group is existing. Please kindly help me. Thanks in Advance With Regards Santhanam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL with Intel Compiler
Sorry, didn't see you already had a mysql user. David has a better english than mine: It looks like your MySQL server process is hitting a problem when it tries to change its user id to that of the user 'mysql'. There are two possible reasons for this: 1. You're starting the server process as a user who isn't 'root', so the user doesn't have the necessary privilege to change the UID of the server process. -- OR -- 2. You *are* starting the server process as 'root', but your system doesn't have a user called 'mysql', so the process is trying, and failing, change its UID to a user that doesn't exist. Try finger mysql to see whether you actually have a user named 'mysql'. Thinking about it, there are other possibilities, assuming that you *do* have a user named 'mysql'. 3. The 'mysql' user doesn't have a home directory, or for some reason that user doesn't have write-access to its home directory. 4. The 'mysql' user doesn't have the necessary access privileges to /path/to/mysql and all of its sub-directories. source http://www.talkaboutprogramming.com/group/comp.lang.java.databases/messages/ 57463.html _ Steve Poirier -Original Message- From: Santhanam [mailto:[EMAIL PROTECTED] Sent: August 24, 2004 8:02 AM To: [EMAIL PROTECTED] Subject: MySQL with Intel Compiler Dear Friends, We want to use MySQL compiled with Intel Compiler to get superior performance. Our server is a rack mounted HP DL 380 server with Redhat Enterprise Linux Advanced Server 3.0. We have used mysql-standard-4.1.3-beta-pc-linux-i686-icc.tar.gz. But we are getting the following error : --- [EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user=mysql --force Installing all prepared tables Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 040824 17:29:49 Aborting 040824 17:29:49 ./bin/mysqld: Shutdown complete --- For more details(Full text of Error Message), please see the attachment. But mysql user group is existing. Please kindly help me. Thanks in Advance With Regards Santhanam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL with Intel Compiler
Hi! On Aug 24, Santhanam wrote: Dear Friends, We want to use MySQL compiled with Intel Compiler to get superior performance. Our server is a rack mounted HP DL 380 server with Redhat Enterprise Linux Advanced Server 3.0. We have used mysql-standard-4.1.3-beta-pc-linux-i686-icc.tar.gz. But we are getting the following error : --- [EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user=mysql --force Installing all prepared tables Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 040824 17:29:49 Aborting 040824 17:29:49 ./bin/mysqld: Shutdown complete http://bugs.mysql.com/bug.php?id=4408 Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL with Intel Compiler
We've seen this problem too. In our case we definitely had a mysql user, and the mysql user definitely existed. From one prompt we could start the gcc-compiled MySQL correctly, but not the Intel-compiled MYSQL. We were able to fix the problem by setting LD_LIBRARY_PATH=/lib. -JF -Original Message- From: Steve Poirier [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 8:03 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: MySQL with Intel Compiler Sorry, didn't see you already had a mysql user. David has a better english than mine: It looks like your MySQL server process is hitting a problem when it tries to change its user id to that of the user 'mysql'. There are two possible reasons for this: 1. You're starting the server process as a user who isn't 'root', so the user doesn't have the necessary privilege to change the UID of the server process. -- OR -- 2. You *are* starting the server process as 'root', but your system doesn't have a user called 'mysql', so the process is trying, and failing, change its UID to a user that doesn't exist. Try finger mysql to see whether you actually have a user named 'mysql'. Thinking about it, there are other possibilities, assuming that you *do* have a user named 'mysql'. 3. The 'mysql' user doesn't have a home directory, or for some reason that user doesn't have write-access to its home directory. 4. The 'mysql' user doesn't have the necessary access privileges to /path/to/mysql and all of its sub-directories. source http://www.talkaboutprogramming.com/group/comp.lang.java.datab ases/messages/ 57463.html _ Steve Poirier -Original Message- From: Santhanam [mailto:[EMAIL PROTECTED] Sent: August 24, 2004 8:02 AM To: [EMAIL PROTECTED] Subject: MySQL with Intel Compiler Dear Friends, We want to use MySQL compiled with Intel Compiler to get superior performance. Our server is a rack mounted HP DL 380 server with Redhat Enterprise Linux Advanced Server 3.0. We have used mysql-standard-4.1.3-beta-pc-linux-i686-icc.tar.gz. But we are getting the following error : --- [EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user=mysql --force Installing all prepared tables Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 040824 17:29:49 Aborting 040824 17:29:49 ./bin/mysqld: Shutdown complete --- For more details(Full text of Error Message), please see the attachment. But mysql user group is existing. Please kindly help me. Thanks in Advance With Regards Santhanam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]