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
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> <<>> >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> <<>> > >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
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> <<>> 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> <<>> 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
Ok Egor, here goes (not that it will give you any better information than I did already but since you asked...) <<>> 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 <<>> 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, 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
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
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 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
The group is not really important, as long as mysql owns the data directory and its contents. You can check /etc/group and see if you have a mysql group, or a group to which mysql is a member. Rance Hall wrote: > Folks: > > I think you are on the right track with that Gerald.. > > I deleted all the files in my data directory (they were just the ones > that mysql_install_db creates) and then ran mysql_install_db --user=mysql > > This time, nothing was created, no files, or anything, cant even find > an error message that would say why. > > So since I know that the server is running under safe_mysqld > --user=mysql it couldnt find the files cause under that account name > apparently they dont exist. > > The mysql user is part of what group, so I can chown the dir, and > start again? > > > Gerald Clark wrote > >> Does mysql own the mysql database directory, and all its files? >> >> You should have run it as >> mysql_install_db --user=mysql >> >> Rance Hall wrote: >> >>> >>> Hello all >>> >>> I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at >>> that computer now, so that could be wrong slighly) install pkg >>> >>> I have installed it, and I can get it to run with the >>> --skip-grant-tables option. >>> >>> When I try to run safe_mysqld without the skip option I get the >>> following error: Table 'mysql.host' doesn't exist >>> >>> Now, I ran the mysql_install_db script and it made a bunch of >>> databases including two called host.xxx >>> >>> Question, what is the proper syntax for a creation of the mysql.host >>> table so that I can create it and get past this error. >>> >>> If anyone else has any experience with this, could this be a bug in >>> the install_db script? >>> >>> Thanks for all your help >>> >>> Rance >> > > _ > Join the world's 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
server startup error on linux
Ok, I guess Im gonna have to do this again I have a Slackware 8.0 distro with the apache, php, and mysql install pkgs off of the cd I am logged in as root (not su'ed to root) and run the mysql_install_db script I run it with or without the --user=mysql qualifier in either case the databases are corrected, and the file permissions and ownership show that root owns all the database files with read and write access to the owner and the group. running safe_mysqld with or without the --user=mysql qualifier results in the same error "Table mysql.host doesnt exist" There are two tables created by the mysql_install_db script that are called host.xxx 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 Help. Rance _ 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
Folks: I think you are on the right track with that Gerald.. I deleted all the files in my data directory (they were just the ones that mysql_install_db creates) and then ran mysql_install_db --user=mysql This time, nothing was created, no files, or anything, cant even find an error message that would say why. So since I know that the server is running under safe_mysqld --user=mysql it couldnt find the files cause under that account name apparently they dont exist. The mysql user is part of what group, so I can chown the dir, and start again? Gerald Clark wrote >Does mysql own the mysql database directory, and all its files? > >You should have run it as >mysql_install_db --user=mysql > >Rance Hall wrote: > >> >>Hello all >> >>I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at >>that computer now, so that could be wrong slighly) install pkg >> >>I have installed it, and I can get it to run with the >>--skip-grant-tables option. >> >>When I try to run safe_mysqld without the skip option I get the >>following error: Table 'mysql.host' doesn't exist >> >>Now, I ran the mysql_install_db script and it made a bunch of >>databases including two called host.xxx >> >>Question, what is the proper syntax for a creation of the mysql.host >>table so that I can create it and get past this error. >> >>If anyone else has any experience with this, could this be a bug in >>the install_db script? >> >>Thanks for all your help >> >>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
Does mysql own the mysql database directory, and all its files? You should have run it as mysql_install_db --user=mysql Rance Hall wrote: > > Hello all > > I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at > that computer now, so that could be wrong slighly) install pkg > > I have installed it, and I can get it to run with the > --skip-grant-tables option. > > When I try to run safe_mysqld without the skip option I get the > following error: Table 'mysql.host' doesn't exist > > Now, I ran the mysql_install_db script and it made a bunch of > databases including two called host.xxx > > Question, what is the proper syntax for a creation of the mysql.host > table so that I can create it and get past this error. > > If anyone else has any experience with this, could this be a bug in > the install_db script? > > Thanks for all your help > > Rance > > > _ > Join the world's 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 > > - 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
server startup error
Hello all I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at that computer now, so that could be wrong slighly) install pkg I have installed it, and I can get it to run with the --skip-grant-tables option. When I try to run safe_mysqld without the skip option I get the following error: Table 'mysql.host' doesn't exist Now, I ran the mysql_install_db script and it made a bunch of databases including two called host.xxx Question, what is the proper syntax for a creation of the mysql.host table so that I can create it and get past this error. If anyone else has any experience with this, could this be a bug in the install_db script? Thanks for all your help 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