View previous topic :: View next topic |
Author |
Message |
MistY n00b
Joined: 03 Nov 2002 Posts: 39
|
Posted: Fri Jul 18, 2003 12:22 pm Post subject: mysql-4.0.13-r3 and init script problem |
|
|
Hello,
I don't know if I'm in the right place, but I've found a problem in the init script. It try to start "safe_mysqld", but there is only a "mysqld_safe" binary... Just replace it does the tricks.... |
|
Back to top |
|
|
Genone Retired Dev
Joined: 14 Mar 2003 Posts: 9526 Location: beyond the rim
|
|
Back to top |
|
|
Brandy Bodhisattva
Joined: 08 Jun 2003 Posts: 820 Location: New Zealand
|
Posted: Fri Jul 18, 2003 2:26 pm Post subject: |
|
|
Hi Misty.
It looks like you forgot to update your initscript. You need to run
Ciao, Brandy. _________________ Faber est suae quisque fortunae.
Last edited by Brandy on Fri Jul 18, 2003 2:29 pm; edited 1 time in total |
|
Back to top |
|
|
slartibartfasz Veteran
Joined: 29 Oct 2002 Posts: 1462 Location: Vienna, Austria
|
Posted: Fri Jul 18, 2003 2:29 pm Post subject: Re: mysql-4.0.13-r3 and init script problem |
|
|
MistY wrote: | I don't know if I'm in the right place, but I've found a problem in the init script. It try to start "safe_mysqld", but there is only a "mysqld_safe" binary... Just replace it does the tricks.... |
are u sure that u didnt acidentially keep the old configfile of the 3.x version. my init script points to the correct script...
the script was renamed from version 3.x to 4.x as stated here:
Quote: | `safe_mysqld' is renamed to `mysqld_safe'. For backward compatibility, binary distributions will for some time include safe_mysqld as a symlink to mysqld_safe. |
binary distributions - ha _________________ To an engineer the glass is neither half full, nor half empty - it is just twice as big as it needs to be. |
|
Back to top |
|
|
MistY n00b
Joined: 03 Nov 2002 Posts: 39
|
Posted: Fri Jul 18, 2003 2:30 pm Post subject: |
|
|
env-update doesn't change anything... maybe it's only specific to me... |
|
Back to top |
|
|
slartibartfasz Veteran
Joined: 29 Oct 2002 Posts: 1462 Location: Vienna, Austria
|
Posted: Fri Jul 18, 2003 2:32 pm Post subject: |
|
|
MistY wrote: | env-update doesn't change anything... maybe it's only specific to me... |
etc-update != env-update _________________ To an engineer the glass is neither half full, nor half empty - it is just twice as big as it needs to be. |
|
Back to top |
|
|
Deathwing00 Bodhisattva
Joined: 13 Jun 2003 Posts: 4087 Location: Dresden, Germany
|
Posted: Mon Sep 15, 2003 10:55 am Post subject: |
|
|
I followed each and any of the posts on the forum, but none solved the problem to me
· etc-update didn't do anything.
· root@BlackHat lib # /usr/bin/mysqld_safe --user=mysql
Code: | Starting mysqld daemon with databases from /var/lib/mysql
030915 12:50:17 mysqld ended
|
·mysqld.err
Code: | 030915 12:50:17 mysqld started
Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the $
030915 12:50:17 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.fr$
030915 12:50:17 Aborting
030915 12:50:17 /usr/sbin/mysqld: Shutdown Complete
030915 12:50:17 mysqld ended
|
· mysql.log & mysql.err are empy.
· root@BlackHat lib # ebuild /var/db/pkg/dev-db/mysql*/*.ebuild config
Code: | * Hmm, it appears as though you already have the mysql
* database in place. If you are having problems trying
* to start mysqld, perhaps you need to manually run
* /usr/bin/mysql_install_db and/or check your config
* file(s) and/or database(s) and/or logfile(s).
|
· root@BlackHat lib # dmesg | grep socket
Code: | Initializing RT netlink socket
NET4: Unix domain sockets 1.0/SMP for Linux NET4.0.
|
What am I supposed to do now??? Is my config file wrong? Am I missing anything? |
|
Back to top |
|
|
Deathwing00 Bodhisattva
Joined: 13 Jun 2003 Posts: 4087 Location: Dresden, Germany
|
Posted: Mon Sep 15, 2003 11:37 am Post subject: |
|
|
I got the daemon started doing this:
http://www.mysql.com/doc/en/mysql_install_db.html
Code: | mysqld crashes immediately
If you are running Red Hat Version 5.0 with a version of glibc older than 2.0.7-5, you should make sure you have installed all glibc patches. There is a lot of information about this in the MySQL mail archives. Links to the mail archives are available online at http://lists.mysql.com/. Also, see section 2.6.2 Linux Notes (All Linux Versions). You can also start mysqld manually using the --skip-grant-tables option and add the privilege information yourself using mysql:
shell> BINDIR/mysqld_safe --skip-grant-tables &
shell> BINDIR/mysql -u root mysql
From mysql, manually execute the SQL commands in mysql_install_db. Make sure you run mysqladmin flush-privileges or mysqladmin reload afterward to tell the server to reload the grant tables.
|
After that:
Code: | root@BlackHat bin # ./mysql_fix_privilege_tables
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func tables to MySQL 3.22.14 and above.
This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23
If you get 'Access denied' errors, you should run this script again
and give the MySQL root user password as an argument!
Converting all privilege tables to MyISAM format
ERROR 1017 at line 1: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 at line 2: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 at line 3: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 at line 4: Can't find file: './mysql/func.frm' (errno: 13)
ERROR 1017 at line 5: Can't find file: './mysql/columns_priv.frm' (errno: 13)
ERROR 1017 at line 6: Can't find file: './mysql/tables_priv.frm' (errno: 13)
If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name'. You can safely ignore these!
ERROR 1017 at line 1: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 at line 2: Can't find file: './mysql/user.frm' (errno: 13)
Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 1017 at line 1: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 at line 2: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 at line 3: Can't find file: './mysql/db.frm' (errno: 13)
Setting default privileges for the new grant, index and alter privileges
ERROR 1017 at line 1: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 at line 2: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 at line 3: Can't find file: './mysql/host.frm' (errno: 13)
Adding columns needed by GRANT .. REQUIRE (openssl)
You can ignore any Duplicate column errors
ERROR 1017 at line 1: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 at line 6: Can't find file: './mysql/user.frm' (errno: 13)
Creating the new table and column privilege tables
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any Unknown column errors from this
ERROR 1017 at line 1: Can't find file: './mysql/columns_priv.frm' (errno: 13)
Fixing the func table
You can ignore any Duplicate column errors
ERROR 1017 at line 1: Can't find file: './mysql/func.frm' (errno: 13)
Adding new fields used by MySQL 4.0.2 to the privilege tables
You can ignore any Duplicate column errors
ERROR 1017 at line 1: Can't find file: './mysql/user.frm' (errno: 13)
Updating new privileges in MySQL 4.0.2 from old ones
ERROR 1017 at line 1: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 at line 1: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 at line 1: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 at line 4: Can't find file: './mysql/host.frm' (errno: 13) |
Looks like the script 'mysql_install_db' does nothing |
|
Back to top |
|
|
Deathwing00 Bodhisattva
Joined: 13 Jun 2003 Posts: 4087 Location: Dresden, Germany
|
Posted: Mon Sep 15, 2003 7:02 pm Post subject: |
|
|
Help please! I cannot run prelude without this! |
|
Back to top |
|
|
ofeet n00b
Joined: 19 Jul 2004 Posts: 61 Location: Utah
|
Posted: Tue Mar 21, 2006 5:19 pm Post subject: mysql 4.1.x fix |
|
|
[NOTE* THIS IS A FIX]
when i updated to 4.1 a lot of stuff got screwed.
when I tried to connect i got the "could not connect to mysqld.sock (111)" yada yada.
Here's what I did to fix it...
# cd /var/lib/mysql
and then delete ib_logfileX (x being for how ever many there are wrong)
then shutdown mysql if you have it on (you might have to zap it) and then start it back up.
you can now connect with 'mysql --user=root -p'
The problem is that I uninstalled 4.0 and installed 4.1
in 4.0 the log file sizes where different. it's lame, but this caused problems in 4.1
anyway, hope this helped! _________________ I have nothing witty or brilliant to put here... /tear |
|
Back to top |
|
|
|