View previous topic :: View next topic |
Author |
Message |
TheNewb Apprentice
Joined: 10 Jun 2005 Posts: 183
|
Posted: Sun Aug 10, 2008 9:00 am Post subject: Mysql won't run... no error? [SOLVED] |
|
|
One of the most frustrating things... Mysql for some reason quit, but I can't get an error message other then (1).
This is all it gives me...
Code: |
richie ~ # /etc/init.d/mysql start
* Starting mysql ...
* Starting mysql (/etc/mysql/my.cnf)
* MySQL NOT started (1) [ !! ]
|
/var/log/mysql is no help either...
Code: |
richie ~ # ls /var/log/mysql/ -la
total 1
drwxr-x--- 2 mysql mysql 120 2008-08-10 01:51 .
drwxr-xr-x 19 root root 1032 2008-08-06 04:40 ..
-rw-r--r-- 1 mysql mysql 0 2008-08-10 01:49 .keep_dev-db_mysql-0
-rw-rw---- 1 mysql mysql 0 2008-08-10 01:49 mysql.log
|
Dmesg and /var/messages don't provide any help =(
Code: |
Aug 10 01:50:01 richie rc-scripts: MySQL NOT started (1)
Aug 10 01:51:18 richie rc-scripts: MySQL NOT started (1)
Aug 10 01:51:52 richie rc-scripts: MySQL NOT started (1)
Aug 10 01:52:05 richie rc-scripts: MySQL NOT started (1)
Aug 10 01:52:31 richie rc-scripts: MySQL NOT started (1)
|
Is there any advice to getting the server back online? Or at least finding out what the error is?
Code: |
~ # emerge --info
Portage 2.1.4.4 (default-linux/amd64/2006.1/desktop, gcc-4.1.2, glibc-2.7-r0, 2.6.23-gentoo x86_64)
=================================================================
System uname: 2.6.23-gentoo x86_64 AMD Athlon(tm) 64 X2 Dual Core Processor 4200+
Timestamp of tree: Sun, 10 Aug 2008 07:34:01 +0000
app-shells/bash: 3.2_p33
dev-java/java-config: 1.3.7, 2.0.33-r1
dev-lang/python: 2.4.4-r6, 2.5.2-r6
dev-python/pycrypto: 2.0.1-r6
sys-apps/baselayout: 1.12.9-r2
sys-apps/sandbox: 1.2.18.1-r2
sys-devel/autoconf: 2.13, 2.61-r2
sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10.1-r1
sys-devel/binutils: 2.18-r1
sys-devel/gcc-config: 1.3.16
sys-devel/libtool: 1.5.26
virtual/os-headers: 2.6.25-r4
ACCEPT_KEYWORDS="amd64"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -march=athlon64"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /opt/glftpd/etc /opt/glftpd/ftp-data /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config /var/qmail/alias /var/qmail/control /var/vpopmail/etc"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo /etc/texmf/web2c /etc/udev/rules.d"
CXXFLAGS="-O2 -march=athlon64"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks metadata-transfer parallel-fetch sandbox sfperms strict unmerge-orphans userfetch"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LANG="en_US.UTF-8"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="X a52 acl alsa amd64 anthy apache2 ares arts authdaemond autostart berkdb browserplugin cairo cal3d cav cdr cegui cg cgi cjk cli cracklib crypt ctype cups dba dbus dlloader doc dri dvd dvdr dvdread eds emboss emul-linux-x86 encode esd fam ffmpeg firefox fortran gd gdbm gif gimp-print glitz gnome gpm gstreamer gtk gtk2 hal howl iconv imap immqt-bc ipalias ipv6 isdnlog jgraph jpeg kde ldap mad maildir midi mikmod mozilla mp3 mpeg mssql mudflap mysql ncurses nls nocd nptl nptlonly nvidia ogg oggvorbis openal opengl openmp oss pam pcre pdf perl php png ppds pppd python qmail qmail-spp qt qt3 qt4 quicktime readline reflection samba sdl session slp spamassasin spamassassin spell spl sqlite ssl symlink tcpd tiff timidity tokenizer truetype unicode usb valias vhosts videos vorbis wxwindows xml xml2 xorg xscreensaver xv zlib" ALSA_CARDS="intel8x0" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="nvidia"
Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
|
_________________ #define struct union /* A Real space saver! */
Last edited by TheNewb on Sun Aug 10, 2008 3:33 pm; edited 1 time in total |
|
Back to top |
|
|
steveb Advocate
Joined: 18 Sep 2002 Posts: 4564
|
Posted: Sun Aug 10, 2008 11:43 am Post subject: |
|
|
What happens if you run: Code: | /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock |
// SteveB |
|
Back to top |
|
|
TheNewb Apprentice
Joined: 10 Jun 2005 Posts: 183
|
Posted: Sun Aug 10, 2008 3:32 pm Post subject: |
|
|
Quote: |
What happens if you run:
Code:
/usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
// SteveB
|
What happens... I get a meaningful error on exactly what's wrong....
And have the problem fixed 15 seconds later! Thank you!!!! _________________ #define struct union /* A Real space saver! */ |
|
Back to top |
|
|
steveb Advocate
Joined: 18 Sep 2002 Posts: 4564
|
Posted: Sun Aug 10, 2008 5:22 pm Post subject: |
|
|
TheNewb wrote: | What happens... I get a meaningful error on exactly what's wrong....
And have the problem fixed 15 seconds later! |
|
|
Back to top |
|
|
dstutz97 Tux's lil' helper
Joined: 14 Apr 2003 Posts: 80
|
Posted: Tue Mar 15, 2011 2:28 am Post subject: |
|
|
Thanks! |
|
Back to top |
|
|
|
|
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
|
|