Mysql error when starting

**darkzero88** · 12-16-2009

Well i have had a server for about 2 months now, and im still finding out new stuff about it, so i started coding a lil php & JS, and i wanted to make a DB for it with mysql, anyway this is not the point :P. The point is that i get an error when i try starting my mysql services.

When i do

Code:

/etc/init.d/mysql start

this is the output i get

Code:

 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)
 * MySQL NOT started (0)                                                  [ !! ]

thanks for help, if you need anymore information from any files, just let me know, and ill post em asap ^_^

**gruven** · 12-16-2009

Code:

emerge --config mysql

Should fix your problem. You must configure your mysql server before you can start it.

It is explained more here:
Gentoo Linux Documentation -- MySQL Startup Guide

**darkzero88** · 12-16-2009

Here is the whole thing that happened

Code:

shadow-server ~ # emerge --config mysql
--- Invalid atom in /etc/portage/package.keywords: =net-analyzer/portsentry


Configuring pkg...

--- Invalid atom in /etc/portage/package.keywords: =net-analyzer/portsentry
 * You have already a MySQL database in place.
 * (///var/lib/mysql/*)
 * Please rename or delete it if you wish to replace it.
 *
 * ERROR: dev-db/mysql-5.0.84-r1 failed.
 * Call stack:
 *               ebuild.sh, line   49:  Called pkg_config
 *             environment, line 3881:  Called mysql_pkg_config
 *             environment, line 3535:  Called die
 * The specific snippet of code:
 *           die "MySQL database already exists!";
 *  The die message:
 *   MySQL database already exists!
 *
 * If you need support, post the topmost build error, and the call stack if relevant.
 * A complete build log is located at '/var/tmp/portage/dev-db/mysql-5.0.84-r1/temp/build.log'.
 * The ebuild environment file is located at '/var/tmp/portage/dev-db/mysql-5.0.84-r1/temp/environment'.
 * This ebuild is from an overlay named 'gentoo': '/var/db/pkg/'
 *

shadow-server ~ # cd /var/lib/mysql
shadow-server mysql # ls
ib_logfile0        mysqld-bin.000003  mysqld-bin.000009  mysqld-bin.000015
ib_logfile1        mysqld-bin.000004  mysqld-bin.000010  mysqld-bin.index
ibdata1            mysqld-bin.000005  mysqld-bin.000011  test
mysql              mysqld-bin.000006  mysqld-bin.000012
mysqld-bin.000001  mysqld-bin.000007  mysqld-bin.000013
mysqld-bin.000002  mysqld-bin.000008  mysqld-bin.000014
shadow-server mysql # rm mysql
rm: cannot remove `mysql': Is a directory
shadow-server mysql # rm -R mysql
shadow-server mysql # ls
ib_logfile0        mysqld-bin.000003  mysqld-bin.000008  mysqld-bin.000013
ib_logfile1        mysqld-bin.000004  mysqld-bin.000009  mysqld-bin.000014
ibdata1            mysqld-bin.000005  mysqld-bin.000010  mysqld-bin.000015
mysqld-bin.000001  mysqld-bin.000006  mysqld-bin.000011  mysqld-bin.index
mysqld-bin.000002  mysqld-bin.000007  mysqld-bin.000012  test
shadow-server mysql # emerge --config mysql
--- Invalid atom in /etc/portage/package.keywords: =net-analyzer/portsentry


Configuring pkg...

--- Invalid atom in /etc/portage/package.keywords: =net-analyzer/portsentry
 * Creating the mysql database and setting proper
 * permissions on it ...
 * Insert a password for the mysql 'root' user
 * Avoid ["'\_%] characters in the password
    >
 * Retype the password
    >
. * Loading "zoneinfo", this step may require a few seconds ...
 * Stopping the server ...
 * Done

shadow-server mysql # /etc/init.d/mysql start
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)
 * MySQL NOT started (0)                                                  [ !! ]

**gruven** · 12-16-2009

Ok then, let us see your

Code:

emerge --info

and

Code:

emerge -pv mysql

Also, I just noticed, since I don't actually run Gentoo (I use Funtoo), is this normal?

This ebuild is from an overlay named 'gentoo': '/var/db/pkg/'

**darkzero88** · 12-16-2009

Code:

# emerge --info
Portage 2.1.6.13 (default/linux/amd64/10.0, gcc-4.3.4, glibc-2.9_p20081201-r2, 2                                   .6.30-gentoo-r5 x86_64)
=================================================================
System uname: Linux-2.6.30-gentoo-r5-x86_64-AMD_Athlon-tm-_64_X2_Dual_Core_Proce                                   ssor_5200+-with-gentoo-1.12.13
Timestamp of tree: Sat, 21 Nov 2009 01:45:01 +0000
app-shells/bash:     4.0_p28
dev-java/java-config: 2.1.9-r1
dev-lang/python:     2.6.2-r1
sys-apps/baselayout: 1.12.13
sys-apps/sandbox:    1.6-r2
sys-devel/autoconf:  2.63-r1
sys-devel/automake:  1.9.6-r2, 1.10.2
sys-devel/binutils:  2.18-r3
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.2.6a
virtual/os-headers:  2.6.27-r2
ACCEPT_KEYWORDS="amd64"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/                                   fonts/fonts.conf /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/                                   ext-active/ /etc/php/cli-php5/ext-active/ /etc/sandbox.d /etc/terminfo /etc/udev                                   /rules.d"
CXXFLAGS="-O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks fixpackages parallel-fetch protect-owned sandbox sfperms str                                   ict unmerge-orphans userfetch"
GENTOO_MIRRORS="htt://distfiles.gentoo.org htt://distro.ibiblio.org/pub/linux/                                   distributions/gentoo"
LDFLAGS="-Wl,-O1"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress                                    --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclu                                   de=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="acl amd64 berkdb bzip2 cli cracklib crypt cups dri fortran gdbm gpm iconv i                                   pv6 mmx modules mudflap multilib mysql ncurses nls nptl nptlonly openmp pam pcre                                    perl php pppd python readline reflection samba session spl sse sse2 ssl sysfs t                                   cpd unicode vnc xorg zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x                                    ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 i                                   ntel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGI                                   NS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 iopl                                   ug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share s                                   hm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon aut                                   hn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_ho                                   st authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_c                                   ache env expires ext_filter file_cache filter headers include info log_config lo                                   gio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique                                   _id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse e                                   vdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm                                   001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="fbdev glint intel mach64 mg                                   a neomagic nv r128 radeon savage sis tdfx trident vesa vga via vmware voodoo"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_A                                   LL, LINGUAS, MAKEOPTS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_E                                   XTRA_OPTS, PORTDIR_OVERLAY

Code:

# emerge -pv mysql

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild   R   ] dev-db/mysql-5.0.84-r1  USE="berkdb community perl ssl -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal -profiling (-selinux) -static" 0 kB

Total: 1 package (1 reinstall), Size of downloads: 0 kB

 * IMPORTANT: 2 news items need reading for repository 'gentoo'.
 * Use eselect news to read news items.

and wtf is Funtoo ? =O XD

**gruven** · 12-17-2009

Funtoo is a fork of Gentoo by the original Gentoo creator, Daniel Robbins. It is more of a bleeding edge distro.

Now, since you are running Gentoo stable, and don't have crazy cflags, have you ran an etc-update since your last update? Have you ran revdep-rebuild since having the mysql problems? Have you ran an emerge --sync && emerge -avuDN world since installing mysql?

If you have done all of that, have you tried reinstalling mysql?

I have had the problem of mysql not starting before, but I don't exactly recall what it was that was causing it. I want to say use flags, but I really don't remember.

**darkzero88** · 12-17-2009

Well the thing is that mysql is like the third emerge i did after i got my server xD, and yes i tried re installing, i did the unmerge, unemerge, or wtf xD, but it worked, but how can i be sure EVERYTHING got removed? so there wasn't any files left?

And Funtoo sounds nice, so much different Linux sources :P

**gruven** · 12-17-2009

You need to install some portage utilities.

Code:

emerge gentoolkit

then, to make sure all of your linking is correct, run this:

Code:

revdep-rebuild -i

That will check all of your library dynamic linking and fix it should it find a problem.

**darkzero88** · 12-18-2009

Nope, still failed, the tool worked and all, but my mysql still wont start X_X

**gruven** · 12-18-2009

Ok, since I am not in linux right now, would you check /var/log and any subfolders to see if there is a mysql log, and if it has any errors in it?

If we can find why it isn't starting, I am sure we can fix it.

Thread Tools

Display

Mysql error when starting

Posting Permissions