Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysql-4.0.13-r3 and init script problem
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Portage & Programming
View previous topic :: View next topic  
Author Message
MistY
n00b
n00b


Joined: 03 Nov 2002
Posts: 39

PostPosted: Fri Jul 18, 2003 12:22 pm    Post subject: mysql-4.0.13-r3 and init script problem Reply with quote

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
View user's profile Send private message
Genone
Retired Dev
Retired Dev


Joined: 14 Mar 2003
Posts: 8993
Location: beyond the rim

PostPosted: Fri Jul 18, 2003 2:06 pm    Post subject: Reply with quote

http://bugs.gentoo.org is the right place.
Back to top
View user's profile Send private message
Brandy
Bodhisattva
Bodhisattva


Joined: 08 Jun 2003
Posts: 820
Location: New Zealand

PostPosted: Fri Jul 18, 2003 2:26 pm    Post subject: Reply with quote

Hi Misty.

It looks like you forgot to update your initscript. You need to run
Code:

etc-update

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
View user's profile Send private message
slartibartfasz
Veteran
Veteran


Joined: 29 Oct 2002
Posts: 1462
Location: vienna - austria

PostPosted: Fri Jul 18, 2003 2:29 pm    Post subject: Re: mysql-4.0.13-r3 and init script problem Reply with quote

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
View user's profile Send private message
MistY
n00b
n00b


Joined: 03 Nov 2002
Posts: 39

PostPosted: Fri Jul 18, 2003 2:30 pm    Post subject: Reply with quote

env-update doesn't change anything... maybe it's only specific to me...
Back to top
View user's profile Send private message
slartibartfasz
Veteran
Veteran


Joined: 29 Oct 2002
Posts: 1462
Location: vienna - austria

PostPosted: Fri Jul 18, 2003 2:32 pm    Post subject: Reply with quote

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
View user's profile Send private message
Deathwing00
Moderator
Moderator


Joined: 13 Jun 2003
Posts: 4078
Location: Barcelona, Spain

PostPosted: Mon Sep 15, 2003 10:55 am    Post subject: Reply with quote

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
View user's profile Send private message
Deathwing00
Moderator
Moderator


Joined: 13 Jun 2003
Posts: 4078
Location: Barcelona, Spain

PostPosted: Mon Sep 15, 2003 11:37 am    Post subject: Reply with quote

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
View user's profile Send private message
Deathwing00
Moderator
Moderator


Joined: 13 Jun 2003
Posts: 4078
Location: Barcelona, Spain

PostPosted: Mon Sep 15, 2003 7:02 pm    Post subject: Reply with quote

Help please! I cannot run prelude without this! :(
Back to top
View user's profile Send private message
ofeet
n00b
n00b


Joined: 19 Jul 2004
Posts: 61
Location: Utah

PostPosted: Tue Mar 21, 2006 5:19 pm    Post subject: mysql 4.1.x fix Reply with quote

[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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Portage & Programming All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum