Re: mysql_install_db problem
jose wrote: I´ve problems with mysql_install_db I´m trying to install mysql (last version 4.1.10) in a x86 solaris 10 release. I prove with other version of solaris like 9 or 8 and always is the same result. The system return a core file but give me none log error. One strange thing is that was able to install with other machine. I have seen this exact problem and I have seen two reasons for this. If you would like to try my packages, they are at www.blastwave.org. One problem is an initgroups call and the other is from the crypt function in libcrypt_?.so. I can give you patches for both. It may be best to try my package first to verify that you have no other problems and that this will fix things. Then if you do not want to use my packages, just post back to the list and I will send you the patches. Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql_install_db problem!!
check the privileges on directories. that error you generally get when user dont have sufficient privileges on directories. please go through the installation steps given in mysql documentation Anil -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 8:28 PM To: manasvini nandakumar Cc: [EMAIL PROTECTED] Subject: Re: mysql_install_db problem!! manasvini nandakumar wrote: Hi all, I have cross compiled mysql-4.1.7 (from the source distribution)for an IXP425 based board with Montavista Linux-3.0.When I run mysql_install_db --user=mysql ...It runs into several errors with the following log --- [EMAIL PROTECTED]: /usr/local# ./bin/mysql_install_db --user=mysql WARNING: The host '192.168.10.231' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 1146 Table 'mysql.db' doesn't exist ERROR: 1146 Table 'mysql.db' doesn't exist ERROR: 3 Error writing file './mysql/host.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/user.frm' (Errcode: 2) --- --- The filesystem is NFS mounted.I am hoping someone can tell me why this is happenning and If I have missed out something. The mysql user cannot write to the database directory. It could be an NFS issue. Thanx in advance, Manasvini - Do you Yahoo!? Yahoo! Mail - You care about security. So do we. -- 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]
RE: mysql_install_db problem!!
Hi all, Initially, I had also suspected an NFS problem,I tried the same process on a local flash file system on the target board.It still yielded the same problems. the mysql user has complete privileges on the directory (MYSQL's data directory /usr/local/mysql/var/).I had also tested a sample program that attempts to emulate the same sequence that mysqld follows for creating a table.(create a file, write some data into it, seek the next available position, and append some more data.).This program runs correctly, even when logged in as mysql. I was wondering if it could be a cross compilation issue...or If there is still some privilege/other issue that I have overlooked. Thanks in adavnce, Manasvini - Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more.
Re: mysql_install_db problem!!
manasvini nandakumar wrote: Hi all, I have cross compiled mysql-4.1.7 (from the source distribution)for an IXP425 based board with Montavista Linux-3.0.When I run mysql_install_db --user=mysql ...It runs into several errors with the following log [EMAIL PROTECTED]: /usr/local# ./bin/mysql_install_db --user=mysql WARNING: The host '192.168.10.231' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 1146 Table 'mysql.db' doesn't exist ERROR: 1146 Table 'mysql.db' doesn't exist ERROR: 3 Error writing file './mysql/host.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/user.frm' (Errcode: 2) -- The filesystem is NFS mounted.I am hoping someone can tell me why this is happenning and If I have missed out something. The mysql user cannot write to the database directory. It could be an NFS issue. Thanx in advance, Manasvini - Do you Yahoo!? Yahoo! Mail - You care about security. So do we. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql_install_db problem
The easy way around this is to change your hostname to 'localhost,' install the scripts, and then change your hostname back. There are other ways to fixing this, but that's the fastest, I've found. J.R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql_install_db problem
Have you verified that the mysql internal data bases don't exist? If you are running a Win binary, they should already exist. I don't even think mysql_install_db is part of the Win dist. It is a shell script used in UNIX installations. ~rob Sent: Monday, January 07, 2002 11:38 AM To: [EMAIL PROTECTED] Subject: mysql_install_db problem I am running mysql on windows 98 could not get the mysql_install_db to work. Anyone familar with this problem or know a way around? I checked the folder 'scripts' but did not see mysql_install_db in there ??? thanks in advance = Regards, Investorclb - 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: mysql_install_db problem
scripts/mysl_install_db --user=mysql Now that you have files and directories created under the wrong user, you can chown -R mysql /usr/local/mysql/var or whatever the data directory is on your system. Titus Purdin wrote: I am installing mysql-3.23.33-dec-osf5.1-alphaev6 on a DEC Alphastation running True64 Unix version 5.0A. Logged in as root, when I run scripts/mysql_install_db as part of the installation, it runs as far as % scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables and appears to hang. I let it run for several hours and it continued to use cycles, but was making no apparent progress. Insights appreciated. titus sends - 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
