Re: Server startup error on Linux
Rance, Saturday, March 23, 2002, 1:27:37 AM, you wrote: RH Egor: RH Yes, im sure that the host.xxx tables are in the directory I specified to RH the mysql_install_db script. RH One thing to note.. RH This is a software package for my distro... I did not compile from source so RH I dont know what options were used in the compile process. RH It may be that the server is unable to look in the dir where the files RH are... if this is the case then this would explain why the server cant find RH the host.xxx databases. RH I have tried to run safe_mysqld --datadir=/path/to/data RH but that doesnt help RH Do you think I should just uninstall the package, and download the sources RH and start over? RH Im at the end of my rope with this, Its just dumb to me that the server cant RH find something that I can find, even after I tell it where to look. RH There must be something more wrong that just a simple chown command, or file RH permissions or something like that. Rance, it's best to uninstall your MySQL server and install from scratch the binary package from http://www.mysql.com. RH Thoughts? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Server startup error on Linux
Rance, Thursday, March 21, 2002, 9:30:26 PM, you wrote: RH I issued the chown command as indicated by Andreas RH but it doesnt help RH I still get the Table mysql.hosts doesnt exist RH I know that all the tables created by mysql_install_db are infact owned by RH mysql RH but the server daemon still cant find them Give me complete output of the error message - show us the contents of the .err file RH what next? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Server startup error on Linux
Ok Egor, here goes (not that it will give you any better information than I did already but since you asked...) exerpt from .err file follows 020318 14:30:48 mysqld started 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 020318 14:30:49 mysqld ended exerpt from .err file ended because I have about 18 similar blocks in my .err file for each time I tried to start the server to see if I fixed the problem coping the entire .err file didnt make any sense. Again, this is after running the mysql_install_db and verifing that permissions to the files created by mysql_install_db are correct. --skip-grant-tables will allow the server to start, but a normal start is impossible Rance From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Server startup error on Linux Date: Fri, 22 Mar 2002 15:38:03 +0200 Rance, Thursday, March 21, 2002, 9:30:26 PM, you wrote: RH I issued the chown command as indicated by Andreas RH but it doesnt help RH I still get the Table mysql.hosts doesnt exist RH I know that all the tables created by mysql_install_db are infact owned by RH mysql RH but the server daemon still cant find them Give me complete output of the error message - show us the contents of the .err file RH what next? _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - 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: Server startup error on Linux
Rance, Friday, March 22, 2002, 4:53:41 PM, you wrote: RH here goes (not that it will give you any better information than I did RH already but since you asked...) RH exerpt from .err file follows RH 020318 14:30:48 mysqld started RH 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist RH 020318 14:30:49 mysqld ended RH exerpt from .err file ended RH because I have about 18 similar blocks in my .err file for each time I tried RH to start the server to see if I fixed the problem coping the entire .err RH file didnt make any sense. RH Again, this is after running the mysql_install_db and verifing that RH permissions to the files created by mysql_install_db are correct. RH --skip-grant-tables will allow the server to start, but a normal start is RH impossible Rance, are you sure that table 'host' really exists? Take a look at mysql datadir if there are the grant tables like 'host.frm', 'host.MYD', 'host.MYI'. RH Rance -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Server startup error on Linux
Egor: Yes, im sure that the host.xxx tables are in the directory I specified to the mysql_install_db script. One thing to note.. This is a software package for my distro... I did not compile from source so I dont know what options were used in the compile process. It may be that the server is unable to look in the dir where the files are... if this is the case then this would explain why the server cant find the host.xxx databases. I have tried to run safe_mysqld --datadir=/path/to/data but that doesnt help Do you think I should just uninstall the package, and download the sources and start over? Im at the end of my rope with this, Its just dumb to me that the server cant find something that I can find, even after I tell it where to look. There must be something more wrong that just a simple chown command, or file permissions or something like that. Just my opinion. Thoughts? From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Server startup error on Linux Date: Fri, 22 Mar 2002 20:32:00 +0200 Rance, Friday, March 22, 2002, 4:53:41 PM, you wrote: RH here goes (not that it will give you any better information than I did RH already but since you asked...) RH exerpt from .err file follows RH 020318 14:30:48 mysqld started RH 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist RH 020318 14:30:49 mysqld ended RH exerpt from .err file ended RH because I have about 18 similar blocks in my .err file for each time I tried RH to start the server to see if I fixed the problem coping the entire .err RH file didnt make any sense. RH Again, this is after running the mysql_install_db and verifing that RH permissions to the files created by mysql_install_db are correct. RH --skip-grant-tables will allow the server to start, but a normal start is RH impossible Rance, are you sure that table 'host' really exists? Take a look at mysql datadir if there are the grant tables like 'host.frm', 'host.MYD', 'host.MYI'. RH Rance _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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: server startup error on linux
I assume that the mysql daemon is looking for one of those owned by mysql. The server will start if I send the --skip-grant-tables option Who wants to run a database with no grant tables Find out where your databases are located. Think /var/db/mysql is the default. Go there and type: chown -Rf mysql:mysql * to change ownership of databases and tables. Note that mysql:mysql is user:group and if the mysql-user and/or group is different from 'mysql' you should change it. :wq //andreas http://phpwizard.dk (in Danish only) - 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: server startup error on linux
I assume that the mysql daemon is looking for one of those owned by mysql. The server will start if I send the --skip-grant-tables option Who wants to run a database with no grant tables Find out where your databases are located. Think /var/db/mysql is the default. Go there and type: chown -Rf mysql:mysql * to change ownership of databases and tables. Note that mysql:mysql is user:group and if the mysql-user and/or group is different from 'mysql' you should change it. :wq //andreas http://phpwizard.dk (in Danish only) sql, query - 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: Server startup error on Linux
I issued the chown command as indicated by Andreas but it doesnt help I still get the Table mysql.hosts doesnt exist I know that all the tables created by mysql_install_db are infact owned by mysql but the server daemon still cant find them what next? _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - 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